bÀi in ra ne

8/3/2019 BI IN RA NE

1/39

BO CO N PHN TCH THIT K H THNG -QUN L IMTHPT

TNG QUAN V TI

1. Bi cnh v l do thc hin ti

Cng vi s pht trin nhanh chng v phn cng my tnh, cc phn mm

ngy cng tr nn a dng, phong ph, hon thin hn v h tr hiu qu cho con

ngi. Cc phn mm hin nay ngy cng m phng c rt nhiu nghip v kh

khn, h tr cho ngi dng thun tin s dng, thi gian x l nhanh chng, v

mt s nghip v c t ng ho cao.

Do vy m trong vic pht trin phn mm, s i hi khng ch l s

chnh xc, x l c nhiu nghip v thc t m cn phi p ng cc yu cukhc nh v tc , giao din thn thin, m hnh ho c thc t vo my tnh

ngi s dng tin li, quen thuc, tnh tng thch cao, bo mt cao (i vi

cc d liu nhy cm), Cc phn mm gip tit kim mt lng ln thi gian,

cng sc ca con ngi, v tng chnh xc v hiu qu trong cng vic (nht l

vic sa li v t ng ng b ho).

Nhm mc ch tng hp cc kin thc hc, mn hc thc tp cng

nhn to iu kin cho sinh vin c c hi pht huy kh nng lp trnh., kh nng

pht trin cc ng dng phn mm vo thc t. Trong mn hc ny, nhm chn

ti qun l hc sinh cp 3.

Thc t, vic qun l hc v trong trng trung hc ph thng. Nu khng

c s h tr ca tin hc, vic qun l ny phi cn kh nhiu ngi, chia thnh

nhiu khu, mi c th qun l c ton b h s, hc sinh (thng tin, im s,

k lut, hc b, ), lp hc (s s, GVCN, thi kho biu, ), gio vin (thng tin,

lch dy, ) cng nh cc nghip v sp thi kho biu, tnh im trung bnh, xp

loi hc lc cho hc sinh ton trng (s lng hc sinh c th ln n hai ba

ngn hc sinh). Cc cng vic ny i hi nhiu thi gian v cng sc, m s

chnh xc v hiu qu khng cao, v a s u lm bng th cng rt t t ng.

Mt s nghip v nh tra cu, thng k, v hiu chnh thng tin kh vt v. Ngoi

SV:NGUYN TH HOI NHN-NGUYN VN LINH-TRN VN THNG -1-


2/39


ra cn c mt s kh khn v vn lu tr kh s, d b tht lc, tn km,

Trong khi , cc nghip v ny hon ton c th tin hc ho mt cch d dng.

Vi s gip ca tin hc, vic qun l hc v s tr nn n gin, thun tin,

nhanh chng v hiu qu hn rt nhiu.Cui cng, chng em xin chn thnh cm n thy nhit tnh hng dn

nhm thc hin ti ny.

2. Phng php trin khai ti

T nhng yu cu, cng chi tit i vi ti ca gio vin hng dn,

nhm ra cc cng vic c th :

- Giai on 1: Thu thp yu cu, xc nh cc chc nng ca h thng.- Giai on 2: Thit k c s d liu.

- Giai on 3: M ha.

- Giai on 4: Kim th.

- Giai on 5: Ci t .

3. Mi trng pht trin v trin khai

Yu cu mi trng pht trin

- H iu hnh windows XP tr ln

- .net framework 2.0 +

- H qun tr c s d liu c s d liu SQL Server 2005

- Ngn ng lp trnh: C#

- IDE h tr: Visual studio 2005

Mi trng trin khai- H thng mng LAN



3/39


Chng 1. PHN TCH YU CU NGHIP VBI TON

1.1 Gii thiu

ph hp vi thc t, phn mm to ra phi than thin, d s dng i

vi ngi dng, bc kho st hin trng, tm hiu v phn tch cc yu cu v

mt nghip v l rt cn thit i vi mt phn mm.

Bi ton qun l hc sinh cp 3 c thit k nhm ng dng cho vic qun

l h thng mt trng trung hc ph thng. Bi ton c ci t trn h thng

