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

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

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

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

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

5、統(tǒng)采納B/S模式混合應(yīng)用，后臺(tái)實(shí)現(xiàn)職員治理、工資治理、用戶治理等數(shù)據(jù)的添加、修改、刪除的功能。掃瞄器要緊實(shí)現(xiàn)能將個(gè)人差不多信息、個(gè)人考勤統(tǒng)計(jì)等通過(guò)網(wǎng)絡(luò)展現(xiàn)給職員，使整個(gè)治理系統(tǒng)更具科學(xué)性、準(zhǔn)確性。服務(wù)器端要緊實(shí)現(xiàn)對(duì)后臺(tái)和前臺(tái)端請(qǐng)求數(shù)據(jù)的業(yè)務(wù)邏輯的處理回應(yīng)。數(shù)據(jù)庫(kù)的治理等功能。3.2 數(shù)據(jù)庫(kù)配置本網(wǎng)站是在windows 7下開(kāi)發(fā)的，數(shù)據(jù)庫(kù)使用的是Sql Server 2005。具體配置步驟如下：新建空數(shù)據(jù)庫(kù)，取名為Salary.mdf。在Salary.mdf中建表dbo.tb_Emp、tb_User、dbo.tb_Wage 等數(shù)據(jù)庫(kù)表。完成數(shù)據(jù)初始化工作，將表中各字段與域值添加到里面去。3.3

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

7、信息。4.1.3職員信息顯示能夠方便職員按編號(hào)、姓名來(lái)搜索更讓人信息。 ListEmps.aspx要緊功能代碼： public partial class web_ListEmps : System.Web.UI.Page BLL.EmpLogic B_emps = new BLL.EmpLogic(); MODEL.EmpInfo M_emps = new MODEL.EmpInfo(); protected void Page_Load(object sender, EventArgs e) if (!Page.IsPostBack) if (Sessionusername = null)

8、 Response.Redirect(Default.aspx); LoadEmpInfo(); protected void 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.Gr

