C#±ÏÒµÉè¼ÆËµÃ÷Êé--¿ìµÝµ¥´òӡϵͳÇà

¿ªÊ¼Óû§µÇ¼³¬¼¶Óû§·Ç³¬¼¶Óû§Ìí¼Ó²Ù×÷Ô±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

ÁªÏµ¿Í·þ£º779662525#qq.com(#Ìæ»»Îª@)