{
DataGrid1.EditItemIndex = e.Item.ItemIndex; DataGrid1.DataBind(); } private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e) {
DataGrid1.CurrentPageIndex = e.NewPageIndex; DataGrid1.DataBind(); }
private void add_button_Click(object sender, System.EventArgs e) {
string k;
k =Request.QueryString[\ SqlConnection MyConn = new SqlConnection(\=127.0.0.1;uid=sa;pwd=;database=whtzkj\
string strupdate=\[Salary] set UserID=\+ TextBox2.Text +\\+ \+ TextBox3.Text + \
+ TextBox4.Text + \+ \+ \+ TextBox5.Text + \+\+ \+ TextBox6.Text + \
\+TextBox7.Text + \+\+ \+ TextBox8.Text + \+ \+ \+ TextBox9.Text + \ SalaryID= \
SqlCommand strcmd = new SqlCommand(strupdate,MyConn); strcmd.Connection.Open(); strcmd.ExecuteNonQuery(); strcmd.Connection.Close();
Response.Write(\修改成功!'); window.location.href='wageModify.aspx';\ }
（4）工资浏览页面：非工资管理人员是不能进入工资浏览界面的，管理人员进去浏览界面后，会看到公司所
有员工的工资信息。如图5.3.4(a)。 ·28· 武汉航海（武汉航海职业技术学院学报） 2008年第1期 private void Button3_Click(object sender, System.EventArgs e) {
Year = TextBox3.Text; Month =TextBox4.Text;
sqlDataAdapter1.SelectCommand.CommandText = \Year +
\ try {
sqlDataAdapter1.Fill(dsSalary1);
DataGrid1.DataBind(); } catch { } finally { } }
private void Button4_Click(object sender, System.EventArgs e) {
UserID = TextBox5.Text;
sqlDataAdapter1.SelectCommand.CommandText = \UserID; try {
sqlDataAdapter1.Fill(dsSalary1); DataGrid1.DataBind(); } catch { } finally { } }
private void Button5_Click(object sender, System.EventArgs e) {
Dept = TextBox6.Text;
sqlDataAdapter1.SelectCommand.CommandText = \* from Salary where Dept = '\+ Dept + \
sqlDataAdapter1.Fill(dsSalary1); DataGrid1.DataBind(); } Private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e) {
DataGrid1.CurrentPageIndex = e.NewPageIndex; DataGrid1.DataBind(); }
（3）工资修改界面：只有工资管理人员才能进入该界面，该界面如图5.3.3(a)。
2008年第1期 胡娟 基于B/S 模式的工资管理系统 ·27· [Month] =\ try {
sqlDataAdapter1.Fill(dataSet1); DataGrid1.DataBind(); } catch { } finally { } }
工资管理人员查询界面，如图5.3.2(c)
图5.3.2(c)
该界面实现代码如下：
private void Button1_Click(object sender, System.EventArgs e) {
Year = TextBox1.Text ;
sqlDataAdapter1.SelectCommand.CommandText = \ try {
sqlDataAdapter1.Fill(dsSalary1); DataGrid1.DataBind(); } catch { } finally { } }
private void Button2_Click(object sender, System.EventArgs e) {
Month = TextBox2.Text ;
sqlDataAdapter1.SelectCommand.CommandText = \* from Salary where [Month] =\+ Month; try {
sqlDataAdapter1.Fill(dsSalary1); DataGrid1.DataBind(); } catch { } finally { }
} ·26· 武汉航海（武汉航海职业技术学院学报） 2008年第1期
图5.3.2(a)
员工查询界面如图5.3.2(b)
图5.3.2(b)
该界面实现代码：
private void Button1_Click(object sender, System.EventArgs e) {
Year = TextBox1.Text ;
sqlDataAdapter1.SelectCommand.CommandText = \+ \
[UserID] =\ try {
sqlDataAdapter1.Fill(dataSet1); DataGrid1.DataBind(); } catch { } finally { }
}
private void Button2_Click(object sender, System.EventArgs e) {
Month = TextBox2.Text ;
sqlDataAdapter1.SelectCommand.CommandText = \Month + \ [UserID] =\ try {
sqlDataAdapter1.Fill(dataSet1); DataGrid1.DataBind(); } catch { } finally { } }
private void Button3_Click(object sender, System.EventArgs e) {
Year = TextBox3.Text; Month =TextBox4.Text;
sqlDataAdapter1.SelectCommand.CommandText = \* from Salary where [Year] = \+ Year + \年第1期 胡娟 基于B/S 模式的工资管理系统 ·25·
private void add_button_Click(object sender, System.EventArgs e) {
dbComm=new SqlCommand(strSQL,sqlConnection1); if(Page.IsValid) {
StringstrSQL=\
INTOSalary(SalaryID,UserID,Dept,Year,Month,Bouns,BasicWage,AllWage,Remark)
VALUES(@SalaryID,@UserID,@Dept,@Year,@Month,@Bouns,@BasicWage,@AllWage,@Remark)\
SqlCommand dbComm=new SqlCommand(strSQL,sqlConnection1); dbComm.Parameters.Add(\
dbComm.Parameters.Add(\ dbComm.Parameters.Add(\ dbComm.Parameters.Add(\ dbComm.Parameters.Add(\ dbComm.Parameters.Add(\ dbComm.Parameters.Add(\arChar,50); dbComm.Parameters.Add(\ dbComm.Parameters.Add(\ dbComm.Parameters[\ dbComm.Parameters[\ dbComm.Parameters[\ dbComm.Parameters[\ dbComm.Parameters[\