public object getLawDetail([FromBody] JObject json)
{
try
{
string res = json.Value <string>("json");
dynamic dy = JsonConvert.DeserializeObject <ExpandoObject>(res);
string fileid = dy.data.fileid;
SafetyLawEntity entity = safetylawbll.GetEntity(fileid);
DataTable cdt = fileInfoBLL.GetFiles(entity.FilesId);
IList <Photo> cfiles = new List <Photo>(); //资料文件
foreach (DataRow item in cdt.Rows)
{
Photo p = new Photo();
p.id = item[0].ToString();
p.filename = item[1].ToString();
p.fileurl = dataitemdetailbll.GetItemValue("imgUrl") + item[2].ToString().Substring(1);
cfiles.Add(p);
}
return(new
{
Code = 0,
Count = -1,
Info = "获取数据成功",
data = new { fileid = entity.Id, filename = entity.FileName, lawarea = entity.LawArea, filecode = entity.FileCode, issuedept = entity.IssueDept, carrydate = string.IsNullOrEmpty(entity.CarryDate.ToString()) ? "" : Convert.ToDateTime(entity.CarryDate).ToString("yyyy-MM-dd"), validversions = entity.ValidVersions, cfiles = cfiles }
});
}
catch (Exception ex)
{
return(new { Code = -1, Count = 0, Info = ex.Message });
}
}
/// <summary>
/// 保存表单（新增、修改）
/// </summary>
/// <param name="keyValue">主键值</param>
/// <param name="entity">实体对象</param>
/// <returns></returns>
public void SaveForm(string keyValue, SafetyLawEntity entity)
{
try
{
service.SaveForm(keyValue, entity);
}
catch (Exception)
{
throw;
}
}
public string ImportLaw(string lawtypecode)
{
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 lawarea = dt.Rows[i][1].ToString();
//文件编号
string filecode = dt.Rows[i][2].ToString();
//颁发部门
string iuusedept = dt.Rows[i][3].ToString();
//施行日期
string carrydate = dt.Rows[i][4].ToString();
//有效版本号
string validversions = dt.Rows[i][5].ToString();
//---****值存在空验证*****--
if (string.IsNullOrEmpty(filename) || string.IsNullOrEmpty(filecode) || string.IsNullOrEmpty(iuusedept) || string.IsNullOrEmpty(carrydate) || string.IsNullOrEmpty(validversions))
{
falseMessage += "</br>" + "第" + (i + 2) + "行值存在空,未能导入.";
error++;
continue;
}
SafetyLawEntity sl = new SafetyLawEntity();
sl.FileName = filename;
sl.LawArea = lawarea;
sl.FileCode = filecode;
sl.IssueDept = iuusedept;
sl.ValidVersions = validversions;
sl.LawTypeCode = lawtypecode;//分类
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.CarryDate = DateTime.Parse(DateTime.Parse(carrydate).ToString("yyyy-MM-dd"));
}
catch
{
falseMessage += "</br>" + "第" + (i + 2) + "行时间有误,未能导入.";
error++;
continue;
}
try
{
safetylawbll.SaveForm("", sl);
fileInfoBLL.SaveForm("", fileEntity);
}
catch
{
error++;
}
}
count = dt.Rows.Count - 1;
message = "共有" + count + "条记录,成功导入" + (count - error) + "条，失败" + error + "条";
message += "</br>" + falseMessage;
}
return(message);
}
public ActionResult SaveForm(string keyValue, SafetyLawEntity entity)
{
entity.LawSource = "0";//内部数据
safetylawbll.SaveForm(keyValue, entity);
return(Success("操作成功。"));
}
