public ActionResult ImportPersonData()
{
string UnitID = RequestHelper.GetStrByName("UnitID"),
RowID = RequestHelper.GetStrByName("RowID");
if (string.IsNullOrEmpty(UnitID) || string.IsNullOrEmpty(RowID))
{
return(operateContext.RedirectAjax(1, "参数异常~", "", ""));
}
var files = Request.Files;
if (files == null || files.Count <= 0)
{
return(null);
}
string file_name = "工资模板" + operateContext.Usr.login_name;
string pathServer = "~/UpFile/WageManager";
string path = Server.MapPath(pathServer);
if (!Directory.Exists(path.ToString()))
{
Directory.CreateDirectory(path.ToString());//文件夹不存在则创建
}
HttpPostedFileBase file = Request.Files["filePerson"];
//1.上传文档
string sreUrl = Server.MapPath(pathServer + "/" + file_name + "." + file.FileName.Split('.')[1]);
file.SaveAs(sreUrl);//上传文件
System.Data.DataTable dt = NpoiHelper.ImportExcelToDataTable(sreUrl);
if (null == dt || dt.Rows.Count <= 0)
{
return(operateContext.RedirectAjax(1, "导入数据为空~", "", ""));
}
bool mark = operateContext.bllSession.WGJG02_Template.ImportPersonData(dt, UnitID, RowID);
if (mark)
{
return(operateContext.RedirectAjax(0, "导入成功~", "", ""));
}
return(operateContext.RedirectAjax(1, "导入失败~", "", ""));
}