mng Lan. Mi ngi dng khi s dng h thng cn phi thit lp cu hnh kt

ni n my ch ca trng. Sau , ng nhp vo h thng vi username v

password ca mnh. Ti mi vai tr ca ngi dng, h thng s t ng gii hn

cc chc nng tng ng vi vai tr .

1.2. Cc yu cu nghip v

Bi ton qun l hc sinh cp 3 gm cc yu cu sau:- Chc nng cu hnh h thng: trc khi ng nhp vo h thng, ngi

dng cn phi cu hinh tn my ch, mt khu v ti khon my ch, chn c s

d liu cn thao tc.

- Qun l hc sinh: Vic qun l hc sinh bao gm cc thao tc nh thm

hc sinh mi, sa i thng tin hc sinh, xp lp

- Qun l cn b gio vin trong trng: Vic qun l ny cng bao gm:

Thm mi gio vin, sa i thng tin, phn cng nhim v ging dy, nhim v

ch nhim lp

- Qun l im hc sinh: nhp im, thng k kt qu hc tp ca tng hc

sinh, tng lp hc.



4/39


- Ngoi ra i vi vai tr admin, ngi dng cn c cc tc v nh thay i

mt khu, thit lp li mt khu, thit lp quyn cho ngi dng. i vi vai tr

ngi dng User cn c cc chc nng : thay i mt khu ca chnh ngi dng

hin ti.



5/39


Chng 2. THIT K C S D LIU

2.1. S ERD

2.2. Danh sch cc bng

STT Tn ngha

1. HocSinh Lu tr thng tin hc sinh

2. GiaoVien Lu tr thng tin gio vin

3. HocKy Lu tr thng tin v cc hc k trong mt nm hc

4. NamHoc Lu tr thng tin v cc nm hc



6/39


5. LopHoc Lu tr thng tin v tt c lp hc

6. KhoiHoc Lu tr thng tin v cc khi hc, vd: 10,11,12

7. BanHoc Lu tr thng tin v cc ban hc, vd: ban A, B, c s

8. MonHoc Lu tr thng tin phn cc mn hc

9. XepLop Lu tr thng tin phn cng hc sinh vo mt lp c th

10.

PhanCong Lu tr thng tin v phn cng dy hc cho gio vin

11.

Diem Lu tr im s ca hc sinh

2.3. Miu t chi tit cc bng

2.3.1. Bng hc sinh

HocSinh

Tn trng Kiu d liu Miu t Ghi ch

Mahs int M hc sinh Kha chnh

Ho nvarchar H v tn m

Ten nvarchar Tn hc sinh

GioiTinh nvarchar Gii tnh hc sinh

NgaySinh datetime Ngy sinh hc sinhDiaChi nvarchar a ch hc sinh

DienThoai Varchar in thoi lin h

CMDN Varchar S CMND

2.3.2. Bng gio vin



7/39


GiaoVien


MaGV int M gio vin Kha chnh

Ho nvarchar H v tn m

Ten nvarchar Tn gio vin

GioiTinh nvarchar Gii tnh gio vin

NgaySinh datetime Ngy sinh gio vin

DiaChi nvarchar a ch gio vin

DienThoai Varchar in thoi lin h

CMDN Varchar S CMND

MatKhau Varchar Mt khu ng nhp h thng

Role Varchar Vai tr ng nhp User, admin

2.3.3. Bng nm hc

Namhoc

Tn trng Kiu dliu

Miu t Ghi ch

MaNH int M nm hc Kha chnh, tng t ng

TenNH Nvarchar Tn nm hc

NamBatDau Int Nm bt u

NamKetThuc Int Nm kt thc

2.3.4. Bng hc k

HocKy


MaHK Int M hc k Kha chnh, tng t ng

TenHK Nvarchar Tn hc k

ThangBatDau Int Thng bt u hck



8/39


NgayBatDau Int Ngy bt u hck

ThangKetThuc Int Thng kt thc hck

NgayKetThuc Int Ngy kt thc hck

2.3.5. Bng lp hc

LopHoc

Tntrng

Kiu d liu Miu t Ghi ch

MaLH Int M lp hc Kha chnh, tng t ngTenLH Nvarchar Tn lp hc

