querymemberform.aspx

某公司的人事及工资管理系统

                        <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
                        <Columns>
                            <asp:BoundField DataField="自编号" HeaderText="自编号" InsertVisible="False" ReadOnly="True"
                                SortExpression="自编号" Visible="False" />
                            <asp:BoundField DataField="员工编号" HeaderText="员工编号" SortExpression="员工编号" Visible="False" />
                            <asp:BoundField DataField="员工姓名" HeaderText="员工姓名" SortExpression="员工姓名" Visible="False" />
                            <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" />
                        <AlternatingRowStyle BackColor="Gainsboro" />
                    </asp:GridView>
                </asp:Panel>
            </td>
        </tr>
        <tr>
            <td align="center" style="font-size: 0.8em; width: 2232px; font-family: 宋体; height: 120px;
                background-color: mediumturquoise">
                员工培训记录<asp:Panel ID="Panel4" runat="server" BackColor="Olive" Height="110px" ScrollBars="Auto"
                    Width="555px">
                    <asp:SqlDataSource ID="SqlDataSource6" runat="server" ConnectionString="<%$ ConnectionStrings:MyPersonnelDBConnectionString %>"
                        SelectCommand="SELECT * FROM [培训记录] WHERE ([员工编号] = @员工编号)">
                        <SelectParameters>
                            <asp:ControlParameter ControlID="DropDownList2" Name="员工编号" PropertyName="SelectedValue"
                                Type="String" />
                        </SelectParameters>
                    </asp:SqlDataSource>
                    <asp:GridView ID="GridView4" runat="server" AutoGenerateColumns="False" BackColor="White"
                        BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataKeyNames="自编号"
                        DataSourceID="SqlDataSource6" GridLines="Vertical" Width="1200px">
                        <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
                        <Columns>
                            <asp:BoundField DataField="自编号" HeaderText="自编号" InsertVisible="False" ReadOnly="True"
                                SortExpression="自编号" Visible="False" />
                            <asp:BoundField DataField="员工编号" HeaderText="员工编号" SortExpression="员工编号" Visible="False" />
                            <asp:BoundField DataField="员工姓名" HeaderText="员工姓名" SortExpression="员工姓名" Visible="False" />
                            <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" />
                        <AlternatingRowStyle BackColor="#DCDCDC" />
                    </asp:GridView>
                </asp:Panel>
            </td>
        </tr>
        <tr>
            <td align="center" style="font-size: 0.8em; width: 2232px; font-family: 宋体; height: 120px;
                background-color: mediumturquoise">
                员工奖惩记录<asp:Panel ID="Panel5" runat="server" BackColor="Olive" Height="110px" ScrollBars="Auto"
                    Width="555px">
                    <asp:SqlDataSource ID="SqlDataSource7" runat="server" ConnectionString="<%$ ConnectionStrings:MyPersonnelDBConnectionString %>"
                        SelectCommand="SELECT * FROM [奖惩记录] WHERE ([员工编号] = @员工编号)">
                        <SelectParameters>
                            <asp:ControlParameter ControlID="DropDownList2" Name="员工编号" PropertyName="SelectedValue"
                                Type="String" />
                        </SelectParameters>
                    </asp:SqlDataSource>
                    <asp:GridView ID="GridView5" runat="server" AutoGenerateColumns="False" BackColor="White"
                        BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataKeyNames="自编号"
                        DataSourceID="SqlDataSource7" GridLines="Vertical" Width="800px">
                        <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
                        <Columns>
                            <asp:BoundField DataField="自编号" HeaderText="自编号" InsertVisible="False" ReadOnly="True"
                                SortExpression="自编号" Visible="False" />
                            <asp:BoundField DataField="员工编号" HeaderText="员工编号" SortExpression="员工编号" Visible="False" />
                            <asp:BoundField DataField="员工姓名" HeaderText="员工姓名" SortExpression="员工姓名" Visible="False" />
                            <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" />
                        <AlternatingRowStyle BackColor="#DCDCDC" />
                    </asp:GridView>
                </asp:Panel>
            </td>
        </tr>
        <tr>
            <td align="center" style="font-size: 0.8em; width: 2232px; font-family: 宋体; height: 120px;
                background-color: mediumturquoise">
                员工工作业绩<asp:Panel ID="Panel6" runat="server" BackColor="Olive" Height="110px" ScrollBars="Auto"
                    Width="555px">
                    <asp:SqlDataSource ID="SqlDataSource8" runat="server" ConnectionString="<%$ ConnectionStrings:MyPersonnelDBConnectionString %>"
                        SelectCommand="SELECT * FROM [工作业绩] WHERE ([员工编号] = @员工编号)">
                        <SelectParameters>
                            <asp:ControlParameter ControlID="DropDownList2" Name="员工编号" PropertyName="SelectedValue"
                                Type="String" />
                        </SelectParameters>
                    </asp:SqlDataSource>
                    <asp:GridView ID="GridView6" runat="server" AutoGenerateColumns="False" BackColor="White"
                        BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataKeyNames="自编号"
                        DataSourceID="SqlDataSource8" GridLines="Vertical" Width="600px">
                        <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
                        <Columns>
                            <asp:BoundField DataField="自编号" HeaderText="自编号" InsertVisible="False" ReadOnly="True"
                                SortExpression="自编号" Visible="False" />
                            <asp:BoundField DataField="员工编号" HeaderText="员工编号" SortExpression="员工编号" Visible="False" />
                            <asp:BoundField DataField="员工姓名" HeaderText="员工姓名" SortExpression="员工姓名" Visible="False" />
                            <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" />
                        <AlternatingRowStyle BackColor="#DCDCDC" />
                    </asp:GridView>
                </asp:Panel>
            </td>
        </tr>
    </table>
</asp:Content>