1using System;
  2using System.Data;
  3using System.Collections;
  4
  5using MyBookShop.DataAccessLayer;
  6using MyBookShop.DataAccessHelper;
  7
  8namespace MyBookShop.BusinessLogicLayer
  9...{
 10    /**//// <summary>
 11    /// Category 的摘要说明。
 12    /// </summary>
 13    public class Category
 14    ...{
 15        私有成员#region 私有成员
 16
 17        private int _categoryId;            //图书类别ID
 18        private string _categoryName;        //图书类别名
 19
 20        private bool _exist;                //是否存在标志
 21
 22        #endregion 私有成员
 23
 24        属性#region 属性
 25        
 26        public int CategoryID
 27        ...{
 28            set
 29            ...{
 30                this._categoryId=value;
 31            }
 32            get
 33            ...{
 34                return this._categoryId;
 35            }
 36        }
 37        public string CategoryName
 38        ...{
 39            set
 40            ...{
 41                this._categoryName=value;
 42            }
 43            get
 44            ...{
 45                return this._categoryName;
 46            }
 47        }
 48        public bool Exist
 49        ...{
 50            get
 51            ...{
 52                return this._exist;
 53            }
 54        }
 55
 56        #endregion 属性
 57
 58        方法#region 方法
 59        
 60        /**//// <summary>
 61        /// 根据参数categoryId，获取图书类别详细信息
 62        /// </summary>
 63        /// <param name="topicID">图书类别ID</param>
 64        public void LoadData(int categoryId)
 65        ...{
 66            Database db=new Database();        //实例化一个Database类
 67
 68            string sql="";
 69            sql="Select * from [Category] where CategoryId = "+ categoryId ;
 70
 71            DataRow dr=db.GetDataRow(sql);    //利用Database类的GetDataRow方法查询用户数据
 72
 73            //根据查询得到的数据，对成员赋值
 74            if(dr!=null)
 75            ...{
 76                this._categoryId=GetSafeData.ValidateDataRow_N(dr,"CategoryId");
 77                this._categoryName=GetSafeData.ValidateDataRow_S(dr,"CategoryName");
 78                
 79                this._exist=true;
 80            }
 81            else
 82            ...{
 83                this._exist=false;
 84            }
 85        }
 86
 87        /**//// <summary>
 88        /// 根据查询条件哈希表,查询数据
 89        /// </summary>
 90        /// <param name="queryItems">查询条件哈希表</param>
 91        /// <returns>查询结果数据DataTable</returns>
 92        public static DataTable Query(Hashtable queryItems)
 93        ...{
 94            string where=SqlStringConstructor.GetConditionClause(queryItems);
 95            string sql="Select * From [Category]"+where;
 96            Database db = new Database();
 97            return db.GetDataTable(sql);
 98        }
 99        #endregion 方法
100    }
101}
102