貌似点BTN触发不了 。
求教下。
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 货运结算日期
'商品信息' 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 货运结算日期')要用动态SQL and " + comboBox1.Text + " like '%" + this.comboBox2.Text + "%'还有第一句,你都要统计运费还要用运费来GROUP BY ?晕
需要拼接成一个完成的SQL语句,然后执行之.不同的开发语言,使用方法不同.
s = '你的拼接语句'然后用命令执行上面的s.(不同的语言执行方法不同.)
up....用动态SQL来执行这段代码...