/// <summary>
/// 保存表单（新增、修改）
/// </summary>
/// <param name="keyValue">主键值</param>
/// <param name="entity">实体对象</param>
/// <returns></returns>
public void SaveForm(string keyValue, AccidentCaseLawEntity entity)
{
try
{
service.SaveForm(keyValue, entity);
}
catch (Exception)
{
throw;
}
}
public ActionResult SaveForm(string keyValue, AccidentCaseLawEntity entity)
{
entity.CaseSource = "0";//内部数据
accidentcaselawbll.SaveForm(keyValue, entity);
return(Success("操作成功。"));
}
public string ImportAccidentCase()
{
int error = 0;
string message = "请选择格式正确的文件再导入!";
string falseMessage = "";
int count = HttpContext.Request.Files.Count;
if (count > 0)
{
HttpPostedFileBase file = HttpContext.Request.Files[0];
if (string.IsNullOrEmpty(file.FileName))
{
return(message);
}
if (!(file.FileName.Substring(file.FileName.IndexOf('.')).Contains("xls") || file.FileName.Substring(file.FileName.IndexOf('.')).Contains("xlsx")))
{
return(message);
}
string fileName = DateTime.Now.ToString("yyyyMMddHHmmss") + System.IO.Path.GetExtension(file.FileName);
file.SaveAs(Server.MapPath("~/Resource/temp/" + fileName));
DataTable dt = ExcelHelper.ExcelImport(Server.MapPath("~/Resource/temp/" + fileName));
int order = 1;
if (Directory.Exists(Server.MapPath("~/Resource/ht/images/channel")) == false)//如果不存在就创建file文件夹
{
Directory.CreateDirectory(Server.MapPath("~/Resource/ht/images/channel"));
}
for (int i = 1; i < dt.Rows.Count; i++)
{
order = i;
//文件名称
string filename = dt.Rows[i][0].ToString();
//事故时间
string time = dt.Rows[i][1].ToString();
//备注
string remark = dt.Rows[i][2].ToString();
//---****值存在空验证*****--
if (string.IsNullOrEmpty(filename) || string.IsNullOrEmpty(time))
{
falseMessage += "</br>" + "第" + (i + 2) + "行值存在空,未能导入.";
error++;
continue;
}
AccidentCaseLawEntity sl = new AccidentCaseLawEntity();
sl.FileName = filename;
sl.AccRange = "2";
sl.Remark = remark;
sl.FilesId = Guid.NewGuid().ToString();
FileInfoEntity fileEntity = new FileInfoEntity();
fileEntity.RecId = sl.FilesId;
fileEntity.EnabledMark = 1;
fileEntity.DeleteMark = 0;
fileEntity.FilePath = "~/Resource/ht/images/channel/" + filename;
fileEntity.FileName = sl.FileName;
fileEntity.FolderId = "ht/images";
try
{
sl.AccTime = DateTime.Parse(DateTime.Parse(time).ToString("yyyy-MM-dd HH:mm"));
}
catch
{
falseMessage += "</br>" + "第" + (i + 2) + "行时间有误,未能导入.";
error++;
continue;
}
try
{
accidentcaselawbll.SaveForm("", sl);
fileInfoBLL.SaveForm("", fileEntity);
}
catch
{
error++;
}
}
count = dt.Rows.Count - 1;
message = "共有" + count + "条记录,成功导入" + (count - error) + "条，失败" + error + "条";
message += "</br>" + falseMessage;
}
return(message);
}
