/// <summary> /// 查询近12个月的已审核采购入库单个数 /// </summary> /// <returns></returns> public ActionResult GetStockInDepotCountByMtoth1() { List <int> dts = new List <int>(); DateTime dt = DateTime.Now.AddYears(-1); for (int i = 1; i <= 12; i++) { DateTime d = dt.AddMonths(i); dts.Add(StockInDepotDAL.FindByYCount(d, 1)); } return(Json(dts)); }
/// <summary> /// 查询所有的入库数据 /// </summary> /// <returns></returns> public ActionResult StockIn() { List <int> dts = new List <int>(); DateTime dt = DateTime.Now.AddYears(-1); for (int i = 1; i <= 12; i++) { DateTime d = dt.AddMonths(i); int cr = StockInDepotDAL.FindByYCount(d, 0) + StockInDepotDAL.FindByYCount(d, 1); //采购入库数 int sr = ProduceInDepotDAL.FindByYCount(d, 0) + ProduceInDepotDAL.FindByYCount(d, 1); //生产入库 int qr = OtherInDepotDAL.FindByYCount(d); //其它入库 int st = SaleReturnDAL.FindByYCount(d, 0) + SaleReturnDAL.FindByYCount(d, 1); //销售退货 dts.Add(cr + sr + qr + st); } return(Json(dts)); }