private string toexcel(int tid) { IList <EyouSoft.Model.TourStructure.LBGYSTours> list = null; EyouSoft.BLL.TourStructure.Tour tBll = new EyouSoft.BLL.TourStructure.Tour(); list = tBll.GetToursGYS(CurrentUserCompanyID, 1, 1, ref recordCount, tid); if (recordCount != 0) { list = tBll.GetToursGYS(CurrentUserCompanyID, recordCount, 1, ref recordCount, tid); } Response.Clear(); Response.AppendHeader("Content-Disposition", "attachment;filename=" + "area" + DateTime.Now.ToShortDateString() + ".xls"); Response.ContentEncoding = System.Text.Encoding.Default; Response.ContentType = "application/ms-excel"; //取得数据表各列标题,各标题之间以\t分割,最后一个列标题后加回车符 StringBuilder sb = new StringBuilder(); sb.AppendFormat("<table border='1'><tr><th>{0}</th><th>{1}</th><th>{2}</th><th>{3}</th><th>{4}</th><th>{5}</th><th>{6}</th><tr>", "团号", "线路名称", "出团日期", "人数", "计调员", "返利", "结算费用"); foreach (EyouSoft.Model.TourStructure.LBGYSTours cs in list) { sb.AppendFormat("<td >{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{4}</td><td>{5}</td><td>{6}</td><tr>", " " + cs.TourCode + " ", cs.RouteName, cs.LDate.ToString("yyyy-MM-dd"), cs.PlanPeopleNumber, cs.PlanNames, cs.CommissionAmount, cs.SettlementAmount); } sb.Append("</table>"); return(sb.ToString()); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string type = context.Request.QueryString["type"]; //登录公司ID EyouSoft.SSOComponent.Entity.UserInfo userModel = EyouSoft.Security.Membership.UserProvider.GetUser(); //如果公司ID为0表示没有公司登录 并返回false if (userModel == null) { context.Response.Write("{Islogin:false}"); return; } if (type != null && type != "") { string tourId = context.Request.QueryString["tourId"]; if (tourId != "") { int result = 0; switch (type) { case "TiJiao": result = new EyouSoft.BLL.TourStructure.Tour().SetStatus(tourId, EyouSoft.Model.EnumType.TourStructure.TourStatus.财务核算); break; case "FuHe": result = new EyouSoft.BLL.TourStructure.Tour().SetIsReview(tourId, true); break; case "JieSu": result = new EyouSoft.BLL.TourStructure.Tour().SetStatus(tourId, EyouSoft.Model.EnumType.TourStructure.TourStatus.核算结束); break; case "JiDiao": result = new EyouSoft.BLL.TourStructure.Tour().SetStatus(tourId, EyouSoft.Model.EnumType.TourStructure.TourStatus.回团报账); break; case "TuiHuiCaiWu": result = new EyouSoft.BLL.TourStructure.Tour().SetStatus(tourId, EyouSoft.Model.EnumType.TourStructure.TourStatus.财务核算); break; } context.Response.Write(result.ToString()); } } }
/// <summary> /// 删除一次申请机票 /// </summary> /// <param name="TicketOutId"></param> /// <returns></returns> public int DeleteTicket(string TicketOutId) { TicketOutListInfo model = GetTicketModel(TicketOutId); if (dal.DeleteTicket(TicketOutId) > 0) { //日志 AddSysLog("删除"); //维护团队机票状态 if (model != null) { EyouSoft.BLL.TourStructure.Tour tourDal = new EyouSoft.BLL.TourStructure.Tour(); tourDal.SetTourTicketStatus(model.TourId, model.State); //价格维护 EyouSoft.BLL.UtilityStructure.Utility u = new EyouSoft.BLL.UtilityStructure.Utility(); IList <EyouSoft.Model.StatisticStructure.ItemIdAndType> iList = new List <EyouSoft.Model.StatisticStructure.ItemIdAndType>(); iList.Add(new EyouSoft.Model.StatisticStructure.ItemIdAndType() { ItemId = model.TicketOutId, ItemType = EyouSoft.Model.EnumType.StatisticStructure.PaidType.机票支出 }); u.CalculationTourOut(model.TourId, iList); //维护供应商交易次数 IDAL.UtilityStructure.IUtility idal = Component.Factory.ComponentFactory.CreateDAL <IDAL.UtilityStructure.IUtility>(); idal.ServerTradeCount(model.TicketOfficeId); } return(1); } return(0); }
/// <summary> /// 页面初始绑定 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { #region 团款确认 string act = Utils.GetQueryStringValue("act"); if (Utils.GetQueryStringValue("act") != "") { if (act == "cbsubmit") { if (!CheckGrant(global::Common.Enum.TravelPermission.财务管理_团款支出_成本确认)) { Utils.ResponseNoPermit(global::Common.Enum.TravelPermission.财务管理_团款支出_成本确认, false); } EyouSoft.BLL.TourStructure.Tour bll = new EyouSoft.BLL.TourStructure.Tour(SiteUserInfo); if (bll.SetIsCostConfirm(Utils.GetQueryStringValue("tourid"), true) > 0) { EyouSoft.Common.Function.MessageBox.Show(this.Page, "确认成功!"); } else { EyouSoft.Common.Function.MessageBox.Show(this.Page, "操作失败!"); } } } #endregion if (!IsPostBack) { if (!CheckGrant(global::Common.Enum.TravelPermission.财务管理_团款支出_栏目)) { Utils.ResponseNoPermit(global::Common.Enum.TravelPermission.财务管理_团款支出_栏目, false); } BindInfo(); } }
/// <summary> /// 初始化游客信息列表 /// </summary> protected void InitVisitorListAndRouteInfo() { EyouSoft.BLL.TourStructure.TourOrder order = new EyouSoft.BLL.TourStructure.TourOrder(base.SiteUserInfo); EyouSoft.Model.TourStructure.TourOrder orderModel = order.GetOrderModel(base.SiteUserInfo.CompanyID, orderId); if (orderModel == null) { Response.Clear(); Response.Write("未找到信息"); Response.End(); } EyouSoft.Model.TourStructure.TourBaseInfo infoModel = new EyouSoft.BLL.TourStructure.Tour(base.SiteUserInfo).GetTourInfo(orderModel.TourId); ltrTourNumber.Text = orderModel.TourNo; ltrRouteName.Text = orderModel.RouteName; if (infoModel != null) { ltrDays.Text = infoModel.TourDays.ToString(); } IList <EyouSoft.Model.TourStructure.TourOrderCustomer> list = orderModel.CustomerList.Where(x => x.CustomerStatus == EyouSoft.Model.EnumType.TourStructure.CustomerStatus.正常).ToList(); rptVisitorList.DataSource = list; rptVisitorList.DataBind(); }
protected string customlevtypeprice(string tourid) { if (userModel != null && userModel.ID > 0) { return(BindPricesList(tourid, userModel.TourCompany.CustomerLevel)); } else { System.Text.StringBuilder stringPrice = new System.Text.StringBuilder(); EyouSoft.BLL.TourStructure.Tour tourBLl = new EyouSoft.BLL.TourStructure.Tour(); PriceList = tourBLl.GetPriceStandards(tourid); stringPrice.Append("<tr bgcolor=\"#dfedfc\">"); stringPrice.Append("<td height=\"20\" align=\"center\" width=\"40%\" bgcolor=\"#d0eafb\">报价标准</td>"); stringPrice.Append("<td style=\"text-align:left\" width=\"60%\" bgcolor=\"#d0eafb\">价格</td>"); for (int i = 0; i < PriceList.Count; i++) { for (int j = 0; j < PriceList[i].CustomerLevels.Count; j++) { if (PriceList[i].CustomerLevels[j].LevelType == EyouSoft.Model.EnumType.CompanyStructure.CustomLevType.门市) { stringPrice.Append("<tr>"); stringPrice.AppendFormat("<td height=\"20\" width=\"50px\" align=\"center\" bgcolor=\"#f6fafd\">{0} </td>", PriceList[i].StandardName); stringPrice.Append("<td style=\"text-align:left\" bgcolor=\"#f6fafd\">"); stringPrice.AppendFormat("成人价:{0} <br/>", Utils.FilterEndOfTheZeroDecimal(PriceList[i].CustomerLevels[j].AdultPrice)); stringPrice.AppendFormat("儿童价:{0}", Utils.FilterEndOfTheZeroDecimal(PriceList[i].CustomerLevels[j].ChildrenPrice)); stringPrice.Append("</td></tr>"); break; } } } stringPrice.Append("</tr>"); prices = stringPrice.ToString(); return(prices); } }
/// <summary> /// 页面初始化方法 /// </summary> /// <param name="travelId">行程单ID</param> protected void DataInit(string tourId) { //声明bll对象 EyouSoft.BLL.TourStructure.Tour bll = new EyouSoft.BLL.TourStructure.Tour(); //声明团队计划对象 EyouSoft.Model.TourStructure.TourInfo model = (EyouSoft.Model.TourStructure.TourInfo)bll.GetTourInfo(tourId); if (model != null) { //线路名称 this.lblAreaName.Text = model.RouteName; //团号 this.lblTeamNum.Text = model.TourCode; //天数 this.lblDay.Text = model.TourDays.ToString(); //成人数 this.lblAdult.Text = model.PlanPeopleNumber.ToString(); //儿童数 //出发交通 this.lblBegin.Text = model.LTraffic; //返程交通 this.lblEnd.Text = model.RTraffic; //行程安排 this.litTravel.Text = model.TourQuickInfo.QuickPlan; //服务标准 this.litService.Text = model.TourQuickInfo.Service; //地接社信息 this.rptDjInfo.DataSource = model.LocalAgencys; this.rptDjInfo.DataBind(); } }
/// <summary> /// AJAX请求获取指定团队编号所在母团下相关子团信息 /// </summary> void GetTours() { string tourId = Utils.GetFormValue("tourid"); DateTime sLDate = new DateTime(Utils.GetInt(Utils.GetFormValue("year"), DateTime.Now.Year), Utils.GetInt(Utils.GetFormValue("month"), DateTime.Now.Month), 1); DateTime eLDate = sLDate.AddMonths(1); EyouSoft.SSOComponent.Entity.UserInfo userInfo = EyouSoft.Security.Membership.UserProvider.GetUser(); int levelId = 0; if (userInfo != null && userInfo.UserType == EyouSoft.Model.EnumType.CompanyStructure.CompanyUserType.组团用户) { levelId = userInfo.TourCompany.CustomerLevel; } var items = new EyouSoft.BLL.TourStructure.Tour().GetToursRiLi(Master.CompanyId, tourId, sLDate, eLDate); string s = "[]"; if (items != null && items.Count > 0) { foreach (var item in items) { decimal marketPrice = 0; decimal levelPrice = 0; new EyouSoft.BLL.TourStructure.Tour().GetTourPrice(item.TourId, levelId, out marketPrice, out levelPrice); item.JiaGeCR = levelPrice; } s = Newtonsoft.Json.JsonConvert.SerializeObject(items); } ResponseAndClear(s); }
protected void BindPriceList() { System.Text.StringBuilder stringPrice = new System.Text.StringBuilder(); string TourId = Utils.GetQueryStringValue("tourId"); EyouSoft.BLL.TourStructure.Tour tourBLl = new EyouSoft.BLL.TourStructure.Tour(); PriceList = tourBLl.GetPriceStandards(TourId); for (int i = 0; i < PriceList.Count; i++) { for (int j = 0; j < PriceList[i].CustomerLevels.Count; j++) { if (PriceList[i].CustomerLevels[j].LevelId == SiteUserInfo.TourCompany.CustomerLevel) { stringPrice.Append("<tr>"); stringPrice.AppendFormat("<td><input type=\"radio\" name=\"radio\" class='radio_select' id=\"radio{0}\" value=\"{0}\"/>{1} </td>", PriceList[i].StandardId, PriceList[i].StandardName); stringPrice.Append("<td>"); stringPrice.AppendFormat("成人价:<span name=\"sp_cr_price\">{0}</span> ", Utils.FilterEndOfTheZeroDecimal(PriceList[i].CustomerLevels[j].AdultPrice)); stringPrice.AppendFormat("儿童价:<span name=\"sp_et_price\">{0}</span>", Utils.FilterEndOfTheZeroDecimal(PriceList[i].CustomerLevels[j].ChildrenPrice)); stringPrice.Append("</td></tr>"); break; } } } price = stringPrice.ToString(); }
private void bind() { //查询条件 LDate = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("LDate")) == null ? "" : Utils.GetDateTimeNullable(Utils.GetQueryStringValue("LDate")).Value.ToString("yyyy-MM-dd"); LEDate = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("LEdate")) == null ? "" : Utils.GetDateTimeNullable(Utils.GetQueryStringValue("LEDate")).Value.ToString("yyyy-MM-dd"); RouteName = Utils.GetQueryStringValue("RouteName").ToString(); EyouSoft.Model.TourStructure.TourSentTaskSearch TourSentTaskSearch = new EyouSoft.Model.TourStructure.TourSentTaskSearch(); TourSentTaskSearch.LDate = Utils.GetDateTimeNullable(LDate); TourSentTaskSearch.LEDate = Utils.GetDateTimeNullable(LEDate); TourSentTaskSearch.RouteName = RouteName; TourSentTaskSearch.CompanyId = CurrentUserCompanyID; //第几页 pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1); //用户ID int[] UserID = new int[1]; UserID[0] = SiteUserInfo.ID; //初始化列表 EyouSoft.BLL.TourStructure.Tour tsBLL = new EyouSoft.BLL.TourStructure.Tour(SiteUserInfo); IList <EyouSoft.Model.TourStructure.TourSentTask> SendTaskslist = null; SendTaskslist = tsBLL.GetMySendTourInfo(pageSize, pageIndex, ref recordCount, UserID, TourSentTaskSearch); //绑定 retList.DataSource = SendTaskslist; retList.DataBind(); Repeater1.DataSource = SendTaskslist; Repeater1.DataBind(); //判断记录条数 len = retList == null ? 0 : SendTaskslist.Count; Print(); //分页 BindPage(); RegisterScript(string.Format("var recordCount={0};", recordCount)); }
protected void Page_Load(object sender, EventArgs e) { //声明bll对象 EyouSoft.BLL.TourStructure.Tour bll = new EyouSoft.BLL.TourStructure.Tour(SiteUserInfo); //声明散拼计划对象 EyouSoft.Model.TourStructure.TourBaseInfo tModel = bll.GetTourInfo(Utils.GetQueryStringValue("tourId")); if (tModel != null) { if (tModel.TourType == EyouSoft.Model.EnumType.TourStructure.TourType.团队计划) { EyouSoft.Model.TourStructure.TourTeamInfo model = (EyouSoft.Model.TourStructure.TourTeamInfo)tModel; Bind(model); } else { EyouSoft.Model.TourStructure.TourInfo model = (EyouSoft.Model.TourStructure.TourInfo)tModel; Bind(model); } } else { Response.Clear(); Response.Write("未找到信息!"); Response.End(); } }
/// <summary> /// 修改机票申请 /// </summary> /// <param name="TicketModel"></param> /// <returns></returns> public bool UpdateTicketOutListModel(TicketOutListInfo TicketModel) { if (TicketModel.State == EyouSoft.Model.EnumType.PlanStructure.TicketState.None) { return(false); } //TicketModel.State = EyouSoft.Model.EnumType.PlanStructure.TicketState.机票申请; string registerId; if (dal.ToTicketOut(TicketModel, out registerId)) { EyouSoft.BLL.UtilityStructure.Utility u = new EyouSoft.BLL.UtilityStructure.Utility(); IList <EyouSoft.Model.StatisticStructure.ItemIdAndType> iList = new List <EyouSoft.Model.StatisticStructure.ItemIdAndType>(); iList.Add(new EyouSoft.Model.StatisticStructure.ItemIdAndType() { ItemId = TicketModel.TicketOutId, ItemType = EyouSoft.Model.EnumType.StatisticStructure.PaidType.机票支出 }); //价格维护 u.CalculationTourOut(TicketModel.TourId, iList); u.CalculationTourSettleStatus(TicketModel.TourId); //日志 AddSysLog("修改"); //维护团队状态 EyouSoft.BLL.TourStructure.Tour tourDal = new EyouSoft.BLL.TourStructure.Tour(); tourDal.SetTourTicketStatus(TicketModel.TourId, TicketModel.State); return(true); } return(false); }
/// <summary> /// 价格列表 /// </summary> void BindPireList() { EyouSoft.BLL.TourStructure.Tour bl = new EyouSoft.BLL.TourStructure.Tour(); IList <EyouSoft.Model.TourStructure.TourPriceStandardInfo> list = bl.GetPriceStandards(Request["tourId"]); rpt_price.DataSource = list; rpt_price.DataBind(); }
/// <summary> /// 安排地接 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddTravel(LocalTravelAgencyInfo model) { string id = Guid.NewGuid().ToString(); model.ID = id; model.TotalAmount = model.Settlement; if (dal.RanguageTravel(model)) { //添加支出明细 AddStatAllOut(model); //重新计算团队支出 EyouSoft.BLL.UtilityStructure.Utility u = new EyouSoft.BLL.UtilityStructure.Utility(); IList <EyouSoft.Model.StatisticStructure.ItemIdAndType> iList = new List <EyouSoft.Model.StatisticStructure.ItemIdAndType>(); iList.Add(new EyouSoft.Model.StatisticStructure.ItemIdAndType() { ItemId = model.ID, ItemType = EyouSoft.Model.EnumType.StatisticStructure.PaidType.地接支出 }); //价格维护 u.CalculationTourOut(model.TourId, iList); //加日志 //AddSysLog("新增"); //维护地接社交易数量 if (model.TravelAgencyID > 0) { u.ServerTradeCount(model.TravelAgencyID); } u.CalculationTourSettleStatus(model.TourId); #region LGWR EyouSoft.Model.EnumType.TourStructure.TourType? tourType = new EyouSoft.BLL.TourStructure.Tour().GetTourType(model.TourId); Model.EnumType.CompanyStructure.SysPermissionClass mokuai = EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.散拼计划_散拼计划; if (tourType != null && tourType == EyouSoft.Model.EnumType.TourStructure.TourType.团队计划) { mokuai = EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.团队计划_团队计划; } EyouSoft.Model.CompanyStructure.SysHandleLogs logInfo = new EyouSoft.Model.CompanyStructure.SysHandleLogs(); logInfo.CompanyId = 0; logInfo.DepatId = 0; logInfo.EventCode = EyouSoft.Model.CompanyStructure.SysHandleLogsNO.EventCode; logInfo.EventIp = string.Empty; logInfo.EventMessage = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "{0}在" + mokuai.ToString() + "新增了地接安排,安排编号:" + model.ID + ",计划编号为:" + model.TourId; logInfo.EventTime = DateTime.Now; logInfo.EventTitle = "新增地接安排"; logInfo.ModuleId = mokuai; logInfo.OperatorId = 0; this.Logwr(logInfo); #endregion return(true); } return(false); }
/// <summary> /// 绑定列表 /// </summary> void Bind() { txt_teamName.Value = ""; txt_teamNum.Value = ""; txt_teamStatus.Value = ""; txt_teamTraffic.Value = ""; txt_PaidMoney.Value = ""; string tourId = Utils.GetQueryStringValue("tourId"); EyouSoft.BLL.PlanStruture.TravelAgency bll = new EyouSoft.BLL.PlanStruture.TravelAgency(); EyouSoft.BLL.TourStructure.Tour tour = new EyouSoft.BLL.TourStructure.Tour(); EyouSoft.Model.TourStructure.TourBaseInfo info = tour.GetTourInfo(tourId); txt_teamNum.Value = info.TourCode; txt_teamName.Value = info.RouteName; txt_teamStatus.Value = info.Status.ToString(); txt_teamTraffic.Value = Utils.FilterEndOfTheZeroDecimal(info.TotalExpenses); //txt_PaidMoney .Value=Utils.FilterEndOfTheZeroDecimal(info. //lt_seller.Text = info.SellerName; //lt_actor.Text = info.OperatorId.ToString(); EyouSoft.BLL.TourStructure.TourOrder orderbll = new EyouSoft.BLL.TourStructure.TourOrder(SiteUserInfo); EyouSoft.Model.TourStructure.TourOrder ordermodel = new EyouSoft.Model.TourStructure.TourOrder(); IList <EyouSoft.Model.StatisticStructure.StatisticOperator> listSeller = orderbll.GetSalerInfo(tourId); IList <string> listOprator = tour.GetTourCoordinators(tourId); string sellers = ""; string oprator = ""; foreach (var v in listSeller) { sellers += v.OperatorName + ","; } if (sellers.Length > 0) { sellers = sellers.TrimEnd(','); } foreach (var v in listOprator) { oprator += v + ","; } if (oprator.Length > 0) { oprator = oprator.TrimEnd(','); } lt_seller.Text = sellers; lt_actor.Text = oprator; IList <EyouSoft.Model.PlanStructure.PaymentList> list = bll.GetSettleList(tourId); IList <EyouSoft.Model.PlanStructure.PaymentList> listPiaowu = list.Where(x => x.SupplierType == EyouSoft.Model.EnumType.CompanyStructure.SupplierType.票务).ToList(); IList <EyouSoft.Model.PlanStructure.PaymentList> listDiJie = list.Where(x => x.SupplierType == EyouSoft.Model.EnumType.CompanyStructure.SupplierType.地接).ToList(); rpt_dijie.DataSource = listDiJie; rpt_piaowu.DataSource = listPiaowu; rpt_dijie.DataBind(); rpt_piaowu.DataBind(); }
/// <summary> /// 获取儿童价 /// </summary> /// <param name="tourId">团号</param> /// <returns></returns> protected string GetChildrenPrice(string tourId) { decimal Adult = 0; decimal Children = 0; EyouSoft.BLL.TourStructure.Tour tourbll = new EyouSoft.BLL.TourStructure.Tour(); tourbll.GetTourPrice(tourId, SiteUserInfo.TourCompany.CustomerLevel, out Adult, out Children); return(EyouSoft.Common.Utils.FilterEndOfTheZeroString(Children.ToString())); }
/// <summary> /// 根据团号得到报价 /// </summary> protected string GetPrice(string tourid) { EyouSoft.BLL.TourStructure.Tour tour = new EyouSoft.BLL.TourStructure.Tour(SiteUserInfo); decimal crPrice; decimal rtPrice; tour.GetTourMarketPrice(tourid, out crPrice, out rtPrice); return(Utils.FilterEndOfTheZeroDecimal(crPrice) + "/" + Utils.FilterEndOfTheZeroDecimal(rtPrice)); }
/// <summary> /// 页面初始化方法 /// </summary> /// <param name="travelId">行程单ID</param> protected void DataInit(string tourId) { //声明bll对象 EyouSoft.BLL.TourStructure.Tour bll = new EyouSoft.BLL.TourStructure.Tour(SiteUserInfo); //声明团队计划对象 EyouSoft.Model.TourStructure.TourTeamInfo model = (EyouSoft.Model.TourStructure.TourTeamInfo)bll.GetTourInfo(tourId); if (model != null && model.ReleaseType == EyouSoft.Model.EnumType.TourStructure.ReleaseType.Normal) { #region 页面控件赋值 //线路名称 this.lblAreaName.Text = model.RouteName; //团号 this.lblTeamNum.Text = model.TourCode; //人数 this.lblAdult.Text = model.PlanPeopleNumber.ToString(); //天数 this.lblDayCount.Text = model.TourDays.ToString(); //出发交通 this.lblBegin.Text = model.LTraffic; //返程交通 this.lblEnd.Text = model.RTraffic; //出团日期 LeaveDate = model.LDate; if (model.TourNormalInfo != null) { //不含项目 this.lblNoProject.Text = EyouSoft.Common.Function.StringValidate.TextToHtml(model.TourNormalInfo.BuHanXiangMu); //购物安排 this.lblBuy.Text = EyouSoft.Common.Function.StringValidate.TextToHtml(model.TourNormalInfo.GouWuAnPai); //儿童安排 this.lblChildPlan.Text = EyouSoft.Common.Function.StringValidate.TextToHtml(model.TourNormalInfo.ErTongAnPai); //自费项目 this.lblSelfProject.Text = EyouSoft.Common.Function.StringValidate.TextToHtml(model.TourNormalInfo.ZiFeiXIangMu); //注意事项 this.lblNote.Text = EyouSoft.Common.Function.StringValidate.TextToHtml(model.TourNormalInfo.ZhuYiShiXiang); //温馨提示 this.lblTips.Text = EyouSoft.Common.Function.StringValidate.TextToHtml(model.TourNormalInfo.WenXinTiXing); //行程安排 this.rptTravel.DataSource = model.TourNormalInfo.Plans; this.rptTravel.DataBind(); } //包含项目 //包含项目 if (model.Services != null) { tdCount = model.Services.Count * 2; } this.rptProject.DataSource = model.Services; this.rptProject.DataBind(); //地接社信息 this.rptDjInfo.DataSource = model.LocalAgencys; this.rptDjInfo.DataBind(); #endregion } }
/// <summary> /// 页面初始化方法 /// </summary> /// <param name="teamNumber">团队编号</param> /// <param name="teamName">团队名称</param> /// <param name="dayCount">天数</param> /// <param name="beginDate">开始日期</param> /// <param name="endDate">结束日期</param> protected void DataInit(string teamNumber, string routeName, int?dayCount, DateTime?beginDate, DateTime?endDate, int?areaId, int[] SellerId, int[] CoordinatorId, string orderName) { //声明查询对象 EyouSoft.Model.TourStructure.TourSearchInfo searchModel = new EyouSoft.Model.TourStructure.TourSearchInfo(); //团号查询 searchModel.TourCode = teamNumber; //线路名称 searchModel.RouteName = routeName; //游客姓名 searchModel.YouKeName = orderName; //团队天数 searchModel.TourDays = dayCount; //出团日期 searchModel.SDate = beginDate; //截止日期 searchModel.EDate = endDate; //线路区域编号 searchModel.AreaId = areaId; //销售员编号 searchModel.Sellers = SellerId; //计调员编号 searchModel.Coordinators = CoordinatorId; searchModel.TourStatus = (EyouSoft.Model.EnumType.TourStructure.TourStatus?)Utils.GetEnumValue(typeof(EyouSoft.Model.EnumType.TourStructure.TourStatus), Utils.GetQueryStringValue("tourStatus"), null); //人数、团款合计 int peopleSum = 0; decimal paraSum = 0; //声明bll对象 EyouSoft.BLL.TourStructure.Tour bllOrder = new EyouSoft.BLL.TourStructure.Tour(SiteUserInfo); //获得团队计划集合 IList <EyouSoft.Model.TourStructure.LBTeamTourInfo> list = bllOrder.GetToursTeam(SiteUserInfo.CompanyID, pageSize, pageIndex, ref recordCount, searchModel); bllOrder.GetToursTeamHeJi(SiteUserInfo.CompanyID, searchModel, out peopleSum, out paraSum); //判断集合是否有数据 if (list != null && list.Count > 0) { lt_peopleNum.Text = peopleSum.ToString(); lt_paraSum.Text = "¥" + paraSum.ToString("0.00"); //页面控件数据绑定 this.rptList.DataSource = list; this.rptList.DataBind(); //设置分页 BindPage(); //不显示无数据提示 lblMsg.Visible = false; } else { lt_paraSum.Visible = false; lt_peopleNum.Visible = false; //没有数据隐藏分页控件 this.ExportPageInfo1.Visible = false; lblMsg.Visible = true; } }
/// <summary> /// 打印送团单 /// </summary> private void Print() { //声明bll对象 EyouSoft.BLL.TourStructure.Tour tourBll = new EyouSoft.BLL.TourStructure.Tour(SiteUserInfo); //声明bll对象 EyouSoft.BLL.CompanyStructure.CompanySetting bll = new EyouSoft.BLL.CompanyStructure.CompanySetting(); //打印送团单 路劲 printUrl = bll.GetPrintPath(SiteUserInfo.CompanyID, EyouSoft.Model.EnumType.CompanyStructure.PrintTemplateType.送团单); }
/// <summary> /// 获得成人 儿童 价格 /// </summary> /// <param name="tourId"></param> /// <returns></returns> protected string getPeoPlePrice(string tourId) { string Prices = ""; //登录 if (userModel != null && userModel.ID > 0) { IList <EyouSoft.Model.TourStructure.TourPriceStandardInfo> PriceStandard = new EyouSoft.BLL.TourStructure.Tour().GetPriceStandards(tourId); if (PriceStandard != null && PriceStandard.Count > 0) { if (PriceStandard[0].CustomerLevels != null) { for (int j = 0; j < PriceStandard[0].CustomerLevels.Count; j++) { if (PriceStandard[0].CustomerLevels[j].LevelId == userModel.TourCompany.CustomerLevel) { Prices = Utils.FilterEndOfTheZeroString(PriceStandard[0].CustomerLevels[j].AdultPrice.ToString("0.00")) + "/" + Utils.FilterEndOfTheZeroString(PriceStandard[0].CustomerLevels[j].ChildrenPrice.ToString("0.00")); break; } else { Prices = ""; } } } } } //未登录 if (userModel == null || Prices == "") { EyouSoft.BLL.TourStructure.Tour bl = new EyouSoft.BLL.TourStructure.Tour(); IList <EyouSoft.Model.TourStructure.TourPriceStandardInfo> list = bl.GetPriceStandards(tourId); if (list != null && list.Count > 0) { for (int i = 0; i < list.Count; i++) { if (list[0].CustomerLevels != null) { for (int j = 0; j < list[0].CustomerLevels.Count; j++) { if (list[0].CustomerLevels[j].LevelType == EyouSoft.Model.EnumType.CompanyStructure.CustomLevType.门市) { Prices = Utils.FilterEndOfTheZeroString(list[0].CustomerLevels[j].AdultPrice.ToString("0.00")) + "/" + Utils.FilterEndOfTheZeroString(list[0].CustomerLevels[j].ChildrenPrice.ToString("0.00")); break; } } } } } } return(Prices); }
/// <summary> /// 绑定客户等级 /// </summary> void BindCustomers() { //List<Customers> list = new List<Customers>(); //list.Add(new Customers(3, "客户等级")); //rpt_Customer.DataSource = list; //rpt_Customer.DataBind(); EyouSoft.BLL.TourStructure.Tour tour = new EyouSoft.BLL.TourStructure.Tour(); EyouSoft.Model.TourStructure.TourInfo binfo = new EyouSoft.Model.TourStructure.TourInfo(); binfo = (EyouSoft.Model.TourStructure.TourInfo)tour.GetTourInfo(Request.QueryString["tourId"]); EyouSoft.BLL.TourStructure.Tour bl = new EyouSoft.BLL.TourStructure.Tour(); IList <EyouSoft.Model.TourStructure.TourPriceStandardInfo> listStand = binfo.PriceStandards; IList <EyouSoft.Model.TourStructure.TourPriceCustomerLevelInfo> listCust = listStand.First().CustomerLevels; IList <EyouSoft.Model.CompanyStructure.CustomStand> list = new List <EyouSoft.Model.CompanyStructure.CustomStand>(); EyouSoft.BLL.CompanyStructure.CompanyCustomStand bll = new EyouSoft.BLL.CompanyStructure.CompanyCustomStand(); list = bll.GetCustomStandByCompanyId(CurrentUserCompanyID); int kkk = list.Count; IList <EyouSoft.Model.TourStructure.TourPriceStandardInfo> plist = binfo.PriceStandards; for (int i = 0; i < listStand.Count; i++) { for (int j = 0; j < list.Count; j++) { //if(listStand[i].CustomerLevels[i].LevelId == list.sel) if (listStand[i].CustomerLevels.Count > j) { var vn = list.Where(x => x.Id == listStand[i].CustomerLevels[j].LevelId).FirstOrDefault(); if (vn != null) { listStand[i].CustomerLevels[j].LevelName = vn.CustomStandName; } else { listStand[i].CustomerLevels.RemoveAt(j); } } var xn = listStand[i].CustomerLevels.Where(x => x.LevelId == list[j].Id).FirstOrDefault(); if (xn == null) { listStand[i].CustomerLevels.Add(new EyouSoft.Model.TourStructure.TourPriceCustomerLevelInfo() { LevelId = list[j].Id, LevelType = list[j].LevType, LevelName = list[j].CustomStandName, AdultPrice = 0, ChildrenPrice = 0 }); } } } sinfo = plist; }
/// <summary> /// 绑定线路列表 /// </summary> protected void BindInitLineProducts(int?LineTypeID, string LineName, DateTime?StarTime, DateTime?EndTime) { EyouSoft.Model.TourStructure.TourSearchInfo ModelTourSearch = new EyouSoft.Model.TourStructure.TourSearchInfo(); //出团结束时间 ModelTourSearch.EDate = EndTime; //出团开始时间 ModelTourSearch.SDate = StarTime; //线路名称 ModelTourSearch.RouteName = LineName; //线路区域编号 ModelTourSearch.AreaId = LineTypeID; ModelTourSearch.Areas = SiteUserInfo.Areas; //线路筛选 if (Request.QueryString["xlid"] != "" && Request.QueryString["xlid"] != null) { ModelTourSearch.AreaId = Utils.GetInt(Utils.GetQueryStringValue("xlid")); } //获取首页团号 if (!string.IsNullOrEmpty(Utils.GetQueryStringValue("tourid"))) { ModelTourSearch.TourId = Utils.GetQueryStringValue("tourid"); } ModelTourSearch.TourCityId = Utils.GetIntNull(Utils.GetQueryStringValue("cityID")); if (ModelTourSearch.SDate.HasValue || ModelTourSearch.EDate.HasValue) { TourDisplayType = EyouSoft.Model.EnumType.CompanyStructure.TourDisplayType.明细团; } //组团端计划列表 IList <EyouSoft.Model.TourStructure.LBZTTours> LBZTToursList = new List <EyouSoft.Model.TourStructure.LBZTTours>(); //计划中心业务类 EyouSoft.BLL.TourStructure.Tour BllTour = new EyouSoft.BLL.TourStructure.Tour(SiteUserInfo, false); //获取组团端计划列表 LBZTToursList = BllTour.GetToursZTD(SiteUserInfo.CompanyID, PageSize, PageIndex, ref RecordCount, ModelTourSearch, TourDisplayType); if (LBZTToursList.Count > 0) { this.LineProductLists.DataSource = LBZTToursList; this.LineProductLists.DataBind(); BinPage(); } else { this.ExporPageInfoSelect1.Visible = false; } ModelTourSearch = null; LBZTToursList = null; BllTour = null; }
/// <summary> /// 修改地接 /// </summary> /// <param name="Model"></param> /// <returns></returns> public bool UpdateTravelAgency(EyouSoft.Model.PlanStructure.LocalTravelAgencyInfo Model) { if (dal.UpdateTravelModel(Model)) { //重新计算团队支出 EyouSoft.BLL.UtilityStructure.Utility u = new EyouSoft.BLL.UtilityStructure.Utility(); IList <EyouSoft.Model.StatisticStructure.ItemIdAndType> iList = new List <EyouSoft.Model.StatisticStructure.ItemIdAndType>(); iList.Add(new EyouSoft.Model.StatisticStructure.ItemIdAndType() { ItemId = Model.ID, ItemType = EyouSoft.Model.EnumType.StatisticStructure.PaidType.地接支出 }); //价格维护 u.CalculationTourOut(Model.TourId, iList); //加日志 //AddSysLog("修改"); //维护地接社交易数量 if (Model.TravelAgencyID > 0) { EyouSoft.Model.PlanStructure.LocalTravelAgencyInfo tempModel = GetTravelModel(Model.ID); if (tempModel != null) { u.ServerTradeCount(new int[] { Model.TravelAgencyID, tempModel.TravelAgencyID }); } } u.CalculationTourSettleStatus(Model.TourId); #region LGWR EyouSoft.Model.EnumType.TourStructure.TourType? tourType = new EyouSoft.BLL.TourStructure.Tour().GetTourType(Model.TourId); Model.EnumType.CompanyStructure.SysPermissionClass mokuai = EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.散拼计划_散拼计划; if (tourType != null && tourType == EyouSoft.Model.EnumType.TourStructure.TourType.团队计划) { mokuai = EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.团队计划_团队计划; } EyouSoft.Model.CompanyStructure.SysHandleLogs logInfo = new EyouSoft.Model.CompanyStructure.SysHandleLogs(); logInfo.CompanyId = 0; logInfo.DepatId = 0; logInfo.EventCode = EyouSoft.Model.CompanyStructure.SysHandleLogsNO.EventCode; logInfo.EventIp = string.Empty; logInfo.EventMessage = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "{0}在" + mokuai.ToString() + "修改了地接安排,安排编号:" + Model.ID + ",计划编号为:" + Model.TourId; logInfo.EventTime = DateTime.Now; logInfo.EventTitle = "修改地接安排"; logInfo.ModuleId = mokuai; logInfo.OperatorId = 0; this.Logwr(logInfo); #endregion return(true); } return(false); }
/// <summary> /// 多对一处理 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void rpt_list1_ItemDataBound(object sender, RepeaterItemEventArgs e) { EyouSoft.Model.TourStructure.LBTKZCTourInfo dv = ((EyouSoft.Model.TourStructure.LBTKZCTourInfo)(e.Item.DataItem)); if (dv.TourType == EyouSoft.Model.EnumType.TourStructure.TourType.单项服务) { EyouSoft.BLL.TourStructure.Tour bll = new EyouSoft.BLL.TourStructure.Tour(); decimal totalAmount = 0; decimal unpaidAmount = 0; bll.GetTourExpense(dv.TourId, out totalAmount, out unpaidAmount, ExpendSearchInfo); Literal lt_amout = e.Item.FindControl("lt_Amount") as Literal; lt_amout.Text = "支出:" + Utils.FilterEndOfTheZeroDecimal(totalAmount) + "<br/>未付:" + Utils.FilterEndOfTheZeroDecimal(unpaidAmount); IsDanXiang = true; } else { if (dv.TourId != "") { EyouSoft.BLL.PlanStruture.TravelAgency bll = new EyouSoft.BLL.PlanStruture.TravelAgency(); IList <EyouSoft.Model.PlanStructure.PaymentList> list = bll.GetSettleList(dv.TourId, ExpendSearchInfo); if (list != null) { Repeater rpt = e.Item.FindControl("rpt_project") as Repeater; if (Utils.GetInt(Utils.GetQueryStringValue("comtype")) > 0) { if (Utils.GetInt(Utils.GetQueryStringValue("comtype")) == 1) { rpt.DataSource = list.Where(p => p.SupplierType == EyouSoft.Model.EnumType.CompanyStructure.SupplierType.地接); } else { rpt.DataSource = list.Where(p => p.SupplierType == EyouSoft.Model.EnumType.CompanyStructure.SupplierType.票务); } } else { rpt.DataSource = list; } rpt.DataBind(); } if (list.FirstOrDefault(i => i.SupplierType == EyouSoft.Model.EnumType.CompanyStructure.SupplierType.地接) != null) { IsDiJie = true; } if (list.FirstOrDefault(i => i.SupplierType == EyouSoft.Model.EnumType.CompanyStructure.SupplierType.票务) != null) { IsJiPiao = true; } } } }
/// <summary> /// to xls /// </summary> private void ToXls() { if (!CheckGrant(global::Common.Enum.TravelPermission.个人中心_送团任务表_栏目)) { ResponseToXls(string.Empty); } int _pageSize = Utils.GetInt(Utils.GetQueryStringValue("recordcount")); int _recordCount = 0; if (_pageSize < 1) { ResponseToXls(string.Empty); } LDate = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("LDate")) == null ? "" : Utils.GetDateTimeNullable(Utils.GetQueryStringValue("LDate")).Value.ToString("yyyy-MM-dd"); LEDate = Utils.GetDateTimeNullable(Utils.GetQueryStringValue("LEdate")) == null ? "" : Utils.GetDateTimeNullable(Utils.GetQueryStringValue("LEDate")).Value.ToString("yyyy-MM-dd"); RouteName = Utils.GetQueryStringValue("RouteName").ToString(); EyouSoft.Model.TourStructure.TourSentTaskSearch TourSentTaskSearch = new EyouSoft.Model.TourStructure.TourSentTaskSearch(); TourSentTaskSearch.LDate = Utils.GetDateTimeNullable(LDate); TourSentTaskSearch.LEDate = Utils.GetDateTimeNullable(LEDate); TourSentTaskSearch.RouteName = RouteName; TourSentTaskSearch.CompanyId = CurrentUserCompanyID; //第几页 pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1); //用户ID int[] UserID = new int[1]; UserID[0] = SiteUserInfo.ID; //初始化列表 EyouSoft.BLL.TourStructure.Tour tsBLL = new EyouSoft.BLL.TourStructure.Tour(SiteUserInfo); var list = tsBLL.GetMySendTourInfo(_pageSize, 1, ref _recordCount, UserID, TourSentTaskSearch); //取得数据表各列标题,各标题之间以\t分割,最后一个列标题后加回车符 StringBuilder sb = new StringBuilder(); sb.AppendFormat("{0}\t{1}\t{2}\t{3}\t{4}\t{5}\t{6}\n", "出团日期", "集合时间", "去程航班/时间", "回程航班/时间", " 线路名称", "人数", "计调"); foreach (EyouSoft.Model.TourStructure.TourSentTask cs in list) { cs.GatheringTime = Utils.GetDateTimeNullable(cs.GatheringTime) == null ? "" : cs.GatheringTime; sb.AppendFormat("{0}\t{1}\t{2}\t{3}\t{4}\t{5}\t{6}\n", cs.LDate == null ? "" : Convert.ToDateTime(cs.LDate).ToString("yyyy-MM-dd"), cs.GatheringTime, cs.LTraffic, cs.RTraffic, cs.RouteName, cs.PlanPeopleNumber, cs.TourCoordinatorInfo[0].Name); } ResponseToXls(sb.ToString()); }
/// <summary> /// 判断是否有传值 /// </summary> protected void InitRouteInfo() { EyouSoft.BLL.TourStructure.Tour bll = new EyouSoft.BLL.TourStructure.Tour(); EyouSoft.Model.TourStructure.TourTeamInfo tourInfo = bll.GetTourInfo(tourId) as EyouSoft.Model.TourStructure.TourTeamInfo; if (tourInfo == null) { Response.Clear(); Response.Write("未找到信息"); Response.End(); } }
protected void Page_Load(object sender, EventArgs e) { tourBll = new EyouSoft.BLL.TourStructure.Tour(this.SiteUserInfo); #region 权限验证 //单项服务删除权限 if (!CheckGrant(TravelPermission.单项服务_单项服务_删除服务)) { this.linkDelete.Visible = false; DeleteFlag = false; } //单项服务修改权限 if (!CheckGrant(TravelPermission.单项服务_单项服务_修改服务)) { this.linkUpdate.Visible = false; EditFlag = false; } //单项服务新增权限 if (!CheckGrant(TravelPermission.单项服务_单项服务_新增服务)) { this.linkAdd.Visible = false; AddFlag = false; } #endregion #region 项模板列删除 DeleteId = Request.QueryString["DeleteId"]; if (DeleteId != "" && Request.QueryString["DeleteId"] != null)//删除ID { //调用删除的方法 if (tourBll.Delete(DeleteId)) { Response.Clear(); Response.Write("1"); Response.End(); } } #endregion if (!IsPostBack) { ////判断权限 if (!CheckGrant(TravelPermission.单项服务_单项服务_栏目)) { Utils.ResponseNoPermit(TravelPermission.单项服务_单项服务_栏目, true); return; } //绑定列表 BindSingleServeList(); } }
protected void BindAreaInfo() { //计划中心业务逻辑类 EyouSoft.BLL.TourStructure.Tour bll = new EyouSoft.BLL.TourStructure.Tour(); //计划团队信息实体类 string TourId = Utils.GetQueryStringValue("tourId"); if (TourId != null && TourId != "") { model = (EyouSoft.Model.TourStructure.TourInfo)bll.GetTourInfo(TourId); if (model != null) { this.lt_xianluName.Text = model.RouteName; this.lt_teamCode.Text = model.TourCode; this.lt_startDate.Text = model.LDate.ToShortDateString(); this.lt_shengyu.Text = (model.PlanPeopleNumber - model.VirtualPeopleNumber).ToString(); //计调员 this.litCoordinatorId.Text = model.Coordinator.Name.ToString(); //计调员编号 this.hidCoordinatorId.Value = model.Coordinator.CoordinatorId.ToString(); #region 线路区域 int Areaid = model.AreaId; EyouSoft.BLL.CompanyStructure.Area AreaBll = new EyouSoft.BLL.CompanyStructure.Area(); EyouSoft.Model.CompanyStructure.Area Area = new EyouSoft.Model.CompanyStructure.Area(); Area = AreaBll.GetModel(Areaid); //计调员 if (Area != null) { this.Area.Text = Area.AreaName; } #endregion //销售员 EyouSoft.Model.CompanyStructure.CustomerInfo Customer = new EyouSoft.BLL.CompanyStructure.Customer().GetCustomerModel(SiteUserInfo.TourCompany.TourCompanyId); if (Customer != null) { this.litseller.Text = Customer.Saler; } } } //初始化联系人 this.txtContactName.Text = SiteUserInfo.ContactInfo.ContactName; //电话 this.txtContactPhone.Text = SiteUserInfo.ContactInfo.ContactTel; //手机 this.txtContactMobile.Text = SiteUserInfo.ContactInfo.ContactMobile; //传真 this.txtContactFax.Text = SiteUserInfo.ContactInfo.ContactFax; }
/// <summary> /// 删除地接 /// </summary> /// <param name="TravelId">安排地接编号</param> /// <returns></returns> public bool DelTravelAgency(string TravelId) { EyouSoft.Model.PlanStructure.LocalTravelAgencyInfo modelTravel = GetTravelModel(TravelId); if (dal.DeletTravelModel(TravelId)) { //加日志 //AddSysLog("删除"); //维护地接社交易数量 if (modelTravel != null) { EyouSoft.BLL.CompanyStructure.CompanySupplier bllSuplier = new EyouSoft.BLL.CompanyStructure.CompanySupplier();// EyouSoft.BLL.CompanyStructure.CompanySupplier(); EyouSoft.Model.CompanyStructure.CompanySupplier Model = bllSuplier.GetModel(modelTravel.TravelAgencyID, modelTravel.CompanyId); if (Model != null && Model.Id > 0) { EyouSoft.BLL.UtilityStructure.Utility idal = new EyouSoft.BLL.UtilityStructure.Utility(); idal.ServerTradeCount(new int[] { Model.Id }); } //重新计算团队支出 EyouSoft.BLL.UtilityStructure.Utility u = new EyouSoft.BLL.UtilityStructure.Utility(); //价格维护 u.CalculationTourOut(modelTravel.TourId, null); #region LGWR EyouSoft.Model.EnumType.TourStructure.TourType? tourType = new EyouSoft.BLL.TourStructure.Tour().GetTourType(modelTravel.TourId); Model.EnumType.CompanyStructure.SysPermissionClass mokuai = EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.散拼计划_散拼计划; if (tourType != null && tourType == EyouSoft.Model.EnumType.TourStructure.TourType.团队计划) { mokuai = EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.团队计划_团队计划; } EyouSoft.Model.CompanyStructure.SysHandleLogs logInfo = new EyouSoft.Model.CompanyStructure.SysHandleLogs(); logInfo.CompanyId = 0; logInfo.DepatId = 0; logInfo.EventCode = EyouSoft.Model.CompanyStructure.SysHandleLogsNO.EventCode; logInfo.EventIp = string.Empty; logInfo.EventMessage = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "{0}在" + mokuai.ToString() + "删除了地接安排,安排编号:" + modelTravel.ID + ",计划编号为:" + modelTravel.TourId; logInfo.EventTime = DateTime.Now; logInfo.EventTitle = "删除地接安排"; logInfo.ModuleId = mokuai; logInfo.OperatorId = 0; this.Logwr(logInfo); #endregion return(true); } } return(false); }