public ActionResult GetProduceInDepotStateCount() { List <int> list = new List <int>(); list.Add(ProduceInDepotDAL.FindStateCount(0)); list.Add(ProduceInDepotDAL.FindStateCount(1)); return(Json(list)); }
public ActionResult GetProduceInDepotCountByMtoth1() { 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(ProduceInDepotDAL.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)); }
/// <summary> /// 条件查询 /// </summary> /// <param name="PIDID"></param> /// <param name="DepotID"></param> /// <param name="PIDDate"></param> /// <param name="UsersName"></param> /// <param name="PIDState"></param> /// <param name="PageIndex"></param> /// <param name="PageSize"></param> /// <param name="count"></param> /// <returns></returns> public static List <ProduceInDepot> Find(string PIDID, string DepotID, string PIDDate, string UsersName, int PIDState, int PageIndex, int PageSize, out int count) { return(ProduceInDepotDAL.Find(PIDID, DepotID, PIDDate, UsersName, PIDState, PageIndex, 10, out count)); }
/// <summary> /// 审核采购订单 /// </summary> /// <param name="id"></param> /// <returns></returns> public static int CKProduceInDepot(string id, int userid) { return(ProduceInDepotDAL.CKProduceInDepot(id, userid)); }
/// <summary> /// 根据ID查询采购单信息 /// </summary> /// <param name="id"></param> /// <returns></returns> internal static ProduceInDepot GetByID(string id) { return(ProduceInDepotDAL.GetByID(id)); }
/// <summary> /// 修改【---事务---】 /// </summary> /// <param name="dp"></param> /// <returns></returns> public static int EdiStocks(ProduceInDepot dep, List <ProduceInDepotDeteil> list) { return(ProduceInDepotDAL.EdiStocks(dep, list)); }
/// <summary> /// 删除 /// </summary> /// <param name="id"></param> /// <returns></returns> public static int DelStocks(string id) { return(ProduceInDepotDAL.DelStocks(id)); }
/// <summary> /// 分页查询 /// </summary> /// <param name="PageIndex"></param> /// <param name="PageSize"></param> /// <returns></returns> public static List <ProduceInDepot> GetAllPage(int PageIndex, int PageSize) { return(ProduceInDepotDAL.GetAllPage(PageIndex, PageSize)); }
/// <summary> /// 查询所有 /// </summary> /// <returns></returns> public static List <ProduceInDepot> GetAll() { return(ProduceInDepotDAL.GetAll()); }