ring c_field,c_value;
m_fields.GetWindowText(c_field);
m_value.GetWindowText(c_value);
if (c_field.IsEmpty()||(c_value.IsEmpty()))
{
MessageBox("请设置查询条件","提示",64);
return;
}
CString sql,c_starttime,c_endtime;
m_strtime.GetWindowText(c_starttime);
m_endtime.GetWindowText(c_endtime);
if (c_field.IsEmpty()||(c_value.IsEmpty()))
{
MessageBox("请设置查询条件","提示",64);
return;
}
m_list.DeleteAllItems();
switch (m_fields.GetCurSel())
{
case 0:
{
c_field = "bookname";
sql.Format("select a.bookname,a.barcode,a.author,a.bookconcern,a.price,b.numbers from tb_bookinfo a inner join (select barcode,sum(numbers) numbers from tb_cancelsell_sub where sellcancelid in (select sellcancelid from tb_cancelsell_main where intime between '%s' and '%s') group by barcode)as b on a.barcode = b.barcode and a.bookname = '%s' order by b.numbers desc",c_starttime,c_endtime, c_value);
break;
}
case 1:
{
c_field = "barcode";
sql.Format("select a.bookname,a.barcode,a.author,a.bookconcern,a.price,b.numbers from tb_bookinfo a inner join (select barcode,sum(numbers) numbers from tb_cancelsell_sub where sellcancelid in (select sellcancelid from tb_cancelsell_main where intime between '%s' and '%s') group by barcode)as b on a.barcode = b.barcode and a.barcode = '%s' order by b.numbers desc",c_starttime,c_endtime, c_value);
break;
}
case 2:
{
c_field = "author";
sql.Format("select a.bookname,a.barcode,a.author,a.bookconcern,a.price,b.numbers from tb_bookinfo a inner join (select barcode,sum(numbers) numbers from tb_cancelsell_sub where sellcancelid in (select sellcancelid from tb_cancelsell_main where intime between '%s' and '%s') group by barcode)as b on a.barcode = b.barcode and a.author = '%s' order by b.numbers desc",c_starttime,c_endtime,
上一篇:
DlgSaleBack2.cpp
下一篇:
"夜"