选中提交
//zr1.aspx文件<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="zr1.aspx.cs" Inherits="zr1" Title="考核系统" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder2" Runat="Server">
<center>
<table height="40" width="660">
<tr>
<td style="height: 20px">
</td>
<td style="height: 20px; width: 364px;">
</td>
</tr>
<tr>
<td>
欢迎您!<asp:Label ID="Label1" runat="server"></asp:Label>
<asp:HyperLink ID="HyperLink3" runat="server" NavigateUrl="~/Default.aspx">退出</asp:HyperLink></td>
<td style="vertical-align: middle; width: 364px; text-align: right">
<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/zr1.aspx">审批文件</asp:HyperLink>
<asp:HyperLink ID="HyperLink2" runat="server" NavigateUrl="~/zr2.aspx">审批记录</asp:HyperLink>
</td>
</tr>
</table>
</center>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<table height="580" width="660">
<tr>
<td align="center" valign="top">
<asp:GridView ID="dv1" runat="server" BackColor="White" BorderColor="#999999" BorderStyle="None"
BorderWidth="1px" CellPadding="3" DataKeyNames="swh" GridLines="Vertical" OnRowCommand="dv1_RowCommand" AllowPaging="True" AutoGenerateColumns="False" OnPageIndexChanging="dv1_PageIndexChanging1">
<FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
<Columns>
<asp:ButtonField CommandName="shenpi" Text="三级审批" HeaderText="操作"/>
<asp:ButtonField HeaderText="结果" />
<asp:BoundField DataField="swh" HeaderText="文件号" />
<asp:BoundField DataField="lwdw" HeaderText="单位" />
<asp:BoundField DataField="wjzt" HeaderText="文件主题" />
<asp:BoundField DataField="rq" HeaderText="日期" />
<asp:BoundField DataField="sy" HeaderText="事由" />
<asp:BoundField DataField="nbr" HeaderText="申报人" />
</Columns>
<RowStyle BackColor="#EEEEEE" ForeColor="Black" />
<SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
<HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="Gainsboro" />
</asp:GridView>
<br />
<asp:LinkButton ID="LinkButton1" runat="server" OnClick="LinkButton1_Click">最前页</asp:LinkButton>
<asp:LinkButton ID="LinkButton2" runat="server" OnClick="LinkButton2_Click">上一页</asp:LinkButton><asp:LinkButton
ID="LinkButton3" runat="server" OnClick="LinkButton3_Click">下一页</asp:LinkButton>
<asp:LinkButton ID="LinkButton4" runat="server" OnClick="LinkButton4_Click">最后页</asp:LinkButton><br />
<br />
<br />
<asp:Label ID="Label2" runat="server" Text="填写审批人姓名:"></asp:Label>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br />
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="提交" />
<asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="取消" />
<asp:Button ID="Button3" runat="server" OnClick="Button3_Click" Text="退出" /><br />
</td>
</tr>
</table>
</asp:Content>
--------------------编程问答-------------------- //zr1.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;
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();
}
}
--------------------编程问答-------------------- 单击时20行“操作”列的“二级审批”时,出现下图的效果
怎样才能选中第20行,而只改变第20行的数据,而不是从17到20全部改变? --------------------编程问答-------------------- 再补充一句,若单击上面页面第一条记录时,也就是第17行的“二级审批”
按提交正常,保存数据库正常,查询结果正常,一切正常
我的三级审批页面这种症状同样存在
跪求各路大虾出手相助挖
补充:.NET技术 , ASP.NET