public CommonRtnEntity Delete([FromBody] object [] ids) { IBuyOrderInfoServices services = new BuyOrderInfoServices(); bool result = services.DeleteByIds(ids); if (result) { //删除订单也需要删除商品 WareInfoServices wareServices = new WareInfoServices(); List <string> orderIDList = new List <string>(); for (int i = 0; i < ids.Length; i++) { orderIDList.Add(ids[i] + ""); } wareServices.DeleteByOrderID(orderIDList); } CommonRtnEntity rtnInfo = new CommonRtnEntity() { Success = result, Data = result, Message = result ? "删除成功!":"删除失败" }; return(rtnInfo); }
public CommonRtnEntity GetSaleWareSituation([FromBody] SearchBase <BuyOrderSearch> searchInfo) { IWareInfoServices services = new WareInfoServices(); DateTime start = DateTime.Parse(DateTime.Now.AddDays(-15).ToString("yyyy-MM-dd")); DateTime end = DateTime.Parse(DateTime.Now.AddDays(1).ToString("yyyy-MM-dd")); List <WareInfo> list = services.Query("[OrderID] in (select b.ID from BuyOrderInfo as b where b.OrderType='SO' and b.CreateTime>='" + start.ToString("yyyy-MM-dd") + "' and b.CreateTime<='" + end.ToString("yyyy-MM-dd") + "')"); List <string> wareNameList = new List <string>(); IEnumerable <IGrouping <string, WareInfo> > query = list.GroupBy(pet => pet.Name, pet => pet); List <Object> dataList = new List <object>(); foreach (var item in query) { wareNameList.Add(item.Key); dataList.Add( new { value = item.ToList().Sum(x => x.TotalMoney), name = item.Key, } ); } CommonRtnEntity rtnInfo = new CommonRtnEntity() { Success = list.Count > 0, Data = new { WareNameList = wareNameList, DataList = dataList }, Message = "查询成功!" }; return(rtnInfo); }