/// <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 <OtherInDepot> Find(string OIDID, string DepotID, string OIDDate, string UsersName, int OIDState, int PageIndex, int PageSize, out int count) { return(OtherInDepotDAL.Find(OIDID, DepotID, OIDDate, UsersName, OIDState, PageIndex, PageSize, out count)); }
/// <summary> /// 审核采购订单 /// </summary> /// <param name="id"></param> /// <returns></returns> public static int CKInDepot(string id, int userid) { return(OtherInDepotDAL.CKInDepot(id, userid)); }
/// <summary> /// 根据ID查询采购单信息 /// </summary> /// <param name="id"></param> /// <returns></returns> internal static OtherInDepot GetByID(string id) { return(OtherInDepotDAL.GetByID(id)); }
/// <summary> /// 修改【---事务---】 /// </summary> /// <param name="dp"></param> /// <returns></returns> public static int EdiStocks(OtherInDepot dep, List <OtherInDepotDetail> list) { return(OtherInDepotDAL.EdiStocks(dep, list)); }
/// <summary> /// 删除 /// </summary> /// <param name="id"></param> /// <returns></returns> public static int DelStocks(string id) { return(OtherInDepotDAL.DelStocks(id)); }
/// <summary> /// 查询所有 /// </summary> /// <returns></returns> public static List <OtherInDepot> GetAll() { return(OtherInDepotDAL.GetAll()); }