string sql1="select '百货MIS' as 分类,count(*) as 笔数, sum(jyje)as 交易金额,sum(sxf)as 手续费,sum(jsje) as 结算金额,'"+this.txt_date.Text.ToString()+"' as 清算日期 from dbo.CardPOS_Detail where qsrq='"+this.txt_date.Text.ToString()+"' and ((zdh>=32112000 and zdh <=32112080) or(zdh>=32112081 and zdh <=32112099) or((zdh>=32112237 and zdh <=32112241) or (zdh>=32112243 and zdh <=32112250)))"; 可以把它合成一句,就是条件不一样嘛!
string sql1="select '百货MIS' as 分类,count(*) as 笔数, sum(jyje)as 交易金额,sum(sxf)as 手续费,sum(jsje) as 结算金额,'"+this.txt_date.Text.ToString()+"' as 清算日期 from dbo.CardPOS_Detail where qsrq='"+this.txt_date.Text.ToString()+"' and ((zdh>=32112000 and zdh <=32112080) or(zdh>=32112081 and zdh <=32112099) or((zdh>=32112237 and zdh <=32112241) or (zdh>=32112243 and zdh <=32112250)))"; 可以把它合成一句,就是条件不一样嘛!
话说, 如果是条件相同, 请勿使用union all 连接, 会影响读取效率