?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_ManageCard_Card : 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];
                labCardContent.Text = Convert.ToString(rowViewCard["CardContent"]);
                labCardTitle.Text = "帖子標題：" + Convert.ToString(rowViewCard["CardName"]);
                labCardDate.Text = "發帖日期：" + Convert.ToString(rowViewCard["CardDate"]);
                labCardMod.Text = "帖子所屬模塊：" + Convert.ToString(rowViewModule["ModuleName"]);
                sqlconn.Close();
            }
        }
    }
}