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