一个参数就够了:
CString strNYD="20041001";
CString strSQL;
strSQL.Format("Select DanHao "
" FROM Table1 WHERE "
" NianYueDay=%s And (FenLei='1' And HaveGetState='0' And ShuLiang>0 "
"Or FenLei='1' And TuiKuanBiaoZhi='1' "
"Or FenLei='0' And (HaveGetState='0' or TuiKuanBiaoZhi='1') "
"Or FenLei='7' And (HaveGetState='0' or TuiKuanBiaoZhi='1') "
"Or FenLei='6' And (HaveGetState='0' And ShuLiang>0 or TuiKuanBiaoZhi='1')) "
"Group by DanHao Order by DanHao",
strNYD)
CString strNYD="20041001";
CString strSQL;
strSQL.Format("Select DanHao "
" FROM Table1 WHERE "
" NianYueDay=%s And (FenLei='1' And HaveGetState='0' And ShuLiang>0 "
"Or FenLei='1' And TuiKuanBiaoZhi='1' "
"Or FenLei='0' And (HaveGetState='0' or TuiKuanBiaoZhi='1') "
"Or FenLei='7' And (HaveGetState='0' or TuiKuanBiaoZhi='1') "
"Or FenLei='6' And (HaveGetState='0' And ShuLiang>0 or TuiKuanBiaoZhi='1')) "
"Group by DanHao Order by DanHao",
strNYD)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货