/// <summary> /// 外部订单详细表 /// </summary> /// <param name="paination">分页信息</param> /// <param name="view">查询条件</param> /// <param name="totalReceiveAmount">收款总额</param> /// <param name="totalPaymentAmount">付款总额</param> /// <param name="totalProfitAmount">利润总额</param> public static DataTable QueryPlatformExternalOrder(Pagination paination, PlatformExternalOrderView view, out decimal totalReceiveAmount, out decimal totalPaymentAmount, out decimal totalProfitAmount) { if (view == null) { throw new ArgumentNullException("view"); } var repository = Factory.CreateReportRepository(); return(repository.QueryPlatformExternalOrder(paination, view, out totalReceiveAmount, out totalPaymentAmount, out totalProfitAmount)); }
private PlatformExternalOrderView getCondition() { var view = new PlatformExternalOrderView(); if (!string.IsNullOrWhiteSpace(this.txtPayStartDate.Text)) { view.BeginPayTime = DateTime.Parse(this.txtPayStartDate.Text); } if (!string.IsNullOrWhiteSpace(this.txtPayEndDate.Text)) { view.EndPayTime = DateTime.Parse(this.txtPayEndDate.Text).AddDays(1).AddMilliseconds(-3); } if (!string.IsNullOrWhiteSpace(this.txtInternalOrderId.Text)) { view.OrderId = decimal.Parse(this.txtInternalOrderId.Text.Trim()); } if (!string.IsNullOrWhiteSpace(this.txtExternalOrderId.Text)) { view.ExternalOrderId = this.txtExternalOrderId.Text.Trim(); } if (!string.IsNullOrWhiteSpace(this.ddlAirlines.SelectedValue)) { view.Airline = this.ddlAirlines.SelectedValue; } if (!string.IsNullOrWhiteSpace(this.txtDeparture.Code)) { view.Departure = this.txtDeparture.Code; } if (!string.IsNullOrWhiteSpace(this.ddlPayStatus.SelectedValue)) { view.Payed = this.ddlPayStatus.SelectedValue == "1"; } if (!string.IsNullOrWhiteSpace(this.txtPnr.Text)) { view.PNR = this.txtPnr.Text; } if (!string.IsNullOrWhiteSpace(this.txtArrival.Code)) { view.Arrival = this.txtArrival.Code; } if (!string.IsNullOrWhiteSpace(this.ddlOrderSource.SelectedValue)) { view.OrderSource = (PlatformType)int.Parse(this.ddlOrderSource.SelectedValue); } if (!string.IsNullOrWhiteSpace(this.ddlPrintStatus.SelectedValue)) { view.ETDZStatus = short.Parse(this.ddlPrintStatus.SelectedValue); } return(view); }
/// <summary> /// 下载外部订单详细明细表 /// </summary> /// <param name="view">查询条件</param> public static DataTable DownloadPlatformExternalOrder(PlatformExternalOrderView view) { decimal totalRecieveAmount, totalPaymentAmount, totalProfitAmount; return(QueryPlatformExternalOrder(null, view, out totalRecieveAmount, out totalPaymentAmount, out totalProfitAmount)); }