/// <summary>
/// 团队订单-运营后台
/// </summary>
/// <param name="pageSize">每页显示记录数</param>
/// <param name="pageCurrent">当前页</param>
/// <param name="recordCount">总记录数</param>
/// <param name="search">搜索实体</param>
/// <returns>团队订单集合</returns>
public IList <EyouSoft.Model.NewTourStructure.MTourList> GetList(int pageSize, int pageCurrent, ref int recordCount, EyouSoft.Model.NewTourStructure.MTourListSearch search)
{
return(dal.GetList(pageSize, pageCurrent, ref recordCount, search));
}
/// <summary>
/// 团队订单(组团社)
/// </summary>
/// <param name="pageSize">每页显示记录数</param>
/// <param name="pageCurrent">当前页</param>
/// <param name="recordCount">总记录数</param>
/// <param name="companyId">公司编号</param>
/// <param name="search">搜索实体</param>
/// <returns>团队订单集合</returns>
public IList <EyouSoft.Model.NewTourStructure.MTourList> GetList(int pageSize, int pageCurrent, ref int recordCount, string companyId, EyouSoft.Model.NewTourStructure.MTourListSearch search)
{
IList <MTourList> list = new List <MTourList>();
string tableName = "tbl_NewTourList";
string fields = "*,(select StartCityName,DayNum,LateNum from tbl_NewRouteBasicInfo where RouteId=tbl_NewTourList.RouteId for xml raw,root) as RouteInfo,(select CompanyName from tbl_CompanyInfo where Id=tbl_NewTourList.Business) as BusinessName,(select CompanyType from tbl_CompanyInfo where Id=tbl_NewTourList.Business) as CompanyType";
string primaryKey = "TourId";
string orderByString = "IssueTime DESC ";
StringBuilder strWhere = new StringBuilder("1=1");
strWhere.AppendFormat(" and Travel='{0}'", companyId);
if (search != null)
{
if (search.SLeaveDate.HasValue)
{
strWhere.AppendFormat(" and datediff(day,'{0}',StartDate)>=0", search.SLeaveDate);
}
if (search.ELeaveDate.HasValue)
{
strWhere.AppendFormat(" and datediff(day,'{0}',StartDate)<=0", search.ELeaveDate);
}
if (search.TourOrderStatus != null)
{
strWhere.AppendFormat(" and OrderStatus={0}", (int)search.TourOrderStatus);
}
if (search.OrderStatus != null && search.OrderStatus.Length > 0)
{
if (search.OrderStatus.Length == 1 && search.OrderStatus[0].HasValue)
{
strWhere.AppendFormat(" and OrderStatus={0}", (int)search.OrderStatus[0].Value);
}
else
{
string strIds = string.Empty;
foreach (var t in search.OrderStatus)
{
if (!t.HasValue)
{
continue;
}
strIds += (int)t.Value + ",";
}
strIds = strIds.TrimEnd(',');
if (!string.IsNullOrEmpty(strIds))
{
strWhere.AppendFormat(" and OrderStatus in ({0}) ", strIds);
}
}
}
if (!string.IsNullOrEmpty(search.TourKey))
{
strWhere.AppendFormat(" and (RouteName like '%{0}%' or VisitorContact like '%{0}%' or exists(select 1 from tbl_CompanyInfo where Id=tbl_NewTourList.Business and CompanyName like '%{0}%'))", search.TourKey.Trim());
}
if (search.AreaType != null)
{
strWhere.AppendFormat(" and exists(select 1 from tbl_NewRouteBasicInfo where RouteId=tbl_NewTourList.RouteId and RouteType={0})", (int)search.AreaType);
}
}
using (IDataReader rdr = DbHelper.ExecuteReader(this._db, pageSize, pageCurrent, ref recordCount, tableName, primaryKey, fields, strWhere.ToString(), orderByString))
{
while (rdr.Read())
{
MTourList model = new MTourList();
model.TourId = rdr.IsDBNull(rdr.GetOrdinal("TourId")) ? "" : rdr.GetString(rdr.GetOrdinal("TourId"));
model.OrderNo = rdr.IsDBNull(rdr.GetOrdinal("OrderNo")) ? "" : rdr.GetString(rdr.GetOrdinal("OrderNo"));
model.TourNo = rdr.IsDBNull(rdr.GetOrdinal("TourNo")) ? "" : rdr.GetString(rdr.GetOrdinal("TourNo"));
model.RouteId = rdr.IsDBNull(rdr.GetOrdinal("RouteId")) ? "" : rdr.GetString(rdr.GetOrdinal("RouteId"));
model.RouteName = rdr.IsDBNull(rdr.GetOrdinal("RouteName")) ? "" : rdr.GetString(rdr.GetOrdinal("RouteName"));
model.StartDate = rdr.IsDBNull(rdr.GetOrdinal("StartDate")) ? DateTime.MinValue : rdr.GetDateTime(rdr.GetOrdinal("StartDate"));
model.Business = rdr.IsDBNull(rdr.GetOrdinal("Business")) ? "" : rdr.GetString(rdr.GetOrdinal("Business"));
model.SLeaveDate = rdr.IsDBNull(rdr.GetOrdinal("LeaveDate")) ? "" : rdr.GetString(rdr.GetOrdinal("LeaveDate"));
model.ComeBackDate = rdr.IsDBNull(rdr.GetOrdinal("ComeBackDate")) ? "" : rdr.GetString(rdr.GetOrdinal("ComeBackDate"));
model.TravelContact = rdr.IsDBNull(rdr.GetOrdinal("TravelContact")) ? "" : rdr.GetString(rdr.GetOrdinal("TravelContact"));
model.TravelTel = rdr.IsDBNull(rdr.GetOrdinal("TravelTel")) ? "" : rdr.GetString(rdr.GetOrdinal("TravelTel"));
model.VisitorContact = rdr.IsDBNull(rdr.GetOrdinal("VisitorContact")) ? "" : rdr.GetString(rdr.GetOrdinal("VisitorContact"));
model.VisitorTel = rdr.IsDBNull(rdr.GetOrdinal("VisitorTel")) ? "" : rdr.GetString(rdr.GetOrdinal("VisitorTel"));
model.ScheduleNum = rdr.IsDBNull(rdr.GetOrdinal("ScheduleNum")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("ScheduleNum"));
model.AdultNum = rdr.IsDBNull(rdr.GetOrdinal("AdultNum")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("AdultNum"));
model.ChildrenNum = rdr.IsDBNull(rdr.GetOrdinal("ChildrenNum")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("ChildrenNum"));
model.SingleRoomNum = rdr.IsDBNull(rdr.GetOrdinal("SingleRoomNum")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("SingleRoomNum"));
model.VisitorNotes = rdr.IsDBNull(rdr.GetOrdinal("VisitorNotes")) ? "" : rdr.GetString(rdr.GetOrdinal("VisitorNotes"));
model.TravelNotes = rdr.IsDBNull(rdr.GetOrdinal("TravelNotes")) ? "" : rdr.GetString(rdr.GetOrdinal("TravelNotes"));
model.BusinessNotes = rdr.IsDBNull(rdr.GetOrdinal("BusinessNotes")) ? "" : rdr.GetString(rdr.GetOrdinal("BusinessNotes"));
model.IssueTime = rdr.IsDBNull(rdr.GetOrdinal("IssueTime")) ? DateTime.MinValue : rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
model.OrderStatus = (TourOrderStatus)rdr.GetByte(rdr.GetOrdinal("OrderStatus"));
model.TourStatus = (TourStatus)rdr.GetByte(rdr.GetOrdinal("TourStatus"));
model.OperatorId = rdr.IsDBNull(rdr.GetOrdinal("OperatorId")) ? "" : rdr.GetString(rdr.GetOrdinal("OperatorId"));
model.TourPrice = rdr.IsDBNull(rdr.GetOrdinal("TourPrice")) ? 0 : rdr.GetDecimal(rdr.GetOrdinal("TourPrice"));
model.Travel = rdr.IsDBNull(rdr.GetOrdinal("Travel")) ? "" : rdr.GetString(rdr.GetOrdinal("Travel"));
model.DayNum = rdr.IsDBNull(rdr.GetOrdinal("RouteInfo")) ? 0 : Utility.GetInt(GetValueByXml(rdr.GetString(rdr.GetOrdinal("RouteInfo")), "DayNum"));
model.LateNum = rdr.IsDBNull(rdr.GetOrdinal("RouteInfo")) ? 0 : Utility.GetInt(GetValueByXml(rdr.GetString(rdr.GetOrdinal("RouteInfo")), "LateNum"));
model.StartCityName = rdr.IsDBNull(rdr.GetOrdinal("RouteInfo")) ? "" : GetValueByXml(rdr.GetString(rdr.GetOrdinal("RouteInfo")), "StartCityName");
model.BusinessName = rdr.IsDBNull(rdr.GetOrdinal("BusinessName")) ? "" : rdr.GetString(rdr.GetOrdinal("BusinessName"));
model.CompanyType = (CompanyType)Enum.Parse(typeof(CompanyType), rdr["CompanyType"].ToString());
list.Add(model);
}
}
return(list);
}
/// <summary>
/// 团队订单(组团社)
/// </summary>
/// <param name="pageSize">每页显示记录数</param>
/// <param name="pageCurrent">当前页</param>
/// <param name="recordCount">总记录数</param>
/// <param name="companyId">公司编号</param>
/// <param name="search">搜索实体</param>
/// <returns>团队订单集合</returns>
public IList <EyouSoft.Model.NewTourStructure.MTourList> GetZTList(int pageSize, int pageCurrent, ref int recordCount, string companyId, EyouSoft.Model.NewTourStructure.MTourListSearch search)
{
if (!string.IsNullOrEmpty(companyId))
{
return(dal.GetList(pageSize, pageCurrent, ref recordCount, companyId, search));
}
else
{
return(null);
}
}
