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);
}
