uploadfy导入Excel内容到数据库中2

cs:(上传文件并将Excel中的内容导入到数据库中)
public JsonResult DoImport(string uploadtype, string q_t)
        {
            iPAL.Applications.Authen.LoginUser user = (iPAL.Applications.Authen.LoginUser)(Session["LoginUser"]);
            m_userno = user.WorkNo;

            AjaxCallResult result = new AjaxCallResult();

            HttpContext.Response.ContentType = "text/plain";
            HttpContext.Response.Charset = "utf-8";

            string msg = string.Empty;
            string strUploadPath = HttpContext.Request.PhysicalApplicationPath + "iPALUploads\\";
            try
            {
                if (!Directory.Exists(strUploadPath))
                {
                    Directory.CreateDirectory(strUploadPath);
                }
                if ( HttpContext.Request.Files.Count != 1 )
                {
                    result.result = -1;
                    result.data = "上传文件只能为1.";
                    return Json(result);
                }
                HttpPostedFileBase postedFile = HttpContext.Request.Files[0];
                string fileName = postedFile.FileName;
                string ext = fileName.Substring(fileName.LastIndexOf('.'));
                string tempFile = fileName.Substring(0,fileName.Length - ext.Length -1 ) +  Guid.NewGuid().ToString("N");
                tempFile = Path.Combine(strUploadPath, tempFile) + ext;
                postedFile.SaveAs(tempFile);

                result.result = ImportSheet(tempFile, q_t, m_userno, ref msg);
                result.data = msg;

            }
            catch (Exception ex)
            {

                result.result = -1;
                result.data = ex.Message;
            }

            return Json(result);
        }
        private int ImportSheet(string filePath,string bigT,string userno,ref string msg)
        {
            ExcelReader excel = new ExcelReader();
            DataTable dt = new DataTable();
            int nRet = 0;
            List<BIGT_SHEET_MODEL> lstSheet = btModuel.GetSheetModel();//sheet
            List<BIGT_SHEET_MODEL> lstColModel = btModuel.GetColModel();//列模型
            List<BigTColModel> lstCol = new List<BigTColModel>();

            BIGT_SHEET_MODEL col;
            BIGT_SHEET_MODEL sheet;

            int nFailSheet = 0;
            for( int i=0; i < lstSheet.Count;i++)
            {
                sheet = lstSheet[i];
                if (excel.ReadFromExcel(filePath, sheet.sheet_name, dt) < 0)
                {
                    nFailSheet++;
                    if (nFailSheet == lstSheet.Count)
                    {
                        msg = "没有发现任何可识别Sheet名";
                        return -1;
                    }
                    continue;
                }
                //获取列模型
                lstCol.Clear();
                for (int k = 0; k < lstColModel.Count; k++)
                {
                    col = lstColModel[k];
                    if (string.IsNullOrEmpty(col.col_index))//只取与数据库对应的列
                    {
                        continue;
                    }
                    if (string.IsNullOrEmpty(col.col_model) || sheet.col_model == col.col_model)
                    {

                        BigTColModel colModel = new BigTColModel();
                        colModel.sheet_name = col.sheet_name;
                        colModel.col_index = col.col_index;

                        lstCol.Add(colModel);
                    }
                    else
                    {
                        continue;
                    }
                }

                nRet = ImportSheetData(userno, sheet.sheet_name, bigT, dt, lstCol, ref msg);
                if (nRet < 0)
                {
                    return -1;
                }
            }
           
            return 1;
        }