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