2.8使用EntityBase

2.8使用EntityBase

 

 

 

返回单个实例对象

/// <summary> /// 按指定的名字返回城市对象 /// </summary> /// <param name="cityName"></param> /// <returns></returns> [System.ComponentModel.DataObjectMethod(System.ComponentModel.DataObjectMethodType.Select, false)] public static City SelectByName(string cityName) {     DataProviders.IDataProvider provider = CreateDataProvider();     provider.SQL = "SELECT CityID as [Identity],Name,PostalCode,DistanceCode,Province,Longitude,Latitude,Version " +                     "FROM lt_dictionary.City WHERE Name=@name";     provider.AddParameters("@name", cityName);     return CreateInstance(provider.ExecuteDataTable()); }

 

 

返回集合对象

/// <summary> /// 返回所有禁用状态的城市信息 /// </summary> /// <returns></returns> [System.ComponentModel.DataObjectMethod(System.ComponentModel.DataObjectMethodType.Select, false)] public static List<City> SelectIsDisabled() {     DataProviders.IDataProvider provider = CreateDataProvider();     provider.SQL = "SELECT CityID as [Identity],Name,PostalCode,DistanceCode,Province,Longitude,Latitude,Version " +                     "FROM lt_dictionary.City WHERE Enable=0";     //返回List<City>     return CreateInstances(provider.ExecuteDataTable()); }