basicenglish.aspx.cs

互联网程序设计的课程

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;
using DBClass;
public partial class ConsultManage_BasicEnglish : System.Web.UI.Page
{
    DataTable dt;
    string[] colName = {"YingYSP"};
    string[] colType = {"System.String"};
    DB db = new DB();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            dt = MyTable.MakeTable(colName, colType,0);
            Session["myTable"] = dt;            
        }
        if (Session["myTable"] != null)
            dt = (DataTable)Session["myTable"];       
    }
    //添加英语水平
    protected void btn_TianJ_Click(object sender, EventArgs e)
    {
        DataRow row;
        reset();
        if (tbx_YingYSP.Text == "")
        {
            lbl_info1.Text = "英语水平不能为空！";
            tbx_YingYSP.Focus();
            return;
        }
        
        row = dt.NewRow();
        row["YingYSP"] = tbx_YingYSP.Text;

        try
        {
            dt.Rows.Add(row);
        }
        catch
        {
            lbl_info1.Text = "英语水平不能重复!";
            tbx_YingYSP.Text = "";
            tbx_YingYSP.Focus();
            return;
        }

        GridView1.DataSource = dt;
        GridView1.DataBind();
    }
    //清空Label的显示信息
    protected void reset()
    {
        lbl_info1.Text = "";
    }
    //点击取消
    protected void btn_QuX_Click(object sender, EventArgs e)
    {
        reset();
        GridView1.Visible = false;
    }

   　//点击删除
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            if (e.Row.RowState == DataControlRowState.Normal || e.Row.RowState == DataControlRowState.Alternate)
            {
                ((LinkButton)e.Row.Cells[1].Controls[0]).Attributes.Add(
                    "onclick", "javascript:return confirm('确定删除吗？')");
            }
        }
    }
    //确定删除
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
    //    string delectId = GridView1.DataKeys[e.RowIndex].Value.ToString();
        int index = e.RowIndex;
        dt.Rows[index].Delete();
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }

    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }
    //更新

    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        int index = e.RowIndex;
        for (int i = 0; i < GridView1.Columns.Count-2; i++)
        {
            string newValue = ((TextBox)GridView1.Rows[index].Cells[i].Controls[0]).Text;
            dt.Rows[index][i] = newValue;
        }
        GridView1.EditIndex = -1;
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }
    //取消编辑
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }
    //提交所有数据
    protected void btn_QueD_Click(object sender, EventArgs e)
    {
        bool result = true;
        string insertStr;
        SqlConnection conn = db.OpenConn();
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            DataRow row = dt.Rows[i];
            insertStr = "insert into YingYSPinfo (YingYSP) values('"
                + row["YingYSP"].ToString() + "')";
            SqlCommand MyCmd = new SqlCommand(insertStr, conn);
            try
            {
                MyCmd.ExecuteNonQuery();
            }
            catch
            {
                result = false;
                break;
            }
       
        }
        db.DisposeConn(conn);
        if (result)
            lbl_info2.Text = "插入操作成功！";
        else
            lbl_info2.Text = "插入操作失败！";      
    }
}