辦公自動(dòng)化系統(tǒng)設(shè)計(jì)文件

1、Web開(kāi)發(fā)與應(yīng)用技術(shù)設(shè)計(jì)文檔項(xiàng)目名稱：辦公自動(dòng)化系統(tǒng) 完成日期：2012-01-05 目 錄 TOC o 1-3 h z 3338第五章 系統(tǒng)模塊劃分8 一、系統(tǒng)設(shè)計(jì)背景辦公自動(dòng)化（Office Automation System，OAS）系統(tǒng)，是利用先進(jìn)的計(jì)算機(jī)信息技術(shù)和現(xiàn)代辦公設(shè)備構(gòu)成的人機(jī)信息處理系統(tǒng)，輔助治理人員進(jìn)行各種辦公活動(dòng)。辦公自動(dòng)化系統(tǒng)由辦公機(jī)構(gòu)、辦公人員、辦公設(shè)備、網(wǎng)絡(luò)環(huán)境、辦公信息等幾個(gè)差不多要素構(gòu)成。本系統(tǒng)開(kāi)發(fā)的目的是緊密結(jié)合目前政府機(jī)關(guān)和企事業(yè)單位的辦公業(yè)務(wù)流程和治理特點(diǎn)，開(kāi)發(fā)一套先進(jìn)的、綜合的、完整的、同時(shí)能有效的在局域網(wǎng)和廣域網(wǎng)運(yùn)行的辦公自動(dòng)化系統(tǒng)。通過(guò)該系統(tǒng)的使用

2、，可有效地提高政府機(jī)關(guān)和企事業(yè)單位的工作效率，提升應(yīng)用單位信息化治理的水平，減少工作人員的工作量，降低政府機(jī)關(guān)和企事業(yè)單位的成本。二、系統(tǒng)需求分析數(shù)據(jù)層上，實(shí)現(xiàn)對(duì)職員部門信息的修改、刪除、更新等操作，同時(shí)記錄考勤狀況。2.業(yè)務(wù)層上，實(shí)現(xiàn)各種與數(shù)據(jù)層的交互工作。3.視覺(jué)上，盡可能的做到人機(jī)交互，簡(jiǎn)明、易明白。4.主界面上顯示當(dāng)前日期，展示經(jīng)理風(fēng)采。三、系統(tǒng)功能介紹登錄功能【系統(tǒng)治理員】查看公告考勤治理（設(shè)置上下班時(shí)刻，治理職員的簽到、簽退等）系統(tǒng)設(shè)置（設(shè)置個(gè)人密碼，為系統(tǒng)設(shè)置新的治理員等）部門治理（編輯新增加的部門以及部門信息的維護(hù)工作）【一般用戶】個(gè)人操作（包括查看系統(tǒng)公告，修改個(gè)人登錄密碼）

3、考勤簽到（完成個(gè)人考勤，即簽到和簽退功能的實(shí)現(xiàn)）查看系統(tǒng)公告上下班簽到時(shí)刻設(shè)置上下班簽到功能密碼重置功能添加新治理員設(shè)置新建部門功能更新部門信息四、系統(tǒng)流程圖 登錄 登錄 系統(tǒng)治理員 一般職員修改個(gè)人信息修改密碼信息修改部門信息修改考勤信息修改個(gè)人密碼查看公告考勤簽到簽退五、系統(tǒng)模塊劃分【模塊劃分】登錄模塊職員治理模塊治理員和一般職員模塊數(shù)據(jù)維護(hù)模塊上班簽到的查詢部門增刪信息更新模塊六、數(shù)據(jù)庫(kù)設(shè)計(jì)數(shù)據(jù)庫(kù)中存在8個(gè)表單分不如下:七、詳細(xì)設(shè)計(jì)及實(shí)現(xiàn)連接數(shù)據(jù)庫(kù)：Web.configue:BaseClass那個(gè)實(shí)現(xiàn)連接的類：using System;using System.Data;using Sy

4、stem.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;using System.Collections;/ / BaseClass 的摘要講明/ public class BaseClass : System.Web.UI

5、.Page public BaseClass() / / TODO: 在此處添加構(gòu)造函數(shù)邏輯 / #region 顯?示?客戶端?對(duì)?話框 / / WebMessageBox用?來(lái)?在客戶端?彈獺?出?對(duì)?話框。 / / 對(duì)?話框顯?示?內(nèi)容 / public string MessageBox(string TxtMessage) string str; str = alert( + TxtMessage + ); return str; #endregion #region 執(zhí)行DSQL語(yǔ)?句? / / 用?來(lái)?執(zhí)行DSQL語(yǔ)?句? / / sQueryString SQL字?符?串? /

6、 操作痢?是?否?成功|(TrueFalse) public Boolean ExecSQL(string sQueryString) SqlConnection con = new SqlConnection(ConfigurationManager.AppSettingsconStr); con.Open(); SqlCommand dbCommand = new SqlCommand(sQueryString, con); if (dbCommand.ExecuteNonQuery() 0) con.Close(); return true; else con.Close(); retu

