/// <summary> /// 保存表单(新增、修改) /// </summary> /// <param name="keyValue">主键值</param> /// <param name="entity">实体对象</param> /// <param name="kpiEntity">考核信息</param> /// <returns></returns> public void SaveForm(string keyValue, SafepunishEntity entity, SafekpidataEntity kpiEntity) { try { service.SaveForm(keyValue, entity, kpiEntity); } catch (Exception ex) { throw; } }
public ActionResult GetFormJson(string keyValue) { SafepunishEntity data = safepunishbll.GetEntity(keyValue); if (data.AmerceType == "2") { data.PunishType = ""; } var kpidata = safekpidatabll.GetList("").Where(p => p.SafePunishId == keyValue).FirstOrDefault(); object obj = new { punishdata = data, kpidata = kpidata }; return(ToJsonResult(obj)); }
public ActionResult SaveForm(string keyValue, SafepunishEntity entity, SafekpidataEntity kpiEntity, [System.Web.Http.FromBody] string punishJson, [System.Web.Http.FromBody] string relatedpunishJson) { var year = DateTime.Now.ToString("yyyy"); var month = DateTime.Now.ToString("MM"); var day = DateTime.Now.ToString("dd"); var punishCode = "Q/CRPHZHB 2208.06.01-JL02-" + year + month + day + safepunishbll.GetPunishCode(); entity.SafePunishCode = !string.IsNullOrEmpty(entity.SafePunishCode) ? entity.SafePunishCode : punishCode; safepunishbll.SaveForm(keyValue, entity, kpiEntity); if (entity.AmerceType == "2" || entity.AmerceType == "3" || entity.AmerceType == "4") { if (punishJson.Length > 0) { if (safepunishdetailbll.Remove(keyValue, "0") > 0) { List <SafepunishdetailEntity> list = Newtonsoft.Json.JsonConvert.DeserializeObject <List <SafepunishdetailEntity> >(punishJson); foreach (SafepunishdetailEntity data in list) { safepunishdetailbll.SaveForm("", data); } } } if (relatedpunishJson.Length > 0) { if (safepunishdetailbll.Remove(keyValue, "1") > 0) { List <SafepunishdetailEntity> list = Newtonsoft.Json.JsonConvert.DeserializeObject <List <SafepunishdetailEntity> >(relatedpunishJson); foreach (SafepunishdetailEntity data in list) { safepunishdetailbll.SaveForm("", data); } } } } return(Success("操作成功。")); }
public ActionResult CommitApply(string keyValue, AptitudeinvestigateauditEntity entity, SafepunishEntity punEntity, SafekpidataEntity kpiEntity, [System.Web.Http.FromBody] string punishJson, [System.Web.Http.FromBody] string relatedpunishJson) { if (punEntity != null && (string.IsNullOrEmpty(punEntity.ApplyState) || punEntity.ApplyState == "0")) { var year = DateTime.Now.ToString("yyyy"); var month = DateTime.Now.ToString("MM"); var day = DateTime.Now.ToString("dd"); var punishCode = "Q/CRPHZHB 2208.06.01-JL02-" + year + month + day + safepunishbll.GetPunishCode(); punEntity.SafePunishCode = !string.IsNullOrEmpty(punEntity.SafePunishCode) ? punEntity.SafePunishCode : punishCode; safepunishbll.SaveForm(keyValue, punEntity, kpiEntity); if (punishJson.Length > 0) { if (safepunishdetailbll.Remove(keyValue, "0") > 0) { List <SafepunishdetailEntity> list = Newtonsoft.Json.JsonConvert.DeserializeObject <List <SafepunishdetailEntity> >(punishJson); foreach (SafepunishdetailEntity data in list) { safepunishdetailbll.SaveForm("", data); } } } if (relatedpunishJson.Length > 0) { if (safepunishdetailbll.Remove(keyValue, "1") > 0) { List <SafepunishdetailEntity> list = Newtonsoft.Json.JsonConvert.DeserializeObject <List <SafepunishdetailEntity> >(relatedpunishJson); foreach (SafepunishdetailEntity data in list) { safepunishdetailbll.SaveForm("", data); } } } } if (!string.IsNullOrEmpty(keyValue) && entity != null) { safepunishbll.CommitApply(keyValue, entity); } return(Success("操作成功。")); }
/// <summary> /// 导出安全惩罚详细 /// </summary> /// <param name="keyValue"></param> /// <returns></returns> public ActionResult ExportSafePunishInfo(string keyValue) { HttpResponse resp = System.Web.HttpContext.Current.Response; //报告对象 string fileName = "安全惩罚审批单_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".doc"; string strDocPath = Request.PhysicalApplicationPath + @"Resource\ExcelTemplate\安全考核导出模板.docx"; Aspose.Words.Document doc = new Aspose.Words.Document(strDocPath); DocumentBuilder builder = new DocumentBuilder(doc); DataTable dt = new DataTable(); dt.Columns.Add("PunishCode"); //编号 dt.Columns.Add("CreateDept"); //所属专业(部门) dt.Columns.Add("ApplyTime"); //申请时间 dt.Columns.Add("BelongDept"); //被考核部门 dt.Columns.Add("PunishNum"); //考核金额 dt.Columns.Add("PunishRemark"); //事件描述 dt.Columns.Add("filed1"); //第一个区域名称 dt.Columns.Add("filed2"); //第二个区域名称 dt.Columns.Add("approve1"); //第一步审核意见 dt.Columns.Add("approvename1"); //第二步审核意见 dt.Columns.Add("approvetime1"); //第一步审核意见 dt.Columns.Add("approve2"); //第二步审核意见 dt.Columns.Add("approvename2"); //第一步审核意见 dt.Columns.Add("approvetime2"); //第二步审核意见 DataRow row = dt.NewRow(); //安全考核信息 SafepunishEntity safepunishentity = safepunishbll.GetEntity(keyValue); row["PunishCode"] = safepunishentity.SafePunishCode; row["PunishRemark"] = safepunishentity.PunishRemark; row["CreateDept"] = safepunishentity.BelongDept; row["ApplyTime"] = safepunishentity.ApplyTime.IsEmpty() ? "" : Convert.ToDateTime(safepunishentity.ApplyTime).ToString("yyyy-MM-dd"); if (safepunishentity.AmerceType == "1" || safepunishentity.AmerceType == "2") { row["filed1"] = "部门意见"; row["filed2"] = "分管领导意见"; } else if (safepunishentity.AmerceType == "3" || safepunishentity.AmerceType == "4") { row["filed1"] = "专业意见"; row["filed2"] = "部门意见"; } var flist = fileinfobll.GetImageListByRecid(keyValue); builder.MoveToMergeField("PunishImage"); foreach (FileInfoEntity fmode in flist) { string path = ""; if (string.IsNullOrWhiteSpace(fmode.FilePath)) { path = Server.MapPath("~/content/Images/no_1.png"); } else { var filepath = Server.MapPath("~/") + fmode.FilePath.Replace("~/", "").ToString(); if (System.IO.File.Exists(filepath)) { path = filepath; } else { path = Server.MapPath("~/content/Images/no_1.png"); } } builder.MoveToMergeField("RewardImage"); builder.InsertImage(path, 200, 160); } row["approve1"] = safepunishentity.SpecialtyOpinion; row["approvetime1"] = safepunishentity.CreateDate.IsEmpty() ? "" : Convert.ToDateTime(safepunishentity.CreateDate).ToString("yyyy-MM-dd"); UserEntity createuser = new UserBLL().GetEntity(safepunishentity.CreateUserId); if (createuser.SignImg.IsEmpty()) { row["approvename1"] = Server.MapPath("~/content/Images/no_1.png"); } else { var filepath = Server.MapPath("~/") + createuser.SignImg.ToString().Replace("../../", "").ToString(); if (System.IO.File.Exists(filepath)) { row["approvename1"] = filepath; } else { row["approvename1"] = Server.MapPath("~/content/Images/no_1.png"); } } builder.MoveToMergeField("approvename1"); builder.InsertImage(row["approvename1"].ToString(), 80, 35); //获取被考核对象 SafepunishdetailEntity safepunishdetailentity = safepunishdetailbll.GetListByPunishId(keyValue, "0").OrderBy(t => t.CreateDate).FirstOrDefault(); row["BelongDept"] = departmentbll.GetEntity(safepunishdetailentity.BelongDept) == null ? "" : departmentbll.GetEntity(safepunishdetailentity.BelongDept).FullName; row["PunishNum"] = safepunishdetailentity.PunishNum; DataTable dtAptitude = safepunishbll.GetAptitudeInfo(keyValue); for (int i = dtAptitude.Rows.Count - 1; i > 0; i--) { if (i == (dtAptitude.Rows.Count - 2)) { row["approve2"] = dtAptitude.Rows[i]["auditremark"]; row["approvetime2"] = dtAptitude.Rows[i]["auditdate"].IsEmpty() ? "" : Convert.ToDateTime(dtAptitude.Rows[i]["auditdate"]).ToString("yyyy-MM-dd"); if (dtAptitude.Rows[i]["auditsignimg"].IsEmpty()) { row["approvename2"] = Server.MapPath("~/content/Images/no_1.png"); } else { var filepath = Server.MapPath("~/") + dtAptitude.Rows[i]["auditsignimg"].ToString().Replace("../../", "").ToString(); if (System.IO.File.Exists(filepath)) { row["approvename2"] = filepath; } else { row["approvename2"] = Server.MapPath("~/content/Images/no_1.png"); } } builder.MoveToMergeField("approvename2"); builder.InsertImage(row["approvename2"].ToString(), 80, 35); } } dt.Rows.Add(row); doc.MailMerge.Execute(dt); doc.MailMerge.DeleteFields(); doc.Save(resp, Server.UrlEncode(fileName), ContentDisposition.Attachment, Aspose.Words.Saving.SaveOptions.CreateSaveOptions(SaveFormat.Doc)); return(Success("导出成功!")); }