protected void btn_okchang_Click(object sender, EventArgs e)
{
try {
ua = (user)Session["Adminu"];
//Buckup.Buckup_ChangePower(ua.name, txt_name.Text, Hidden1.Value);
Buckup.Buckup_AccountOperation("修改账号权限", ua.name, clientIP, txt_name.Text, Hidden1.Value.Trim());
string id = SqlFunction.Sql_ReturnNumberES("select id from admin where user_name='" + txt_name.Text + "'");
string sql = "";
sql = string.Format(@"update admin set User_Name='{0}', User_Email='{1}',
phone='{2}', a_state='{3}', isadd='{4}', isupdate='{5}', isselect='{6}',
isdelete='{7}', isregedit='{8}', isexport='{9}' where id=" + id,
txt_name.Text, txt_email.Value, txt_phone.Value, ddl_s.SelectedIndex,
Convert.ToInt32(cb_add.Checked), Convert.ToInt32(cb_update.Checked), Convert.ToInt32(cb_select.Checked),
Convert.ToInt32(cb_dele.Checked), Convert.ToInt32(cb_regedit.Checked), Convert.ToInt32(cb_export.Checked));
int r = SqlFunction.Sql_ReturnNumberENQ(sql);
if (r == 1)
{
LayerA("修改成功!", 6, Page);
}
else
{
LayerA("修改失败!错误信息:" + r, 5, Page);
}
} catch (Exception ee) {
LayerA("修改失败!错误信息:" + ee.Message, 5, Page);
}
}
protected void btn_deleteUser_Click(object sender, EventArgs e)
{
try {
ua = (user)Session["Adminu"];
Buckup.Buckup_AccountOperation("删除用户", ua.name, clientIP, txt_name.Text, "");
int r = SqlFunction.Sql_ReturnNumberENQ("delete from admin where user_name='" + info[0] + "'");
if (r == 1)
{
LayerA("删除成功!", 6, Page);
}
else
{
LayerA("删除失败!错误信息:" + r, 5, Page);
}
} catch (Exception ee) {
LayerA("删除失败!错误信息:" + ee.Message, 5, Page);
}
}
protected void btn_changepwd_Click(object sender, EventArgs e)
{
ua = (user)Session["Adminu"];
string clientIP = HttpContext.Current.Request.UserHostAddress;
string pwd = MD5pwd.MD5zsgc.MD5Entry(old_pwd.Value);
string newpwd = MD5pwd.MD5zsgc.MD5Entry(new_pwd.Value);
if (SqlFunction.Sql_ReturnNumberES("select user_pwd from admin where user_name='" + ua.name + "'") == pwd)
{
int jg = SqlFunction.Sql_ReturnNumberENQ("update admin set user_pwd='" + newpwd + "' where user_name='" + ua.name + "'");
if (jg == 1)
{
Buckup.Buckup_AccountOperation("更改密码", ua.name, ua.name, clientIP, string.Format("将原密码{0},更改成{1}", pwd, newpwd));
LayerA("修改成功", 6, Page);
}
}
else
{
LayerA("原密码错误", 5, Page);
}
}
//注册
protected void btn_r_ok_Click(object sender, EventArgs e)
{
string info = check();
if (Convert.ToInt32(SqlFunction.Sql_ReturnNumberES("select count(*) from admin where user_name='" + txt_name.Value + "'")) != 0)
{
LayerA("注册失败,已存在此用户", 5, Page);
return;
}
if (info == "") //检查注册信息
{
int[] bl;
bl = new int[6];
if (cb_add.Checked == true)
{
bl[0] = 1;
}
else
{
bl[0] = 0;
}
if (cb_update.Checked == true)
{
bl[2] = 1;
}
else
{
bl[1] = 0;
}
if (cb_select.Checked == true)
{
bl[3] = 1;
}
else
{
bl[2] = 0;
}
if (cb_dele.Checked == true)
{
bl[1] = 1;
}
else
{
bl[3] = 0;
}
if (cb_regedit.Checked == true)
{
bl[4] = 1;
}
else
{
bl[4] = 0;
}
if (cb_export.Checked == true)
{
bl[5] = 1;
}
else
{
bl[5] = 0;
}
string sql = "";
DateTime dt = DateTime.Now;
sql = string.Format(@"insert into Admin (User_Name,User_Pwd,
User_Email,phone,a_state,isadd,isupdate,isselect,isdelete,isregedit,isexport,creatTime)
values(" + "'" + txt_name.Value + "',"
+ "'" + MD5pwd.MD5zsgc.MD5Entry(this.txt_pwd.Value) + "',"
+ "'" + txt_email.Value + "',"
+ "'" + txt_phone.Value + "',"
+ "'" + ddl_s.Text + "',"
+ "'" + bl[0] + "',"
+ "'" + bl[1] + "',"
+ "'" + bl[2] + "',"
+ "'" + bl[3] + "',"
+ "'" + bl[4] + "',"
+ "'" + bl[5] + "',"
+ "'" + dt.ToString() + "')");
if (SqlFunction.Sql_ReturnNumberENQ(sql) == 1)
{
string power = "";
power = string.Format("[增:{0}],[改:{1}],[查:{2}],[删:{3}],[注册:{4}],[导出:{5}];1表示有权限0表示无权限"
, bl[0], bl[1], bl[2], bl[3], bl[4], bl[5]);
ua = (user)Session["Adminu"];
string info2 = "";//备份的注册信息
info2 = string.Format("[密码:{0}][状态:{1}]{2}",
MD5pwd.MD5zsgc.MD5Entry(txt_pwd.Value), ddl_s.SelectedValue, power);
string clientIP = HttpContext.Current.Request.UserHostAddress;
Buckup.Buckup_AccountOperation("注册用户", ua.name, clientIP, txt_name.Value, info2);
LayerA("注册成功", 6, Page);
}
else
{
LayerA("注册失败", 5, Page);
}
}
else //检查不规范
{
LayerA(info, 5, Page);
}
}