/// <summary> /// 保存表单(新增、修改) /// </summary> /// <param name="keyValue">主键值</param> /// <param name="entity">实体对象</param> /// <returns></returns> public void SaveForm(string keyValue, ReserverplanEntity entity) { try { service.SaveForm(keyValue, entity); } catch (Exception ex) { var a = ex.Message; throw; } }
public string ImportReserverplanData() { try { if (OperatorProvider.Provider.Current().IsSystem) { return("超级管理员无此操作权限"); } int error = 0; string message = "请选择格式正确的文件再导入!"; string falseMessage = ""; int count = HttpContext.Request.Files.Count; if (count > 0) { 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)); } Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); var sheet = wb.Worksheets[0]; if (sheet.Cells[1, 0].StringValue != "应急预案名称" || sheet.Cells[1, 1].StringValue != "应急预案类型" || sheet.Cells[1, 2].StringValue != "编制部门" || sheet.Cells[1, 4].StringValue != "编制时间" || sheet.Cells[1, 5].StringValue != "审核部门" || sheet.Cells[1, 6].StringValue != "审核人" || sheet.Cells[1, 7].StringValue != "审核时间" || sheet.Cells[1, 8].StringValue != "单位性质" || sheet.Cells[1, 9].StringValue != "是否评审" || sheet.Cells[1, 10].StringValue != "附件") { return(message); } for (int i = 2; i <= sheet.Cells.MaxDataRow; i++) { count++; if (string.IsNullOrWhiteSpace(sheet.Cells[i, 0].StringValue) || string.IsNullOrWhiteSpace(sheet.Cells[i, 1].StringValue) || string.IsNullOrWhiteSpace(sheet.Cells[i, 2].StringValue) || string.IsNullOrWhiteSpace(sheet.Cells[i, 4].StringValue) || string.IsNullOrWhiteSpace(sheet.Cells[i, 6].StringValue) || string.IsNullOrWhiteSpace(sheet.Cells[i, 6].StringValue) || string.IsNullOrWhiteSpace(sheet.Cells[i, 7].StringValue) || string.IsNullOrWhiteSpace(sheet.Cells[i, 8].StringValue) || string.IsNullOrWhiteSpace(sheet.Cells[i, 9].StringValue) || string.IsNullOrWhiteSpace(sheet.Cells[i, 10].StringValue)) { falseMessage += "</br>" + "第" + (i + 1) + "行未按模板要求填写,未能导入."; error++; continue; } ReserverplanEntity planEntity = new ReserverplanEntity(); planEntity.NAME = sheet.Cells[i, 0].StringValue; planEntity.PLANTYPENAME = sheet.Cells[i, 1].StringValue; var dataItem1 = new DataItemDetailBLL().GetDataItemListByItemCode("'MAE_PlanType'").Where(x => x.ItemName == sheet.Cells[i, 1].StringValue).ToList().FirstOrDefault(); if (dataItem1 != null) { planEntity.PLANTYPE = dataItem1.ItemValue; } //编制部门 var dept = new DepartmentBLL().GetList().Where(x => x.FullName == sheet.Cells[i, 2].StringValue).ToList().FirstOrDefault(); if (dept == null) { falseMessage += "</br>" + "第" + (i + 1) + "行编制部门不正确,未能导入."; error++; continue; } planEntity.DEPARTID_BZ = dept.DepartmentId; planEntity.DEPARTNAME_BZ = dept.FullName; //编制人 planEntity.USERNAME_BZ = sheet.Cells[i, 3].StringValue; //var userEntity = new UserBLL().GetList().Where(x => x.RealName == sheet.Cells[2, 3].StringValue).ToList().FirstOrDefault(); //if (userEntity != null) { // planEntity.USERID_BZ = userEntity.UserId; //} //审核部门 var auditDept = new DepartmentBLL().GetList().Where(x => x.FullName == sheet.Cells[i, 5].StringValue).ToList().FirstOrDefault(); if (auditDept == null) { falseMessage += "</br>" + "第" + (i + 1) + "行审核部门不正确,未能导入."; error++; continue; } planEntity.DEPARTID_SH = auditDept.DepartmentId; planEntity.DEPARTNAME_SH = auditDept.FullName; planEntity.USERNAME_SH = sheet.Cells[i, 6].StringValue; var userEntity1 = new UserBLL().GetList().Where(x => x.RealName == sheet.Cells[i, 6].StringValue).ToList().FirstOrDefault(); if (userEntity1 != null) { planEntity.USERID_SH = userEntity1.UserId; } DateTime s = new DateTime(); try { s = DateTime.Parse(sheet.Cells[i, 4].StringValue); planEntity.DATATIME_BZ = s; } catch (Exception) { falseMessage += "</br>" + "第" + (i + 1) + "行编制时间格式不正确,未能导入."; error++; continue; } try { s = DateTime.Parse(sheet.Cells[i, 7].StringValue); planEntity.DATATIME_SH = s; } catch (Exception) { falseMessage += "</br>" + "第" + (i + 1) + "行审核时间格式不正确,未能导入."; error++; continue; } planEntity.ORGXZTYPE = sheet.Cells[i, 8].StringValue == "单位内部" ? 1 : 2; planEntity.ORGXZNAME = sheet.Cells[i, 8].StringValue; planEntity.ISAUDITNAME = sheet.Cells[i, 9].StringValue; var dataItem = new DataItemDetailBLL().GetDataItemListByItemCode("'MAE_IsAudit'").Where(x => x.ItemName == sheet.Cells[i, 9].StringValue).ToList().FirstOrDefault(); if (dataItem != null) { planEntity.ISAUDIT = dataItem.ItemValue; } planEntity.ID = Guid.NewGuid().ToString(); //文件路径 string filepath = sheet.Cells[i, 10].StringValue; var fileinfo = new FileInfo(decompressionDirectory + filepath); FileInfoEntity fileInfoEntity = new FileInfoEntity(); string fileguid = Guid.NewGuid().ToString(); fileInfoEntity.Create(); fileInfoEntity.RecId = planEntity.ID; //关联ID fileInfoEntity.FileName = filepath; fileInfoEntity.FilePath = "~/Resource/Reserverplan/" + 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/Reserverplan/"), decompressionDirectory + filepath, fileguid + fileinfo.Extension); fileinfobll.SaveForm("", fileInfoEntity); planEntity.FILES = fileInfoEntity.RecId; try { reserverplanbll.SaveForm(planEntity.ID, planEntity); } catch { error++; } } message = "共有" + count + "条记录,成功导入" + (count - error) + "条,失败" + error + "条。"; if (error > 0) { message += "</br>" + falseMessage; } } return(message); } catch (Exception ex) { return(ex.Message); } }
public ActionResult SaveForm(string keyValue, ReserverplanEntity entity) { reserverplanbll.SaveForm(keyValue, entity); return(Success("操作成功。")); }