protected override void OnFlowEnd(T_Qualification_PostTotal entity, Workflow.Logic.Domain.S_WF_InsTaskExec taskExec, Workflow.Logic.Domain.S_WF_InsDefRouting routing) { if (entity == null) { return; } var sql = string.Format("select * from T_Qualification_Postqualificationmanagement where T_Qualification_PostTotalID ='{0}'", entity.ID); var dt = HRSQLDB.ExecuteDataTable(sql); var dicList = FormulaHelper.DataTableToListDic(dt); foreach (var item in dicList) { var userid = item.GetValue("Users"); var quali = BusinessEntities.Set <S_Qualification_Postqualificationmanagement>().FirstOrDefault(p => p.Users == userid); if (quali == null) { quali = new S_Qualification_Postqualificationmanagement(); quali.ID = FormulaHelper.CreateGuid(); BusinessEntities.Set <S_Qualification_Postqualificationmanagement>().Add(quali); } UpdateEntity <S_Qualification_Postqualificationmanagement>(quali, item); } BusinessEntities.SaveChanges(); sql = string.Format("update T_Qualification_Postqualificationmanagement set IsApprove='True' where T_Qualification_PostTotalID ='{0}'", entity.ID); HRSQLDB.ExecuteNonQuery(sql); }
public override bool ExecTaskExec(Workflow.Logic.Domain.S_WF_InsTaskExec taskExec, Workflow.Logic.Domain.S_WF_InsDefRouting routing, string nextExecUserIDs, string nextExecUserNames, string nextExecUserIDsGroup, string nextExecRoleIDs, string nextExecOrgIDs, string execComment) { var bol = base.ExecTaskExec(taskExec, routing, nextExecUserIDs, nextExecUserNames, nextExecUserIDsGroup, nextExecRoleIDs, nextExecOrgIDs, execComment); if (routing.Code == "ToHR") { var formID = taskExec.S_WF_InsFlow.FormInstanceID; //反写流程表单ID至待审批资质 string updateSql = string.Format("update T_Qualification_Postqualificationmanagement set T_Qualification_PostTotalID = '{0}' where isnull(IsApprove,'False')='False' ", formID); HRSQLDB.ExecuteNonQuery(updateSql); } return(bol); }
protected override void OnFlowEnd(T_Trainmanagement_TrainplanApproval entity, Workflow.Logic.Domain.S_WF_InsTaskExec taskExec, Workflow.Logic.Domain.S_WF_InsDefRouting routing) { if (entity == null) { return; } if (string.IsNullOrEmpty(entity.RelateID)) { entity.RelateID = entity.ID; } var detailList = entity.T_Trainmanagement_TrainplanApproval_Trainplan.ToList(); if (detailList.Count == 0) { return; } HRSQLDB.ExecuteNonQuery("delete from S_Train_CompPlan where FormID ='" + entity.RelateID + "'"); foreach (var item in detailList) { S_Train_CompPlan plan = new S_Train_CompPlan(); plan.ID = Formula.FormulaHelper.CreateGuid(); plan.FormID = entity.RelateID; BusinessEntities.Set <S_Train_CompPlan>().Add(plan); plan.InOrOut = "In"; //将表单主表数据更新至结果表 UpdateEntity <S_Train_CompPlan>(plan, entity.ToDic()); //将表单子表数据更新至结果表 UpdateEntity <S_Train_CompPlan>(plan, item.ToDic()); } entity.IsNewVersion = "True"; string sql = string.Format("update T_Trainmanagement_TrainplanApproval set IsNewVersion = 'False' where RelateID='{0}' and ID <>'{1}'", entity.RelateID, entity.ID); HRSQLDB.ExecuteNonQuery(sql); BusinessEntities.SaveChanges(); }
protected override void OnFlowEnd(T_Trainmanagement_Departmenttrainplan entity, Workflow.Logic.Domain.S_WF_InsTaskExec taskExec, Workflow.Logic.Domain.S_WF_InsDefRouting routing) { if (entity != null) { if (string.IsNullOrEmpty(entity.RelateID)) { entity.RelateID = entity.ID; } var list = entity.T_Trainmanagement_Departmenttrainplan_Trainplan.ToList(); HRSQLDB.ExecuteNonQuery("delete from S_Train_DeptPlan where FormID ='" + entity.RelateID + "'"); foreach (var item in list) { S_Train_DeptPlan plan = new S_Train_DeptPlan(); plan.ID = Formula.FormulaHelper.CreateGuid(); //更新主表对应的数据 UpdateEntity <S_Train_DeptPlan>(plan, entity.ToDic()); //更新子表对应的数据 UpdateEntity <S_Train_DeptPlan>(plan, item.ToDic()); plan.FormID = entity.RelateID; plan.InOrOut = "In"; BusinessEntities.Set <S_Train_DeptPlan>().Add(plan); } //更新本年的部门培训通知状态 var sql = string.Format("update S_Train_DeptTask set IsSubmit = 'True' where Dept = '{0}' and Trainyears ='{1}'", entity.Putdept, entity.Trainyears); HRSQLDB.ExecuteNonQuery(sql); entity.IsNewVersion = "True"; sql = string.Format("update T_Trainmanagement_Departmenttrainplan set IsNewVersion = 'False' where RelateID='{0}' and ID <>'{1}'", entity.RelateID, entity.ID); HRSQLDB.ExecuteNonQuery(sql); BusinessEntities.SaveChanges(); } base.OnFlowEnd(entity, taskExec, routing); }