/// <summary>
/// Returns a list of users (suitable for read-only lists, such as combos), optionally of a certain role.
/// </summary>
/// <param name="roleId">Role to filter (negative number means all).</param>
/// <returns>A list of users (id, full name), ordered by full name.</returns>
public DataSet GetUserList(int roleId)
{
Database d = DatabaseFactory.GetDatabase();
if (roleId >= 0)
{
return(d.FillDataSet("USR_ID, USR_FULLNAME", "VW_USERS_LIST", null, "USR_ROL_ID = @VW_USERS_LIST.USR_ROL_ID", "VW_USERS_LIST", -1, roleId));
}
else
{
return(d.FillDataSet("USR_ID, USR_FULLNAME", "VW_USERS_LIST", null, null, "VW_USERS_LIST", -1));
}
}
public DataSet LoadStaticResources(string culture, int logicalUnit)
{
Database d = DatabaseFactory.GetDatabase();
object[] values = { culture, "STATICS", logicalUnit };
return(d.FillDataSet("SELECT UPPER(LIT_DESCSHORT), LIT_DESCLONG FROM LITERALS "
+ "WHERE LIT_LAN_ID = @LITERALS.LIT_LAN_ID@ "
+ "AND LIT_CATEGORY = @LITERALS.LIT_CATEGORY@ "
+ "AND LIT_DLUNI_ID = @LITERALS.LIT_DLUNI_ID@", "LiteralesField", values));
}
/// <summary>
/// Executes a Query and fills a DataSet.
/// </summary>
/// <param name="select">Fields to SELECT.</param>
/// <param name="from">Tables and joins clauses.</param>
/// <param name="where">Filters to add to where. Null if none.</param>
/// <param name="groupBy">Fields to GROUP BY. Null if none.</param>
/// <param name="orderBy">Fields to ORDER BY. Null if none.</param>
/// <returns>Returns a DataSet which contains a DataTable. The table name is "Results".</returns>
public DataSet FillDataSet(
string select,
string from,
string where,
string groupBy,
string orderBy
)
{
Database d = DatabaseFactory.GetDatabase();
return(d.FillDataSet(select, from, orderBy, where, groupBy, "Results", -1));
}
public DataSet LoadMessageBoxResources(string culture, int logicalUnit)
{
Database d = DatabaseFactory.GetDatabase();
object[] values = { culture, "VIEWS", "MESSAGES", "MODULES", logicalUnit };
return(d.FillDataSet("SELECT LIT_ID, LIT_DESCSHORT, LIT_DESCLONG FROM LITERALS "
+ "WHERE LIT_LAN_ID = @LITERALS.LIT_LAN_ID@ "
+ "AND (LIT_CATEGORY = @LITERALS.LIT_CATEGORY@ "
+ "OR LIT_CATEGORY = @LITERALS.LIT_CATEGORY@ "
+ "OR LIT_CATEGORY = @LITERALS.LIT_CATEGORY@) "
+ "AND LIT_DLUNI_ID = @LITERALS.LIT_DLUNI_ID@", "LiteralesField", values));
}
public DataSet LoadMenuResources(string culture, int logicalUnit)
{
Database d = DatabaseFactory.GetDatabase();
object[] values = { culture, "FIELD", "STATICS", "MESSAGES", logicalUnit };
return(d.FillDataSet("SELECT LIT_ID, LIT_DESCSHORT, LIT_DESCLONG FROM LITERALS "
+ "WHERE LIT_LAN_ID = @LITERALS.LIT_LAN_ID@ "
+ "AND LIT_CATEGORY <> @LITERALS.LIT_CATEGORY@ "
+ "AND LIT_CATEGORY <> @LITERALS.LIT_CATEGORY@ "
+ "AND LIT_CATEGORY <> @LITERALS.LIT_CATEGORY@ "
+ "AND LIT_DLUNI_ID = @LITERALS.LIT_DLUNI_ID@", "Literales", values));
}
public DataSet FillDataSet(
string table,
string select,
string from,
string where,
string groupBy,
string orderBy,
object[] values
)
{
Database d = DatabaseFactory.GetDatabase();
return(d.FillDataSet(select, from, orderBy, where, groupBy, table, -1, values));
}
public void FillDataSet(
ref DataSet dataSet,
string table,
string select,
string from,
string where,
string groupBy,
string orderBy,
object[] values
)
{
Database d = DatabaseFactory.GetDatabase();
d.FillDataSet(ref dataSet, select, from, orderBy, where, groupBy, table, -1, values);
}
public DataSet GetUserData(string login)
{
Database d = DatabaseFactory.GetDatabase();
return(d.FillDataSet("USR_ID, USR_NAME, USR_SURNAME1, USR_SURNAME2, USR_ROL_ID, USR_LOGIN, USR_PASSWORD, USR_LAN_ID, USR_STATUS, USR_CUS_ID", "USERS", null, "USR_LOGIN = @USERS.USR_LOGIN@ AND USR_STATUS = @USERS.USR_STATUS@", "USERS", -1, login, 1));
}
