cmd.CommandText="Select Distinct numbers,jodate,eveidname,submiteridname,sum(amount) As [totalamount],case when cheks = 1 then count(cheks) else '0' end as [已审核],case when cheks = 0 then count(cheks) else '0' end as [未审核] ,count(numbers) As [rowcount] Fr om {pm0102} Group By numbers,cheks,jodate,eveidname,submiteridname"
加好友 
发短信
Post By：2018/12/14 22:31:00 [只看该作者]
