煤礦員工工資管理系統(tǒng)

1、煤礦員工薪資管理系統(tǒng)摘 要在信息技術(shù)高速發(fā)展的今天，傳統(tǒng)的數(shù)據(jù)統(tǒng)計方式在處理龐大繁雜的信息量時顯得力不從心，于是，人們對于運用計算機來輔助和管理工作的需求正在逐步提高。隨著各個煤礦業(yè)務(wù)的逐步擴展，煤礦的員工人數(shù)也在迅速增加，由于管理人員水平有限,導(dǎo)致某些員工紀錄管理并不完善，特別是繁雜的員工工資管理紀錄，不易查詢、修改，極易導(dǎo)致錯誤，而落后的員工管理方法隨著社會的日益競爭,必將被淘汰。由計算機來管理龐大而繁雜的公司員工紀錄是非常合適的，不僅查詢和修改方便，并且效率高，速度快，完全能夠滿足現(xiàn)代化公司管理的需要，同時也更利于實現(xiàn)全面辦公自動化。因此開發(fā)一套煤礦員工工資管理系統(tǒng)軟件勢在必行。員工工資

2、管理系統(tǒng)的主要任務(wù)是用計算機對員工檔案資料（包括員工工資紀錄）進行查詢、修改、增加、刪除以及存儲；對符合條件的記錄進行查詢、統(tǒng)計、輸出等；用計算機快速、準確地完成各種紀錄資料的統(tǒng)計和匯總工作；迅速地打印出各種報表資料。它可使管理人員節(jié)省大量時間,而且使用起來很方便真正實現(xiàn)了管理的自動化。關(guān)鍵詞： 財務(wù)管理 互聯(lián)網(wǎng) 系統(tǒng)設(shè)計第一章 緒 論1.1 瀏覽器/服務(wù)器模型WWW是構(gòu)建在瀏覽器/服務(wù)器（B/S）模型以及http協(xié)議的基礎(chǔ)上的，其運作模式可以描述為：請求處理應(yīng)答。從瀏覽器提交的請求通過Web服務(wù)器給應(yīng)用程序服務(wù)器，由它調(diào)用相關(guān)的網(wǎng)頁應(yīng)用程序進行處理，處理的結(jié)果由網(wǎng)頁交給Web服務(wù)器，Web服

3、務(wù)器把這個網(wǎng)頁作為對請求的應(yīng)答發(fā)還給瀏覽器。至于對提交的信息如何處理，就交由網(wǎng)站的開發(fā)人員編寫相關(guān)的網(wǎng)頁應(yīng)用程序來決定反饋到瀏覽器的內(nèi)容；如果需要對數(shù)據(jù)庫進行訪問，開發(fā)人員還可以利用應(yīng)用程序服務(wù)器所提供的接口對其進行訪問。網(wǎng)頁內(nèi)容的動態(tài)發(fā)布是Web應(yīng)用程序的主要實現(xiàn)方法，通常這種方法同服務(wù)器端提供的WWW服務(wù)技術(shù)密不可分。一般來說，在Internet服務(wù)器上可以通過多種途徑實現(xiàn)。第二章 系統(tǒng)分析2.1功能需求分析需求分析是軟件生命周期的一個重要階段，它根本的任務(wù)是確定為了滿足用戶的需要必須做什么。具體地說，應(yīng)該確定系統(tǒng)必須具有的功能和性能，系統(tǒng)要求的運行環(huán)境，并且預(yù)測系統(tǒng)發(fā)展的前景，必須仔細分

4、析系統(tǒng)中的數(shù)據(jù)，既要分析系統(tǒng)中的數(shù)據(jù)流。又要分析長期使用的數(shù)據(jù)存儲，通過分析應(yīng)該得出新系統(tǒng)邏輯方案數(shù)據(jù)流圖、數(shù)據(jù)字典等，為系統(tǒng)的設(shè)計奠定基礎(chǔ)。通過上面的用戶調(diào)查，本系統(tǒng)初步規(guī)劃已經(jīng)比較清晰，所有，在功能需求分析階段，我們綜合需求調(diào)查的結(jié)果和我們建站的經(jīng)驗，所以，本站功能需求經(jīng)過以上分析最后整理如下：能夠貯存大量原始員工數(shù)據(jù)和有用信息的數(shù)據(jù)庫。能夠高速自動處理大量與員工有關(guān)的各項數(shù)據(jù)的電子計算機系統(tǒng)。為各級管理人員提供員工基本情況、工資等查詢顯示員工信息的終端設(shè)備。能夠迅速地把員工信息傳輸給計算機，并把各計算中心站連結(jié)起來的計算機網(wǎng)絡(luò)系統(tǒng)。第三章 系統(tǒng)設(shè)計3.1 整體設(shè)計整個系統(tǒng)采用B/S模式混

