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

public partial class add_course : System.Web.UI.Page
{
    OPDataBase op = new OPDataBase();
    protected void Page_Load(object sender, EventArgs e)
    {
        for (int i = 1; i < 32; i++)
        {

            DropDownList4.Items.Add(new ListItem(i.ToString(), i.ToString()));
            DropDownList7.Items.Add(new ListItem(i.ToString(), i.ToString()));
            DropDownList9.Items.Add(new ListItem(i.ToString(), i.ToString()));
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string name, desn, startdate, enddate, coursehour, examinedate,totalmark,coursename,TeacherID,sql;
        name = TextBox1_name.Text.Trim();
        sql = "select  TeacherID from Teacher where Name='"+name+"'";
        SqlConnection conn = new SqlConnection(op .getConnection ());
        conn.Open();
        SqlCommand cmd1=new SqlCommand (sql,conn );
        TeacherID = Convert .ToString ( cmd1.ExecuteScalar());
        desn = TextBox2_courDesn.Text.Trim();
        coursename = TextBox5_CourseName.Text.Trim();
        startdate = DropDownList2.SelectedValue.ToString() + DropDownList3.SelectedValue.ToString() + DropDownList4.SelectedValue.ToString();
        enddate = DropDownList5.SelectedValue.ToString() + DropDownList6.SelectedValue.ToString() + DropDownList7.SelectedValue.ToString();
        coursehour = TextBox3_courTime.Text.Trim();
        totalmark = TextBox4_TotalMark.Text;
        examinedate = DropDownList10.SelectedValue.ToString() + DropDownList8.SelectedValue.ToString() + DropDownList9.SelectedValue.ToString();
       
        string sqlstr = "insert into Course (Desn, Body, StartDate, EndDate, CourseHour,TeacherID,ExamineDate,TotalMark)values('" +
           coursename + "','" + desn + "','" + startdate + "','" + enddate + "','" + coursehour + "','" + TeacherID + "','" + examinedate + "','" + totalmark + "')";
       // SqlCommand cmd = new SqlCommand(sqlstr, conn);
        try
        {
            op.BindCommand(sqlstr);
           // cmd.ExecuteNonQuery();
            Response.Write("<script>alert('添加成功！')</script>");
        }
        catch (SqlException ex)
        {
            string a = ex.Message.ToString();
            Label1.Text = a;

        }
    
  }
    protected void Button2_Click(object sender, EventArgs e)
    {
        TextBox1_name.Text  = "";
        TextBox2_courDesn.Text  = "";
        
        TextBox5_CourseName.Text  = "";
    }
     
    
      
       
     
     
        
    
}