public DataView Query(int startRowIndex, int maximumRows, string appName, string programName, WfApplicationAuthType authType, string where, string orderBy, ref int totalCount)
{
WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder();
if (string.IsNullOrEmpty(appName) == false)
{
builder.AppendItem("APPLICATION_NAME", appName);
if (string.IsNullOrEmpty(programName) == false)
{
builder.AppendItem("PROGRAM_NAME", programName);
}
}
if (authType != WfApplicationAuthType.None)
{
builder.AppendItem("AUTH_TYPE", authType.ToString());
}
string sql = builder.ToSqlString(TSqlBuilder.Instance);
if (string.IsNullOrEmpty(where) == false)
{
sql = (string.IsNullOrEmpty(sql) ? where : sql + " AND (" + where + ")");
}
return(base.Query(startRowIndex, maximumRows, sql, orderBy, ref totalCount));
}
public DataView Query(int startRowIndex, int maximumRows, string appName, string programName, WfApplicationAuthType authType, string where, string orderBy, ref int totalCount)
{
WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder();
if (string.IsNullOrEmpty(appName) == false)
{
builder.AppendItem("APPLICATION_NAME", appName);
if (string.IsNullOrEmpty(programName) == false)
{
builder.AppendItem("PROGRAM_NAME", programName);
}
}
if (authType != WfApplicationAuthType.None)
{
builder.AppendItem("AUTH_TYPE", authType.ToString());
}
string sql = builder.ToSqlString(TSqlBuilder.Instance);
if (string.IsNullOrEmpty(where) == false)
{
sql = (string.IsNullOrEmpty(sql) ? where : sql + " AND (" + where + ")");
}
return base.Query(startRowIndex, maximumRows, sql, orderBy, ref totalCount);
}
public WfApplicationAuth Load(string appName, string progName, WfApplicationAuthType authType)
{
appName.CheckStringIsNullOrEmpty("appName");
progName.CheckStringIsNullOrEmpty("progName");
return(WfApplicationAuthAdapter.Instance.Load(builder =>
{
builder.AppendItem("APPLICATION_NAME", appName);
builder.AppendItem("PROGRAM_NAME", progName);
builder.AppendItem("AUTH_TYPE", authType.ToString());
}).FirstOrDefault());
}
public WfApplicationAuthCollection Load(string appName, WfApplicationAuthType authType)
{
appName.CheckStringIsNullOrEmpty("appName");
return(WfApplicationAuthAdapter.Instance.Load(builder =>
{
builder.AppendItem("APPLICATION_NAME", appName).AppendItem("AUTH_TYPE", authType.ToString());
}));
}
