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

1、煤礦員工薪資管理系統(tǒng)摘 要在信息技術(shù)高速發(fā)展的今天，傳統(tǒng)的數(shù)據(jù)統(tǒng)計(jì)方式在處理龐大繁雜的信息量時(shí)顯得力不從心，于是，人們對(duì)于運(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ì)錄是非常合適的，不僅查詢和修改方便，并且效率高，速度快，完全能夠滿足現(xiàn)代化公司管理的需要，同時(shí)也更利于實(shí)現(xiàn)全面辦公自動(dòng)化。因此開發(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)很方便真正實(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ù)器，Web服

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

4、析系統(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ī)劃已經(jīng)比較清晰，所有，在功能需求分析階段，我們綜合需求調(diào)查的結(jié)果和我們建站的經(jīng)驗(yàn)，所以，本站功能需求經(jīng)過(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è)系統(tǒng)采用B/S模式混

5、合應(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下開發(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ù)初始化工作，將表中各字段與域值添加進(jìn)去。3.3數(shù)據(jù)表設(shè)計(jì)3.3.1 數(shù)據(jù)庫(kù)

6、的概念結(jié)構(gòu)設(shè)計(jì)新系統(tǒng)邏輯方案中的數(shù)據(jù)流程圖和數(shù)據(jù)字典對(duì)新系統(tǒng)描述已經(jīng)很清晰，經(jīng)過(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)站的大門，讓人們了解這個(gè)系統(tǒng)的具體內(nèi)容，同時(shí)展現(xiàn)出本系統(tǒng)整體美觀的畫面效果，方便用戶登錄來(lái)實(shí)現(xiàn)網(wǎng)站的功能。Default.aspx4.1.2前臺(tái)頁(yè)面登錄輸入用戶名2015，密碼123進(jìn)入前臺(tái)頁(yè)面，方便用戶來(lái)查看員工的個(gè)人信息、工資信息。4.1.3員工信息顯示可以方

7、便員工按編號(hào)、姓名來(lái)搜索更讓人信息。 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è)置鼠標(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

11、.backgroundColor=#99CCFF;this.style.color=#FFFFFF;); publicvoid GridView1_PageIndexChanging(object sender,GridViewPageEventArgs e) this.GridView1.PageIndex = e.NewPageIndex; LoadEmpInfo(); 4.14工資信息顯示可以方便員工用工資編號(hào)、員工編號(hào)來(lái)進(jìn)行搜索自己的薪酬信息。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è)置鼠標(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.backgroundColor=#99CCFF;this.style.color=#FFFFFF;); public

16、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主要功能代碼：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(請(qǐng)輸入必要信息！);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(賬號(hào)錯(cuò)誤！);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）用戶可以管理個(gè)人信息。同時(shí)可以點(diǎn)擊修改注冊(cè)信息進(jìn)入修改頁(yè)面，點(diǎn)擊返回退出到前臺(tái)管理頁(yè)面。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ù)庫(kù)操作出錯(cuò)！);); 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、該用戶可以注冊(cè)！););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后臺(tái)登錄（1）為了使系統(tǒng)更加安全，內(nèi)部信息不被泄露，所以必須輸入用戶名以及密碼才能登錄，必須是管理員進(jìn)行管理。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(請(qǐng)輸入管理員用戶名！); if (PassWord.Text.Equals() Response.Write(alert(請(qǐng)輸入管理員密碼！); 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 進(jìn)入后臺(tái)管理頁(yè)面：管理員實(shí)現(xiàn)員工管理系統(tǒng)、工資管系統(tǒng)、用戶管理系統(tǒng)等功能。Admin_Index.asp

31、x4.1.7員工信息管理可以方便管理員按員工編號(hào)、姓名搜索員工信息進(jìn)行管理。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è)置鼠標(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;

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(); 點(diǎn)擊修改進(jìn)入修改員工信息頁(yè)面：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)主頁(yè)); 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添加員工信息頁(yè)面了解每一位員工的個(gè)人信息，進(jìn)行有效的管理。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(你還沒(méi)有登錄系統(tǒng)，請(qǐng)返回主頁(yè)登錄系統(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)主頁(yè)); Response.Write(window.location=Admin_AddEmps.aspx;); Response.Write(elsewindow.location=Admin_right.aspx;); else Response.Write(alert(數(shù)據(jù)庫(kù)操作有錯(cuò)誤！);); 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工資管理頁(yè)面可以方便管理員按員工編號(hào)、姓名搜索員工工資信息進(jìn)行管理。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è)置鼠標(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(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修改工資信息點(diǎn)擊修改進(jìn)入修改工資信息頁(yè)面：根據(jù)員工的個(gè)人表現(xiàn)來(lái)隨時(shí)更改薪酬嘉獎(jiǎng)員工，鼓勵(lì)員工再接再厲。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)主頁(yè)); 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(你還沒(méi)有登錄系統(tǒng)，請(qǐng)返回主頁(yè)登錄系統(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)主頁(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(); 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）方便管理員對(duì)用戶的修改和刪除。Admin_AllUsers.aspx（2）添加新用戶信息：主要功能代碼：publicpartialclassweb_adminManag