¿ªÊ¼Óû§µÇ¼³¬¼¶Óû§·Ç³¬¼¶Óû§Ìí¼Ó²Ù×÷Ô±YNɾ³ý²Ù×÷Ô±YÐ޸ĵǼÓû§ÐÅÏ¢YÌí¼Ó³É¹¦Í˳ö²Ù×÷ɾ³ý³É¹¦N±£´æ²Ù×÷Ô±ÐÅÏ¢YÐ޸ijɹ¦¿ìµÝµ¥ÉèÖÿìµÝµ¥²éѯ¿ìµÝµ¥´òÓ¡
Ìí¼Ó¿ìµÝµ¥Ð޸ĿìµÝµ¥É¾³ý¿ìµÝµ¥ ͼ2-4 ϵͳÁ÷³Ìͼ
2.5 ϵͳµÄ¿ª·¢»·¾³
£¨1£©ÔËÐÐÆ½Ì¨£ºWindows 7¡£
£¨2£©Êý¾Ý¿â¹ÜÀíϵͳÈí¼þ£ºMicrosoft SQL Sever 2005¡£ £¨3£©¿ª·¢ÓïÑÔ£ºVisual C#.NET¡£ £¨4£©ÏµÍ³¿ª·¢Æ½Ì¨£º.NET Framework 4¡£ £¨5£©·Ö±æÂÊ£º1360¡Á768¡£
7
µÚÈýÕ Êý¾Ý¿â·ÖÎöÓëÉèÖÃ
3.1 Êý¾Ý¿â·ÖÎö
¿¼Âǵ½¿ìµÝ¹«Ë¾ÐèÒª´¦ÀíÅÓ´óµÄÐÅÏ¢Á¿£¬Êý¾Ý¿âά»¤¹¤×÷Á¿½Ï´ó£¬ÔÚ¿ª·¢¿ìµÝ
µ¥Èí¼þ´òӡϵͳʱ£¬Ñ¡ÓÃSQL Sever 2005×÷ΪÊý¾Ý¿â¹ÜÀíϵͳ¡£ÔÚ¸ÃÊý¾Ý¿â¹ÜÀíϵͳÖУ¬Ð½¨Ò»¸öÊý¾Ý¿â£¬Êý¾Ý¿âÃûΪdb_Express£¬ÔÚdb_ExpressÊý¾Ý¿âÖÐн¨4¸öÊý¾Ý±í£¬·Ö±ðÓÃÀ´´æ´¢µ¥¾ÝÄ£°å¡¢¿ìµÝµ¥¼Ç¼¡¢µ¥¾ÝÀàÐͺͲÙ×÷Ô±µÈÐÅÏ¢£¬Ð½¨µÄÊý¾Ý±íÐÅÏ¢Èçͼ3-1Ëùʾ¡£
¡ª¡ª¡ªµ¥¾ÝÄ£°åÐÅÏ¢±í
¡ª¡ª¡ª¿ìµÝµ¥¼Ç¼ÐÅÏ¢±í
¡ª¡ª¡ªµ¥¾ÝÀàÐÍÐÅÏ¢±í
¡ª¡ª¡ª²Ù×÷Ô±ÐÅÏ¢±í
ͼ3-1 db_ExpressÊý¾Ý¿âµÄ˵Ã÷
3.2 Êý¾Ý¿â¸ÅÄîÉè¼Æ
²Ù×÷Ô±ÔڵǼ¸Ãϵͳʱ£¬ÐèÒª¾¹ýÉí·ÝµÄÑéÖ¤£¬²Ù×÷Ô±·ÖΪ³¬¼¶Óû§ºÍ·Ç³¬¼¶Óû§£¬ÔÚ±¾ÏµÍ³ÖУ¬Ö»ÉèÖÃÒ»¸ö³¬¼¶Óû§£¬ÆäËûµÄ¶¼ÊǷdz¬¼¶Óû§£¬ËûÃǵÄÇø±ðÖ÷ÒªÌåÏÖÔÚ¡°²Ù×÷Աά»¤¡±Ä£¿é£¬³¬¼¶Óû§¿ÉÒԶԷdz¬¼¶Óû§½øÐÐÌí¼ÓºÍɾ³ý¡£²Ù×÷Ô±ÐÅÏ¢E¡ªRͼ3-2-1Ëùʾ¡£
²Ù×÷Ô±Ãû³ÆÃÜÂë²Ù×÷Ô±´úÂë²Ù×÷Ô±¼¶±ð²Ù×÷Ô±µÇ¼ÐÅÏ¢
ͼ3-2-1 ²Ù×÷Ô±ÐÅÏ¢E-Rͼ
µ¥¾ÝÀàÐÍÖ÷ÒªÊÇÖ¸¸ÃϵͳÖпìµÝµ¥ÐÅÏ¢µÄ»ù±¾²ÎÊý£¬¿ìµÝµ¥ÉèÖÃÊÇÕû¸öϵͳÁ÷³ÌµÄ»ù´¡£¬ÏµÍ³´æÔÚ¶àÖÖÀàÐ͵ĿìµÝµ¥£¬ÎªÁË·½±ã¿ìµÝµ¥µÄ¹ÜÀíÒÔ¼°Êý¾Ý±íÖ®¼ä¹ØÁªÐÅÏ¢µÄÕûºÏ£¬ËùÒÔ¸ÃÊý¾Ý±íΪÿ¸öµ¥¾ÝÀàÐÍÉèÖÃÁ˶ÔÓ¦µÄ±àÂë±íʾ¡£ÔÚ
8
¡°IsEnabled¡±ÁбíÖÐ,¡°1¡±ÆôÓõ¥¾ÝÀàÐÍ£¬¡°0¡±±íʾ½ûÓõ¥¾ÝÀàÐÍ¡£µ¥¾ÝÀàÐÍÐÅÏ¢µÄE-RͼÈçͼ3-2-2Ëùʾ¡£
µ¥¾ÝÀàÐÍÃû³Æ±ê¼Çµ¥¾ÝÀàÐͱàÂëµ¥¾Ý¿í¶Èµ¥¾ÝÀàÐÍÐÅÏ¢±àÂ볤¶Èµ¥¾Ý¸ß¶ÈÊÇ·ñÆôÓÃ
µ¥¾ÝͼƬ ͼ3-2-2 µ¥¾ÝÀàÐÍÐÅÏ¢E-Rͼ
µ¥¾ÝÄ£°åÊÇͨ¹ýGDI+ͼÐγÌÐòÉè¼ÆÓïÑÔ»æÖÆ£¬×ª»»Îª.bmp¸ñʽ±£´æµ½Ö¸¶¨Îļþ¼ÐÏ£¬±¾ÏµÍ³»æÖÆÁËÎåÖÖµ¥¾ÝÄ£°æ£¬·Ö±ðÊÇ·áËÙ´ï¿ìµÝµ¥¡¢Éêͨ¿ìµÝµ¥¡¢ÌìÌì¿ìµÝµ¥¡¢ÖÐͨ¿ìµÝµ¥ºÍ×··â¿ìµÝµ¥£¬ËüÃÇÉæ¼°µ½µÄÐÅÏ¢Ãû³Æ²»Í¬£¬ÓÿØÖƱàÂë±êʶ¿ØÖƵÄÃû³Æ£¬ÔÚ¡°IsFlag¡±ÁбíÖÐ,¡°1¡±±ê¼Ç¿ìµÝµ¥ºÅ£¬ÆäËüÃû³ÆÓá°0¡±±ê¼Ç¡£µ¥¾ÝÄ£°åÐÅÏ¢E-Rͼ3-2-3Ëùʾ¡£
Ä£°åÆðµãXÖá×ø±êµ¥¾ÝÀàÐͱàÂë¿ØÖÆ±àÂëÄ£°åÆðµãYÖá×ø±êÄ£°å¿í¶ÈÖµµ¥¾ÝÄ£°åÐÅÏ¢¿ØÖÆÃûµÄĬÈÏÉèÖÃֵģ°å¸ß¶Èֵģ°åÐÅÏ¢±ê¼Ç·û¿ØÖÆÃûµÄ½»»»Ïî¿ØÖÆÃû
9
ͼ3-2-3 µ¥¾ÝÄ£°åÐÅÏ¢E-Rͼ
ÔÚµ¥¾ÝÄ£°æÐÅÏ¢±íÍêÉÆ¡¢Ã÷È·ºó£¬²ÅÄÜÌîд¿ìµÝµ¥¼Ç¼ÐÅÏ¢£¬Ò»¸öµ¥¾ÝÀàÐͱà
Âë¿ÉÒÔ¶ÔÓ¦¶à¸ö¿ìµÝµ¥ºÅ£¬Ò»¸ö¿ìµÝµ¥ºÅ¿ØÖÆ×ÅÕûÕÅ¿ìµÝµ¥µÄÈ«²¿ÐÅÏ¢ÄÚÈÝ£¬Í¨¹ý¿ØÖƱàÂëÕÒµ½¿ØÖÆÃû³ÆÏµľßÌåÐÅÏ¢ÄÚÈÝ¡£±¾ÏµÍ³µÄ¿ìµÝµ¥ºÅ²ÉÓõÄÊÇÌõÐÎÂëÖеÄ39Â룬¿ìµÝµ¥¼Ç¼ÐÅÏ¢E-Rͼ3-2-4Ëùʾ¡£
¿ØÖƱàÂë¿ìµÝµ¥ºÅ´úºÅ±ê¼Ç¿ØÖÆÄÚÈݵ¥¾ÝÀàÐͱàÂë¿ìµÝµ¥¼Ç¼ÐÅÏ¢
ͼ3-2-4 ¿ìµÝµ¥¼Ç¼ÐÅÏ¢E¡ªRͼ
3.3 Êý¾Ý±íÂß¼½á¹¹Éè¼Æ
¸ù¾ÝÉè¼ÆºÃµÄʵÌåE-Rͼ´´½¨Êý¾Ý¿âµÄÂß¼½á¹¹£¬db_ExpressÊý¾Ý¿â¸÷±íµÄ½á
¹¹ÈçÏ£º
£¨1£©²Ù×÷Ô±µÇ¼ÐÅÏ¢±íÓÃÀ´´¢´æ²Ù×÷Ô±µÄÀà±ðÐÅÏ¢£¬°üÀ¨²Ù×÷Ô±´úÂ룬²Ù×÷Ô±Ãû³Æ¡¢ÃÜÂë¡¢²Ù×÷Ô±¼¶±ð4¸ö×ֶΡ£tb_Operator±íµÄÂß¼½á¹¹Èç±í3-3-1Ëùʾ¡£ ±í3-3-1 ²Ù×÷Ô±µÇ¼ÐÅÏ¢±í ×Ö¶ÎÃû Êý¾ÝÀàÐÍ ÊÇ·ñÖ÷¼ü ÊÇ·ñÔÊÐí¿ÕÖµ ÃèÊö OperatorCode Îı¾ÐÍ£¨varchar£© ÊÇ ·ñ ²Ù×÷Ô±´úÂë OperstorName Îı¾ÐÍ£¨varchar£© ·ñ ·ñ ²Ù×÷Ô±Ãû³Æ Password Îı¾ÐÍ£¨varchar£© ·ñ ·ñ ÃÜÂë IsFlag Îı¾ÐÍ£¨char£© ·ñ ·ñ ²Ù×÷Ô±¼¶±ð £¨2£©µ¥¾ÝÀàÐÍÐÅÏ¢±íÓÃÀ´´æ´¢¿ìµÝµ¥ÐÅÏ¢µÄ²ÎÊýÊôÐÔ£¬°üÀ¨µ¥¾ÝÀàÐͱàÂ룬µ¥¾ÝÀàÐÍÃû³Æ¡¢±ê¼Ç¡¢µ¥¾Ý¿í¶È¡¢µ¥¾Ý¸ß¶È¡¢µ¥¾ÝͼƬ¡¢ÊÇ·ñÆôÓᢱàÂ볤¶È8¸ö×ֶΡ£tb_BillType±íµÄÂß¼½á¹¹Èç±í3-3-2Ëùʾ¡£ ±í3-3-2 µ¥¾ÝÀàÐÍÐÅÏ¢±í ×Ö¶ÎÃû Êý¾ÝÀàÐÍ ÊÇ·ñÖ÷¼ü ÊÇ·ñÔÊÐí¿ÕÖµ ÃèÊö 10