/// <summary>
/// 查询条件
/// </summary>
/// <param name="bSaleBll"></param>
/// <param name="list"></param>
private void SelectQModel(out EyouSoft.BLL.StatisticStructure.BSalesStatistics bSaleBll, out IList <EyouSoft.Model.StatisticStructure.MSalesStatistics> list)
{
//初始化条件
pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1);
//实例化销售统计BLL
bSaleBll = new EyouSoft.BLL.StatisticStructure.BSalesStatistics(SiteUserInfo);
//实例化销售统计Model
searchInfo = new EyouSoft.Model.StatisticStructure.MQuerySalesStatistics();
//实例化销售统计List
list = null;
//查询实体类赋值
searchInfo.CompanyId = CurrentUserCompanyID;
//排序方式
searchInfo.OrderIndex = 1;
//开始时间
searchInfo.LeaveDateStart = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("todate"));
txtToLeaveDate.Text = Utils.GetQueryStringValue("todate");
//结束时间
searchInfo.LeaveDateEnd = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("endate"));
txtEndLeaveDate.Text = Utils.GetQueryStringValue("endate");
//线路区域
int[] areaIds = Utils.GetIntArray(Utils.GetQueryStringValue("ddlLineType"), ",");
searchInfo.AreaIds = areaIds;
searchInfo.CityIds = Utils.GetIntArray(Utils.GetQueryStringValue("cityId"), ",");
searchInfo.ProvinceIds = Utils.GetIntArray(Utils.GetQueryStringValue("province"), ",");
//组团社Id
searchInfo.CustomerId = Utils.GetInt(Utils.GetQueryStringValue("hd_teamId"));
//searchInfo.CustomerName = Utils.GetQueryStringValue("hd_teamName");
hd_teamId = Utils.GetQueryStringValue("hd_teamId");
txt_teamName = Utils.GetQueryStringValue("hd_teamName");
//计调员
int[] jdy = Utils.GetIntArray(Utils.GetQueryStringValue("jdyId"), ",");
searchInfo.LogisticIds = jdy;
//销售员
int[] xsy = Utils.GetIntArray(Utils.GetQueryStringValue("xsyId"), ",");
searchInfo.SalesClerkIds = xsy;
//操作员
int[] czy = Utils.GetIntArray(Utils.GetQueryStringValue("czyId"), ",");
searchInfo.OperatorId = czy;
selectOperator1.OperId = Utils.GetQueryStringValue("jdyId");
selectOperator1.OperName = Utils.GetQueryStringValue("jdyName");
selectOperator2.OperId = Utils.GetQueryStringValue("xsyId");
selectOperator2.OperName = Utils.GetQueryStringValue("xsyName");
EyouSoft.BLL.CompanyStructure.CompanySetting csBLL = new EyouSoft.BLL.CompanyStructure.CompanySetting();
EyouSoft.Model.EnumType.CompanyStructure.ComputeOrderType?cot = csBLL.GetComputeOrderType(SiteUserInfo.CompanyID);
searchInfo.ComputeOrderType = cot.HasValue ? cot.Value : EyouSoft.Model.EnumType.CompanyStructure.ComputeOrderType.统计有效订单;
searchInfo.ShangDanSDate = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("sdsdate"));
searchInfo.ShangDanEDate = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("sdedate"));
}
//列表初始化
protected void ListBind(DateTime?sDate, DateTime?eDate, int[] orderOperId, string orderLot, string tuanHao, string cusHao, string lineName, int[] operIds, bool?selSettle)
{
int companyID = SiteUserInfo.CompanyID;
EyouSoft.BLL.CompanyStructure.CompanySetting csBll = new EyouSoft.BLL.CompanyStructure.CompanySetting();
EyouSoft.Model.EnumType.CompanyStructure.ComputeOrderType?OrderTypeModel = csBll.GetComputeOrderType(companyID);
EyouSoft.Model.TourStructure.OrderCenterSearchInfo queryModel = new EyouSoft.Model.TourStructure.OrderCenterSearchInfo();
//根据条件搜索相关条件
EyouSoft.BLL.TourStructure.TourOrder TourOrderBll = new EyouSoft.BLL.TourStructure.TourOrder(SiteUserInfo);
EyouSoft.Model.TourStructure.SalerSearchInfo searchModel = new EyouSoft.Model.TourStructure.SalerSearchInfo();
if (searchModel.ComputeOrderType == OrderTypeModel.Value)
{
searchModel.ComputeOrderType = EyouSoft.Model.EnumType.CompanyStructure.ComputeOrderType.统计确认成交订单;
}
searchModel.SDate = sDate;
searchModel.EDate = eDate;
searchModel.OrderOperatorId = orderOperId;
searchModel.CompanyName = cusHao;
searchModel.OrderNo = orderLot;
searchModel.TourNo = tuanHao;
searchModel.RouteName = lineName;
searchModel.SalerId = operIds;
searchModel.ComputeOrderType = OrderTypeModel;
searchModel.IsSettle = selSettle;
System.Collections.Generic.IList <EyouSoft.Model.TourStructure.TourOrder> Ilist = TourOrderBll.GetOrderList(pageSize, pageIndex, ref recordCount, CurrentUserCompanyID, searchModel);
if (Ilist != null && Ilist.Count > 0)
{
EyouSoft.Model.TourStructure.MSaleReceivableSummaryInfo Summaryinfo = new EyouSoft.BLL.TourStructure.TourOrder(SiteUserInfo).GetSaleReceivableSummary(SiteUserInfo.CompanyID, searchModel);
//合同金额汇总
this.LitFinanceSum.Text = Summaryinfo.TotalAmount.ToString("c2");
//人数统计
this.LitPeopleCount.Text = Summaryinfo.PeopleNumber.ToString();
//已收金额
this.LitHasCheckMoney.Text = Summaryinfo.ReceivedAmount.ToString("c2");
//已收待审核金额
this.LitNotCheckMoney.Text = Summaryinfo.UnauditedAmount.ToString("c2");
//未收金额
this.LitNotReceived.Text = Summaryinfo.NotReceivedAmount.ToString("c2");
repList.DataSource = Ilist;
repList.DataBind();
}
else
{
this.ExporPageInfoSelect1.Visible = false;
this.repList.EmptyText = "<tr><td height='30px' bgcolor='#e3f1fc' colspan='14' align='center'>暂时没有数据！</td></tr>";
}
TourOrderBll = null;
searchModel = null;
BindPage();
}