/// <summary> /// 保存表单(新增、修改) /// </summary> /// <param name="keyValue">主键值</param> /// <param name="entity">实体对象</param> /// <returns></returns> public void SaveForm(string keyValue, JobApprovalFormEntity entity, List <ManyPowerCheckEntity> data, string arr) { try { service.SaveForm(keyValue, entity, data, arr); if (entity.IsSubmit == 1) { UserBLL userbll = new UserBLL(); DangerousJobFlowDetailEntity flow = DangerousJobFlowDetailIService.GetList().Where(t => t.BusinessId == entity.Id && t.Status == 0).FirstOrDefault(); string userids = DangerousJobFlowDetailIService.GetCurrentStepUser(entity.Id, flow.Id); DataTable dt = userbll.GetUserTable(userids.Split(',')); entity = service.GetEntity(entity.Id); entity.JobLevelName = dataitemdetailbll.GetItemName("DangerousJobCheck", entity.JobLevel); JPushApi.PushMessage(string.Join(",", dt.AsEnumerable().Select(t => t.Field <string>("account")).ToArray()), string.Join(",", dt.AsEnumerable().Select(t => t.Field <string>("realname")).ToArray()), "WXZY001", entity.JobLevelName + "审批单(" + entity.JobTypeName + ")申请待您审批,请您及时处理。", entity.CreateUserName + "于" + entity.CreateDate.Value.ToString("yyyy年MM月dd日") + "申请的" + entity.JobLevelName + "审批单(" + entity.JobTypeName + ")需要您进行审批,请您及时处理。", entity.Id); } //if (entity.FlowState == "1") //{ // UserBLL userbll = new UserBLL(); // UserEntity userEntity = userbll.GetEntity(entity.DutyPersonId);//获取责任人用户信息 // JPushApi.PushMessage(userEntity.Account, entity.DutyPerson, "GZDB001", "例行安全工作", entity.Id); //} } catch (Exception ex) { throw ex; } }
/// <summary> /// 保存表单(新增、修改) /// </summary> /// <param name="keyValue">主键值</param> /// <param name="entity">实体对象</param> /// <returns></returns> public void SaveForm(string keyValue, JobApprovalFormEntity entity) { try { service.SaveForm(keyValue, entity); } catch (Exception) { throw; } }
public ActionResult SaveCancelReason(string keyValue, JobApprovalFormEntity entity) { try { Operator user = OperatorProvider.Provider.Current(); var entity1 = JobApprovalFormbll.GetEntity(keyValue); if (entity1 != null) { entity1.CancelReason = entity.CancelReason; entity1.CancelTime = DateTime.Now; entity1.CancelUserId = user.UserId; entity1.CancelUserName = user.UserName; entity1.JobState = 3;//更改状态(作废) JobApprovalFormbll.SaveForm(keyValue, entity1); } return(Success("操作成功。")); } catch (Exception ex) { return(Error("操作失败。")); } }
/// <summary> /// 开始作业 /// </summary> /// <param name="keyValue"></param> /// <param name="ledgerType"></param> /// <param name="type"></param> /// <param name="worktime"></param> /// <param name="issendmessage"></param> /// <param name="conditioncontent"></param> /// <param name="conditionid"></param> /// <param name="iscomplete"></param> public void LedgerOp(string keyValue, string ledgerType, string type, string worktime, string issendmessage, string conditioncontent, string conditionid = "", string iscomplete = "") { string title = string.Empty; string message = string.Empty; var time = Convert.ToDateTime(worktime); Operator curUser = OperatorProvider.Provider.Current(); JobApprovalFormEntity entity = service.GetEntity(keyValue); string sql = ""; if (type == "HeightWorking" || type == "Lifting" || type == "Digging" || type == "OpenCircuit" || type == "WhenHot" || type == "BlindPlateWall" || type == "LimitedSpace" || type == "EquOverhaulClean") { if (ledgerType == "0") { sql = string.Format(@"update bis_jobsafetycardapply set realityjobstarttime=to_date('{1}','yyyy-mm-dd hh24:mi:ss')," + "jobstate=10,RealityJobEndTime='' where id='{0}'", keyValue, time.ToString("yyyy-MM-dd HH:mm:ss")); } else if (ledgerType == "1") { int jobstate = 9; if (iscomplete == "0") { jobstate = 9;//状态为作业暂停 } else { UserBLL userbll = new UserBLL(); JobSafetyCardApplyBLL JobSafetyCardApplyBLL = new JobSafetyCardApplyBLL(); JobSafetyCardApplyEntity data = JobSafetyCardApplyBLL.GetEntity(keyValue); if (type == "OpenCircuit") { jobstate = 6; //断路作业 结束作业后下一步流程为验收 状态值改为验收中:6 DataTable dt = userbll.GetUserTable(data.CheckPersonId.Split(',')); JPushApi.PushMessage(string.Join(",", dt.AsEnumerable().Select(t => t.Field <string>("account")).ToArray()), data.CheckPerson, "ZYAQZ004", data.JobTypeName + "安全证待您进行作业后验收,请您及时处理。", data.CreateUserName + "于" + data.CreateDate.Value.ToString("yyyy年MM月dd日") + "申请的" + data.JobTypeName + "安全证需要您进行作业后验收,请您及时处理。", data.Id); } else if (type == "EquOverhaulClean") { jobstate = 7; //设备检修清理作业 结束作业后下一步流程为送电 状态值改为送电中:7 DataTable dt = userbll.GetUserTable(data.PowerGivePersonId.Split(',')); JPushApi.PushMessage(string.Join(",", dt.AsEnumerable().Select(t => t.Field <string>("account")).ToArray()), data.PowerGivePerson, "ZYAQZ010", data.JobTypeName + "已结束,待您进行送电,请您及时处理。", data.CreateUserName + "于" + data.CreateDate.Value.ToString("yyyy年MM月dd日") + "申请的" + data.JobTypeName + "已结束,需要您进行送电操作,请您及时处理。", data.Id); } else { jobstate = 11; //其他作业 作业结束即为整个流程结束 状态值为11 } } sql = string.Format("update bis_jobsafetycardapply set jobstate={2},realityjobendtime=to_date('{1}','yyyy-mm-dd hh24:mi:ss') where id='{0}'", keyValue, time.ToString("yyyy-MM-dd HH:mm:ss"), jobstate); } } else { if (ledgerType == "0") { entity.RealityJobStartTime = time; sql = string.Format(@"update BIS_JobApprovalForm set RealityJobStartTime=to_date('{1}','yyyy-mm-dd hh24:mi:ss')," + "WorkOperate='0',RealityJobEndTime='' where id='{0}'", keyValue, time.ToString("yyyy-MM-dd HH:mm:ss")); entity.WorkOperate = "0"; entity.RealityJobEndTime = null; } if (ledgerType == "1") { entity.RealityJobEndTime = time; if (iscomplete == "0") { entity.WorkOperate = "1"; } sql = string.Format("update BIS_JobApprovalForm set WorkOperate='{2}',RealityJobEndTime=to_date('{1}','yyyy-mm-dd hh24:mi:ss') where id='{0}'", keyValue, time.ToString("yyyy-MM-dd HH:mm:ss"), entity.WorkOperate); } //更新作业安全证状态 UpdateGerOp(keyValue, ledgerType, type, worktime, issendmessage, conditioncontent, conditionid, iscomplete); } service.UpdateData(sql); #region 添加执行情况信息 FireWaterCondition Conditionentity = new FireWaterCondition(); Conditionentity.Id = !string.IsNullOrEmpty(conditionid) ? conditionid : ""; Conditionentity.LedgerType = ledgerType; Conditionentity.ConditionTime = time; Conditionentity.ConditionContent = conditioncontent; Conditionentity.ConditionDept = curUser.DeptName; Conditionentity.ConditionDeptCode = curUser.DeptCode; Conditionentity.ConditionDeptId = curUser.DeptId; Conditionentity.ConditionPerson = curUser.UserName; Conditionentity.ConditionPersonId = curUser.UserId; Conditionentity.FireWaterId = keyValue; firewaterbll.SubmitCondition(conditionid, Conditionentity); #endregion }
public ActionResult SaveForm(string keyValue, JobApprovalFormEntity entity, [System.Web.Http.FromBody] string arr) { try { var str = 0; var msg = ""; if (entity.IsSubmit == 1) { var list = JobApprovalFormbll.GetList("").Where(x => x.IsSubmit == 1).Where(x => x.Id != keyValue).ToList(); var JobSafetyCardId = string.Join(",", list.Select(x => x.JobSafetyCardId).ToArray()).Replace(",", "','"); if (!string.IsNullOrEmpty(entity.JobSafetyCardId)) { var cardId = entity.JobSafetyCardId.TrimEnd(',').Split(','); foreach (var item in cardId) { if (JobSafetyCardId.Contains(item)) { str = 1; var Applyentity = jobSafetyCardApplybll.GetEntity(item); msg += Applyentity.JobTypeName + "(" + Applyentity.ApplyNo + "),"; } } if (str == 1) { return(Error(msg.TrimEnd(',') + "作业安全证已被关联,请重新选择。")); } else { //获取业务数据关联的逐级审核流程步骤信息 Operator user = OperatorProvider.Provider.Current(); var data = manyPowerCheckbll.GetListByModuleNo(user.OrganizeCode, entity.ModuleName); JobApprovalFormbll.SaveForm(keyValue, entity, data, arr); return(Success("操作成功。")); } } else { //获取业务数据关联的逐级审核流程步骤信息 Operator user = OperatorProvider.Provider.Current(); var data = manyPowerCheckbll.GetListByModuleNo(user.OrganizeCode, entity.ModuleName); JobApprovalFormbll.SaveForm(keyValue, entity, data, arr); return(Success("操作成功。")); } } else { //获取业务数据关联的逐级审核流程步骤信息 Operator user = OperatorProvider.Provider.Current(); var data = manyPowerCheckbll.GetListByModuleNo(user.OrganizeCode, entity.ModuleName); JobApprovalFormbll.SaveForm(keyValue, entity, data, arr); return(Success("操作成功。")); } } catch (Exception ex) { return(Error("操作失败。" + ex.Message)); } }
public void ExportDetails(string KeyValue) { string fileName = Str.Empty; JobApprovalFormEntity jobapprovalformentity = JobApprovalFormbll.GetEntity(KeyValue); if (jobapprovalformentity == null) { return; } else { if (jobapprovalformentity.JobLevel == "0") { fileName = Server.MapPath("~/Resource/ExcelTemplate/一级危险作业审批单.docx"); } if (jobapprovalformentity.JobLevel == "1") { fileName = Server.MapPath("~/Resource/ExcelTemplate/二级危险作业审批单.docx"); } if (jobapprovalformentity.JobLevel == "2") { fileName = Server.MapPath("~/Resource/ExcelTemplate/三级危险作业审批单.docx"); } Document doc = new Document(fileName); DocumentBuilder builder = new DocumentBuilder(doc); DataSet ds = new DataSet(); DataTable dt = new DataTable(""); dt.Columns.Add("JobDeptName"); //作业单位 dt.Columns.Add("JobContent"); //作业内容 dt.Columns.Add("JobStartTime"); //作业开始时间 dt.Columns.Add("JobEndTime"); //作业结束时间 dt.Columns.Add("JobPlace"); //作业地点 dt.Columns.Add("JobNum"); //作业人数 dt.Columns.Add("JobType"); //危险作业类型 dt.Columns.Add("DangerousDecipher"); //主要危险、危害因素 dt.Columns.Add("SafetyMeasures"); //安全措施(可另附) dt.Columns.Add("AuditRemark1"); //中心(部门)安全管理人员: dt.Columns.Add("AuditRemark2"); //现场安全负责人 dt.Columns.Add("AuditRemark3"); //作业单位主管意见 dt.Columns.Add("AuditRemark4"); //工序确认意见 dt.Columns.Add("AuditRemark5"); //中心(部门)安全管理人员意见 dt.Columns.Add("AuditRemark6"); //中心(部门)负责人意见 dt.Columns.Add("AuditRemark7"); //作业单位负责人意见 dt.Columns.Add("AuditRemark8"); //公司安全环保健康部意见 dt.Columns.Add("AuditRemark9"); //公司分管负责人意见 dt.Columns.Add("AuditUserName1"); //中心(部门)安全管理人员: dt.Columns.Add("AuditUserName2"); //现场安全负责人 dt.Columns.Add("AuditUserName3"); //作业单位主管意见 dt.Columns.Add("AuditUserName4"); //工序确认意见 dt.Columns.Add("AuditUserName5"); //中心(部门)安全管理人员意见 dt.Columns.Add("AuditUserName6"); //中心(部门)负责人意见 dt.Columns.Add("AuditUserName7"); //作业单位负责人意见 dt.Columns.Add("AuditUserName8"); //公司安全环保健康部意见 dt.Columns.Add("AuditUserName9"); //公司分管负责人意见 dt.Columns.Add("Tel1"); //中心(部门)安全管理人员: dt.Columns.Add("Tel2"); //现场安全负责人 dt.Columns.Add("AuditDate3"); //作业单位主管意见 dt.Columns.Add("AuditDate4"); //工序确认意见 dt.Columns.Add("AuditDate5"); //中心(部门)安全管理人员意见 dt.Columns.Add("AuditDate6"); //中心(部门)负责人意见 dt.Columns.Add("AuditDate7"); //作业单位负责人意见 dt.Columns.Add("AuditDate8"); //公司安全环保健康部意见 dt.Columns.Add("AuditDate9"); //公司分管负责人意见 dt.Columns.Add("SignUrl"); //编制人 dt.Columns.Add("SignUrl1"); //审批人 DataRow row1 = dt.NewRow(); string auditdate3 = "年 月 日", //作业单位主管意见 auditdate4 = "年 月 日", //工序确认意见 auditdate5 = "年 月 日", //中心(部门)安全管理人员意见 auditdate6 = "年 月 日", //中心(部门)负责人意见 auditdate7 = "年 月 日", //作业单位负责人意见 auditdate8 = "年 月 日", //公司安全环保健康部意见 auditdate9 = "年 月 日"; //公司分管负责人意见 string defaultstr = "yyyy年MM月dd日"; var table = JobApprovalFormbll.GetCheckInfo(jobapprovalformentity.Id); row1["JobDeptName"] = jobapprovalformentity.JobDeptName; row1["JobContent"] = jobapprovalformentity.JobContent; row1["JobStartTime"] = jobapprovalformentity.JobStartTime.HasValue ? jobapprovalformentity.JobStartTime.Value.ToString("yyyy-MM-dd HH:mm") : ""; row1["JobEndTime"] = jobapprovalformentity.JobEndTime.HasValue ? jobapprovalformentity.JobEndTime.Value.ToString("yyyy-MM-dd HH:mm") : ""; row1["JobPlace"] = jobapprovalformentity.JobPlace; row1["JobNum"] = jobapprovalformentity.JobNum; //row1["JobType"] = jobapprovalformentity.JobTypeName; var JobLevelList = dataItemCache.GetDataItemList("DangerousJobType"); foreach (var item in JobLevelList) { if (jobapprovalformentity.JobType.Contains(item.ItemValue)) { row1["JobType"] += " ☑" + item.ItemName; } else { row1["JobType"] += " □" + item.ItemName; } } //row1["JobType"]+="" Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); var data = classstandardconfigbll.GetList("").Where(t => t.WorkType == "DangerousJobCheck" && t.DeptCode == user.OrganizeCode).FirstOrDefault(); if (data != null) { var newdata = data.Whbs.Split('$'); foreach (var item in newdata) { if (jobapprovalformentity.DangerousDecipher.Contains(item)) { row1["DangerousDecipher"] += " ☑" + item; } else { row1["DangerousDecipher"] += " □" + item; } } } row1["SafetyMeasures"] = jobapprovalformentity.SafetyMeasures; string pic = Server.MapPath("~/content/Images/no_1.png");//默认图片 UserBLL userbll = new UserBLL(); for (int i = 0; i < table.Rows.Count; i++) { if (i + 1 < 3) { var users = userbll.GetEntity(table.Rows[i]["approvepersonid"].ToString()); row1["Tel" + (i + 1)] = users != null ? users.Mobile : ""; } else { if (!string.IsNullOrEmpty(table.Rows[i]["approvetime"].ToString())) { var stime = Convert.ToDateTime(table.Rows[i]["approvetime"]); row1["AuditDate" + (i + 1)] = stime.ToString(defaultstr); } } var filepath = table.Rows[i]["SignUrl"] == null ? "" : (Server.MapPath("~/") + table.Rows[i]["SignUrl"].ToString().Replace("../../", "").ToString()).Replace(@"\/", "/").ToString(); row1["AuditRemark" + (i + 1)] = table.Rows[i]["approveopinion"]; row1["AuditUserName" + (i + 1)] = builder.MoveToMergeField("AuditUserName" + (i + 1));; //中心(部门)安全管理人员: //builder.InsertImage(row["Person1"].ToString(), 80, 35); if (!System.IO.File.Exists(filepath)) { filepath = pic; } builder.InsertImage(filepath, 80, 35); } var signurl = string.IsNullOrEmpty(jobapprovalformentity.SignUrl) ? "" : (Server.MapPath("~/") + jobapprovalformentity.SignUrl.Replace("../../", "").ToString()).Replace(@"\/", "/").ToString(); row1["SignUrl"] = builder.MoveToMergeField("SignUrl"); //row1["SignUrl1"] = builder.MoveToMergeField("SignUrl1"); if (!System.IO.File.Exists(signurl)) { signurl = pic; } builder.InsertImage(signurl, 80, 35); row1["SignUrl1"] = builder.MoveToMergeField("SignUrl1"); if (!System.IO.File.Exists(signurl)) { signurl = pic; } builder.InsertImage(signurl, 80, 35); dt.Rows.Add(row1); doc.MailMerge.Execute(dt); doc.MailMerge.ExecuteWithRegions(dt); var docStream = new MemoryStream(); doc.Save(docStream, SaveOptions.CreateSaveOptions(Aspose.Words.SaveFormat.Doc)); Response.ContentType = "application/msword"; if (jobapprovalformentity.JobLevel == "0") { Response.AddHeader("content-disposition", "attachment;filename=一级危险作业审批单.doc"); } if (jobapprovalformentity.JobLevel == "1") { Response.AddHeader("content-disposition", "attachment;filename=二级危险作业审批单.doc"); } if (jobapprovalformentity.JobLevel == "2") { Response.AddHeader("content-disposition", "attachment;filename=三级危险作业审批单.doc"); } Response.BinaryWrite(docStream.ToArray()); Response.End(); } }