warehousesmain.aspx

asp销售管理系统

            <td><asp:TextBox ID="TextBox1" runat="server" Text=<%# Bind("UserName")%>></asp:TextBox></td>
            <td>是否允许例外存放其他物资？:</td>
            <td><asp:CheckBox ID="Checkbox2" runat="server" Checked=<%# Bind("IsExceptionAllowed")%>/></td>
        </tr>
        <tr>
            <td align=left>定额:</td>
            <td>
                <asp:TextBox ID="txtQuota" runat="server" Text='<%# Bind("Quota") %>'></asp:TextBox>
                <asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ControlToValidate="txtQuota"
                    Display="Dynamic" ErrorMessage="请输入数字！" ValidationExpression="^\-?[0-9]*\.?[0-9]*$" ValidationGroup="QuantityValid"></asp:RegularExpressionValidator>
            </td>
            <td>       
            </td>
        </tr>
        </table>
        <table width=100%>
        <tr>
        <td>物资分类：</td>
        <td></td>
        <td>本库可存放物资：</td>
        </tr>
        <tr>
            <td width=40%>
                <asp:SqlDataSource ID="SqlSparesCatogries" runat="server" ConnectionString="<%$ ConnectionStrings:MySqlProviderConnection %>"
                    SelectCommand="SELECT ItemCategoryID,([ItemCategoryID]+','+[Description]) As CategoriesName FROM [ItemCategories] Where ItemCategoryID NOT in (Select ItemCategoryID From [WareHouseItemCatogries] Where WareHouseID = @WareHouseID)">
                    <SelectParameters>
                        <asp:QueryStringParameter QueryStringField="id" Name="WareHouseID"/>
                    </SelectParameters>
                </asp:SqlDataSource>
                <asp:ListBox ID="ListSparesCatogries" runat="server" Width=100% Rows=10 
                    DataSourceID="SqlSparesCatogries" DataTextField="CategoriesName" DataValueField="ItemCategoryID" 
                    SelectionMode="Multiple" AutoPostBack="false" onDblclick="moveoption(FormViewWareHouses_ListSparesCatogries, FormViewWareHouses_ListWareHouseItemCatogries, true);"></asp:ListBox>
            </td>
            <td width=10% align=center valign=middle>
                <input type=button value="添加>>" OnClick="moveoption(FormViewWareHouses_ListSparesCatogries, FormViewWareHouses_ListWareHouseItemCatogries, true);" />
                <br /><br /><br />
                <input type=button value="<<删除" onclick="moveoption(FormViewWareHouses_ListWareHouseItemCatogries, FormViewWareHouses_ListSparesCatogries, false);"/>
            </td>
            <td>
                <asp:SqlDataSource ID="SqlWareHouseItemCatogries" runat="server" ConnectionString="<%$ ConnectionStrings:MySqlProviderConnection %>"
                    SelectCommand="SELECT ItemCategoryID,([ItemCategoryID]+','+[Description]) As CategoriesName FROM [ItemCategories] Where ItemCategoryID in (Select ItemCategoryID From [WareHouseItemCatogries] Where WareHouseID = @WareHouseID)">
                    <SelectParameters>
                        <asp:QueryStringParameter QueryStringField="id" Name="WareHouseID"/>
                    </SelectParameters>
                </asp:SqlDataSource>
                <asp:ListBox ID="ListWareHouseItemCatogries" runat="server" Width="98%" Rows=10 
                    DataSourceID="SqlWareHouseItemCatogries" DataTextField="CategoriesName" 
                    DataValueField="ItemCategoryID" SelectionMode="Multiple" AutoPostBack="false"
                    onDblclick="moveoption(FormViewWareHouses_ListWareHouseItemCatogries, FormViewWareHouses_ListSparesCatogries, false);">
                </asp:ListBox>
            </td>
        </tr>
        <tr><td align=right>              
        <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" ValidationGroup="QuantityValid" CommandName="Update"
            Text="保存更改">
        </asp:LinkButton>
        </td>
        <td></td>
        <td align=left>
        <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
            Text="取消">
        </asp:LinkButton>
        </td></tr>
        </table>
    </EditItemTemplate>
    <InsertItemTemplate>
        <table width=100%><tr>
            <td align=left width=20%>仓库编号:</td>
            <td width=20%>
                <asp:TextBox ID="txtWareHouseCode" runat="server" Text=<%# Bind("WareHouseCode")%>></asp:TextBox></td>
            <td width=30%>名称:</td>
            <td><asp:TextBox ID="txtDescription" runat="server" Text=<%# Bind("Description")%>></asp:TextBox></td>
        </tr>
        <tr>
            <td align=left>上级仓库:</td>
            <td>
                <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:MySqlProviderConnection %>"
                    SelectCommand="SELECT * FROM [ViewWareHouses]">
                </asp:SqlDataSource>
                <asp:DropDownList ID="drpParentWareHouseID" runat="server" DataSourceID="SqlDataSource3"
                    DataTextField="Description" DataValueField="WareHouseID">
                </asp:DropDownList>
            </td>
            <td>是否允许存放物资？:</td>
            <td>
                <asp:CheckBox ID="Checkbox1" runat="server" Checked="true"/>
            </td>
        </tr>
        <tr>
            <td align=left>主要管库员:</td>
            <td><asp:TextBox ID="TextBox1" runat="server" Text=<%# Bind("UserName")%>></asp:TextBox></td>
            <td>是否允许例外存放其他物资？:</td>
            <td><asp:CheckBox ID="Checkbox2" runat="server" Checked="true"/></td>
        </tr>
        <tr>
            <td align=left>定额:</td>
            <td>
                <asp:TextBox ID="txtQuota" runat="server" Text='<%# Bind("Quota") %>'></asp:TextBox>
                <asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ControlToValidate="txtQuota"
                    Display="Dynamic" ErrorMessage="请输入数字！" ValidationExpression="^\-?[0-9]*\.?[0-9]*$" ValidationGroup="QuantityValid"></asp:RegularExpressionValidator>
            </td>
        </tr>
        </table>
        <table width=100%>
        <tr>
        <td>物资分类：</td>
        <td></td>
        <td>本库可存放物资：</td>
        </tr>
        <tr>
            <td width=40%>
                <asp:SqlDataSource ID="SqlSparesCatogries" runat="server" ConnectionString="<%$ ConnectionStrings:MySqlProviderConnection %>"
                    SelectCommand="SELECT ItemCategoryID,([ItemCategoryID]+','+[Description]) As CategoriesName FROM [ItemCategories]">
                </asp:SqlDataSource>
                <asp:ListBox ID="ListSparesCatogries" runat="server" Width=100% Rows=10 
                    DataSourceID="SqlSparesCatogries" DataTextField="CategoriesName" DataValueField="ItemCategoryID" 
                    SelectionMode="Multiple" AutoPostBack="false" onDblclick="moveoption(FormViewWareHouses_ListSparesCatogries, FormViewWareHouses_ListWareHouseItemCatogries, true);"></asp:ListBox>
            </td>
            <td width=10% align=center valign=middle>
                <input type=button value="添加>>" OnClick="moveoption(FormViewWareHouses_ListSparesCatogries, FormViewWareHouses_ListWareHouseItemCatogries, true);" />
                <br /><br /><br />
                <input type=button value="<<删除" onclick="moveoption(FormViewWareHouses_ListWareHouseItemCatogries, FormViewWareHouses_ListSparesCatogries, false);"/>
            </td>
            <td>
                <asp:ListBox ID="ListWareHouseItemCatogries" runat="server" Width="98%" Rows=10 
                    SelectionMode="Multiple" AutoPostBack="false"
                    onDblclick="moveoption(FormViewWareHouses_ListWareHouseItemCatogries, FormViewWareHouses_ListSparesCatogries, false);">
                </asp:ListBox>
            </td>
        </tr>
        <tr><td align=right>              
        <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" ValidationGroup="QuantityValid" CommandName="Insert"
            Text="保存" OnClientClick="return getInsertIDList(FormViewWareHouses_ListWareHouseItemCatogries);">
        </asp:LinkButton>
        </td>
        <td></td>
        <td align=left>
        <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
            Text="取消">
        </asp:LinkButton>
        </td></tr>
        </table>
    </InsertItemTemplate>
</asp:FormView>
</form>
</body>
</html>