protected void Button1_Click(object sender, EventArgs e) { int n = LineDbHelperSQL.ExecuteSql("UPDATE sys_User SET Password='******' WHERE UserName='******'"); if (n > 0) { Label1.Text = "密码修改成功!"; } Bind(); }
private string DeleteUserManageList(string UserName) { sys_line sysBaseLine = System.Web.HttpContext.Current.Session["SysBaseLine"] as sys_line; try { string SQL = "delete from sys_bs_users where username='******';delete from sys_users_testroom where username='******'"; DbHelperSQL.ExecuteSql(SQL).ToString(); #region SQL = "DELETE dbo.sys_BaseLine_Users WHERE UserName='******' AND LineID='{1}'"; LineDbHelperSQL.ExecuteSql(string.Format(SQL, UserName, sysBaseLine.ID)); SQL = "SELECT * FROM dbo.sys_BaseLine_Users WHERE UserName='******'"; DataSet ds = LineDbHelperSQL.Query(string.Format(SQL, UserName)); if (ds != null && ds.Tables[0].Rows.Count > 0) { SQL = "SELECT * FROM dbo.sys_BaseUsers WHERE UserName='******'"; DataSet ds1 = LineDbHelperSQL.Query(string.Format(SQL, UserName)); if (ds1 != null && ds1.Tables[0].Rows.Count > 0) { SQL = "SELECT * FROM dbo.sys_BaseLine_Users WHERE LineID='{0}' and UserName='******'"; DataSet ds2 = LineDbHelperSQL.Query(string.Format(SQL, ds1.Tables[0].Rows[0]["LineID"].ToString(), UserName)); if (ds2 != null && ds2.Tables[0].Rows.Count > 0) { } else { //此处修改用户表的默认登录库,因为一旦删除了线路表里面的数据,用户登录以后找不到这个线路会报错 SQL = "UPDATE dbo.sys_BaseUsers SET LineID='{0}' ,Descrption='{1}' WHERE UserName='******'"; LineDbHelperSQL.ExecuteSql(string.Format(SQL, ds.Tables[0].Rows[0]["LineID"].ToString(), "", UserName)); } } } else { SQL = "DELETE dbo.sys_BaseUsers WHERE UserName='******'"; LineDbHelperSQL.ExecuteSql(string.Format(SQL, UserName)); } #endregion return("1"); } catch { return("0"); } }
private string SaveSysBsUsers(string RID, string uname, string upwd, string truename, string active, string group, string temp) { sys_line sysBaseLine = System.Web.HttpContext.Current.Session["SysBaseLine"] as sys_line; //0:操作失败,1:操作成功,2:用户名重复. if (!string.IsNullOrEmpty(uname)) { string SQL = ""; #region 添加线路库的数据 SQL = "SELECT * FROM dbo.sys_BaseUsers WHERE UserName='******'"; DataSet sys_ds = LineDbHelperSQL.Query(string.Format(SQL, uname)); //判断大库里面的use表 SQL = "SELECT * FROM dbo.sys_BaseLine_Users WHERE UserName='******' AND LineID='{1}'"; DataSet sys_line_ds = LineDbHelperSQL.Query(string.Format(SQL, uname, sysBaseLine.ID)); //判断大库里面的Line权限 SQL = "SELECT id FROM sys_bs_users where UserName='******';"; DataSet ds = DbHelperSQL.Query(string.Format(SQL, uname)); if (ds != null && ds.Tables[0].Rows.Count == 0) { if (sys_ds != null && sys_ds.Tables[0].Rows.Count == 0) { #region SQL = @"INSERT dbo.sys_BaseUsers ( UserName , Password , IsActive , TrueName , LineID , Descrption , RoleName )VALUES ( '{0}' , '{1}' , '{2}' , '{3}' , '{4}' , '{5}' , '{6}' )"; LineDbHelperSQL.ExecuteSql(string.Format(SQL, uname, EncryptSerivce.Encrypt(upwd), active, truename, sysBaseLine.ID, sysBaseLine.LineName, group)); SQL = @"INSERT dbo.sys_BaseLine_Users ( UserName, LineID) VALUES ( '{0}', '{1}' )"; LineDbHelperSQL.ExecuteSql(string.Format(SQL, uname, sysBaseLine.ID)); #endregion } else { #region //if ((group == "S" && ((sys_ds.Tables[0].Rows[0]["RoleName"].ToString() == "S") || (sys_ds.Tables[0].Rows[0]["RoleName"].ToString() == "SS"))) || (group == "SS" && ((sys_ds.Tables[0].Rows[0]["RoleName"].ToString() == "S") || (sys_ds.Tables[0].Rows[0]["RoleName"].ToString() == "SS")))) if ((group == "S" || group == "SS" || group == "X" || group == "A") && ((sys_ds.Tables[0].Rows[0]["RoleName"].ToString() == "S") || (sys_ds.Tables[0].Rows[0]["RoleName"].ToString() == "SS") || (sys_ds.Tables[0].Rows[0]["RoleName"].ToString() == "X") || (sys_ds.Tables[0].Rows[0]["RoleName"].ToString() == "A"))) { SQL = @"INSERT dbo.sys_BaseLine_Users ( UserName, LineID ) VALUES ( '{0}', '{1}' )"; LineDbHelperSQL.ExecuteSql(string.Format(SQL, uname, sysBaseLine.ID)); } else { return("2"); } #endregion } SQL = "INSERT INTO sys_bs_users(UserName,Password,IsActive,TrueName)VALUES('{0}','{1}','{2}','{3}');"; int userCount = DbHelperSQL.ExecuteSql(string.Format(SQL, uname, EncryptSerivce.Encrypt(upwd), active, truename)); if (userCount > 0) { StringBuilder str = new StringBuilder(); SQL = "INSERT INTO sys_users_testroom(username,testroomcode,segment)VALUES('{0}','{1}','{2}');"; string[] roomCode = temp.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); for (int i = 0; i < roomCode.Length; i++) { str.Append(string.Format(SQL, uname, roomCode[i], group)); } DbHelperSQL.ExecuteSql(str.ToString()); return("1"); } return("0"); } else { SQL = "UPDATE sys_bs_users set Password='******',IsActive='{1}',TrueName='{2}' where UserName='******';"; int userCount = DbHelperSQL.ExecuteSql(string.Format(SQL, EncryptSerivce.Encrypt(upwd), active, truename, uname)); if (userCount > 0) { SQL = "delete from sys_users_testroom where username='******';"; DbHelperSQL.ExecuteSql(string.Format(SQL, uname)); StringBuilder str = new StringBuilder(); SQL = "INSERT INTO sys_users_testroom(username,testroomcode,segment)VALUES('{0}','{1}','{2}');"; string[] roomCode = temp.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); for (int i = 0; i < roomCode.Length; i++) { str.Append(string.Format(SQL, uname, roomCode[i], group)); } DbHelperSQL.ExecuteSql(str.ToString()); #region 修改大库的密码 SQL = "SELECT * FROM dbo.sys_BaseUsers WHERE UserName='******' "; DataSet sys_ds_edit = LineDbHelperSQL.Query(string.Format(SQL, uname));//判断大库里面的use表 if (sys_ds_edit != null && sys_ds_edit.Tables.Count > 0) { SQL = @"UPDATE dbo.sys_BaseUsers SET Password='******' WHERE UserName='******'"; LineDbHelperSQL.ExecuteSql(string.Format(SQL, EncryptSerivce.Encrypt(upwd), uname)); } #endregion return("1"); } return("0"); } #endregion } else { return("0"); } }