public bool AuditingInventoryOrder(string InventoryID) { bool flag = false; try { ProductsStock stock; VInventory inventory = new VInventory(); ProductsStockDAL kdal = new ProductsStockDAL(); inventory = new InventoryDAL().getByID(InventoryID); if (kdal.isHaveEitity(inventory.HouseDetailID, inventory.ProductsID)) { stock = new ProductsStock(); stock.HouseDetailID = inventory.HouseDetailID; stock.ProductsID = inventory.ProductsID; stock.Num = inventory.AdjustNum; kdal.updateEitityNum(stock); } else { stock = new ProductsStock(); stock.HouseDetailID = inventory.HouseDetailID; stock.ProductsID = inventory.ProductsID; stock.Num = inventory.AdjustNum; kdal.insertNewEitity(stock); } flag = true; } catch { } return(flag); }
public bool AuditingTransferring(string ID) { bool flag = false; try { ProductsStockDAL kdal = new ProductsStockDAL(); VTransferringOrder order = new TransferringOrderDAL().getByID(ID); if (order == null) { return(false); } int outHouseID = order.OutHouseID; int inHouseID = order.InHouseID; int productsID = order.ProductsID; int quantity = order.Quantity; ProductsStock stock = kdal.getByProductsIDStockID(productsID, outHouseID); ProductsStock stock2 = kdal.getByProductsIDStockID(productsID, inHouseID); if (stock == null) { return(false); } if (quantity > stock.Num) { return(false); } ProductsStock p = new ProductsStock(); p.HouseDetailID = outHouseID; p.ProductsID = productsID; p.Num = quantity; ProductsStock stock4 = new ProductsStock(); stock4.HouseDetailID = inHouseID; stock4.ProductsID = productsID; stock4.Num = quantity; if (kdal.updateCutNum(p)) { if (stock2 == null) { kdal.insertNewEitity(stock4); } else { kdal.updateAddNum(stock4); } } flag = true; } catch { } return(flag); }
public bool AuditingBuyReturnOrder(string BuyReturnID) { bool flag = false; try { List <VBuyReturnDetail> list = new List <VBuyReturnDetail>(); ProductsStockDAL kdal = new ProductsStockDAL(); BuyReturn return2 = new BuyReturnDAL().getByID(BuyReturnID); if (return2 == null) { return(false); } list = new BuyReturnDetailDAL().getBuyReturnDetailByBuyReturnID(BuyReturnID); for (int i = 0; i < list.Count; i++) { ProductsStock stock; BuyReturnDetail detail = list[i]; if (kdal.isHaveEitity(return2.HouseDetailID, detail.ProductsID)) { stock = new ProductsStock(); stock.HouseDetailID = return2.HouseDetailID; stock.ProductsID = detail.ProductsID; stock.Num = detail.Quantity; kdal.updateCutNum(stock); } else { stock = new ProductsStock(); stock.HouseDetailID = return2.HouseDetailID; stock.ProductsID = detail.ProductsID; stock.Num = -detail.Quantity; kdal.insertNewEitity(stock); } } flag = true; } catch { } return(flag); }
public bool AuditingSalesOutOrder(string SalesReturnID) { bool flag = false; try { VSalesReturn return2 = new VSalesReturn(); List <VSalesReturnDetail> list = new List <VSalesReturnDetail>(); ProductsStockDAL kdal = new ProductsStockDAL(); return2 = new SalesReturnDAL().getByID(SalesReturnID); list = new SalesReturnDetailDAL().getBySalesReturnID(SalesReturnID); for (int i = 0; i < list.Count; i++) { ProductsStock stock; SalesReturnDetail detail = list[i]; if (kdal.isHaveEitity(return2.HouseDetailID, detail.ProductsID)) { stock = new ProductsStock(); stock.HouseDetailID = return2.HouseDetailID; stock.ProductsID = detail.ProductsID; stock.Num = detail.Quantity; kdal.updateAddNum(stock); } else { stock = new ProductsStock(); stock.HouseDetailID = return2.HouseDetailID; stock.ProductsID = detail.ProductsID; stock.Num = detail.Quantity; kdal.insertNewEitity(stock); } } flag = true; } catch { } return(flag); }
public bool AuditingAppendStockOrder(string AppendID) { bool flag = false; try { VAppendStock stock = new VAppendStock(); List <VAppendStockDetail> list = new List <VAppendStockDetail>(); ProductsStockDAL kdal = new ProductsStockDAL(); stock = new AppendStockDAL().getByID(AppendID); list = new AppendStockDetailDAL().getListByAppendID(AppendID); for (int i = 0; i < list.Count; i++) { ProductsStock stock2; AppendStockDetail detail = list[i]; if (kdal.isHaveEitity(stock.HouseDetailID, detail.ProductsID)) { stock2 = new ProductsStock(); stock2.HouseDetailID = stock.HouseDetailID; stock2.ProductsID = detail.ProductsID; stock2.Num = detail.Quantity; kdal.updateAddNum(stock2); } else { stock2 = new ProductsStock(); stock2.HouseDetailID = stock.HouseDetailID; stock2.ProductsID = detail.ProductsID; stock2.Num = detail.Quantity; kdal.insertNewEitity(stock2); } } flag = true; } catch { } return(flag); }
public bool AuditingBuyReceiptOrder(string ReceiptOrderID) { bool flag = false; try { BuyReceipt receipt = new BuyReceipt(); List <VBuyReceiptDetail> list = new List <VBuyReceiptDetail>(); ProductsStockDAL kdal = new ProductsStockDAL(); receipt = new BuyReceiptDAL().getByID(ReceiptOrderID); list = new BuyReceiptDetailDAL().getBuyReceiptDetailByReceiptOrderID(ReceiptOrderID); for (int i = 0; i < list.Count; i++) { ProductsStock stock; BuyReceiptDetail detail = list[i]; if (kdal.isHaveEitity(receipt.HouseDetailID, detail.ProductsID)) { stock = new ProductsStock(); stock.HouseDetailID = receipt.HouseDetailID; stock.ProductsID = detail.ProductsID; stock.Num = detail.Quantity; kdal.updateAddNum(stock); } else { stock = new ProductsStock(); stock.HouseDetailID = receipt.HouseDetailID; stock.ProductsID = detail.ProductsID; stock.Num = detail.Quantity; kdal.insertNewEitity(stock); } } flag = true; } catch { } return(flag); }