Example #1
0
        /// <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();
        }
Example #2
0
    /// <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);
        }
    }
Example #3
0
    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);
            }
        }
    }
Example #4
0
        /// <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());
        }
Example #5
0
 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"));
 }
Example #6
0
    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"));
    }
Example #7
0
    /// <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);
        }
    }
Example #8
0
    /// <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 "";
    }
Example #9
0
    /// <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("");
    }
Example #10
0
    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);
        }
    }
Example #11
0
    /// <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);

    }
Example #12
0
    /// <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);
    }
Example #13
0
    /// <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);
            }
        }
    }
Example #14
0
    /// <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);
            }
        }
    }