MaKH Int M khi hc Kha ngoi

MaBH Int M ban hc Kha ngoi

MaNH Int M nm hc Kha ngoi

MaGV Varchar M gio vin chnhim

Kha ngoi

2.3.6. Bng ban hc

BanHoc

Tntrng


MaBH Int M ban hc Kha chnh, tng tng

TenBH Nvarchar Tn ban hc

2.3.7. Bng mn hc

MonHoc

Tntrng




9/39


MaMH Int M mn hc Kha chnh, tng tng

TenMH Nvarchar Tn mn hc

2.3.8. Bng khi hc

KhoiHoc


MaKH Int M kha hc Kha chnh

TenKH Nvarchar Tn kha hc Kha chnh

2.3.9. Bng phn cng

PhanCong

Tntrng


MaPC int M phn cng Kha chnh, tng t ng

MaGV Int M gio vin Kha ngoi

MaLH Int M lp hc Kha ngoi

MaHK Int M hc k Kha ngoiMaMH Int M mn hc Kha ngoi

2.3.10. Bng xp lp

XepLop

Tntrng


MaHS Varchar M hc sinh Kha chnh, kha ngoi

MaLH Int M lp hc Kha chnh, kha ngoi

2.3.11. Bng im

Diem



10/39


Tntrng


MaHS Varchar M hc sinh Kha chnh, kha ngoi

MaPC int M phn cng Kha chnh, kha ngoi

DiemHS1 Varchar im h s 1 Cc im c ngn cchbi du phy

DiemHS2 Varchar im h s 2 Cc im c ngn cchbi du phy

DiemThi Decimal(3,1) im thi S thp phn, 1 ch s phn thp phn

TBM Decimal(3,2) im trung bnh mn S thp phn, 2 ch s phn thp phn

SV:NGUYN TH HOI NHN-NGUYN VN LINH-TRN VN THNG-10-


11/39


Chng 3. XY DNG CHC NNG CACHNG TRNH

3.1. Chc nng cu hnh my ch

Bi ton c ci t trong mi trng mng LAN nn s c mt my ch

lu tr c s d liu. Mi my khch khi ng nhp vo h thng cn phi cuhnh cc thng s ng nhp vo.

bi ton ny, vi chc nng cu hnh my ch, cc thng s cn thit

phi c cung cp l tn my ch, ti khon v mt khu ng nhp vo h qun

tr c s d liu ca my ch, tn c s d liu m ti my khch cn thao tc n.

to kt ni n my ch ta s dng on m:

SqlConnection cn = new SqlConnection("Data Source=" + Server

+ ";Initial Catalog=" + database +";Integrated Security=True");

if (cn != null)

{

cn.Open();

}

Hoc on m sau nu ng nhp vi ti khon v mt khu :

cn = new SqlConnection("Data Source=" + Server +

";database=" + database + ";uid="

+ user + ";pwd=" + pass);

if (cn != null)



12/39


{

cn.Open();

}

3.2. Chc nng ng nhp

Nhm m bo tnh bo mt trong h thng, vi mi ngi dng c cp mt

ti khon cng vi quyn ca mnh. Khi vo h thng, ngi dng cn phi thc hin

tc v ng nhp vi username v password. H thng s a ra cc chc nng tng

ng vi quyn ca ngi ng nhp.

Khi ngi dng cung cp user name v password, chng trnh s gi chng

n h thng v kim tra xem ti khon c hp l hay khng: vic kim tra ny s gi

th tc hm c ci t trong h thng:

create proc [dbo].[usp_checkLogin]

@user varchar(10),

@pass varchar(50),

@flag bit output,@role varchar(10) output,

@name nvarchar(100)output

as

begin

select @role= [Role],@name = TenGV from giaovien where

[MaGV]=@user and MatKhau=@pass

if (count(@role)=1)set @flag = 1

else set @flag = 0

end



13/39


3.3. Chc nng qun l hc sinh

Thm danh sch hc sinh: chn nm hc, chn hc k, chn ban hc

v lp hc, in y thng tin ca hc sinh v chn nt thm mi hc sinh.

Hoc c th chn t file excel:

