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

public partial class SubjectManage_Subject : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["USERSTYLE"] == "TEACHER")
        {

        }
        else
        {
            Dialog("對不起，你沒有權限訪問這個頁面！");
            Response.Redirect("~/SystemManage/Login.aspx");
        }
    }
    private void Dialog(String Str)
    {
        Response.Write(@"<script type='text/JavaScript'>");
        Response.Write(@"alert('" + Str + "');");
        //Response.Write(@"window.location='./list_logingroup.aspx';");
        Response.Write(@"</script>");
    }
    protected void btnAdd_Click1(object sender, EventArgs e)
    {
        String tno = texTno.Text;
        String grade = ddlGrade.Text;
        String type = ddlType.Text;
        String content = changeWord(texContent.Text);
        String a = changeWord(texA.Text);
        String b = changeWord(texB.Text);
        String c = changeWord(texC.Text);
        String d = changeWord(texD.Text);
        String key = texKey.Text;

        SqlData sql = new SqlData();       
        String[]  InsertStr=new String[9];
        InsertStr[0] = tno; InsertStr[1] =content ; InsertStr[2] = grade; InsertStr[3] =a ; InsertStr[4] = b;
        InsertStr[5] = c; InsertStr[6] = d; InsertStr[7] = key; InsertStr[8] = type;

        if (sql.CheckStringUnique("TAB_TESTSYNTAX", "TSNO", tno) == 2)
        {
            if (sql.InsertRow("TAB_TESTSYNTAX", InsertStr, InsertStr.Length) == false)
            {
                Label10.Text = "錄入失敗！";
            }
            else
                Label10.Text = "操作成功！";
            sql.SqlDataClose();
        }
        else
            Label10.Text = "題號為"+tno+"已經存在！";
       
    }
    protected void btnNext_Click(object sender, EventArgs e)
    {
        int i = 1;
        String s = i.ToString();
        SqlData sql = new SqlData();
        while (sql.CheckStringUnique("TAB_TESTSYNTAX", "TSNO", s) == 1)
        {
            i++;
            s = i.ToString();
        }

        texTno.Text = s;
        texContent.Text="";
        texA.Text="";
        texB.Text="";
        texC.Text="";
        texD.Text="";
        texKey.Text="";
        Label10.Text = "繼續錄入！";
    }

    protected void btnFind_Click(object sender, EventArgs e)
    {
        String str = texTno.Text;

        string ConnectionString =
        ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        SqlConnection myConnection = new SqlConnection(ConnectionString);

        String conString = "select * from TAB_TESTSYNTAX where TSNO="+str;
        SqlDataAdapter myAdapter = new SqlDataAdapter(conString, myConnection);

        DataSet myDataSet = new DataSet();
        myAdapter.Fill(myDataSet,"info");
        DataTable Table = myDataSet.Tables[0];
        
        if (Table.Rows.Count == 0)
        {
            Label10.Text="沒有此記錄！";
        }
        else
        {
            DataRow row = Table.Rows[0];
            texContent.Text = row["TSCONTENT"].ToString();
            ddlGrade.Text = row["TSGRADE"].ToString();
            texA.Text = row["A"].ToString();
            texB.Text = row["B"].ToString();
            texC.Text = row["C"].ToString();
            texD.Text = row["D"].ToString();
            texKey.Text = row["TSKEY"].ToString();
            ddlType.Text = row["SSTYLENO"].ToString();
            Label10.Text = "";
        }

    }
    protected void btnUpdate_Click(object sender, EventArgs e)
    {
        String tno = texTno.Text;
        String grade = ddlGrade.Text;
        String type = ddlType.Text;
        String content = changeWord(texContent.Text);
        String a = changeWord(texA.Text);
        String b = changeWord(texB.Text);
        String c = changeWord(texC.Text);
        String d = changeWord(texD.Text);
        String key = texKey.Text;

        SqlData sql = new SqlData();
        String[] InsertStr = new String[9];
        InsertStr[0] = tno; InsertStr[1] = content; InsertStr[2] = grade; InsertStr[3] = a; InsertStr[4] = b;
        InsertStr[5] = c; InsertStr[6] = d; InsertStr[7] = key; InsertStr[8] = type;

        String []UpdateCloumn={"TSNO","TSCONTENT","TSGRADE","A","B","C","D","TSKEY","SSTYLENO"};
        if (sql.updateRow("TAB_TESTSYNTAX", UpdateCloumn, InsertStr, InsertStr.Length, "TSNO", tno) == true)
        {
            Label10.Text = "修改成功！";
        }
        else
            Label10.Text = "修改失敗！";
        sql.SqlDataClose();
            
    }
    protected void btnDel_Click(object sender, EventArgs e)
    {
        //DeleteRow(String TableName, String CloumnName, String WhereStr)
        String str = texTno.Text;
        SqlData sql=new SqlData();
        if (sql.CheckStringUnique("TAB_SAVETESTSYNTAX", "TSNO", str) == 1)
        {
            Label10.Text = "該題已經被選進試卷，不能被刪除！";
        }
        else
        {
            if (sql.DeleteRow("TAB_TESTSYNTAX","TSNO", str) == true)
        {
            Label10.Text = "刪除成功！";
        }
        else
            Label10.Text = "刪除失敗！";
        sql.SqlDataClose();
        texTno.Text="";
        texContent.Text = "";
        texA.Text = "";
        texB.Text = "";
        texC.Text = "";
        texD.Text = "";
        texKey.Text = "";
        }
    }
    protected void BtnReturn_Click(object sender, EventArgs e)
    {
        Response.Redirect("~/SystemManage/TeacherMain.aspx");
    }
    public string changeWord(string str)
    {
        String[] sArray = str.Split('\'');
        String result = "";
        foreach (String head in sArray)
        {
            result += " " + head.ToString();
        }
        return result;
    }
}