Õª Òª
Ëæ×ÅÍøÂçÓ¦Óü¼ÊõµÄ·ÉËÙ·¢Õ¹£¬»ùÓÚÍøÂçµÄÓ¦ÓÃϵͳ¸øÈËÃÇ´øÀ´ÁËÖî¶à±ãÀû¡£Ëæ×ÅÆóÒµÈËÔ±ÊýÁ¿Ôö¼Ó£¬ÆóÒµµÄÈËʹ¤×ʹÜÀí¹¤×÷Ò²±äµÃÔ½À´Ô½¸´ÔÓ¡£½¨Á¢ÈËʹ¤×ʹÜÀíϵͳÊÇΪÁËÊÊÓ¦ÆóÒµÏÖ´ú»¯¹ÜÀíµÄÐèÒª£¬·½±ã¹ÜÀíÖ°¹¤¹¤×ÊÇé¿öºÍÖ°¹¤¸öÈËÐÅÏ¢£»Í¬Ê±Ò²·½±ãÖ°¹¤¿ÉÒÔÉÏÍø²éѯ×Ô¼ºµÄ¹¤×ÊÐÅÏ¢£¬»¹ÓÐÀûÓÚÌá¸ß°ì¹«Ð§ÂÊ£¬¸ÄÉư칫ÖÊÁ¿£¬¹æ·¶ÆóÒµÖ°¹¤¹¤×ʵij£¹æ¹ÜÀí¹¤×÷¡£¹¤×ʹÜÀí¼ÈÉæ¼°µ½ÆóÒµÀͶ¯ÈËʵĹÜÀí£¬Í¬Ê±Ò²ÊÇÆóÒµ²ÆÎñ¹ÜÀíµÄÖØÒª×é³É²¿·Ö¡£×ʽðÊÇÆóÒµÉú´æµÄÖ÷ÒªÔªËØ£¬×ʽðµÄÁ÷¶¯Ó°Ïìµ½ÆóÒµµÄÕûÌåÔË×÷£¬ÆóÒµÔ±¹¤µÄ¹¤×ÊÊÇÆóÒµ×ʽð¹ÜÀíµÄÒ»¸öÖØÒªµÄ×é³É²¿·Ö¡£ÔçÆڵŤ×Êͳ¼ÆºÍ·¢·Å¶¼ÊÇʹÓÃÈ˹¤·½Ê½´¦ÀíÖ½ÖʲÄÁÏ£¬²»½ö»¨·Ñ²ÆÎñÈËÔ±´óÁ¿µÄʱ¼äÇÒ²»Ò×±£´æ£¬ÍùÍùÓÉÓÚ¸öÈ˵ÄÒòËسд²»É÷»ò¼ÆËãÊèºö£¬³öÏÖ¹¤×Ê·¢·Å´íÎóµÄÏÖÏó¡£ÔçÆÚ¹¤×ʹÜÀí¶à²ÉÈ¡Ö½ÖʲÄÁϺ;ßÓнÏÇ¿µÄʱ¼äÏÞÖÆ¡£»ùÓÚÒÔÉÏÔÒò£¬ÆóÒµ¹¤×ʹÜÀíϵͳʹÓõçÄÔ°²È«±£´æ¡¢¿ìËÙ¼ÆË㡢ȫÃæͳ¼Æ£¬ÊµÏÖ¹¤×ʹÜÀíµÄϵͳ»¯¡¢¹æ·¶»¯¡¢×Ô¶¯»¯¡£
ÈËʹ¤×ʹÜÀíϵͳÊǵäÐ͵ÄÐÅÏ¢¹ÜÀíϵͳ£¨MIS£©£¬¸Ãϵͳ¾ß±¸ÁËÒÔϹ¦ÄÜ: ϵͳÐèÒª·ÖΪÎ岿·ÖÈËʹÜÀíÄ£¿é¡¢¹¤×ʹÜÀíÄ£¿é¡¢ÏµÍ³¹ÜÀíÄ£¿é¡¢Óû§¹ÜÀíÄ£¿é¡¢ÐÅÏ¢²éѯµÈ¹¦ÄÜÄ£¿é¡£±¾ÏµÍ³²ÉÓÃÁËÄ¿Ç°Á÷ÐеÄB/Sģʽ¡£Ñ¡ÔñVisual Studio2010×÷Ϊ¿ª·¢Æ½Ì¨£¬ÒÔMS SQL Server 2008 ×÷Ϊ ºǫ́Êý¾Ý¿âÀ´Íê³É¶ÔϵͳµÄÉè¼ÆºÍ¿ª·¢¡£¼´ä¯ÀÀÆ÷¡¢Ó¦Ó÷þÎñÆ÷¡¢Êý¾Ý¿â·þÎñÆ÷Èý²ãÌåϵ½á¹¹¡£Windows Server 2003²Ù×÷ϵͳ¡¢¿Í»§¶Ë²ÉÓÃIEä¯ÀÀÆ÷ºÍ·þÎñÆ÷Á¬½Ó,×îÖÕÐγÉÁË»ùÓÚB/SģʽµÄÈËʹ¤×ʹÜÀíϵͳ¡£
¹Ø¼ü´Ê£ºÈËʹ¤×Ê Visual Studio ÐÅÏ¢¹ÜÀí B/S
Abstract
With the rapid development of network technology, web-based application systems to bring people a lot of convenience. With the increasing number of corporate personnel, enterprise personnel wage management work also becomes more and more complex. The establishment of wage and personnel management system in order to adapt to modern enterprise management needs, to facilitate the management of salary of staff and worker individual information; at the same time the convenience can check their salary information, but also can improve the office efficiency, improve office quality, standardize enterprise workers wages routine management work. Management involves both wage labor and personnel management, enterprise financial management is also an important part of. Capital enterprises to survive is the main element, capital flows affect the overall operation of enterprises, the wages of employees in financial management of enterprises is an important part of. Early wages are paid and the use of artificial materials handling paper, not only the financial officers spent a lot of time and difficult to preserve, often due to personal factors copying carelessness or negligence of the calculation, payment of wages in the wrong phenomenon. Early salary management adopts the material and has the strong time constraints. Based on the above reason, the enterprise wage management system using computer security, fast calculation, comprehensive statistics, the realization of the wage management system is changed, standardization, automation.
Personnel salary management system is a typical management information system ( MIS ), the system has the following functions: the system is divided into five parts of personnel management module, management module, system management module, user management module, the information query module. The system adopts the popular B / S model. Select the Visual Studio2010 as the development platform, with MS SQL Server 2008database as a background to the completion of the system design and development. Browser, application server, database server three layer system structure. Windows Server 2003operating system, using IE browser client and server connection, eventually forming based on B / S mode of personnel management system of wages.
Key words: the wages of personnel information management Visual Studio B / S
Ŀ ¼
Õª Òª III
Abstract IV
µÚÒ»Õ Ð÷ ÂÛ 1
1£®1 Ñ¡Ìâ±³¾° 1
1£®2 Ñо¿Ä¿µÄºÍÒâÒå 1
1£®3 Ñо¿µÄÏÖ×´ 2
1£®3¿ª·¢ËùÓü¼Êõ¼°Ìصã 2
1.3.1 B/S¿ª·¢Ä£Ê½ 2
1.3.2 ASP.NET¼°Visual Studio½éÉÜ 3
1.3.3 ADO.NET½éÉÜ 5
µÚ¶þÕ ϵͳ·ÖÎöÓë×ÜÌåÉè¼Æ 7
2£®1 ϵͳÐèÇó·ÖÎö 7
2£®2 ϵͳ¹¦ÄÜ·ÖÎö 7
2.3ϵͳ¼Ü¹¹·ÖÎö 8
2.4ϵͳ¿ÉÐÐÐÔ·ÖÎö 9
2.5ϵͳ×ÜÌåÉè¼Æ 10
2.5.1ϵͳÉè¼Æ˼Ïë 10
2.5.2ϵͳ¹¦ÄÜÄ£¿éÉè¼Æ 11
2.5.2¹¦ÄÜÄ£¿é 11
2.6»ù±¾Á÷³Ì·ÖÎö 12
2.6.1ϵͳʹÓÃ×ÜÁ÷³Ì 12
2.6.2ÐÂÔ±¹¤×¢²áÁ÷³Ì 13
2.6.3¹ÜÀíÔ±¼Ç¼Á÷³Ì 13
2.6.4¹¤×ʽáËãÁ÷³Ì 14
µÚÈýÕ»ù±¾µÄÀíÂÛ 15
3.1Êý¾Ý¿â½éÉÜ 15
3.2Êý¾Ý±íÉè¼Æ 16
3.2.1¸ÅÄî½á¹¹Éè¼Æ 16
3.2.2Êý¾Ý¿âE-RͼÉè¼Æ 17
3.2.3Êý¾Ý¿âÂß¼½á¹¹Éè¼Æ 19
µÚËÄÕ ¹¦ÄÜÄ£¿éÏêϸÉè¼Æ 20
4. 1µÇ¼ģ¿éÉè¼Æ 20
4. 2Ìí¼ÓÔ±¹¤ÐÅϢģ¿éÉè¼Æ 22
Æä¹Ø¼ü³ÌÐò´úÂëÈçÏÂËùʾ£º 22
4. 3»ù±¾¹¤×ÊÉèÖÃÄ£¿éÉè¼Æ 23
4. 3¹¤×Ê×ܽáÄ£¿éÉè¼Æ 24
µÚÎåÕ ϵͳ²âÊÔ 27
5.1 ²âÊÔµÄÈÎÎñ¼°Ä¿±ê 27
5.1.1²âÊÔµÄÈÎÎñ 27
5.1.2²âÊÔµÄÄ¿±ê 27
5.2²âÊÔ·½°¸ 27
5.2.1Ä£¿é²âÊÔ 27
5.2.2¼¯³É²âÊÔ 28
5.2.3ÑéÊÕ²âÊÔ 28
5.2.4ƽÐÐÔËÐÐ 28
µÚÁùÕ ϵͳʹÓÃά»¤ 29
6.1ϵͳʹÓÃ˵Ã÷ 29
6.2ϵͳµÄά»¤ 29
½á¡¡ÂÛ 31
Ö л 32
²Î¿¼ÎÄÏ× 33
µÚÒ»Õ Ð÷ ÂÛ
1£®1 Ñ¡Ìâ±³¾°
Ëæ׿ÆËã»ú¼¼ÊõµÄ·ÉËÙ·¢Õ¹£¬¼ÆËã»úÔÚ¸ßУ¹ÜÀíÖÐÓ¦ÓõÄÆÕ¼°£¬ÀûÓüÆËã»úʵÏÖÆóÒµµÄÈËʹ¤×ʹÜÀíÊÆÔÚ±ØÐС£´«Í³µÄ¹¤×ʹÜÀíϵͳͨ³£²ÉÓù̶¨µÄ¹¤×ʼÆË㹫ʽºÍ¹Ì¶¨µÄ¹¤×ÊÏîÄ¿£¬ÄÑÓÚÊÊÓ¦Êг¡¾¼ÃÌõ¼þϹ¤×ÊÕþ²ßºÍ¹¤×ÊÖƶȵı仯¡£ÏÖÓеÄÈáÐÔ¹¤×ʽṹµÄ¹¤×ʹÜÀíϵͳËäÈ»¿ÉÒÔ×Ô¶¨ÒåÕÊÌס¢¹¤×ÊÏîÄ¿ºÍ¼ÆË㹫ʽµÈ£¬µ«ÍùÍù²Ù×÷¸´ÔÓ£¬ÄÑÓÚÔÚ»ù²ã¿Í»§ÖÐÍƹãʹÓ᣶ÔÓÚÆóÒµÀ´Ëµ£¬ÀûÓüÆËã»úÖ§³ÖÆóÒµ¸ßЧÂÊÍê³ÉÀͶ¯ÈËʹÜÀíµÄÈÕ³£ÊÂÎñ£¬ÊÇÊÊÓ¦½¨ÉèÆóÒµÏÖ´ú»¯ÒªÇó¡¢Íƶ¯ÆóÒµÈËʹÜÀí×ßÏò¿Æѧ»¯¡¢¹æ·¶»¯µÄ±ØÒªÌõ¼þ£»¶ø¹¤×ʹÜÀíÊÇÒ»ÏîËöËé¡¢¸´ÔÓ¶øÓÖÊ®·ÖϸֵŤ×÷£¬¹¤×ʼÆËã¡¢·¢·Å¡¢ºËËãµÄ¹¤×÷Á¿ºÜ´ó£¬Ò»°ã²»ÔÊÐí³ö´í£¬Èç¹ûʵÐÐÊÖ¹¤²Ù×÷£¬Ã¿Ô·¢·Å¹¤×ÊÐëÊÖ¹¤ÌîÖÆ´óÁ¿µÄ±í¸ñ£¬Õâ¾Í»áºÄ·Ñ¹¤×÷ÈËÔ±´óÁ¿µÄʱ¼äºÍ¾«Á¦£¬¼ÆËã»ú½øÐй¤×Ê·¢·Å¹¤×÷£¬²»½öÄܹ»±£Ö¤¹¤×ʺËËã׼ȷÎÞÎ󡢿ìËÙÊä³ö£¬¶øÇÒ»¹¿ÉÒÔÀûÓüÆËã»ú¶ÔÓйع¤×ʵĸ÷ÖÖÐÅÏ¢½øÐйÜÀí£¬·þÎñÓÚ²ÆÎñ²¿ÃÅÆäËû·½ÃæµÄºËËãºÍ²ÆÎñ´¦Àí£¬Í¬Ê±¼ÆËã»ú¾ßÓÐÊÖ¹¤¹ÜÀíËùÎÞ·¨±ÈÄâµÄÓŵã.ÀýÈç:¼ìË÷ѸËÙ¡¢²éÕÒ·½±ã¡¢¿É¿¿ÐԸߡ¢´æ´¢Á¿´ó¡¢±£ÃÜÐԺá¢ÊÙÃü³¤¡¢³É±¾µÍµÈ¡£ÕâЩÓŵãÄܹ»¼«´óµØÌá¸ßÈËʹ¤×ʹÜÀíµÄЧÂÊ,Ò²ÊǸßУµÄ¿Æѧ»¯¡¢Õý¹æ»¯¹ÜÀí,Óë¼ÆËã»úÍøÂç¼¼Êõ½Ó¹ìµÄÖØÒªÌõ¼þ¡£²»Í¬µÄÆóÒµ¾ßÓв»Í¬µÄÈËÊ¡¢¹¤×ʹÜÀíÖƶȣ¬Õâ¾Í¾ö¶¨Á˲»Í¬µÄ¸ßУÐèÒª²»Í¬µÄ¹¤×ʹÜÀíϵͳ¡£Ä³ÆóÒµÒÔÇ°µÄËùÓй¤×Ê×ÊÁ϶¼ÊÇÓõµ°¸Îı¾µÄÐÎʽÀ´½øÐйÜÀíµÄ£¬Ãæ¶ÔÄ¿Ç°µÄʵ¼Ê×´¿ö£¬ÆÈÇÐÐèÒª¿ª·¢Ò»¸öÐÂϵͳÀ´ÊÊÓ¦ÕâһЩ¹¤×÷¡£