Th tc chn d liu vo bng hc sinh:

CREATEproc usp_InsertHS

@Ho [nvarchar](50),

@Ten [nvarchar](100),

@Gioitinh [nvarchar](10),

@Ngaysinh [datetime] ,

@Diachi [nvarchar](Max),

@Dienthoai [varchar](50),

@CMND [varchar](50),

@MaHS [varchar](50)output

as

begin

INSERTINTO HocSinh VALUES('',@Ho,@Ten, @Gioitinh

,@Ngaysinh,@Diachi,@Dienthoai,@CMND)

select @MaHS=max([MaHS])from HocSinh

end

Trong chng trnh s gi th tc ny v truyn vo cc thng s

trn.

Sa i thng tin hc sinh: chn lp hc. dng datagridview load

tt c cc hc sinh thuc lp . sa i thng tin hc sinh, cn chn mthng , cc thng tin c th s c set ln cc textbox nhm cho chng ta sa i.

Th tc cp nht li d liu ca hc sinh

createproc usp_UpdateHocSinh

@MaHS [varchar](50),



14/39


@Ho [nvarchar](50),

@Ten [nvarchar](100),


@Ngaysinh [datetime] ,@Diachi [nvarchar](Max),


@CMND [varchar](50)

as

update HocSinh

setHo=@Ho,Ten=@Ten,Gioitinh=@Gioitinh,Ngaysinh=@Ngaysinh,Diachi=@Diac

hi,Dienthoai=@Dienthoai,CMND=@CMND

where MaHS=@MaHS

Tm kim hc sinh: Ngi dng cn nhp vo m hc sinh. Thng tin

hc sinh ny s c load v datagridview. i vi hc sinh va tm c, chng

ta c th sa i thng tin.

Xp lp: chn cc hc sinh cn xp lp mi, chn lp.

3.4. Chc nng qun l im hc sinh

i tng s dng:

Gio vin b mn ng nhp vo h thng. Gio vin ch c quyn cp

nht im ca b mn mnh ph trch

Chc nng ghi im

M bng im ph hp vi m phn cng ca gio vin b mn:

ALTERPROC [dbo].[usp_GETBANGDIEMBYMAPC]

@MAPC INT



15/39


AS

SELECT HS.MAHS,(HO+TEN)AS HOTEN,

DIEMHS1,DIEMHS2,DIEMTHI,TBM

FROM HOCSINH AS HS,DIEM, PHANCONG AS PCWHERE DIEM.MAPC = PC.MAPC

AND PC.MAPC = @MAPC

AND DIEM.MAHS = HS.MAHS

Cp nht im

ALTERPROC [dbo].[usp_UPDATEDIEM]

@MAHS VARCHAR(50),

@MAPC INT,

@DIEMHS1 VARCHAR(50),

@DIEMHS2 VARCHAR(50),

@DIEMTHI DECIMAL(3,1)

AS

UPDATE DIEM SET DIEMHS1=@DIEMHS1,DIEMHS2 =

@DIEMHS2,DIEMTHI=@DIEMTHI

WHERE MAHS = @MAHS AND MAPC = @MAPC

Chc nng tnh im trung bnh

ALTERPROC [dbo].[usp_UPDATETBM]

@MAHS VARCHAR(50),

@MAPC INT,

@DIEMHS1 VARCHAR(50),@DIEMHS2 VARCHAR(50),

@DIEMTHI DECIMAL(3,1),

@TBM DECIMAL(3,2)

AS



16/39


UPDATE DIEM SET DIEMHS1=@DIEMHS1,DIEMHS2 =

@DIEMHS2,DIEMTHI=@DIEMTHI,TBM = @TBM

WHERE MAHS = @MAHS AND MAPC = @MAPC

Chc nng tng kt im tng mn ca mt lp

ALTERPROC [dbo].[USP_GETBANGDIEMTONGKETMON]

@MALH INT,

@MAMH INT

AS

DECLARE @MAPC1 INT

DECLARE @MAPC2 INT

EXEC USP_GET2MAPC @MAMH,@MALH,@MAPC1OUTPUT,@MAPC2 OUTPUT

--TAO BANG TAM 1 (DIEM HKI)

