/// <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));
}
