Пример #1
0
    //根据名字邮箱查找用户,确定修改密码
    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>");
        }
    }
Пример #2
0
    //根据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);
    }
Пример #3
0
    //选出全部的数据
    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);
    }