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">位置: &nbsp; 客户管理 &nbsp;>  &nbsp;客户资料批量导入</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 &nbsp;&nbsp; 女性: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"/>&nbsp;&nbsp;<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">
                        &nbsp;
                    <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 + -
显示快捷键?