选中提交

//zr1.aspx.csusing 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 zr1 : System.Web.UI.Page
{
    SqlConnection conn = new SqlConnection("Server=(local);UID=sa;PWD=123456;Database=jspcl");
    DataSet de = new DataSet();
    SqlDataAdapter da;
    protected void Page_Load(object sender, EventArgs e)
    {
        Label1.Text = Session["adminname"].ToString();
        TextBox1.Text = Session["adminname"].ToString();
        TextBox1.Enabled = false;
        if (!this.IsPostBack)
        {
            ViewState["SortOrder"] = "swh";
            ViewState["OrderDire"] = "ASC";
            BindGrid();
        }
    }
    protected void BindGrid()//数据显示
    {
        da = new SqlDataAdapter("select swh,lwdw,wjzt,rq,sy,nbr from wenjian where pylx = '未审批'", conn);
        DataSet ds = new DataSet();
        try
        {
            da.Fill(ds, "wenjian");
            DataView view = ds.Tables["wenjian"].DefaultView;
            string sort = (string)ViewState["SortOrder"] + " " + (string)ViewState["OrderDire"];
            view.Sort = sort;
            dv1.DataSource = view;
            dv1.DataBind();
        }
        catch (Exception err)
        {
            Response.Write(err.ToString());
        }
    }    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        dv1.PageIndex = 0;
        BindGrid();
    }
    protected void LinkButton2_Click(object sender, EventArgs e)
    {
        if (dv1.PageIndex > 0)
            dv1.PageIndex -= 1;
        BindGrid();
    }
    protected void LinkButton3_Click(object sender, EventArgs e)
    {
        if (dv1.PageIndex < dv1.PageCount - 1)
            dv1.PageIndex += 1;
        BindGrid();
    }
    protected void LinkButton4_Click(object sender, EventArgs e)
    {
        if (dv1.PageCount > 0)
            dv1.PageIndex = (dv1.PageCount - 1);
        BindGrid();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection("Server=(local);UID=sa;PWD=123456;Database=jspcl");
        conn.Open();
        for (int i = 0; i < dv1.Rows.Count; i++)
        { 
            
            if (dv1.Rows[i].Cells[0].Enabled == false)
            {
                string nbr = dv1.Rows[i].Cells[7].Text.ToString();
                string swh = dv1.Rows[i].Cells[2].Text.ToString();
                string pylx = dv1.Rows[i].Cells[1].Text.ToString();
                string sql = "insert into nbrinfor(name,nbr,swh,pylx,pyrq) values('" + TextBox1.Text + "','" + nbr + "','" + swh + "','" + pylx + "','" + System.DateTime.Now + "')";
                SqlCommand cmd = new SqlCommand(sql, conn);
                try
                {
                    cmd.ExecuteNonQuery();
                    BindGrid();
                    Response.Write("<script>alert('" + "提交成功！" + "')</script>");
                    Response.Redirect("zr1.aspx");                }
                catch (Exception err)
                {
                    Response.Write(err.ToString());
                }
                finally
                {
                    conn.Close();
                }
            }
        }
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        TextBox1.Text = "";
    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        Response.Redirect("first.aspx");
    }
    protected void dv1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName.Equals("shenpi"))
        {
            for (int index = 0; index < Convert.ToInt32(e.CommandArgument) + 1; index++)
            {
                Session["swh"] = dv1.Rows[index].Cells[2].Text;
                Session["pylx"] = dv1.Rows[index].Cells[1].Text;
                SqlConnection conn = new SqlConnection("Server=(local);UID=sa;PWD=123456;Database=jspcl");
                conn.Open();
                string sql = "update wenjian set pylx='三级已审批',pylxer='" + TextBox1.Text + "' where swh='" + dv1.Rows[index].Cells[2].Text + "'";
                SqlCommand cmd = new SqlCommand(sql, conn);
                cmd.ExecuteNonQuery();
                conn.Close();
                dv1.Rows[index].Cells[1].Text = "三级已审批";
                dv1.Rows[index].Cells[0].Enabled = false;
                dv1.Rows[index].Cells[1].Enabled = false;
            }
        }
    }
    protected void dv1_PageIndexChanging1(object sender, GridViewPageEventArgs e)
    {
        dv1.PageIndex = e.NewPageIndex;
        BindGrid();
    }
}