///// <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, "操作失败"); } } }