public void LoginUserPage_Init(object sender, EventArgs e)
{
me = (new LoginUser()).CurrentUser;
if (!QueryReport.Code.LoginUser.isLogin())
{
Response.Redirect("~/SignIn.aspx", false);
Response.End();
}
}
/// <summary>
/// Get Query List for dropdown on rpexcel / rpworddetail
/// </summary>
/// <param name="me">Current user, used to determine privilege level</param>
/// <param name="FormatType">1 = Excel, 2 = Word, 3 = All</param>
public DataSet GetQueryListForDropdown(CUSTOMRP.Model.LoginUser me, int FormatType)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select [ID], [SOURCEVIEWNAME] + ' | ' +[DESC] [NewDesc] ");
strSql.Append(" FROM [SOURCEVIEW] ");
strSql.AppendFormat(" WHERE [VIEWLEVEL]>={0} AND [DATABASEID]={1} AND (FORMATTYPE & {2}) = {2}", me.ViewLevel, me.DatabaseID, FormatType);
strSql.Append(" ORDER BY [SOURCEVIEWNAME], [DESC]");
return(DbHelperSQL.Query(me.ID, strSql.ToString()));
}