/// <summary>
/// 导游收款 订单列表
/// </summary>
/// <param name="tourID">团号</param>
protected void GetOrderListBytourID(string tourID)
{
if (!string.IsNullOrEmpty(tourID))
{
EyouSoft.Model.TourStructure.MOrderSum sum = new EyouSoft.Model.TourStructure.MOrderSum();
IList <EyouSoft.Model.TourStructure.MTourOrder> orders = new EyouSoft.BLL.TourStructure.BTourOrder().GetTourOrderListById(ref sum, tourID);
if (orders != null && orders.Count > 0)
{
this.litsumPrices.Text = UtilsCommons.GetMoneyString(orders.Sum(p => p.GuideIncome), ProviderToMoney);
this.repGuidPayment.DataSource = orders;
this.repGuidPayment.DataBind();
}
else
{
this.tabGuidPaymentView.Visible = false;
}
}
}
/// <summary>
/// 获取某个团下面的订单数
/// </summary>
/// <param name="tourID">团号</param>
protected void BindOrderList(string tourID)
{
EyouSoft.Model.TourStructure.MOrderSum orders = new EyouSoft.Model.TourStructure.MOrderSum();
IList <EyouSoft.Model.TourStructure.MTourOrder> items = new EyouSoft.BLL.TourStructure.BTourOrder().GetTourOrderListById(tourID, ref orders);
if (items != null && items.Count > 0)
{
items = items.Where(c => c.OrderStatus == EyouSoft.Model.EnumType.TourStructure.OrderStatus.已成交).ToList();
}
if (items != null && items.Count > 0)
{
phEmptyDingDan.Visible = false;
repTourOrderList.DataSource = items;
repTourOrderList.DataBind();
}
else
{
phEmptyDingDan.Visible = true;
}
}
/// <summary>
/// 团款收入
/// </summary>
protected void DataInitTourPayIncome()
{
EyouSoft.Model.TourStructure.MOrderSum sumOrder = new EyouSoft.Model.TourStructure.MOrderSum();
IList <EyouSoft.Model.TourStructure.MTourOrder> tourlist = new EyouSoft.BLL.TourStructure.BTourOrder().GetTourOrderListById(TourId, ref sumOrder);
if (tourlist != null && tourlist.Count > 0)
{
var list = tourlist.Where(p => p.OrderStatus == EyouSoft.Model.EnumType.TourStructure.OrderStatus.已成交).ToList();
if (list != null && list.Count > 0)
{
this.repTourIncomList.DataSource = list;
this.repTourIncomList.DataBind();
this.litConfirmMoneyCount.Text = EyouSoft.Common.UtilsCommons.GetMoneyString(list.Sum(p => p.ConfirmMoney), ProviderToMoney);
this.litConfirmSettlementMoneyCount.Text = EyouSoft.Common.UtilsCommons.GetMoneyString(list.Sum(p => p.ConfirmSettlementMoney), ProviderToMoney);
this.litSalerIncomeCount.Text = EyouSoft.Common.UtilsCommons.GetMoneyString(list.Sum(p => p.GuideRealIncome), ProviderToMoney);
decimal finIncome = list.Sum(p => p.ConfirmMoney) - list.Sum(p => p.GuideRealIncome);
this.litCheckMoneyCount.Text = EyouSoft.Common.UtilsCommons.GetMoneyString(finIncome, ProviderToMoney);
this.litProfitCount.Text = EyouSoft.Common.UtilsCommons.GetMoneyString(list.Sum(p => p.Profit), ProviderToMoney);
//团队收入结算金额汇总
this.hidTourIncomCount = list.Sum(p => p.ConfirmSettlementMoney);
}
}
}
/// <summary>
/// 初始化
/// </summary>
private void DataInit()
{
//获取分页参数并强转
pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"));
string tourID = Utils.GetQueryStringValue("tourId");
EyouSoft.Model.TourStructure.MOrderSum sumOrder = new EyouSoft.Model.TourStructure.MOrderSum();
IList <EyouSoft.Model.TourStructure.MTourOrder> orderlist = new EyouSoft.BLL.TourStructure.BTourOrder().GetTourOrderListById(pageSize, pageIndex, tourID, ref recordCount, ref sumOrder);
if (orderlist != null && orderlist.Count > 0)
{
this.rptList.DataSource = orderlist;
this.rptList.DataBind();
BindPage();
}
else
{
this.lblMsg.Text = "没有相关数据!";
this.ExporPageInfoSelect1.Visible = false;
}
//绑定分页
BindPage();
}
/// <summary>
/// 初始化数据
/// </summary>
private void DataInit()
{
string b = Utils.GetQueryStringValue("mark");
switch (b)
{
case "1":
this.lblMsg.Text = "提交成功！";
break;
case "2":
this.lblMsg.Text = "提交失败！";
break;
case "3":
this.lblMsg.Text = "保存成功！";
break;
}
string tourId = Utils.GetQueryStringValue("tourId");
BPlan bll = new BPlan();
//团队支出
IList <MPlanBaseInfo> list = bll.GetList(tourId);
if (list != null && list.Count > 0)
{
rptList.DataSource = list;
rptList.DataBind();
this.litFrist.Text = " <span>类型</span> - <span>名称</span> - <span>结算费用</span>";
}
else
{
this.litFrist.Text = "暂无支出!";
}
//导游收入
EyouSoft.Model.TourStructure.MOrderSum sum = new EyouSoft.Model.TourStructure.MOrderSum();
IList <EyouSoft.Model.TourStructure.MTourOrder> orders = new EyouSoft.BLL.TourStructure.BTourOrder().GetTourOrderListById(ref sum, tourId);
if (orders != null && orders.Count > 0)
{
repGuidInMoney.DataSource = orders;
repGuidInMoney.DataBind();
this.litSecond.Text = " <span>客源单位</span> - <span>团款现收</span>";
}
else
{
this.litSecond.Text = "暂无收入!";
}
//导游借款
IList <MDebit> ls = new EyouSoft.BLL.FinStructure.BFinance().GetDebitLstByTourId(tourId, true);
if (ls != null && ls.Count > 0)
{
this.rptDebit.DataSource = ls;
this.rptDebit.DataBind();
this.litThird.Text = " <span>姓名</span> - <span>日期</span> - <span>金额</span>";
}
else
{
this.litThird.Text = "暂无借款!";
}
//报账汇总
MBZHZ model = bll.GetBZHZ(tourId);
if (model != null)
{
lbl_guidesIncome.Text = UtilsCommons.GetMoneyString(model.GuideIncome, ProviderToMoney);
lbl_guidesBorrower.Text = UtilsCommons.GetMoneyString(model.GuideBorrow, ProviderToMoney);
lbl_guidesSpending.Text = UtilsCommons.GetMoneyString(model.GuideOutlay, ProviderToMoney);
lbl_replacementOrReturn.Text = UtilsCommons.GetMoneyString(model.GuideMoneyRtn, ProviderToMoney);
}
}
/// <summary>
/// 初始化信息
/// </summary>
private void InitInfo()
{
string orderid = string.Empty;
EyouSoft.BLL.TourStructure.BTour bll = new EyouSoft.BLL.TourStructure.BTour();
EyouSoft.Model.TourStructure.MTourBaseInfo baseModel = bll.GetTourInfo(TourId);
if (baseModel == null)
{
RCWE("异常请求");
}
EyouSoft.Model.TourStructure.MTourTeamInfo teamModel = null;
EyouSoft.Model.TourStructure.MTourSanPinInfo sanpinModel = null;
switch (baseModel.TourType)
{
case EyouSoft.Model.EnumType.TourStructure.TourType.出境团队:
case EyouSoft.Model.EnumType.TourStructure.TourType.地接团队:
case EyouSoft.Model.EnumType.TourStructure.TourType.组团团队:
teamModel = (EyouSoft.Model.TourStructure.MTourTeamInfo)baseModel;
break;
case EyouSoft.Model.EnumType.TourStructure.TourType.单项服务:
this.TGuideNote.Visible = false;
this.TReceiveJourney.Visible = false;
this.TService.Visible = false;
this.ph_rpt_OrderinfoList.Visible = false;
return;
default:
sanpinModel = (EyouSoft.Model.TourStructure.MTourSanPinInfo)baseModel;
break;
}
#region 订单信息
EyouSoft.BLL.TourStructure.BTourOrder bllorder = new EyouSoft.BLL.TourStructure.BTourOrder();
EyouSoft.Model.TourStructure.MOrderSum ordersum = new EyouSoft.Model.TourStructure.MOrderSum();
IList <EyouSoft.Model.TourStructure.MTourOrder> MtourOrder = bllorder.GetTourOrderListById(TourId, ref ordersum).Where(c => c.OrderStatus == EyouSoft.Model.EnumType.TourStructure.OrderStatus.已成交).ToList();
if (MtourOrder != null && MtourOrder.Count > 0)
{
this.rpt_OrderinfoList.DataSource = MtourOrder;
this.rpt_OrderinfoList.DataBind();
}
else
{
this.ph_rpt_OrderinfoList.Visible = false;
}
#endregion
#region 团队信息
if (teamModel != null)
{
this.lbRouteName.Text = teamModel.RouteName;
this.lbTourCode.Text = teamModel.TourCode;
this.lbdayCount.Text = teamModel.TourDays.ToString();
this.lbstarttime.Text = UtilsCommons.GetDateString(teamModel.LDate, ProviderToDate);
this.lbendtime.Text = UtilsCommons.GetDateString(teamModel.RDate, ProviderToDate);
if (teamModel.GuideList != null && teamModel.GuideList.Count > 0)
{
string guidelist = string.Empty;
for (int i = 0; i < teamModel.GuideList.Count; i++)
{
if (i == teamModel.GuideList.Count - 1)
{
guidelist += teamModel.GuideList[i].Name;
}
else
{
guidelist += teamModel.GuideList[i].Name + "、";
}
}
this.lbguidename.Text = guidelist;
}
this.lbpeoplecount.Text = teamModel.PlanPeopleNumber.ToString();
if (teamModel.TourPlaner != null && teamModel.TourPlaner.Count > 0)
{
string planerlist = string.Empty;
for (int i = 0; i < teamModel.TourPlaner.Count; i++)
{
if (i == teamModel.TourPlaner.Count - 1)
{
planerlist += teamModel.TourPlaner[i].Planer;
}
else
{
planerlist += teamModel.TourPlaner[i].Planer + "、";
}
}
var jiDiaoInfo = new EyouSoft.BLL.ComStructure.BComUser().GetModel(teamModel.TourPlaner[0].PlanerId, CurrentUserCompanyID);
if (jiDiaoInfo != null)
{
planerlist += " " + jiDiaoInfo.ContactMobile + " " + jiDiaoInfo.ContactTel;
}
this.lbplander.Text = planerlist;
}
if (teamModel.SaleInfo != null)
{
var xiaoShouYuanInfo = new EyouSoft.BLL.ComStructure.BComUser().GetModel(teamModel.SaleInfo.SellerId, CurrentUserCompanyID);
if (xiaoShouYuanInfo != null)
{
teamModel.SaleInfo.Mobile = xiaoShouYuanInfo.ContactMobile;
teamModel.SaleInfo.Phone = xiaoShouYuanInfo.ContactTel;
}
this.lbsellerinfo.Text = teamModel.SaleInfo.Name + " " + teamModel.SaleInfo.Mobile + " " + teamModel.SaleInfo.Phone;
}
}
else if (sanpinModel != null)
{
this.lbRouteName.Text = baseModel.RouteName;
this.lbTourCode.Text = baseModel.TourCode;
this.lbdayCount.Text = baseModel.TourDays.ToString();
this.lbstarttime.Text = UtilsCommons.GetDateString(baseModel.LDate, ProviderToDate);
this.lbendtime.Text = UtilsCommons.GetDateString(baseModel.RDate, ProviderToDate);
if (baseModel.GuideList != null && baseModel.GuideList.Count > 0)
{
string guidelist = string.Empty;
for (int i = 0; i < baseModel.GuideList.Count; i++)
{
if (i == baseModel.GuideList.Count - 1)
{
guidelist += baseModel.GuideList[i].Name;
}
else
{
guidelist += baseModel.GuideList[i].Name + "、";
}
}
this.lbguidename.Text = guidelist;
}
this.lbpeoplecount.Text = baseModel.PlanPeopleNumber.ToString();
if (baseModel.TourPlaner != null && baseModel.TourPlaner.Count > 0)
{
string planerlist = string.Empty;
for (int i = 0; i < baseModel.TourPlaner.Count; i++)
{
if (i == baseModel.TourPlaner.Count - 1)
{
planerlist += baseModel.TourPlaner[i].Planer;
}
else
{
planerlist += baseModel.TourPlaner[i].Planer + "、";
}
}
var jiDiaoInfo = new EyouSoft.BLL.ComStructure.BComUser().GetModel(baseModel.TourPlaner[0].PlanerId, CurrentUserCompanyID);
if (jiDiaoInfo != null)
{
planerlist += " " + jiDiaoInfo.ContactMobile + " " + jiDiaoInfo.ContactTel;
}
this.lbplander.Text = planerlist;
}
if (baseModel.SaleInfo != null)
{
var xiaoShouYuanInfo = new EyouSoft.BLL.ComStructure.BComUser().GetModel(baseModel.SaleInfo.SellerId, CurrentUserCompanyID);
if (xiaoShouYuanInfo != null)
{
baseModel.SaleInfo.Mobile = xiaoShouYuanInfo.ContactMobile;
baseModel.SaleInfo.Phone = xiaoShouYuanInfo.ContactTel;
}
this.lbsellerinfo.Text = baseModel.SaleInfo.Name + " " + baseModel.SaleInfo.Mobile + " " + baseModel.SaleInfo.Phone;
}
}
else
{
return;
}
#endregion
#region 计调信息
EyouSoft.BLL.PlanStructure.BPlan bllPlan = new EyouSoft.BLL.PlanStructure.BPlan();
EyouSoft.Model.PlanStructure.MPlanBaseInfo planinfo = bllPlan.GetGuidePrint(TourId);
#region 导游安排接待行程
if (!string.IsNullOrEmpty(planinfo.ReceiveJourney))
{
TReceiveJourney.Visible = true;
this.lbReceiveJourney.Text = EyouSoft.Common.Function.StringValidate.TextToHtml(planinfo.ReceiveJourney);
}
else
{
TReceiveJourney.Visible = false;
}
#endregion
#region 导游安排服务标准
if (!string.IsNullOrEmpty(planinfo.ServiceStandard))
{
TService.Visible = true;
this.lbServiceStandard.Text = EyouSoft.Common.Function.StringValidate.TextToHtml(planinfo.ServiceStandard);
}
else
{
TService.Visible = false;
}
#endregion
#region 导游须知
if (!string.IsNullOrEmpty(planinfo.GuideNotes))
{
TGuideNote.Visible = true;
this.lbGuidNote.Text = EyouSoft.Common.Function.StringValidate.TextToHtml(planinfo.GuideNotes);
}
else
{
this.TGuideNote.Visible = false;
}
#endregion
#region 团队支付详单
#region 导游
IList <EyouSoft.Model.PlanStructure.MPlan> GuidePlanList = bllPlan.GetList(EyouSoft.Model.EnumType.PlanStructure.PlanProject.导游, null, null, false, null, TourId, PlanState.已落实);
GuidePlanList = GetZhiChus(GuidePlanList);
if (GuidePlanList != null && GuidePlanList.Count > 0)
{
this.guid = GuidePlanList.Count;
this.rpt_guid.DataSource = GuidePlanList;
this.rpt_guid.DataBind();
}
else
{
this.ph_guid.Visible = false;
}
#endregion
#region 地接
IList <EyouSoft.Model.PlanStructure.MPlan> groundPlanList = bllPlan.GetList(EyouSoft.Model.EnumType.PlanStructure.PlanProject.地接, null, null, false, null, TourId, PlanState.已落实);
groundPlanList = GetZhiChus(groundPlanList);
if (groundPlanList != null && groundPlanList.Count > 0)
{
this.dijie = groundPlanList.Count;
this.rpt_dijie.DataSource = groundPlanList;
this.rpt_dijie.DataBind();
}
else
{
this.ph_dijie.Visible = false;
}
#endregion
#region 飞机
IList <EyouSoft.Model.PlanStructure.MPlan> phanePlanList = bllPlan.GetList(EyouSoft.Model.EnumType.PlanStructure.PlanProject.飞机, null, null, false, null, TourId, PlanState.已落实);
phanePlanList = GetZhiChus(phanePlanList);
if (phanePlanList != null && phanePlanList.Count > 0)
{
this.plane = phanePlanList.Count;
this.rpt_plane.DataSource = phanePlanList;
this.rpt_plane.DataBind();
}
else
{
this.ph_plane.Visible = false;
}
#endregion
#region 购物
IList <EyouSoft.Model.PlanStructure.MPlan> shopPlanList = bllPlan.GetList(EyouSoft.Model.EnumType.PlanStructure.PlanProject.购物, null, null, false, null, TourId, PlanState.已落实);
shopPlanList = GetZhiChus(shopPlanList);
if (shopPlanList != null && shopPlanList.Count > 0)
{
this.gouwu = shopPlanList.Count;
this.rpt_gouwu.DataSource = shopPlanList;
this.rpt_gouwu.DataBind();
}
else
{
this.ph_gouwu.Visible = false;
}
#endregion
#region 国内游轮
IList <EyouSoft.Model.PlanStructure.MPlan> InshipPlanList = bllPlan.GetList(EyouSoft.Model.EnumType.PlanStructure.PlanProject.国内游轮, null, null, false, null, TourId, PlanState.已落实);
InshipPlanList = GetZhiChus(InshipPlanList);
if (InshipPlanList != null && InshipPlanList.Count > 0)
{
this.guoneichuan = InshipPlanList.Count;
this.rpt_guoneichuan.DataSource = InshipPlanList;
this.rpt_guoneichuan.DataBind();
}
else
{
this.ph_guoneichuan.Visible = false;
}
#endregion
#region 涉外游轮
IList <EyouSoft.Model.PlanStructure.MPlan> OutshipPlanList = bllPlan.GetList(EyouSoft.Model.EnumType.PlanStructure.PlanProject.涉外游轮, null, null, false, null, TourId, PlanState.已落实);
OutshipPlanList = GetZhiChus(OutshipPlanList);
if (OutshipPlanList != null && OutshipPlanList.Count > 0)
{
this.shewaichuan = OutshipPlanList.Count;
this.rpt_shewaichuan.DataSource = OutshipPlanList;
this.rpt_shewaichuan.DataBind();
}
else
{
this.ph_shewaichuan.Visible = false;
}
#endregion
#region 火车
IList <EyouSoft.Model.PlanStructure.MPlan> trainPlanList = bllPlan.GetList(EyouSoft.Model.EnumType.PlanStructure.PlanProject.火车, null, null, false, null, TourId, PlanState.已落实);
trainPlanList = GetZhiChus(trainPlanList);
if (trainPlanList != null && trainPlanList.Count > 0)
{
this.train = trainPlanList.Count;
this.rpt_train.DataSource = trainPlanList;
this.rpt_train.DataBind();
}
else
{
this.ph_train.Visible = false;
}
#endregion
#region 景点
IList <EyouSoft.Model.PlanStructure.MPlan> scenicPlanList = bllPlan.GetList(EyouSoft.Model.EnumType.PlanStructure.PlanProject.景点, null, null, false, null, TourId, PlanState.已落实);
scenicPlanList = GetZhiChus(scenicPlanList);
if (scenicPlanList != null && scenicPlanList.Count > 0)
{
this.jingdian = scenicPlanList.Count;
this.rpt_jingdian.DataSource = scenicPlanList;
this.rpt_jingdian.DataBind();
}
else
{
this.ph_jingdian.Visible = false;
}
#endregion
#region 酒店
IList <EyouSoft.Model.PlanStructure.MPlan> hotelPlanList = bllPlan.GetList(EyouSoft.Model.EnumType.PlanStructure.PlanProject.酒店, null, null, false, null, TourId, PlanState.已落实);
hotelPlanList = GetZhiChus(hotelPlanList);
if (hotelPlanList != null && hotelPlanList.Count > 0)
{
this.hotel = hotelPlanList.Count;
this.rpt_hotellistk.DataSource = hotelPlanList;
this.rpt_hotellistk.DataBind();
}
else
{
this.ph_hotel.Visible = false;
}
#endregion
#region 领料
IList <EyouSoft.Model.PlanStructure.MPlan> lingliaolPlanList = bllPlan.GetList(EyouSoft.Model.EnumType.PlanStructure.PlanProject.领料, null, null, false, null, TourId, PlanState.已落实);
lingliaolPlanList = GetZhiChus(lingliaolPlanList);
if (lingliaolPlanList != null && lingliaolPlanList.Count > 0)
{
this.lingliao = lingliaolPlanList.Count;
this.rpt_lingliao.DataSource = lingliaolPlanList;
this.rpt_lingliao.DataBind();
}
else
{
this.ph_lingliao.Visible = false;
}
#endregion
#region 其它
IList <EyouSoft.Model.PlanStructure.MPlan> otherlPlanList = bllPlan.GetList(EyouSoft.Model.EnumType.PlanStructure.PlanProject.其它, null, null, false, null, TourId, PlanState.已落实);
otherlPlanList = GetZhiChus(otherlPlanList);
if (otherlPlanList != null && otherlPlanList.Count > 0)
{
this.qita = otherlPlanList.Count;
this.rpt_qita.DataSource = otherlPlanList;
this.rpt_qita.DataBind();
}
else
{
this.ph_qita.Visible = false;
}
#endregion
#region 汽车
IList <EyouSoft.Model.PlanStructure.MPlan> busPlanList = bllPlan.GetList(EyouSoft.Model.EnumType.PlanStructure.PlanProject.汽车, null, null, false, null, TourId, PlanState.已落实);
busPlanList = GetZhiChus(busPlanList);
if (busPlanList != null && busPlanList.Count > 0)
{
this.bus = busPlanList.Count;
this.rpt_bus.DataSource = busPlanList;
this.rpt_bus.DataBind();
}
else
{
this.ph_bus.Visible = false;
}
#endregion
#region 用餐
IList <EyouSoft.Model.PlanStructure.MPlan> yongcanPlanList = bllPlan.GetList(EyouSoft.Model.EnumType.PlanStructure.PlanProject.用餐, null, null, false, null, TourId, PlanState.已落实);
yongcanPlanList = GetZhiChus(yongcanPlanList);
if (yongcanPlanList != null && yongcanPlanList.Count > 0)
{
this.yongcan = yongcanPlanList.Count;
this.rpt_yongcan.DataSource = yongcanPlanList;
this.rpt_yongcan.DataBind();
}
else
{
this.ph_yongcan.Visible = false;
}
#endregion
#region 用车
IList <EyouSoft.Model.PlanStructure.MPlan> carPlanList = bllPlan.GetList(EyouSoft.Model.EnumType.PlanStructure.PlanProject.用车, null, null, false, null, TourId, PlanState.已落实);
carPlanList = GetZhiChus(carPlanList);
if (carPlanList != null && carPlanList.Count > 0)
{
this.chedui = carPlanList.Count;
this.rpt_chedui.DataSource = carPlanList;
this.rpt_chedui.DataBind();
}
else
{
this.ph_chedui.Visible = false;
}
#endregion
#endregion
#endregion
}
