/// <summary> /// 绑定机票咨询列表信息 /// </summary> private void BindTicketList() { string Title = Utils.InputText(Server.UrlDecode(Request.QueryString["Title"])); int Type = Utils.GetInt(Request.QueryString["Type"]); string ContactName = Utils.InputText(Server.UrlDecode(Request.QueryString["ContactName"])); DateTime?StartDate = Utils.GetDateTimeNullable(Request.QueryString["StartDate"]); if (!string.IsNullOrEmpty(Title)) { this.txtTitle.Value = Title; } EyouSoft.Model.TicketStructure.VoyageType VoyageType = EyouSoft.Model.TicketStructure.VoyageType.所有; if (Type > 0) { this.dropType.SelectedValue = Type.ToString(); switch (Type) { case 1: VoyageType = EyouSoft.Model.TicketStructure.VoyageType.单程; break; case 2: VoyageType = EyouSoft.Model.TicketStructure.VoyageType.往返程; break; case 3: VoyageType = EyouSoft.Model.TicketStructure.VoyageType.缺口程; break; } } if (!string.IsNullOrEmpty(ContactName)) { this.txtContactName.Value = ContactName; } if (StartDate != null) { this.txtStartDate.Value = StartDate.Value.ToShortDateString(); } int recordCount = 0; EyouSoft.Model.TicketStructure.QueryTicketApply TicketModel = new EyouSoft.Model.TicketStructure.QueryTicketApply(); TicketModel.Title = Title; TicketModel.VoyageType = VoyageType; TicketModel.ContactName = ContactName; TicketModel.TakeOffDateStart = StartDate; IList <EyouSoft.Model.TicketStructure.TicketApply> TicketList = EyouSoft.BLL.TicketStructure.TicketApply.CreateInstance().GetList(TicketModel, PageSize, PageIndex, ref recordCount); if (recordCount > 0) { this.ExportPageInfo1.intPageSize = PageSize; this.ExportPageInfo1.intRecordCount = recordCount; this.ExportPageInfo1.CurrencyPage = PageIndex; this.ExportPageInfo1.PageLinkURL = Request.ServerVariables["SCRIPT_NAME"].ToString() + "?"; this.ExportPageInfo1.UrlParams = Request.QueryString; this.repTicketList.DataSource = TicketList; this.repTicketList.DataBind(); } else { this.repTicketList.EmptyText = "<tr><td height='100px' align='center' colspan='10'>暂无记录</td></tr>"; this.ExportPageInfo1.Visible = false; } TicketModel = null; TicketList = null; }
/// <summary> /// 获得申请的列表 /// </summary> /// <param name="query">查询实体</param> /// <param name="pageSize">分页大小</param> /// <param name="pageIndex">当前页</param> /// <param name="recordCount">总的记录数</param> /// <returns></returns> public IList <EyouSoft.Model.TicketStructure.TicketApply> GetList(EyouSoft.Model.TicketStructure.QueryTicketApply query, int pageSize, int pageIndex, ref int recordCount) { return(idal.GetList(query, pageSize, pageIndex, ref recordCount)); }
/// <summary> /// 获得申请的列表 /// </summary> /// <param name="query">查询条件实体</param> /// <param name="pageSize">分页大小</param> /// <param name="pageIndex">当前页</param> /// <param name="recordCount">总的记录数</param> /// <returns></returns> public virtual IList <EyouSoft.Model.TicketStructure.TicketApply> GetList(EyouSoft.Model.TicketStructure.QueryTicketApply query, int pageSize, int pageIndex, ref int recordCount) { IList <EyouSoft.Model.TicketStructure.TicketApply> list = new List <EyouSoft.Model.TicketStructure.TicketApply>(); string tableName = "Ticket_Apply"; string fields = "ID,TicketArticleID,TicketArticleTitle,VoyageType,PeopleNum,TakeOffDate,ReturnDate,CountryType,Remark,CompanyName,ContactName,CompanyTel,CompanyAddress,IssueTime,UpdateTime,State"; string primaryKey = "ID"; string orderByString = "IssueTime desc"; StringBuilder strWhere = new StringBuilder("1=1"); #region 查询拼接 if (query != null) { if (!string.IsNullOrEmpty(query.Title)) { strWhere.AppendFormat(" AND TicketArticleTitle like '%{0}%' ", query.Title); } if (!string.IsNullOrEmpty(query.ContactName)) { strWhere.AppendFormat(" AND ContactName like '%{0}%' ", query.ContactName); } if (query.TakeOffDateStart.HasValue) { strWhere.AppendFormat(" AND DATEDIFF(dd, TakeOffDate, '{0}')=0", query.TakeOffDateStart.Value.ToString("yyyy-MM-dd")); } /* * if (query.TakeOffDateStart.HasValue) * strWhere.AppendFormat(" AND TakeOffDate>='{0}'", query.TakeOffDateStart.Value.ToString("yyyy-MM-dd")); * * if (query.TakeOffDateEnd.HasValue) * strWhere.AppendFormat(" AND TakeOffDate<='{0}'", query.TakeOffDateEnd.Value.AddDays(1).AddMilliseconds(-1)); */ if (query.VoyageType != EyouSoft.Model.TicketStructure.VoyageType.所有) { strWhere.AppendFormat(" AND VoyageType={0}", Convert.ToByte(query.VoyageType)); } } #endregion using (IDataReader dr = DbHelper.ExecuteReader(this._database, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields, strWhere.ToString(), orderByString)) { while (dr.Read()) { EyouSoft.Model.TicketStructure.TicketApply model = new EyouSoft.Model.TicketStructure.TicketApply(); model.ApplyId = dr.GetString(dr.GetOrdinal("ID")); model.TicketArticleID = dr.IsDBNull(dr.GetOrdinal("TicketArticleID")) ? "" : dr.GetString(dr.GetOrdinal("TicketArticleID")); model.TicketArticleTitle = dr.IsDBNull(dr.GetOrdinal("TicketArticleTitle")) ? "" : dr.GetString(dr.GetOrdinal("TicketArticleTitle")); model.TicketFlight.VoyageSet = (EyouSoft.Model.TicketStructure.VoyageType)Enum.Parse(typeof(EyouSoft.Model.TicketStructure.VoyageType), dr.GetByte(dr.GetOrdinal("VoyageType")).ToString()); model.TicketFlight.PeopleNumber = dr.GetInt32(dr.GetOrdinal("PeopleNum")); if (!dr.IsDBNull(dr.GetOrdinal("TakeOffDate"))) { model.TicketFlight.TakeOffDate = dr.GetDateTime(dr.GetOrdinal("TakeOffDate")); } if (!dr.IsDBNull(dr.GetOrdinal("ReturnDate"))) { model.TicketFlight.ReturnDate = dr.GetDateTime(dr.GetOrdinal("ReturnDate")); } model.TicketFlight.PeopleCountryType = (EyouSoft.Model.TicketStructure.PeopleCountryType)Enum.Parse(typeof(EyouSoft.Model.TicketStructure.PeopleCountryType), dr.GetByte(dr.GetOrdinal("CountryType")).ToString()); //model.Remark = dr.IsDBNull(dr.GetOrdinal("Remark")) ? "" : dr.GetString(dr.GetOrdinal("Remark")); model.CompanyName = dr.IsDBNull(dr.GetOrdinal("CompanyName")) ? "" : dr.GetString(dr.GetOrdinal("CompanyName")); model.ContactName = dr.IsDBNull(dr.GetOrdinal("ContactName")) ? "" : dr.GetString(dr.GetOrdinal("ContactName")); model.CompanyTel = dr.IsDBNull(dr.GetOrdinal("CompanyTel")) ? "" : dr.GetString(dr.GetOrdinal("CompanyTel")); //model.CompanyAddress = dr.IsDBNull(dr.GetOrdinal("CompanyAddress")) ? "" : dr.GetString(dr.GetOrdinal("CompanyAddress")); list.Add(model); model = null; } } return(list); }