/// <summary> /// 初始化线路列表 /// </summary> private void InitRouteList() { //记录条数 int intRecordCount = 0; //页码 CurrencyPage = Utils.GetInt(Utils.GetQueryStringValue("Page"), 1); //查询实体 MRouteSearch queryModel = new MRouteSearch(); #region 查询参数赋值 //线路来源,专线,地接 routeSource = (RouteSource)Utils.GetInt(Utils.GetQueryStringValue("routeSource"), 1); queryModel.RouteSource = routeSource; //专线Id queryModel.AreaId = Utils.GetInt(Utils.GetQueryStringValue("lineId"), 0); ILine1.CheckedId = queryModel.AreaId.ToString(); ddl_ZX.SelectedValue = queryModel.AreaId.ToString(); //专线类型 queryModel.RouteType = null; if (Utils.GetIntSign(Utils.GetQueryStringValue("lineType"), -1) >= 0) { queryModel.RouteType = (AreaType)Utils.GetInt(Utils.GetQueryStringValue("lineType")); } //出发城市 queryModel.StartCity = Utils.GetInt(Utils.GetQueryStringValue("goCity"), 0); ddl_goCity.SelectedValue = queryModel.StartCity.ToString(); //关键字 queryModel.RouteKey = Utils.GetQueryStringValue("keyWord") == "线路名称" ? string.Empty : Utils.GetQueryStringValue("keyWord"); txt_keyWord.Value = queryModel.RouteKey.Length > 0 ? queryModel.RouteKey : "线路名称"; #endregion IRoute bll = EyouSoft.BLL.NewTourStructure.BRoute.CreateInstance(); //线路库列表 IList <MRoute> list = bll.GetBackCenterList(intPageSize, CurrencyPage, ref intRecordCount, SiteUserInfo.CompanyID, queryModel); if (list != null && list.Count > 0) { //存在列表数据 rpt_List.DataSource = list; rpt_List.DataBind(); ExportPageInfo1.Visible = true; this.ExportPageInfo1.intPageSize = intPageSize; this.ExportPageInfo1.intRecordCount = intRecordCount; this.ExportPageInfo1.CurrencyPage = CurrencyPage; this.ExportPageInfo1.PageLinkURL = Request.ServerVariables["SCRIPT_NAME"].ToString() + "?"; this.ExportPageInfo1.UrlParams.Add("lineId", queryModel.AreaId.ToString()); this.ExportPageInfo1.UrlParams.Add("lineType", Utils.GetQueryStringValue("lineType")); this.ExportPageInfo1.UrlParams.Add("goCity", queryModel.StartCity.ToString()); this.ExportPageInfo1.UrlParams.Add("keyWord", queryModel.RouteKey); this.ExportPageInfo1.UrlParams.Add("routeSource", Utils.GetInt(Utils.GetQueryStringValue("routeSource"), 1).ToString()); } else { //不存在列表数据 pnlNodata.Visible = true; } }
/// <summary> /// 初始化线路列表 /// </summary> private void InitRouteList() { //记录条数 int intRecordCount = 0; //页码 int CurrencyPage = Utils.GetInt(Utils.GetQueryStringValue("Page"), 1); int intPageSize = 15; IRoute bll = EyouSoft.BLL.NewTourStructure.BRoute.CreateInstance(); //查询实体 MRouteSearch queryModel = new MRouteSearch(); #region 查询参数赋值 routeSource = (RouteSource)Utils.GetInt(Utils.GetQueryStringValue("routeSource"), 1); //线路来源,专线,地接 queryModel.RouteSource = routeSource; //专线Id queryModel.AreaId = Utils.GetInt(Utils.GetQueryStringValue("lineId"), 0); if (Utils.GetIntSign(Utils.GetQueryStringValue("lineType"), -1) >= 0) { queryModel.RouteType = (AreaType)Utils.GetInt(Utils.GetQueryStringValue("lineType")); } //出发城市 queryModel.StartCity = Utils.GetInt(Utils.GetQueryStringValue("goCity"), 0); //关键字 queryModel.RouteKey = Utils.GetQueryStringValue("keyWord") == "线路名称" ? string.Empty : Utils.GetQueryStringValue("keyWord"); #endregion //线路库列表 IList <MRoute> list = bll.GetBackCenterList(intPageSize, CurrencyPage, ref intRecordCount, Utils.GetQueryStringValue("companyID"), queryModel); if (list != null && list.Count > 0) { //存在列表数据 rpt_List.DataSource = list; rpt_List.DataBind(); ExportPageInfo1.Visible = true; this.ExportPageInfo1.intPageSize = intPageSize; this.ExportPageInfo1.intRecordCount = intRecordCount; this.ExportPageInfo1.CurrencyPage = CurrencyPage; this.ExportPageInfo1.PageLinkURL = "/routeagency/routemanage/RouteView.aspx?"; this.ExportPageInfo1.UrlParams.Add("lineId", queryModel.AreaId.ToString()); this.ExportPageInfo1.UrlParams.Add("lineType", Utils.GetQueryStringValue("lineType")); this.ExportPageInfo1.UrlParams.Add("goCity", queryModel.StartCity.ToString()); this.ExportPageInfo1.UrlParams.Add("keyWord", queryModel.RouteKey); this.ExportPageInfo1.UrlParams.Add("routeSource", Utils.GetInt(Utils.GetQueryStringValue("routeSource"), 1).ToString()); } else { //不存在列表数据 pnlNodata.Visible = true; } }
protected void Page_Load(object sender, EventArgs e) { #region 权限判断 if ((RouteSource)Utils.GetInt(Utils.GetQueryStringValue("RouteSource"), 1) == RouteSource.专线商添加) { if (!CheckGrant(TravelPermission.专线_线路管理)) { Utils.ResponseNoPermit(); return; } } else if ((RouteSource)Utils.GetInt(Utils.GetQueryStringValue("RouteSource"), 1) == RouteSource.地接社添加) { if (!CheckGrant(TravelPermission.地接_线路管理)) { Utils.ResponseNoPermit(); return; } } #endregion //线路来源 routeSource = (RouteSource)Utils.GetInt(Utils.GetQueryStringValue("routeSource"), 1); //操作类型 string Operating = Utils.GetQueryStringValue("Operating"); /* * 存在操作,目前该页面只有保存操作 * 保存操作包含修改和添加 */ if (Operating.Length > 0) { Save(Operating); } //生成页面唯一标识 Key = "AddTourism" + Guid.NewGuid().ToString(); if (!IsPostBack) { /*线路区域类型 * 国内长线 = 0, * 国际线 = 1, * 国内短线 = 2, * 地接线路 = 3, */ travelRangeType = Utils.GetInt(Utils.GetQueryStringValue("travelRangeType")); //专线类型 travelRangeId = Utils.GetInt(Utils.GetQueryStringValue("travelRangeId")); //初始化页面 InitPage(); } }
/// <summary> /// 绑定线路区域 /// </summary> private void BindLineArea() { //用户Id string UserID = string.Empty;; if (SiteUserInfo != null) { EyouSoft.SSOComponent.Entity.UserInfo UserInfoModel = SiteUserInfo; UserID = UserInfoModel.ID ?? "0"; } ICompanyUser companyUserBLL = EyouSoft.BLL.CompanyStructure.CompanyUser.CreateInstance(); EyouSoft.Model.CompanyStructure.CompanyUser companyUserModel = companyUserBLL.GetModel(UserID); if (companyUserModel != null && companyUserModel.Area != null && companyUserModel.Area.Count > 0) { //国内 List <AreaBase> gn = companyUserModel.Area.Where(ty => ty.RouteType == AreaType.国内长线).ToList(); //国际 List <AreaBase> gj = companyUserModel.Area.Where(ty => ty.RouteType == AreaType.国际线).ToList(); //周边 List <AreaBase> zb = companyUserModel.Area.Where(ty => ty.RouteType == AreaType.地接线路 || ty.RouteType == AreaType.国内短线).ToList(); if (gn != null && gn.Count > 0) { showGN = true; rpt_gn.DataSource = gn; rpt_gn.DataBind(); } if (gj != null && gj.Count > 0) { showGJ = true; rpt_gj.DataSource = gj; rpt_gj.DataBind(); } if (zb != null && zb.Count > 0) { showZB = true; rpt_zb.DataSource = zb; rpt_zb.DataBind(); } routeSource = (RouteSource)Utils.GetInt(Utils.GetQueryStringValue("RouteSource"), 1); } }
/// <summary> /// 团队订单(专线,地接) /// </summary> /// <param name="pageSize">每页显示记录数</param> /// <param name="pageCurrent">当前页</param> /// <param name="recordCount">总记录数</param> /// <param name="companyId">公司编号</param> /// <param name="OrderType">订单来源</param> /// <param name="search">搜索实体</param> /// <returns>团队订单集合</returns> public IList <EyouSoft.Model.NewTourStructure.MTourList> GetList(int pageSize, int pageCurrent, ref int recordCount, string companyId, RouteSource OrderType, EyouSoft.Model.NewTourStructure.MTourListSearch search) { IList <MTourList> list = new List <MTourList>(); string tableName = "tbl_NewTourList"; string fields = "*,(select StartCityName,DayNum,LateNum from tbl_NewRouteBasicInfo where RouteId=tbl_NewTourList.RouteId for xml raw,root) as RouteInfo,(select CompanyName from tbl_CompanyInfo where Id=tbl_NewTourList.Travel) as TravelName,(select CompanyType from tbl_CompanyInfo where Id=tbl_NewTourList.Travel) as CompanyType"; string primaryKey = "TourId"; string orderByString = "IssueTime DESC "; StringBuilder strWhere = new StringBuilder("1=1"); strWhere.AppendFormat(" and Business='{0}' and OrderSource={1}", companyId, (int)OrderType); if (search != null) { if (search.SLeaveDate.HasValue) { strWhere.AppendFormat(" and datediff(day,'{0}',StartDate)>=0", search.SLeaveDate); } if (search.ELeaveDate.HasValue) { strWhere.AppendFormat(" and datediff(day,'{0}',StartDate)<=0", search.ELeaveDate); } if (search.TourOrderStatus != null) { strWhere.AppendFormat(" and OrderStatus={0}", (int)search.TourOrderStatus); } if (!string.IsNullOrEmpty(search.TourKey)) { strWhere.AppendFormat(" and (RouteName like '%{0}%' or exists(select 1 from tbl_CompanyInfo where Id=tbl_NewTourList.Travel and CompanyName like '%{0}%'))", search.TourKey.Trim()); } if (search.AreaType != null) { strWhere.AppendFormat(" and exists(select 1 from tbl_NewRouteBasicInfo where RouteId=tbl_NewTourList.RouteId and RouteType={0})", (int)search.AreaType); } } using (IDataReader rdr = DbHelper.ExecuteReader(this._db, pageSize, pageCurrent, ref recordCount, tableName, primaryKey, fields, strWhere.ToString(), orderByString)) { while (rdr.Read()) { MTourList model = new MTourList(); model.TourId = rdr.IsDBNull(rdr.GetOrdinal("TourId")) ? "" : rdr.GetString(rdr.GetOrdinal("TourId")); model.OrderNo = rdr.IsDBNull(rdr.GetOrdinal("OrderNo")) ? "" : rdr.GetString(rdr.GetOrdinal("OrderNo")); model.TourNo = rdr.IsDBNull(rdr.GetOrdinal("TourNo")) ? "" : rdr.GetString(rdr.GetOrdinal("TourNo")); model.RouteId = rdr.IsDBNull(rdr.GetOrdinal("RouteId")) ? "" : rdr.GetString(rdr.GetOrdinal("RouteId")); model.RouteName = rdr.IsDBNull(rdr.GetOrdinal("RouteName")) ? "" : rdr.GetString(rdr.GetOrdinal("RouteName")); model.StartDate = rdr.IsDBNull(rdr.GetOrdinal("StartDate")) ? DateTime.MinValue : rdr.GetDateTime(rdr.GetOrdinal("StartDate")); model.Business = rdr.IsDBNull(rdr.GetOrdinal("Business")) ? "" : rdr.GetString(rdr.GetOrdinal("Business")); model.SLeaveDate = rdr.IsDBNull(rdr.GetOrdinal("LeaveDate")) ? "" : rdr.GetString(rdr.GetOrdinal("LeaveDate")); model.ComeBackDate = rdr.IsDBNull(rdr.GetOrdinal("ComeBackDate")) ? "" : rdr.GetString(rdr.GetOrdinal("ComeBackDate")); model.TravelContact = rdr.IsDBNull(rdr.GetOrdinal("TravelContact")) ? "" : rdr.GetString(rdr.GetOrdinal("TravelContact")); model.TravelTel = rdr.IsDBNull(rdr.GetOrdinal("TravelTel")) ? "" : rdr.GetString(rdr.GetOrdinal("TravelTel")); model.VisitorContact = rdr.IsDBNull(rdr.GetOrdinal("VisitorContact")) ? "" : rdr.GetString(rdr.GetOrdinal("VisitorContact")); model.VisitorTel = rdr.IsDBNull(rdr.GetOrdinal("VisitorTel")) ? "" : rdr.GetString(rdr.GetOrdinal("VisitorTel")); model.ScheduleNum = rdr.IsDBNull(rdr.GetOrdinal("ScheduleNum")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("ScheduleNum")); model.AdultNum = rdr.IsDBNull(rdr.GetOrdinal("AdultNum")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("AdultNum")); model.ChildrenNum = rdr.IsDBNull(rdr.GetOrdinal("ChildrenNum")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("ChildrenNum")); model.SingleRoomNum = rdr.IsDBNull(rdr.GetOrdinal("SingleRoomNum")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("SingleRoomNum")); model.VisitorNotes = rdr.IsDBNull(rdr.GetOrdinal("VisitorNotes")) ? "" : rdr.GetString(rdr.GetOrdinal("VisitorNotes")); model.TravelNotes = rdr.IsDBNull(rdr.GetOrdinal("TravelNotes")) ? "" : rdr.GetString(rdr.GetOrdinal("TravelNotes")); model.BusinessNotes = rdr.IsDBNull(rdr.GetOrdinal("BusinessNotes")) ? "" : rdr.GetString(rdr.GetOrdinal("BusinessNotes")); model.IssueTime = rdr.IsDBNull(rdr.GetOrdinal("IssueTime")) ? DateTime.MinValue : rdr.GetDateTime(rdr.GetOrdinal("IssueTime")); model.OrderStatus = (TourOrderStatus)rdr.GetByte(rdr.GetOrdinal("OrderStatus")); model.TourStatus = (TourStatus)rdr.GetByte(rdr.GetOrdinal("TourStatus")); model.OperatorId = rdr.IsDBNull(rdr.GetOrdinal("OperatorId")) ? "" : rdr.GetString(rdr.GetOrdinal("OperatorId")); model.TourPrice = rdr.IsDBNull(rdr.GetOrdinal("TourPrice")) ? 0 : rdr.GetDecimal(rdr.GetOrdinal("TourPrice")); model.Travel = rdr.IsDBNull(rdr.GetOrdinal("Travel")) ? "" : rdr.GetString(rdr.GetOrdinal("Travel")); model.DayNum = rdr.IsDBNull(rdr.GetOrdinal("RouteInfo")) ? 0 : Utility.GetInt(GetValueByXml(rdr.GetString(rdr.GetOrdinal("RouteInfo")), "DayNum")); model.LateNum = rdr.IsDBNull(rdr.GetOrdinal("RouteInfo")) ? 0 : Utility.GetInt(GetValueByXml(rdr.GetString(rdr.GetOrdinal("RouteInfo")), "LateNum")); model.StartCityName = rdr.IsDBNull(rdr.GetOrdinal("RouteInfo")) ? "" : GetValueByXml(rdr.GetString(rdr.GetOrdinal("RouteInfo")), "StartCityName"); model.TravelName = rdr.IsDBNull(rdr.GetOrdinal("TravelName")) ? "" : rdr.GetString(rdr.GetOrdinal("TravelName")); model.CompanyType = (CompanyType)Enum.Parse(typeof(CompanyType), rdr["CompanyType"].ToString()); list.Add(model); } } return(list); }
/// <summary> /// 初始化页面 /// </summary> private void InitPage() { #region 配置用户控件 //配置上传用户控件 files.IsGenerateThumbnail = true; //标准报价包含用户控件配置 AddStandardRoute_ServiceStandard.ContainerID = Key; #endregion //线路区域类型名称 lbl_travelRangeName.Text = EyouSoft.Common.Utils.GetQueryStringValue("travelRangeName"); //绑定销售城市 SalesArea(); //绑定交通 BindTraffic(); //绑定推荐状态 BindRecommendType(false); //绑定线路区域主题 BindTheme(); //线路Id routeId = Utils.GetQueryStringValue("RouteId"); #region 修改-复制加载原有数据 if (routeId.Length > 0) { #region 页面赋值 //线路实体 MRoute model = EyouSoft.BLL.NewTourStructure.BRoute.CreateInstance().GetModel(routeId); //线路来源 routeSource = model.RouteSource; //专线类型 travelRangeId = model.AreaId; if (model != null) { //线路配图 if (model.RouteImg.Length > 0) { img_showImg.Src = EyouSoft.Common.Domain.FileSystem + model.RouteImg1; img_showImg.Visible = true; //a_showImg.HRef = EyouSoft.Common.Domain.FileSystem + model.RouteImg; //a_showImg.Visible = true; } #region 线路类型 //线路类型 travelRangeType = (int)model.RouteType; if (model.RouteType == AreaType.国际线) { #region 主要浏览国家 if (model.BrowseCountrys != null && model.BrowseCountrys.Count > 0) { //主要浏览国家个数 int i = model.BrowseCountrys.Count; //变量 string str = string.Empty, qzstr = string.Empty; //递减遍历主要浏览国家 while (i-- > 0) { //国家信息 str += model.BrowseCountrys[i].CountryId + ","; //签证信息 if (model.BrowseCountrys[i].IsVisa) { qzstr += model.BrowseCountrys[i].CountryId + ","; } } //国家信息 hd_BrowseCountrys.Value = str.Substring(0, str.Length - 1); //签证信息 if (qzstr.Length > 0) { hd_qz.Value = qzstr.Substring(0, qzstr.Length - 1); } } //免签 直接显示免签 if (model.IsNotVisa) { chk_null.Checked = true; hd_qz.Value = string.Empty; } //国际线路成人定金 txt_AdultDeposit.Text = model.AdultPrice < 0 ? string.Empty : Utils.FilterEndOfTheZeroDecimal(model.AdultPrice); //国际线路儿童定金 txt_ChildrenDeposit.Text = model.ChildrenPrice < 0 ? string.Empty : Utils.FilterEndOfTheZeroDecimal(model.ChildrenPrice); #endregion } else { #region 主要浏览城市 if (model.BrowseCitys != null && model.BrowseCitys.Count > 0) { //主要浏览城市个数 int i = model.BrowseCitys.Count; //变量 string str = string.Empty; //递减遍历主要浏览城市 while (i-- > 0) { /* * 保存主要浏览城市信息 * 存在县保存:县id|城市id, * 不存在县(城市)保存:城市id, * 最终用js拆分 */ if (model.BrowseCitys[i].CountyId > 0) { str += model.BrowseCitys[i].CountyId + "|" + model.BrowseCitys[i].CityId + ","; } else { str += model.BrowseCitys[i].CityId + ","; } } //主要浏览城市信息 hd_BrowseCitys.Value = str.Substring(0, str.Length - 1); } #endregion } #endregion #region 普通数据 //专线名称 lbl_travelRangeName.Text = model.AreaName; //线路名称 txt_LineName.Text = model.RouteName; //如果是推荐状态为 推荐 重新绑定推荐状态 if (model.RecommendType == RecommendType.推荐) { BindRecommendType(true); } //推荐状态 ddl_Status.SelectedValue = ((int)model.RecommendType).ToString(); //出发交通 ddl_DepartureTraffic.SelectedIndex = (int)model.StartTraffic - 1; //返回交通 ddl_ReturnTraffic.SelectedIndex = (int)model.EndTraffic - 1; //出发城市 hd_goCity.Value = model.StartCity + "|" + model.StartCityName; //返回城市 hd_returnCity.Value = model.EndCity + "|" + model.EndCityName; //线路特色 txt_LineFeatures.Value = model.Characteristic; //最小成团人数 txt_MinNumberPeople.Text = model.GroupNum.ToString(); //参考价 txt_ReferencePrice.Text = Utils.FilterEndOfTheZeroDecimal(model.IndependentGroupPrice); //住宿天数 txt_days.Text = model.Day.ToString(); //住宿夜数 txt_nights.Text = model.Late.ToString(); //提前几天报名 txt_EarlyDays.Text = model.AdvanceDayRegistration.ToString(); //散客报名无需成团,铁定发团 chk_FITRegistration.Checked = model.IsCertain; //简易版行程 txt_AddTourismBriefnessTravel.Value = model.FastPlan; //报价不包含 txt_PriceExcluding.Value = model.ServiceStandard.NotContainService; //赠送项目 txt_GiftItems.Value = model.ServiceStandard.GiftInfo; //儿童及其他安排 txt_OtherArr.Value = model.ServiceStandard.ChildrenInfo; //购物安排 txt_ShoppingArr.Value = model.ServiceStandard.ShoppingInfo; //自费项目 txt_ThisConsumption.Value = model.ServiceStandard.ExpenseItem; //销售须知 txt_Notes.Value = model.VendorsNotes; //备注 txt_Remarks.Value = model.ServiceStandard.Notes; //主题 hd_SubjectLine.Value = SetTheme(model.Themes); //销售区域 hd_SellCity.Value = SetSalesArea(model.Citys); #endregion #region 行程 //行程 if (model.ReleaseType == ReleaseType.Quick) { txt_AddTourismBriefnessTravel.Value = model.FastPlan; } else { if (model.StandardPlans != null && model.StandardPlans.Count > 0) { isTravel = true; rpt_standardPlans.DataSource = model.StandardPlans.OrderBy(r => r.PlanDay).ToList(); rpt_standardPlans.DataBind(); } } #endregion #region 报价 txt_FIT.Value = model.FitQuotation; AddStandardRoute_ServiceStandard.RouteServiceStandardInfo = model.ServiceStandard; //判断是否为团队 isServiceStandard = model.ServiceStandard.CarContent.Length > 0 || //用车 model.ServiceStandard.DinnerContent.Length > 0 || //用餐 model.ServiceStandard.ResideContent.Length > 0 || //住宿 model.ServiceStandard.SightContent.Length > 0 || //景点 model.ServiceStandard.TrafficContent.Length > 0 || //往返交通 model.ServiceStandard.GuideContent.Length > 0 || //导游 model.ServiceStandard.IncludeOtherContent.Length > 0; //其他包含 #endregion } #endregion //保存类型 SaveType = Utils.GetQueryStringValue("type"); if (SaveType == "copy") { //复制 //清空线路ID routeId = string.Empty; //清空线路名称 txt_LineName.Text = string.Empty; } } #endregion /* * 绑定出发返回城市 * 该方法需要根据线路区域类型显示不同的返回城市 * 为兼容添加与修改 * 该方法只能写在线路数据加载之后 */ BindCity(); /* * 绑定主要浏览国家或城市 * 该方法需要根据线路区域类型显示不同的返回城市 * 为兼容添加与修改 * 该方法只能写在线路数据加载之后 * 此方法与修改-复制原有数据中的代码无冲突 */ BindCountrysOrCity(); }