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