?using System;
using System.Data;
using System.Data.SqlClient;
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;

public partial class BackDesk_ManageUser_EditCard : System.Web.UI.Page
{
    DataCon myCon = new DataCon();
    DataOperate sqlBind = new DataOperate();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["Name"] == null)
        {
            Response.Redirect("../../FrontDesk/Login/Login.aspx");
        }
        else
        {
            labUserName.Text = Session["Name"].ToString() + "！";
            if (!IsPostBack)
            {
                SqlConnection sqlconn = myCon.getCon();
                sqlconn.Open();
                string sqlstr = "select a.*,b.ModuleID,b.ModuleName from tb_Card as a "
                   + "join tb_Module as b on a.ModuleID = b.ModuleID where a.CardID = '"
                   + Request["CardID"].ToString() + "'";//接受CardInfo.aspx頁傳值
                SqlDataAdapter myAdapter = new SqlDataAdapter(sqlstr, sqlconn);
                DataSet myDSCard = new DataSet();
                DataSet myDSModule = new DataSet();
                myAdapter.Fill(myDSCard, "tb_Card");
                myAdapter.Fill(myDSModule, "tb_Module");
                DataRowView rowViewCard = myDSCard.Tables["tb_Card"].DefaultView[0];
                DataRowView rowViewModule = myDSModule.Tables["tb_Module"].DefaultView[0];
                txtCardContent.Text = Convert.ToString(rowViewCard["CardContent"]);
                labCardTitle.Text = "帖子標題："+Convert.ToString(rowViewCard["CardName"]);
                labCardDate.Text = "發(fā)帖日期："+Convert.ToString(rowViewCard["CardDate"]);
                hpLinkCardMod.Text = "所屬模塊："+Convert.ToString(rowViewModule["ModuleName"]);
                sqlconn.Close();
            }
        }
    }
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        string sqlstr = "update tb_Card set CardContent='" + txtCardContent.Text
           + "' where  CardID='" + Request["CardID"].ToString() + "'";
        sqlBind.DataCom(sqlstr);
        Response.Redirect("CardInfo.aspx");
    }
    protected void btnCancel_Click(object sender, EventArgs e)
    {
        Response.Redirect("CardInfo.aspx");
    }
    protected void btnPride_Click(object sender, EventArgs e)
    {
        string sqlstr = "update tb_Card set CardIsPride='是' where CardID='" + Request["CardID"].ToString() + "'";
        sqlBind.DataCom(sqlstr);
        Response.Write("<script lanuage=javascript>alert('指定成功！');location='javascript:history.go(-1)'</script>");
    }
}