/// <summary> /// 查询采购单审核数和未审核数 /// </summary> /// <returns></returns> public ActionResult GetStocksStateCount() { List <int> list = new List <int>(); list.Add(StocksDAL.FindStateCount(0)); list.Add(StocksDAL.FindStateCount(1)); return(Json(list)); }
public static Stocks GetStocksByKioskID_ProdID(int kioskid, int prodid) { var dal = new StocksDAL(); DataRow row = dal.GetStocksByKioskID_ProdID(kioskid, prodid); var ins = new Stocks(); ins.Bind(row); return(ins); }
/// <summary> /// 查询近12个月的采购单个数 /// </summary> /// <returns></returns> public ActionResult GetStocksCountByMtoth1() { 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(StocksDAL.FindByYCount1(d)); } return(Json(dts)); }
public static List <Stocks> GetStocksByReferenceAndKioskID(string directsupplier, int kioskid) { var dal = new StocksDAL(); var collection = new List <Stocks>(); foreach (DataRow row in dal.GetStocksByReferenceAndKioskID(directsupplier, kioskid).Rows) { var instance = new Stocks(); instance.Bind3(row); collection.Add(instance); } return(collection); }
public static List <Stocks> GetKioskPhoneStocks(int id, int type) { var dal = new StocksDAL(); var coll = new List <Stocks>(); foreach (DataRow row in dal.GetKioskPhoneStocks(id, type).Rows) { var ins = new Stocks(); ins.Bind2(row); coll.Add(ins); } return(coll); }
/// <summary> /// /// </summary> /// <param name="textWhere"></param> /// <param name="textOrder"></param> /// <param name="pageIndex"></param> /// <param name="pageRow"></param> /// <param name="columns"></param> /// <returns></returns> public DataTable GetLackOfInspectionListByPage(string textWhere, string textOrder, int pageIndex, int pageRow, List <string> dateColumns, out int dataCount) { DataTable supplyPlanData = GetSupplyPlanListByPage(textWhere, textOrder, pageIndex, pageRow, dateColumns, out dataCount); ///增加RDC数量和VMI数量 foreach (var item in dateColumns) { } supplyPlanData.Columns.Add("RDC", typeof(decimal)); supplyPlanData.Columns.Add("VMI", typeof(decimal)); ///获取所有零件号 List <string> partNos = new List <string>(); foreach (DataRow dr in supplyPlanData.Rows) { string partNo = dr["PartNo"].ToString(); if (partNos.Contains(partNo)) { continue; } partNos.Add(partNo); } List <StocksInfo> stocksInfos = new StocksDAL().GetList("[PART_NO] in ('" + string.Join("','", partNos.ToArray()) + "')", string.Empty); List <WarehouseInfo> warehouseInfos = new WarehouseDAL().GetList("[WAREHOUSE_TYPE] in (" + (int)WarehouseTypeConstants.RDC + "," + (int)WarehouseTypeConstants.VMI + ")", string.Empty); foreach (DataRow dr in supplyPlanData.Rows) { string partNo = dr["PartNo"].ToString(); string supplierNum = dr["SupplierNum"].ToString(); string plant = dr["Plant"].ToString(); /// decimal rdcQty = stocksInfos.Where(d => warehouseInfos.Where(w => w.WarehouseType.GetValueOrDefault() == (int)WarehouseTypeConstants.RDC).Select(w => w.Warehouse).Contains(d.WmNo) && d.PartNo == partNo && d.SupplierNum == supplierNum && d.Plant == plant).Sum(d => d.AvailbleStocks.GetValueOrDefault()); /// decimal vmiQty = stocksInfos.Where(d => warehouseInfos.Where(w => w.WarehouseType.GetValueOrDefault() == (int)WarehouseTypeConstants.VMI).Select(w => w.Warehouse).Contains(d.WmNo) && d.PartNo == partNo && d.SupplierNum == supplierNum && d.Plant == plant).Sum(d => d.AvailbleStocks.GetValueOrDefault()); dr["RDC"] = rdcQty; dr["VMI"] = vmiQty; } return(supplyPlanData); }
/// <summary> /// 多条件查询带分页 /// </summary> /// <param name="StockID"></param> /// <param name="UsersName"></param> /// <param name="PPID"></param> /// <param name="StockDate"></param> /// <param name="StockInDate"></param> /// <param name="PageIndex"></param> /// <param name="PageSize"></param> /// <param name="count"></param> /// <returns></returns> public static List <Stocks> Find(string StockID, string UsersName, string PPID, string StockDate, string StockInDate, int PageIndex, int PageSize, out int count, int?StockState) { return(StocksDAL.Find(StockID, UsersName, PPID, StockDate, StockInDate, PageIndex, PageSize, out count, StockState)); }
internal static Stocks GetByID(string id) { return(StocksDAL.GetByID(id)); }
/// <summary> /// 修改 /// </summary> /// <param name="dp"></param> /// <returns></returns> public static int EdiStocks(Stocks dp, List <StockDetail> list) { return(StocksDAL.EdiStocks(dp, list)); }
/// <summary> /// 审核采购订单 /// </summary> /// <param name="id"></param> /// <returns></returns> public static int CKStocks(string id) { return(StocksDAL.CKStocks(id)); }
/// <summary> /// 添加 /// </summary> /// <param name="dep"></param> /// <returns></returns> public static int AddStocks(Stocks dep, List <StockDetail> list) { return(StocksDAL.AddStocks(dep, list)); }
/// <summary> /// 删除 /// </summary> /// <param name="id"></param> /// <returns></returns> public static int DelStocks(string id) { return(StocksDAL.DelStocks(id)); }
/// <summary> /// 查询所有 /// </summary> /// <returns></returns> public static List <Stocks> GetAll() { return(StocksDAL.GetAll()); }
/// <summary> /// 分页查询 /// </summary> /// <param name="PageIndex"></param> /// <param name="PageSize"></param> /// <returns></returns> public static List <Stocks> GetAllPage(int PageIndex, int PageSize) { return(StocksDAL.GetAllPage(PageIndex, PageSize)); }
public Guid Save(Stock model) { return(StocksDAL.Save(model)); }
public void Delete(Guid id) { StocksDAL.Delete(id); }
/// <summary> /// 发布 /// </summary> /// <param name="aId"></param> /// <param name="loginUser"></param> /// <returns></returns> public bool StartInfos(List <string> rowsKeyValues, string loginUser) { if (dal.GetList("[ID] IN (" + string.Join(",", rowsKeyValues) + ") and [STATUS] = " + (int)InventoryOrderStatusConstants.CREATED + "", string.Empty).Count == 0) { throw new Exception("MC:0x00000369");///状态为已创建的盘点单才允许进行发布 } List <InventoryNoticeOrderInfo> info = dal.GetList("[ID] IN (" + string.Join(",", rowsKeyValues) + ")", string.Empty); if (info.Count == 0) { throw new Exception("MC:0x00000084");///数据错误 } List <PartsStockInfo> partsStocks = new PartsStockDAL().GetList("[WM_NO] in ('" + string.Join("','", info.Select(d => d.WmNo).ToArray()) + "') and [ZONE_NO] in ('" + string.Join("','", info.Select(d => d.ZoneNo).ToArray()) + "') and [KEEPER] in ('" + string.Join("','", info.Select(d => d.Keeper).ToArray()) + "')", string.Empty); if (partsStocks.Count == 0) { throw new Exception("MC:0x00000370");///没有相关的物料仓储信息 } List <StocksInfo> stocks = new StocksDAL().GetList("[WM_NO] in ('" + string.Join("','", partsStocks.Select(d => d.WmNo).ToArray()) + "') and [ZONE_NO] in ('" + string.Join("','", partsStocks.Select(d => d.ZoneNo).ToArray()) + "') and [PACKAGE_MODEL] in ('" + string.Join("','", partsStocks.Select(d => d.InboundPackageModel).ToArray()) + "') and [PART_NO] in ('" + string.Join("','", partsStocks.Select(d => d.PartNo).ToArray()) + "') and [SUPPLIER_NUM] in ('" + string.Join("','", partsStocks.Select(d => d.SupplierNum).ToArray()) + "')", string.Empty); string check = new ConfigBLL().GetValueByCode("NO_STOCK_MATERIAL_NOT_RELEASE_TO_INVENTORY_ORDER"); string stock = new ConfigBLL().GetValueByCode("MATERIALS_USED_IN_AVAILABLE_STOCK"); string sql = string.Empty; foreach (var item in info) { List <PartsStockInfo> partsStockInfos = partsStocks.Where(d => d.Keeper == item.Keeper && d.WmNo == item.WmNo && d.ZoneNo == item.ZoneNo).ToList(); if (partsStockInfos.Count == 0) { throw new Exception("MC:0x00000370");///没有相关的物料仓储信息 } foreach (var items in partsStockInfos) { List <StocksInfo> stocksInfos = stocks.Where(d => d.Keeper == items.Keeper && d.WmNo == items.WmNo && d.ZoneNo == item.ZoneNo && d.PartNo == items.PartNo).ToList(); string Package = items.Package == null ? "null" : items.Package.ToString(); if (check == "true") { int sum = 0; if (stock == "true") { sum = (int)stocksInfos.Select(d => d.AvailbleStocks).Sum(); } else { sum = (int)stocksInfos.Select(d => d.StocksNum).Sum(); } if (sum > 0) { sql += "insert into [LES].[TT_WMM_INVENTORY_ORDER_PART] " + "([FID],[ORDER_CODE],[ORDER_FID],[WM_NO],[ZONE_NO],[DLOC],[PART_NO],[SUPPLIER_NUM],[PACKAGE_MODEL],[PACKAGE],[PART_CNAME],[PACKAGE_QTY],[REFERENCE_QTY],[VALID_FLAG],[CREATE_DATE],[CREATE_USER])" + "values(" + "newid()," + "N'" + item.OrderCode + "'," + "N'" + item.Fid + "'," + "N'" + items.WmNo + "'," + "N'" + items.ZoneNo + "'," + "N'" + items.Dloc + "'," + "N'" + items.PartNo + "'," + "N'" + items.SupplierNum + "'," + "N'" + items.InboundPackageModel + "'," + Package + "," + "N'" + items.PartCname + "'," + "N'" + stocksInfos.Select(d => d.Stocks).Sum() + "'," + "N'" + sum + "'," + "1," + "GETDATE()," + "N'" + loginUser + "'" + ")\n"; } } else { int sum = 0; if (stock == "true") { sum = (int)stocksInfos.Select(d => d.AvailbleStocks).Sum(); } else { sum = (int)stocksInfos.Select(d => d.StocksNum).Sum(); } sql += "insert into [LES].[TT_WMM_INVENTORY_ORDER_PART] " + "([FID],[ORDER_CODE],[ORDER_FID],[WM_NO],[ZONE_NO],[DLOC],[PART_NO],[SUPPLIER_NUM],[PACKAGE_MODEL],[PACKAGE],[PART_CNAME],[PACKAGE_QTY],[REFERENCE_QTY],[VALID_FLAG],[CREATE_DATE],[CREATE_USER])" + "values(" + "newid()," + "N'" + item.OrderCode + "'," + "N'" + item.Fid + "'," + "N'" + items.WmNo + "'," + "N'" + items.ZoneNo + "'," + "N'" + items.Dloc + "'," + "N'" + items.PartNo + "'," + "N'" + items.SupplierNum + "'," + "N'" + items.PackageModel + "'," + Package + "," + "N'" + items.PartCname + "'," + "N'" + stocksInfos.Select(d => d.Stocks).Sum() + "'," + "N'" + sum + "'," + "1," + "GETDATE()," + "N'" + loginUser + "'" + ")\n"; } } } using (TransactionScope trans = new TransactionScope()) { if (string.IsNullOrEmpty(sql)) { throw new Exception("MC:0x00000440");///没有相关物料明细 } sql += "update [LES].[TT_WMM_INVENTORY_NOTICE_ORDER] set [STATUS] = " + (int)InventoryOrderStatusConstants.PUBLISHED + ",[MODIFY_DATE] = GETDATE(),[MODIFY_USER] = N'" + loginUser + "' where [VALID_FLAG] = 1 and [ID] IN (" + string.Join(",", rowsKeyValues) + ") "; CommonDAL.ExecuteNonQueryBySql(sql); trans.Complete(); } return(true); }
public static void SetStocksByRefKiosdidProdid(string dr, int kioskid, int stocklist, int prodid, string checkby) { var dal = new StocksDAL(); dal.SetStocksByRefKiosdidProdid(dr, kioskid, stocklist, prodid, checkby); }
public static void InsertStocks(List <Stocks> collection) { var dal = new StocksDAL(); dal.InsertStocks(collection); }
public static void ModifyNewStocks(List <Stocks> newStocks, int type, int kioskid) { var dal = new StocksDAL(); dal.ModifyNewStocks(newStocks, type, kioskid); }
public static bool DeleteStocksByKiosk(int kioskID) { var dal = new StocksDAL(); return(dal.DeleteStocksByKiosk(kioskID)); }