/// <summary> /// 获得页面数据 /// </summary> protected void GetDataList() { #region 价格组成 string[] sltPriceArray = Utils.GetFormValues("selectPrice"); string[] standardArray = Utils.GetFormValues("Standard"); string[] djPriceArrray = Utils.GetFormValues("txtDjPrice"); string[] wsPriceArray = Utils.GetFormValues("txtWsPrice"); string[] oneDjPrice = Utils.GetFormValues("oneDjPrice"); string[] oneDjCount = Utils.GetFormValues("oneDjCount"); string[] oneWsPrice = Utils.GetFormValues("oneWsPrice"); string[] oneWsCount = Utils.GetFormValues("oneWsCount"); this.TotalAmount = Utils.GetDecimal(Utils.GetFormValue(this.txtAllPrice.UniqueID)); //this.OnePriceAll = Utils.GetDecimal(Utils.GetFormValue(this.txtOnePriceAll.UniqueID)); this.cr_price = Utils.GetDecimal(txt_crPrice.Value); this.rt_price = Utils.GetDecimal(txt_rtPrice.Value); this.all_price = Utils.GetDecimal(txt_allPrice.Value); #endregion //if (sltPriceArray != null && sltPriceArray.Count() <= 0) //{ // Response.Write("<script>javascript:window.alert('请输入价格组成信息!')</script>"); // return; //} if (sltPriceArray != null && standardArray != null && djPriceArrray != null && wsPriceArray != null && oneDjPrice != null && oneDjCount != null && oneWsPrice != null && oneWsCount != null) { if (sltPriceArray.Count() == standardArray.Count() && djPriceArrray.Count() == wsPriceArray.Count() && sltPriceArray.Count() > 0 && oneDjPrice.Count() == oneDjCount.Count() && oneDjCount.Count() == oneWsPrice.Count() && oneWsPrice.Count() == oneWsCount.Count() && oneWsCount.Count() > 0) { IList <EyouSoft.Model.TourStructure.TourTeamServiceInfo> list = new List <EyouSoft.Model.TourStructure.TourTeamServiceInfo>(); for (int i = 0; i < sltPriceArray.Count(); i++) { if (sltPriceArray[i].Trim() != "-1") { EyouSoft.Model.TourStructure.TourTeamServiceInfo model = new EyouSoft.Model.TourStructure.TourTeamServiceInfo(); model.ServiceType = (EyouSoft.Model.EnumType.TourStructure.ServiceType)Enum.Parse(typeof(EyouSoft.Model.EnumType.TourStructure.ServiceType), sltPriceArray[i]); model.Service = standardArray[i]; model.LocalPrice = Utils.GetDecimal(djPriceArrray[i]); model.SelfPrice = Utils.GetDecimal(wsPriceArray[i]); model.LocalUnitPrice = Utils.GetDecimal(oneDjPrice[i]); model.LocalPeopleNumber = Utils.GetInt(oneDjCount[i]); model.SelfUnitPrice = Utils.GetDecimal(oneWsPrice[i]); model.SelfPeopleNumber = Utils.GetInt(oneWsCount[i]); list.Add(model); } } this.GetList = list; } } }
/// <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); }