/// <summary>
/// 根据团队票编号获取乘客信息
/// </summary>
/// <param name="groupTicketID">团队票编号</param>
/// <returns>乘客信息集合</returns>
public IList <EyouSoft.Model.TicketStructure.PassengerInformation> GetPassengerInformation(int groupTicketID)
{
IList <EyouSoft.Model.TicketStructure.PassengerInformation> list = new List <EyouSoft.Model.TicketStructure.PassengerInformation>();
EyouSoft.Model.TicketStructure.PassengerInformation item = null;
DbCommand comm = this._database.GetSqlStringCommand(SQL_PassengerInformation_GetPassengerInformation);
this._database.AddInParameter(comm, "@GroupTicketsID", DbType.Int32, groupTicketID);
using (IDataReader reader = DbHelper.ExecuteReader(comm, this._database))
{
while (reader.Read())
{
item = new EyouSoft.Model.TicketStructure.PassengerInformation()
{
ID = (int)reader["ID"],
GroupTicketsID = (int)reader["GroupTicketsID"],
UName = reader.IsDBNull(reader.GetOrdinal("UName")) ? "" : reader["UName"].ToString(),
DocumentNo = reader.IsDBNull(reader.GetOrdinal("DocumentNo")) ? "" : reader["DocumentNo"].ToString(),
Mobile = reader.IsDBNull(reader.GetOrdinal("Mobile")) ? "" : reader["Mobile"].ToString()
};
if (!reader.IsDBNull(reader.GetOrdinal("PassengerType")))
{
item.PassengerType = (EyouSoft.Model.TicketStructure.PassengerType)Enum.Parse(typeof(EyouSoft.Model.TicketStructure.PassengerType), reader["PassengerType"].ToString());
}
if (!reader.IsDBNull(reader.GetOrdinal("DocumentType")))
{
item.DocumentType = (EyouSoft.Model.TicketStructure.DocumentType)Enum.Parse(typeof(EyouSoft.Model.TicketStructure.DocumentType), reader["DocumentType"].ToString());
}
list.Add(item);
}
}
return(list);
}
protected void Page_Load(object sender, EventArgs e)
{
(this.Master as UserPublicCenter.MasterPage.NewPublicCenter).HeadMenuIndex = 3;
Utils.AddStylesheetInclude(CssManage.GetCssFilePath("index2011"));
Utils.AddStylesheetInclude(CssManage.GetCssFilePath("InformationStyle"));
if (Utils.GetFormValue("hidSave") == "save")
{
EyouSoft.Model.TicketStructure.GroupTickets model = new EyouSoft.Model.TicketStructure.GroupTickets();
int airType = Utils.GetInt(Request.Form["selAirCompany"]);//获取航空公司
if (airType > 0)
{
model.AirlinesType = (EyouSoft.Model.TicketStructure.AirlinesType)airType;
}
model.Contact = Utils.GetFormValue("txtContacter");
model.ContactQQ = Utils.GetFormValue("txtQQ");
model.Email = Utils.GetFormValue("txtEmail");
model.EndCity = Utils.GetFormValue("txtEndCity");
model.FlightNumber = Utils.GetFormValue("txtNo");
model.GroupType = (EyouSoft.Model.TicketStructure.GroupType)Utils.GetInt(Request.Form["rdiType"], 1);
model.HopesPrice = Utils.GetDecimal(Request.Form["txtPrice"]);
model.IssueTime = DateTime.Now;
model.Notes = Utils.GetFormValue("txtReamrk", 500);
model.PelopeCount = Utils.GetInt(Request.Form["txtNum"]);
if (model.PelopeCount < 10)
{
Utils.ShowAndRedirect("预订失败，人数不正确！", this.Request.Url.ToString());
}
model.Phone = Utils.GetFormValue("txtTel");
model.StartCity = Utils.GetFormValue("txtStartCity");
model.StartTime = Utils.GetFormValue("txtStartDate");
model.TimeRange = Utils.GetFormValue("selSTime") + "—" + Utils.GetFormValue("selETime");
string[] names = Utils.GetFormValues("txtName");
string[] pTypes = Utils.GetFormValues("selpType");
string[] cTypes = Utils.GetFormValues("selcType");
string[] cNos = Utils.GetFormValues("txtcNo");
string[] mobiles = Utils.GetFormValues("txtMobile");
if (names != null && names.Length > 0)
{
IList <EyouSoft.Model.TicketStructure.PassengerInformation> passengerList = new List <EyouSoft.Model.TicketStructure.PassengerInformation>();
for (int i = 0; i < names.Length; i++)
{
EyouSoft.Model.TicketStructure.PassengerInformation passenger = new EyouSoft.Model.TicketStructure.PassengerInformation();
passenger.DocumentNo = cNos[i];
passenger.DocumentType = (EyouSoft.Model.TicketStructure.DocumentType)Utils.GetInt(cTypes[i], 1);
passenger.Mobile = mobiles[i];
passenger.PassengerType = (EyouSoft.Model.TicketStructure.PassengerType)Utils.GetInt(pTypes[i], 1);
passenger.UName = names[i];
passengerList.Add(passenger);
}
model.PassengerInformationList = passengerList;
}
if (EyouSoft.BLL.TicketStructure.GroupTickets.CreateInstance().AddGroupTickets(model))
{
Utils.ShowAndRedirect("预订成功！", this.Request.Url.ToString());
}
else
{
Utils.ShowAndRedirect("预订失败！", this.Request.Url.ToString());
}
}
}
