public int Add_BatchMR(string Part, string BatchID, string StoreID, string RequestedBy, string Remarks, MR.Status MRStatus, MR.Type MRType, int OriginType)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@Part", Part),
new SqlParameter("@BatchID", BatchID),
new SqlParameter("@MRStore", StoreID),
new SqlParameter("@MREnterdBy", RequestedBy),
new SqlParameter("@MRRemarks", Remarks),
new SqlParameter("@MRStatus", MRStatus),
new SqlParameter("@MRType", MRType),
new SqlParameter("@OriginType", OriginType),
new SqlParameter("@outParam", SqlDbType.Int)
{
Direction = ParameterDirection.Output
}
};
return(Execute.RunSP_Output(Connection, "SPADD_BatchMR_SendMR", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Add_Packing_ToSections(string StoreID, int SectionID, int DepID, string RequestedBy, string Remarks, MR.Status MRStatus, MR.Type MRType, int OriginType)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MRStore", StoreID),
new SqlParameter("@SectionID", SectionID),
new SqlParameter("@DepID", DepID),
new SqlParameter("@MREnterdBy", RequestedBy),
new SqlParameter("@MRRemarks", Remarks),
new SqlParameter("@MRStatus", MRStatus),
new SqlParameter("@MRType", MRType),
new SqlParameter("@OriginType", OriginType),
new SqlParameter("@outParam", SqlDbType.Int)
{
Direction = ParameterDirection.Output
}
};
return(Execute.RunSP_Output(Connection, "SPADD_MR_Packing_ToSections", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
