µÚÒ»·¶ÎÄÍø - רҵÎÄÕ·¶ÀýÎĵµ×ÊÁÏ·ÖÏíÆ½Ì¨

ÔÚÏß²âÊÔϵͳ£¨±ÏÒµÂÛÎÄ£©

À´Ô´£ºÓû§·ÖÏí ʱ¼ä£º2025/5/31 12:07:46 ±¾ÎÄÓÉloading ·ÖÏí ÏÂÔØÕâÆªÎĵµÊÖ»ú°æ
˵Ã÷£ºÎÄÕÂÄÚÈݽö¹©Ô¤ÀÀ£¬²¿·ÖÄÚÈÝ¿ÉÄܲ»È«£¬ÐèÒªÍêÕûÎĵµ»òÕßÐèÒª¸´ÖÆÄÚÈÝ£¬ÇëÏÂÔØwordºóʹÓá£ÏÂÔØwordÓÐÎÊÌâÇëÌí¼Ó΢ÐźÅ:xxxxxxx»òQQ£ºxxxxxx ´¦Àí£¨¾¡¿ÉÄܸøÄúÌṩÍêÕûÎĵµ£©£¬¸ÐлÄúµÄÖ§³ÖÓëÁ½⡣

ËÕÖݿƼ¼Ñ§ÔºÌìÆ½Ñ§Ôº±¾¿ÆÉú±ÏÒµÉè¼Æ£¨ÂÛÎÄ£©

Ðø±í4.5

±íÃû ˵Ã÷ ×Ö¶ÎÃû deptID paperType creator createdTime fillBlankSum fillBlankCateID singleSelectionCateID T_PaperByRandomSelection ´æ´¢Ëæ»ú³éÌâÊÔ¾í Êý¾ÝÀàÐÍ Int Nvarchar(50) Nvarchar(50) Datetime Int Int Int ÊÇ·ñÊÇ·ñΪΪ¿Õ Ö÷¼ü Y Y Y Y Y Y Y Y N N N N N N N N ÊÇ·ñ˵Ã÷ Íâ¼ü N N N N N N N N רҵºÅ ÊÔ¾íרҵÀàÐÍ ´´½¨Õß ´´½¨Ê±¼ä Ìî¿ÕÌâÌâÊý Ñ¡ÔñÌâÌâÊý Ìî¿ÕÌâµÄ¿ÆÄ¿ºÅ Ñ¡ÔñÌâµÄ¿ÆÄ¿ºÅ singleSelectionSum Int ±í4.6 ÌâÄ¿±í

±íÃû ˵Ã÷ ×Ö¶ÎÃû cateID cateName T_SubjectTypeCategory ´æ´¢¸÷¿ÆÌâÄ¿¼Ç¼ Êý¾ÝÀàÐÍ Int ÊÇ·ñΪ¿Õ ÊÇ·ñΪÖ÷¼ü N Y N N N ÊÇ·ñΪÍâ¼ü N N N ˵Ã÷ ¿ÆÄ¿ID ¿ÆÄ¿Ãû³Æ ÌâÄ¿ÖÖÀà Nvarchar(50) Y subjectType Int ±í4.7 ²âÊÔ°²Åűí

±íÃû ˵Ã÷ ×Ö¶ÎÃû testID testName paperID paperType totalScores passScores neededMinutes creatorUserID creatorName enableDate unenableDate T_Test ´æ´¢²âÊÔ°²ÅÅÐÅÏ¢ Êý¾ÝÀàÐÍ Int Int Int Int Int Int ÊÇ·ñΪ¿Õ N Y Y Y Y Y ÊÇ·ñΪÖ÷¼ü Y N N N N N N N N N N

ÊÇ·ñΪÍâ¼ü Y N N N N N N N N N N ˵Ã÷ ²âÊÔID ²âÊÔÃû³Æ ÊÔ¾íID ÊÔ¾íÀàÐÍ ÊÔ¾í×Ü·Ö ¼°¸ñ·Ö ²âÊÔʱ¼ä ´´½¨ÕßID ´´½¨ÕßÃû×Ö ¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä Nvarchar£¨50£© N Nvarchar£¨50£© Y Nvarchar£¨50£© Y Datetime Datetime Y Y

13

ËÕÖݿƼ¼Ñ§ÔºÌìÆ½Ñ§Ôº±¾¿ÆÉú±ÏÒµÉè¼Æ£¨ÂÛÎÄ£©

