///// <summary>
/////
///// </summary>
///// <param name="id"></param>
///// <returns></returns>
//public virtual bool SetTop(string id)
//{
//}
#endregion
#region Private Methods
/// <summary>
/// 给酒店信息板块model赋值
/// </summary>
/// <param name="model">酒店首页信息板块实体</param>
/// <param name="dr">IDataReader</param>
private void InputModelValue(EyouSoft.Model.HotelStructure.HotelLocalInfo model, IDataReader dr)
{
model.CityCode = dr.IsDBNull(dr.GetOrdinal("CityCode")) ? "" : dr.GetString(dr.GetOrdinal("CityCode"));
model.HotelCode = dr.GetString(dr.GetOrdinal("HotelCode"));
model.HotelImg = dr.IsDBNull(dr.GetOrdinal("HotelImg")) ? "" : dr.GetString(dr.GetOrdinal("HotelImg"));
model.HotelName = dr.GetString(dr.GetOrdinal("HotelName"));
model.Id = dr.GetString(dr.GetOrdinal("Id"));
model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime"));
model.IsTop = dr.GetString(dr.GetOrdinal("IsTop")) == "0" ? false : true;
model.MarketingPrice = dr.GetDecimal(dr.GetOrdinal("MarketingPrice"));
model.Rank = (EyouSoft.HotelBI.HotelRankEnum)Enum.Parse(typeof(EyouSoft.HotelBI.HotelRankEnum), dr.GetByte(dr.GetOrdinal("Rank")).ToString());
model.ShortDesc = dr.IsDBNull(dr.GetOrdinal("ShortDesc")) ? "" : dr.GetString(dr.GetOrdinal("ShortDesc"));
model.ShowType = (EyouSoft.Model.HotelStructure.HotelShowType)Enum.Parse(typeof(EyouSoft.Model.HotelStructure.HotelShowType), dr.GetByte(dr.GetOrdinal("ShowType")).ToString());
model.SortId = dr.GetInt32(dr.GetOrdinal("SortId"));
}
/// <summary>
/// 获取酒店系统-首页酒店板块信息实体
/// </summary>
/// <param name="Id">首页酒店板块信息主键Id</param>
/// <returns></returns>
public virtual EyouSoft.Model.HotelStructure.HotelLocalInfo GetModel(string Id)
{
EyouSoft.Model.HotelStructure.HotelLocalInfo model = null;
DbCommand dc = this._db.GetSqlStringCommand(Sql_Model_LocalHotelInfo);
this._db.AddInParameter(dc, "ID", DbType.AnsiStringFixedLength, Id);
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._db))
{
while (dr.Read())
{
model = new EyouSoft.Model.HotelStructure.HotelLocalInfo();
InputModelValue(model, dr);
}
}
return(model);
}
/// <summary>
/// 根据类型获取酒店系统的首页酒店板块信息集合
/// </summary>
/// <param name="type">类型</param>
/// <param name="CityCode">城市三字码(为空时，不做条件)</param>
/// <param name="topNum">数据条数 0:获取所有</param>
/// <returns></returns>
public virtual IList <EyouSoft.Model.HotelStructure.HotelLocalInfo> GetList(EyouSoft.Model.HotelStructure.HotelShowType type, string CityCode, int topNum)
{
IList <EyouSoft.Model.HotelStructure.HotelLocalInfo> lists = null;
EyouSoft.Model.HotelStructure.HotelLocalInfo model = null;
string StrSql = string.Empty;
if (topNum > 0)
{
StrSql = string.Format("SELECT TOP {0} [ID],[HotelCode],[HotelName],[ShortDesc],[Rank],[MarketingPrice],[CityCode],[HotelImg],[ShowType],[SortId],[IsTop] ,[IssueTime] FROM [dbo].[tbl_HotelLocalInfo] WHERE [ShowType]={1} ", topNum, (int)type);
}
else
{
StrSql = string.Format("SELECT [ID],[HotelCode],[HotelName],[ShortDesc],[Rank],[MarketingPrice],[CityCode],[HotelImg],[ShowType],[SortId],[IsTop] ,[IssueTime] FROM [dbo].[tbl_HotelLocalInfo] WHERE [ShowType]={0} ", (int)type);
}
if (!string.IsNullOrEmpty(CityCode))
{
StrSql = StrSql + " AND [CityCode]=@CityCode";
}
StrSql = StrSql + " ORDER BY [IsTop] DESC,[SortId] DESC,IssueTime DESC";
DbCommand dc = this._db.GetSqlStringCommand(StrSql);
this._db.AddInParameter(dc, "ShowType", DbType.Byte, (int)type);
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.HotelLocalInfo>();
while (dr.Read())
{
model = new EyouSoft.Model.HotelStructure.HotelLocalInfo();
InputModelValue(model, dr);
lists.Add(model);
model = null;
}
}
return(lists);
}
/// <summary>
/// 根据类型获取所有的酒店信息集合(分页)
/// </summary>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="RecordCount"></param>
/// <param name="type">类型</param>
/// <returns></returns>
public virtual IList <EyouSoft.Model.HotelStructure.HotelLocalInfo> GetList(int PageSize, int PageIndex, ref int RecordCount, EyouSoft.Model.HotelStructure.HotelShowType type)
{
IList <EyouSoft.Model.HotelStructure.HotelLocalInfo> lists = null;
string StrTableName = "tbl_HotelLocalInfo";
string StrFiledName = " [ID],[HotelCode],[HotelName],[ShortDesc],[Rank],[MarketingPrice],[CityCode],[HotelImg],[ShowType],[SortId],[IsTop] ,[IssueTime] ";
string StrWhereQuery = string.Format("[ShowType]='{0}' ", (int)type);
string StrOrderBy = " IsTop,IssueTime DESC";
#region List赋值
using (IDataReader dr = DbHelper.ExecuteReader(this._db, PageSize, PageIndex, ref RecordCount, StrTableName, "ID", StrFiledName, StrWhereQuery, StrOrderBy))
{
lists = new List <EyouSoft.Model.HotelStructure.HotelLocalInfo>();
EyouSoft.Model.HotelStructure.HotelLocalInfo model = null;
while (dr.Read())
{
model = new EyouSoft.Model.HotelStructure.HotelLocalInfo();
InputModelValue(model, dr);
lists.Add(model);
model = null;
}
}
#endregion
return(lists);
}
/// <summary>
/// 添加，删除操作
/// </summary>
/// <param name="mothedType">操作类型（add,delete）</param>
private void OpearMothed(string mothedType)
{
string[] HotelCodesOrId = StringValidate.Split(Utils.GetFormValue("HotelCodes"), ","); //接口酒店Code,或者本地酒店ID
if (mothedType == "add")
{
int HotelShowType = Utils.GetInt(Request.Form["HotelShowType"], 0);
string Interjson = Server.HtmlDecode(Utils.GetFormValue("InterList")); //获取接口列表数据
if (string.IsNullOrEmpty(Interjson))
{
Utils.ResponseMeg(false, "请重新查询数据，再进行添加！");
return;
}
EyouSoft.Model.HotelStructure.HotelLocalInfo hotelLocal = null; //本地酒店实体
IList <EyouSoft.Model.HotelStructure.HotelLocalInfo> list = new List <EyouSoft.Model.HotelStructure.HotelLocalInfo>();
string topcodes = Utils.GetFormValue("HotelTopCodes");
string[] SetTopCodes = string.IsNullOrEmpty(topcodes) == true?null: StringValidate.Split(topcodes, ","); //置顶的酒店Code
IList <EyouSoft.Model.HotelStructure.HotelInfo> interList = JsonConvert.DeserializeObject <IList <EyouSoft.Model.HotelStructure.HotelInfo> >(Interjson); //将json序列化为集合对象
foreach (string item in HotelCodesOrId)
{
EyouSoft.Model.HotelStructure.HotelInfo hodelinfo = null;
foreach (EyouSoft.Model.HotelStructure.HotelInfo interitem in interList)
{
if (interitem == null)
{
continue;
}
if (interitem.HotelCode == item)
{
hodelinfo = interitem;
break;
}
}
if (hodelinfo != null) //将接口Hotel值赋给HotelLocal实体
{
hotelLocal = new EyouSoft.Model.HotelStructure.HotelLocalInfo();
hotelLocal.HotelCode = hodelinfo.HotelCode;
hotelLocal.HotelName = hodelinfo.HotelName;
hotelLocal.IssueTime = DateTime.Now;
hotelLocal.MarketingPrice = hodelinfo.MinRate; //暂定
if (hodelinfo.HotelImages != null && hodelinfo.HotelImages.Count > 0)
{
hotelLocal.HotelImg = hodelinfo.HotelImages[0].ImageURL;
}
hotelLocal.Rank = hodelinfo.Rank;
hotelLocal.ShortDesc = hodelinfo.ShortDesc;
hotelLocal.ShowType = (EyouSoft.Model.HotelStructure.HotelShowType)HotelShowType;
hotelLocal.CityCode = hodelinfo.CityCode;
if (SetTopCodes != null && SetTopCodes.Length > 0) //判断是否选中置顶
{
for (int i = 0; i < SetTopCodes.Length; i++)
{
if (item == SetTopCodes[i])
{
hotelLocal.IsTop = true;
}
}
}
list.Add(hotelLocal);
hodelinfo = null;
}
}
int row = EyouSoft.BLL.HotelStructure.HotelLocalInfo.CreateInstance().Add(list); //添加操作结果
if (row == 0)
{
Utils.ResponseMeg(false, "该酒店数据已经存在");
}
else if (row < list.Count)
{
Utils.ResponseMeg(false, "部分酒店已经存在，其它的添加成功");
}
else
{
Utils.ResponseMeg(true, "操作成功");
}
list = null;
}
if (mothedType == "delete") //删除本地数据
{
if (EyouSoft.BLL.HotelStructure.HotelLocalInfo.CreateInstance().Delete(HotelCodesOrId) > 0)
{
Utils.ResponseMeg(true, "操作成功");
}
else
{
Utils.ResponseMeg(true, "操作失败");
}
}
}
