exceltodatabase.aspx
来自「该服务平台解决了计算机网络与移动网络之间信息交换问题」· ASPX 代码 · 共 117 行
ASPX
117 行
<%@ Page Language="C#" EnableEventValidation = "false" AutoEventWireup="true" CodeFile="ExcelToDataBase.aspx.cs" Inherits="UserManagement_ExcelToDataBase" 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 style="margin-top:0px">
<form id="form1" runat="server">
<table style="width: 691px; height: 206px; background-color: #f3f8ff; border-right: #9ac4e0 1px solid; border-top: #9ac4e0 1px solid; left: 0px; border-left: #9ac4e0 1px solid; border-bottom: #9ac4e0 1px solid; position: relative; top: -2px;" >
<tr>
<td style="font-size: small; width: 96px; height: 1px">
<hr style="width: 761px; height: 33px; left: 0px; position: relative; top: -8px; background-color: #9ac4e0;" />
<asp:Label ID="Label12" runat="server" Font-Size="10pt" Height="12px" Style="left: 3px;
position: relative; top: -44px" Width="740px">位置: 职工管理 > 职工资料批量导入</asp:Label>
<asp:Label ID ="label1" runat ="server" Width ="760px" Font-Size ="11pt" style="left: 0px; position: relative; top: -29px" >下载Excel文件</asp:Label> </td>
</tr>
<tr>
<td style="width: 96px; height: 30px; font-size: small;">
<table style="width: 690px; left: 0px; position: relative; top: -29px;">
<tr>
<td style="font-size: small; width: 87px; height: 26px">
<asp:Label ID ="text1" runat ="server" Font-Size ="10pt" > 请选择群组</asp:Label>
</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;">
<asp:Label ID ="Label2" runat ="server" Font-Size ="10pt" > 请选择部门单位</asp:Label>
</td>
<td style="font-size: small; ">
<asp:DropDownList ID="cbDept" runat="server" Width="153px"></asp:DropDownList>
<asp:Button ID="btnQuery" runat="server" Text="下载Excel文件" OnClick="btnExcelFileDown_Click" /></td>
</tr>
</table>
<table style="width: 690px; left: 0px; position: relative; top: -26px;">
<%--<tr>
<td>
<asp:LinkButton ID="LinkButton1" runat="server" PostBackUrl="~/UserManagement/UpLoadFiles/ExcelFile.xls">LinkButton</asp:LinkButton></td>
</tr>--%>
<tr>
<td>
<asp:Label ID ="Label3" Font-Size ="10pt" ForeColor ="red" runat ="server"> 下载Excel用户信息表格注意事项：</asp:Label></td>
</tr>
<tr>
<td>
<asp:Label ID ="Label4" Font-Size ="10pt" ForeColor ="red" runat ="server"> 1、不能修改Excel各单元格格式。</asp:Label></td>
</tr>
<tr>
<td>
<asp:Label ID ="Label5" Font-Size ="10pt" ForeColor ="red" runat ="server"> 2、Excel用户信息表格中的群组号、部门单位号、手机号必须填写。</asp:Label></td>
</tr>
<tr>
<td>
<asp:Label ID ="Label6" Font-Size ="10pt" ForeColor ="red" runat ="server"> 3、Excel用户信息表格中性别如须填写，则填入编号。男性：0 女性：1</asp:Label></td>
</tr>
</table>
</td>
</tr>
<tr>
<td style="font-size: small; width: 96px; height: 30px">
<hr style="width: 690px; border-top-width: 1px; border-left-width: 1px; border-top-color: #9ac4e0; border-bottom: #9ac4e0 1px solid; border-right-width: 1px; left: -2px; position: relative; top: -38px;" />
<asp:Label ID ="Label7" runat ="server" Font-Size ="11pt" style="left: 1px; position: relative; top: -37px" > 上传Excel文件</asp:Label></td>
</tr>
<tr>
<td style="width: 96px; height: 226px;">
<table style="width: 437px; font-size:small; height: 161px; left: 0px; position: relative; top: -35px;">
<tr>
<td style="width: 80px; height: 10px;">
<asp:Label ID ="Label8" runat ="server" Font-Size ="10pt" > Excel工作薄名</asp:Label></td>
<td style="width: 83px; height: 10px;">
<asp:TextBox ID="tbExcelTableName" runat="server">Sheet1$</asp:TextBox><input id="myFile" type="file" runat="server" name="myFile"/></td>
</tr>
<tr>
<td style="width: 80px; height: 17px">
<asp:Label ID ="Label9" runat ="server" Font-Size ="10pt" >文件名</asp:Label></td>
<td style="width: 83px; height: 17px">
<asp:TextBox ID="tbFileName" runat="server" Width="233px" Enabled="False"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 80px; height: 16px">
<asp:Label ID ="Label10" runat ="server" Font-Size ="10pt" >文件类型</asp:Label></td>
<td style="width: 83px; height: 16px">
<asp:TextBox ID="tbFileType" runat="server" Width="233px" Enabled="False"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 80px; height: 17px">
<asp:Label ID ="Label11" Font-Size ="10pt" runat ="server">文件大小</asp:Label></td>
<td style="width: 83px; height: 17px">
<asp:TextBox ID="tbFileSize" runat="server" Width="233px" Enabled="False"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 80px; height: 17px">
</td>
<td style="width: 240px; height:20px" align="left">
<asp:Button ID="btnUploadExcel" runat="server" Text="上传Excel文件" OnClick="UploadFile" Width="114px"/> <asp:Button ID="btnImportData" runat="server" Text="导入数据" OnClick="btnImportData_Click" Width="80px" /></td>
</tr>
</table>
<asp:Panel ID="Panel1" runat="server" Height="64px" ScrollBars="Vertical" Width="102px" style="position: relative; left: 0px; top: -32px;">
<asp:GridView ID="gvDownExcel" runat="server" Visible="False" Height="50px" Width="742px">
</asp:GridView>
</asp:Panel>
</td>
</tr>
</table>
<asp:Label id="textLabel" runat ="server" Height="42px" Width="769px"></asp:Label>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?