?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 TeachStudy_Teacher_hjqk : System.Web.UI.Page
{
    PersonRecordClass prObj = new PersonRecordClass();
    TeachStudyClass tsObj = new TeachStudyClass();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if ((Session["isOpen"] == null) && (Session["Admin"] == null))
            {
                Response.Write("<script>parent.location='../Default.aspx';</script>");
            }
            else
            {

                tabList.Visible = false;
                tabAdd.Visible = false;
                tabUpdate.Visible = false;
                btnAddList.Visible = false;
                if (Convert.ToInt32(Session["isOpen"]) == 1 || Convert.ToInt32(Session["Admin"]) == 1)
                {
                    tabList.Visible = true;
                    btnAddList.Visible = true;
                    gvListBind();


                }
                else
                {
                    tabList.Visible = true;
                    btnAddList.Visible = false;
                    gvListBind();
                    gvList.Columns[0].Visible = false;
                    gvList.Columns[1].Visible = false;
                }
            }
        }
    }
    //=============================================================
    // 方 法 名： gvListBind()
    // 功能描述： 對GridView進行綁定，顯示教學研究（在線課題）的資料
    // 輸入參數： 無
    // 返 回 值： 無
    // ==============================================================
    public void gvListBind()
    {
        if ((Session["isOpen"] == null) && (Session["Admin"] == null))
        {
            Response.Write("<script>parent.location='../Default.aspx';</script>");
        }
        else
        {
            if (Convert.ToInt32(Session["Admin"]) == 1)
            {
                SqlCommand myCmd = tsObj.GetAJYCmd(4);
                prObj.GVBind(myCmd, gvList, "AJY");
            }
            else
            {
                SqlCommand myCmd = tsObj.GetSJYCmd(4, Convert.ToInt32(Session["UID"]));
                prObj.GVBind(myCmd, gvList, "SJY");
            }

        }

    }  
    //=============================================================
    // 事 件 名： gvList_RowDeleting()
    // 功能描述： 對GridView中的某行進行刪除
    // ==============================================================
    protected void gvList_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        int P_Int_id = Convert.ToInt32(gvList.DataKeys[e.RowIndex].Value);
        tsObj.DeleteJYInfo(P_Int_id);
        gvListBind();
    }   
    //=============================================================
    // 事 件 名： gvList_RowUpdating()
    // 功能描述： 對GridView中的某行進行修改時，修改表顯示其修改內容
    // ==============================================================
    protected void gvList_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        tabUpdate.Visible = true;
        tabList.Visible = false;
        tabAdd.Visible = false;
        prObj.DDLBind(ddlUYearInfo);
        int P_Int_id = Convert.ToInt32(gvList.DataKeys[e.RowIndex].Value);
        labValue.Text = P_Int_id.ToString();
        DataSet ds = tsObj.ReturnJYDs(4, P_Int_id, "JYInfo");
        txtName.Text = ds.Tables["JYInfo"].Rows[0][0].ToString();
        txtUName.Text = ds.Tables["JYInfo"].Rows[0][1].ToString();
        txtULessonName.Text = ds.Tables["JYInfo"].Rows[0][8].ToString();
        txtUStartEndTime.Text = ds.Tables["JYInfo"].Rows[0][2].ToString();
        txtUUnit.Text = ds.Tables["JYInfo"].Rows[0][3].ToString();
        txtUFroming.Text = ds.Tables["JYInfo"].Rows[0][4].ToString();
        txtUAuthor.Text = ds.Tables["JYInfo"].Rows[0][5].ToString();
        txtUWorker.Text = ds.Tables["JYInfo"].Rows[0][6].ToString();
        ddlUYearInfo.SelectedItem.Text = ds.Tables["JYInfo"].Rows[0][7].ToString();

    }    
    //=============================================================
    // 事 件 名： btnReset_Click()
    // 功能描述： 在添加表上，單擊重置按鈕時，重新填寫教師的教學研究資料
    // ==============================================================
    protected void btnReset_Click(object sender, EventArgs e)
    {
        txtAName.Text = "";
        txtALessonName.Text = "";
        txtAStartEndTime.Text = "";
        txtAUnit.Text = "";
        txtAFroming.Text = "";
        txtAAuthor.Text = "";
        txtAWorker.Text = "";
        ddlAYearInfo.SelectedIndex = 0;
    }
    //=============================================================
    // 事 件 名： btnUpdate_Click()
    // 功能描述： 在修改表上，單擊修改按鈕時，修改教師的教學研究資料
    // ==============================================================
    protected void btnUpdate_Click(object sender, EventArgs e)
    {
        if (Session["Username"] == null)
        {
            Response.Write("<script>parent.location='../Default.aspx';</script>");
        }
        else
        {
            if (txtUName.Text.Trim() == "")
            {
                Response.Write("<script>alert('請填寫獲獎名稱！');</script>");
            }
            if (txtULessonName.Text.Trim() == "")
            {
                Response.Write("<script>alert('請填寫獲獎項目名稱！');</script>");
            }
            else if (txtUStartEndTime.Text.Trim() == "")
            {
                Response.Write("<script>alert('請填寫時間！');</script>");

            }
            else if (txtUUnit.Text.Trim() == "")
            {
                Response.Write("<script>alert('請填寫授予單位！');</script>");
            }
            else if (txtUFroming.Text.Trim() == "")
            {
                Response.Write("<script>alert('請填寫備注！');</script>");
            }
            else if (txtUAuthor.Text.Trim() == "")
            {
                Response.Write("<script>alert('請填寫主持人！');</script>");
            }
            else if (txtUWorker.Text.Trim() == "")
            {
                Response.Write("<script>alert('請填寫合作人！');</script>");
            }
            else
            {
                tsObj.UpdateJYInfo(Convert.ToInt32(labValue.Text.Trim()), txtUName.Text.Trim(), txtULessonName.Text.Trim(), txtUAuthor.Text.Trim(), txtUWorker.Text.Trim(), txtUFroming.Text.Trim(), txtUStartEndTime.Text.Trim(), txtUUnit.Text.Trim(), Convert.ToString(Session["Username"]), Convert.ToInt32(ddlUYearInfo.SelectedItem.ToString()), Convert.ToInt32(Session["UID"]));
                Response.Redirect("~/TeachStudy/Teacher_hjqk.aspx");
            }
        }
    }
    //=============================================================
    // 事 件 名： btnAdd_Click()
    // 功能描述： 在添加表上，單擊添加按鈕時，將教學研究資料添加到表tb_jiaoyan中
    // ==============================================================
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        if (Session["Username"] == null)
        {
            Response.Write("<script>parent.location='../Default.aspx';</script>");
        }
        else
        {
            if (ddlAName.SelectedIndex == 0)
            {
                Response.Write("<script>alert('請選擇需要添加資料的姓名！');</script>");

            }
            else if (txtAName.Text.Trim() == "")
            {
                Response.Write("<script>alert('請填寫獲獎名稱！');</script>");
            }
            else if (txtALessonName.Text.Trim() == "")
            {
                Response.Write("<script>alert('請填寫獲獎項目名稱！');</script>");
            }
            else if (txtAStartEndTime.Text.Trim() == "")
            {
                Response.Write("<script>alert('請填寫起止時間！');</script>");

            }
            else if (txtAUnit.Text.Trim() == "")
            {
                Response.Write("<script>alert('請填寫授予單位！');</script>");

            }
            else if (txtAFroming.Text.Trim() == "")
            {
                Response.Write("<script>alert('請填寫備注！');</script>");
            }
            else if (txtAAuthor.Text.Trim() == "")
            {
                Response.Write("<script>alert('請填寫主持人！')</script>");
            }
            else if (txtAWorker.Text.Trim() == "")
            {
                Response.Write("<script>alert('請填寫合作人！')</script>");
            }
            else if (ddlAYearInfo.SelectedIndex == 0)
            {
                Response.Write("<script>alert('請選擇填寫年度！');</script>");
            }
            else
            {
                tsObj.AddJYInfo(txtAName.Text.Trim(), txtALessonName.Text.Trim(), txtAAuthor.Text.Trim(), txtAWorker.Text.Trim(), txtAFroming.Text.Trim(), txtAStartEndTime.Text.Trim(), txtAUnit.Text.Trim(), 4, Convert.ToInt32(ddlAName.SelectedValue), Convert.ToString(Session["Username"]), "", Convert.ToInt32(ddlAYearInfo.SelectedItem.ToString()), Convert.ToInt32(Session["UID"]));
                Response.Redirect("~/TeachStudy/Teacher_hjqk.aspx");
            }
        }

    }
    //=============================================================
    // 事 件 名： btnAddList_Click()
    // 功能描述： 當用戶單擊添加按鈕，添加表顯示
    // ==============================================================
    protected void btnAddList_Click1(object sender, EventArgs e)
    {
        tabAdd.Visible = true;
        tabList.Visible = false;
        tabUpdate.Visible = false;
        prObj.DDLBind(ddlAYearInfo);
        prObj.DDLNameBind(ddlAName, "userInfo");
        if ((Session["isOpen"] == null) && (Session["Admin"] == null))
        {
            Response.Write("<script>parent.location='../Default.aspx';</script>");
        }
        else
        {
            if (Convert.ToInt32(Session["Admin"]) == 1)
            { }
            else
            {
                ddlAName.SelectedValue = Convert.ToString(Session["UID"]);
                ddlAName.Enabled = false;

            }
        }
    }
    protected void gvList_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        gvList.PageIndex = e.NewPageIndex;
        gvListBind();
    }
}