check.aspx

asp销售管理系统

                    </asp:TemplateField>
                    <asp:BoundField DataField="ReviewerName" HeaderText="审核人" SortExpression="ReviewerName" />
                    <asp:TemplateField>
                        <ItemTemplate>
                            <asp:LinkButton ID="btnReview" Runat="server" Visible=false CommandName="Update" OnClientClick="return confirm('审核之后将不能再编辑，确定？');">
                            审核</asp:LinkButton>
                        </ItemTemplate>
                    </asp:TemplateField>

                    <asp:TemplateField>
                        <ItemTemplate>
                            <asp:LinkButton ID="btnDelete" Runat="server" Visible=false CommandName="Delete" OnClientClick="return confirm('确定删除该发料单？');">
                            删除</asp:LinkButton>
                        </ItemTemplate>
                    </asp:TemplateField>
                </Columns>
            </sk:myGridView>
            <asp:SqlDataSource ID="SqlDataSource5" runat="server" ConnectionString="<%$ ConnectionStrings:MySqlProviderConnection %>"
                SelectCommand="SELECT [Items].ItemID, [Items].Name, [Items].Specification, [Items].Unit, [Items].StandardPrice, InventoryQuantity, RealQuantity ,
                                    (RealQuantity-InventoryQuantity) as CheckItemsExtra, (RealQuantity-InventoryQuantity)*StandardPrice as CheckItemsExtraMoney,
                                    InventoryReasonID FROM [InventoryCheckDetail] 
                                    Join [Items] ON ([InventoryCheckDetail].ItemID = [Items].ItemID ) 
                                    WHERE ([InventoryCheckDetail].[InventoryCheckID] = @InventoryCheckID) 
                                    Order By InventoryCheckDetailID Desc"
                UpdateCommand="sp_updateInventoryCheckDetail" UpdateCommandType="StoredProcedure" 
                DeleteCommand="sp_deleteInventoryCheckDetail" DeleteCommandType="StoredProcedure">
                <SelectParameters>
                    <asp:ControlParameter ControlID="GridView3" Name="InventoryCheckID" PropertyName="SelectedValue"
                        Type="Int32" />
                </SelectParameters>
                <UpdateParameters>
                    <asp:ControlParameter ControlID="GridView3" Name="InventoryCheckID" PropertyName="SelectedValue"
                        Type="Int32" />
                    <asp:Parameter Name="ItemID" Type="string" />
                    <asp:Parameter Name="RealQuantity" Type="decimal" />
                    <asp:Parameter Name="InventoryReasonID" Type="int32" />
                </UpdateParameters>
                <DeleteParameters>
                    <asp:ControlParameter ControlID="GridView3" Name="InventoryCheckID" PropertyName="SelectedValue"
                        Type="Int32" />
                    <asp:Parameter Name="ItemID" Type="string" />
                </DeleteParameters>
            </asp:SqlDataSource>
            详细盘点记录
            <sk:myGridView ID="GridView4" runat="server" AutoGenerateColumns="False" AllowPaging=true Width="98%"
                DataKeyNames="ItemID" RowStyle-HorizontalAlign="Left" DataSourceID="SqlDataSource5"
                OnRowDataBound="GridView4_RowDataBound" ShowFooter=true OnDataBound="GridView4_DataBound" OnRowUpdating="GridView4_RowUpdating">
                <Columns>
                    <asp:TemplateField HeaderText="物资编号" SortExpression="ItemID" FooterStyle-HorizontalAlign="left">
                        <ItemTemplate>
                            <%# Eval("ItemID")%>
                        </ItemTemplate>
                        <FooterTemplate>
                            <asp:DropDownList ID="drpItem" runat="server" DataTextField="ItemID" DataValueField="ItemID"
                                onkeyup="dropKeyUp()" onkeypress="catch_press(this);" Visible="false">
                            </asp:DropDownList>
                            <asp:LinkButton ID="LinkButtonEditAdd" runat="server" Visible="false" 
                                Text="快速添加" OnClick="LinkButtonEditAdd_Click">
                            </asp:LinkButton>
                        </FooterTemplate>
                    </asp:TemplateField>
                    <asp:BoundField DataField="Name" HeaderText="物资名称" SortExpression="Name" ReadOnly="true" />
                    <asp:BoundField DataField="Specification" HeaderText="规格型号" SortExpression="Specification" ReadOnly="true" />
                    <asp:BoundField DataField="Unit" HeaderText="计量单位" SortExpression="Unit" ReadOnly="true" />
                    <asp:BoundField DataField="StandardPrice" HeaderText="标准单价" SortExpression="StandardPrice" HtmlEncode= false DataFormatString="{0:C}" ReadOnly="true" />
                    <asp:BoundField DataField="InventoryQuantity" HeaderText="账面数量" SortExpression="InventoryQuantity" ReadOnly="true" />
                    <asp:TemplateField HeaderText="实际数量" SortExpression="RealQuantity">
                        <ItemTemplate>
                            <%# Eval("RealQuantity")%>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <asp:TextBox ID="txtQuantity" runat="server" Width="60px" Text='<%# Bind("RealQuantity") %>'></asp:TextBox>
                            <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="txtQuantity"
                                ErrorMessage="请输入数量！" ValidationGroup="QuantityEditValid" Display="Dynamic"></asp:RequiredFieldValidator>
                            <asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ControlToValidate="txtQuantity"
                                Display="Dynamic" ErrorMessage="请输入数字！" ValidationExpression="^\-?[0-9]*\.?[0-9]*$" ValidationGroup="QuantityEditValid"></asp:RegularExpressionValidator>
                        </EditItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="盈亏数量" SortExpression="CheckItemsExtra">
                        <ItemTemplate>
                            <%# Eval("CheckItemsExtra")%>
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="盈亏金额" SortExpression="CheckItemsExtraMoney">
                        <ItemTemplate>
                           <%# String.Format("{0:C}",Eval("CheckItemsExtraMoney"))%>
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="盈亏原因" SortExpression="CheckItemsReason">
                        <EditItemTemplate>
                            <asp:Label ID="Label1" runat="server" Text='<%# Eval("InventoryReasonID") %>' Visible="False"></asp:Label>
                            <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:MySqlProviderConnection %>"
                                SelectCommand="sp_getCheckItemsReason" SelectCommandType="StoredProcedure">
                                <SelectParameters>
                                    <asp:ControlParameter ControlID="Label1" Name="InventoryReasonID" PropertyName="Text"
                                        Type="Int32" />
                                </SelectParameters>
                            </asp:SqlDataSource>
                            <asp:DropDownList ID="drpCheckItemsReason" runat="server" DataSourceID="SqlDataSource2"
                                DataTextField="Column2" DataValueField="Column1">
                            </asp:DropDownList>
                        </EditItemTemplate>
                        <ItemTemplate>
                            <asp:Label ID="Label1" runat="server" Text='<%# Eval("InventoryReasonID") %>' Visible="False"></asp:Label>
                            <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:MySqlProviderConnection %>"
                                SelectCommand="sp_getCheckItemsReason" SelectCommandType="StoredProcedure">
                                <SelectParameters>
                                    <asp:ControlParameter ControlID="Label1" Name="InventoryReasonID" PropertyName="Text"
                                        Type="Int32" />
                                </SelectParameters>
                            </asp:SqlDataSource>
                            <asp:DropDownList ID="drpCheckItemsReason" runat="server" DataSourceID="SqlDataSource2"
                                DataTextField="Column2" DataValueField="Column1" Enabled=false>
                            </asp:DropDownList>
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:CommandField CancelText="取消" 
                        DeleteText="删除" EditText="编辑" InsertText="插入" NewText="新增" 
                        SelectText="选取" UpdateText="确认" ValidationGroup="QuantityEditValid" />
                    <asp:TemplateField>
                        <ItemTemplate>
                            <asp:LinkButton ID="btnDeleteOne" Runat="server" 
                                OnClientClick="return confirm('删除该记录将把系统库存恢复为盘点前库存，确定？');"
                                CommandName="Delete">删除</asp:LinkButton>
                        </ItemTemplate>
                    </asp:TemplateField>
                </Columns>
            </sk:myGridView>
        </div>
        </asp:View>
    </asp:MultiView>
</asp:Content>