lid";
sql.Format("select a.stockname,a.merchandiseID,b.name,a.unitPrice,a.numbers,a.rebate,a.paymoney,c.operator,a.cancelid from tb_cancelinstock_sub a inner join tb_merchandiseinfo b on a.merchandiseID = b.id inner join tb_cancelinstock_main c on a.cancelid = c.cancelid and a.%s = '%s' and c.intime between '%s' and '%s' ",c_field,c_value,c_starttime,c_endtime);
break;
}
case 1:
{
c_field = "provider";
sql.Format("select a.stockname,a.merchandiseID,b.name,a.unitPrice,a.numbers,a.rebate,a.paymoney,c.operator,a.cancelid from tb_cancelinstock_sub a inner join tb_merchandiseinfo b on a.merchandiseID = b.id inner join tb_cancelinstock_main c on a.cancelid = c.cancelid and c.%s = '%s' and c.intime between '%s' and '%s' ",c_field,c_value,c_starttime,c_endtime);
break;
}
case 2:
{
c_field = "operator";
sql.Format("select a.stockname,a.merchandiseID,b.name,a.unitPrice,a.numbers,a.rebate,a.paymoney,c.operator,a.cancelid from tb_cancelinstock_sub a inner join tb_merchandiseinfo b on a.merchandiseID = b.id inner join tb_cancelinstock_main c on a.cancelid = c.cancelid and c.%s = '%s' and c.intime between '%s' and '%s' ",c_field,c_value,c_starttime,c_endtime);
break;
}
case 3:
{
c_field = "name" ;
sql.Format("select a.stockname,a.merchandiseID,b.name,a.unitPrice,a.numbers,a.rebate,a.paymoney,c.operator,a.cancelid from tb_cancelinstock_sub a inner join tb_merchandiseinfo b on a.merchandiseID = b.id inner join tb_cancelinstock_main c on a.cancelid = c.cancelid and b.%s = '%s' and c.intime between '%s' and '%s' ",c_field,c_value,c_starttime,c_endtime);
break;
}
}
m_pRs->Close();
m_pRs->Open((_variant_t)sql,m_pCon.GetInterfacePtr(),adOpenKeyset,adLockOptimistic,adCmdText);
int row = 0;
while (! m_pRs->adoEOF)
{
CString temp;
list.InsertItem(100,"");
for (int i = 0;i<9;i++)
{
temp = (TCHAR *)(_bstr_t)m_pRs->GetFields()->GetIt
上一篇：
frmcbz.frm
下一篇：
超市进销存管理系统的开发
2013-9-1
