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