摘要:
使用sql语句查询日期在一周内的数据select * from ShopOrder where datediff(week,ordTime,getdate()-1)=0 //查询当天日期在一周年的数据select * from ShopOrder where datediff(day,ordTime... 阅读全文
摘要:
select Category,REPLACE(sum(Amount),'-','') as Amountfrom T_Detail WHERE CREATED_BY='6123EC14-50E2-4D4A-AACA-6A9578AAFDBB'group by Category说明:Amount中的... 阅读全文
摘要:
select Category from(select distinct Category from T_Detail where CREATED_BY= @CREATED_BY AND RecordDate>=@RecordDate1 AND RecordDate<@RecordDate2)t g... 阅读全文
摘要:
lblWeekStart.Content = DateTime.Now.AddDays(Convert.ToDouble((0 - Convert.ToInt16(DateTime.Now.DayOfWeek)))).ToShortDateString(); lblWeekEnd.Content ... 阅读全文