public System.Data.DataTable GetDataView(long UserID, MR.Status Status, MR.Origin OriginType)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@UserID", UserID),
new SqlParameter("@Status", Status),
new SqlParameter("@OriginType", OriginType)
};
return(Execute.RunSP_DataTable(Connection, "SPGET_MR_ByDepID_Status_Origin", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public System.Data.DataTable GetMR_ToBatch(long UserID, MR.Status Status, MR.Origin ToBatch)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@UserID", UserID),
new SqlParameter("@Status", Status),
new SqlParameter("@Origin", ToBatch)
};
return(Execute.RunSP_DataTable(Connection, "SPGET_MR_ByProduct_Status", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
