check.aspx

asp销售管理系统

<%@ Register Assembly="skcontrols"   TagPrefix="sk" Namespace="skcontrols"%><%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="check.aspx.cs" Inherits="inventory_check" Title="Untitled Page" %>
<%@ 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="hidPriceAtlast" runat="server" Value=0 />
            <asp:HiddenField ID="hidWareHouseID" runat="server" Value=0 />
            <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MySqlProviderConnection %>"
                InsertCommand="sp_insertCheck" InsertCommandType=StoredProcedure >
                <InsertParameters>
                    <asp:Parameter Name="InventoryCheckID" Type="Int32" />
                    <asp:Parameter Name="WareHouseID" Type="Int32" />
                    <asp:Parameter Name="CheckDate" Type="DateTime" />
                    <asp:Parameter Name="UserName" Type="String" />
                    <asp:Parameter Name="Description" Type="String" />
                    <asp:Parameter Name="ItemsIDList" Type="String" />
                    <asp:Parameter Name="InventoryList" Type="String" />
                    <asp:Parameter Name="QuantityList" Type="String" />
                    <asp:Parameter Name="ReasonList" Type="String" />
                </InsertParameters>
            </asp:SqlDataSource>
            <asp:FormView ID="FormView1" runat="server" AllowPaging="True" DataKeyNames="CheckID"
                DataSourceID="SqlDataSource1" DefaultMode="Insert" Width=95% 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 align=left>盘点单位:</td>
                        <td><%# Application["Organ"] %></td>
                        <td>盘点单号:</td>
                        <td>系统自动编号</td>
                    </tr>
                    <tr><td align=left>盘点日期:</td>
                        <td><asp:TextBox ID="CheckDateTextBox" 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>
                            <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>
                        <td align=left>备 &nbsp; &nbsp; 注:</td>
                        <td colspan=1><asp:TextBox ID="DescriptionTextBox" runat="server" 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><asp:Button ID="btnAuto" runat="server" Text="读入该库所有物资" OnClientClick="JavaScript: return confirm('您确认所选仓库正确吗？');" OnClick="btnAuto_Click" />
                        </td>
                    </tr>
                    <tr valign=top runat=server id="trList"><td colspan=6>
                    <div class="divGridView">
                        <sk:myGridView ID="GridView1" runat="server" AllowPaging="True" AllowPagingToggle="false" AutoGenerateColumns="False"
                            Width=100% DataKeyNames="CheckItemsID" ShowFooter=true AllowSorting="False"
                            OnPageIndexChanging="GridView1_PageIndexChanging" OnRowDeleting="GridView1_RowDeleting" 
                            OnRowEditing="GridView1_RowEditing" OnRowCancelingEdit="GridView1_RowCancelingEdit" OnRowUpdating="GridView1_RowUpdating" OnRowDataBound="GridView1_RowDataBound">
                            <Columns>
                                <asp:TemplateField HeaderText="序号">
                                    <ItemTemplate>
                                        <%# (((GridViewRow)Container).DataItemIndex + 1) %>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="物资编号" SortExpression="CheckItemsID">
                                    <ItemTemplate>
                                        <asp:Label ID="lblCheckItemsID" runat="server" Text='<%# Eval("CheckItemsID")%>'></asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="物资名称" SortExpression="CheckItemsName">
                                    <ItemTemplate>
                                        <%# Eval("CheckItemsName")%>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="规格型号" SortExpression="CheckItemsSpecification">
                                    <ItemTemplate>
                                        <%# Eval("CheckItemsSpecification")%>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="单位" SortExpression="CheckItemsUnit">
                                    <ItemTemplate>
                                        <%# Eval("CheckItemsUnit")%>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="标准单价" SortExpression="CheckItemsStandardPrice">
                                    <ItemTemplate>
                                        <%# String.Format("{0:C}",Eval("CheckItemsStandardPrice"))%>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="账面数量" SortExpression="CheckItemsInventory">
                                    <ItemTemplate>
                                        <%# Eval("CheckItemsInventory")%>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="实际数量" SortExpression="CheckQuantity">
                                    <ItemTemplate>
                                        <%# Eval("CheckQuantity") %>