public static void Approve(ISIOP SIOP) { SqlParameter[] _parameters = { new SqlParameter("@SIOPID", SIOP.SIOPID) , new SqlParameter("@SysModifier", SIOP.SysModifier) }; SqlHelper.ExecuteNonQuery(ConnectionString, "sp_SIOP_Approve", _parameters); }
public static void Initialize(ISIOP SIOP) { SqlParameter[] _parameters = { new SqlParameter("@SIOPID", SIOP.SIOPID) , new SqlParameter("@Type", SIOP.PlanType) , new SqlParameter("@SysCreator", SIOP.SysCreator) }; SqlHelper.ExecuteNonQuery(ConnectionString, "sp_SIOP_Initialize", _parameters); }
public static DataSet RetrieveGroup(ISIOP SIOP, Int32 SearchOption) { SqlParameter[] _parameters = { new SqlParameter("@WorkCenterCode", SIOP.WorkCenterCode) , new SqlParameter("@WhseCode", SIOP.WhseCode) , new SqlParameter("@WhseLocation", SIOP.WhseLocation) , new SqlParameter("@SearchOption", SearchOption) }; return(SqlHelper.ExecuteDataset(ConnectionString, "sp_SIOP_Grouped_Search", _parameters)); }
public static DataSet Arbitrate(ISIOP SIOP) { SqlParameter[] _parameters = { new SqlParameter("@Year", SIOP.Year) , new SqlParameter("@Period", SIOP.Period) , new SqlParameter("@ItemCode", SIOP.ItemCode) , new SqlParameter("@Quantity", SIOP.Quantity) , new SqlParameter("@SysCreator", SIOP.SysCreator) }; return(SqlHelper.ExecuteDataset(ConnectionString, "sp_SIOP_Arbitrate", _parameters)); }
public static DataSet Retrieve(ISIOP SIOP, Int32 SearchOption) { SqlParameter[] _parameters = { new SqlParameter("@WhseCode", SIOP.WhseCode) , new SqlParameter("@WhseLocation", SIOP.WhseLocation) , new SqlParameter("@ItemCode", SIOP.ItemCode) , new SqlParameter("@Description", SIOP.Description) , new SqlParameter("@Model", SIOP.Model) , new SqlParameter("@SearchOption", SearchOption) }; return(SqlHelper.ExecuteDataset(ConnectionString, "sp_SIOP_Search", _parameters)); }
public static DataSet ArbitrateByGroup(ISIOP SIOP) { SqlParameter[] _parameters = { new SqlParameter("@Year", SIOP.Year) , new SqlParameter("@Period", SIOP.Period) , new SqlParameter("@WhseCode", SIOP.WhseCode) , new SqlParameter("@WorkCenterCode", SIOP.WorkCenterCode) , new SqlParameter("@WhseLocation", SIOP.WhseLocation) , new SqlParameter("@Quantity", SIOP.Quantity) , new SqlParameter("@SysCreator", SIOP.SysCreator) }; return(SqlHelper.ExecuteDataset(ConnectionString, "sp_SIOP_Grouped_ArbitrateByGroup", _parameters)); }