摘要:
判断datatable指定列是否重复 var query = from t in dtTemp.AsEnumerable() group t by new { t1 = t.Field<string>("StartTime"), t2 = t.Field<string>("EndTime"), t3 阅读全文
摘要:
select convert(varchar(50),datepart(year,InTime)) +'-'+convert(varchar(50),datepart(month,InTime)) as month ,count(1) as Qty,SiteID from FineDtl group 阅读全文