public ActionResult ImportEmployeeByExcel(HttpPostedFileBase files) { Common.ClientResult.Result result = new Common.ClientResult.Result(); #region 导入Excel try { HttpPostedFileBase file = files; string FileName; string savePath = string.Empty; if (file == null || file.ContentLength <= 0) { result.Code = Common.ClientCode.Fail; result.Message = "文件不能为空"; //return result; return(Json(new { code = 0, msg = result.Message })); } else { string filename = System.IO.Path.GetFileName(file.FileName); int filesize = file.ContentLength; //获取上传文件的大小单位为字节byte string fileEx = System.IO.Path.GetExtension(filename); //获取上传文件的扩展名 string NoFileName = System.IO.Path.GetFileNameWithoutExtension(filename); //获取无扩展名的文件名 int Maxsize = 4000 * 1024; //定义上传文件的最大空间大小为4M string FileType = ".xls"; //定义上传文件的类型字符串 FileName = NoFileName + DateTime.Now.ToString("yyyyMMddhhmmss") + fileEx; if (!FileType.Contains(fileEx)) { result.Code = Common.ClientCode.Fail; result.Message = "文件类型不对,只能导入xls格式的文件"; //return result; return(Json(new { code = 0, msg = result.Message })); } //if (filesize >= Maxsize) //{ // result.Code = Common.ClientCode.Fail; // result.Message = "上传文件超过4M,不能上传"; // //return result; // return Json(new { code = 0, msg = result.Message }); //} string path = AppDomain.CurrentDomain.BaseDirectory + "excel/"; savePath = System.IO.Path.Combine(path, FileName); file.SaveAs(savePath); } //string filename = System.IO.Path.GetFileName(file.FileName); string message = string.Empty; DataTable table = Util_XLS.NpoiReadExcle2(savePath, "Sheet1", out message); if (!string.IsNullOrWhiteSpace(message)) { result.Code = Common.ClientCode.Fail; result.Message = message; return(Json(new { code = 0, msg = result.Message })); } if (table == null && table.Rows.Count <= 0) { result.Code = Common.ClientCode.Fail; result.Message = "导入Excel中不存在有效员工信息请核实!"; return(Json(new { code = 0, msg = result.Message })); } int SuccessNum = 0; if (ImportEmployeeAdd(table, ref message, out SuccessNum)) { result.Code = Common.ClientCode.Succeed; result.Message = string.Format("成功导入{0}人员工信息!", table.Rows.Count); return(Json(new { code = 1, msg = result.Message })); } else { result.Code = Common.ClientCode.Fail; result.Message = message; return(Json(new { code = 0, msg = result.Message })); } } catch (Exception ex) { result.Code = Common.ClientCode.Fail; result.Message = ex.Message + "导入失败,请认真检查excel"; //return result; return(Json(new { code = 0, msg = result.Message })); } #endregion }
public ActionResult SetFailByExcel(HttpPostedFileBase files) { Common.ClientResult.Result result = new Common.ClientResult.Result(); result.Code = Common.ClientCode.Fail; result.Message = "导入失败"; #region 导入Excel try { HttpPostedFileBase file = files; string FileName; string savePath = string.Empty; if (file == null || file.ContentLength <= 0) { result.Code = Common.ClientCode.Fail; result.Message = "文件不能为空"; return(Json(new { code = result.Code, msg = result.Message })); } else { string filename = System.IO.Path.GetFileName(file.FileName); int filesize = file.ContentLength; //获取上传文件的大小单位为字节byte string fileEx = System.IO.Path.GetExtension(filename); //获取上传文件的扩展名 string NoFileName = System.IO.Path.GetFileNameWithoutExtension(filename); //获取无扩展名的文件名 int Maxsize = 4000 * 1024; //定义上传文件的最大空间大小为4M //string FileType = ".xls";//定义上传文件的类型字符串 string[] FileType = new string[] { ".xls", ".xlsx" }; FileName = NoFileName + DateTime.Now.ToString("yyyyMMddhhmmss") + fileEx; if (!FileType.Contains(fileEx)) { result.Code = Common.ClientCode.Fail; result.Message = "文件类型不对,只能导入Excel文件"; return(Json(new { code = result.Code, msg = result.Message })); } if (filesize >= Maxsize) { result.Code = Common.ClientCode.Fail; result.Message = "上传文件超过4M,不能上传"; //return result; return(Json(new { code = 0, msg = result.Message })); } string path = AppDomain.CurrentDomain.BaseDirectory + "excel/"; savePath = System.IO.Path.Combine(path, FileName); file.SaveAs(savePath); } //string filename = System.IO.Path.GetFileName(file.FileName); string message = string.Empty; DataTable table = Util_XLS.NpoiReadExcle2(savePath, "Sheet1", out message); if (!string.IsNullOrWhiteSpace(message)) { result.Code = Common.ClientCode.Fail; result.Message = message; return(Json(new { code = result.Code, msg = result.Message })); } if (table == null && table.Rows.Count <= 0) { result.Code = Common.ClientCode.Fail; result.Message = "导入Excel中不存在有效信息,请核实!"; return(Json(new { code = result.Code, msg = result.Message })); } IBLL.IEmployeeStopPaymentBLL mbll = new BLL.EmployeeStopPaymentBLL(); string errMsg = mbll.SetStopPaymentFailByExcel(table, LoginInfo.UserID, LoginInfo.UserName); if (errMsg == "") { result.Code = Common.ClientCode.Succeed; result.Message = "导入成功!"; } else { result.Code = Common.ClientCode.Fail; result.Message = errMsg; } return(Json(new { code = result.Code, msg = result.Message })); } catch (Exception ex) { result.Code = Common.ClientCode.Fail; result.Message = ex.Message + "导入失败,请认真检查excel"; return(Json(new { code = result.Code, msg = result.Message })); } #endregion }