±í4.8 ²âÊԳɼ¨±í

±íÃû ˵Ã÷ ×Ö¶ÎÃû markID recorderID totalScore marker T_TestMark ´æ´¢²âÊԳɼ¨ Êý¾ÝÀàÐÍ Int Int Int Nvarchar(50) ÊÇ·ñΪ¿Õ ÊÇ·ñΪÖ÷¼ü N N Y Y Y N N N ÊÇ·ñΪÍâ¼ü N Y N N ˵Ã÷ ÆÀ·ÖID ½»¾íID µÃ·Ö ÆÀ¾íÈË ±í4.9 ²âÊԼǼ±í

±íÃû ˵Ã÷ ×Ö¶ÎÃû recorderID testID userID submitType T_TestRecorder ´æ´¢²âÊԼǼ Êý¾ÝÀàÐÍ Int Int Nvarchar(50) ÊÇ·ñΪ¿Õ ÊÇ·ñΪÖ÷¼ü N Y Y Y N N N ÊÇ·ñΪÍâ¼ü N Y N N ˵Ã÷ ½»¾íID ²âÊÔID ²âÊÔÕßID ½»¾í·½Ê½ Nvarchar£¨50£© Y ±í4.10 Óû§±í

±íÃû ˵Ã÷ ×Ö¶ÎÃû userID name userPwd deptID right locked sex createdTime T_User ´æ´¢Óû§ÐÅÏ¢ Êý¾ÝÀàÐÍ Varchar(30) Nvarchar(10) Varchar(30) Smallint Nvarchar(20) Bit Int ÊÇ·ñΪ¿Õ ÊÇ·ñΪÖ÷¼ü N Y N Y Y Y Y Y N N N N N N N N ÊÇ·ñΪÍâ¼ü N Y N N N N N N N ˵Ã÷ Óû§ID Óû§Ãû×Ö Óû§ÃÜÂë רҵID Óû§È¨ÏÞ Ëø¶¨ ÐԱ𠴴½¨Ê±¼ä ÉϴεǼµÄʱ¼ä Smalldatetime Y lastLoginTime Smalldatetime Y ±í4.11 רҵ±í

±íÃû ˵Ã÷ ×Ö¶ÎÃû deptID deptName T_Department ´æ´¢×¨ÒµÐÅÏ¢ Êý¾ÝÀàÐÍ Smallint Nvarchar(50) ÊÇ·ñΪ¿Õ ÊÇ·ñΪÖ÷¼ü N Y Y N ÊÇ·ñΪÍâ¼ü N Y ˵Ã÷ רҵID רҵÃû³Æ

14

ËÕÖݿƼ¼Ñ§ÔºÌìÆ½Ñ§Ôº±¾¿ÆÉú±ÏÒµÉè¼Æ£¨ÂÛÎÄ£©

±í4.12 ²âÊԴ𰸱í

±íÃû ˵Ã÷ ×Ö¶ÎÃû recorderID subjectType subjectID answer1 answer3 scores T_TestRecorder_Answer ´æ´¢²âÊÔÕߵIJâÊÔ´ð°¸ Êý¾ÝÀàÐÍ Bigint Int Int Nvarchar(50) Char(1) Int ÊÇ·ñΪ¿Õ ÊÇ·ñΪÖ÷¼ü N Y Y Y Y Y Y N N N N N ÊÇ·ñΪÍâ¼ü N N N N N N ˵Ã÷ ½»¾íID ÌâÄ¿ÀàÐÍ ÌâÄ¿ID Ìî¿ÕÌâ´ð°¸ Ñ¡ÔñÌâ´ð°¸ ·ÖÊý ±í4.13 ·ÖÊý±í

±íÃû ˵Ã÷ ×Ö¶ÎÃû testID subjectType scores T_Test_Subject_Scores ´æ´¢²âÊÔ¸÷ÌâÐÍ·ÖÊý Êý¾ÝÀàÐÍ Int Int Int ÊÇ·ñÊÇ·ñΪÖ÷¼ü ÊÇ·ñΪÍâΪ¿Õ ¼ü N Y Y Y N N N N N ˵Ã÷ ²âÊÔID ÌâÄ¿ÀàÐÍ ·ÖÊý

15