5、合應(yīng)用，后臺實現(xiàn)員工管理、工資管理、用戶管理等數(shù)據(jù)的添加、修改、刪除的功能。瀏覽器主要實現(xiàn)能將個人基本信息、個人考勤統(tǒng)計等通過網(wǎng)絡(luò)展現(xiàn)給員工，使整個管理系統(tǒng)更具科學(xué)性、準確性。服務(wù)器端主要實現(xiàn)對后臺和前臺端請求數(shù)據(jù)的業(yè)務(wù)邏輯的處理回應(yīng)。數(shù)據(jù)庫的管理等功能。3.2 數(shù)據(jù)庫配置本網(wǎng)站是在windows 7下開發(fā)的，數(shù)據(jù)庫使用的是Sql Server 2005。具體配置步驟如下：新建空數(shù)據(jù)庫，取名為Salary.mdf。在Salary.mdf中建表dbo.tb_Emp、tb_User、dbo.tb_Wage等數(shù)據(jù)庫表。完成數(shù)據(jù)初始化工作，將表中各字段與域值添加進去。3.3數(shù)據(jù)表設(shè)計3.3.1 數(shù)據(jù)庫

6、的概念結(jié)構(gòu)設(shè)計新系統(tǒng)邏輯方案中的數(shù)據(jù)流程圖和數(shù)據(jù)字典對新系統(tǒng)描述已經(jīng)很清晰，經(jīng)過前面可行性論證后，下面就可以在此基礎(chǔ)上進行系統(tǒng)的數(shù)據(jù)庫結(jié)構(gòu)設(shè)計。3.3.2 數(shù)據(jù)庫表數(shù)據(jù)庫名：Salary表名：dbo.tb_Emp表名：tb_User表名：dbo.tb_Wage第四章 系統(tǒng)詳細設(shè)計4.1 具體頁面設(shè)計如下：4.1.1首頁設(shè)計首頁是一個網(wǎng)站的大門，讓人們了解這個系統(tǒng)的具體內(nèi)容，同時展現(xiàn)出本系統(tǒng)整體美觀的畫面效果，方便用戶登錄來實現(xiàn)網(wǎng)站的功能。Default.aspx4.1.2前臺頁面登錄輸入用戶名2015，密碼123進入前臺頁面，方便用戶來查看員工的個人信息、工資信息。4.1.3員工信息顯示可以方

