public IList <SsUser> FindSsUsers(string username) { IList <SsUser> list = new List <SsUser>(); string sql = String.Format("select * from SsUser where username like '{0}'", "%" + username + "%"); DataTable dt = SqlHelper.ExecuteQuery(sql); if (dt != null) { SsUser SsUser = null; foreach (DataRow row in dt.Rows) { SsUser = new SsUser(); SsUser.ID = Int32.Parse(row["id"].ToString()); SsUser.Username = row["username"].ToString(); SsUser.Password = row["password"].ToString(); SsUser.Realname = row["realname"].ToString(); SsUser.Email = row["email"].ToString(); SsUser.Phone = row["phone"].ToString(); SsUser.Address = row["address"].ToString(); SsUser.Zipcode = row["zipcode"].ToString(); SsUser.Role = Int32.Parse(row["author"].ToString()); list.Add(SsUser); } } return(list); }
public int EditSsUser(SsUser SsUser) { string sql = String.Format("updete SsUser set username={0},password='******',realname={2},email='{3}',phone='{4}',address='{5}',zipcode='{6}',zipcode='{7}' where id={8}", SsUser.Username, SsUser.Password, SsUser.Realname, SsUser.Email, SsUser.Phone, SsUser.Address, SsUser.Zipcode, SsUser.Role, SsUser.ID); return(SqlHelper.ExecuteNonQuery(sql)); }
public int AddSsUser(SsUser SsUser) { string sql = String.Format("insert into SsUser(username,password,realname,email,phone,address,zipcode,role) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", SsUser.Username, SsUser.Password, SsUser.Realname, SsUser.Email, SsUser.Phone, SsUser.Address, SsUser.Zipcode, SsUser.Role); return(SqlHelper.ExecuteNonQuery(sql)); }
protected void Page_Load(object sender, EventArgs e) { SsUser user = (SsUser)Session["user"]; // if (user != null || user.Role != 1) { // this.ClientScript.RegisterClientScriptBlock(this.GetType(),"","alert('您没有登录或不是管理员,无权进入');window.location.href='../../Content1.aspx'",true); } }
protected void Page_Load(object sender, EventArgs e) { SsUserBLL ssUserBLL = new SsUserBLL(); SsUser ssUser = new SsUser(); ssUser.Username = ""; ssUser.Password = ""; ssUser.Realname = ""; ssUser.Phone = ""; ssUser.Address = ""; ssUser.Zipcode = ""; ssUser.Email = ""; }
public SsUser FindSsUser(int id) { SsUser ssUser = null; string sql = String.Format("select * from SsUser where id = {0}", id); SqlDataReader sdr = SqlHelper.ExecuteReader(sql); if (sdr.Read()) { ssUser = new SsUser(sdr.GetInt32(0), sdr.GetString(1), sdr.GetString(2), sdr.GetString(3), sdr.GetString(4), sdr.GetString(5), sdr.GetString(6), sdr.GetString(7), sdr.GetInt32(8)); } sdr.Close(); return(ssUser); }
public SsUser FindSsUser(string username, string password) { SsUser ssUser = null; string sql = String.Format("select * from SsUser where username='******' and password ='******'", username, password); SqlDataReader sdr = SqlHelper.ExecuteReader(sql); if (sdr.Read()) { ssUser = new SsUser(sdr.GetInt32(0), sdr.GetString(1), sdr.GetString(2), sdr.GetString(3), sdr.GetString(4), sdr.GetString(5), sdr.GetString(6), sdr.GetString(7), sdr.GetInt32(8)); } sdr.Close(); return(ssUser); }
protected void Button1_Click(object sender, EventArgs e) { SsUserBLL ssUserBLL = new SsUserBLL(); SsUser ssUser = new SsUser(); ssUser.Username = TextBoxUserName.Text; ssUser.Password = TextBoxPassword.Text; ssUser.Realname = TextBoxRename.Text; ssUser.Phone = TextBoxPhone.Text; ssUser.Address = TextBoxAdress.Text; ssUser.Zipcode = TextBoxZip.Text; ssUser.Role = 1; ssUser.Email = TextBoxEmaill.Text; ssUserBLL.AddSsUser(ssUser); this.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('添加失败,上传图片文件大小不能超过2MB.')", true); }
protected void Button1_Click(object sender, EventArgs e) { SsUserBLL ssUserBLL = new SsUserBLL(); SsUser ssUser = new SsUser(); ssUser.Username = TextBoxUserName.Text; ssUser.Password = TextBoxPassword.Text; ssUser.Realname = TextBoxRename.Text; ssUser.Phone = TextBoxPhone.Text; ssUser.Address = TextBoxAdress.Text; ssUser.Zipcode = TextBoxZip.Text; ssUser.Role = Convert.ToInt32(TextBoxMember.Text); ssUser.Email = TextBoxEmaill.Text; ssUserBLL.AddSsUser(ssUser); Response.Write("<script>alert('注册成功!')</script>"); }
public int EditSsUser(SsUser SsUser) { return(SsUserDAL.EditSsUser(SsUser)); }
public int AddSsUser(SsUser SsUser) { return(SsUserDAL.AddSsUser(SsUser)); }