/// <summary>
/// 获取所有的城市地理位置（地标）信息集合
/// </summary>
/// <param name="CityCode">城市三字码（空或null时，获取所有城市信息；不为空时，根据三字码获取相应城市的地理位置信息集合）</param>
/// <returns></returns>
public virtual IList <EyouSoft.Model.HotelStructure.HotelLandMarks> GetList(string CityCode)
{
IList <EyouSoft.Model.HotelStructure.HotelLandMarks> lists = null;
EyouSoft.Model.HotelStructure.HotelLandMarks model = null;
string StrSql = "SELECT [Id],[Por],[CityCode] FROM [dbo].[tbl_HotelLandMarks]";
if (!string.IsNullOrEmpty(CityCode))
{
CityCode = "%" + CityCode + "%";
StrSql = StrSql + " WHERE [CityCode] like @CityCode";
}
DbCommand dc = this._db.GetSqlStringCommand(StrSql);
if (!string.IsNullOrEmpty(CityCode))
{
this._db.AddInParameter(dc, "CityCode", DbType.AnsiString, CityCode);
}
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._db))
{
lists = new List <EyouSoft.Model.HotelStructure.HotelLandMarks>();
while (dr.Read())
{
model = new EyouSoft.Model.HotelStructure.HotelLandMarks();
model.CityCode = dr.GetString(dr.GetOrdinal("CityCode"));
model.Por = dr.GetString(dr.GetOrdinal("Por"));
model.Id = dr.GetInt32(dr.GetOrdinal("Id"));
lists.Add(model);
model = null;
}
}
return(lists);
}
/// <summary>
/// 获取酒店地理位置信息实体
/// </summary>
/// <param name="Id">地理位置主键Id</param>
/// <returns></returns>
public virtual EyouSoft.Model.HotelStructure.HotelLandMarks GetModel(int Id)
{
EyouSoft.Model.HotelStructure.HotelLandMarks model = null;
string StrSql = "SELECT [Id],[Por],[CityCode] FROM [dbo].[tbl_HotelLandMarks] WHERE [ID]=@ID";
DbCommand dc = this._db.GetSqlStringCommand(StrSql);
this._db.AddInParameter(dc, "ID", DbType.Int32, Id);
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._db))
{
while (dr.Read())
{
model = new EyouSoft.Model.HotelStructure.HotelLandMarks();
model.CityCode = dr.GetString(dr.GetOrdinal("CityCode"));
model.Por = dr.GetString(dr.GetOrdinal("Por"));
model.Id = dr.GetInt32(dr.GetOrdinal("Id"));
}
}
return(model);
}
