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