/// <summary> /// 获取团队定制列表 /// </summary> /// <param name="PageSize">每页显示条数</param> /// <param name="PageIndex">当前页码</param> /// <param name="RecordCount">总记录数</param> /// <param name="SearchInfo">团队定制查询实体</param> /// <returns>团队定制列表</returns> public IList <EyouSoft.Model.HotelStructure.HotelTourCustoms> GetList(int PageSize, int PageIndex, ref int RecordCount, EyouSoft.Model.HotelStructure.SearchTourCustomsInfo SearchInfo) { IList <EyouSoft.Model.HotelStructure.HotelTourCustoms> list = new List <EyouSoft.Model.HotelStructure.HotelTourCustoms>(); string tableName = "tbl_HotelTourCustoms"; string fields = @" Id,CompanyId,HotelCode,HotelName,HotelStar,LiveStartDate,LiveEndDate,RoomCount,PeopleCount,Payment, IssueTime,TreatState,RoomAsk,OtherRemark,LocationAsk,GuestType,TourType,BudgetMin,BudgetMax, (select top 1 ContactName,ContactSex,ContactTel,ContactFax,ContactMobile,ContactEmail,QQ,MQ,MSN from tbl_CompanyUser where tbl_CompanyUser.CompanyId = tbl_HotelTourCustoms.CompanyId and IsDeleted = '0' and IsEnable = '1' and IsAdmin = '1' for xml raw,root('Root')) as Contact"; string orderByStr = " IssueTime DESC "; string PrimaryKey = "Id"; StringBuilder strWhere = new StringBuilder(" 1=1 "); if (SearchInfo != null) { if (!string.IsNullOrEmpty(SearchInfo.HotelCode)) { strWhere.AppendFormat(" and HotelCode='{0}' ", SearchInfo.HotelCode); } if (!string.IsNullOrEmpty(SearchInfo.HotelName)) { strWhere.AppendFormat(" and HotelName like '%{0}%' ", SearchInfo.HotelName); } if (SearchInfo.CheckInSDate.HasValue) { strWhere.AppendFormat(" and datediff(dd,'{0}',LiveStartDate) >= 0 ", SearchInfo.CheckInSDate.Value.ToString()); } if (SearchInfo.CheckInEDate.HasValue) { strWhere.AppendFormat(" and datediff(dd,'{0}',LiveStartDate) <= 0 ", SearchInfo.CheckInEDate.Value.ToString()); } if (SearchInfo.CheckOutSDate.HasValue) { strWhere.AppendFormat(" and datediff(dd,'{0}',LiveEndDate) >= 0 ", SearchInfo.CheckOutSDate.Value.ToString()); } if (SearchInfo.CheckOutEDate.HasValue) { strWhere.AppendFormat(" and datediff(dd,'{0}',LiveEndDate) <= 0 ", SearchInfo.CheckOutEDate.Value.ToString()); } if (!string.IsNullOrEmpty(SearchInfo.CompanyId)) { strWhere.AppendFormat(" and CompanyId = '{0}' ", SearchInfo.CompanyId); } } using (IDataReader dr = DbHelper.ExecuteReader(this._database, PageSize, PageIndex, ref RecordCount, tableName, PrimaryKey, fields, strWhere.ToString(), orderByStr)) { while (dr.Read()) { EyouSoft.Model.HotelStructure.HotelTourCustoms model = new EyouSoft.Model.HotelStructure.HotelTourCustoms(); model.Id = dr.GetInt32(dr.GetOrdinal("Id")); model.CompanyId = dr["CompanyId"].ToString(); model.HotelName = dr[dr.GetOrdinal("HotelName")].ToString(); if (!dr.IsDBNull(dr.GetOrdinal("HotelCode"))) { model.HotelCode = dr[dr.GetOrdinal("HotelCode")].ToString(); } if (!dr.IsDBNull(dr.GetOrdinal("LiveStartDate"))) { model.LiveStartDate = dr.GetDateTime(dr.GetOrdinal("LiveStartDate")); } if (!dr.IsDBNull(dr.GetOrdinal("LiveEndDate"))) { model.LiveEndDate = dr.GetDateTime(dr.GetOrdinal("LiveEndDate")); } model.RoomCount = dr.GetInt32(dr.GetOrdinal("RoomCount")); model.PeopleCount = dr.GetInt32(dr.GetOrdinal("PeopleCount")); if (!dr.IsDBNull(dr.GetOrdinal("Payment"))) { model.Payment = (EyouSoft.HotelBI.HBEPaymentType) int.Parse(dr[dr.GetOrdinal("Payment")].ToString()); } if (!dr.IsDBNull(dr.GetOrdinal("TreatState"))) { model.TreatState = (EyouSoft.Model.HotelStructure.OrderStateList) int.Parse(dr[dr.GetOrdinal("TreatState")].ToString()); } model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.RoomAsk = dr["RoomAsk"].ToString(); model.OtherRemark = dr["OtherRemark"].ToString(); model.LocationAsk = dr["LocationAsk"].ToString(); if (!dr.IsDBNull(dr.GetOrdinal("GuestType"))) { model.GuestType = (EyouSoft.HotelBI.HBEGuestTypeIndicator)dr.GetByte(dr.GetOrdinal("GuestType")); } if (!dr.IsDBNull(dr.GetOrdinal("TourType"))) { model.TourType = (EyouSoft.Model.HotelStructure.TourTypeList)dr.GetByte(dr.GetOrdinal("TourType")); } if (!dr.IsDBNull(dr.GetOrdinal("BudgetMin"))) { model.BudgetMin = dr.GetDecimal(dr.GetOrdinal("BudgetMin")); } if (!dr.IsDBNull(dr.GetOrdinal("BudgetMax"))) { model.BudgetMax = dr.GetDecimal(dr.GetOrdinal("BudgetMax")); } model.HotelStar = (EyouSoft.HotelBI.HotelRankEnum)dr.GetByte(dr.GetOrdinal("HotelStar")); #region 2011-12-20线路改版增加 if (!dr.IsDBNull(dr.GetOrdinal("Contact"))) { var xRoot = XElement.Parse(dr.GetString(dr.GetOrdinal("Contact"))); var xRows = Common.Utility.GetXElements(xRoot, "row"); if (xRows != null && xRows.Any()) { model.Contact = new Model.CompanyStructure.ContactPersonInfo(); foreach (var t in xRows) { if (t == null) { continue; } model.Contact.ContactName = Common.Utility.GetXAttributeValue(t, "ContactName"); model.Contact.ContactSex = (Model.CompanyStructure.Sex) Common.Utility.GetInt(Common.Utility.GetXAttributeValue(t, "ContactSex")); model.Contact.Tel = Common.Utility.GetXAttributeValue(t, "ContactTel"); model.Contact.Fax = Common.Utility.GetXAttributeValue(t, "ContactFax"); model.Contact.Mobile = Common.Utility.GetXAttributeValue(t, "ContactMobile"); model.Contact.Email = Common.Utility.GetXAttributeValue(t, "ContactEmail"); model.Contact.QQ = Common.Utility.GetXAttributeValue(t, "QQ"); model.Contact.MQ = Common.Utility.GetXAttributeValue(t, "MQ"); model.Contact.MSN = Common.Utility.GetXAttributeValue(t, "MSN"); } } } #endregion list.Add(model); model = null; } } return(list); }
/// <summary> /// 获取团队定制列表 /// </summary> /// <param name="PageSize">每页显示条数</param> /// <param name="PageIndex">当前页码</param> /// <param name="RecordCount">总记录数</param> /// <param name="SearchInfo">团队定制查询实体</param> /// <returns>团队定制列表</returns> public IList <EyouSoft.Model.HotelStructure.HotelTourCustoms> GetList(int PageSize, int PageIndex, ref int RecordCount, EyouSoft.Model.HotelStructure.SearchTourCustomsInfo SearchInfo) { return(dal.GetList(PageSize, PageIndex, ref RecordCount, SearchInfo)); }