SELECT MAHS,HOTEN,TBM AS HKI

INTO #BANGTAM1

FROM VIEW_BANGDIEM

WHERE MAPC = @MAPC1

--TAO BANG TAM 2

SELECT MAHS,HOTEN,TBM AS HKII

INTO #BANGTAM2

FROM VIEW_BANGDIEM

WHERE MAPC = @MAPC2

--KET NOI 2 BANG TAM

SELECT #BANGTAM1.MAHS,

#BANGTAM1.HOTEN,HKI,HKII,DBO.DIEMTKMON(HKI,HKII)AS CANAM

FROM #BANGTAM1,#BANGTAM2

WHERE #BANGTAM1.MAHS = #BANGTAM2.MAHS

Chc nng tng kt im tt c cc mn



17/39


ALTERPROC [dbo].[USP_TKCUOINAM]

@MALH INT,

@LUACHON INT--1:KY 1, 2:KY 2 , 3: CA NAM

ASSELECT HS.MAHS AS MAHS,(HO+TEN)AS

HOTEN,PC.MAPC,MH.TENMH AS MON,TBM AS HKI,MAHK

INTO #BANGTAM3

FROM PHANCONG AS PC,DIEM,HOCSINH AS HS,MONHOC

AS MH

WHERE MAHK= 1

AND MALH = @MALHAND PC.MAPC = DIEM.MAPC

AND HS.MAHS = DIEM.MAHS

AND MH.MAMH = PC.MAMH

SELECT HS.MAHS AS MAHS,(HO+TEN)AS

HOTEN,PC.MAPC,MH.TENMH AS MON,TBM AS HKII,MAHK

INTO #BANGTAM4FROM PHANCONG AS PC,DIEM,HOCSINH AS HS,MONHOC

AS MH

WHERE MAHK= 2

AND MALH = @MALH

AND PC.MAPC = DIEM.MAPC

AND HS.MAHS = DIEM.MAHS

AND MH.MAMH = PC.MAMH

SELECT

BT3.MAHS,BT3.HOTEN,BT3.MON,BT3.HKI,BT4.HKII,

(BT3.HKI+BT4.HKII*2)/3 AS CANAM



18/39


INTO #BANGTAM5

FROM #BANGTAM3 AS BT3,#BANGTAM4 AS BT4

WHERE BT3.MAHS = BT4.MAHS

AND BT3.MON = BT4.MON

IF @LUACHON = 1

SELECT MAHS,HOTEN,[Ton],[Vt L],[Ha Hc],[Sinh

Hc],[Tin Hc],[Ng Vn],[Lch S],[a L],[Ngoi Ng],[Gio dc cng dn],

[Cng ngh],[Th dc],

([Ton]*2+[Vt L]+[Ha Hc]+[Sinh Hc]+[Tin Hc]+[Ng Vn]*2+[Lch S]+[a L]+[Ngoi Ng]+[Gio dc cng dn]+[Cng

ngh]+[Th dc])/14 AS [IM TB K I]

