34,594
社区成员
发帖
与我相关
我的任务
分享
select '商品信息' as 商品结算,商品简称,结算状态,sum(运费) 运费,货运结算日期,sum(订购数量) 订购数量 from 商品资料 where 货运结算日期 between'" + dateTimePicker1.Value.Date + "'and '" + dateTimePicker2.Value.Date + "' and " + comboBox1.Text + " like '%" + this.comboBox2.Text + "%' group by 商品简称,结算状态,运费,货运结算日期,订购数量 union select '合计' as 商品结算,'','',sum(运费) 运费,getdate(),sum(订购数量) 订购数量 from 商品资料 where 货运结算日期 between'" + dateTimePicker1.Value.Date + "'and '" + dateTimePicker2.Value.Date + "' and " + comboBox1.Text + " like '%" + this.comboBox2.Text + "%' order by 货运结算日期
exec
('select ''商品信息'' as 商品结算,商品简称,结算状态,sum(运费) 运费,货运结算日期,sum(订购数量) 订购数量
from 商品资料 where 货运结算日期 between'" + dateTimePicker1.Value.Date + "'and '" + dateTimePicker2.Value.Date + "'
and " + comboBox1.Text + " like '%" + this.comboBox2.Text + "%'
group by 商品简称,结算状态,货运结算日期
union
select ''合计'' as 商品结算,'','',sum(运费) 运费,getdate(),sum(订购数量) 订购数量
from 商品资料 where 货运结算日期 between'" + dateTimePicker1.Value.Date + "'and '" + dateTimePicker2.Value.Date + "'
and " + comboBox1.Text + " like '%" + this.comboBox2.Text + "%'
order by 货运结算日期')
select
'商品信息' as 商品结算,商品简称,结算状态,
sum(运费) 运费,货运结算日期,sum(订购数量) 订购数量
from
商品资料
where
货运结算日期 between'" + dateTimePicker1.Value.Date + "'and '" + dateTimePicker2.Value.Date + "'
and
" + comboBox1.Text + " like '%" + this.comboBox2.Text + "%'
group by
商品简称,结算状态,运费,货运结算日期,订购数量
union
select
'合计' as 商品结算,'','',sum(运费) 运费,getdate(),sum(订购数量) 订购数量
from
商品资料
where
货运结算日期 between'" + dateTimePicker1.Value.Date + "'
and
'" + dateTimePicker2.Value.Date + "'
and
" + comboBox1.Text + " like '%" + this.comboBox2.Text + "%'
order by
货运结算日期