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