/// <summary>
/// 获取实体
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public MNewHotelInfo GetModel(int id)
{
MNewHotelInfo model = null;
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat(SQL_SELECT_BYID, id);
DbCommand dc = this._db.GetSqlStringCommand(strSql.ToString());
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._db))
{
while (dr.Read())
{
model = new MNewHotelInfo();
model.Id = dr.GetInt32(dr.GetOrdinal("Id"));
model.OrderId = dr.GetInt32(dr.GetOrdinal("OrderId"));
model.HotelName = dr["HotelName"].ToString();
model.CityName = dr["CityName"].ToString();
model.CityAreaType = (CityAreaType)int.Parse(dr[dr.GetOrdinal("CityAreaType")].ToString());
model.HotelStar = (HotelStarType)int.Parse(dr[dr.GetOrdinal("HotelStar")].ToString());
model.QQ = dr["QQ"].ToString();
if (!dr.IsDBNull(dr.GetOrdinal("MenShiPrice")))
{
model.MenShiPrice = dr.GetDecimal(dr.GetOrdinal("MenShiPrice"));
}
if (!dr.IsDBNull(dr.GetOrdinal("TeamPrice")))
{
model.TeamPrice = dr.GetDecimal(dr.GetOrdinal("TeamPrice"));
}
model.OperateId = dr.GetInt32(dr.GetOrdinal("OperateId"));
model.OperateTime = dr.GetDateTime(dr.GetOrdinal("OperateTime"));
}
}
return(model);
}
/// <summary>
/// 修改实体信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(MNewHotelInfo model)
{
if (model == null)
{
return(false);
}
return(dal.Update(model));
}
/// <summary>
/// 添加实体信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(MNewHotelInfo model)
{
if (model == null)
{
return(false);
}
return(dal.Add(model));
}
/// <summary>
/// 获取首页显示的酒店信息
/// </summary>
/// <param name="cityAreaType">城市区域类型</param>
/// <param name="cityName">城市名称</param>
/// <param name="topNumber">个数</param>
/// <returns>IList</returns>
public IList <MNewHotelInfo> GetList(CityAreaType hotelType, string cityName, int topNumber)
{
IList <MNewHotelInfo> list = new List <MNewHotelInfo>();
MNewHotelInfo model = null;
StringBuilder strSql = new StringBuilder();
if (!string.IsNullOrEmpty(cityName))
{
strSql.AppendFormat(SQL_SELECT_BYTYPE, topNumber, (int)hotelType);
strSql.Append(string.Format(" and CityName = '{0}'", cityName));
}
else
{
if ((int)hotelType == 0)
{
strSql.AppendFormat(SQL_SELECT_HuaDong, topNumber, (int)hotelType);
}
if ((int)hotelType == 1)
{
strSql.AppendFormat(SQL_SELECT_GangAao, topNumber, (int)hotelType);
}
}
DbCommand dc = this._db.GetSqlStringCommand(strSql.ToString());
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._db))
{
while (dr.Read())
{
model = new MNewHotelInfo();
model.Id = dr.GetInt32(dr.GetOrdinal("Id"));
model.OrderId = dr.GetInt32(dr.GetOrdinal("OrderId"));
model.HotelName = dr["HotelName"].ToString();
model.CityName = dr["CityName"].ToString();
model.CityAreaType = (CityAreaType)int.Parse(dr[dr.GetOrdinal("CityAreaType")].ToString());
model.HotelStar = (HotelStarType)int.Parse(dr[dr.GetOrdinal("HotelStar")].ToString());
model.QQ = dr["QQ"].ToString();
if (!dr.IsDBNull(dr.GetOrdinal("MenShiPrice")))
{
model.MenShiPrice = dr.GetDecimal(dr.GetOrdinal("MenShiPrice"));
}
if (!dr.IsDBNull(dr.GetOrdinal("TeamPrice")))
{
model.TeamPrice = dr.GetDecimal(dr.GetOrdinal("TeamPrice"));
}
model.OperateId = dr.GetInt32(dr.GetOrdinal("OperateId"));
model.OperateTime = dr.GetDateTime(dr.GetOrdinal("OperateTime"));
list.Add(model);
model = null;
}
}
return(list);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(MNewHotelInfo model)
{
DbCommand dc = this._db.GetSqlStringCommand(SQL_INSERT);
this._db.AddInParameter(dc, "OrderId", DbType.Int32, GetNextOrderId());
this._db.AddInParameter(dc, "HotelName", DbType.String, model.HotelName);
this._db.AddInParameter(dc, "CityName", DbType.String, model.CityName);
this._db.AddInParameter(dc, "CityAreaType", DbType.Byte, (int)model.CityAreaType);
this._db.AddInParameter(dc, "HotelStar", DbType.Byte, (int)model.HotelStar);
this._db.AddInParameter(dc, "MenShiPrice", DbType.Decimal, model.MenShiPrice);
this._db.AddInParameter(dc, "TeamPrice", DbType.String, model.TeamPrice);
this._db.AddInParameter(dc, "QQ", DbType.Decimal, model.QQ);
this._db.AddInParameter(dc, "OperateId", DbType.Int32, (int)model.OperateId);
return(DbHelper.ExecuteSql(dc, this._db) > 0 ? true : false);
}
/// <summary>
/// 根据类别获取分页数据
/// </summary>
/// <param name="pageSize"></param>
/// <param name="pageIndex"></param>
/// <param name="recordCount"></param>
/// <param name="hotelType"></param>
/// <returns></returns>
public IList <MNewHotelInfo> GetList(int pageSize, int pageIndex, ref int recordCount)
{
IList <MNewHotelInfo> list = new List <MNewHotelInfo>();
MNewHotelInfo model = null;
string tableName = "tbl_NewHotelInfo";
string fields = "*";
string primaryKey = "ID";
string orderByString = "Id DESC";
string strWhere = "";//查询条件
using (IDataReader dr = DbHelper.ExecuteReader(this._db, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields, strWhere.ToString(), orderByString))
{
while (dr.Read())
{
model = new MNewHotelInfo();
model.Id = dr.GetInt32(dr.GetOrdinal("Id"));
model.OrderId = dr.GetInt32(dr.GetOrdinal("OrderId"));
model.HotelName = dr["HotelName"].ToString();
model.CityName = dr["CityName"].ToString();
model.CityAreaType = (CityAreaType)int.Parse(dr[dr.GetOrdinal("CityAreaType")].ToString());
model.HotelStar = (HotelStarType)int.Parse(dr[dr.GetOrdinal("HotelStar")].ToString());
model.QQ = dr["QQ"].ToString();
if (!dr.IsDBNull(dr.GetOrdinal("MenShiPrice")))
{
model.MenShiPrice = dr.GetDecimal(dr.GetOrdinal("MenShiPrice"));
}
if (!dr.IsDBNull(dr.GetOrdinal("TeamPrice")))
{
model.TeamPrice = dr.GetDecimal(dr.GetOrdinal("TeamPrice"));
}
model.OperateId = dr.GetInt32(dr.GetOrdinal("OperateId"));
model.OperateTime = dr.GetDateTime(dr.GetOrdinal("OperateTime"));
list.Add(model);
model = null;
}
}
return(list);
}
