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