myassetsform.aspx

重庆某纸业公司的固定资产管理系统

                       <asp:ControlParameter ControlID="TextBox18" Name="月度折旧额" PropertyName="Text" Type="Double" />
                       <asp:ControlParameter ControlID="TextBox19" Name="预计净残值" PropertyName="Text" Type="Double" />
                       <asp:ControlParameter ControlID="TextBox20" Name="补充说明" PropertyName="Text" Type="String" />
                       <asp:ControlParameter ControlID="TextBox3" Name="资产编号" PropertyName="Text" Type="String" />
                    </UpdateParameters>                   
                    <DeleteParameters>
                        <asp:Parameter Name="资产编号" Type="String" />
                    </DeleteParameters>                   
                    <SelectParameters>
                        <asp:ControlParameter ControlID="TextBox1" Name="资产名称" PropertyName="Text" Type="String" />
                    </SelectParameters>
                    <InsertParameters>
                        <asp:ControlParameter ControlID="TextBox3" Name="资产编号" PropertyName="Text" Type="String" />
                        <asp:ControlParameter ControlID="TextBox4" Name="资产名称" PropertyName="Text" Type="String" />
                        <asp:ControlParameter ControlID="TextBox5" Name="规格型号" PropertyName="Text" Type="String" />
                        <asp:ControlParameter ControlID="TextBox6" Name="制造厂家" PropertyName="Text" Type="String" />
                        <asp:ControlParameter ControlID="TextBox7" Name="出厂日期" PropertyName="Text" Type="DateTime" />
                        <asp:ControlParameter ControlID="TextBox8" Name="入账日期" PropertyName="Text" Type="DateTime" />
                        <asp:ControlParameter ControlID="TextBox9" Name="存放地点" PropertyName="Text" Type="String" />
                        <asp:ControlParameter ControlID="DropDownList1" Name="使用部门" PropertyName="SelectedValue"
                            Type="String" />
                        <asp:ControlParameter ControlID="DropDownList2" Name="使用状态" PropertyName="SelectedValue"
                            Type="String" />
                        <asp:ControlParameter ControlID="DropDownList3" Name="增加方式" PropertyName="SelectedValue"
                            Type="String" />
                        <asp:ControlParameter ControlID="DropDownList4" Name="所属类别" PropertyName="SelectedValue"
                            Type="String" />
                        <asp:ControlParameter ControlID="TextBox10" Name="单位" PropertyName="Text" Type="String" />
                        <asp:ControlParameter ControlID="TextBox11" Name="数量" PropertyName="Text" Type="Int32" />
                        <asp:ControlParameter ControlID="TextBox12" Name="单价" PropertyName="Text" Type="Double" />
                        <asp:ControlParameter ControlID="TextBox13" Name="金额" PropertyName="Text" Type="Double" />
                        <asp:ControlParameter ControlID="TextBox14" Name="资产原值" PropertyName="Text" Type="Double" />
                        <asp:ControlParameter ControlID="TextBox15" Name="累计折旧" PropertyName="Text" Type="Double" />
                        <asp:ControlParameter ControlID="DropDownList5" Name="折旧方法" PropertyName="SelectedValue"
                            Type="String" />
                        <asp:ControlParameter ControlID="TextBox16" Name="折旧月数" PropertyName="Text" Type="Int32" />
                        <asp:ControlParameter ControlID="TextBox17" Name="已提月数" PropertyName="Text" Type="Int32" />
                        <asp:ControlParameter ControlID="TextBox18" Name="月度折旧额" PropertyName="Text" Type="Double" />
                        <asp:ControlParameter ControlID="TextBox19" Name="预计净残值" PropertyName="Text" Type="Double" />
                        <asp:ControlParameter ControlID="TextBox20" Name="补充说明" PropertyName="Text" Type="String" />
                    </InsertParameters>
                </asp:SqlDataSource>
            </td>
        </tr>
        <tr>
            <td style="width: 2232px; height: 100px; background-color: gainsboro">
                <asp:Panel ID="Panel1" runat="server" Height="200px" ScrollBars="Auto" Width="553px">
                    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White"
                        BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataKeyNames="资产编号"
                        DataSourceID="SqlDataSource2" Font-Names="宋体" Font-Size="Small" GridLines="Vertical"
                        OnRowCreated="GridView1_RowCreated" OnSelectedIndexChanged="GridView1_SelectedIndexChanged"
                        Width="2000px" AllowSorting="True" Height="250px">
                        <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
                        <Columns>
                            <asp:CommandField ButtonType="Button" HeaderText="选择" ShowSelectButton="True" />
                            <asp:TemplateField HeaderText="删除" ShowHeader="False">
                                <ItemTemplate>
                                    <asp:Button ID="Button1" runat="server" CausesValidation="False" CommandName="Delete"
                                        Text="删除" />
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:BoundField DataField="自编号" HeaderText="自编号" InsertVisible="False" ReadOnly="True"
                                SortExpression="自编号" />
                            <asp:BoundField DataField="资产编号" HeaderText="资产编号" ReadOnly="True" SortExpression="资产编号" />
                            <asp:BoundField DataField="资产名称" HeaderText="资产名称" SortExpression="资产名称" />
                            <asp:BoundField DataField="规格型号" HeaderText="规格型号" SortExpression="规格型号" />
                            <asp:BoundField DataField="制造厂家" HeaderText="制造厂家" SortExpression="制造厂家" />
                            <asp:BoundField DataField="出厂日期" HeaderText="出厂日期" SortExpression="出厂日期" />
                            <asp:BoundField DataField="入账日期" HeaderText="入账日期" SortExpression="入账日期" />
                            <asp:BoundField DataField="存放地点" HeaderText="存放地点" SortExpression="存放地点" />
                            <asp:BoundField DataField="使用部门" HeaderText="使用部门" SortExpression="使用部门" />
                            <asp:BoundField DataField="使用状态" HeaderText="使用状态" SortExpression="使用状态" />
                            <asp:BoundField DataField="增加方式" HeaderText="增加方式" SortExpression="增加方式" />
                            <asp:BoundField DataField="所属类别" HeaderText="所属类别" SortExpression="所属类别" />
                            <asp:BoundField DataField="单位" HeaderText="单位" SortExpression="单位" />
                            <asp:BoundField DataField="数量" HeaderText="数量" SortExpression="数量" />
                            <asp:BoundField DataField="单价" HeaderText="单价" SortExpression="单价" />
                            <asp:BoundField DataField="金额" HeaderText="金额" SortExpression="金额" />
                            <asp:BoundField DataField="资产原值" HeaderText="资产原值" SortExpression="资产原值" />
                            <asp:BoundField DataField="累计折旧" HeaderText="累计折旧" SortExpression="累计折旧" />
                            <asp:BoundField DataField="折旧方法" HeaderText="折旧方法" SortExpression="折旧方法" />
                            <asp:BoundField DataField="折旧月数" HeaderText="折旧月数" SortExpression="折旧月数" />
                            <asp:BoundField DataField="已提月数" HeaderText="已提月数" SortExpression="已提月数" />
                            <asp:BoundField DataField="月度折旧额" HeaderText="月度折旧额" SortExpression="月度折旧额" />
                            <asp:BoundField DataField="预计净残值" HeaderText="预计净残值" SortExpression="预计净残值" />
                            <asp:BoundField DataField="补充说明" HeaderText="补充说明" SortExpression="补充说明" />
                        </Columns>
                        <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
                        <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
                        <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
                        <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" HorizontalAlign="Center" />
                        <AlternatingRowStyle BackColor="Gainsboro" />
                    </asp:GridView>
                </asp:Panel>
            </td>
        </tr>
    </table>
</asp:Content>