systemManagement/rightModify.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using Eclipse.HRM.UI;
namespace Test.Traing
{
    public partial class rightMoify : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void Button1_Click(object sender, EventArgs e)
        {
           String userid = Session["loginName"].ToString();
            SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=Eclipse_HRM;Persist Security Info=True;User ID=sa;Password=51Aspx");
            int rightl=0;
            if (rightmodifyDpDLt.SelectedValue == "管理员权限")
                rightl = 2;
           if(rightmodifyDpDLt.SelectedValue=="部门经理")
               rightl = 1;
           if (rightmodifyDpDLt.SelectedValue == "普通用户")
               rightl = 0;
           string sqlrightmodify = "Update userlist Set [right]='" + rightl + "' where user_ID='"+rightModifyID.Text+"'";
           string sql = "select * from userlist where user_ID=" + rightModifyID.Text;
           if (DBhelper.GetDataTable(sql).Rows.Count != 0)//判断用户是否存在
            {
                DBhelper.ExeQuery(sqlrightmodify);
                Response.Write("<script>alert('权限已修改！')</script>");
            }
            else
                Response.Write("<script>alert('此用户不存在！')</script>");

        }

        protected void Button2_Click(object sender, EventArgs e)
        {
            rightModifyID.Text = null;
        }
    }
}