public string ImportStandard(string refid, string refname, string deptcode, string refcode)
{
try
{
if (OperatorProvider.Provider.Current().IsSystem)
{
return("超级管理员无此操作权限");
}
string orgId = OperatorProvider.Provider.Current().OrganizeId;//所属公司
int error = 0;
int success = 0;
string message = "请选择文件格式正确的文件再导入!";
string falseMessage = "";
int count = HttpContext.Request.Files.Count;
if (count > 0)
{
if (HttpContext.Request.Files.Count != 2)
{
return("请按正确的方式导入两个文件.");
}
HttpPostedFileBase file = HttpContext.Request.Files[0];
HttpPostedFileBase file2 = HttpContext.Request.Files[1];
if (string.IsNullOrEmpty(file.FileName) || string.IsNullOrEmpty(file2.FileName))
{
return(message);
}
Boolean isZip1 = file.FileName.Substring(file.FileName.IndexOf('.')).Contains("zip"); //第一个文件是否为Zip格式
Boolean isZip2 = file2.FileName.Substring(file2.FileName.IndexOf('.')).Contains("zip"); //第二个文件是否为Zip格式
if ((isZip1 || isZip2) == false || (isZip1 && isZip2) == true)
{
return(message);
}
string fileName1 = DateTime.Now.ToString("yyyyMMddHHmmss") + System.IO.Path.GetExtension(file.FileName);
file.SaveAs(Server.MapPath("~/Resource/temp/" + fileName1));
string fileName2 = DateTime.Now.ToString("yyyyMMddHHmmss") + System.IO.Path.GetExtension(file2.FileName);
file2.SaveAs(Server.MapPath("~/Resource/temp/" + fileName2));
string decompressionDirectory = Server.MapPath("~/Resource/decompression/") + DateTime.Now.ToString("yyyyMMddhhmmssfff") + "\\";
Aspose.Cells.Workbook wb = new Aspose.Cells.Workbook();
if (isZip1)
{
UnZip(Server.MapPath("~/Resource/temp/" + fileName1), decompressionDirectory, "", true);
wb.Open(Server.MapPath("~/Resource/temp/" + fileName2));
}
else
{
UnZip(Server.MapPath("~/Resource/temp/" + fileName2), decompressionDirectory, "", true);
wb.Open(Server.MapPath("~/Resource/temp/" + fileName1));
}
Aspose.Cells.Cells cells = wb.Worksheets[0].Cells;
DataTable dt = cells.ExportDataTable(1, 0, cells.MaxDataRow, cells.MaxColumn, false);
for (int i = 0; i < dt.Rows.Count; i++)
{
FileManageEntity standard = new FileManageEntity();
standard.ID = Guid.NewGuid().ToString();
//文件名称
string filename = dt.Rows[i][0].ToString();
//文件编号
string fileno = dt.Rows[i][1].ToString();
//---****值存在空验证*****--
if (string.IsNullOrEmpty(filename) || string.IsNullOrEmpty(filename) || string.IsNullOrEmpty(dt.Rows[i][2].ToString()))
{
falseMessage += "</br>" + "第" + (i + 1) + "行值存在空,未能导入.";
error++;
continue;
}
var user = ERCHTMS.Code.OperatorProvider.Provider.Current();
var oldList = filemanagebll.GetList(String.Format(" and createuserorgcode='{0}' and fileno='{1}' and id<>'{2}'", user.OrganizeCode, fileno, standard.ID)).ToList();
var r = oldList.Count > 0;
if (r)
{
falseMessage += "</br>" + "第" + (i + 1) + "行存在相同文件编号,未能导入.";
error++;
continue;
}
bool conbool = false;
//文件路径
string[] filepaths = dt.Rows[i][2].ToString().Split(';');
var filepath = "";
for (int j = 0; j < filepaths.Length; j++)
{
filepath = filepaths[j];
if (string.IsNullOrEmpty(filepath))
{
continue;
}
string strPath = filepath.Substring(filepath.IndexOf('.'));
//---****文件格式验证*****--
if (!(strPath.Contains("doc") || strPath.Contains("docx") || strPath.Contains("pdf") || strPath.Contains("ppt") || strPath.Contains("xlsx") || strPath.Contains("xls") || strPath.Contains("png") || strPath.Contains("jpg") || strPath.Contains("jpeg")))
{
falseMessage += "</br>" + "第" + (i + 1) + "行指定附件格式不正确,未能导入.";
error++;
conbool = true;
continue;
}
//---****文件是否存在验证*****--
if (!System.IO.File.Exists(decompressionDirectory + filepath))
{
falseMessage += "</br>" + "第" + (i + 1) + "行指定附件不存在,未能导入.";
error++;
conbool = true;
continue;
}
var fileinfo = new FileInfo(decompressionDirectory + filepath);
FileInfoEntity fileInfoEntity = new FileInfoEntity();
string fileguid = Guid.NewGuid().ToString();
fileInfoEntity.Create();
fileInfoEntity.RecId = standard.ID; //关联ID
fileInfoEntity.FileName = filepath;
fileInfoEntity.FilePath = "~/Resource/FileManageSystem/" + fileguid + fileinfo.Extension;
fileInfoEntity.FileSize = (Math.Round(decimal.Parse(fileinfo.Length.ToString()) / decimal.Parse("1024"), 2)).ToString();//文件大小（kb）
fileInfoEntity.FileExtensions = fileinfo.Extension;
fileInfoEntity.FileType = fileinfo.Extension.Replace(".", "");
TransportRemoteToServer(Server.MapPath("~/Resource/FileManageSystem/"), decompressionDirectory + filepath, fileguid + fileinfo.Extension);
fileinfobll.SaveForm("", fileInfoEntity);
}
if (conbool)
{
continue;
}
standard.FileName = filename;
standard.FileNo = fileno;
standard.FileTypeId = refid;
standard.FileTypeName = refname;
standard.FileTypeCode = refcode;
DepartmentEntity deptEntity = deptBll.GetEntityByCode(deptcode);
if (deptEntity != null)
{
standard.ReleaseDeptId = deptEntity.DepartmentId;
standard.ReleaseDeptName = deptEntity.FullName;
}
else
{
standard.ReleaseDeptId = OperatorProvider.Provider.Current().DeptId;
standard.ReleaseDeptName = OperatorProvider.Provider.Current().DeptName;
}
if (!string.IsNullOrEmpty(dt.Rows[i][3].ToString()))
{
standard.ReleaseTime = Convert.ToDateTime(dt.Rows[i][3].ToString());
}
standard.Remark = !string.IsNullOrEmpty(dt.Rows[i][4].ToString()) ? dt.Rows[i][4].ToString() : "";
try
{
filemanagebll.SaveForm(standard.ID, standard);
success++;
}
catch
{
error++;
}
}
message = "共有" + dt.Rows.Count + "条记录,成功导入" + success + "条，失败" + error + "条";
message += "</br>" + falseMessage;
}
return(message);
}
catch (Exception e)
{
return("导入的Excel数据格式不正确，请下载标准模板重新填写！");
}
}
public ActionResult SaveForm(string keyValue, FileManageEntity entity)
{
filemanagebll.SaveForm(keyValue, entity);
return(Success("操作成功。"));
}
