¡¶Í¼Êé¹ÜÀíϵͳ¡·Éè¼ÆÖ¸µ¼Ê飨×îÍêÕû°æ£© ÏÂÔØ±¾ÎÄ

¡¶Í¼Êé¹ÜÀíϵͳ¡·C# Éè¼ÆÖ¸µ¼Êé V2.0 2013.8.1 ¡ª 9.20 LSH

6.4 Àà×ÜÌåÉè¼Æ£¨µü´ú1£©

ʵÌåÀà¡¢Êý¾Ý·ÃÎʲãÀà¡¢ÒµÎñÂß¼­²ãÀà¡¢±íʾ²ã´°¿ÚÀàµÄ³õ²½Éè¼ÆÈç±í3¡£ ±í3 ʵÌåÀà¡¢Êý¾Ý·ÃÎʲ㡢ҵÎñÂß¼­²ãµÄÀàÉè¼Æ ²ã ʵÌåÀàÄ£¿é £¨Model£© ÀàÃû ReaderType Reader Book Borrow Êý¾Ý·ÃÎʲ㠣¨DAL£© ReaderTypeDAL ReaderDAL BookDAL BorrowDAL SQLHelper ÒµÎñÂß¼­²ã £¨BLL£© ReaderTypeAdmin ReaderAdmin BookAdmin BorrowAdmin UserAdmin ±íʾ²ã £¨UI£© frmLogin frmMain frmReader ¡­ ˵Ã÷ ¶ÁÕßÀàÐÍʵÌåÀà ¶ÁÕßʵÌåÀà ͼÊéʵÌåÀà ½èÔļǼʵÌåÀà ¶ÁÕßÀàÐÍÊý¾Ý±í·ÃÎÊÀࣨ²å¡¢É¾¡¢¸Ä¡¢²é¡¢´æ´¢¹ý³ÌµÈ£© ¶ÁÕßÊý¾Ý±í·ÃÎÊÀࣨ²å¡¢É¾¡¢¸Ä¡¢²é¡¢´æ´¢¹ý³ÌµÈ£© ͼÊéÊý¾Ý±í·ÃÎÊÀࣨ²å¡¢É¾¡¢¸Ä¡¢²é¡¢´æ´¢¹ý³ÌµÈ£© ½èÔÄÊý¾Ý±í·ÃÎÊÀࣨ²å¡¢É¾¡¢¸Ä¡¢²é¡¢´æ´¢¹ý³ÌµÈ£© ΢ÈíÌṩµÄ¶ÔSQL ServerÊý¾Ý¿â½øÐзÃÎʵÄͨÓÃÀà ¶ÁÕßÀàÐ͹ÜÀíÀ࣬ʵÏֲ塢ɾ¡¢¸Ä¡¢²éµÈÐÅϢά»¤²Ù×÷¡£ ¶ÁÕß¹ÜÀíÀ࣬ʵÏÖ½èÊéÖ¤°ìÀí¡¢±ä¸ü¡¢²¹°ì¡¢¹Òʧ¡¢½â³ý¹Òʧ¡¢×¢ÏúµÈÓÃÀýÖеĸ÷ÖÖϵͳ²Ù×÷¡£ ͼÊé¹ÜÀíÀ࣬ʵÏÖͼÊé¹ÜÀí¸÷ÓÃÀýÖеÄϵͳ²Ù×÷ ½èÔĹÜÀíÀ࣬ʵÏÖ½èÊé¡¢»¹Êé¡¢Ðø½èµÈÓÃÀýÖеÄϵͳ²Ù×÷¡£ Óû§¹ÜÀíÀ࣬ µÇ¼´°¿ÚÀà ³ÌÐòÖ÷´°¿ÚÀ࣬º¬²Ëµ¥¡¢¹¤¾ßÀ¸¡¢×´Ì¬À¸µÈ ¶ÁÕß¹ÜÀí´°¿ÚÀà 6.5 Model²ãʵÌåÀàÉè¼Æ

ÔÚBookManage.ModelÏîÄ¿ÖÐÌí¼Ó4¸öʵÌåÀࣺReaderType¡¢Reader¡¢Book¡¢Borrow£¬·Ö±ð¶ÔÓ¦4¸öÊý¾Ý¿â±í¡£ÊµÌåÀàµÄÊôÐÔÓëÊý¾Ý¿â±í½á¹¹±£³ÖÒ»Ö£¨Ãû³Æ¡¢ÀàÐÍ£©£»ÊµÌåÀàÓ¦¾¡Á¿¼òµ¥£¬³ýÁËʵÌå¶ÔÏóµÄ¸´ÖÆÓë±È½ÏµÈ·½·¨Í⣬²»ÒËÌí¼Ó¹ý¶à·½·¨¡£

ÆäʵʵÌåÀà¾ÍÊÇʵÏÖORM¡£

