using?System;
using?System.Collections.Generic;
using?System.Data;
using?System.Data.OleDb;
using?System.Data.SqlClient;
using?System.Linq;
using?System.Web;
using?WebApplication1;

namespace?excel
{
????///?

????///?export?的摘要說明
????///?

????public?class?export?:?IHttpHandler
????{

????????public?void?ProcessRequest（HttpContext?context）
????????{
????????????context.Response.ContentType?=?“text/plain“;
????????????HttpFileCollection?httpFileCollection?=?context.Request.Files;
????????????if?（httpFileCollection.Count?==?0）
????????????{
????????????????context.Response.Write（“請選擇你要上傳的excel文件“）;
????????????????context.Response.End（）;
????????????}
????????????string?connStr?=?System.Configuration.ConfigurationManager.ConnectionStrings[“ConnectionString“]?.ConnectionString;
????????????if?（string.IsNullOrWhiteSpace（connStr））
????????????{
????????????????context.Response.Write（“數據庫鏈接字符串沒有配置“）;
????????????????context.Response.End（）;
????????????}

????????????foreach?（string?name?in?httpFileCollection）
????????????{
????????????????string?path?=context.Server.MapPath（“~“）?+?@“upload\“?+?Guid.NewGuid（）?+?httpFileCollection[name].FileName;
????????????????httpFileCollection[name].SaveAs（path）;
????????????????var?helper?=?new?ExcelHelper（path）;
????????????????DataTable?dt?=?helper.ExcelToDataTable（“Sheet1“?true）;
????????????????if?（dt?==?null）
????????????????{
????????????????????context.Response.Write（“上傳的excel文件格式不對“）;
????????????????????context.Response.End（）;
????????????????}
????????????????//對手機號去重
????????????????DataTable?newtable?=?dt.AsDataView（）.ToTable（true）;
????????????????using?（SqlConnection?conn?=?new?SqlConnection（connStr））
????????????????{

????????????????????conn.Open（）;
????????????????????foreach?（DataRow?row?in?newtable.Rows）
????????????????????{
????????????????????????string?commandStr?=?“INSERT?INTO?t_stu_info（namephoneremark）?VALUES（@name@phone@remark）“;
????????????????????????SqlCommand?sqlCommand?=?new?SqlCommand（）;
????????????????????????sqlCommand.Connection?=?conn;
????????????????????????sqlCommand.CommandText?=?commandStr;
????????????????????????sqlCommand.CommandType?=?CommandType.Text;
????????????????????????SqlParameter[]?sqlParameter?={
????????????????????????????????????new?SqlParameter（“@name“row[“name?“]==null?““:row[“name?“].ToString（））
????????????????????????????????????new?SqlParameter（“@phone“row[“phone“]==null?““:row[“phone“].ToString（））
????????????????????????????????????new?SqlParameter（“@remark“row[“remark“]==null?““:row[“remark“].ToString（））
????????????????????????????????????};
????????????????????????sqlCommand.Parameters.AddRange（sqlParameter）;
????????????????????????sqlCommand.ExecuteNonQuery（）;
????????????????????}

????????????????????//using?（SqlBulkCopy?sqlBulkCopy?=?new?System.Data.SqlClient.SqlBulkCopy（connStr?SqlBulkCopyOptions.KeepIdentity?|?SqlBulkCopyOptions.UseInternalTran

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2019-03-06?09:09??excel\
?????目錄???????????0??2019-03-06?09:07??excel\.vs\
?????目錄???????????0??2019-03-06?09:07??excel\.vs\config\
?????文件???????86088??2019-03-06?09:08??excel\.vs\config\applicationhost.config
?????目錄???????????0??2019-03-06?09:07??excel\.vs\excel\
?????目錄???????????0??2019-03-06?09:08??excel\.vs\excel\v15\
?????文件???????75264??2019-03-06?10:46??excel\.vs\excel\v15\.suo
?????目錄???????????0??2019-03-06?09:08??excel\.vs\excel\v15\Server\
?????目錄???????????0??2019-03-06?09:08??excel\.vs\excel\v15\Server\sqlite3\
?????文件???????????0??2019-03-06?09:08??excel\.vs\excel\v15\Server\sqlite3\db.lock
?????文件????????4096??2019-03-06?09:08??excel\.vs\excel\v15\Server\sqlite3\storage.ide
?????文件???????32768??2019-03-06?10:29??excel\.vs\excel\v15\Server\sqlite3\storage.ide-shm
?????文件?????1693352??2019-03-06?10:29??excel\.vs\excel\v15\Server\sqlite3\storage.ide-wal
?????目錄???????????0??2019-03-06?09:07??excel\.vs\excel\v15\sqlite3\
?????文件?????1060864??2019-03-06?09:03??excel\.vs\excel\v15\sqlite3\storage.ide
?????目錄???????????0??2019-03-06?10:29??excel\excel\
?????目錄???????????0??2019-03-06?09:13??excel\excel\Files\
?????文件???????25177??2019-03-06?09:13??excel\excel\Files\2318bde6-f11d-48b3-bad4-74cdd363241d.xlsx
?????文件???????78861??2019-03-06?09:13??excel\excel\Files\學生.xml
?????文件??????????89??2019-03-05?16:56??excel\excel\Global.asax
?????文件?????????335??2019-03-05?16:56??excel\excel\Global.asax.cs
?????目錄???????????0??2019-03-06?09:07??excel\excel\javascript\
?????目錄???????????0??2019-03-06?09:07??excel\excel\javascript\layui-v2.4.5\
?????目錄???????????0??2019-03-06?09:07??excel\excel\javascript\layui-v2.4.5\layui\
?????目錄???????????0??2019-03-06?09:07??excel\excel\javascript\layui-v2.4.5\layui\css\
?????文件???????69524??2018-11-02?10:36??excel\excel\javascript\layui-v2.4.5\layui\css\layui.css
?????文件????????9885??2018-11-02?10:36??excel\excel\javascript\layui-v2.4.5\layui\css\layui.mobile.css
?????目錄???????????0??2019-03-06?09:07??excel\excel\javascript\layui-v2.4.5\layui\css\modules\
?????文件????????1063??2018-11-02?10:36??excel\excel\javascript\layui-v2.4.5\layui\css\modules\code.css
?????目錄???????????0??2019-03-06?09:07??excel\excel\javascript\layui-v2.4.5\layui\css\modules\laydate\
?????目錄???????????0??2019-03-06?09:07??excel\excel\javascript\layui-v2.4.5\layui\css\modules\laydate\default\
............此處省略382個文件信息