示例#1
0
        public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType = "text/plain";
            context.Response.Charset     = "utf-8";
            string filename = "error";

            ExcelBiz excelBiz = new ExcelBiz();

            HttpPostedFile file = context.Request.Files["Filedata"];

            try
            {
                string userName = "";
                if (HttpContext.Current.User.Identity.IsAuthenticated)
                {
                    userName = HttpContext.Current.User.Identity.Name;
                }
                else
                {
                    throw new Exception("未能识别用户");
                }

                string uploadPath = context.Server.MapPath("\\files\\shipment\\");
                filename = DateTime.Now.ToString("yyyyMMddHHmmssffff") + "_" + file.FileName;
                if (file != null)
                {
                    if (!Directory.Exists(uploadPath))
                    {
                        Directory.CreateDirectory(uploadPath);
                    }

                    file.SaveAs(uploadPath + filename);
                    _UpLog.WriteLog(file.FileName + " | 另存为:| " + filename);

                    excelBiz.Excel2MySql(uploadPath, filename, userName, 0);
                    //异步执行excel 存mysql
                    new Thread(o =>
                    {
                        //excelBiz.Excel2MySql(uploadPath, filename);
                    });
                }
            }
            catch (Exception ex)
            {
                _ErrLog.WriteLog(file.FileName + " 上传异常: " + ex.Message + ex.StackTrace);
                context.Response.Clear();
                context.Response.Write("error");
                context.Response.End();
            }
            context.Response.Clear();
            context.Response.Write(filename);
            context.Response.End();
        }
示例#2
0
 public void Init()
 {
     _FakeUOW_CDsDB = new FakeUOW_CDsDB();
     _servicio      = new ExcelBiz(_FakeUOW_CDsDB);
 }