/// <summary>
/// 获取数据集
/// </summary>
/// <returns></returns>
public DataSet GetList()
{
string strSql = @"select tb_sys_admin.id,[count],telephone,loginTime,sex,AccountState,PowerLeave,tb_sys_role.roleName from tb_sys_admin
left join tb_sys_role on tb_sys_role.id=tb_sys_admin.roleid ";
Test_BUL.sys_Common common = new Test_BUL.sys_Common();
return common.GetList(strSql);
}
/// <summary>
/// 获取数据集
/// </summary>
/// <returns></returns>
public DataSet GetList()
{
string strSql = @"select tb_sys_admin.id,[count],telephone,loginTime,sex,AccountState,PowerLeave,tb_sys_role.roleName from tb_sys_admin
left join tb_sys_role on tb_sys_role.id=tb_sys_admin.roleid ";
Test_BUL.sys_Common common = new Test_BUL.sys_Common();
return(common.GetList(strSql));
}
protected override void OnInit(EventArgs e)
{
if (!CheckAdminLogin())
{
FinalMessage("系统尚未登录或登录超时！", "./login.aspx", 0);
}
else
{
#region Request对象地址栏参数检查
//..
#endregion
#region 得到该用户所对角色的菜单
Test_BUL.sys_Common common = new Test_BUL.sys_Common();
DataSet SysAdminDS;
if (Tools.CacheUtil.IsExist(Test_BUL.sysParam.CachePageIdDs))
{
SysAdminDS = (DataSet)Tools.CacheUtil.GetCache(Test_BUL.sysParam.CachePageIdDs);
}
else
{
SysAdminDS = common.GetList(" select pageId from tb_sys_role where id=" + adminGetRoleId);
Tools.CacheUtil.InsertCach(Test_BUL.sysParam.CachePageIdDs, (object)SysAdminDS, Test_BUL.sysParam.CachePageIdDsTimes, 2);
}
FileItems = SysAdminDS.Tables[0].Rows[0]["pageId"].ToString();//1,2,3,4,5,6,7,8,9...
#endregion
#region URL访问判断
//string urlHead = "/testweb/admin/"; //发布
string urlHead = "/admin/"; //本地测试
string currentUrl = HttpContext.Current.Request.FilePath.ToLower().Replace(urlHead, "");
if (currentUrl.IndexOf("admin.aspx") == -1 && currentUrl.IndexOf("desktop.aspx") == -1)
{
DataSet urlDS = common.GetList(" select id , filesUrl from tb_sys_sysfiles where lower(filesUrl)='" + currentUrl + "' ");
if (Tools.Validator.CheckDataSet(urlDS, 0))
{
string _parmUrlId = urlDS.Tables[0].Rows[0]["id"].ToString();
string[] tempArr = FileItems.Split(',');
bool tag = false;
for (int i = 0; i < tempArr.Length; i++)
{
if (tempArr[i] == _parmUrlId)
{
tag = true; break;
}
}
if (!tag)
{
FinalMessage("您无权访问该页", "", 1);
}
//if (!RequestQueryValidate()) //没有处理完善，带搜索框查询跳转、多条件分页查询跳转的2种情况的还没有处理
// FinalMessage("对不起，页面参数校验错误！", "", 1);
}
else
{
FinalMessage("您访问的页面不存在", "", 1);
}
}
#endregion
}
base.OnInit(e);
}
protected override void OnInit(EventArgs e)
{
if (!CheckAdminLogin())
FinalMessage("系统尚未登录或登录超时！", "./login.aspx", 0);
else
{
#region Request对象地址栏参数检查
//..
#endregion
#region 得到该用户所对角色的菜单
Test_BUL.sys_Common common = new Test_BUL.sys_Common();
DataSet SysAdminDS;
if (Tools.CacheUtil.IsExist(Test_BUL.sysParam.CachePageIdDs))
SysAdminDS = (DataSet)Tools.CacheUtil.GetCache(Test_BUL.sysParam.CachePageIdDs);
else
{
SysAdminDS = common.GetList(" select pageId from tb_sys_role where id=" + adminGetRoleId);
Tools.CacheUtil.InsertCach(Test_BUL.sysParam.CachePageIdDs, (object)SysAdminDS, Test_BUL.sysParam.CachePageIdDsTimes, 2);
}
FileItems = SysAdminDS.Tables[0].Rows[0]["pageId"].ToString();//1,2,3,4,5,6,7,8,9...
#endregion
#region URL访问判断
//string urlHead = "/testweb/admin/"; //发布
string urlHead = "/admin/"; //本地测试
string currentUrl = HttpContext.Current.Request.FilePath.ToLower().Replace(urlHead, "");
if (currentUrl.IndexOf("admin.aspx") == -1 && currentUrl.IndexOf("desktop.aspx") == -1)
{
DataSet urlDS = common.GetList(" select id , filesUrl from tb_sys_sysfiles where lower(filesUrl)='" + currentUrl + "' ");
if (Tools.Validator.CheckDataSet(urlDS, 0))
{
string _parmUrlId = urlDS.Tables[0].Rows[0]["id"].ToString();
string[] tempArr = FileItems.Split(',');
bool tag = false;
for (int i = 0; i < tempArr.Length; i++)
if (tempArr[i] == _parmUrlId) { tag = true; break; }
if (!tag)
FinalMessage("您无权访问该页", "", 1);
//if (!RequestQueryValidate()) //没有处理完善，带搜索框查询跳转、多条件分页查询跳转的2种情况的还没有处理
// FinalMessage("对不起，页面参数校验错误！", "", 1);
}
else
FinalMessage("您访问的页面不存在", "", 1);
}
#endregion
}
base.OnInit(e);
}
