public List <VInventory> getSearchListByID(string InventoryID) { List <VInventory> list = new List <VInventory>(); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@InventoryID", SqlDbType.NVarChar) }; parameters[0].Value = InventoryID; SqlDataReader reader = SQLHelper.RunProcedure("p_Inventory_getSearchListByID", parameters); while (reader.Read()) { VInventory item = new VInventory(); item.Description = reader.GetString(reader.GetOrdinal("Description")); item.CreateDate = reader.GetString(reader.GetOrdinal("CreateDate")); item.RealName = reader.GetString(reader.GetOrdinal("RealName")); item.InventoryID = reader.GetString(reader.GetOrdinal("InventoryID")); item.AdjustNum = reader.GetInt32(reader.GetOrdinal("AdjustNum")); item.BillNum = reader.GetInt32(reader.GetOrdinal("BillNum")); item.RealityNum = reader.GetInt32(reader.GetOrdinal("RealityNum")); item.ProductsID = reader.GetInt32(reader.GetOrdinal("ProductsID")); item.TradeDate = reader.GetString(reader.GetOrdinal("TradeDate")); item.State = reader.GetInt32(reader.GetOrdinal("State")); item.HouseDetailID = reader.GetInt32(reader.GetOrdinal("HouseDetailID")); item.HouseName = reader.GetString(reader.GetOrdinal("HouseName")); item.SubareaName = reader.GetString(reader.GetOrdinal("SubareaName")); item.Operator = reader.GetString(reader.GetOrdinal("Operator")); item.ProductsName = reader.GetString(reader.GetOrdinal("ProductsName")); list.Add(item); } reader.Close(); return(list); }
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); }