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);
}