7、便員工按編號、姓名來搜索更讓人信息。 ListEmps.aspx主要功能代碼：publicpartialclassweb_ListEmps : System.Web.UI.Page BLL.EmpLogic B_emps = new BLL.EmpLogic(); MODEL.EmpInfo M_emps = new MODEL.EmpInfo();protectedvoid Page_Load(object sender, EventArgs e) if (!Page.IsPostBack) if (Sessionusername = null) Response.Redirect(Defa

8、ult.aspx); LoadEmpInfo(); protectedvoid SearchNews_Click(object sender, EventArgs e) /處理模糊查詢方向if (this.DropDownList1.SelectedValue.ToString().Equals(empNo) M_emps.E_id = int.Parse(this.TextBox1.Text.Trim();this.GridView1.DataSource = B_emps.QueryEmpInfoByID(M_emps);this.GridView1.DataBind(); elseif

9、(this.DropDownList1.SelectedValue.ToString().Equals(name) M_emps.E_name = this.TextBox1.Text.Trim();this.GridView1.DataSource = B_emps.QueryEmpInfoByName(M_emps);this.GridView1.DataBind(); else LoadEmpInfo(); publicvoid LoadEmpInfo() GridView1.DataSource = B_emps.GetData_emps(); GridView1.DataBind()

10、; publicvoid GridView1_RowDataBound(object sender,GridViewRowEventArgs e) /設(shè)置鼠標的指向行標效果if (e.Row.RowType = DataControlRowType.DataRow) e.Row.Attributes.Add(onmouseover, this.style.backgroundColor=#CCCCCC;this.style.color=#FFFFFF;this.style.cursor=#CCCCCC;); e.Row.Attributes.Add(onmouseout, this.style

11、.backgroundColor=#99CCFF;this.style.color=#FFFFFF;); publicvoid GridView1_PageIndexChanging(object sender,GridViewPageEventArgs e) this.GridView1.PageIndex = e.NewPageIndex; LoadEmpInfo(); 4.14工資信息顯示可以方便員工用工資編號、員工編號來進行搜索自己的薪酬信息。ListWages.aspx主要功能代碼：publicpartialclassweb_ListWages : System.Web.UI.Pag

12、e BLL.WageLogic B_wages = new BLL.WageLogic(); MODEL.WageInfo M_wages = new MODEL.WageInfo();protectedvoid Page_Load(object sender, EventArgs e) if (!Page.IsPostBack) if (Sessionusername = null) Response.Redirect(Default.aspx); LoadWageInfo(); protectedvoid SearchNews_Click(object sender, EventArgs

13、e) /處理模糊查詢方向if (this.DropDownList1.SelectedValue.ToString().Equals(wageNo) M_wages.W_id = int.Parse(this.TextBox1.Text.Trim();this.GridView1.DataSource = B_wages.QueryWageInfoByWID(M_wages);this.GridView1.DataBind(); elseif (this.DropDownList1.SelectedValue.ToString().Equals(empNo) M_wages.E_id = in

14、t.Parse(this.TextBox1.Text.Trim();this.GridView1.DataSource = B_wages.QueryWageInfoByEID(M_wages);this.GridView1.DataBind(); else LoadWageInfo(); publicvoid LoadWageInfo() GridView1.DataSource = B_wages.GetData_wages(); GridView1.DataBind(); publicvoid GridView1_RowDataBound(object sender, GridViewR

15、owEventArgs e) /設(shè)置鼠標的指向行標效果if (e.Row.RowType = DataControlRowType.DataRow) e.Row.Attributes.Add(onmouseover, this.style.backgroundColor=#CCCCCC;this.style.color=#FFFFFF;this.style.cursor=#CCCCCC;); e.Row.Attributes.Add(onmouseout, this.style.backgroundColor=#99CCFF;this.style.color=#FFFFFF;); public

16、void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) this.GridView1.PageIndex = e.NewPageIndex; LoadWageInfo(); 4.15個人管理中心（1）用戶可以自己注冊個人信息。同時可以點擊修改注冊信息進入修改頁面，點擊返回退出到前臺管理頁面。Login.ascx主要功能代碼：publicpartialclassLogin : System.Web.UI.UserControl MODEL.UserInfo M_userinfo = new MODEL.Us

17、erInfo(); BLL.UserLogic B_userlogic = new BLL.UserLogic();staticint KKK = 0;staticstring KKName = ;protectedvoid Page_Load(object sender, EventArgs e) if (!Page.IsPostBack) if (KKK = 0) this.login_1.Visible = true;this.login_2.Visible = false; else this.login_1.Visible = false;this.login_2.Visible =

18、 true; Sessionusername = KKName; Label.Text = KKName; protectedvoid Login1_Click(object sender, EventArgs e) M_userinfo.UserName = this.UserName.Text.Trim(); M_userinfo.Password = FormsAuthentication.HashPasswordForStoringInConfigFile(this.Password.Text.Trim(), MD5);/M_userinfo.Password = this.Passw

19、ord.Text.Trim();if (UserName.Text = | Password.Text = ) Response.Write(alert(請輸入必要信息！);history.back();); else if (UserName.Text != & Password.Text != ) if (B_userlogic.AdminLogin(M_userinfo) 0) Sessionadmin = M_userinfo.UserName.ToString(); Response.Redirect(./Web/adminManager/Admin_Index.aspx); els

20、eif (B_userlogic.UserLogin(M_userinfo) 0) this.login_1.Visible = false;this.login_2.Visible = true; KKK = 1; KKName = UserName.Text.ToString();this.Label.Text = KKName; Sessionusername = KKName; else Response.Write(alert(賬號錯誤！);history.back();); protectedvoid Cancel_Click(object sender, EventArgs e)

21、 this.UserName.Text = ;this.Password.Text = ; KKK = 0;this.UserName.Focus(); Session.Clear(); protectedvoid Login_out_Click(object sender, EventArgs e) this.login_1.Visible = true;this.login_2.Visible = false; KKK = 0;this.UserName.Text = ;this.Password.Text = ; KKName = ;this.UserName.Focus(); Sess

22、ion.Clear(); （2）用戶可以管理個人信息。同時可以點擊修改注冊信息進入修改頁面，點擊返回退出到前臺管理頁面。UserCenter.aspx主要功能代碼：publicpartialclassweb_UserCenter : System.Web.UI.Page BLL.UserLogic Ba = new BLL.UserLogic(); MODEL.UserInfo Ma = new MODEL.UserInfo();protectedvoid Page_Load(object sender, EventArgs e) if (!Page.IsPostBack) if (Sessi

23、onusername = null) Response.Write(alert(數(shù)據(jù)庫操作出錯！);); else DataBindUserInfo(); publicvoid DataBindUserInfo() Ma.UserName = Sessionusername.ToString();DataSet ds = Ba.QueryUserInfoByName(Ma);this.Email.Text = ds.Tables0.Rows03.ToString();this.TextBox1.Text = ds.Tables0.Rows01.ToString();this.TextBox2.

24、Text = ds.Tables0.Rows03.ToString();this.aleave.Text = ds.Tables0.Rows04.ToString();this.UserName.Text = ds.Tables0.Rows01.ToString();this.TodayTime.Text = System.DateTime.Now.ToShortDateString().ToString(); protectedvoid LinkButton1_Click(object sender, EventArgs e) if (tb1.Visible) tb1.Visible = f

25、alse; tb2.Visible = true; else tb1.Visible = true; tb2.Visible = false; protectedvoid CheckUser_Click(object sender, EventArgs e) Ma.UserName = this.TextBox1.Text.Trim();if (Ba.CheckUser(Ma) 0) Response.Write(alert(該用戶已存在！););this.TextBox1.Text = ;this.Reg.Enabled = false; else Response.Write(alert(

26、該用戶可以注冊！););this.Reg.Enabled = true; protectedvoid Reg_Click(object sender, EventArgs e) Ma.UserName = this.TextBox1.Text.Trim(); Ma.Password = FormsAuthentication.HashPasswordForStoringInConfigFile(this.UserPwd1.Text.Trim(), MD5); Ma.UserEmail = this.TextBox2.Text.Trim(); Ma.Lever = 普通用戶;if (Ba.Add

27、User(Ma) Response.Write(alert(修改成功！);); Sessionusername = Ma.UserName.ToString(); Response.Redirect(UserCenter.aspx); protectedvoid Button1_Click(object sender, EventArgs e) Response.Redirect(Default.aspx); 4.1.6后臺登錄（1）為了使系統(tǒng)更加安全，內(nèi)部信息不被泄露，所以必須輸入用戶名以及密碼才能登錄，必須是管理員進行管理。Admin_Login.aspx主要功能代碼：publicpart

28、ialclassweb_adminManager_Admin_Login : System.Web.UI.Page MODEL.UserInfo Ma = new MODEL.UserInfo(); BLL.UserLogic Ba = new BLL.UserLogic();protectedvoid Page_Load(object sender, EventArgs e) if (!Page.IsPostBack) protectedvoid btn_Cancel_Click(object sender, EventArgs e) UserName.Text = ; PassWord.T

29、ext = ;this.UserName.Focus(); protectedvoid btn_Login_Click(object sender, EventArgs e) if (UserName.Text.Equals() Response.Write(alert(請輸入管理員用戶名！); if (PassWord.Text.Equals() Response.Write(alert(請輸入管理員密碼！); Ma.UserName = UserName.Text.Trim(); Ma.Password = FormsAuthentication.HashPasswordForStorin

30、gInConfigFile(PassWord.Text.Trim(), MD5); /Ma.Password = PassWord.Text.Trim();if (Ba.AdminLogin(Ma) 0) Sessionadmin = UserName.Text.Trim(); Response.Redirect(Admin_Index.aspx); else Response.Redirect(Admin_Login.aspx); （2）輸入管理員用戶：admin 管理員密碼：admin 進入后臺管理頁面：管理員實現(xiàn)員工管理系統(tǒng)、工資管系統(tǒng)、用戶管理系統(tǒng)等功能。Admin_Index.asp

31、x4.1.7員工信息管理可以方便管理員按員工編號、姓名搜索員工信息進行管理。Admin_ListEmps.aspx主要功能代碼：publicpartialclassweb_adminManager_Admin_EmpsList : System.Web.UI.Page BLL.EmpLogic B_emps = new BLL.EmpLogic(); MODEL.EmpInfo M_emps = new MODEL.EmpInfo();protectedvoid Page_Load(object sender, EventArgs e) if (!Page.IsPostBack) if (Se

32、ssionadmin = null) Response.Redirect(Admin_Login.aspx); LoadEmpInfo(); protectedvoid SearchNews_Click(object sender, EventArgs e) /處理模糊查詢方向if (this.DropDownList1.SelectedValue.ToString().Equals(empNo) M_emps.E_id = int.Parse(this.TextBox1.Text.Trim();this.GridView1.DataSource = B_emps.QueryEmpInfoBy

33、ID(M_emps);this.GridView1.DataBind(); elseif (this.DropDownList1.SelectedValue.ToString().Equals(name) M_emps.E_name = this.TextBox1.Text.Trim();this.GridView1.DataSource = B_emps.QueryEmpInfoByName(M_emps);this.GridView1.DataBind(); else LoadEmpInfo(); publicvoid LoadEmpInfo() GridView1.DataSource

34、= B_emps.GetData_emps(); GridView1.DataBind(); publicvoid GridView1_RowDataBound(object sender, GridViewRowEventArgs e) /設(shè)置鼠標的指向行標效果if (e.Row.RowType = DataControlRowType.DataRow) e.Row.Attributes.Add(onmouseover, this.style.backgroundColor=#CCCCCC;this.style.color=#FFFFFF;this.style.cursor=#CCCCCC;

35、); e.Row.Attributes.Add(onmouseout, this.style.backgroundColor=#666633;this.style.color=#FFFFFF;); publicvoid GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) this.GridView1.PageIndex = e.NewPageIndex; LoadEmpInfo(); 點擊修改進入修改員工信息頁面：Admin_EditEmps.aspx主要功能代碼：publicpartialclassweb_a

36、dminManager_Admin_EditEmps : System.Web.UI.Page MODEL.EmpInfo M_emps = new MODEL.EmpInfo(); BLL.EmpLogic B_emps = new BLL.EmpLogic();protectedvoid Page_Load(object sender, EventArgs e) if (!Page.IsPostBack) Sessionid = int.Parse(Request.QueryStringeid.ToString(); M_emps.E_id = int.Parse(Request.Quer

37、yStringeid.ToString();DataSet ds = B_emps.DataBindEmps(M_emps);if (ds.Tables0.Rows.Count 0) .Value = ds.Tables0.Rows01.ToString();this.sex.Value = ds.Tables0.Rows02.ToString();this.home.Value = ds.Tables0.Rows04.ToString();this.race.Value = ds.Tables0.Rows05.ToString();cate.Value = ds.Tables0.Rows06

38、.ToString();this.dept.Value = ds.Tables0.Rows07.ToString();this.position.Value = ds.Tables0.Rows08.ToString();this.telephone.Value = ds.Tables0.Rows010.ToString(); protectedvoid Btn_OK_Click(object sender, EventArgs e) M_emps.E_id = int.Parse(Request.QueryStringeid.ToString(); M_emps.E_name = .Value

39、.Trim(); M_emps.Sex = this.sex.Value.Trim(); M_emps.Home = this.home.Value.Trim(); M_emps.Race = this.race.Value.Trim(); M_emps.Educate = cate.Value.Trim(); M_emps.Dept = this.dept.Value.Trim(); M_emps.Position = this.position.Value.Trim(); M_emps.Telephone = this.telephone.Value.Trim();if (B_emps.U

40、pdateNews(M_emps) Response.Write(if(confirm(按確定繼續(xù)操作，按取消回到系統(tǒng)主頁); Response.Write(window.location=Admin_ListEmps.aspx;); Response.Write(elsewindow.location=Admin_right.aspx;); protectedvoid Reset_Click(object sender, EventArgs e) .Value = ;this.sex.Value = ;this.home.Value = ;this.race.Value = ;cate.Va

41、lue = ;this.dept.Value = ;this.position.Value = ;this.telephone.Value = ; 4.1.8添加員工信息頁面了解每一位員工的個人信息，進行有效的管理。Admin_AddEmps.aspx主要功能代碼：publicpartialclassweb_adminManager_Admin_AddEmps : System.Web.UI.Page MODEL.EmpInfo M_emps = new MODEL.EmpInfo(); BLL.EmpLogic B_emps = new BLL.EmpLogic();protectedvoi

42、d Page_Load(object sender, EventArgs e) if (!Page.IsPostBack) if (Sessionadmin = null) /Response.Write(alert(你還沒有登錄系統(tǒng)，請返回主頁登錄系統(tǒng)！);); Response.Redirect(Admin_Login.aspx); protectedvoid Btn_OK_Click(object sender, EventArgs e) M_emps.E_name = .Value.Trim(); M_emps.Sex = this.sex.Value.Trim(); M_emps.B

43、irthday = Convert.ToDateTime(this.birthday.Value.Trim(); M_emps.Home = this.home.Value.Trim(); M_emps.Race = this.race.Value.Trim(); M_emps.Educate = cate.Value.Trim(); M_emps.Dept = this.dept.Value.Trim(); M_emps.Position = this.position.Value.Trim(); M_emps.E_time = Convert.ToDateTime(this.time.Va

44、lue.Trim(); M_emps.Telephone = this.telephone.Value.Trim();if (B_emps.AddEmps(M_emps) Response.Write(if(confirm(按確定繼續(xù)發(fā)布，按取消回到系統(tǒng)主頁); Response.Write(window.location=Admin_AddEmps.aspx;); Response.Write(elsewindow.location=Admin_right.aspx;); else Response.Write(alert(數(shù)據(jù)庫操作有錯誤！);); Response.Write(); pr

45、otectedvoid Reset_Click(object sender, EventArgs e) .Value = ;this.sex.Value = ;this.birthday.Value = ;this.home.Value = ;this.race.Value = ;cate.Value = ;this.dept.Value = ;this.position.Value=;this.time.Value = ;this.telephone.Value = ; 4.1.9工資管理頁面可以方便管理員按員工編號、姓名搜索員工工資信息進行管理。Admin_ListWages.aspx主用

46、功能代碼：publicpartialclassweb_adminManager_Admin_WagesList : System.Web.UI.Page BLL.WageLogic B_wages = new BLL.WageLogic(); MODEL.WageInfo M_wages = new MODEL.WageInfo();protectedvoid Page_Load(object sender, EventArgs e) if (!Page.IsPostBack) if (Sessionadmin = null) Response.Redirect(Admin_Login.asp

47、x); LoadWageInfo(); protectedvoid SearchNews_Click(object sender, EventArgs e) /處理模糊查詢方向if (this.DropDownList1.SelectedValue.ToString().Equals(wageNo) M_wages.W_id = int.Parse(this.TextBox1.Text.Trim();this.GridView1.DataSource = B_wages.QueryWageInfoByWID(M_wages);this.GridView1.DataBind(); elseif

48、(this.DropDownList1.SelectedValue.ToString().Equals(empNo) M_wages.E_id = int.Parse(this.TextBox1.Text.Trim();this.GridView1.DataSource = B_wages.QueryWageInfoByEID(M_wages);this.GridView1.DataBind(); else LoadWageInfo(); publicvoid LoadWageInfo() GridView1.DataSource = B_wages.GetData_wages(); Grid

49、View1.DataBind(); publicvoid GridView1_RowDataBound(object sender, GridViewRowEventArgs e) /設(shè)置鼠標的指向行標效果if (e.Row.RowType = DataControlRowType.DataRow) e.Row.Attributes.Add(onmouseover, this.style.backgroundColor=#CCCCCC;this.style.color=#FFFFFF;this.style.cursor=#CCCCCC;); e.Row.Attributes.Add(onmou

50、seout, this.style.backgroundColor=#666633;this.style.color=#FFFFFF;); publicvoid GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) this.GridView1.PageIndex = e.NewPageIndex; LoadWageInfo(); 4.1.10修改工資信息點擊修改進入修改工資信息頁面：根據(jù)員工的個人表現(xiàn)來隨時更改薪酬嘉獎員工，鼓勵員工再接再厲。Admin_EditWages.aspx主要功能代碼：publicpa

51、rtialclassweb_adminManager_EditWages : System.Web.UI.Page MODEL.WageInfo M_wages = new MODEL.WageInfo(); BLL.WageLogic B_wages = new BLL.WageLogic();protectedvoid Page_Load(object sender, EventArgs e) if (!Page.IsPostBack) Sessionid = int.Parse(Request.QueryStringwid.ToString(); M_wages.W_id = int.P

52、arse(Request.QueryStringwid.ToString();DataSet ds = B_wages.DataBindWages(M_wages);if (ds.Tables0.Rows.Count 0) this.empno.Value = ds.Tables0.Rows01.ToString();this.bwage.Value = ds.Tables0.Rows02.ToString();this.pwage.Value = ds.Tables0.Rows03.ToString();this.bonus.Value = ds.Tables0.Rows04.ToStrin

53、g();this.withhold.Value = ds.Tables0.Rows05.ToString();this.beforetax.Value = ds.Tables0.Rows06.ToString();this.taxbate.Value = ds.Tables0.Rows07.ToString();this.aftertax.Value = ds.Tables0.Rows08.ToString(); protectedvoid Btn_OK_Click(object sender, EventArgs e) M_wages.W_id = int.Parse(Request.Que

54、ryStringwid.ToString(); M_wages.B_wage = this.bwage.Value.Trim(); M_wages.P_wage = this.pwage.Value.Trim(); M_wages.Bonus = this.bonus.Value.Trim(); M_wages.Withhold = this.withhold.Value.Trim(); M_wages.Beforetax = this.beforetax.Value.Trim(); M_wages.Taxbate = this.taxbate.Value.Trim(); M_wages.Af

55、tertax = this.aftertax.Value.Trim();if (B_wages.UpdateWages(M_wages) Response.Write(if(confirm(按確定繼續(xù)操作，按取消回到系統(tǒng)主頁); Response.Write(window.location=Admin_ListWages.aspx;); Response.Write(elsewindow.location=Admin_right.aspx;); protectedvoid Reset_Click(object sender, EventArgs e) this.bwage.Value = ;t

56、his.pwage.Value = ;this.bonus.Value = ;this.withhold.Value = ;this.beforetax.Value = ;this.taxbate.Value = ;this.aftertax.Value = ; 4.1.11添加工資信息Admin_AddWages.aspx主用功能代碼：publicpartialclassweb_adminManager_Admin_AddWages : System.Web.UI.Page MODEL.WageInfo M_wages = new MODEL.WageInfo(); BLL.WageLogi

57、c B_wages = new BLL.WageLogic();protectedvoid Page_Load(object sender, EventArgs e) if (!Page.IsPostBack) if (Sessionadmin = null) /Response.Write(alert(你還沒有登錄系統(tǒng)，請返回主頁登錄系統(tǒng)！);); Response.Redirect(Admin_Login.aspx); protectedvoid Btn_OK_Click(object sender, EventArgs e) M_wages.E_id = int.Parse(this.e

58、mpno.Value.Trim(); M_wages.B_wage = this.bwage.Value.Trim(); M_wages.P_wage = this.pwage.Value.Trim(); M_wages.Bonus = this.bonus.Value.Trim(); M_wages.Withhold = this.withhold.Value.Trim(); M_wages.Beforetax = this.beforetax.Value.Trim(); M_wages.Taxbate = this.taxbate.Value.Trim(); M_wages.Afterta

59、x = this.aftertax.Value.Trim();if (B_wages.AddWages(M_wages) Response.Write(if(confirm(按確定繼續(xù)發(fā)布，按取消回到系統(tǒng)主頁); Response.Write(window.location=Admin_AddWages.aspx;); Response.Write(elsewindow.location=Admin_right.aspx;); else Response.Write(alert(數(shù)據(jù)庫操作有錯誤！);); Response.Write(); protectedvoid Reset_Click(

60、object sender, EventArgs e) this.empno.Value = ;this.bwage.Value = ;this.pwage.Value = ;this.bonus.Value = ;this.withhold.Value = ;this.beforetax.Value = ;this.taxbate.Value = ;this.aftertax.Value = ; 4.1.12管理系統(tǒng)用戶（1）方便管理員對用戶的修改和刪除。Admin_AllUsers.aspx（2）添加新用戶信息：主要功能代碼：publicpartialclassweb_adminManag