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