/// <summary> /// 加载用户菜单 /// </summary> /// <param name="ds">系统所有菜单</param> /// <param name="FileItems">用户权限页面id集合</param> /// <returns></returns> public string GetSystemMenu(DataSet ds, string FileItems) { if (ds == null || string.IsNullOrEmpty(FileItems)) return ""; StringBuilder strbu = new StringBuilder(""); int tempCount = ds.Tables[0].Rows.Count; for (int i = 0; i < tempCount; i++) { Test_BUL.sys_Common common = new sys_Common(); DataSet tempChildDs = common.GetList(" select * from tb_sys_sysfiles where id in(" + FileItems + ") and showLeft=1 and ClassId=" + ds.Tables[0].Rows[i]["id"].ToString()); if (sysCheck.CheckDataSet(tempChildDs, 0)) { strbu.Append(" <dl> ");//start nod strbu.Append(" <dt><span style=\"background-image: url(" + ds.Tables[0].Rows[i]["imgUrl"].ToString() + ");\">" + ds.Tables[0].Rows[i]["menuName"].ToString() + "</span></dt> "); strbu.Append(" <dd class=\"hide\"><ul> "); for (int j = 0; j < tempChildDs.Tables[0].Rows.Count; j++)//add Child Node { strbu.Append(" <li><a href=\"./" + tempChildDs.Tables[0].Rows[j]["filesUrl"].ToString() + "\" target=\"main_iframe\" >" + tempChildDs.Tables[0].Rows[j]["fielsName"].ToString() + "</a></li> "); } strbu.Append(" </ul></dd> "); strbu.Append(" </dl> ");//end nod } } return strbu.ToString(); }
/// <summary> /// 更新密码操作 /// </summary> protected void btnCon_Click(object sender, EventArgs e) { string relpwd = this.txtrelpwd.Value.Trim(); string newpwd = this.txtnewpwd.Value.Trim(); string chkpwd = this.txtchkpwd.Value.Trim(); if (string.IsNullOrEmpty(relpwd) || string.IsNullOrEmpty(newpwd) || string.IsNullOrEmpty(chkpwd)) { FinalMessage("输入不完整或网络错误", "Edit_Psssword.aspx", 1); } if (newpwd != chkpwd) { FinalMessage("新密码两次输入不一致", "Edit_Psssword.aspx", 1); } if (newpwd.Length < 6 || newpwd.Length > 16) { FinalMessage("新密码长度与要求不符", "Edit_Psssword.aspx", 1); } Test_BUL.sys_Common common = new Test_BUL.sys_Common(); string strsql = " update tb_sys_userinfo set password='******' where id=" + ID + " and password='******' "; if (common.ExecuteSql(strsql) > 0) { Response.Redirect("Manage_Member.aspx"); } else { FinalMessage("修改失败", "Edit_Psssword.aspx", 1); } }
protected void btnSend_Click(object sender, EventArgs e) { Test_BUL.sys_Common common = new Test_BUL.sys_Common(); DataSet ds = common.GetList(" select menuName from tb_sys_sysmenu where menuName='" + this.txtMenuName.Value.Trim() + "' "); if (!Tools.Validator.CheckDataSet(ds, 0)) { Test_Model.sys_sysmenu sysmenuModel = new Test_Model.sys_sysmenu(); sysmenuModel.menuName = this.txtMenuName.Value.Trim(); string imgUrl = this.txtMenuImg.Value.Trim(); sysmenuModel.imgUrl = imgUrl != "" ? imgUrl : "../Images/Ico/null.gif"; sysmenuModel.menuOrder = Tools.StringHelp.GetInt(this.txtIntOrder.Value.Trim()); sysmenuModel.addName = adminGetCount; sysmenuModel.addTime = DateTime.Now; Test_BUL.sys_sysmenu sysmenu = new Test_BUL.sys_sysmenu(); if (sysmenu.Add(sysmenuModel) > 0) { Response.Redirect("Manage_Menu.aspx"); } else { FinalMessage("新增用户失败!", "Add_Menu.aspx", 1); } } }
/// <summary> /// 加载用户菜单 /// </summary> /// <param name="ds">系统所有菜单</param> /// <param name="FileItems">用户权限页面id集合</param> /// <returns></returns> public string GetSystemMenu(DataSet ds, string FileItems) { if (ds == null || string.IsNullOrEmpty(FileItems)) { return(""); } StringBuilder strbu = new StringBuilder(""); int tempCount = ds.Tables[0].Rows.Count; for (int i = 0; i < tempCount; i++) { Test_BUL.sys_Common common = new sys_Common(); DataSet tempChildDs = common.GetList(" select * from tb_sys_sysfiles where id in(" + FileItems + ") and showLeft=1 and ClassId=" + ds.Tables[0].Rows[i]["id"].ToString()); if (sysCheck.CheckDataSet(tempChildDs, 0)) { strbu.Append(" <dl> ");//start nod strbu.Append(" <dt><span style=\"background-image: url(" + ds.Tables[0].Rows[i]["imgUrl"].ToString() + ");\">" + ds.Tables[0].Rows[i]["menuName"].ToString() + "</span></dt> "); strbu.Append(" <dd class=\"hide\"><ul> "); for (int j = 0; j < tempChildDs.Tables[0].Rows.Count; j++)//add Child Node { strbu.Append(" <li><a href=\"./" + tempChildDs.Tables[0].Rows[j]["filesUrl"].ToString() + "\" target=\"main_iframe\" >" + tempChildDs.Tables[0].Rows[j]["fielsName"].ToString() + "</a></li> "); } strbu.Append(" </ul></dd> "); strbu.Append(" </dl> ");//end nod } } return(strbu.ToString()); }
private void BindProvince() { Test_BUL.sys_Common common = new Test_BUL.sys_Common(); string strb = " select CapitalName,DomainID from tb_sys_capital "; DataSet ds = common.GetList(strb.ToString()); Tools.WebControl.BindList(this.ddlProcince, ds.Tables[0], "CapitalName", "DomainID"); this.ddlProcince.Items.Insert(0, new ListItem("——请选中——", "-1")); }
/// <summary> /// 更新数据 /// </summary> protected void btnCon_Click(object sender, EventArgs e) { string _name = this.txtName.Value.Trim(); string _value = this.txtValue.Value.Trim(); string _typetag = this.txtTypeTag.Value.Trim(); if (string.IsNullOrEmpty(_name) || string.IsNullOrEmpty(_typetag)) { FinalMessage("请确认所填信息的完整性", "Add_SysParam.aspx", 1); } if (Tools.RequestCheck.CheckKeyWord(_name) || Tools.RequestCheck.CheckKeyWord(_typetag)) { FinalMessage("参数名或类型标记含有非法字符", "Add_SysParam.aspx", 1); } if (!Tools.Validator.IsPositiveInt(_value)) { FinalMessage("参数值应为正整数", "Add_SysParam.aspx", 1); } Test_BUL.sys_Common common = new Test_BUL.sys_Common(); DataSet temds = common.GetList(" select id, name from tb_sys_paramcenter where name='" + (this.txtName.Value) + "' and typeTag='" + (this.txtTypeTag.Value) + "' "); if (Tools.Validator.CheckDataSet(temds, 0)) { if (temds.Tables[0].Rows.Count > 1) { FinalMessage("此参数名已经存在", "Add_SysParam.aspx", 1); } else if (temds.Tables[0].Rows[0]["id"].ToString() != ID) { FinalMessage("此参数名已经存在", "Add_SysParam.aspx", 1); } } modelparma.id = Tools.StringHelp.GetInt(ID); modelparma.name = _name; modelparma.value = Tools.StringHelp.GetInt(_value); modelparma.typeTag = Tools.StringHelp.CutStirngNormal(_typetag, 10, 0); modelparma.addUserId = Tools.StringHelp.GetInt(adminGetId); modelparma.addUserName = adminGetCount; modelparma.addTime = DateTime.Now; if (bulparam.Update(modelparma)) { Response.Redirect("Manage_SysParam.aspx?p=" + p); } else { FinalMessage("保存失败", "Add_SysParam.aspx", 1); } }
/// <summary> /// 获取菜单HTML /// </summary> /// <returns></returns> private string GetMenuHTML() { if (string.IsNullOrEmpty(FileItems)) return ""; Test_BUL.sys_Common common = new Test_BUL.sys_Common(); DataSet ds = common.GetList(" select id,menuName,imgUrl from tb_sys_sysmenu order by menuOrder asc "); if (Tools.Validator.CheckDataSet(ds, 0)) { Test_BUL.sys_sysmenu bulMenu = new Test_BUL.sys_sysmenu(); return bulMenu.GetSystemMenu(ds, FileItems); } return ""; }
/// <summary> /// 获取菜单HTML /// </summary> /// <returns></returns> private string GetMenuHTML() { if (string.IsNullOrEmpty(FileItems)) { return(""); } Test_BUL.sys_Common common = new Test_BUL.sys_Common(); DataSet ds = common.GetList(" select id,menuName,imgUrl from tb_sys_sysmenu order by menuOrder asc "); if (Tools.Validator.CheckDataSet(ds, 0)) { Test_BUL.sys_sysmenu bulMenu = new Test_BUL.sys_sysmenu(); return(bulMenu.GetSystemMenu(ds, FileItems)); } return(""); }
protected void btnSend_Click(object sender, EventArgs e) { Test_BUL.sys_Common common = new Test_BUL.sys_Common(); DataSet ds = common.GetList(" select menuName from tb_sys_sysmenu where menuName='" + this.txtMenuName.Value.Trim() + "' "); if (!Tools.Validator.CheckDataSet(ds, 0)) { Test_Model.sys_sysmenu sysmenuModel = new Test_Model.sys_sysmenu(); sysmenuModel.menuName = this.txtMenuName.Value.Trim(); string imgUrl = this.txtMenuImg.Value.Trim(); sysmenuModel.imgUrl = imgUrl != "" ? imgUrl : "../Images/Ico/null.gif"; sysmenuModel.menuOrder = Tools.StringHelp.GetInt(this.txtIntOrder.Value.Trim()); sysmenuModel.addName = adminGetCount; sysmenuModel.addTime = DateTime.Now; Test_BUL.sys_sysmenu sysmenu = new Test_BUL.sys_sysmenu(); if (sysmenu.Add(sysmenuModel) > 0) Response.Redirect("Manage_Menu.aspx"); else FinalMessage("新增用户失败!", "Add_Menu.aspx", 1); } }
/// <summary> /// 更新密码操作 /// </summary> protected void btnCon_Click(object sender, EventArgs e) { string relpwd = this.txtrelpwd.Value.Trim(); string newpwd = this.txtnewpwd.Value.Trim(); string chkpwd = this.txtchkpwd.Value.Trim(); if (string.IsNullOrEmpty(relpwd) || string.IsNullOrEmpty(newpwd) || string.IsNullOrEmpty(chkpwd)) FinalMessage("输入不完整或网络错误", "Edit_Psssword.aspx", 1); if (newpwd != chkpwd) FinalMessage("新密码两次输入不一致", "Edit_Psssword.aspx", 1); if (newpwd.Length < 6 || newpwd.Length > 16) FinalMessage("新密码长度与要求不符", "Edit_Psssword.aspx", 1); Test_BUL.sys_Common common = new Test_BUL.sys_Common(); string strsql = " update tb_sys_userinfo set password='******' where id=" + ID + " and password='******' "; if (common.ExecuteSql(strsql) > 0) Response.Redirect("Manage_Member.aspx"); else FinalMessage("修改失败", "Edit_Psssword.aspx", 1); }
/// <summary> /// 更新数据 /// </summary> protected void btnCon_Click(object sender, EventArgs e) { string _name = this.txtName.Value.Trim(); string _value = this.txtValue.Value.Trim(); string _typetag = this.txtTypeTag.Value.Trim(); if (string.IsNullOrEmpty(_name) || string.IsNullOrEmpty(_typetag)) FinalMessage("请确认所填信息的完整性", "Add_SysParam.aspx", 1); if (Tools.RequestCheck.CheckKeyWord(_name) || Tools.RequestCheck.CheckKeyWord(_typetag)) FinalMessage("参数名或类型标记含有非法字符", "Add_SysParam.aspx", 1); if (!Tools.Validator.IsPositiveInt(_value)) FinalMessage("参数值应为正整数", "Add_SysParam.aspx", 1); Test_BUL.sys_Common common = new Test_BUL.sys_Common(); DataSet temds = common.GetList(" select id, name from tb_sys_paramcenter where name='" + (this.txtName.Value) + "' and typeTag='" + (this.txtTypeTag.Value) + "' "); if (Tools.Validator.CheckDataSet(temds, 0)) { if (temds.Tables[0].Rows.Count > 1) FinalMessage("此参数名已经存在", "Add_SysParam.aspx", 1); else if (temds.Tables[0].Rows[0]["id"].ToString() != ID) FinalMessage("此参数名已经存在", "Add_SysParam.aspx", 1); } modelparma.id = Tools.StringHelp.GetInt(ID); modelparma.name = _name; modelparma.value = Tools.StringHelp.GetInt(_value); modelparma.typeTag = Tools.StringHelp.CutStirngNormal(_typetag, 10, 0); modelparma.addUserId = Tools.StringHelp.GetInt(adminGetId); modelparma.addUserName = adminGetCount; modelparma.addTime = DateTime.Now; if (bulparam.Update(modelparma)) Response.Redirect("Manage_SysParam.aspx?p=" + p); else FinalMessage("保存失败", "Add_SysParam.aspx", 1); }
/// <summary> /// 按钮操作 /// </summary> protected void rpt_Mod_ItemCommand(object source, RepeaterCommandEventArgs e) { Test_BUL.sys_Common common = new Test_BUL.sys_Common(); HiddenField hfGetId = (HiddenField)e.Item.FindControl("hfGetId"); int id = Tools.StringHelp.GetInt(hfGetId.Value); if (e.CommandName == "freeze") { try { if (common.ExecuteSql(" update tb_sys_admin set AccountState=20 where id=" + id) > 0) { DataBind_role(); foreach (RepeaterItem rpItem in rpt_Mod.Items) { LinkButton lbbDel = (LinkButton)rpItem.FindControl("lblfreeze"); lbbDel.Attributes.Add("onclick", "if(!confirm('确定禁用吗?')) return false;"); } } } catch (Exception ex) { Response.Write("<script>alert('冻结失败:" + ex.Message + "');</script>"); } } if (e.CommandName == "open") { try { if (common.ExecuteSql(" update tb_sys_admin set AccountState=10 where id=" + id) > 0) { DataBind_role(); foreach (RepeaterItem rpItem in rpt_Mod.Items) { LinkButton lbbDel = (LinkButton)rpItem.FindControl("lblopen"); lbbDel.Attributes.Add("onclick", "if(!confirm('确定启用吗?')) return false;"); } } } catch (Exception ex) { Response.Write("<script>alert('启用失败:" + ex.Message + "');</script>"); } } if (e.CommandName == "del") { try { if (common.Delete("tb_sys_admin", id)) { DataBind_role(); foreach (RepeaterItem rpItem in rpt_Mod.Items) { LinkButton lbbDel = (LinkButton)rpItem.FindControl("lblDelete"); lbbDel.Attributes.Add("onclick", "if(!confirm('确定删除吗?')) return false;"); } } } catch (Exception ex) { FinalMessage("删除失败" + ex.Message, "Manage_SysUser.aspx", 1); } } }