OA系统

开发平台：
ASP/ASPX

edit_deal.aspx：源码内容
							﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="edit_deal.aspx.cs" Inherits="web_data_repair_select_edit_deal" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>无标题页</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:MultiView ID="MultiView1" runat="server" ActiveViewIndex="0">
            <asp:View ID="View3" runat="server">
                          <table border="1" width="651">
              <tr align="left">
              <td style="background-color: transparent; background-image: none;">
              <span>选择门店</span></td>
              <td style="background-color: transparent; background-image: none;">
                  <asp:DropDownList ID="dl_department" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource1" DataTextField="name" DataValueField="id" Width="198px" AppendDataBoundItems="True">
                      <asp:ListItem Value="-1">所有门店</asp:ListItem>
                  </asp:DropDownList>
                                <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:oa1ConnectionString %>" SelectCommand="SELECT id, name FROM OA_DEPARTMENT WHERE (CHARINDEX('店', name) > 0)"></asp:SqlDataSource>
              </td>
              </tr>
              <tr align="left">
              <td style="background-color: transparent; background-image: none;">
              <span>选择厂商</span></td>
              <td style="background-color: transparent; background-image: none;">
                  <asp:DropDownList ID="dl_company" runat="server" DataSourceID="SqlDataSource4"
                      DataTextField="company" DataValueField="company" Width="197px" AppendDataBoundItems="True">
                      <asp:ListItem Value="-1">所有厂商</asp:ListItem>
                  </asp:DropDownList>
                  <asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:oa1ConnectionString %>"
                      SelectCommand="SELECT [company] FROM [oa_company]"></asp:SqlDataSource>
              
              </td>
              </tr>
              <tr>
              <td style="background-color: transparent; background-image: none;">
              <span>选择设备类型</span></td>
              <td style="background-color: transparent; background-image: none;">
                  <asp:DropDownList ID="dl_type" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource2" DataTextField="type" DataValueField="type" Width="198px" AppendDataBoundItems="True">
                      <asp:ListItem Value="-1">所有类型</asp:ListItem>
                  </asp:DropDownList><br />
                  <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:oa1ConnectionString %>"
                      SelectCommand="SELECT [type] FROM [OA_UNIT_TYPE]">
                  </asp:SqlDataSource>
              </td>
                  <td style="background-color: transparent; background-image: none;">
                  <span>选择设备名称</span>
                  </td>
                  <td style="background-color: transparent; background-image: none;">
                      <asp:DropDownList ID="dl_name" runat="server" DataSourceID="SqlDataSource3" DataTextField="eq_name"
                          DataValueField="eq_name" Width="194px" AppendDataBoundItems="True">
                          <asp:ListItem Value="-1">所有设备</asp:ListItem>
                      </asp:DropDownList>
                      <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:oa1ConnectionString %>"
                          SelectCommand="SELECT [eq_name] FROM [OA_UNIT_DETAIL] WHERE ([eq_type] = @eq_type)">
                          <SelectParameters>
                              <asp:ControlParameter ControlID="dl_type" Name="eq_type" PropertyName="SelectedValue"
                                  Type="String" />
                          </SelectParameters>
                      </asp:SqlDataSource>
                  </td>
              </tr>
                      <tr align="left">
                          <td style="background-color: transparent; background-image: none;">
                              <span>开始时间</span></td>
                          <td style="background-color: transparent; background-image: none;">
                              <span>
                                  <asp:TextBox ID="b_time" runat="server" Width="176px"></asp:TextBox>
                                  <asp:ImageButton ID="ImageButton1" runat="server" Enabled="true" ImageUrl="~/images/calbtn.gif"
                                      OnClick="ImageButton1_Click" /><br />
                                  <asp:Calendar ID="Begindate" runat="server" BackColor="White" BorderColor="#999999"
                                      CellPadding="4" DayNameFormat="Shortest" Font-Names="Verdana" Font-Size="8pt"
                                      ForeColor="Black" Height="180px" OnSelectionChanged="Begindate_SelectionChanged"
                                      Visible="False" Width="200px">
                                      <SelectedDayStyle BackColor="#666666" Font-Bold="True" ForeColor="White" />
                                      <TodayDayStyle BackColor="#CCCCCC" ForeColor="Black" />
                                      <OtherMonthDayStyle ForeColor="#808080" />
                                      <NextPrevStyle VerticalAlign="Bottom" />
                                      <DayHeaderStyle BackColor="#CCCCCC" Font-Bold="True" Font-Size="7pt" />
                                      <TitleStyle BackColor="#999999" BorderColor="Black" Font-Bold="True" />
                                      <SelectorStyle BackColor="#CCCCCC" />
                                      <WeekendDayStyle BackColor="#FFFFCC" />
                                  </asp:Calendar>
                              </span></td>
                          <td style="background-color: transparent; background-image: none;" >
                              <span class="STYLE1">截止时间</span></td>
                          <td style="background-color: transparent; background-image: none;">
                              <span class="STYLE1">
                                  <asp:TextBox ID="e_time" runat="server" Width="157px"></asp:TextBox>
                                  <asp:ImageButton ID="ImageButton2" runat="server" Enabled="true" ImageUrl="~/images/calbtn.gif"
                                      OnClick="ImageButton2_Click" /><br />
                                  <asp:Calendar ID="Enddate" runat="server" BackColor="White" BorderColor="#999999"
                                      CellPadding="4" DayNameFormat="Shortest" Font-Names="Verdana" Font-Size="8pt"
                                      ForeColor="Black" Height="180px" OnSelectionChanged="Enddate_SelectionChanged"
                                      Visible="False" Width="200px">
                                      <SelectedDayStyle BackColor="#666666" Font-Bold="True" ForeColor="White" />
                                      <TodayDayStyle BackColor="#CCCCCC" ForeColor="Black" />
                                      <OtherMonthDayStyle ForeColor="#808080" />
                                      <NextPrevStyle VerticalAlign="Bottom" />
                                      <DayHeaderStyle BackColor="#CCCCCC" Font-Bold="True" Font-Size="7pt" />
                                      <TitleStyle BackColor="#999999" BorderColor="Black" Font-Bold="True" />
                                      <SelectorStyle BackColor="#CCCCCC" />
                                      <WeekendDayStyle BackColor="#FFFFCC" />
                                  </asp:Calendar>
                              </span>
                          </td>
                      </tr>
                      <tr>
                          <td colspan="4" style="background-color: transparent; background-image: none; height: 28px;" align="center">
                              &nbsp;<asp:Button ID="btn_ok" runat="server" OnClick="btn_ok_Click" Text="提交" /></td>
                      </tr>
                  </table>
                <asp:GridView ID="GridView1" runat="server" Width="655px" CellPadding="4" ForeColor="#333333" GridLines="None" AutoGenerateColumns="False" OnRowDataBound="GridView1_RowDataBound" DataKeyNames="form_id" PageSize="20" OnPageIndexChanging="GridView1_PageIndexChanging" AllowPaging="True">
                    <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                    <RowStyle BackColor="#EFF3FB" />
                    <EditRowStyle BackColor="#2461BF" />
                    <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
                    <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
                    <HeaderStyle BackColor="Silver" Font-Bold="True" ForeColor="White" />
                    <AlternatingRowStyle BackColor="White" />
                    <Columns>
                        <asp:BoundField DataField="form_id" HeaderText="维修单号" />
                        <asp:BoundField DataField="department" HeaderText="门店" />
                        <asp:BoundField DataField="applytime" HeaderText="报修日期" />
                        <asp:BoundField DataField="finish_date" HeaderText="完工日期" />
                        <asp:BoundField DataField="total_result" HeaderText="状态" />
                    </Columns>
                </asp:GridView>
            </asp:View>
        </asp:MultiView></div>
        &nbsp;
    </form>
</body>
</html>

						