dispatch.aspx

asp销售管理系统

<%@ Register Assembly="skcontrols"   TagPrefix="sk" Namespace="skcontrols"%><%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Dispatch.aspx.cs" Inherits="outbound_Dispatch" Title="支出小票" %>
<%@ Register Assembly="obout_Calendar_Pro_Net" Namespace="OboutInc.Calendar" TagPrefix="obout" %>
<asp:Content ID="Content1" ContentPlaceHolderID="contentMain" Runat="Server">
    <asp:RadioButton ID="radioBrowser" runat="server" autopostback="true" 
      GroupName="SearchType" Text="支出发料" OnCheckedChanged="radioButton_CheckedChanged" Checked='true' />
    <asp:RadioButton ID="radioInsert" runat="server" autopostback="true" 
      GroupName="SearchType" Text="发料查询" OnCheckedChanged="radioButton_CheckedChanged" />
    <asp:Label ID="Message" runat="server" Text="" ForeColor=red></asp:Label>
    <asp:MultiView ID="MultiView1" runat="server" ActiveViewIndex=0>
        <asp:View ID="View1" runat="server">
            <asp:HiddenField ID="hidWareHouseID" runat="server" Value='0' />
            <asp:HiddenField ID="hidAddItemID" runat="server" Value='0' />
            <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MySqlProviderConnection %>"
                InsertCommand="sp_insertDispatch" InsertCommandType='StoredProcedure' OnInserted="SqlDataSource1_Inserted">
                <InsertParameters>
                    <asp:Parameter Name="DeliveryID" Type="Int32" Direction="Output"/>
                    <asp:Parameter Name="ProjectCategoryID" Type="Int32" />
                    <asp:Parameter Name="DepartmentID" Type="Int32" />
                    <asp:Parameter Name="WareHouseID" Type="Int32" />
                    <asp:Parameter Name="DeliveryDate" Type="DateTime" />
                    <asp:Parameter Name="UserName" Type="String" />
                    <asp:Parameter Name="Description" Type="String" />
                    <asp:Parameter Name="ReceiverName" Type="String" />
                    <asp:Parameter Name="IsAccepted" Type="Boolean" DefaultValue="false" />
                    <asp:Parameter Name="IsReviewed" Type="boolean" DefaultValue="false" />
                    <asp:Parameter Name="ReviewerID" Type="string" DefaultValue="" />
                    <asp:Parameter Name="ItemsIDList" Type="String" />
                    <asp:Parameter Name="QuantityList" Type="String" />
                </InsertParameters>
            </asp:SqlDataSource>
            <asp:FormView ID="FormView1" runat="server" AllowPaging="True" DataKeyNames="DeliveryID" DataSourceID="SqlDataSource1" 
                DefaultMode="Insert" Width='98%' HorizontalAlign=Center OnItemInserting="FormView1_ItemInserting"
                OnItemInserted="FormView1_ItemInserted">
                <InsertItemTemplate>
                    <table width='100%'>
                    <thead><tr><td colspan=6 class="ticketTitle">支出发料单</td></tr></thead>
                    <tr>
                        <td align=left>管 库 员:</td>
                        <td><%#Server.HtmlEncode(this.User.Identity.Name)%></td>
                        <td>单 &nbsp; &nbsp; 位:</td>
                        <td><%# Application["Organ"]%></td>
                        <td>发料单号:</td>
                        <td>系统自动编号</td>
                    </tr>
                    <tr><td align=left>发料日期:</td>
                        <td><asp:TextBox ID="DeliveryDateTextBox" runat="server" Text='<%#DateTime.Now.ToShortDateString()%>'>
                        </asp:TextBox>
                            <obout:calendar id="Calendar1" runat="server" dateformat="yyyy-mm-dd" datepickerbuttontext='<img src="../images/calendar.gif"/>'
                                datepickermode="True" namesdays="日, 一, 二, 三, 四, 五, 六"  ShowYearSelector="true" namesmonths="一月, 二月, 三月, 四月, 五月, 六月, 七月, 八月, 九月, 十月, 十一月, 十二月"
                                scriptpath="../JScripts/calendarscript" stylefolder="../calendarStyle/default"></obout:calendar>
                        </td>
                        <td align=left>发料仓库:</td>
                        <td align=left colspan=3>
                            <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:MySqlProviderConnection %>"
                                SelectCommand="sp_getGrantedWareHouses" SelectCommandType="StoredProcedure">
                                <SelectParameters>
                                    <asp:Parameter Name="UserName" Type="String" />
                                </SelectParameters>    
                            </asp:SqlDataSource>
                            <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource2"
                                DataTextField="Description" DataValueField="WareHouseID"
                                OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged" OnDataBound="DropDownList1_DataBound">
                            </asp:DropDownList></td>
                    </tr>
                    <tr>
                        <td align=left>领料部门:</td>
                        <td><asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:MySqlProviderConnection %>"
                                SelectCommand="Select [DepartmentID], REPLICATE ('|- ', [Level]) + [Name] AS DepartName, [Label] FROM dbo.GetDepartmentTreeInfo() order by [Label]"></asp:SqlDataSource>
                            <asp:DropDownList ID="DropDownList2" runat="server" DataSourceID="SqlDataSource3" AutoPostBack="true"
                                DataTextField="DepartName" DataValueField="DepartmentID">
                            </asp:DropDownList></td>                    
                        <td align=left>领 料 人:</td>
                        <td><asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:MySqlProviderConnection %>"
                                SelectCommand="Select UserName From Accounts_DepartmentUsers Where DepartmentID=@DepartmentID">
                                <SelectParameters>
                                    <asp:ControlParameter ControlID="DropDownList2" PropertyName="SelectedValue" Name="DepartmentID" Type="Int32" />
                                </SelectParameters>    
                            </asp:SqlDataSource>
                            <asp:DropDownList ID="DrpUser" runat="server" DataSourceID="SqlDataSource4" DataTextField="UserName" DataValueField="UserName">
                            </asp:DropDownList>
                        </td>
                        <td align=left>生产项目:</td>
                        <td><asp:SqlDataSource ID="SqlProjectCategory" runat="server" ConnectionString="<%$ ConnectionStrings:MySqlProviderConnection %>"
                                SelectCommand="Select [ProjectCategoryID], REPLICATE ('|- ', [Level]) + [Name] AS ProjectName, [Label] FROM dbo.GetProjectTree() order by [Label]">
                            </asp:SqlDataSource>                            
                            <asp:DropDownList ID="DrpProjectCategory" runat="server" DataSourceID="SqlProjectCategory"
                                DataTextField="ProjectName" DataValueField="ProjectCategoryID" AutoPostBack="false">
                            </asp:DropDownList></td>
                    </tr>
                    <tr>
                        <td align=left>备 &nbsp; &nbsp; 注:</td>
                        <td align=left colspan=5><asp:TextBox ID="DescriptionTextBox" runat="server" Width=90% Text='<%# Bind("Description") %>'>
                        </asp:TextBox></td>                    
                    </tr>
                    <tr><td colspan=2>
                        <asp:RadioButton ID="radioBrowserDetails" runat="server" autopostback="true" 
                          GroupName="SearchType" 
                          Text="浏览" 
                          OnCheckedChanged="radioButtonDetails_CheckedChanged" Checked=true />
                        <asp:RadioButton ID="radioInsertDetails" runat="server" autopostback="true" 
                          GroupName="SearchType" 
                          Text="新增"
                          OnCheckedChanged="radioButtonDetails_CheckedChanged" />
                    </td>
                    <td align="left">
                    <asp:DropDownList ID="drpFilterOption" runat="server">
                        <asp:ListItem Text="物资编号" Value="ItemID" Selected="True"></asp:ListItem>
                        <asp:ListItem Text="物资名称" Value="Name"></asp:ListItem>
                        <asp:ListItem Text="规格型号" Value="Specification"></asp:ListItem>
                    </asp:DropDownList>
                    </td>
                    <td>
                        <asp:TextBox ID="ItemIDTextBox" runat="server" Width="100px" Enabled="false" onkeyup="dropKeyUp()" />
                        <asp:LinkButton ID="LinkButtonSearch" runat="server" Text="查找" OnClick="LinkButtonSearch_Click" Enabled="false">
                        </asp:LinkButton>
                    </td>
                    <td colspan=2>
                    </td>
                    </tr>
                    <tr valign=top runat=server id="trList"><td colspan=6>
                    <div class="divGridView">