msganswer.aspx.cs

B/S asp.net的C#编的网站

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class MsgAnswer : System.Web.UI.Page
{
    WebUser user = new WebUser();
    string connstr = ConfigurationManager.AppSettings["constr"].ToString();
    

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            SqlConnection conn = new SqlConnection(connstr);
            DataSet ds = new DataSet();

            try
            {
                //string sql = "Select [Title] From [News] Where [MessageID] = " + Convert.ToInt32(Request.QueryString["msgID"]) + "";
                string sql = "Select [Title], [Receive], [Email] From [User],[Message] Where [User].UserID = [Message].UserID AND MessageID = " + Convert.ToInt32(Request.QueryString["msgID"]) + "";
                SqlCommand cmd = new SqlCommand(sql, conn);

                conn.Open();
                SqlDataAdapter sda = new SqlDataAdapter();
                sda.SelectCommand = cmd;
                sda.Fill(ds);
            }
            catch (SqlException se)
            {
                se.ToString();
            }
            finally
            {
                conn.Close();
            }

            if (ds.Tables[0].Rows.Count > 0)
            {
                titletxt.Text = "回复：" + ds.Tables[0].Rows[0][0].ToString();
                user.UserReceive = Convert.ToBoolean(ds.Tables[0].Rows[0][1]);
                user.UserMail = ds.Tables[0].Rows[0][2].ToString();
            }
        }
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection(connstr);
        //需要管理员权限        
        try
        {
            conn.Open();
            //修改Message表中Answer属性列
            string sql_1 = "Update [Message] Set Answer = '" + anstxt.Text + "',AnsCheck = " + 1 + " Where MessageID = " + Convert.ToInt32(Request.QueryString["msgID"]) + "";
            SqlCommand cmd_1 = new SqlCommand(sql_1, conn);
            //cmd_1.Parameters.Add("@ID", SqlDbType.Int, 4).Value = Convert.ToInt32(msgnum.Text.Trim());
            //cmd_1.Parameters.Add("@check", SqlDbType.Bit, 1).Value = 1;
            cmd_1.ExecuteNonQuery();
        }
        catch (SqlException se2)
        {
            se2.ToString();
        }
        finally
        {
            conn.Close();
        }

        //邮件发送
        if (CheckBox1.Checked)
        {
            //回复到mail           

            WebUser admin = new WebUser();
            admin.UserID = Session["login_ID"].ToString();
            WebUserManager wum = new WebUserManager();
            wum.UserInfoLoad(admin);

            if (user.UserReceive)
            {
                //填充邮件内容
                Email em = new Email();
                em.FromEmail1 = admin.UserMail;
                em.ToEmail1 = user.UserMail;
                em.Body1 = anstxt.Text;
                em.Title1 = titletxt.Text.Trim();

                try
                {
                    //发送邮件
                    em.SendNormalMail();
                }
                catch (Exception ex1)
                {
                    ex1.ToString();
                }
            }
        }

        Response.Redirect("./MessageBook.aspx");        
    }
}