//更新用户
public int Update(Ep229User user)
{
string sql = String.Format("update ep229_user set user_name='{0}',user_pwd='{1}',user_rname='{2}',user_email='{3}',user_company='{4}',user_tel='{5}',user_fax='{6}',user_right={7} where user_id={8}", user.UserName,
user.UserPwd, user.UserRName, user.UserEmail, user.UserCompany, user.UserTel, user.UserFax, user.UserRight, user.UserId);
return(SqlHelper.ExecuteNonQuery(sql));
}
//插入一条数据
public int Insert(Ep229User user)
{
string sql = String.Format("insert into ep229_user(user_name,user_pwd,user_rname,user_email,user_company,user_tel,user_fax) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", user.UserName,
user.UserPwd, user.UserRName, user.UserEmail, user.UserCompany, user.UserTel, user.UserFax);
return(SqlHelper.ExecuteNonQuery(sql));
}
protected void Page_Load(object sender, EventArgs e)
{
Ep229User user = (Ep229User)Session["user"];
if (user == null || user.UserRight > 1)
{
this.ClientScript.RegisterClientScriptBlock(this.GetType(),
"", "alert('没权限');window.location.href='../Index.aspx'", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
Page.Title = "密码更改";
if (!IsPostBack)
{
Ep229User user = (Ep229User)Session["user"];
if (user != null)
{
TextBox1.Text = user.UserName;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Page.Title = "用户详情";
//根据session取得当前用户详情
Ep229User user = (Ep229User)Session["user"];
if (user != null)
{
userid.Text = user.UserName;
name.Text = user.UserRName;
email.Text = user.UserEmail;
company.Text = user.UserCompany;
tel.Text = user.UserTel;
fax.Text = user.UserFax;
}
}
//修改密码事件
protected void Button1_Click(object sender, EventArgs e)
{
Ep229UserBLL UserBLL = new Ep229UserBLL();
Ep229User user = new Ep229User();
user = (Ep229User)Session["user"];
user.UserPwd = TextBox2.Text;
if (UserBLL.EditUser(user) == 1)
{
this.ClientScript.RegisterClientScriptBlock(this.GetType(),
"", "alert('修改成功'); window.location.href='../index.aspx'", true);
}
else
{
this.ClientScript.RegisterClientScriptBlock(this.GetType(),
"", "alert('修改失败'); window.location.href='Edit.aspx'", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{ //先根据session判断，如果没有从cookie中取
Ep229User user = (Ep229User)Session["user"];
if (user == null)
{
if (Request.Cookies["userId"] != null)
{
int userId = Int32.Parse(Request.Cookies["userId"].Value);
user = userBLL.FindUserById(userId);
Session["user"] = user;
}
}
}
//如果会话存在则根据权限，选择面版
if (Session["user"] != null)
{
Ep229User user = (Ep229User)Session["user"];
Literal1.Text = user.UserName;
//0为管理员
if (user.UserRight == 0)
{
HyperLink2.Visible = true;
HyperLink3.Visible = true;
HyperLink4.Visible = true;
HyperLink5.Visible = true;
}
//1为普通用户
else if (user.UserRight == 1)
{
HyperLink2.Visible = false;
HyperLink3.Visible = false;
HyperLink4.Visible = false;
HyperLink5.Visible = false;
}
MultiView1.ActiveViewIndex = 1;
}
else
{
MultiView1.ActiveViewIndex = 0;
}
}
protected void Page_Load(object sender, EventArgs e)
{
Ep229User user = (Ep229User)Session["user"];
//根据权限显示页面
if (user == null || user.UserRight == 1)
{
manage_list1.Visible = false;
manage_list2.Visible = false;
manage_list3.Visible = false;
manage_list4.Visible = false;
manage_list5.Visible = false;
manage_list6.Visible = false;
user_list2.Visible = false;
user_list3.Visible = false;
user_list4.Visible = false;
user_list1.InnerHtml = "";
user_list1.InnerHtml = "<a href='../index.aspx'>登录</a>";
contain.Attributes.Add("class", "span12");
}
}
//登录按钮事件，先去判断用户名和密码是否正确
protected void Login_Click(object sender, EventArgs e)
{
Ep229User user = userBLL.FindUserByNameAndPwd(UserName.Text, Pwd.Text);
if (user != null)
{
if (Remember.Checked)
{
HttpCookie cookie = new HttpCookie("userId");
cookie.Path = "/";
cookie.Value = user.UserId.ToString();
cookie.Expires = DateTime.Now.AddDays(7);
Response.Cookies.Add(cookie);
}
Session["user"] = user;
Response.Redirect("~/Views/index.aspx");
}
else
{
Response.Write("<script>alert('用户名或密码错误')</script>");
}
}
//根据用户名密码查询数据
public Ep229User SelectOne(string username, string userpwd)
{
Ep229User user = null;
string sql = String.Format("select * from ep229_user where user_name='{0}' and user_pwd='{1}'", username, userpwd);
SqlDataReader sdr = SqlHelper.ExecuteReader(sql);
if (sdr.Read())
{
user = new Ep229User();
user.UserId = sdr.GetInt32(0);
user.UserName = sdr.GetString(1);
user.UserPwd = sdr.GetString(2);
user.UserRName = sdr.GetString(3);
user.UserEmail = sdr.GetString(4);
user.UserCompany = sdr.GetString(5);
user.UserTel = sdr.GetString(6);
user.UserFax = sdr.GetString(7);
user.UserDatetime = sdr.GetDateTime(8);
user.UserRight = sdr.GetByte(9);
}
sdr.Close();
return(user);
}
//查出全部的用户
public IList <Ep229User> SelectAll()
{
IList <Ep229User> list = new List <Ep229User>();
String sql = String.Format("select * from ep229_user");
DataTable dt = SqlHelper.ExecuteQuery(sql);
Ep229User user = null;
foreach (DataRow row in dt.Rows)
{
user = new Ep229User();
user.UserId = (int)row[0];
user.UserName = (string)row[1];
user.UserPwd = (string)row[2];
user.UserRName = (string)row[3];
user.UserEmail = (string)row[4];
user.UserCompany = (string)row[5];
user.UserTel = (string)row[6];
user.UserFax = (string)row[7];
user.UserDatetime = (DateTime)row[8];
user.UserRight = (byte)row[9];
list.Add(user);
}
return(list);
}
//根据用户名查询用户
public IList <Ep229User> SelectSome(out int total, string username, string sortExpression, int start, int count)
{
IList <Ep229User> list = new List <Ep229User>();
String sql = String.Format("select * from ep229_user where user_name like '{0}'", "%" + username + "%");
DataTable dt = SqlHelper.ExecuteQuery(out total, sql, sortExpression, start, count);
Ep229User user = null;
foreach (DataRow row in dt.Rows)
{
user = new Ep229User();
user.UserId = (int)row[0];
user.UserName = (string)row[1];
user.UserPwd = (string)row[2];
user.UserRName = (string)row[3];
user.UserEmail = (string)row[4];
user.UserCompany = (string)row[5];
user.UserTel = (string)row[6];
user.UserFax = (string)row[7];
user.UserDatetime = (DateTime)row[8];
user.UserRight = (byte)row[9];
list.Add(user);
}
return(list);
}
//按钮1添加事件如果返回成功跳回首页，如果用户没登录，或者没反馈成功，还在当前页面
protected void Button1_Click(object sender, EventArgs e)
{
if ((user = (Ep229User)Session["user"]) != null)
{
feedBack.FbackTitle = TextBox1.Text;
feedBack.FbackContent = TextBox2.Text;
feedBack.user = user;
if (feedBackDAL.Insert(feedBack) == 1)
{
this.ClientScript.RegisterClientScriptBlock(this.GetType(),
"", "alert('反馈成功'); window.location.href='../Index.aspx'", true);
}
else
{
this.ClientScript.RegisterClientScriptBlock(this.GetType(),
"", "alert('反馈失败');", true);
}
}
else
{
this.ClientScript.RegisterClientScriptBlock(this.GetType(),
"", "alert('请先登录'); window.location.href='../Index.aspx'", true);
}
}
//编辑用户
public int EditUser(Ep229User user)
{
return(UserDAL.Update(user));
}
//删除用户
public int DeleteUser(Ep229User user)
{
return(UserDAL.Delete(user.UserId));
}
//增加用户
public int AddUser(Ep229User user)
{
return(UserDAL.Insert(user));
}
