static DataTable getData(IEnvironment env, int lref) { IPagedSource source = new PagedSourceDocNum(env); source.getBuilder().addParameterValue(TableDOCNUM.LOGICALREF, lref); DataTable tabNum = source.getAll(); if (ToolTable.isEmpty(tabNum)) { throw new MyException.MyExceptionError(MessageCollection.T_MSG_ERROR_NUMERATION); } return(tabNum); }
static DataTable getData(IEnvironment env, DateTime date, short mod, short docType, short firm, short div, short factory, short wh, short group, short role, short user) { IPagedSource source = new PagedSourceDocNum(env); source.getBuilder().addParameterValue(TableDOCNUM.APPMODULE, mod); source.getBuilder().addParameterValue(TableDOCNUM.DOCIDEN, docType); source.getBuilder().beginWhereGroup(); source.getBuilder().addParameterValue(TableDOCNUM.FIRMID, firm); source.getBuilder().addParameterValue(TableDOCNUM.FIRMID, 0, SqlTypeRelations.equal, SqlTypeRelations.boolOr); source.getBuilder().endWhereGroup(); source.getBuilder().beginWhereGroup(); source.getBuilder().addParameterValue(TableDOCNUM.EFFSDATE, date, SqlTypeRelations.lessEqual); source.getBuilder().addParameterValue(TableDOCNUM.EFFEDATE, date, SqlTypeRelations.greaterEqual); source.getBuilder().endWhereGroup(); source.getBuilder().beginWhereGroup(); source.getBuilder().addParameterValue(TableDOCNUM.DIVISID, div); source.getBuilder().addParameterValue(TableDOCNUM.DIVISID, -1, SqlTypeRelations.equal, SqlTypeRelations.boolOr); source.getBuilder().endWhereGroup(); source.getBuilder().beginWhereGroup(); source.getBuilder().addParameterValue(TableDOCNUM.WHID, wh); source.getBuilder().addParameterValue(TableDOCNUM.WHID, -1, SqlTypeRelations.equal, SqlTypeRelations.boolOr); source.getBuilder().endWhereGroup(); source.getBuilder().beginWhereGroup(); source.getBuilder().addParameterValue(TableDOCNUM.FACTID, factory); source.getBuilder().addParameterValue(TableDOCNUM.FACTID, -1, SqlTypeRelations.equal, SqlTypeRelations.boolOr); source.getBuilder().endWhereGroup(); source.getBuilder().beginWhereGroup(); source.getBuilder().addParameterValue(TableDOCNUM.GROUPID, group); source.getBuilder().addParameterValue(TableDOCNUM.GROUPID, 0, SqlTypeRelations.equal, SqlTypeRelations.boolOr); source.getBuilder().endWhereGroup(); source.getBuilder().beginWhereGroup(); source.getBuilder().addParameterValue(TableDOCNUM.ROLEID, role); source.getBuilder().addParameterValue(TableDOCNUM.ROLEID, 0, SqlTypeRelations.equal, SqlTypeRelations.boolOr); source.getBuilder().endWhereGroup(); source.getBuilder().beginWhereGroup(); source.getBuilder().addParameterValue(TableDOCNUM.USERID, user); source.getBuilder().addParameterValue(TableDOCNUM.USERID, 0, SqlTypeRelations.equal, SqlTypeRelations.boolOr); source.getBuilder().endWhereGroup(); DataTable tabNum = source.getAll(); if (ToolTable.isEmpty(tabNum)) { throw new MyException.MyExceptionError(MessageCollection.T_MSG_ERROR_NUMERATION); } return(tabNum); }