//编辑管理员 public int updateAdm(Modeladministrators adm) { string sql = "update tbadministrators set administrators_name='" + adm.administratorsName + "',administrators_limit='" + adm.administratorsLimit + "' where administrators_id=" + adm.administratorsId; conn.Open(); SqlCommand cmd = new SqlCommand(sql, conn); int temp = cmd.ExecuteNonQuery(); conn.Close(); return(temp); }
public static int updateAdm(int id, string name, string limit) { if ((int)new admset().Session["administratorsId"] == 1) { Modeladministrators adm = new Modeladministrators(); adm.administratorsId = id; adm.administratorsName = name; adm.administratorsLimit = limit; return(blladministrators.updateAdm(adm)); } else { return(0); } }
//得到管理员列表(除超管) public List <Modeladministrators> getAlladmsinfo() { List <Modeladministrators> list = new List <Modeladministrators>(); DataSet set = daladministrators.getAlladmsinfo(); int nums = set.Tables[0].Rows.Count; for (int i = 0; i < nums; i++) { Modeladministrators adm = new Modeladministrators(); adm.administratorsId = (int)set.Tables[0].Rows[i].ItemArray[0]; adm.administratorsName = set.Tables[0].Rows[i].ItemArray[1].ToString(); adm.administratorsLimit = set.Tables[0].Rows[i].ItemArray[2].ToString(); list.Add(adm); } return(list); }
protected void signin_Click(object sender, EventArgs e) { //管理员登录并跳转到首页 Modeladministrators adm = blladministrators.admlogin(this.name.Text, this.password.Text); if (adm == null) { Response.Write("<script>alert('名字或密码错误');</script>"); } else { Session.Add("administratorsId", adm.administratorsId); Session.Add("administratorsName", adm.administratorsName); Session.Add("administratorsLimit", adm.administratorsLimit); Response.Redirect("admdefault.aspx"); } }
//管理员登陆 public Modeladministrators admlogin(string userName, string userPwd) { Modeladministrators adm = new Modeladministrators(); DataSet set = daladministrators.getAdm(userName); if (set.Tables[0].Rows.Count == 0) { adm = null; } else if (userPwd.Equals(set.Tables[0].Rows[0].ItemArray[2].ToString())) { adm.administratorsId = (int)set.Tables[0].Rows[0].ItemArray[0]; adm.administratorsName = userName; adm.administratorsLimit = set.Tables[0].Rows[0].ItemArray[3].ToString(); } else { adm = null; } return(adm); }
//编辑管理员 public int updateAdm(Modeladministrators adm) { return(daladministrators.updateAdm(adm)); }