上传excel并导入到数据库表

$(function () {



    $(window.parent.document)
        .find("#divToolbar").find("td")
        .each(function () {
            var id = $(this).attr("id");
            if (id == "tdCreateNew" ||
                id == "tdCreateByGrid" ||
                id == "tdShowAllWork" ||
                id == "tdDataImport" ||
                id == "tdHelp" ||
                id == "tdCustomDef" ||
                id == "tdSearchCentra" ||
                id == "tdSearchAll" ||
                id == "tdSearch"
            ) {
                $(this).prev().hide();
                $(this).hide();
            }
        });

    $("#tblMain").find("tr[flag='data']")
        .each(function () {
            var objid = $(this).attr('objid');
            var ele = "<a href='javascript:importExcel(\"" + objid + "\");' style='color:blue;text-decoration:underline;'>上传</a>"
            $(this).find("td[propname='SC']").append(ele);
        });
    compareSj();
    //myDownloadFile();
});


//上传
function importExcel(objid) {
    upload("*.xlsx;",
        //路径 文件名 下载路径
        function (filePath, fileName, downUrl) {
            var theTr = $("#tblMain").find("tr[objid='" + objid + "']");
            //更新文件名
            theTr.find("td[propname='WJ']").text(fileName);

            //写入数据库表，更新上传时间与上传人
            var url = getAppPath() + "/RJKBB/Other/RsjsjSvc.aspx" +
                "?id=" + objid +
                "&path=" + filePath +
                "&wj=" + fileName;// +
                //"&downUrl=" + downUrl;
            $.get(_akUrl(url), function (data) {
                $("#tblMain").find("tr[objid='" + objid + "']").find("td[propname='SCSJ']").text(data.split(';')[0]);
                $("#tblMain").find("tr[objid='" + objid + "']").find("td[propname='SCR']").text(data.split(';')[1]);
            });

            //导入数据 
            var sjbm = theTr.find('td[propname="SJBM"]').text();
            console.log((sjbm))
            var url = getAppPath() + "/Rjkbb/Other/ChImportData.aspx" +
                     "?path=" + filePath +
                     "&isdelete=1" +
                     "&table=" + sjbm;// +
            console.log(_akUrl(url));
            if (sjbm) {
                $.get(_akUrl(url), function (data) {
                    alert(data);
                });

            }

            compareSj(objid);
            myDownloadFile(objid);
        })
}

//时间
function compareSj() {
    $("#tblMain").find("tr[flag='data']").find("td[propname='SCSJ']").each(function () {
        var txt = $(this).text();
        var d = new Date();
        var dStand = new Date(d.getFullYear(), d.getMonth(), d.getDate(), 12, 00, 0);
        var lastDay = new Date(d.getFullYear(), d.getMonth(), d.getDate(), 00, 00, 0);
        var dSc = Date.parse(txt.replace(/-/g, "/"));
        if (txt.length == 0 || dSc <= lastDay) {
            $(this).text('未上报');
        } else if (dSc >= dStand) {
            $(this).css({ 'color': 'red', 'font-weight': 'bold' });
        } else {
            $(this).css({ 'color': 'black', 'font-weight': 'normal' });
        }

    });
}

//下载
function myDownloadFile() {
    //console.log("downloadFile");
    $("#tblMain").find("tr[flag='data']").each(function () {
        var objid = $(this).attr("objid");
        var url = getAppPath() + "/RJKBB/Other/RsjsjDownloadSvc.aspx" +
            "?id=" + objid;
        //console.log(_akUrl(url));
        $.get(_akUrl(url), function (data) {
            if (data != "Empty") {
                //console.log(data);
                $("#tblMain").find("tr[objid='" + objid + "']")
                .find("td[propname='XZ']")
                .html("<a style='color:blue;text-decoration:underline;' href='" + _akUrl(data) + "'>下载</a>");
            }

        });

    });

}

using System;
using System.Collections.Generic;
//using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

using CpmBigDataImportService;
//using RJKBB.Object;
//using RJKBB.DB;
using System.Text.RegularExpressions;
using Appkit.IO;
using Appkit.Common;
public partial class Rjkbb_Other_ChImportData : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string path = AkCommon.GetQueryString("path");
        string tableName = AkCommon.GetQueryString("table");
        string isDeleteBefore = AkCommon.GetQueryString("isdelete");
        string msg = string.Empty;

        //string msg = path;// new SqlConnectConfig().ConfigByDbString(Main.ConnectionString).ConnectString;
        //Response.Write(msg);
        try
        {
            CpmVars myVar = new CpmVars(tableName, AkDirService.CurrentDir);
            SqlConnectConfig sqc = new SqlConnectConfig().ConfigByDbString(RJKBB.DB.Main.ConnectionString);
            myVar.Sqc.Server = sqc.Server;
            myVar.Sqc.Database = sqc.Database;
            myVar.Sqc.Usr = sqc.Usr;
            myVar.Sqc.Pwd = sqc.Pwd;
            myVar.Sqc.TableName = tableName;

            if (isDeleteBefore.Length > 0)
            {
                string sql = string.Format("delete from {0} where 1=1", tableName);
                MyCommon.ExecuteSql(sql, myVar.Sqc.ConnectString);
            }

            switch (tableName)
            {
                case "TLFH":
                case "GJSHFH":
                case "GJSHTH":
                    int count = 0;
                    List<string> sheetNames = new List<string>();
                    using (XlsxFile xlsx = new XlsxFile(path))
                    {
                        for (int i = 0; i < xlsx.Sheets.Length; i++)
                            sheetNames.Add(xlsx.Sheets[i].Name);
                    }
                    foreach (var item in sheetNames)
                        count += ELineList.ExportToDb(path, item, myVar, true, "公司代码");
                     
                    msg = string.Format("导入{0}记录。", count);
                    break;

                case "CDXNMXRBB":
                    msg = string.Format("导入{0}记录。"
                        , ELineList.ExportToDb(path, myVar));
                    break;

                default:
                    msg = string.Format("导入{0}记录。"
                        , ELineList.ExportToDb(path, myVar));
                    break;
            }


        }
        catch (Exception ex)
        {
            msg = ex.Message;
            //throw;
        }
        Response.Write(msg);
    }


}