/// <summary> /// 获得页面数据 /// </summary> protected void GetDataList() { string[] sltProjectArray = Utils.GetFormValues("ddl_Project"); string[] ProjectArray = Utils.GetFormValues("Txt_XianlProject"); if (sltProjectArray == null && sltProjectArray.Count() <= 0) { Response.Write("<script>javascript:window.alert('请选择包含项目!')</script>"); return; } if (sltProjectArray != null && ProjectArray != null) { if (sltProjectArray.Count() == ProjectArray.Count() && sltProjectArray.Count() > 0) { IList <EyouSoft.Model.TourStructure.TourServiceInfo> TourServiceInfoList = new List <EyouSoft.Model.TourStructure.TourServiceInfo>(); for (int i = 0; i < sltProjectArray.Count(); i++) { EyouSoft.Model.TourStructure.TourServiceInfo ModelTourServiceInfo = new EyouSoft.Model.TourStructure.TourServiceInfo(); ModelTourServiceInfo.Service = ProjectArray[i]; ModelTourServiceInfo.ServiceType = (EyouSoft.Model.EnumType.TourStructure.ServiceType)Enum.Parse(typeof(EyouSoft.Model.EnumType.TourStructure.ServiceType), sltProjectArray[i]); TourServiceInfoList.Add(ModelTourServiceInfo); } this.GetList = TourServiceInfoList; } } }
/// <summary> /// 获得页面数据 /// </summary> public IList <EyouSoft.Model.TourStructure.TourServiceInfo> GetDataList() { IList <EyouSoft.Model.TourStructure.TourServiceInfo> list = new List <EyouSoft.Model.TourStructure.TourServiceInfo>(); #region 包含项目 //项目 string[] sltProArray = Utils.GetFormValues("selectPro"); //接待标准 string[] StandardArray = Utils.GetFormValues("txtStandard"); if (sltProArray != null && StandardArray != null) { if (sltProArray.Count() == StandardArray.Count() && sltProArray.Count() > 0) { for (int i = 0; i < sltProArray.Count(); i++) { EyouSoft.Model.TourStructure.TourServiceInfo model = new EyouSoft.Model.TourStructure.TourServiceInfo(); model.Service = Utils.GetFormValues("txtStandard")[i]; model.ServiceType = (EyouSoft.Model.EnumType.TourStructure.ServiceType)Utils.GetInt(Utils.GetFormValues("selectPro")[i]); list.Add(model); } } } return(list); #endregion }
/// <summary> /// 获取线路报价信息实体 /// </summary> /// <param name="QuoteId">线路报价信息编号</param> /// <returns></returns> public EyouSoft.Model.RouteStructure.QuoteTeamInfo GetQuoteInfo(int QuoteId) { EyouSoft.Model.RouteStructure.QuoteTeamInfo model = null; DbCommand dc = this._db.GetStoredProcCommand("proc_RouteQuote_SelectQuoteInfo"); this._db.AddInParameter(dc, "Id", DbType.Int32, QuoteId); using (IDataReader dr = DbHelper.RunReaderProcedure(dc, this._db)) { if (dr.Read()) { model = new EyouSoft.Model.RouteStructure.QuoteTeamInfo(); #region 线路报价基本信息 if (!dr.IsDBNull(dr.GetOrdinal("AdultNum"))) { model.AdultNum = dr.GetInt32(dr.GetOrdinal("AdultNum")); } if (!dr.IsDBNull(dr.GetOrdinal("ChildNum"))) { model.ChildNum = dr.GetInt32(dr.GetOrdinal("ChildNum")); } if (!dr.IsDBNull(dr.GetOrdinal("ContactName"))) { model.ContactName = dr.GetString(dr.GetOrdinal("ContactName")); } if (!dr.IsDBNull(dr.GetOrdinal("ContactTel"))) { model.ContactTel = dr.GetString(dr.GetOrdinal("ContactTel")); } if (!dr.IsDBNull(dr.GetOrdinal("IssueTime"))) { model.CreateTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); } if (!dr.IsDBNull(dr.GetOrdinal("LocalQuoteSum"))) { model.LocalQuoteSum = dr.GetDecimal(dr.GetOrdinal("LocalQuoteSum")); } if (!dr.IsDBNull(dr.GetOrdinal("OperatorId"))) { model.OperatorId = dr.GetInt32(dr.GetOrdinal("OperatorId")); } if (!dr.IsDBNull(dr.GetOrdinal("PeopleNum"))) { model.PeopleNum = dr.GetInt32(dr.GetOrdinal("PeopleNum")); } if (!dr.IsDBNull(dr.GetOrdinal("Id"))) { model.QuoteId = dr.GetInt32(dr.GetOrdinal("Id")); } if (!dr.IsDBNull(dr.GetOrdinal("QuoteUnitsName"))) { model.QuoteUnitsName = dr.GetString(dr.GetOrdinal("QuoteUnitsName")); } if (!dr.IsDBNull(dr.GetOrdinal("Remark"))) { model.Remark = dr.GetString(dr.GetOrdinal("Remark")); } if (!dr.IsDBNull(dr.GetOrdinal("RouteId"))) { model.RouteId = dr.GetInt32(dr.GetOrdinal("RouteId")); } if (!dr.IsDBNull(dr.GetOrdinal("MyQuoteSum"))) { model.SelfQuoteSum = dr.GetDecimal(dr.GetOrdinal("MyQuoteSum")); } if (!dr.IsDBNull(dr.GetOrdinal("TicketAgio"))) { model.TicketAgio = dr.GetDecimal(dr.GetOrdinal("TicketAgio")); } if (!dr.IsDBNull(dr.GetOrdinal("TmpLeaveDate"))) { model.TmpLeaveDate = dr.GetDateTime(dr.GetOrdinal("TmpLeaveDate")); } if (!dr.IsDBNull(dr.GetOrdinal("QuoteUnitsId"))) { model.QuoteUnitsId = dr.GetInt32(dr.GetOrdinal("QuoteUnitsId")); } #endregion #region 线路报价客户要求信息 IList <EyouSoft.Model.TourStructure.TourServiceInfo> ServiceList = new List <EyouSoft.Model.TourStructure.TourServiceInfo>(); dr.NextResult(); while (dr.Read()) { EyouSoft.Model.TourStructure.TourServiceInfo ServiceModel = new EyouSoft.Model.TourStructure.TourServiceInfo(); if (!dr.IsDBNull(dr.GetOrdinal("ConcreteAsk"))) { ServiceModel.Service = dr[dr.GetOrdinal("ConcreteAsk")].ToString(); } if (!dr.IsDBNull(dr.GetOrdinal("ItemType"))) { ServiceModel.ServiceType = (EyouSoft.Model.EnumType.TourStructure.ServiceType) int.Parse(dr[dr.GetOrdinal("ItemType")].ToString()); } ServiceList.Add(ServiceModel); ServiceModel = null; } model.Requirements = ServiceList; #endregion #region 线路报价明细信息 dr.NextResult(); IList <EyouSoft.Model.TourStructure.TourTeamServiceInfo> TeamService = new List <EyouSoft.Model.TourStructure.TourTeamServiceInfo>(); while (dr.Read()) { EyouSoft.Model.TourStructure.TourTeamServiceInfo TeamServiceModel = new EyouSoft.Model.TourStructure.TourTeamServiceInfo(); if (!dr.IsDBNull(dr.GetOrdinal("LocalQuote"))) { TeamServiceModel.LocalPrice = dr.GetDecimal(dr.GetOrdinal("LocalQuote")); } if (!dr.IsDBNull(dr.GetOrdinal("MyQuote"))) { TeamServiceModel.SelfPrice = dr.GetDecimal(dr.GetOrdinal("MyQuote")); } if (!dr.IsDBNull(dr.GetOrdinal("Reception"))) { TeamServiceModel.Service = dr.GetString(dr.GetOrdinal("Reception")); } if (!dr.IsDBNull(dr.GetOrdinal("ItemId"))) { TeamServiceModel.ServiceType = (EyouSoft.Model.EnumType.TourStructure.ServiceType) int.Parse(dr[dr.GetOrdinal("ItemId")].ToString()); } TeamServiceModel.LocalPeopleNumber = dr.GetInt32(dr.GetOrdinal("LocalPeopleNumber")); TeamServiceModel.LocalUnitPrice = dr.GetDecimal(dr.GetOrdinal("LocalUnitPrice")); TeamServiceModel.SelfPeopleNumber = dr.GetInt32(dr.GetOrdinal("SelfPeopleNumber")); TeamServiceModel.SelfUnitPrice = dr.GetDecimal(dr.GetOrdinal("SelfUnitPrice")); TeamService.Add(TeamServiceModel); TeamServiceModel = null; } model.Services = TeamService; #endregion } } return(model); }
/// <summary> /// <summary> /// 获取询价报价实体 /// </summary> /// <param name="Id">主键编号</param> /// <param name="CompanyId">专线公司编号</param> /// <param name="CustomerId">组团公司编号</param> /// <param name="isZhuTuan">是否组团端,1是,0不是</param> /// <returns></returns> public EyouSoft.Model.TourStructure.LineInquireQuoteInfo GetQuoteModel(int Id, int CompanyId, int CustomerId, int isZhuTuan) { EyouSoft.Model.TourStructure.LineInquireQuoteInfo model = null; DbCommand dc = this.DB.GetStoredProcCommand("proc_Tour_GetInquireQuote"); this.DB.AddInParameter(dc, "CompanyId", DbType.Int32, CompanyId); this.DB.AddInParameter(dc, "CustomerId", DbType.Int32, CustomerId); this.DB.AddInParameter(dc, "isZhuTuan", DbType.Int32, isZhuTuan); this.DB.AddInParameter(dc, "Id", DbType.Int32, Id); using (IDataReader dr = DbHelper.RunReaderProcedure(dc, this.DB)) { if (dr.Read()) { #region 询价报价基本信息 model = new EyouSoft.Model.TourStructure.LineInquireQuoteInfo(); model.Id = dr.GetInt32(dr.GetOrdinal("Id")); model.CompanyId = dr.IsDBNull(dr.GetOrdinal("CompanyId")) ? 0 : dr.GetInt32(dr.GetOrdinal("CompanyId")); model.RouteId = dr.IsDBNull(dr.GetOrdinal("RouteId")) ? 0 : dr.GetInt32(dr.GetOrdinal("RouteId")); model.RouteName = dr["RouteName"].ToString(); model.CustomerId = dr.IsDBNull(dr.GetOrdinal("CustomerId")) ? 0 : dr.GetInt32(dr.GetOrdinal("CustomerId")); model.CustomerName = dr["CustomerName"].ToString(); model.ContactName = dr["ContactName"].ToString(); model.ContactTel = dr["ContactTel"].ToString(); model.LeaveDate = dr.IsDBNull(dr.GetOrdinal("LeaveDate")) ? System.DateTime.Now : dr.GetDateTime(dr.GetOrdinal("LeaveDate")); model.AdultNumber = dr.IsDBNull(dr.GetOrdinal("AdultNumber")) ? 0 : dr.GetInt32(dr.GetOrdinal("AdultNumber")); model.ChildNumber = dr.IsDBNull(dr.GetOrdinal("ChildNumber")) ? 0 : dr.GetInt32(dr.GetOrdinal("ChildNumber")); model.PeopleNum = model.AdultNumber + model.ChildNumber; model.SpecialClaim = dr["SpecialClaim"].ToString(); model.TicketAgio = dr.IsDBNull(dr.GetOrdinal("TicketAgio")) ? 0 : dr.GetDecimal(dr.GetOrdinal("TicketAgio")); model.IssueTime = dr.IsDBNull(dr.GetOrdinal("IssueTime")) ? System.DateTime.Now : dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.QuoteState = (EyouSoft.Model.EnumType.TourStructure.QuoteState)dr.GetByte(dr.GetOrdinal("QuoteState")); model.Remark = dr["Remark"].ToString(); model.BuildTourId = dr["BuildTourId"].ToString(); model.TotalAmount = dr.GetDecimal(dr.GetOrdinal("TotalAmount")); model.Traveller = new EyouSoft.Model.TourStructure.TourEverydayApplyTravellerInfo(); model.Traveller.TravellerDisplayType = (EyouSoft.Model.EnumType.TourStructure.CustomerDisplayType)dr.GetByte(dr.GetOrdinal("TravellerDisplayType")); model.Traveller.TravellerFilePath = dr["TravellerFilePath"].ToString(); model.Traveller.Travellers = new List <EyouSoft.Model.TourStructure.TourOrderCustomer>(); #endregion #region 行程要求 EyouSoft.Model.TourStructure.XingChengMust XingChengMust = null; dr.NextResult(); if (dr.Read()) { XingChengMust = new EyouSoft.Model.TourStructure.XingChengMust() { QuoteId = dr.IsDBNull(dr.GetOrdinal("QuoteId")) ? 0 : dr.GetInt32(dr.GetOrdinal("QuoteId")), QuotePlan = dr["QuotePlan"].ToString(), PlanAccessory = dr["PlanAccessory"].ToString(), PlanAccessoryName = dr["PlanAccessoryName"].ToString() }; } model.XingCheng = XingChengMust; #endregion #region 客人要求信息集合 IList <EyouSoft.Model.TourStructure.TourServiceInfo> TourServiceInfoList = new List <EyouSoft.Model.TourStructure.TourServiceInfo>(); EyouSoft.Model.TourStructure.TourServiceInfo TourServiceInfo = null; dr.NextResult(); while (dr.Read()) { TourServiceInfo = new EyouSoft.Model.TourStructure.TourServiceInfo() { Service = dr["ConcreteAsk"].ToString(), ServiceType = (EyouSoft.Model.EnumType.TourStructure.ServiceType)dr.GetInt32(dr.GetOrdinal("ItemType")) }; TourServiceInfoList.Add(TourServiceInfo); } model.Requirements = TourServiceInfoList; #endregion #region 价格组成信息集合 IList <EyouSoft.Model.TourStructure.TourTeamServiceInfo> TourTeamServiceInfoList = new List <EyouSoft.Model.TourStructure.TourTeamServiceInfo>(); EyouSoft.Model.TourStructure.TourTeamServiceInfo TourTeamServiceInfo = null; dr.NextResult(); while (dr.Read()) { TourTeamServiceInfo = new EyouSoft.Model.TourStructure.TourTeamServiceInfo() { Service = dr["Reception"].ToString(), LocalPrice = dr.IsDBNull(dr.GetOrdinal("LocalQuote")) ? 0 : dr.GetDecimal(dr.GetOrdinal("LocalQuote")), SelfPrice = dr.IsDBNull(dr.GetOrdinal("MyQuote")) ? 0 : dr.GetDecimal(dr.GetOrdinal("MyQuote")), ServiceType = (EyouSoft.Model.EnumType.TourStructure.ServiceType)dr.GetInt32(dr.GetOrdinal("ItemId")), LocalPeopleNumber = dr.GetInt32(dr.GetOrdinal("LocalPeopleNumber")), LocalUnitPrice = dr.GetDecimal(dr.GetOrdinal("LocalUnitPrice")), SelfPeopleNumber = dr.GetInt32(dr.GetOrdinal("SelfPeopleNumber")), SelfUnitPrice = dr.GetDecimal(dr.GetOrdinal("SelfUnitPrice")) }; TourTeamServiceInfoList.Add(TourTeamServiceInfo); } model.Services = TourTeamServiceInfoList; #endregion #region 游客信息 if (dr.NextResult() && model != null) { while (dr.Read()) { EyouSoft.Model.TourStructure.TourOrderCustomer traveller = new EyouSoft.Model.TourStructure.TourOrderCustomer() { ID = dr.GetString(dr.GetOrdinal("TravellerId")), VisitorName = dr["TravellerName"].ToString(), CradType = (EyouSoft.Model.EnumType.TourStructure.CradType)dr.GetByte(dr.GetOrdinal("CertificateType")), CradNumber = dr["CertificateCode"].ToString(), Sex = (EyouSoft.Model.EnumType.CompanyStructure.Sex)dr.GetByte(dr.GetOrdinal("Gender")), VisitorType = (EyouSoft.Model.EnumType.TourStructure.VisitorType)dr.GetByte(dr.GetOrdinal("TravellerType")), ContactTel = dr["Telephone"].ToString(), }; traveller.SpecialServiceInfo = new EyouSoft.Model.TourStructure.CustomerSpecialService() { CustormerId = traveller.ID, Fee = !dr.IsDBNull(dr.GetOrdinal("Fee")) ? dr.GetDecimal(dr.GetOrdinal("Fee")) : 0, IsAdd = !dr.IsDBNull(dr.GetOrdinal("IsAdd")) ? dr.GetByte(dr.GetOrdinal("IsAdd")) == 1 ? true : false : false, ProjectName = dr["ServiceName"].ToString(), ServiceDetail = dr["ServiceDetail"].ToString() }; model.Traveller.Travellers.Add(traveller); } } #endregion } } return(model); }