/// <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("操作成功。"));
}