7、rn false; / / 公?告?信?息添?加 / / 標(biāo)括?題琣 / 公?告?內(nèi)容 / 發(fā)?布?公?告?人? / public Boolean ExecProcNotice(string title, string content, string person)/執(zhí)行D公?告?程序 SqlConnection con = new SqlConnection(ConfigurationManager.AppSettingsconStr); con.Open(); SqlCommand cmd = new SqlCommand(insert_tb_notice, con); cmd.Comma

8、ndType = CommandType.StoredProcedure; /公?告?標(biāo)括?題琣 SqlParameter pTitle = new SqlParameter(noticeTitle, SqlDbType.VarChar, 80);/設(shè)?置?數(shù)簓據(jù)Y庫(kù)a參?數(shù)簓 pTitle.Value = title; cmd.Parameters.Add(pTitle); /公?告?詳細(xì)?內(nèi)容 SqlParameter pContent = new SqlParameter(noticeContent, SqlDbType.Text, 0); /0為aText默?認(rèn)?存?儲(chǔ)洹?的?最?大洙

9、?值 pContent.Value = content; cmd.Parameters.Add(pContent); /公?告?發(fā)?布?人? SqlParameter pPerson = new SqlParameter(noticePerson, SqlDbType.VarChar, 20); pPerson.Value=person; cmd.Parameters.Add(pPerson); /判D斷?運(yùn)?行D結(jié)果? if (cmd.ExecuteNonQuery() 0) con.Close(); return true; else con.Close(); return false;

10、#endregion #region 查詢SQL語(yǔ)?句? / /?執(zhí)行D查詢戧?戧?語(yǔ)?句? / / sQueryString SQL字?符?串? / TableName 數(shù)簓據(jù)Y表括?名?稱? / public System.Data.DataSet GetDataSet(string sQueryString, string TableName) SqlConnection con = new SqlConnection(ConfigurationManager.AppSettingsconStr); /string s1 = ConfigurationManager.Connection

11、StringsconStr.ConnectionString; / SqlConnection con = new SqlConnection(s1); SqlDataAdapter dbAdapter = new SqlDataAdapter(sQueryString, con); DataSet dataset = new DataSet(); dbAdapter.Fill(dataset, TableName); return dataset; #endregion以部門信息修改為例寫(xiě)出各項(xiàng)數(shù)據(jù)綁定操作using System;using System.Data;using System

12、.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;public partial class BaseInfo_BaseDepartmentAdd : System.Web.UI.Page protected void Page_Lo

13、ad(object sender, EventArgs e) if (SessionloginName = null) Response.Write(this.parent.location.href=./Default.aspx); protected void imgBtnSave_Click(object sender, ImageClickEventArgs e) BaseClass bc = new BaseClass(); Boolean bl; bl = bc.ExecSQL(insert into department values( + txtName.Text + , +

14、txtContent.Text+ , +txtid.Text +); if (bl) Response.Write(bc.MessageBox(新建部門成功!); else Response.Write(bc.MessageBox(新建部門失敗!); protected void imgBtnClear_Click(object sender, ImageClickEventArgs e) txtName.Text = ; txtContent.Text = ; using System;using System.Data;using System.Configuration;using Sy

15、stem.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;public partial class BaseInfo_BaseDepartmentManager : System.Web.UI.Page BaseClass bc = new BaseClass(); protected

16、 void Page_Load(object sender, EventArgs e) if (SessionloginName = null) Response.Write(this.parent.location.href=./Default.aspx); return; GridView1.DataSource = bc.GetDataSet(select * from department, department); GridView1.DataKeyNames = new String deptid ; GridView1.DataBind(); protected void Gri

17、dView1_PageIndexChanging(object sender, GridViewPageEventArgs e) GridView1.PageIndex = e.NewPageIndex; GridView1.DataBind(); protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) try bc.ExecSQL(delete from department where deptid= + this.GridView1.DataKeyse.RowIndex.Value.To

18、String() + ); GridView1.DataSource = bc.GetDataSet(select * from department, department); GridView1.DataBind(); catch (Exception ex) Response.Write(bc.MessageBox(ex.Message); using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security

19、;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;public partial class BaseInfo_BaseDepartmentUpdate : System.Web.UI.Page BaseClass bc = new BaseClass(); protected void Page_Load(object sender, EventArgs e) if (Sessionlogin

20、Name = null) Response.Write(this.parent.location.href=./Default.aspx); return; if (!IsPostBack) DataSet ds = bc.GetDataSet(select * from department where deptid= + Request.QueryStringid.ToString() + , department); txtName.Text = ds.Tables0.Rows01.ToString(); txtContent.Text = ds.Tables0.Rows02.ToString(); protected void imgBtnSave_Click(object sender, ImageClickEventArgs e) Bool