Exemple #1
0
        public ActionResult GetSaleDepotCountByMtoth1()
        {
            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(SaleDepotDAL.FindByYCount(d, 1));
            }
            return(Json(dts));
        }
Exemple #2
0
        /// <summary>
        /// 查询所有的出库数据
        /// </summary>
        /// <returns></returns>
        public ActionResult StockOut()
        {
            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 = SaleDepotDAL.FindByYCount(d, 0) + SaleDepotDAL.FindByYCount(d, 1);             //销售出库数
                int      sr = ProduceOutDepotDAL.FindByYCount(d, 0) + ProduceOutDepotDAL.FindByYCount(d, 1); //生产领料数
                int      qr = OtherOutDepotDAL.FindByYCount(d);                                              //其它出库
                int      st = StockReturnDAL.FindByYCount(d, 0) + StockReturnDAL.FindByYCount(d, 1);         //采购退货
                dts.Add(cr + sr + qr + st);
            }
            return(Json(dts));
        }