/// <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);
}
