?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_BrowseCard_DeliverCard : System.Web.UI.Page
{
    DataCon myCon = new DataCon();
    DataOperate sqlBind = new DataOperate();
    SqlConnection sqlconn;
    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)
        {
            string strsql = "select * from tb_Module";
            sqlconn = myCon.getCon();
            sqlconn.Open();
            SqlDataAdapter myApter = new SqlDataAdapter(strsql, sqlconn);
            DataSet myDS = new DataSet();
            myApter.Fill(myDS, "tb_Module");
            ddlModuleName.DataSource = myDS;
            ddlModuleName.DataValueField = "ModuleName";
            ddlModuleName.DataBind();
            sqlconn.Close();
        }
    }
    
    protected void btnDeliver_Click(object sender, EventArgs e)
    {
        string strMod = "select ModuleID,ModuleName from tb_Module"
            + " where ModuleName='" + ddlModuleName.SelectedValue + "'";
        sqlconn = myCon.getCon();
        sqlconn.Open();
        SqlDataAdapter myApter = new SqlDataAdapter(strMod, sqlconn);
        DataSet myDS = new DataSet();
        myApter.Fill(myDS, "tb_Module");
        DataRowView rowView = myDS.Tables["tb_Module"].DefaultView[0];
        string strModuleID = Convert.ToString(rowView["ModuleID"]);
        string sqlstr = "insert into tb_Card (UserID,ModuleID,CardName,CardContent)"
                + " values('" + Session["UserID"].ToString() + "','" + strModuleID.ToString()
                + "','" + txtCardTitle.Text + "','" + txtCardContent.Text + "')";
        sqlBind.DataCom(sqlstr);
        Response.Write("<script language=javascript>alert('發表成功');</script>");
    }
    protected void btnCancel_Click(object sender, EventArgs e)
    {
        Response.Redirect("../../FrontDesk/Login/AdminLogined.aspx");
    }
}