protected override void OnInit(EventArgs e) { try { string UserName = HttpContext.Current.Server.UrlDecode(Request.Cookies["Fadmin"]["UserName"].ToString()); string PassWord = HttpContext.Current.Server.UrlDecode(Request.Cookies["Fadmin"]["PassWord"].ToString()); string tableName = "Sys_Admin"; string sqlWhere = " and AUserName='******' and APassWord='******'"; string showField = "top 1 Id"; DataTable dt_user = new HoneyWell.BLL.Sys_Public().SelectData(showField, tableName, sqlWhere).Tables[0]; if (dt_user == null || dt_user.Rows.Count <= 0) { Response.Write("<script language='javascript'>"); Response.Write("window.alert('非法登陆系统!');"); Response.Write("location.href='" + ResolveUrl("~/") + "Friend.aspx';"); Response.Write("</script>"); Response.End(); } } catch (Exception) { Response.Write("<script language='javascript'>"); Response.Write("window.alert('异常登陆系统1!');"); Response.Write("location.href='" + ResolveUrl("~/") + "Friend.aspx';"); Response.Write("</script>"); } base.OnInit(e); }
/// <summary> /// 初始化角色-更新 /// </summary> void InitDutyUpdate() { DataTable dt = new HoneyWell.BLL.Sys_Public().SelectData(" ID,DutyName", "Sys_Duty", " order by DutyDesc").Tables[0]; string str_selected = ""; StringBuilder sbDuty = new StringBuilder(); //拼接HTML-角色 if (DutyID == 0) { str_selected = "selected=\"selected\""; } sbDuty.Append("<option value='0' " + str_selected + ">==请选择==</option>"); foreach (DataRow dr in dt.Rows) { if (StringHelper.NullToInt(dr["ID"]) == DutyID) { sbDuty.Append("<option value=" + StringHelper.NullToInt(dr["ID"]) + " selected=\"selected\">" + StringHelper.NullToStr(dr["DutyName"]) + "</option>"); } else { sbDuty.Append("<option value=" + StringHelper.NullToInt(dr["ID"]) + " >" + StringHelper.NullToStr(dr["DutyName"]) + "</option>"); } } DutyStr = sbDuty.ToString(); }
protected void btnDel_Click(object sender, EventArgs e) { int result = 0; if (Utils.ToInt(nodeValue) > 0) { HoneyWell.Model.Sys_Menu info = new HoneyWell.BLL.Sys_Menu().GetModel(Convert.ToInt32(nodeValue)); HoneyWell.Model.Sys_Logs logs = new HoneyWell.Model.Sys_Logs(); logs.ID = 0; logs.DutyId = Utils.ToInt(GetDutyId()); logs.LoginName = GetUserName(); logs.TitleName = "模块管理"; logs.Depicts = "删除模块信息,名称为:" + info.MenuNameC + ""; logs.CreateTime = DateTime.Now; logs.IpAddress = Request.UserHostAddress; logs.MoreCol1 = ""; logs.MoreCol2 = ""; new HoneyWell.BLL.Sys_Logs().Add(logs); result = new HoneyWell.BLL.Sys_Public().Delete("Sys_Menu", " ID=" + Utils.ToInt(nodeValue) + ""); } if (result > 0) { ScriptManager.RegisterClientScriptBlock(btnSave, GetType(), "", "alert('操作成功!');parent.location='sys_Module_Tree.aspx'", true); } }
public void pageBind() { string strWhere = " "; if (txtDutyId.SelectedValue.Trim().Length > 0) { strWhere += " and DutyId = '" + txtDutyId.SelectedValue.Trim() + "'"; } if (txt_TitleName.Value.Trim().Length > 0) { strWhere += " and TitleName like '%" + txt_TitleName.Value.Trim() + "%'"; } if (txt_Depicts.Value.Trim().Length > 0) { strWhere += " and Depicts like '%" + txt_Depicts.Value.Trim() + "%'"; } string tableName = "Sys_Logs"; string showField = " ID,DutyId,LoginName,TitleName,Depicts,IpAddress,CreateTime"; string orderField = "ID"; int count = 0; DataSet ds = new HoneyWell.BLL.Sys_Public().GetList(tableName, showField, orderField, MyPager.Pagesize, MyPager.Pageindex + 1, 0, strWhere, out count); rptLoop.DataSource = ds; rptLoop.DataBind(); MyPager.Count = count; }
protected void btnSave_Click(object sender, EventArgs e) { bool result = false; HoneyWell.Model.Sys_Area area = SetObjectValue(); if (nodeValue != "") { //判断区域代码是否重复 DataSet ds = new HoneyWell.BLL.Sys_Public().SelectData("top 1 ID", "Sys_Area", " and AreaCode='" + txt_ClassCode.Value.Trim() + "' and AreaCode<>'" + nodeValue + "'"); if (ds != null && ds.Tables[0].Rows.Count > 0) { Response.Write("<script language='javascript'>alert('您输入的区域代码已存在,请重新输入!');location.href='sys_Area_Manage.aspx?nodeText=" + nodeText + "&nodeValue=" + nodeValue + "'</script>"); Response.End(); } //判断区域名称是否重复 DataSet ds1 = new HoneyWell.BLL.Sys_Public().SelectData("top 1 ID", "Sys_Area", " and AreaName='" + txt_ClassName.Value.Trim() + "' and AreaCode<>'" + nodeValue + "'"); if (ds1 != null && ds1.Tables[0].Rows.Count > 0) { Response.Write("<script language='javascript'>alert('您输入的区域名称已存在,请重新输入!');location.href='sys_Area_Manage.aspx?nodeText=" + nodeText + "&nodeValue=" + nodeValue + "'</script>"); Response.End(); } result = new HoneyWell.BLL.Sys_Area().Update(area); } if (true) { ScriptManager.RegisterClientScriptBlock(btnSave, GetType(), "", "alert('操作成功!');location.href='sys_Area_Manage.aspx?nodeText=" + nodeText + "&nodeValue=" + nodeValue + "'", true); } }
public void pageBind() { string strWhere = " "; if (txtDutyId.SelectedValue.Trim().Length > 0) { strWhere += " and DutyId = '" + txtDutyId.SelectedValue.Trim() + "'"; } if (txtLoginName.Value.Trim().Length > 0) { strWhere += " and AUserName ='******'"; } string tableName = "Sys_Admin"; string showField = " ID,DutyId,AUserName,Remark,ModifyTime"; string orderField = "ID"; int count = 0; DataSet ds = new HoneyWell.BLL.Sys_Public().GetList(tableName, showField, orderField, MyPager.Pagesize, MyPager.Pageindex + 1, 0, strWhere, out count); rptLoop.DataSource = ds; rptLoop.DataBind(); MyPager.Count = count; }
public string GetDuty(string DutyId) { string Type_Str = ""; DataTable dt = new HoneyWell.BLL.Sys_Public().SelectData("top 1 DutyName", "Sys_Duty", " and ID='" + DutyId + "'").Tables[0]; if (dt.Rows.Count > 0) { Type_Str = dt.Rows[0]["DutyName"].ToString(); } return(Type_Str); }
/// <summary> /// 初始化角色-新增 /// </summary> void InitDutyAdd() { BLL.Sys_Duty sys_duty_bll = new BLL.Sys_Duty(); DataTable dt = new HoneyWell.BLL.Sys_Public().SelectData(" ID,DutyName", "Sys_Duty", " order by DutyDesc").Tables[0]; StringBuilder sbDuty = new StringBuilder(); //拼接HTML-角色 sbDuty.Append("<option value='0'>==请选择==</option>"); foreach (DataRow dr in dt.Rows) { sbDuty.Append("<option value=" + StringHelper.NullToInt(dr["ID"]) + " >" + StringHelper.NullToStr(dr["DutyName"]) + "</option>"); } DutyStr = sbDuty.ToString(); }
public void BindDuty() { txtDutyId.Items.Clear(); ListItem item1 = new ListItem("==请选择==", ""); txtDutyId.Items.Add(item1); DataTable dt = new HoneyWell.BLL.Sys_Public().SelectData(" ID,DutyName", "sys_Duty", " order by DutyDesc").Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { ListItem item = new ListItem(); item.Text = dt.Rows[i]["DutyName"].ToString(); item.Value = dt.Rows[i]["ID"].ToString(); txtDutyId.Items.Add(item); } }
public void pageBind() { string strWhere = " "; if (txt_DutyName.Value.Trim().Length > 0) { strWhere += " and DutyName like '%" + txt_DutyName.Value.Trim() + "%'"; } string tableName = "Sys_Duty"; string showField = " ID,DutyName,DutyDesc,CreateUser,CreateTime"; string orderField = "ID"; int count = 0; DataSet ds = new HoneyWell.BLL.Sys_Public().GetList(tableName, showField, orderField, MyPager.Pagesize, MyPager.Pageindex + 1, 0, strWhere, out count); rptLoop.DataSource = ds; rptLoop.DataBind(); MyPager.Count = count; }
protected void btnDel_Click(object sender, EventArgs e) { int result = 0; string tableName = "Sys_Area"; string showField = " top 1 ID"; string strWhere = " and AreaCode='" + nodeValue + "'"; DataTable dt = new BLL.Sys_Public().SelectData(showField, tableName, strWhere).Tables[0]; if (dt != null && dt.Rows.Count > 0) { nodeId = Utils.ToInt(dt.Rows[0]["ID"].ToString()); } if (nodeId > 0) { HoneyWell.Model.Sys_Area info = new HoneyWell.BLL.Sys_Area().GetModel(nodeId); HoneyWell.Model.Sys_Logs logs = new HoneyWell.Model.Sys_Logs(); logs.ID = 0; logs.DutyId = Utils.ToInt(GetDutyId()); logs.LoginName = GetUserName(); logs.TitleName = "区域管理"; logs.Depicts = "删除区域信息,名称为:" + info.AreaName + ""; logs.CreateTime = DateTime.Now; logs.IpAddress = Request.UserHostAddress; logs.MoreCol1 = ""; logs.MoreCol2 = ""; new HoneyWell.BLL.Sys_Logs().Add(logs); result = new HoneyWell.BLL.Sys_Public().Delete("Sys_Area", " ID=" + nodeId + ""); } if (result > 0) { ScriptManager.RegisterClientScriptBlock(btnSave, GetType(), "", "alert('操作成功!');parent.location='sys_Area_Tree.aspx'", true); } }
/// <summary> /// 页面权限验证 /// </summary> public void CheckUrlUser() { System.Web.UI.Page page = HttpContext.Current.CurrentHandler as System.Web.UI.Page; try { string strUrl = HttpContext.Current.Request.FilePath; string UserName = HttpContext.Current.Server.UrlDecode(HttpContext.Current.Request.Cookies["Fadmin"]["UserName"].ToString()); string PassWord = HttpContext.Current.Server.UrlDecode(HttpContext.Current.Request.Cookies["Fadmin"]["PassWord"].ToString()); string tableName = "V_Sys_Admin"; string sqlWhere = " and AUserName='******' and APassWord='******'"; string showField = "top 1 MenuSetting"; DataTable dt_user = new HoneyWell.BLL.Sys_Public().SelectData(showField, tableName, sqlWhere).Tables[0]; if (dt_user != null && dt_user.Rows.Count > 0) { string MenuSetting = dt_user.Rows[0]["MenuSetting"].ToString(); string sqlWhere1 = " and ID in (" + MenuSetting + ")"; DataTable dt_menu = new HoneyWell.BLL.Sys_Public().SelectData("MenuUrl", "Sys_Menu", sqlWhere1).Tables[0]; if (dt_menu != null && dt_menu.Rows.Count > 0) { int k = 0; for (int i = 0; i < dt_menu.Rows.Count; i++) { if (dt_menu.Rows[i]["MenuUrl"].ToString() == strUrl) { k += 1; } } if (k <= 0) { HttpContext.Current.Response.Write("<script language='javascript'>"); HttpContext.Current.Response.Write("window.alert('您没有权限查看该页面!');"); HttpContext.Current.Response.Write("window.close();"); HttpContext.Current.Response.Write("</script>"); HttpContext.Current.Response.End(); } } else { HttpContext.Current.Response.Write("<script language='javascript'>"); HttpContext.Current.Response.Write("window.alert('异常登陆系统1!');"); HttpContext.Current.Response.Write("window.close();"); HttpContext.Current.Response.Write("</script>"); HttpContext.Current.Response.End(); } } else { HttpContext.Current.Response.Write("<script language='javascript'>"); HttpContext.Current.Response.Write("window.alert('异常登陆系统2!');"); HttpContext.Current.Response.Write("window.close();"); HttpContext.Current.Response.Write("</script>"); HttpContext.Current.Response.End(); } } catch (Exception) { HttpContext.Current.Response.Write("<script language='javascript'>"); HttpContext.Current.Response.Write("window.alert('异常登陆系统3!');"); HttpContext.Current.Response.Write("window.close();"); HttpContext.Current.Response.Write("</script>"); HttpContext.Current.Response.End(); } }
public void BindMenu() { string MenuSetting = ""; string TableName = "Sys_Duty"; string ShowField = " top 1 MenuSetting"; string OrderField = " and ID='" + Request.Cookies["Fadmin"]["DutyID"].ToString() + "'"; DataTable dt_user = new HoneyWell.BLL.Sys_Public().SelectData(ShowField, TableName, OrderField).Tables[0]; if (dt_user != null && dt_user.Rows.Count > 0) { MenuSetting = dt_user.Rows[0]["MenuSetting"].ToString(); } else { Response.Write("<script language='javascript'>alert('非法登陆系统后台@!');selfIn.location.href='Friend.aspx';</script>"); Response.End(); } DataTable dt1 = new HoneyWell.BLL.Sys_Menu().GroupMenuTree("", " and ID in (select ParentID from Sys_Menu where ID in(" + MenuSetting + ") group by ParentID) and MenuLevel='1' order by MenuOrder").Tables[0]; for (int k = 0; k < dt1.Rows.Count; k++) { str_menu += "<div class=\"overall\">"; str_menu += " <div class=\"mainmenu\"><i></i><span>" + dt1.Rows[k]["MenuNameC"].ToString() + "</span> <b></b></div>"; str_menu += " <div class=\"submenu\">"; str_menu += " <ul>"; DataTable dt2 = new HoneyWell.BLL.Sys_Menu().GetMenuTree("", " and ID in (" + MenuSetting + ") and ParentID=" + dt1.Rows[k]["ID"].ToString() + " and MenuLevel='2' order by MenuOrder").Tables[0]; for (int j = 0; j < dt2.Rows.Count; j++) { DataTable dt3 = new HoneyWell.BLL.Sys_Menu().GetMenuTree("", " and ID in (" + MenuSetting + ") and ParentID=" + dt2.Rows[j]["ID"].ToString() + " and MenuLevel='3' order by MenuOrder").Tables[0]; if (dt3 != null && dt3.Rows.Count > 0) { str_menu += "<li>"; str_menu += " <div class=\"second\"><img src=\"images/line1.png\" class=\"dashe\" /><span>" + dt2.Rows[j]["MenuNameC"].ToString() + "</span><i ></i></div>"; str_menu += " <div class=\"three\">"; str_menu += " <ul>"; for (int m = 0; m < dt3.Rows.Count; m++) { string str_style1 = ""; if (dt3.Rows.Count - 1 == m && dt2.Rows.Count - 1 == j) { str_style1 = "style=\"border-bottom:none;\""; } else { str_style1 = ""; } str_menu += "<li " + str_style1 + "><img src=\"images/line1.png\" class=\"threeimg\" /><a href=\"" + dt3.Rows[m]["MenuUrl"].ToString() + "\" target=\"main\"><span>" + dt3.Rows[m]["MenuNameC"].ToString() + "</span></a> <i></i></li>"; } str_menu += " </ul>"; str_menu += " </div>"; } else { string str_style2 = ""; if (dt2.Rows.Count - 1 == j) { str_style2 = "style=\"border-bottom:none;\""; } else { str_style2 = ""; } str_menu += "<li>"; str_menu += " <div class=\"second\" " + str_style2 + "><img src=\"images/line1.png\" class=\"dashe\" /><a href=\"" + dt2.Rows[j]["MenuUrl"].ToString() + "\" target=\"main\"><span>" + dt2.Rows[j]["MenuNameC"].ToString() + "</span></a><i ></i></div>"; } str_menu += "</li>"; } str_menu += " </ul>"; str_menu += " </div>"; str_menu += " </div>"; } }