摘要:
DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("timestep", Type.GetType("System.Int32"))); for (int i = 1; i <= 24; i++) { DataRow dr = dt.NewRow(); dr["timestep"] = i; dt.Rows.Add(dr); } 阅读全文
摘要:
select dateadd(mi,(datediff(mi,convert(varchar(10),dateadd(ss,-1,CreateOn),120),dateadd(ss,-1,CreateOn))/5)*5,convert(varchar(10),CreateOn,120)) as CreateOnss, count(*) as cnt, MAX(CreateOn),sum(OrderAmt) as OrderAmtdd from SaleOrder where OrderStatus>0 and OrderStatus='2014-01-02' and Cr 阅读全文