public static DataSet Update(IStockCountResult StockCountResult) { SqlParameter[] _parameters = { new SqlParameter("@InventoryTagNo", StockCountResult.InventoryTagNo) , new SqlParameter("@ActualQty", StockCountResult.ActualQty) , new SqlParameter("@SysModifier", StockCountResult.SysModifier) }; return(SqlHelper.ExecuteDataset(ConnectionString, "sp_StockCountResults_Update", _parameters)); }
public static DataSet Retrieve(IStockCountResult StockCountResult) { SqlParameter[] _parameters = { new SqlParameter("@Year", StockCountResult.Year) , new SqlParameter("@Period", StockCountResult.Period) , new SqlParameter("@Warehouse", StockCountResult.Warehouse) }; return(SqlHelper.ExecuteDataset(ConnectionString, "sp_StockCountResults_SelectByYearPeriodWarehouse", _parameters)); }
public static DataSet RetrieveKab(IStockCountResult StockCountResult) { SqlParameter[] _parameters = { new SqlParameter("@Year", StockCountResult.Year) , new SqlParameter("@Period", StockCountResult.Period) , new SqlParameter("@Warehouse", StockCountResult.Warehouse) , new SqlParameter("@WhseLocation", StockCountResult.Location) , new SqlParameter("@ItemCode", StockCountResult.ItemCode) }; return(SqlHelper.ExecuteDataset(ConnectionString, "sp_StockCountResults_RetrieveStockTakingResult", _parameters)); }
public static DataSet Insert(IStockCountResult StockCountResult) { SqlParameter[] _parameters = { new SqlParameter("@Year", StockCountResult.Year) , new SqlParameter("@Period", StockCountResult.Period) , new SqlParameter("@ItemCode", StockCountResult.ItemCode) , new SqlParameter("@UOM", StockCountResult.UOM) , new SqlParameter("@Warehouse", StockCountResult.Warehouse) , new SqlParameter("@Location", StockCountResult.Location) , new SqlParameter("@SysCreator", StockCountResult.SysCreator) }; return(SqlHelper.ExecuteDataset(ConnectionString, "sp_StockCountResults_Insert", _parameters)); }