ËÕÖݿƼ¼Ñ§ÔºÌìÆ½Ñ§Ôº±¾¿ÆÉú±ÏÒµÉè¼Æ£¨ÂÛÎÄ£©

µÚ5Õ ÏêϸÉè¼Æ

5.1 ¾ßÌåÄ£¿éÉè¼Æ

¿Î³Ì¸¨Öú½Ìѧƽ̨ϲâÊÔϵͳÓõÄÊÇÈý²ã¿ª·¢¼¼Êõ£¬Óɿͻ§²ãWebÈ¡µÃÓû§Êý¾Ý,BLL²ã×öÒµÎñÂß¼­µÄ´¦Àí£¬DAL²ã¸ºÔðºÍÊý¾Ý¿âµÄ½»»¥¡£Ö÷Òª°üÀ¨ÀÏʦ¹ÜÀíÄ£¿éºÍѧÉú¹ÜÀíÄ£¿é£¬ÆäÖÐÎÒ×öµÄÊÇÀÏʦ¹ÜÀíÄ£¿éÖеÄÌâÄ¿¹ÜÀíÄ£¿é£¨Ìî¿ÕÌ⡢ѡÔñÌ⣩¡¢ÊÔ¾í¹ÜÀíÄ£¿é¡¢²âÊÔ¹ÜÀíÄ£¿éºÍѧÉú¹ÜÀíÄ£¿éÖеIJâÊÔÄ£¿é¡¢³É¼¨¹ÜÀíÄ£¿é¡£ 5.1.1 ÌâÄ¿¹ÜÀíÄ£¿é

Éè¼ÆË¼Â·£º¶ÔÌî¿ÕÌâ½øÐйÜÀí£¬µã»÷Ìí¼ÓÌâÄ¿µ¯³öÌí¼ÓÌî¿ÕÌâ½çÃæ£¬ÔÚÏÂÀ­²Ëµ¥ÖÐÑ¡ÔñÄĸö¿ÆÄ¿µÄÌî¿ÕÌ⣬±àдÌâÄ¿ºÍ´ð°¸£¬È»ºó±£´æ¡£É¾³ýʱҪѡÔñÏàÓ¦µÄ¼Ç¼£¬µã»÷ɾ³ý¡£

Web²ãBLL²ãDAL²ãÊý¾Ý¿â1.ÊäÈëÌâÄ¿ÐÅÏ¢Ìí¼ÓÌâÄ¿1.1ÌâĿʵÌå1.1.1ÌâÄ¿Êý¾Ýͼ5.1 Ìí¼ÓÌâĿʱÐòͼ

ͼ5.2 Ìî¿ÕÌâ¹ÜÀí½çÃæ

16

ËÑË÷¸ü¶à¹ØÓÚ£º ÔÚÏß²âÊÔϵͳ£¨±ÏÒµÂÛÎÄ£© µÄÎĵµ
ÔÚÏß²âÊÔϵͳ£¨±ÏÒµÂÛÎÄ£©.doc ½«±¾ÎĵÄWordÎĵµÏÂÔØµ½µçÄÔ£¬·½±ã¸´ÖÆ¡¢±à¼­¡¢ÊղغʹòÓ¡
±¾ÎÄÁ´½Ó£ºhttps://www.diyifanwen.net/c0hjlf6xua085bn78adha_5.html£¨×ªÔØÇë×¢Ã÷ÎÄÕÂÀ´Ô´£©

Ïà¹ØÍÆ¼ö£º

ÈÈÃÅÍÆ¼ö
Copyright © 2012-2023 µÚÒ»·¶ÎÄÍø °æÈ¨ËùÓÐ ÃâÔðÉùÃ÷ | ÁªÏµÎÒÃÇ
ÉùÃ÷ :±¾ÍøÕ¾×ðÖØ²¢±£»¤ÖªÊ¶²úȨ£¬¸ù¾Ý¡¶ÐÅÏ¢ÍøÂç´«²¥È¨±£»¤ÌõÀý¡·£¬Èç¹ûÎÒÃÇ×ªÔØµÄ×÷Æ·ÇÖ·¸ÁËÄúµÄȨÀû,ÇëÔÚÒ»¸öÔÂÄÚ֪ͨÎÒÃÇ£¬ÎÒÃǻἰʱɾ³ý¡£
¿Í·þQQ£ºxxxxxx ÓÊÏ䣺xxxxxx@qq.com
ÓåICP±¸2023013149ºÅ
Top