//根据名字邮箱查找用户,确定修改密码 protected void Button1_Click(object sender, EventArgs e) { string name = TextBox1.Text; string email = TextBox2.Text; Ep229UserDAL UserDAL = new Ep229UserDAL(); int i = UserDAL.FindPwd(name, email); if (i == 1) { Response.Redirect("Edit.aspx"); } else { Response.Write("<script>alert('用户名或邮箱错误')</script>"); } }
//根据id查找数据 public Ep229FeedBack SelectById(int id) { Ep229FeedBack feedback = null; string sql = String.Format("select * from ep229_feedback where fback_id={0}", id); SqlDataReader sdr = SqlHelper.ExecuteReader(sql); if (sdr.Read()) { feedback = new Ep229FeedBack(); feedback.FbackId = sdr.GetInt32(0); feedback.FbackTitle = sdr.GetString(1); Ep229User user = new Ep229UserDAL().SelectById(sdr.GetInt32(3)); feedback.user = user; feedback.FbackDatetime = sdr.GetDateTime(4); } sdr.Close(); return(feedback); }
//选出全部的数据 public IList <Ep229FeedBack> SelectAll() { IList <Ep229FeedBack> list = new List <Ep229FeedBack>(); String sql = String.Format("select * from ep229_feedback"); DataTable dt = SqlHelper.ExecuteQuery(sql); Ep229FeedBack fback = null; foreach (DataRow row in dt.Rows) { fback = new Ep229FeedBack(); fback.FbackId = (int)row[0]; fback.FbackTitle = (string)row[1]; fback.FbackContent = (string)row[2]; fback.FbackDatetime = (DateTime)row[4]; Ep229User user = new Ep229UserDAL().SelectById((int)row[3]); fback.user = user; list.Add(fback); } return(list); }