/// <summary>
/// 保存表单（新增、修改）
/// </summary>
/// <param name="keyValue">主键值</param>
/// <param name="entity">实体对象</param>
/// <returns></returns>
public void SaveForm(string keyValue, StandardsystemEntity entity)
{
try
{
service.SaveForm(keyValue, entity);
}
catch (Exception)
{
throw;
}
}
public ActionResult SaveForm(string keyValue, StandardsystemEntity entity)
{
try
{
standardsystembll.SaveForm(keyValue, entity);
return(Success("操作成功。"));
}
catch (Exception ex)
{
throw;
}
}
public string ImportStandard(string standardtype, string categorycode)
{
if (OperatorProvider.Provider.Current().IsSystem)
{
return("超级管理员无此操作权限");
}
string orgId = OperatorProvider.Provider.Current().OrganizeId;//所属公司
int error = 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(2, 0, cells.MaxDataRow - 1, cells.MaxColumn + 1, false);
for (int i = 1; i < dt.Rows.Count; i++)
{
//文件名称
string filename = dt.Rows[i][0].ToString();
//文件路径
string filepath = dt.Rows[i][1].ToString();
//相应元素
string relevantelement = "";
string relevantelementname = "";
string relevantelementid = "";
//实施日期
string carrydate = "";
if (standardtype == "1" || standardtype == "2" || standardtype == "3" || standardtype == "4" || standardtype == "5" || standardtype == "6")
{
relevantelement = dt.Rows[i][2].ToString();
carrydate = dt.Rows[i][3].ToString();
}
//文学字号
string dispatchcode = "";
//颁布部门
string publishdept = "";
if (standardtype == "6")
{
dispatchcode = dt.Rows[i][4].ToString();
publishdept = dt.Rows[i][5].ToString();
}
string dutyid = "";
string dutyName = "";
//---****值存在空验证*****--
if (string.IsNullOrEmpty(filename) || string.IsNullOrEmpty(filepath))
{
falseMessage += "</br>" + "第" + (i + 3) + "行值存在空,未能导入.";
error++;
continue;
}
//---****文件格式验证*****--
if (!(filepath.Substring(filepath.IndexOf('.')).Contains("doc") || filepath.Substring(filepath.IndexOf('.')).Contains("docx") || filepath.Substring(filepath.IndexOf('.')).Contains("pdf")))
{
falseMessage += "</br>" + "第" + (i + 3) + "行附件格式不正确,未能导入.";
error++;
continue;
}
//---****文件是否存在验证*****--
if (!System.IO.File.Exists(decompressionDirectory + filepath))
{
falseMessage += "</br>" + "第" + (i + 3) + "行附件不存在,未能导入.";
error++;
continue;
}
//--**验证岗位是否存在 * *--
int startnum = 4;
if (standardtype == "1" || standardtype == "2" || standardtype == "3" || standardtype == "4" || standardtype == "5")
{
startnum = 4;
}
else if (standardtype == "6")
{
startnum = 6;
}
else if (standardtype == "7" || standardtype == "8" || standardtype == "9")
{
startnum = 2;
}
for (int j = startnum; j < dt.Columns.Count; j++)
{
if (!dt.Rows[i][j].IsEmpty())
{
foreach (var item in dt.Rows[i][j].ToString().Split(','))
{
DepartmentEntity dept = DepartmentBLL.GetList().Where(t => t.OrganizeId == orgId && t.FullName == dt.Rows[0][j].ToString()).FirstOrDefault();
if (dept == null)
{
continue;
}
RoleEntity re = postBLL.GetList().Where(a => a.FullName == item.ToString() && a.OrganizeId == orgId && a.DeleteMark == 0 && a.EnabledMark == 1 && a.DeptId == dept.DepartmentId).FirstOrDefault();
if (re == null)
{
//falseMessage += "</br>" + "第" + (i + 3) + "行岗位有误,未能导入.";
//error++;
continue;
}
else
{
dutyid += re.RoleId + ",";
dutyName += re.FullName + ",";
}
}
}
}
dutyid = dutyid.Length > 0 ? dutyid.Substring(0, dutyid.Length - 1) : "";
dutyName = dutyName.Length > 0 ? dutyName.Substring(0, dutyName.Length - 1) : "";
StandardsystemEntity standard = new StandardsystemEntity();
try
{
if (!string.IsNullOrEmpty(carrydate))
{
standard.CARRYDATE = DateTime.Parse(DateTime.Parse(carrydate).ToString("yyyy-MM-dd"));
}
}
catch
{
falseMessage += "</br>" + "第" + (i + 3) + "行时间有误,未能导入.";
error++;
continue;
}
if (!string.IsNullOrEmpty(relevantelement))
{
foreach (var item in relevantelement.Split(','))
{
ElementEntity re = elementBLL.GetList("").Where(a => a.NAME == item.ToString()).FirstOrDefault();
if (re == null)
{
//falseMessage += "</br>" + "第" + (i + 2) + "行相应元素有误,未能导入.";
//error++;
continue;
}
else
{
relevantelementname += re.NAME + ",";
relevantelementid += re.ID + ",";
}
}
}
relevantelementname = string.IsNullOrEmpty(relevantelementname) ? "" : relevantelementname.Substring(0, relevantelementname.Length - 1);
relevantelementid = string.IsNullOrEmpty(relevantelementid) ? "" : relevantelementid.Substring(0, relevantelementid.Length - 1);
standard.FILENAME = filename;
standard.STATIONID = dutyid;
standard.STATIONNAME = dutyName;
standard.RELEVANTELEMENTNAME = relevantelementname;
standard.RELEVANTELEMENTID = relevantelementid;
standard.DISPATCHCODE = dispatchcode;
standard.PUBLISHDEPT = publishdept;
standard.STANDARDTYPE = standardtype;
standard.CATEGORYCODE = categorycode;
standard.CONSULTNUM = 0;
standard.ID = Guid.NewGuid().ToString();
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/StandardSystem/" + 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/StandardSystem/"), decompressionDirectory + filepath, fileguid + fileinfo.Extension);
fileinfobll.SaveForm("", fileInfoEntity);
try
{
standardsystembll.SaveForm(standard.ID, standard);
}
catch
{
error++;
}
}
count = dt.Rows.Count - 1;
message = "共有" + count + "条记录,成功导入" + (count - error) + "条，失败" + error + "条";
message += "</br>" + falseMessage;
}
return(message);
}