62,243
社区成员




<asp:datagrid id="dtgFlight" runat="server" Width="640px" GridLines="None" BorderColor="White"
CellPadding="0" BorderStyle="Ridge" BorderWidth="0px" BackColor="White" PageSize="5" AutoGenerateColumns="False">
<SelectedItemStyle Font-Bold="True" ForeColor="White" BackColor="#9471DE"></SelectedItemStyle>
<ItemStyle ForeColor="Black" BackColor="#DEDFDE"></ItemStyle>
<HeaderStyle Font-Bold="True" ForeColor="#E7E7FF" BackColor="#4A3C8C"></HeaderStyle>
<FooterStyle ForeColor="Black" BackColor="#C6C3C6"></FooterStyle>
<Columns>
<asp:TemplateColumn>
<HeaderTemplate>
<TABLE id="Table35" style="BORDER-RIGHT: #e6e6e6 1px solid; BORDER-TOP: medium none; BORDER-LEFT: #e6e6e6 1px solid; COLOR: white; BORDER-BOTTOM: #e6e6e6 1px solid; BORDER-COLLAPSE: collapse"
borderColor="white" cellSpacing="0" cellPadding="0" width="100%" bgColor="white" border="1">
<TR bgColor="#cccccc" height="23">
<TD align="center" width="3%">
<DIV style="CURSOR: hand" onclick="ShowAll();">+</DIV>
</TD>
<TD width="17%">航班号
</TD>
<TD width="20%">起飞城市
</TD>
<TD width="20%">到达城市
</TD>
<TD width="20%">起飞时间
</TD>
<TD width="20%">到达时间
</TD>
</TR>
</TABLE>
</HeaderTemplate>
<ItemTemplate>
<TABLE id="Table3" style="BORDER-RIGHT: #e6e6e6 1px solid; BORDER-TOP: medium none; BORDER-LEFT: #e6e6e6 1px solid; BORDER-BOTTOM: #e6e6e6 1px solid; BORDER-COLLAPSE: collapse"
borderColor="white" cellSpacing="0" cellPadding="0" width="100%" border="1">
<TR height="24">
<TD align="center" width="3%">
<DIV style="CURSOR: hand" onclick="ShowDetail(this);">+</DIV>
</TD>
<TD width="17%">
<asp:Label id=lblFlightName runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.FlightName") %>'>
</asp:Label></TD>
<TD width="20%">
<asp:Label id=lblDepartureCityName runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.DepartureCityName") %>'>
</asp:Label></TD>
<TD width="20%">
<asp:Label id=lblArrivalCityName runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.ArrivalCityName") %>'>
</asp:Label></TD>
<TD width="20%">
<asp:Label id=lblDepartureTime runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.DepartureTime") %>'>
</asp:Label></TD>
<TD width="20%">
<asp:Label id=lblArrivalTime runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.ArrivalTime") %>'>
</asp:Label></TD>
</TR>
<TR style="DISPLAY: none">
<TD width="3%" bgColor="white"></TD>
<TD align="center" colSpan="5">
<asp:datagrid id="dtgCabin" runat="server" Width="100%" CellPadding="1" BorderStyle="None" BorderWidth="0px"
BackColor="WhiteSmoke" PageSize="5" AutoGenerateColumns="False" CellSpacing="1">
<AlternatingItemStyle Height="18px"></AlternatingItemStyle>
<ItemStyle BackColor="White"></ItemStyle>
<HeaderStyle BackColor="Info"></HeaderStyle>
<Columns>
<asp:BoundColumn Visible="False" DataField="CabinId"></asp:BoundColumn>
<asp:BoundColumn DataField="CabinName" HeaderText="舱位代码">
<HeaderStyle Width="17%"></HeaderStyle>
</asp:BoundColumn>
<asp:BoundColumn DataField="Type" HeaderText="舱位种类">
<HeaderStyle Width="20%"></HeaderStyle>
</asp:BoundColumn>
<asp:BoundColumn DataField="RemainTickets" HeaderText="剩余票数">
<HeaderStyle Width="20%"></HeaderStyle>
</asp:BoundColumn>
<asp:BoundColumn DataField="Price" HeaderText="价格">
<HeaderStyle Width="20%"></HeaderStyle>
</asp:BoundColumn>
<asp:BoundColumn DataField="Discount" HeaderText="折扣">
<HeaderStyle Width="20%"></HeaderStyle>
</asp:BoundColumn>
</Columns>
<PagerStyle HorizontalAlign="Right" BackColor="White" Mode="NumericPages"></PagerStyle>
</asp:datagrid></TD>
</TR>
</TABLE>
</ItemTemplate>
<EditItemTemplate>
<FONT face="宋体"></FONT>
</EditItemTemplate>
</asp:TemplateColumn>
</Columns>
<PagerStyle HorizontalAlign="Right" ForeColor="Black" BackColor="#C6C3C6"></PagerStyle>
</asp:datagrid>
public class QueryFlight : System.Web.UI.Page
{
protected System.Web.UI.WebControls.TextBox txtBeginDate;
protected System.Web.UI.WebControls.TextBox txtEndDate;
protected System.Web.UI.WebControls.DropDownList ddlDepartureCity;
protected System.Web.UI.WebControls.ImageButton btnSearch;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
protected System.Web.UI.WebControls.ValidationSummary ValidationSummary1;
protected System.Web.UI.WebControls.CompareValidator CompareValidator1;
protected System.Web.UI.WebControls.CompareValidator CompareValidator2;
protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator1;
protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator2;
protected System.Web.UI.WebControls.DataGrid dtgFlight;
protected System.Web.UI.WebControls.DropDownList ddlArrivalCity;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if(!Page.IsPostBack)
{
GetAllCity();
}
}
private void GetAllCity()
{
Citys citys = new Citys();
CityData cityData = new CityData();
try
{
cityData = citys.GetAllCity();
}
catch(Exception e)
{
Response.Write(e.Message + ",内部错误:" + e.InnerException.Message);
}
ddlDepartureCity.DataSource = cityData.City;
ddlDepartureCity.DataTextField = cityData.City.CityNameColumn.ColumnName;
ddlDepartureCity.DataValueField = cityData.City.CityIdColumn.ColumnName;
ddlDepartureCity.DataBind();
ddlArrivalCity.DataSource = cityData.City;
ddlArrivalCity.DataTextField = cityData.City.CityNameColumn.ColumnName;
ddlArrivalCity.DataValueField = cityData.City.CityIdColumn.ColumnName;
ddlArrivalCity.DataBind();
}
private void GetFlight()
{
Flights.Condition condition = new Air.Class.Flights.Condition();
condition._ArrivalCityId = Convert.ToInt32(ddlArrivalCity.SelectedValue);
condition._DepartureCityId = Convert.ToInt32(ddlDepartureCity.SelectedValue);
condition._BeginDate = Convert.ToDateTime(txtBeginDate.Text);
condition._EndDate = Convert.ToDateTime(txtEndDate.Text);
Flights flights = new Flights();
FlightData flightData = new FlightData();
try
{
flightData = flights.GetFlights(condition);
}
catch(Exception e)
{
Response.Write(e.Message + ",内部错误:" + e.InnerException.Message);
}
dtgFlight.DataSource = flightData.Flight;
dtgFlight.DataBind();
for(int i =0; i < dtgFlight.Items.Count; i ++)
{
DataGrid dtgCabin = (DataGrid)dtgFlight.Items[i].FindControl("dtgCabin");
dtgCabin.DataSource = flightData.Flight[i].GetCabinRowsByFlightCabin();
dtgCabin.DataBind();
}
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.btnSearch.Click += new System.Web.UI.ImageClickEventHandler(this.btnSearch_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void btnSearch_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
GetFlight();
}