??????? Help Desk

1
??????? Help Desk IT ????

• ???? ???
• ? ? ??? n934020010
• ??? m9322406016
• ??? n934020027

2
????

• ????
• ????
• ????
• ??????
• ?????

1. ????
2. SQL Create Table
3. ???????
4. ??????
5. ????
6. ??

3
????

• ???IT???????????,?????????????????????????
• ????IT???????,??????,??????????????????????????,??
  ???????????
• ????????,????????????,????????????????????????????
  ?,?????????????????
• ?????????,????????????????????,???????????????
• ????????????,???????,????????,?????????????

4
????

• ????????????IT?????,IT???????????Help Desk -
  IT?????
• ????
• ??????????????
• ????????????,?????????????????????????????
• ? IT ???????????????????????????
• ??????????????,?? IT ????????????????

5
????

• ???
• ?????????,??????????????????
• ????
• ??IT?????????,????????IT??,????IT?????????
• ???
• ???????ID?????????Email????????
• ??
• ?????????????????
• ??
• ???????????
• ????
• ???????????????,??????????
• ????
• ??IT???????

6
??????

• ???????
• ??????
• ?????
• ??????
• ???????
• ??????
• ?????
• ????
• ?????
• ?????
• ????????
• ???????????

7
?????
N
N
RegionID
ReqLog
Location
Process
REQLOG
belong3
RegoinName
N
1
record
ReqID
1
UsrName
1
FinishDate
UsrID
Requst
1
N
Password
request
USR
REQFORM
Status
N
Email
1
Priority
N
N
Ext
Manager
ExpectDate
ApplyDate
with
belong
own
1
1
N
1
1
N
REQTYPE
DEPT
belong2
Skill
has
DeptID
ReqType
ReqDays
ReqName
DeptName
Skill
ReqLevel
8
????
9
SQL Create Table
CREATE TABLE REQTYPE (ReqType VARCHAR(10) NOT NULL, ReqName VARCHAR(20) NOT NULL, ReqDay INT NOT NULL, PRIMARY KEY (ReqType) )
CREATE TABLE LOCATION (RegionID VARCHAR(20) NOT NULL, RegionName VARCHAR(20) NOT NULL, PRIMARY KEY (RegionID) )
CREATE TABLE DEPT (DeptID VARCHAR(6) NOT NULL, DeptName VARCHAR(12) NOT NULL, RegionID VARCHAR(20) NOT NULL, PRIMARY KEY (DeptID), FOREIGN KEY (RegionID) REFERENCES LOCATION (RegionID) )
10
SQL Create Table
CREATE TABLE USR (UsrID VARCHAR(20) NOT NULL, UsrName VARCHAR(40) NOT NULL, Email VARCHAR(40), Ext VARCHAR(10), DeptID VARCHAR(6) NOT NULL, Manager CHAR(1) NOT NULL, Password VARCHAR(12) NOT NULL, Deleted VARCHAR(1), PRIMARY KEY (UsrID), FOREIGN KEY (DeptID) REFERENCES DEPT (DeptID) ON UPDATE CASCADE)
CREATE TABLE SKILL (UsrID VARCHAR(20) NOT NULL, Skill VARCHAR(100), ReqLevel INT NOT NULL, ReqType VARCHAR(10) NOT NULL, PRIMARY KEY (UsrID, ReqLevel), FOREIGN KEY (UsrID) REFERENCES USR (UsrID) ON DELETE CASCADE, FOREIGN KEY (ReqType) REFERENCES REQTYPE (ReqType) ON DELETE CASCADE,)
11
SQL Create Table
CREATE TABLE REQFORM (ReqID VARCHAR(10) NOT NULL, Request VARCHAR(100) NOT NULL, AppDate DATETIME NOT NULL, ExpectDate DATETIME, FinishDate DATETIME, ReqType VARCHAR(10) NOT NULL, Applicant VARCHAR(20) NOT NULL, Status VARCHAR(4), Priority INT NOT NULL, RegionID VARCHAR(20) NOT NULL, PRIMARY KEY (ReqID), FOREIGN KEY (ReqType) REFERENCES REQTYPE (ReqType) ON DELETE CASCADE, FOREIGN KEY (Applicant) REFERENCES USR (UsrID) ON DELETE CASCADE, FOREIGN KEY (RegionID) REFERENCES LOCATION (RegionID) ON DELETE CASCADE)
CREATE TABLE REQLOG (ReqID VARCHAR(12) NOT NULL, Seq INT NOT NULL, ReqLog VARCHAR(100) NOT NULL, Performer VARCHAR(20) NOT NULL, PRIMARY KEY (ReqID, Seq), FOREIGN KEY (ReqID) REFERENCES REQFORM (ReqID) ON DELETE CASCADE, FOREIGN KEY (Performer) REFERENCES USR (UsrID))
12
???????
Help Desk
??????
?????
??????
?????
???
?????
??????
???????
????
13
??????

• ??????http//erpweb.fast.com.tw/helpdesk/login.as
  px
• ????
• admin
• ??
• a
• ??????
• ASP.Net
• ?????(.cs)??WordPad????
• ?????
• SQL Server

14
????
????
Source Code login.aspx
15
????
?????????
Source Code RequestForms.aspx
16
????
?????????
Source Code RequestForms.aspx
17
????
??????
Source Code RequestForms.aspx
18
????
?????
Source Code RequestLog.aspx
19
????
??????
Source Code Department.aspx
20
????
?????
Source Code Location.aspx
21
????
??????
Source Code RequireType.aspx
22
????
???????
Source Code UserInfo.aspx
23
????
????? ?????
Source Code Query.aspx
24
????
????? ?????
Source Code ByDept.aspx
25
????
????? ????????
Source Code OverTime.aspx
26
????
????? ???????????
Source Code Process.aspx
27
??

• ???????????
• ???????,???????Index????,??Query?????,?????DBA?Tun
  ing???????, Index?????????????,??????,???Disk
  I/O????
• ??????????????TM?????????????,???????,?????????
• ?????????!???????????????????,???????,????????????
  
• ???????????????????,??????????!