exceltodatabase.aspx

来自「该服务平台解决了计算机网络与移动网络之间信息交换问题」· ASPX 代码 · 共 111 行

ASPX
111
字号
<%@ page language="C#" enableeventvalidation="false" autoeventwireup="true" inherits="UserManagement_ExcelToDataBase, App_Web_iy7gp0bk" theme="SkinFile" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>无标题页</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <table style="width: 834px; height: 57px; background-color: #f3f8ff;" >
            <tr>
                <td style="font-size: small; width: 100px; height: 2px">
                    <hr style="width: 822px" />
                    下载Excel文件</td>
            </tr>
            <tr>
                <td style="width: 100px; height: 30px; font-size: small;">
                    <table style="width: 827px">
                        <tr>
                            <td style="font-size: small; width: 87px; height: 26px">
                                请选择群组
                            </td>
                            <td style="font-size: small; width: 159px;">
                                <asp:DropDownList ID="cbUserTeam" runat="server" Width="153px" AutoPostBack="True" OnSelectedIndexChanged="cbUserTeam_SelectedIndexChanged">
                                </asp:DropDownList></td>
                            <td style="font-size: small; width: 98px;">
                                请选择部门单位
                            </td>
                            <td style="font-size: small; ">
                                <asp:DropDownList ID="cbDept" runat="server" Width="153px">
                                </asp:DropDownList>
                                <asp:Button ID="btnQuery" runat="server" Text="查询编码" OnClick="btnExcelFileDown_Click" />
                                <asp:HyperLink ID="HyperLink1" runat="server" Width="133px" Font-Size="Small" NavigateUrl="~/UserManagement/UpLoadFiles/ExcelFile.xls">下载Excel文件</asp:HyperLink></td>
                        </tr>
                    </table>
                    <table style="width: 825px">
                        <tr>
                            <td>
                                下载Excel用户信息表格注意事项:</td>
                        </tr>
                        <tr>
                            <td>
                                1、不能修改Excel各单元格格式。</td>
                        </tr>
                        <tr>
                            <td>
                                2、Excel用户信息表格中的群组号和部门单位号可以从上面的查询功能得到。</td>
                        </tr>
                        <tr>
                            <td>
                                3、Excel用户信息表格中的群组号、部门单位号、手机号必须填写。</td>
                        </tr>
                    </table>
                </td>
            </tr>
            <tr>
                <td style="font-size: small; width: 100px; height: 30px">
                    <hr style="width: 821px" />
                    上传Excel文件</td>
            </tr>
            <tr>
                <td style="width: 100px; ">
                    <table style="width: 416px; font-size:small;">
                        <tr>
                            <td style="width: 88px; height: 15px;">
                                Excel工作表名</td>
                            <td style="width: 96px; height: 15px;">
                                <asp:TextBox ID="tbExcelTableName" runat="server">Sheet1$</asp:TextBox>
                                <input id="myFile" type="file" runat="server" name="myFile"/></td>
                        </tr>
                        <tr>
                            <td style="width: 88px; height: 17px">
                                文件名</td>
                            <td style="width: 96px; height: 17px">
                                <asp:TextBox ID="tbFileName" runat="server" Width="309px" Enabled="False"></asp:TextBox></td>
                        </tr>
                        <tr>
                            <td style="width: 88px; height: 16px">
                                文件类型</td>
                            <td style="width: 96px; height: 16px">
                                <asp:TextBox ID="tbFileType" runat="server" Width="309px" Enabled="False"></asp:TextBox></td>
                        </tr>
                        <tr>
                            <td style="width: 88px; height: 17px">
                                文件大小</td>
                            <td style="width: 96px; height: 17px">
                                <asp:TextBox ID="tbFileSize" runat="server" Width="309px" Enabled="False"></asp:TextBox></td>
                        </tr>
                        <tr>
                            <td style="width: 88px; height: 17px">
                            </td>
                            <td style="width: 96px; ">
                                <asp:Button ID="btnUploadExcel" runat="server" Text="上传Excel文件" OnClick="UploadFile"/>
                                <asp:Button ID="btnImportData" runat="server" Text="Button" OnClick="btnImportData_Click" /></td>
                        </tr>
                    </table>
                    <asp:Panel ID="Panel1" runat="server" Height="200px" ScrollBars="Vertical" Width="125px">
                    <asp:GridView ID="gvDownExcel" runat="server" Visible="False" Height="111px" Width="833px">
                    </asp:GridView>
                    </asp:Panel>
                </td>
            </tr>
        </table>
    
    </div>
    </form>
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?