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