9、idView1.DataBind(); else if (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(); public void LoadEmpInfo() GridView1.DataSource = B_emps.GetDa

10、ta_emps(); GridView1.DataBind(); public void GridView1_RowDataBound(object sender,GridViewRowEventArgs e) /設(shè)置鼠標(biāo)的指向行標(biāo)效果 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.Attr

11、ibutes.Add(onmouseout, this.style.backgroundColor=#99CCFF;this.style.color=#FFFFFF;); public void GridView1_PageIndexChanging(object sender,GridViewPageEventArgs e) this.GridView1.PageIndex = e.NewPageIndex; LoadEmpInfo(); 4.14工資信息顯示 能夠方便職員用工資編號(hào)、職員編號(hào)來(lái)進(jìn)行搜索自己的薪酬信息。ListWages.aspx要緊功能代碼：public partial c

12、lass web_ListWages : System.Web.UI.Page BLL.WageLogic B_wages = new BLL.WageLogic(); MODEL.WageInfo M_wages = new MODEL.WageInfo(); protected void Page_Load(object sender, EventArgs e) if (!Page.IsPostBack) if (Sessionusername = null) Response.Redirect(Default.aspx); LoadWageInfo(); protected void S

13、earchNews_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(); else if (this.DropDownList1.SelectedVal

14、ue.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(); public void LoadWageInfo() GridView1.DataSource = B_wages.GetData_wages(); GridView1.DataBind(); public voi

15、d GridView1_RowDataBound(object sender, GridViewRowEventArgs e) /設(shè)置鼠標(biāo)的指向行標(biāo)效果 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.backgrou

16、ndColor=#99CCFF;this.style.color=#FFFFFF;); public void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) this.GridView1.PageIndex = e.NewPageIndex; LoadWageInfo(); 4.15個(gè)人治理中心（1）用戶能夠自己注冊(cè)個(gè)人信息。同時(shí)能夠點(diǎn)擊修改注冊(cè)信息進(jìn)入修改頁(yè)面，點(diǎn)擊返回退出到前臺(tái)治理頁(yè)面。Login.ascx要緊功能代碼：public partial class Login : System.Web.U

17、I.UserControl MODEL.UserInfo M_userinfo = new MODEL.UserInfo(); BLL.UserLogic B_userlogic = new BLL.UserLogic(); static int KKK = 0; static string KKName = ; protected void Page_Load(object sender, EventArgs e) if (!Page.IsPostBack) if (KKK = 0) this.login_1.Visible = true; this.login_2.Visible = fa

18、lse; else this.login_1.Visible = false; this.login_2.Visible = true; Sessionusername = KKName; Label.Text = KKName; protected void Login1_Click(object sender, EventArgs e) M_userinfo.UserName = this.UserName.Text.Trim(); M_userinfo.Password = FormsAuthentication.HashPasswordForStoringInConfigFile(th

19、is.Password.Text.Trim(), MD5); /M_userinfo.Password = this.Password.Text.Trim(); if (UserName.Text = | Password.Text = ) Response.Write(alert(請(qǐng)輸入必要信息！);history.back();); else if (UserName.Text != & Password.Text != ) if (B_userlogic.AdminLogin(M_userinfo) 0) Sessionadmin = M_userinfo.UserName.ToStri

20、ng(); Response.Redirect(./Web/adminManager/Admin_Index.aspx); else if (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(賬號(hào)錯(cuò)誤！);hist

21、ory.back();); protected void Cancel_Click(object sender, EventArgs e) this.UserName.Text = ; this.Password.Text = ; KKK = 0; this.UserName.Focus(); Session.Clear(); protected void Login_out_Click(object sender, EventArgs e) this.login_1.Visible = true; this.login_2.Visible = false; KKK = 0; this.Use

22、rName.Text = ; this.Password.Text = ; KKName = ; this.UserName.Focus(); Session.Clear(); （2）用戶能夠治理個(gè)人信息。同時(shí)能夠點(diǎn)擊修改注冊(cè)信息進(jìn)入修改頁(yè)面，點(diǎn)擊返回退出到前臺(tái)治理頁(yè)面。UserCenter.aspx要緊功能代碼： public partial class web_UserCenter : System.Web.UI.Page BLL.UserLogic Ba = new BLL.UserLogic(); MODEL.UserInfo Ma = new MODEL.UserInfo(); pr

23、otected void Page_Load(object sender, EventArgs e) if (!Page.IsPostBack) if (Sessionusername = null) Response.Write(alert(數(shù)據(jù)庫(kù)操作出錯(cuò)！);); else DataBindUserInfo(); public void DataBindUserInfo() Ma.UserName = Sessionusername.ToString(); DataSet ds = Ba.QueryUserInfoByName(Ma); this.Email.Text = ds.Table

24、s0.Rows03.ToString(); this.TextBox1.Text = ds.Tables0.Rows01.ToString(); this.TextBox2.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(); pr

25、otected void LinkButton1_Click(object sender, EventArgs e) if (tb1.Visible) tb1.Visible = false; tb2.Visible = true; else tb1.Visible = true; tb2.Visible = false; protected void CheckUser_Click(object sender, EventArgs e) Ma.UserName = this.TextBox1.Text.Trim(); if (Ba.CheckUser(Ma) 0) Response.Writ

26、e(alert(該用戶已存在！);); this.TextBox1.Text = ; this.Reg.Enabled = false; else Response.Write(alert(該用戶能夠注冊(cè)！);); this.Reg.Enabled = true; protected void Reg_Click(object sender, EventArgs e) Ma.UserName = this.TextBox1.Text.Trim(); Ma.Password = FormsAuthentication.HashPasswordForStoringInConfigFile(this

27、.UserPwd1.Text.Trim(), MD5); Ma.UserEmail = this.TextBox2.Text.Trim(); Ma.Lever = 一般用戶; if (Ba.AddUser(Ma) Response.Write(alert(修改成功！);); Sessionusername = Ma.UserName.ToString(); Response.Redirect(UserCenter.aspx); protected void Button1_Click(object sender, EventArgs e) Response.Redirect(Default.a

28、spx); 4.1.6后臺(tái)登錄（1）為了使系統(tǒng)更加安全，內(nèi)部信息不被泄露，因此必須輸入用戶名以及密碼才能登錄，必須是治理員進(jìn)行治理。Admin_Login.aspx要緊功能代碼：public partial class web_adminManager_Admin_Login : System.Web.UI.Page MODEL.UserInfo Ma = new MODEL.UserInfo(); BLL.UserLogic Ba = new BLL.UserLogic(); protected void Page_Load(object sender, EventArgs e) if (!

29、Page.IsPostBack) protected void btn_Cancel_Click(object sender, EventArgs e) UserName.Text = ; PassWord.Text = ; this.UserName.Focus(); protected void btn_Login_Click(object sender, EventArgs e) if (UserName.Text.Equals() Response.Write(alert(請(qǐng)輸入治理員用戶名！); if (PassWord.Text.Equals() Response.Write(al

30、ert(請(qǐng)輸入治理員密碼！); Ma.UserName = UserName.Text.Trim(); Ma.Password = FormsAuthentication.HashPasswordForStoringInConfigFile(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.R

31、edirect(Admin_Login.aspx); （2）輸入治理員用戶：admin 治理員密碼：admin 進(jìn)入后臺(tái)治理頁(yè)面：治理員實(shí)現(xiàn)職員治理系統(tǒng)、工資管系統(tǒng)、用戶治理系統(tǒng)等功能。Admin_Index.aspx4.1.7職員信息治理能夠方便治理員按職員編號(hào)、姓名搜索職員信息進(jìn)行治理。Admin_ListEmps.aspx要緊功能代碼： public partial class web_adminManager_Admin_EmpsList : System.Web.UI.Page BLL.EmpLogic B_emps = new BLL.EmpLogic(); MODEL.EmpIn

32、fo M_emps = new MODEL.EmpInfo(); protected void Page_Load(object sender, EventArgs e) if (!Page.IsPostBack) if (Sessionadmin = null) Response.Redirect(Admin_Login.aspx); LoadEmpInfo(); protected void SearchNews_Click(object sender, EventArgs e) /處理模糊查詢方向 if (this.DropDownList1.SelectedValue.ToString

33、().Equals(empNo) M_emps.E_id = int.Parse(this.TextBox1.Text.Trim(); this.GridView1.DataSource = B_emps.QueryEmpInfoByID(M_emps); this.GridView1.DataBind(); else if (this.DropDownList1.SelectedValue.ToString().Equals(name) M_emps.E_name = this.TextBox1.Text.Trim(); this.GridView1.DataSource = B_emps.

34、QueryEmpInfoByName(M_emps); this.GridView1.DataBind(); else LoadEmpInfo(); public void LoadEmpInfo() GridView1.DataSource = B_emps.GetData_emps(); GridView1.DataBind(); public void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) /設(shè)置鼠標(biāo)的指向行標(biāo)效果 if (e.Row.RowType = DataControlRowType.DataR

35、ow) 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=#666633;this.style.color=#FFFFFF;); public void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs

36、e) this.GridView1.PageIndex = e.NewPageIndex; LoadEmpInfo(); 點(diǎn)擊修改進(jìn)入修改職員信息頁(yè)面：Admin_EditEmps.aspx要緊功能代碼：public partial class web_adminManager_Admin_EditEmps : System.Web.UI.Page MODEL.EmpInfo M_emps = new MODEL.EmpInfo(); BLL.EmpLogic B_emps = new BLL.EmpLogic(); protected void Page_Load(object sender

37、, EventArgs e) if (!Page.IsPostBack) Sessionid = int.Parse(Request.QueryStringeid.ToString(); M_emps.E_id = int.Parse(Request.QueryStringeid.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.To

38、String(); this.home.Value = ds.Tables0.Rows04.ToString(); this.race.Value = ds.Tables0.Rows05.ToString(); cate.Value = ds.Tables0.Rows06.ToString(); this.dept.Value = ds.Tables0.Rows07.ToString(); this.position.Value = ds.Tables0.Rows08.ToString(); this.telephone.Value = ds.Tables0.Rows010.ToString(

39、); protected void Btn_OK_Click(object sender, EventArgs e) M_emps.E_id = int.Parse(Request.QueryStringeid.ToString(); M_emps.E_name = .Value.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_e

40、mps.Dept = this.dept.Value.Trim(); M_emps.Position = this.position.Value.Trim(); M_emps.Telephone = this.telephone.Value.Trim(); if (B_emps.UpdateNews(M_emps) Response.Write(if(confirm(按確定接著操作，按取消回到系統(tǒng)主頁(yè)); Response.Write(window.location=Admin_ListEmps.aspx;); Response.Write(elsewindow.location=Admin_

41、right.aspx;); protected void Reset_Click(object sender, EventArgs e) .Value = ; this.sex.Value = ; this.home.Value = ; this.race.Value = ; cate.Value = ; this.dept.Value = ; this.position.Value = ; this.telephone.Value = ; 4.1.8添加職員信息頁(yè)面了解每一位職員的個(gè)人信息，進(jìn)行有效的治理。Admin_AddEmps.aspx要緊功能代碼： public partial cl

42、ass web_adminManager_Admin_AddEmps : System.Web.UI.Page MODEL.EmpInfo M_emps = new MODEL.EmpInfo(); BLL.EmpLogic B_emps = new BLL.EmpLogic(); protected void Page_Load(object sender, EventArgs e) if (!Page.IsPostBack) if (Sessionadmin = null) /Response.Write(alert(你還沒(méi)有登錄系統(tǒng)，請(qǐng)返回主頁(yè)登錄系統(tǒng)！);); Response.Red

43、irect(Admin_Login.aspx); protected void Btn_OK_Click(object sender, EventArgs e) M_emps.E_name = .Value.Trim(); M_emps.Sex = this.sex.Value.Trim(); M_emps.Birthday = Convert.ToDateTime(this.birthday.Value.Trim(); M_emps.Home = this.home.Value.Trim(); M_emps.Race = this.race.Value.Trim(); M_emps.Educ

44、ate = 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.Value.Trim(); M_emps.Telephone = this.telephone.Value.Trim(); if (B_emps.AddEmps(M_emps) Response.Write(if(confirm(按確定接著公布，按取消回到系統(tǒng)主頁(yè)); Response.Wr

45、ite(window.location=Admin_AddEmps.aspx;); Response.Write(elsewindow.location=Admin_right.aspx;); else Response.Write(alert(數(shù)據(jù)庫(kù)操作有錯(cuò)誤！);); Response.Write(); protected void Reset_Click(object sender, EventArgs e) .Value = ; this.sex.Value = ; this.birthday.Value = ; this.home.Value = ; this.race.Value

46、= ; cate.Value = ; this.dept.Value = ; this.position.Value=; this.time.Value = ; this.telephone.Value = ; 4.1.9工資治理頁(yè)面能夠方便治理員按職員編號(hào)、姓名搜索職職員資信息進(jìn)行治理。Admin_ListWages.aspx主用功能代碼：public partial class web_adminManager_Admin_WagesList : System.Web.UI.Page BLL.WageLogic B_wages = new BLL.WageLogic(); MODEL.Wa

47、geInfo M_wages = new MODEL.WageInfo(); protected void Page_Load(object sender, EventArgs e) if (!Page.IsPostBack) if (Sessionadmin = null) Response.Redirect(Admin_Login.aspx); LoadWageInfo(); protected void SearchNews_Click(object sender, EventArgs e) /處理模糊查詢方向 if (this.DropDownList1.SelectedValue.T

48、oString().Equals(wageNo) M_wages.W_id = int.Parse(this.TextBox1.Text.Trim(); this.GridView1.DataSource = B_wages.QueryWageInfoByWID(M_wages); this.GridView1.DataBind(); else if (this.DropDownList1.SelectedValue.ToString().Equals(empNo) M_wages.E_id = int.Parse(this.TextBox1.Text.Trim(); this.GridVie

49、w1.DataSource = B_wages.QueryWageInfoByEID(M_wages); this.GridView1.DataBind(); else LoadWageInfo(); public void LoadWageInfo() GridView1.DataSource = B_wages.GetData_wages(); GridView1.DataBind(); public void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) /設(shè)置鼠標(biāo)的指向行標(biāo)效果 if (e.Row.RowTy

50、pe = 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=#666633;this.style.color=#FFFFFF;); public void GridView1_PageIndexChanging(object s

51、ender, GridViewPageEventArgs e) this.GridView1.PageIndex = e.NewPageIndex; LoadWageInfo(); 4.1.10修改工資信息點(diǎn)擊修改進(jìn)入修改工資信息頁(yè)面：依照職員的個(gè)人表現(xiàn)來(lái)隨時(shí)更改薪酬嘉獎(jiǎng)職員，鼓舞職員再接再厲。 Admin_EditWages.aspx要緊功能代碼：public partial class web_adminManager_EditWages : System.Web.UI.Page MODEL.WageInfo M_wages = new MODEL.WageInfo(); BLL.Wage

52、Logic B_wages = new BLL.WageLogic(); protected void Page_Load(object sender, EventArgs e) if (!Page.IsPostBack) Sessionid = int.Parse(Request.QueryStringwid.ToString(); M_wages.W_id = int.Parse(Request.QueryStringwid.ToString(); DataSet ds = B_wages.DataBindWages(M_wages); if (ds.Tables0.Rows.Count

53、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.ToString(); this.withhold.Value = ds.Tables0.Rows05.ToString(); this.beforetax.Value = ds.Tables0.Rows06.ToString

54、(); this.taxbate.Value = ds.Tables0.Rows07.ToString(); this.aftertax.Value = ds.Tables0.Rows08.ToString(); protected void Btn_OK_Click(object sender, EventArgs e) M_wages.W_id = int.Parse(Request.QueryStringwid.ToString(); M_wages.B_wage = this.bwage.Value.Trim(); M_wages.P_wage = this.pwage.Value.T

55、rim(); 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.Aftertax = this.aftertax.Value.Trim(); if (B_wages.UpdateWages(M_wages) Response.Write(if(confirm(按確定接著

56、操作，按取消回到系統(tǒng)主頁(yè)); Response.Write(window.location=Admin_ListWages.aspx;); Response.Write(elsewindow.location=Admin_right.aspx;); protected void Reset_Click(object sender, EventArgs e) this.bwage.Value = ; this.pwage.Value = ; this.bonus.Value = ; this.withhold.Value = ; this.beforetax.Value = ; this.tax

57、bate.Value = ; this.aftertax.Value = ; 4.1.11添加工資信息Admin_AddWages.aspx主用功能代碼：public partial class web_adminManager_Admin_AddWages : System.Web.UI.Page MODEL.WageInfo M_wages = new MODEL.WageInfo(); BLL.WageLogic B_wages = new BLL.WageLogic(); protected void Page_Load(object sender, EventArgs e) if (

58、!Page.IsPostBack) if (Sessionadmin = null) /Response.Write(alert(你還沒(méi)有登錄系統(tǒng)，請(qǐng)返回主頁(yè)登錄系統(tǒng)！);); Response.Redirect(Admin_Login.aspx); protected void Btn_OK_Click(object sender, EventArgs e) M_wages.E_id = int.Parse(this.empno.Value.Trim(); M_wages.B_wage = this.bwage.Value.Trim(); M_wages.P_wage = this.pwag

59、e.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.Aftertax = this.aftertax.Value.Trim(); if (B_wages.AddWages(M_wages) Response.Write(if(confirm

60、(按確定接著公布，按取消回到系統(tǒng)主頁(yè)); Response.Write(window.location=Admin_AddWages.aspx;); Response.Write(elsewindow.location=Admin_right.aspx;); else Response.Write(alert(數(shù)據(jù)庫(kù)操作有錯(cuò)誤！);); Response.Write(); protected void Reset_Click(object sender, EventArgs e) this.empno.Value = ; this.bwage.Value = ; this.pwage.Valu