BOOL CADOHandle::CapLogin(CString strUser,CString strPass,CString strNodeID,CString &strUserID,CString &strResult,CString &strNodeName,
CString &strSxtCount,CString &strSxtIDList,CString &strSxtNameList,CString &strAddressList,
CString &strVersion,CString &strVerType ,CString &strWinIDList)
{
int res = 0;
CADOParameter pParamUser(CADORecordset::typeBSTR, sizeof(char) * 50);
CADOParameter pParamPass(CADORecordset::typeBSTR, sizeof(char) * 50);
pParamUser.SetValue(strUser);
pParamPass.SetValue(strPass);
CADOCommand pCmd(&m_nAdoDatebase, "SZY_B_Login");//这里挂了,
pCmd.AddParameter(&pParamUser);
pCmd.AddParameter(&pParamPass);
CADORecordset* prs = new CADORecordset(&m_nAdoDatebase);
if(prs->Execute(&pCmd))
{
prs->GetFieldValue("ReturnValue",res);
strResult.Format("%d",res);
if(res == 1)
{
prs->GetFieldValue("Club_id",strUserID);
CleanSQLStr(strUserID);
}
}
else
{
m_nAdoDatebase.Close();
m_nAdoDatebase.SetConnectionString(m_strConnect);
m_nAdoDatebase.Open();
}
if (res == 1 && !strNodeID.Trim().IsEmpty() && !strUserID.IsEmpty())
{
CapGetNodeInfo(strNodeID,strUserID,strNodeName,strSxtCount,strVersion,strVerType);
SetNodeActive(strNodeID,TRUE);
if (atoi(strSxtCount) > 0)
CapGetCameraInfo(strNodeID,strUserID,strSxtIDList,strSxtNameList,strAddressList,strWinIDList);
}
delete prs;
return res;
}CADOCommand::CADOCommand(CADODatabase* pAdoDatabase, CString strCommandText, int nCommandType)
{
m_pCommand = NULL;
m_pCommand.CreateInstance(__uuidof(Command));
m_strCommandText = strCommandText;
m_pCommand->CommandText = m_strCommandText.AllocSysString();
m_nCommandType = nCommandType;
m_pCommand->CommandType = (CommandTypeEnum)m_nCommandType;
m_pCommand->ActiveConnection = pAdoDatabase->GetActiveConnection();//ado2.cpp断点
m_nRecordsAffected = 0;
}
//msado15.tli断点
inline void Command15::PutRefActiveConnection ( struct _Connection * ppvObject ) {
HRESULT _hr = putref_ActiveConnection(ppvObject);
if (FAILED(_hr)) _com_issue_errorex(_hr, this, __uuidof(this));
}
解决方案 »
- 笔段LED类实现倒计时显示,无法刷新重画?
- COleVariant的一个小问题,都来看看。
- 我想在自己的程序里调用一个Dos程序(xxx.exe)并获取它的输出,请高人指点!
- Bmp图象处理
- Microsoft Visual C++ Debug Library的问题?
- 问一个关于任务管理器的小问题 潜心研究PDF,请进来
- 用tcp协议 时 服务端要先建立一个套接字 然后监听,等待连接,但连接后为什么要新创建一个套接字啊
- vc6中有没有word的接口?
- 我是一个菜鸟,想请教一下怎么用CstdioFIle函数处理大量数据
- 我有一个用hook截获鼠标移动的dll,但是没有效果,请问怎么调试?
- 为什么无法在其他线程调用CWnd::OnPaint,但是invalidate可以用
- 单文档视图分割问题
try
{
//你的ADO代码
}
catch (_com_error& e)
{
AfxMessageBox(e.Description());
}
http://blog.csdn.net/xianglitian/article/details/5617173