ORM Object Relational Mapping ¶ÔÏó¹ØÏµÓ³É䣬ÊÇΪÁ˽â¾öÃæÏò¶ÔÏóµÄÀ࣬Óë¹ØÏµÊý¾Ý¿âµÄ±íÖ®¼ä£¬´æÔڵIJ»Æ¥ÅäµÄÏÖÏó£¬Í¨¹ýʹÓÃÃèÊö¶ÔÏóºÍ¹ØÏµÖ®¼äÓ³ÉäµÄÔªÊý¾Ý£¬ÔÚ³ÌÐòÖеÄÀà¶ÔÏó£¬Óë¹ØÏµÊý¾Ý¿âµÄ±íÖ®¼ä½¨Á¢³Ö¾ÃµÄ¹ØÏµ£¬ÓÃÓÚÔÚ³ÌÐòÖÐÃèÊöÊý¾Ý¿â±í¡£±¾ÖÊÉϾÍÊǽ«Êý¾Ý´ÓÒ»ÖÖÐÎʽת»»µ½ÁíÍâÒ»ÖÖÐÎʽ¡£

ORMÊÇÒ»¸ö¹ãÒåµÄ¸ÅÄÊÊÓ¦ÓÚ¹ØÏµÊý¾Ý¿âÓëÓ¦ÓóÌÐòÖ®¼äµÄ¸÷ÀàÊý¾Ýת»»£¬Ä¿Ç°ÓÐÐí¶à×Ô¶¯×ª»»¹¤¾ß¿ÉÓã¬Èçcodesmith µÈ£¬Ò²¿ÉÊÖ¹¤ÊéдʵÌåÀà´úÂëÀ´ÊµÏÖORM¡£ 1. ReaderType

Àà

ÔÚModelÏîÄ¿ÖÐÌí¼Óн¨ÏC#´úÂëÀàReaderType.cs£¬Èçͼ7Ëùʾ¡£

17 / 47

¡¶Í¼Êé¹ÜÀíϵͳ¡·C# Éè¼ÆÖ¸µ¼Êé V2.0 2013.8.1 ¡ª 9.20 LSH

ͼ7 Ìí¼ÓC#´úÂëÀàÎļþReaderType.cs

±í×Ö¶ÎÓ³ÉäΪʵÌåÀàÊôÐԵĻù±¾·½·¨£¨VS 2005¼°ÒÔÉϰ汾£©ÈçÏ£º

private string _rdTypeName; public string rdTypeName {

get { return _rdTypeName; } set { _rdTypeName = value; }

}

¶øÔÚVS 2008¼°ÒÔÉϰ汾Öпɼò»¯Îª£º

public string rdTypeName { get; set; }

±í4 SQL×Ö¶ÎÀàÐÍÓëʵÌåÀàÊôÐÔÀàÐ͵ÄÓ³Éä¹ØÏµ SQL Server×Ö¶ÎÀàÐÍ nchar, nvarchar, text int, smallint numeric(12,0) datetime Float, money bit image DataTableÖÐÀàÐÍ System.String System.Int32, System.Int16 System.Decimal System.DateTime C#ʵÌåÀàÉè¼ÆÊôÐÔ string int long DateTime System.Single, System.Decimal float System.Boolean System.Byte[] bool Byte[] ÔÚVS 2008¼°ÒÔÉϰ汾ÖÐReaderTypeÀàµÄʵÏÖ´úÂëÈçÏ£º 18 / 47

¡¶Í¼Êé¹ÜÀíϵͳ¡·C# Éè¼ÆÖ¸µ¼Êé V2.0 2013.8.1 ¡ª 9.20 LSH

ÔÚVS 2005£¨º¬2008¼°ÒÔÉϰ汾£©ÖÐReaderTypeÀàµÄʵÏÖ´úÂëÈçÏ£º

19 / 47

¡¶Í¼Êé¹ÜÀíϵͳ¡·C# Éè¼ÆÖ¸µ¼Êé V2.0 2013.8.1 ¡ª 9.20 LSH

ÁíÍ⣬¿ÉÌí¼Ó¸´Öƹ¹Ô캯Êý£¬ÈçÏ£º

public ReaderType(ReaderType rt) {

this.rdType = rt.rdType;

this.rdTypeName = rt.rdTypeName; this.CanLendQty = rt.CanLendQty; this.CanLendDay = rt.CanLendDay;

this.CanContinueTimes = rt.CanContinueTimes; this.PunishRate = rt.PunishRate; this.DateValid = rt.DateValid; }

2. Reader3. Book

ÀࣨÂÔ£©

ÀࣨÂÔ£© ÀࣨÂÔ£©

4. Borrow

6.6 DAL²ãÀàÉè¼Æ

³ýSqlHelperÍ⣬ÿ¸öÊý¾Ý¿â±í¶ÔÓ¦Ò»¸öDAL²ãÀ࣬Ö÷ҪʵÏָñíµÄ²åɾ¸Ä²é²Ù×÷¡£ 1. SqlHelper

Àà

20 / 47

ÔÚBookManage.DALÏîÄ¿ÖÐÌí¼ÓSqlHelper.csÎļþ£¬¸ÃÀàÊÇ΢ÈíSqlHelperÀࣨ²Î¼ûÎļþ¡°²Î