Example #1
0
SqlStatement Database::CreateStatement(SqlStatementID& index, const char* fmt)
{
    int nId = -1;
    //check if statement ID is initialized
    if (!index.initialized())
    {
        //convert to lower register
        std::string szFmt(fmt);
        //count input parameters
        int nParams = std::count(szFmt.begin(), szFmt.end(), '?');
        //find existing or add a new record in registry
        LOCK_GUARD _guard(m_stmtGuard);
        PreparedStmtRegistry::const_iterator iter = m_stmtRegistry.find(szFmt);
        if (iter == m_stmtRegistry.end())
        {
            nId = ++m_iStmtIndex;
            m_stmtRegistry[szFmt] = nId;
        }
        else
            nId = iter->second;

        //save initialized statement index info
        index.init(nId, nParams);
    }

    return SqlStatement(index, *this);
}
Example #2
0
void KviWindow::output(int iMsgType, const QDateTime & datetime, const char * pcFormat, ...)
{
	QString szFmt(pcFormat);
	kvi_va_list l;
	kvi_va_start(l, pcFormat);
	QString szBuf;
	KviQString::vsprintf(szBuf, szFmt, l);
	kvi_va_end(l);
	preprocessMessage(szBuf);
	const QChar * pC = szBuf.constData();
	if(!pC)
		return;
	internalOutput(m_pIrcView, iMsgType, (kvi_wchar_t *)pC, 0, datetime);
}
void CSpecReporter::OnBnClickedOk()
{
	UpdateData();
	ostringstream szFmt("");
	vector<string> vtSz;

	vtSz.push_back( szProName ); //存储过程名
	
	vtSz.push_back((LPCSTR)m_szStart);
	vtSz.push_back((LPCSTR)m_szEnd);

	szFmt<<vtType[m_cbType.GetCurSel()] ;
	vtSz.push_back(szFmt.str() );

	CString str;
	m_cbYear.GetLBText(m_cbYear.GetCurSel(),str);
	vtSz.push_back( (LPCSTR)str);


	string szRet;

	CComFunc::callSqlPro(vtSz,szRet);

	if( szRet.compare(SZERROR) )
	{
			AfxMessageBox("完成功能");
		
	} 
	else AfxMessageBox("调用存储功能失败");
	//_CommandPtr cmd;
	//_ParameterPtr par;
	//cmd.CreateInstance(__uuidof( Command ));
	//par.CreateInstance(__uuidof( Parameter));

	//_variant_t vNULL;
	//vNULL.vt = VT_ERROR;
	//vNULL.scode = DISP_E_PARAMNOTFOUND;
	//try{
	//	cmd->put_CommandType(adCmdStoredProc) ;
	//	//开始期号
	//	par=cmd->CreateParameter(_bstr_t("start_issn"),adInteger,adParamInput,4,atol(m_szStart));
	//	cmd->Parameters->Append( par );
	//	//终止期号
	//	par=cmd->CreateParameter(_bstr_t("end_issn"),adInteger,adParamInput,4,atol(m_szEnd));
	//	cmd->Parameters->Append( par );
	//	//期刊类别
	//	par=cmd->CreateParameter(_bstr_t("type_issn"),adInteger,adParamInput,4,vtType[m_cbType.GetCurSel()] );
	//	cmd->Parameters->Append( par );
	//	//特约通讯员所属年度
	//	CString str;
	//	m_cbYear.GetLBText(m_cbYear.GetCurSel(),str);
	//	par=cmd->CreateParameter(_bstr_t("year"),adInteger,adParamInput,4,atol(str) );
	//	cmd->Parameters->Append( par );
	//
	///*	par=cmd->CreateParameter(_bstr_t("ret"),adInteger,adParamOutput,0,vNULL);
	//	cmd->Parameters->Append( par);*/

	//	cmd->put_CommandText(_bstr_t("prc_compute_reporter"));
	//	cmd->ActiveConnection=HospitalConnect;
	//	cmd->Execute(NULL,NULL,adCmdStoredProc);
	//	
	////	succ=(long)cmd->Parameters->GetItem("ret")->Value;

	//	cmd.Detach();
	//	par.Detach();
	//}
	//catch(_com_error e)
	//{
	//	AfxMessageBox(e.ErrorMessage());
	//	return;
	//}	
	//
	//AfxMessageBox("成功执行特约通讯员翻番补助操作");

}