//private static List<OrderSearchResponse> List = new List<OrderSearchResponse>(); /// <summary> /// 订单列表 /// </summary> public static BasePageResponse <OrderSearchResponse> GetOrderList(OrderSearchRequset request) { var response = new BasePageResponse <OrderSearchResponse>(); StringBuilder sb = new StringBuilder(); sb.Append(@"SELECT Id, HOCustomerSerialId, HOSupplierSourceName, HIId, HName, HOCheckInDate, HOCheckOutDate, HOLinkerName, HOStatus, HOSellPrice, HOContractPrice FROM Ho_HotelOrder WHERE 1 = 1"); //订单号 if (!string.IsNullOrWhiteSpace(request.HOCustomerSerialId)) { sb.AppendFormat(" AND HOCustomerSerialId Like '%{0}%'", request.HOCustomerSerialId); } //人员归属查询 if (!string.IsNullOrWhiteSpace(request.PeopleMobile) || !string.IsNullOrWhiteSpace(request.PeopleName)) { if (request.CustomerType == 1) { sb.AppendFormat(" AND HOCustomerName Like '%{0}%' AND HOCustomerMobile = '{1}'", request.PeopleName, request.PeopleMobile); } else { sb.AppendFormat(" AND HOLinkerName Like '%{0}%' AND HOLinkerMobile = '{1}'", request.PeopleName, request.PeopleMobile); } } //时间 if (!string.IsNullOrWhiteSpace(request.StartTime) || !string.IsNullOrWhiteSpace(request.EndTime)) { if (request.TimeType == 1) { sb.AppendFormat(" AND HOCheckInDate >= '{0}' AND HOCheckInDate<'{0}'", request.StartTime, Convert.ToDateTime(request.EndTime).AddDays(1).ToShortDateString()); } else { sb.AppendFormat(" AND HOAddTime >= '{0}' AND HOAddTime<'{0}'", request.StartTime, Convert.ToDateTime(request.EndTime).AddDays(1).ToShortDateString()); } } //来源 if (request.SourceId > 0) { sb.AppendFormat(" AND HOSupplierSourceId = {0}", request.SourceId); } //酒店名称 if (!string.IsNullOrWhiteSpace(request.HotelName)) { sb.AppendFormat(" AND HName Like '%{0}%'", request.HotelName); } //酒店Id if (!string.IsNullOrWhiteSpace(request.HIId)) { sb.AppendFormat(" AND HIId = '{0}'", request.HIId); } //第三方流水 if (!string.IsNullOrWhiteSpace(request.HOOutSerialId)) { sb.AppendFormat(" AND HOOutSerialId = '{0}'", request.HOOutSerialId); } //订单状态 if (request.HOStatus != null) { string state = ""; foreach (var item in state) { state += "'" + item + "',"; } sb.AppendFormat(" AND HOStatus IN ({0})", state.Substring(0, state.Length - 1)); } var list = MysqlHelper.GetList <OrderSearchResponse>(sb.ToString()); var total = list?.Count ?? 0; if (total > 0) { response.IsSuccess = 1; response.Total = total; response.List = list.Skip((request.PageIndex - 1) * request.PageSize).Take(request.PageSize)?.ToList(); } return(response); }
/// <summary> /// 订单列表 /// </summary> /// <param name="request"></param> /// <returns></returns> public static BasePageResponse <OrderSearchResponse> GetOrderList(OrderSearchRequset request) { return(Ho_HotelOrderAccess.GetOrderList(request)); }