<%@ Page Language="C#" MasterPageFile="~/Main.master" AutoEventWireup="true" CodeFile="SprIspLocom.aspx.cs" Inherits="Default2" Title="Untitled Page" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>

<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" Runat="Server">
    <div id="SprName"> 
       <h3>Справка об использовании локомотивов</h3>
    </div>
 <div id="FilterForm">
     <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
      <asp:calendarextender ID="CalendarExtender1" runat="server" Animated="true" 
      PopupButtonID="Image1"
      TargetControlID="InvoiceDateTextBox" Format="yyyy-MM-dd" ></asp:calendarextender>     
     <table style="width: 100%">
         <tr>
             <td style="width: 168px">
                 <asp:Label ID="Label1" runat="server" style="font-weight: 700" 
                     Text="Временной период:"></asp:Label>
             </td>
             <td style="width: 168px">
                <asp:TextBox ID="InvoiceDateTextBox" runat="server" Height="18px" Width="166px"></asp:TextBox>
             </td>
             <td style="width: 75px">
                <asp:ImageButton ID="Image1" runat="Server" AlternateText="Нажмите чтобы открыть календарь"
                     ImageUrl="~/Images/imgCalen.png" Height="18px" ImageAlign="Middle" Width="18px" />
                </td>
             <td style="width: 46px">
                  </td>
             <td>
                  </td>
         </tr>
         <tr>
             <td style="width: 168px; height: 26px;">
                 <asp:Label ID="Label2" runat="server" style="font-weight: 700" Text="НОД:"></asp:Label>
             </td>
             <td style="width: 168px; height: 26px;">
                 <asp:DropDownList ID="ddlNOD" runat="server" Height="18px" Width="166px">
                 </asp:DropDownList>
             </td>
             <td style="width: 75px; height: 26px;">
                  </td>
             <td style="height: 26px; width: 46px">
                 <asp:Label ID="Label3" runat="server" style="font-weight: 700" Text="Депо:"></asp:Label>
             </td>
             <td style="height: 26px">
                 <asp:DropDownList ID="ddlDepo" runat="server" Height="18px" Width="166px">
                 </asp:DropDownList>
             </td>
         </tr>
         <tr>
             <td style="width: 168px">
                 <asp:Label ID="Label4" runat="server" style="font-weight: 700" Text="Вид тяги:"></asp:Label>
             </td>
             <td style="width: 168px">
                 <asp:DropDownList ID="ddlVT" runat="server" Height="18px" Width="166px">
                 </asp:DropDownList>
             </td>
             <td colspan="3">
                  </td>
         </tr>
         <tr>
             <td style="width: 168px">
                 <asp:Label ID="Label5" runat="server" style="font-weight: 700" 
                     Text="Вид движения:"></asp:Label>
             </td>
             <td style="width: 168px">
                 <asp:DropDownList ID="ddlVD" runat="server" Height="18px" Width="165px">
                 </asp:DropDownList>
             </td>
             <td colspan="3">
                  </td>
         </tr>
         <tr>
             <td style="width: 168px">
                  </td>
             <td style="width: 168px">
                  </td>
             <td style="width: 75px">
                  </td>
             <td style="width: 46px">
                  </td>
             <td>
                  </td>
         </tr>
         <tr>
             <td style="width: 168px">
                 <asp:Button ID="btnStart" runat="server" Text="Вывести" Width="143px" 
                     onclick="btnStart_Click" />
             </td>
             <td style="width: 168px">
                 <asp:Button ID="btnCancel" runat="server" Text="Сброс" Width="161px" 
                     onclick="btnCancel_Click" />
             </td>
             <td style="width: 75px">
                  </td>
             <td style="width: 46px">
                  </td>
             <td>
                  </td>
         </tr>
     </table>
 </div>
</asp:Content>

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!this.IsPostBack)
        {
            string tDate = String.Format("{0:yyyy-MM-dd}", DateTime.Now.AddDays(-1));
            InvoiceDateTextBox.Text = tDate;
            CalendarExtender1.SelectedDate = DateTime.Parse(tDate);

            LoadDataElem();
        }
    }

    protected void btnStart_Click(object sender, EventArgs e)
    {
        string ddmm = InvoiceDateTextBox.Text;
        string ru = ddlNOD.SelectedValue;
        string dpl = ddlDepo.SelectedValue;
        string vt = ddlVT.SelectedValue;
        string vd = ddlVD.SelectedValue;
        Response.Redirect("SprIspLocom_Result.aspx?ddmm=" + ddmm + "&ru=" + ru + "&dpl=" + dpl + "&vt=" + vt + "&vd=" + vd);
    }
    protected void btnCancel_Click(object sender, EventArgs e)
    {
        ddlNOD.SelectedIndex = 0;
        ddlDepo.SelectedIndex = 0;
        ddlVT.SelectedIndex = 0;
        ddlVD.SelectedIndex = 0;
    }

    protected void LoadDataElem()
    {
        char[] seps = { ':' };
        dalFormFilter dal = new dalFormFilter();
        foreach (string ru in dal.ru())
        {
            string[] s = ru.Split(seps);
            string ss = s[1]=="Все"? s[1] : s[0] + " - " + s[1];
            ddlNOD.Items.Add(new ListItem(ss, s[0]));
        }
        foreach (string dpl in dal.dpl())
        {
            string[] d = dpl.Split(seps);
            string dd = d[1] == "Все" ? d[1] : d[0] + " - " + d[1];
            ddlDepo.Items.Add(new ListItem(dd, d[0]));
        }
        foreach (string vt in dal.vt())
        {
            string[] t = vt.Split(seps);
            string tt = t[1] == "Все" ? t[1] : t[0] + " - " + t[1];
            ddlVT.Items.Add(new ListItem(tt, t[0]));
        }
        foreach (string vd in dal.vd())
        {
            string[] v = vd.Split(seps);
            string vv = v[1] == "Все" ? v[1] : v[0] + " - " + v[1];
            ddlVD.Items.Add(new ListItem(vv, v[0]));
        }
    }    
}