excletocustomerinfo.aspx
来自「该服务平台解决了计算机网络与移动网络之间信息交换问题」· ASPX 代码 · 共 117 行
ASPX
117 行
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ExcletoCustomerInfo.aspx.cs" Inherits="Customermanangement_ExcletoCustomerInfo" %>
<!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 id="Head1" runat="server">
<title>无标题页</title>
</head>
<body style="margin-top:0px">
<form id="form1" runat="server">
<table style="width: 659px; height: 21px; 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: -8px;" >
<tr>
<td style="font-size: small; width: 96px; height: 2px">
<hr style="width: 764px; height: 33px; left: 0px; position: relative; top: -7px; background-color: #9ac4e0;" />
<asp:Label ID="Label12" runat="server" Font-Size="10pt" Height="12px" Style="left: 3px;
position: relative; top: -40px" Width="740px">位置: 客户管理 > 客户资料批量导入</asp:Label>
<asp:Label ID ="label1" runat ="server" Width ="692px" Font-Size ="11pt" style="left: 2px; position: relative; top: -18px" >下载Excel文件</asp:Label> </td>
</tr>
<tr>
<td style="width: 96px; height: 28px; font-size: small;">
<table style="width: 690px; left: 0px; position: relative; top: -17px;">
<tr>
<td style="font-size: small; width: 87px; height: 28px">
<asp:Label ID ="text1" runat ="server" Font-Size ="10pt" > 请选择群组</asp:Label>
</td>
<td style="font-size: small; width: 159px; height: 28px;">
<asp:DropDownList ID="cbUserTeam" runat="server" Width="153px" AutoPostBack="True" OnSelectedIndexChanged="cbUserTeam_SelectedIndexChanged"></asp:DropDownList></td>
<td style="font-size: small; width: 98px; height: 28px;">
<asp:Label ID ="Label2" runat ="server" Font-Size ="10pt" > 请选择部门单位</asp:Label>
</td>
<td style="font-size: small; height: 28px;">
<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: -14px;">
<%--<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; height: 1px;" />
<asp:Label ID ="Label7" runat ="server" Font-Size ="11pt" > 上传Excel文件</asp:Label></td>
</tr>
<tr>
<td style="width: 96px; ">
<table style="width: 437px; font-size:small; height: 142px;">
<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="67px" ScrollBars="Vertical" Width="110px" style="left: 0px; position: relative; top: 0px">
<asp:GridView ID="gvDownExcel" runat="server" Visible="False" Height="50px" Width="741px">
</asp:GridView>
</asp:Panel>
</td>
</tr>
</table>
<asp:Label id="textLabel" runat ="server" Height="42px" Width="773px"></asp:Label>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?