¡¶Í¼Êé¹ÜÀíϵͳ¡·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Àࣨ²Î¼ûÎļþ¡°²Î