FROM(SELECT MAHS,HOTEN,MON,HKI FROM

#BANGTAM3) o

PIVOT(SUM(HKI)FORMON IN([Ton],[Vt L],[Ha

Hc],[Sinh Hc],[Tin Hc],[Ng Vn],[Lch S],[a L],[Ngoi Ng],[Gio dc

cng dn],[Cng ngh],[Th dc]))AS pv

ELSEIF @LUACHON = 2



[Cng ngh],[Th dc],

([Ton]*2+[Vt L]+[Ha Hc]+[Sinh Hc]+[Tin Hc]+

[Ng Vn]*2+[Lch S]+[a L]+[Ngoi Ng]+[Gio dc cng dn]+[Cng

ngh]+[Th dc])/14 AS [IM TB K II]

FROM(SELECT MAHS,HOTEN,MON,HKII FROM

#BANGTAM4) o



19/39


PIVOT(SUM(HKII)FORMON IN([Ton],[Vt L],[Ha

Hc],[Sinh Hc],[Tin Hc],[Ng Vn],[Lch S],[a L],[Ngoi Ng],[Gio dc

cng dn],[Cng ngh],[Th dc]))AS pv

ELSEIF @LUACHON = 3



[Cng ngh],[Th dc],

([Ton]*2+[Vt L]+[Ha Hc]+[Sinh Hc]+[Tin Hc]+

[Ng Vn]*2+[Lch S]+[a L]+[Ngoi Ng]+[Gio dc cng dn]+[Cngngh]+[Th dc])/14 AS [IM TK NM HC]

FROM(SELECT MAHS,HOTEN,MON,CANAM FROM

#BANGTAM5) o

PIVOT(SUM(CANAM)FORMON IN([Ton],[Vt L],

[Ha Hc],[Sinh Hc],[Tin Hc],[Ng Vn],[Lch S],[a L],[Ngoi Ng],

[Gio dc cng dn],[Cng ngh],[Th dc]))AS pv

3.5. Chc nng qun l cn b gio vin trong trng

To mi gio vin

Nhp cc thng tin cn thit vo cc textbox. Cc thng tin ny s c

chn vo bng gio vin, m gio vin s c tr v.

alterproc usp_InsertGV

@Tengv [nvarchar](100),@Gioitinh [nvarchar](10),






20/39


@CMND [varchar](50),

@Magv [varchar](10)output

as

beginINSERTINTO Giaovien VALUES('',@Tengv, @Gioitinh

,@Ngaysinh,@Diachi,@Dienthoai,@CMND,'123456','User')

select @Magv=max([MaGV])from giaovien

end

Sa i thng tin gio vin

Thng tin gio vin s c hin th trn form, sa i thng tin ca

gio vin, ta cn phi chn mt hng. V sa i, cp nht li d liu. D liu nynu hp l s c thay i trong bng gio vin theo m gio vin chn.

createproc usp_UpdateGiaovien

@MaGV [varchar](50),

@TenGV [nvarchar](100),





@CMND [varchar](50)

as

update giaovien

set

TenGV=@TenGV,Gioitinh=@Gioitinh,Ngaysinh=@Ngaysinh,Diachi=@Diachi,

Dienthoai=@Dienthoai,CMND=@CMND

where MaGV=@MaGV

Phn cng lch ging dy cho tng gio vin



21/39


Mi gio vin s c nhiu lch phn cng, nhiu lp, chn mn hc, lp

hc, hc k, nm hc v chn nt phn cng. Trong bng phn cng s chn d

liu vo.

ly d liu ca gio vin ta dng storeprocudurecreateproc getDataGV

as

select MaGV,TenGV as [Tn gio vin],Gioitinh as[Gii tnh],Ngaysinh

as[Ngy sinh],diachi as [a ch],dienthoai as [in thoi],CMND

from giaovien

Phn cng dng storeproc:

createproc usp_insertphancong@Magv varchar(10),

@MaMH int,

@MaLH int,

@MaHKint,

@MaPC intoutput

as

begininsertinto phancong(MaGV,MaMH,MaLH,MaHK)

values(@Magv,@MaMH,@MaLH,@MaHK)

select @MaPC=max(MaPC)from phancong

end

Phn cng lp ch nhim

Chn lp, chn gio vin. Lch phn cng ch nhim s c cp nht trn

mi lp c chn

createproc usp_UpdateChunhiem

@MaLH int,

@MaGV varchar(10)



22/39


as

update lophoc

set MaGV=@MaGV

where MaLH=@MaLH Sa i lch phn cng dy theo lp

Chn m gio vin. Mi gio vin s c lch phn cng c load ln trn

form, sa i ch cn cp nht li n.

createproc updatePhancong

@MaPC int,

@MaMH int,

@MaGV varchar(10),@MaHKint

as

update phancong

set MaMH=@MaMH,MaGV=@MaGV,MaHK=@MaHK

where MaPC=@MaPC

3.6. Chc nng reset mt khu v phn quyn cho tng user i

vi ngi dng c vai tr l admin

Chc nng ny ch c p dng cho ngi dng c vai tr l admin, ngi

dng vi vai tr l user nu b mt mt khu c th ly li nh vo admin. Vic

reset li mt khu chng qua l cp nht li bng gio vin vi mt khu mc nh

l 123456.if(radioButton1.Checked == true)

{

radioButton2.Checked = false;

groupBox1.Enabled = false;



23/39


if(dal.CheckData("update giaovien set Matkhau= '123456' where

MaGV='" + comboBox1.SelectedValue.ToString().Trim() + "'",

CommandType.Text, null))

{ MessageBox.Show("Bn reset mt khu thnh cng. Mt

khu mc nh l 123456");

}

else

{

MessageBox.Show("Bn reset mt khu khng thnh

cng.");}

}

else

{

if(radioButton2.Checked == true){

groupBox1.Enabled = true;

if(radioButton3.Checked == true)

{

radioButton4.Checked = false;

if(dal.CheckData("update giaovien set [Role]= 'Admin'

where MaGV='" + comboBox1.SelectedValue.ToString().Trim() + "'",

CommandType.Text, null))

{

MessageBox.Show("Set quyn Admin thnh cng");

}



24/39


else

{

MessageBox.Show("Khng thnh cng.");

}}

else {

if(radioButton4.Checked == true)

{

if(dal.CheckData("update giaovien set [Role]= 'User'

where MaGV='" + comboBox1.SelectedValue.ToString().Trim() + "'",

CommandType.Text, null)){

MessageBox.Show("Set quyn User thnh cng");

}

else

{

MessageBox.Show("Khng thnh cng.");

}}

}

}

}

3.7. Chc nng thay i mt khu tng ngi dng

Vi mi ngi dng u c th i mt khu nhm m bo an ton ca

h thng. chc nng ny cng l update li mt khu trn bng gio vin. Khi

ngi dng ng nhp li h thng th phi nhp mt khu mi.

alterproc usp_checkMatkhau



25/39


@uservarchar(10),

@pass varchar(50),

@flagbitoutput,

@passmoi varchar(50)as

begin

declare @Mgv varchar(10)

select @Mgv=MaGV from giaovien where [MaGV]=@userand

MatKhau=@pass

if(count(@Mgv)=1)

begin update giaovien set Matkhau=@passmoi where MaGV=@user

set @flag = 1

end

elseset @flag = 0

end

3.8. Chc nng thot khi h thng

thot khi ng dng ta dng lnh: Environment.exit(0); hoc

Application.exit(0); hoc form.close(); lc ny h thng s b thot nu chn chc

nng ny.



26/39


Chng 4. TRIN KHAI V KT QU

4.1. Mi trng trin khai

H thng mng LAN

Cc yu cu h thng

- H qun tr c s d liu SQL Server 2005

- H iu hnh Windows XP +

- .net framework 2.0 +

4.2. Kt qu v chc nng ca cc chng trnh

u tin l cu hnh server

in cc tham s cn thit



27/39


Nu thnh cng

Form ng nhp

Nhp username v password



28/39


Vo h thng

Chn chc nng qun l thng tin hc sinh:To mi hc sinh



29/39


Sa i thng tin hc sinh



30/39


Tm kim mt hc sinh

Xp lp



31/39


Chc nng qun l imNhp im chi tit v tnh trung bnh



32/39


Tng kt mn (Gio vin b mn)



33/39


Tng kt lp (Gio vin ch nhim)



34/39


Chc nng qun l cn b gio vinForm to mi gio vin



35/39


Sa i thng tin gio vin

Phn cng gio vin



36/39


Phn cng ch nhim lp

Sa i lch phn cng



37/39


Chc nng reset mt khu v phn quyn

Chc nng thay i mt khu



38/39


4.3. Nhn xt v nh gi

H thng c bn hon thnh cc chc nng qun l hc sinh trong mt

trng cp 3 bao gm:- Qun l ngi dng

- Qun l h s hc sinh

- Qun l h s gio vin

- Phn cng ging dy

- Xp lp cho hc sinh

- Qun l im

H thng c th c tng cng thm cc chc nng: Hon thin thm chc nng qun l h s bao gm:

- Theo di chuyn lp, chuyn trng

- Theo di k lut

- Theo di chuyn cn, hnh kim

Hon thin chc nng phn cng:

- Xp thi kha biu cho hc sinh, gio vin



39/39


MC LC

bÀi in ra ne

Documents