解决方案 »
- 请教大家,如何取得 StringBuilder text 中text中的值呢?
- C#的SerialPort 跟串口工具打开的串口的区别
- 我用的ewebeditor的文本编辑器,在我本机上传图片没问题,可是把站点挪到服务器就不能上传了?
- 一个关于相互调用、传值问题
- 新手求救!!!!!!!
- .NET程序员(C# + SQL Server) 3名
- 还是socket问题....异步发送数据出现问题,急救!!!
- 请问C#中如何调用VFP带返回值的存储过程?
- 求软件架构和软件开管理方面的面试题
- 大俠們,拷貝到你的機器上幫我調試一下﹐我實在找不到原因了。
- 不同的字符串要生成不同的整数,不能重复,变成一个唯一的整数标识?
- 是不是所有的windows都有IE,如果有,我下面的代码就不用try,catch了吧
select * from fee order by fee_id desc union all select * from fee order by fee_id desc union all select * from fee order by fee_id desc
SQL中可以用Union
或者直接Merge
sql_str = "select car_fee_id as 交易流水号 ,car_fee_nums as 会员卡号,car_fee_start as 停车时间,car_fee_end as 离开时间,car_fee_must_money as 应收费,car_fee_all_money as 实收费,car_fee_times as 停车时长,car_fee_free_money as 免除,car_fee_sd_money as 水单减免,car_fee_car_id as 车牌号,car_fee_user as 收费人,(case car_fee_flag when 1 then '停车中' when 2 then '已离开' end) as 卡状态 ,(case car_fee_card_type when 0 then '临时卡' when 4 then '会员卡' when 12 then '金卡' when 72 then '内部员工卡' when 5 then '宝宝卡' end) as 卡类别,car_fee_c_nums as 换卡号,(case car_fee_c_card_type when 0 then '临时卡' when 4 then '会员卡' when 12 then '金卡' when 72 then '内部员工卡' when 5 then '宝宝卡' end) as 换卡类别,car_fee_recepice_start as 收据起始号,car_fee_recepice_end as 收据结束号,car_fee_re as 备注,car_fee_mmc as 使用中影卡 from car_park_fee where car_fee_start between '" + d_start + "'and '" + d_end + "' and car_fee_flag = 2 order by car_fee_id desc union all select sum(car_fee_must_money),sum(car_fee_all_money),sum(car_fee_times),sum(car_fee_free_money),sum(car_fee_sd_money) from car_park_fee where car_fee_start between '" + d_start + "'and '" + d_end + "' and car_fee_flag = 2 ";