Õª Òª
¡¡¡¡°éËæ×ÅÖйú¸ßµÈԺУµÄÀ©ÕУ¬ÏÖÔڵĸߵȽÌÓýÒѾ´Ó¾«Ó¢½ÌÓýÑݱä³É´óÖÚ½ÌÓý¡£°ìѧ¹æÄ£µÄ±ä´óµ¼Ö¸ßУʦ×ʶÓÎéÒ²Ô½À´Ô½ÅÓ´ó¡£ÓÉÓÚ½ÌʦÊýÁ¿¾çÔö£¬ÀÍ×ʹ¤×÷Á¿Ò²·¢Éú¾Þ´ó±ä»¯¡£½èÖúÊÖ¹¤²Ù×÷µÄ´«Í³·½·¨ÒѾ²»ÄÜÂú×ã¸ßУµÄ·¢Õ¹ÐèÒª£¬ÎªÁËʵÏָߵÈԺУÀÍ×ʹÜÀíµÄ¿ÆÑ§»¯ºÍÐÅÏ¢»¯£¬±¾ÂÛÎÄ¿ª·¢Ò»Ì×ÌØ±ðÊʺϸßУÀÍ×ʹÜÀíµÄÐÅϢϵͳ¡£
¡¡¡¡±¾ÏµÍ³µÄʵÏÖ¹ý³ÌÖУ¬Ç°Ì¨²ÉÓûùÓÚAsp.net¼¼Êõ¿ª·¢£¬ºǫ́²ÉÓÃSQL SERVER2005 ΪÊý¾Ý¿â¹ÜÀíϵͳÀ´¹¹³É¸ÃÀÍ×ʹÜÀíϵͳ¡£
¡¡¡¡±¾ÂÛÎĵÄÖ÷ÒªÍê³É¹¤×÷ÓУº
¡¡¡¡1¡¢½áºÏ××´óѧʵ¼ÊÇé¿ö£¬¶Ôµ±Ç°¹úÄÚ¸ßУµÄÀÍ×ʹÜÀí×öÈ«Ãæ·ÖÎöºÍµ÷²é£¬¶ÔÏÖÓеÄÀÍ×ʹÜÀíÖи÷ÖÖÎÊÌâ½øÐÐÊáÀí£¬¶Ô¸ÃÎÊÌâµÄ²úÉú½øÐÐÏêϸ·ÖÎö£¬Í¬Ê±Ìá³ö¿ÉÐеĽâ¾ö·½°¸¡£
¡¡¡¡2¡¢ÓÉÓÚµ±Ç°µÄÀÍ×ʹÜÀíÒµÎñ¹¤×÷±È½Ï·±Ã¦£¬Ïà¹Ø²¿ÃÅÖ®¼äµÄ¹¤×÷ºÜÈÝÒ×Ôì³É¹Ë´Ëʧ±ËµÄÏÖÏó£¬Òò´Ë±¾ÏµÍ³ÔÚÉè¼Æ¸÷¸öÄ£¿éʱ£¬³ä·Ö¿¼ÂÇÁ˸÷ÖÖÀÍ×ʹØÏµ£¬¶ÔϵͳµÄ²»Í¬¹¦ÄÜÄ£¿é½øÐгä·ÖÂÛÖ¤£¬Ê¹µÃϵͳµÄÔËÐбäµÄ¸ü·½±ãºÍ¿ì½Ý£¬Ìá¸ßѧУµÄÈËʹÜÀíЧÂÊ£¬ÓÈÆäÊÇÀÍ×ʹÜÀíЧÂÊ£¬ÌáÉý²¿ÃŰìÊÂÐÎÏó¡£
¡¡¡¡3¡¢ÓÉÓÚÀÍ×ʹÜÀíÉæ¼°¶à¸ö²¿ÃÅ£¬µ±Ç°²¿ÃÅÖ®¼ä´æÔÚÐÅÏ¢½»»¥²»¼°Ê±¡¢²»×¼È·µÈÏÖÏ󣬱¾ÏµÍ³¿ª·¢¹ý³ÌÖУ¬³ä·Ö¶ÔϵͳÓû§½øÐе÷ÑУ¬»®·ÖÇ¡µ±µÄÓû§È¨ÏÞ£¬×î´óÏ޶ȵÄÌáÉý²¿ÃÅÖ®¼äÅäºÏĬÆõ¶È¡£Í¬Ê±£¬¶ÔϵͳµÄÓû§Êý¾Ý±í½øÐÐÏêϸÉè¼Æ£¬Ìá¸ßÓû§µÄÊý¾Ý׼ȷÐÔ¡£
¡¡¡¡¹Ø¼ü´Ê£ºAsp.net£¬ SQL Server 2005£¬ÀÍ×ʹÜÀí
ABSTRACT
¡¡¡¡With the dramatic enrollment expansion of higher education in China£¬the higher education has evolved into a popular education from elite education. At the same time, the scale of colleges and universities gets larger and larger, so the numbers of the faculty and staff members at the universities increase too. The work turns out to be more and more challenging to handle the salary and other welfare of teachers in the labor department and personnel department. Due to the increase of teachers£¬the workload has changed greatly. The traditional manual operation cannot meet the demands of the development of colleges and universities. In order to realize the scientific and informational management for the labor in colleges and universities£¬this thesis develops an information system which is suitable for the labor management of colleges and universities. The system is based on ASP technology as the development interface. The background tier is SQL SERVER 2005 as the database management system to constitute the labor management system.
¡¡¡¡The main features of the thesis are:
¡¡¡¡1. Investigate the current process of labor work. Analyze all varieties of issues appearing during the work of the present labor market. Then design each module of labor management. As the result, a more reasonable and efficient system is implemented.
¡¡¡¡2. Since the current labor management work is very engaged, it is not rare for people to miss something while taking care of other things Therefore, during the design phase for each module of this system, a complete analysis of all kinds of labor relations performed. Various functional modules of the system are delicately evaluated and refined. Consequently £¬ the final system becomes much more efficient and convenient to use. This will greatly improve the productivity of the labor management in universities, especially for the labor and payment work productivity, and therefore improve the overall image of the labor department.
¡¡¡¡3. Given the involvement of multiple departments during the labor management procedure, it happens that sometimes different departments couldn't exchange information timely or accurately. During the design phase of the system, solid user surveys are carried out. Appropriate user access privileges are distinguished. These improve the cooperation between various departments to the maximum extent. At the same time, the user data table is delicately designed to improve the data accuracy for users.
¡¡¡¡Key Words: ASP.net; SQL Server 2005; Labor management
¡¡¡¡ÎÒ¹ú¾¼ÃӲʵÁ¦ÈÕÒæÔöÇ¿£¬ËæÖ®´øÀ´µÄÊÇÈíʵÁ¦µÄ½øÒ»²½Í»Î§£¬ÕâÒ²¾Í¼¤·¢ÎÒ¹ú½ÌÓýÊÂÒµµÄ²»¶Ï·¢Õ¹¡£ÌرðÊÇ£¬×Ô 1999 Äê½ÌÓý¸Ä¸ïÕØÊ¼£¬¹úÄÚ¸ßУÀ©´óÕÐÉú·¶Î§ºÍÈËÊý¸÷¸ßУµÄ°ìѧ¹æÄ£Ò²²»¶ÏÀ©´ó£¬Öð½¥ÐγÉÁ˶àÐ£Çø°ìѧµÄ¸ñ¾Ö¡£ÕâÖÖÐÂÐ͸ßУ°ìѧģʽµÄÐËÆð£¬Ê¹µÃÒ»Ö±ÒÔÀ´ÑØÓõÄÈ«È˹¤»ò°ë×Ô¶¯µÄ¹ÜÀí·½Ê½²»ÔÙÊÊÓ¦ÏÖʵµÄÐèÇó£¬ÌرðÊǰéËæ×Ź¤×÷Á¿µÄ´óÔö£¬Ïà¹Ø¹ÜÀí¹¤×÷Öð½¥ÏÔÏÖ³öÄÑÒÔÓ¦¶ÔµÄ¾ÖÃæ¡£ÔÚÕâÖÖ±³¾°Ï£¬ÎÒÃǼ±Ðè²ÉÓÃÏÖÓеÄÈí¼þ£¬ÔÚÏÖÓÐÀÍ×ʹÜÀíµÄ»ù´¡Ö®ÉÏ£¬Í¨¹ýÄ£¿éÌí¼Ó¡¢×ÊÔ´ÓÅ»¯ÉèÖõȷ½Ê½£¬½¨Á¢Ò»Ì×¾ßÓÐÍøÂçÐÅÏ¢µÄ±ã½Ý¡¢×¼È·¡¢ÐÅÏ¢¹²ÏíµÄÀÍ×ʹÜÀíÐÅϢϵͳ£¬Í¬²½ÊµÏÖÀÍ×ʸ÷ÏîÒµÎñµÄÓлú×ۺϲÙ×÷£¬ÀÍ×ÊÐÅÏ¢µÄ´¦Àí¡¢±£´æ£¬ÀÍ×ÊÒµÎñµÄ¹æ·¶»¯¹ÜÀí¡£Í¬Ê±£¬Í¨¹ýÕâÖÖÐÂÐÍÀÍ×ʹÜÀíģʽ£¬½«ÔÓоÖÏÞÓÚÈ˹¤²Ù×÷µÄÀÍ×ʹÜÀíÊÂÎñ·¶Î§½øÒ»²½ÍØÕ¹£¬²»ÔÙÒòÈ˹¤ÎÞ·¨²Ù×÷¶øµ¼Ö²¿·Ö¿ÉÄܵÄÒµÎñÎÞ·¨¿ªÕ¹¡£
¡¡¡¡××´óѧÊÇÒ»Ëù××ÊÐÈËÃñÕþ¸®Ö÷¹Ü¡¢××Ê¡½ÌÓýÌüºÏ×÷¹ÜÀíµÄ±¾¿Æ±¨¿¼µÚ¶þÅú´Î´óѧ¡£20××Ä꣬¸ù¾ÝÖ÷¹Ü²¿ÃŵÄÅú×¼£¬¸ÃУÓÉÓÚ 20××ÄêÓë××××ʦ·¶Ñ§Ð£¡¢××ѧУºÍ××××ѧԺµÄºÏ²¢¡£×Ô´Ë£¬Ñ§Ð£Íê³É¶àµØ°ìѧƽ̨µÄ´î½¨£¬²¢ÉèÖà A Ð£Çø¡¢B Ð£ÇøÒÔ¼° C ±¾²¿Ð£ÇøµÈÈýµØÁª¶¯Ð£Çø¡£¶àÄêÀ´£¬ÓÈÆäÊÇѧУʵʩÒý½øÈ˲ʤ³ÌÒÔÀ´£¬Ê¦×ʶÓÎé²»¶Ï׳´ó£¬¸÷ÀàÀÍ×ÊÒµÎñ²»¶ÏÔö¶à¡£µ«ÊÇ£¬Ñ§Ð£ÈԾɲÉÓÃÈ«È˹¤²Ù×÷»ò¼òÒ×µç×Ó»¯°ì¹«µÄ·½Ê½¶ÔÀÍ×ÊÒµÎñµÄ¹ÜÀí¡£ÕâÑùÒ»À´£¬ºÜÈÝÒ׳öÏÖÈ˹¤²Ù×÷µÄÎÊÌ⣬ÄÑÒÔÓ¦¶Ô¸ü¶àµÄÀÍ×ʹÜÀí·½ÃæµÄ¹¤×÷¡£ËäȻĿǰÒÑÓÐÏֳɵÄÀÍ×Ê·½ÃæµÄ¹ÜÀíÈí¼þÔÚʹÓã¬È´ÒòΪÈí¼þ¿ª·¢ÖеľÖÏÞ£¬È±·¦Õë¶ÔÐÔ£¬¶ÔÓÚ¸ÃУÀÍ×Ê·½ÃæµÄ¾ßÌåÓ¦ÓÃÎÞ·¨ÍêÈ«ÊÊÓᣱÈÈ磬ÓÉÓÚѧУÀúÊ·µÄÔÒò£¬ÏÖÓкܶàѧԺºÍ²¿ÃÅ»¹´æÔÚ´óÁ¿ÍâÆ¸ÈËÔ±£¬ÔÚ´ËÇé¿öÏ£¬Ñ§Ð£¶ÔÒ»¸öÍøÂç°æÀÍ×ʹÜÀíϵͳµÄÐèÇó¾ÍÓ¦ÔËÃæÉú£¬ËüÓ¦¸ÃÊÇʵÓöøÇÒ¹¦ÄÜÇ¿´óµÄ£¬ËüÓ¦¸Ã¾ß±¸ÒÔÏÂÌØµãºÍÐèÇó£ºÈ«ÃæÊµÏÖ¶ÔÏà¹ØÊý¾ÝµÄ¹ÜÀí£»×¼È·¿ìËٵغËËãн³ê£»¼°Ê±ÓÐЧµØÍê³ÉÆäËûÏà¹Ø¹¤×÷£»ÔËÐа²È«¶øÇÒÎȶ¨¡£
¡¡¡¡××´óѧÓÉÓÚ½¨Ð£Ïà¶Ô±È½ÏÍí£¬ÔÚÒ»¶ÎʱÆÚÄÚ£¬ÔÚÈËʹÜÀíϵͳ·½Ã棬ÓÈÆäÊÇÀÍ×ʹÜÀí¹¤×÷·½ÃæÃ»ÓÐÊܵ½Óйط½ÃæµÄ×ã¹»ÖØÊÓ¡£ÓÉÓÚ½üÄêѧУ·ÉËÙ·¢Õ¹£¬ÓÈÆäÊǼ¸Ð£ºÏ²¢ºó£¬ÐγɶàÐ£Çø°ìѧµÄÏÖʵ£¬´ÙʹÀÍ×ʹÜÀí¹¤×÷²»¶Ï¸Ä½ø£¬Ñ§Ð£Ò²¶ÔÆä¹¤×÷Ìá³öÁ˸ü¸ßµÄÒªÇó¡£´ÓÏÖʵµÄÇé¿öÀ´¿´£¬ÀÍ×ʹÜÀíµÄÍøÂ绯ģʽӦ¸ÃÊǸÃÏ×÷·¢Õ¹µÄ·½Ïò¡£ÒÔÎÒУµÄÇé¿öΪÀý£¬ÈËʹÜÀí¹¤×÷¼«¾ßÌØÊâÐÔ£¬Òò´Ë¸»ÓÐÕë¶ÔÐԵġ¢Ð¡Ð͵ġ¢¹¦ÄÜÇ¿¡¢³É±¾µÍµÄÀÍ×ʹÜÀíϵͳµÄ¿ª·¢ÓëʹÓý«ÊǷdz£½ôÆÈºÍ±ØÒªµÄ¡£¸ÃУĿǰÒÑ»ùÓÚÍøÂç×ÊÔ´½¨Á¢ÁËÏÖÓеÄÍøÂç¹ÜÀíϵͳ£¬Èô°ÑÀÍ×ʹÜÀíϵͳ½¨Á¢ÓÚÐ£Ô°ÍøÂçÖ®ÉÏ£¬¿ÉÏë¶øÖª£¬Ïà¹Ø¹ÜÀíÈËԱͨ¹ý´ËÍøÂçϵͳʵʩÏà¹Ø²Ù×÷£¬Ò»·½ÃæÈÃÀÍ×ʹ¤×÷±äµÃ¼ò±ã¶ø¿ìËÙ£¬ÁíÒ»·½Ãæ¿ÉÒÔÈÃѧУÉÏ²ã¼°Ê±ÕÆÎÕѧУÀÍ×Ê·½ÃæµÄ¶¯Ì¬Çé¿ö£¬Îª¾ö²ßÌṩÒÀ¾Ý¡£ÔÙÕߣ¬Ñ§Ð£ÆäËûÈËÔ±Ò²Äܹ»ÀûÓôËϵͳ²éÔÄÓë×Ô¼ºÏà¹ØÀÍ×ÊÇé¿ö¡£Èç´ËÒ»À´£¬ÀÍ×ʹÜÀí¹¤×÷½«³¯×Ÿü¼Ó¹æ·¶µÄ·½Ãæ·¢Õ¹£¬·þÎñˮƽҲ½«½øÒ»²½ÌáÉý¡£
¡¡¡¡¸ßУÀÍ×ÊϵͳÉè¼Æ¿ª·¢£º
ϵͳ³¬¼¶¹ÜÀíÔ±µÇ¼½çÃæÍ¼
³¬¼¶¹ÜÀíÔ±¶Ô²Ù×÷Ô±½øÐÐÉèÖÃ
½ÌÖ°¹¤»ù±¾ÀÍ×ÊÐÅÏ¢¹ÜÀí
ÐÞ¸ÄÖ°¹¤»ù±¾ÐÅÏ¢
²éѯ½çÃæ²éÕÒÏà¹ØÐÅÏ¢
Ð޸ĽÌÖ°¹¤»ù±¾ÀÍ×ÊÐÅÏ¢
ÔÚ±àÖ°¹¤Ð½¼¶¹¤×ʹÜÀí
½ÌÖ°¹¤Ð½¼¶¹¤×ʲéѯºÍÐÞ¸Ä
Ŀ ¼
¡¡¡¡µÚÒ»Õ ¸ÅÊö
¡¡¡¡¡¡¡¡1.1 Ñ¡Ìâ±³¾°ºÍÒÀ¾Ý
¡¡¡¡¡¡¡¡1.2 ¹úÄÚ¸ßУÀÍ×ʹÜÀíµÄÏÖ×´
¡¡¡¡¡¡¡¡1.3 µ±Ç°¸ßУÀÍ×ʹÜÀíµÄ²»×ã
¡¡¡¡¡¡¡¡1.4 ×÷ÕßµÄÖ÷Òª¹¤×÷ºÍÏîÄ¿ÌØµã
¡¡¡¡¡¡¡¡¡¡¡¡1.4.1 ×÷ÕßµÄÖ÷Òª¹¤×÷
¡¡¡¡¡¡¡¡¡¡¡¡1.4.2 ±¾ÏîÄ¿ÌØµã
¡¡¡¡¡¡¡¡1.5 ÂÛÎÄÄÚÈÝÓëÕ½ڽṹ
¡¡¡¡µÚ¶þÕ ¸ßУÀÍ×ʹÜÀíϵͳÏà¹Ø¼¼Êõ¼ò½é
¡¡¡¡¡¡¡¡2.1 ASP.NET ¼¼Êõ½éÉÜ
¡¡¡¡¡¡¡¡2.2 IIS ¼¼Êõ½éÉÜ
¡¡¡¡¡¡¡¡2.3 SQL Server ¼¼Êõ½éÉÜ
¡¡¡¡¡¡¡¡2.4 ±¾ÕÂС½á
¡¡¡¡µÚÈýÕ ¸ßУÀÍ×ʹÜÀíϵͳÐèÇó·ÖÎöÓëÉè¼Æ
¡¡¡¡¡¡¡¡3.1 ±¾ÎÄÂÛÎĵĹÜÀíϵͳ¼°ÀÍ×ÊÒµÎñÏà¹Ø¸ÅÄî
¡¡¡¡¡¡¡¡¡¡¡¡3.1.1 Óù¤ÐÎʽ¸ÅÊö
¡¡¡¡¡¡¡¡¡¡¡¡3.1.2 Ïà¹Ø¸£Àû´ýÓöÃèÊö
¡¡¡¡¡¡¡¡3.2 ÏµÍ³Éæ¼°Ïà¹ØÀÍ×ÊÒµÎñ
¡¡¡¡¡¡¡¡3.3 ±¾ÏµÍ³¹¦ÄÜÐèÇóºÍÌåϵ½á¹¹
¡¡¡¡¡¡¡¡3.4 ϵͳÏà¹ØÄ£¿é½éÉÜÓëÉè¼Æ
¡¡¡¡¡¡¡¡3.5 ϵͳ¾ßÌ幦ÄÜÄ£¿éÉè¼Æ
¡¡¡¡¡¡¡¡¡¡¡¡3.5.1 Óû§È¨ÏÞ¹ÜÀíÄ£¿é
¡¡¡¡¡¡¡¡¡¡¡¡3.5.2 Êý¾Ý³õʼ»¯
¡¡¡¡¡¡¡¡¡¡¡¡3.5.3 ÿÔ¹¤×ʹÜÀíÄ£¿é
¡¡¡¡¡¡¡¡3.6 ϵͳÊý¾Ý¿âÉè¼Æ
¡¡¡¡¡¡¡¡3.7 Ïà¹Ø¼¼ÊõʵÏÖ
¡¡¡¡¡¡¡¡3.8 ±¾ÕÂС½á
¡¡¡¡µÚËÄÕ ¸ßУÀÍ×ʹÜÀíϵͳʵÏÖ
¡¡¡¡¡¡¡¡4.1 Ïà¹ØÄ£¿é½éÉܺÍϵͳ²Ù×÷˵Ã÷
¡¡¡¡¡¡¡¡¡¡¡¡4.1.1 Óû§µÄµÇ¼¼°¹ÜÀí
¡¡¡¡¡¡¡¡¡¡¡¡4.1.2 ϵͳ²Ù×÷˵Ã÷
¡¡¡¡¡¡¡¡4.2 ±¾ÕÂС½á
¡¡¡¡µÚÎåÕ ϵͳ²âÊÔ
¡¡¡¡¡¡¡¡5.1 ϵͳ²âÊÔ·½°¸
¡¡¡¡¡¡¡¡5.2 ²âÊÔÓÃÀýÉè¼Æ
¡¡¡¡¡¡¡¡5.3 ±¾ÕÂС½á
¡¡¡¡µÚÁùÕ ×ܽáºÍÕ¹Íû
¡¡¡¡¡¡¡¡6.1 ÂÛÎÄÍê³ÉµÄ¹¤×÷ºÍ³É¹û
¡¡¡¡¡¡¡¡6.2 Õ¹Íû
¡¡¡¡ÖÂл
¡¡¡¡²Î¿¼ÎÄÏ×
£¨ÈçÄúÐèÒª²é¿´±¾Æª±ÏÒµÉè¼ÆÈ«ÎÄ£¬ÇëÄúÁªÏµ¿Í·þË÷È¡£©