示例#1
0
        public PartialViewResult Index(HttpPostedFileBase fileexcel)
        {
            BanTinTuVan bantintuvan = new BanTinTuVan();

            if (fileexcel != null && fileexcel.ContentLength > 0)
            {
                try
                {
                    string name = ReadNameFile(fileexcel.FileName);
                    string path = "~/Files/somefiles/"; // path: đường dẫn lưu fileexcel tải lên
                    Path.Combine(HostingEnvironment.MapPath(path));
                    String pathOnServer = Path.Combine(path);
                    //var fullPath = Path.Combine(pathOnServer, Path.GetFileName(name));
                    var fullPath = Path.Combine(Server.MapPath(path),
                                                Path.GetFileName(name));
                    fileexcel.SaveAs(fullPath);    // lua file vào server
                    string    url   = path + name; // url: đường dẫn lưu file excel trên server
                    ReadExcel excel = new ReadExcel();
                    url = Path.Combine(HostingEnvironment.MapPath(url));
                    List <DataTable> table = excel.makeDataTableFromSheetName(url, excel.MySheet(url));
                    bantintuvan = excel.BanTinTuVanExcel(table);
                }
                catch (Exception) { }
                return(PartialView("TuVan_ViewChung", bantintuvan));
            }
            return(PartialView());
        }
示例#2
0
        /// <summary>
        /// HieuTM: Upload file, phân tích trả về mẫu dữ liệu.
        /// </summary>
        /// <returns></returns>
        public PartialViewResult UploadExcel()
        {
            LogDb.WriteLogInfo("HieuTM", "UploadExcel", "TuVanController", "Vao Upload");
            BanTinTuVan bttv = null;

            try
            {
                LogDb.WriteLogInfo("HieuTM", "UploadExcel", "TuVanController", "file count: " + Request.Files.Count.ToString());
                string linkSaveServer = "";
                for (int i = 0; i < Request.Files.Count; i++)
                {
                    string directoryPath = Path.Combine((Server.MapPath("~/Files/tuvan/")));
                    var    file          = Request.Files[i];
                    string filename      = file.FileName;

                    if (!System.IO.Directory.Exists(directoryPath))
                    {
                        System.IO.Directory.CreateDirectory(directoryPath);
                    }

                    string newname = Lib.Security.CurrentUserName + "_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + "_" + Path.GetFileName(file.FileName);
                    linkSaveServer   = Path.Combine(Server.MapPath("~/Files/tuvan/"), newname);
                    ViewBag.LinkFile = linkSaveServer;
                    file.SaveAs(linkSaveServer);
                    ReadExcel        excel = new ReadExcel();
                    List <DataTable> table = excel.makeDataTableFromSheetName(linkSaveServer, excel.MySheet(linkSaveServer));

                    bttv = table.Count == 0 ? null : excel.BanTinTuVanExcel(table);
                    if (bttv != null)
                    {
                        bttv.Link = @"Files/tuvan/" + newname;
                    }
                }
            }
            catch (Exception ex)
            {
                bttv = null;
                LogDb.WriteLogInfo("HieuTM", "UploadExcel", "TuVanController", "Error: " + ex.Message);
                LogDb.WriteLogError("HieuTM", "UploadExcel", "TuVanController", ex);
            }
            return(PartialView("TuVan_All_Par", bttv));
        }