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