员工工资管理系统模块设计(2)

{

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[\

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库员工工资管理系统模块设计(2)在线全文阅读。