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");
}
}
