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