GroupStepForDelegation.cs 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474
  1. using Google.Protobuf.WellKnownTypes;
  2. using Microsoft.AspNetCore.DataProtection.KeyManagement;
  3. using OASystem.Domain.Common;
  4. using OASystem.Domain.Dtos.Groups;
  5. using OASystem.Domain.Entities.Groups;
  6. using OASystem.Domain.Enums;
  7. using OASystem.Infrastructure.Repositories.Groups;
  8. using System.Configuration;
  9. using static OpenAI.GPT3.ObjectModels.SharedModels.IOpenAiModels;
  10. namespace OASystem.API.OAMethodLib
  11. {
  12. /// <summary>
  13. /// 团组流程管控
  14. /// </summary>
  15. public static class GroupStepForDelegation
  16. {
  17. private readonly static GrpScheduleRepository _grpScheduleRep = AutofacIocManager.Instance.GetService<GrpScheduleRepository>();
  18. /// <summary>
  19. /// 创建流程管控
  20. /// </summary>
  21. /// <param name="DiId">团组Id</param>
  22. public static async void CreateWorkStep(int DiId)
  23. {
  24. //var _grpScheduleRep = AutofacIocManager.Instance.GetService<GrpScheduleRepository>();
  25. //判断是否已存在团组的流程管控
  26. Grp_ScheduleInfo check = _grpScheduleRep.Query(s => s.DiId == DiId).First();
  27. if (check == null)
  28. {
  29. _grpScheduleRep.BeginTran();
  30. GroupsConfig _groupConfig = AutofacIocManager.Instance.GetService<GroupsConfig>();
  31. DateTime dftBeginDt = DateTime.Now.AddDays(_groupConfig.ExBeginDays);//默认预计开始时间
  32. DateTime dftEndDt = DateTime.Now.AddDays(_groupConfig.ExEndDays);//默认预计结束时间
  33. #region 主流程
  34. Grp_ScheduleInfo _primary = new Grp_ScheduleInfo();
  35. _primary.CreateUserId = _groupConfig.AutoCreate;
  36. _primary.DiId = DiId;
  37. _primary.Exception = 0;
  38. _primary.ExpectBeginDt = dftBeginDt;
  39. _primary.ExpectEndDt = dftEndDt;
  40. _primary.Leader = _groupConfig.Leader;
  41. _primary.PrimaryStep = GrpSchedulePrimaryStepEnum.Wait;
  42. _primary.Remark = "请设置各流程负责人、预计开始/结束时间";
  43. int _primaryId = await _grpScheduleRep.AddAsyncReturnId(_primary);
  44. if (_primaryId > 0)
  45. {
  46. #region 子流程
  47. List<Grp_ScheduleDetailInfo> entityList = new List<Grp_ScheduleDetailInfo>();
  48. #region 模板
  49. Grp_ScheduleDetailInfo _model = new Grp_ScheduleDetailInfo();
  50. _model.CreateUserId = _groupConfig.AutoCreate;
  51. _model.Duty = _groupConfig.DefaultUser;
  52. _model.Exception = 0;
  53. _model.ExpectBeginDt = dftBeginDt;
  54. _model.ExpectEndDt = dftEndDt;
  55. _model.Remark = "未设置负责人";
  56. _model.ScheduleId = _primaryId;
  57. _model.StepStatus = 0;
  58. #endregion
  59. #region 经费预算
  60. Grp_ScheduleDetailInfo grp_budget202 = _model.DeepClone();
  61. grp_budget202.JobContent = GrpSchedulePrimaryStepEnum.BudgetChild02.GetEnumDescription();
  62. grp_budget202.ParentStep = (int)GrpSchedulePrimaryStepEnum.Budget;
  63. grp_budget202.Step = (int)GrpSchedulePrimaryStepEnum.BudgetChild02;
  64. grp_budget202.SLevel = 2;
  65. entityList.Add(grp_budget202);
  66. #endregion
  67. #region 市场部人员报价对接/反馈
  68. //上传明细单
  69. Grp_ScheduleDetailInfo grp_feedback302 = _model.DeepClone();
  70. grp_feedback302.JobContent = GrpSchedulePrimaryStepEnum.FeedbackChild02.GetEnumDescription();
  71. grp_feedback302.ParentStep = (int)GrpSchedulePrimaryStepEnum.Feedback;
  72. grp_feedback302.Step = (int)GrpSchedulePrimaryStepEnum.FeedbackChild02;
  73. grp_feedback302.SLevel = 2;
  74. entityList.Add(grp_feedback302);
  75. //录入最终总经费预算
  76. Grp_ScheduleDetailInfo grp_feedback303 = _model.DeepClone();
  77. grp_feedback303.JobContent = GrpSchedulePrimaryStepEnum.FeedbackChild03.GetEnumDescription();
  78. grp_feedback303.ParentStep = (int)GrpSchedulePrimaryStepEnum.Feedback;
  79. grp_feedback303.Step = (int)GrpSchedulePrimaryStepEnum.FeedbackChild03;
  80. grp_feedback303.SLevel = 2;
  81. entityList.Add(grp_feedback303);
  82. //完成报价对接/反馈
  83. Grp_ScheduleDetailInfo grp_feedback304 = _model.DeepClone();
  84. grp_feedback304.JobContent = GrpSchedulePrimaryStepEnum.FeedbackChild04.GetEnumDescription();
  85. grp_feedback304.ParentStep = (int)GrpSchedulePrimaryStepEnum.Feedback;
  86. grp_feedback304.Step = (int)GrpSchedulePrimaryStepEnum.FeedbackChild04;
  87. grp_feedback304.SLevel = 2;
  88. entityList.Add(grp_feedback304);
  89. #endregion
  90. #region (目前为空)报批流程
  91. #endregion
  92. #region 护照/签证
  93. //收集资料
  94. Grp_ScheduleDetailInfo grp_visa502 = _model.DeepClone();
  95. grp_visa502.JobContent = GrpSchedulePrimaryStepEnum.VisaChild02.GetEnumDescription();
  96. grp_visa502.ParentStep = (int)GrpSchedulePrimaryStepEnum.Visa;
  97. grp_visa502.Step = (int)GrpSchedulePrimaryStepEnum.VisaChild02;
  98. grp_visa502.SLevel = 2;
  99. entityList.Add(grp_visa502);
  100. //取护照资料
  101. Grp_ScheduleDetailInfo grp_visa503 = _model.DeepClone();
  102. grp_visa503.JobContent = GrpSchedulePrimaryStepEnum.VisaChild03.GetEnumDescription();
  103. grp_visa503.ParentStep = (int)GrpSchedulePrimaryStepEnum.Visa;
  104. grp_visa503.Step = (int)GrpSchedulePrimaryStepEnum.VisaChild03;
  105. grp_visa503.SLevel = 2;
  106. entityList.Add(grp_visa503);
  107. //填资料
  108. Grp_ScheduleDetailInfo grp_visa504 = _model.DeepClone();
  109. grp_visa504.JobContent = GrpSchedulePrimaryStepEnum.VisaChild04.GetEnumDescription();
  110. grp_visa504.ParentStep = (int)GrpSchedulePrimaryStepEnum.Visa;
  111. grp_visa504.Step = (int)GrpSchedulePrimaryStepEnum.VisaChild04;
  112. grp_visa504.SLevel = 2;
  113. entityList.Add(grp_visa504);
  114. //送签
  115. Grp_ScheduleDetailInfo grp_visa505 = _model.DeepClone();
  116. grp_visa505.JobContent = GrpSchedulePrimaryStepEnum.VisaChild05.GetEnumDescription();
  117. grp_visa505.ParentStep = (int)GrpSchedulePrimaryStepEnum.Visa;
  118. grp_visa505.Step = (int)GrpSchedulePrimaryStepEnum.VisaChild05;
  119. grp_visa505.SLevel = 2;
  120. entityList.Add(grp_visa505);
  121. //出签+取护照
  122. Grp_ScheduleDetailInfo grp_visa506 = _model.DeepClone();
  123. grp_visa506.JobContent = GrpSchedulePrimaryStepEnum.VisaChild06.GetEnumDescription();
  124. grp_visa506.ParentStep = (int)GrpSchedulePrimaryStepEnum.Visa;
  125. grp_visa506.Step = (int)GrpSchedulePrimaryStepEnum.VisaChild06;
  126. grp_visa506.SLevel = 2;
  127. entityList.Add(grp_visa506);
  128. //归还护照
  129. Grp_ScheduleDetailInfo grp_visa507 = _model.DeepClone();
  130. grp_visa507.JobContent = GrpSchedulePrimaryStepEnum.VisaChild07.GetEnumDescription();
  131. grp_visa507.ParentStep = (int)GrpSchedulePrimaryStepEnum.Visa;
  132. grp_visa507.Step = (int)GrpSchedulePrimaryStepEnum.VisaChild07;
  133. grp_visa507.SLevel = 2;
  134. entityList.Add(grp_visa507);
  135. //签证费用录入
  136. Grp_ScheduleDetailInfo grp_visa508 = _model.DeepClone();
  137. grp_visa508.JobContent = GrpSchedulePrimaryStepEnum.VisaChild08.GetEnumDescription();
  138. grp_visa508.ParentStep = (int)GrpSchedulePrimaryStepEnum.Visa;
  139. grp_visa508.Step = (int)GrpSchedulePrimaryStepEnum.VisaChild08;
  140. grp_visa508.SLevel = 2;
  141. entityList.Add(grp_visa508);
  142. #endregion
  143. #region 业务操作
  144. //机票
  145. Grp_ScheduleDetailInfo grp_busJP601 = _model.DeepClone();
  146. grp_busJP601.JobContent = GrpSchedulePrimaryStepEnum.BusinessJP.GetEnumDescription();
  147. grp_busJP601.ParentStep = (int)GrpSchedulePrimaryStepEnum.Business;
  148. grp_busJP601.Step = (int)GrpSchedulePrimaryStepEnum.BusinessJP;
  149. grp_busJP601.SLevel = 2;
  150. entityList.Add(grp_busJP601);
  151. //机票-询价并导入黑屏代码
  152. Grp_ScheduleDetailInfo grp_busJP6012 = _model.DeepClone();
  153. grp_busJP6012.JobContent = GrpSchedulePrimaryStepEnum.BusinessJPChild02.GetEnumDescription();
  154. grp_busJP6012.ParentStep = (int)GrpSchedulePrimaryStepEnum.BusinessJP;
  155. grp_busJP6012.Step = (int)GrpSchedulePrimaryStepEnum.BusinessJPChild02;
  156. grp_busJP6012.SLevel = 3;
  157. entityList.Add(grp_busJP6012);
  158. //机票-机票已占位
  159. Grp_ScheduleDetailInfo grp_busJP6013 = _model.DeepClone();
  160. grp_busJP6013.JobContent = GrpSchedulePrimaryStepEnum.BusinessJPChild03.GetEnumDescription();
  161. grp_busJP6013.ParentStep = (int)GrpSchedulePrimaryStepEnum.BusinessJP;
  162. grp_busJP6013.Step = (int)GrpSchedulePrimaryStepEnum.BusinessJPChild03;
  163. grp_busJP6013.SLevel = 3;
  164. entityList.Add(grp_busJP6013);
  165. //机票-已出票
  166. Grp_ScheduleDetailInfo grp_busJP6014 = _model.DeepClone();
  167. grp_busJP6014.JobContent = GrpSchedulePrimaryStepEnum.BusinessJPChild04.GetEnumDescription();
  168. grp_busJP6014.ParentStep = (int)GrpSchedulePrimaryStepEnum.BusinessJP;
  169. grp_busJP6014.Step = (int)GrpSchedulePrimaryStepEnum.BusinessJPChild04;
  170. grp_busJP6014.SLevel = 3;
  171. entityList.Add(grp_busJP6014);
  172. //机票-机票费用录入
  173. Grp_ScheduleDetailInfo grp_busJP6015 = _model.DeepClone();
  174. grp_busJP6015.JobContent = GrpSchedulePrimaryStepEnum.BusinessJPChild05.GetEnumDescription();
  175. grp_busJP6015.ParentStep = (int)GrpSchedulePrimaryStepEnum.BusinessJP;
  176. grp_busJP6015.Step = (int)GrpSchedulePrimaryStepEnum.BusinessJPChild05;
  177. grp_busJP6015.SLevel = 3;
  178. entityList.Add(grp_busJP6015);
  179. //酒店
  180. Grp_ScheduleDetailInfo grp_busJD602 = _model.DeepClone();
  181. grp_busJD602.JobContent = GrpSchedulePrimaryStepEnum.BusinessJD.GetEnumDescription();
  182. grp_busJD602.ParentStep = (int)GrpSchedulePrimaryStepEnum.Business;
  183. grp_busJD602.Step = (int)GrpSchedulePrimaryStepEnum.BusinessJD;
  184. grp_busJD602.SLevel = 2;
  185. entityList.Add(grp_busJD602);
  186. //酒店-酒店费用录入
  187. Grp_ScheduleDetailInfo grp_busJD6022 = _model.DeepClone();
  188. grp_busJD6022.JobContent = GrpSchedulePrimaryStepEnum.BusinessJDChild02.GetEnumDescription();
  189. grp_busJD6022.ParentStep = (int)GrpSchedulePrimaryStepEnum.BusinessJD;
  190. grp_busJD6022.Step = (int)GrpSchedulePrimaryStepEnum.BusinessJDChild02;
  191. grp_busJD6022.SLevel = 3;
  192. entityList.Add(grp_busJD6022);
  193. //OP
  194. Grp_ScheduleDetailInfo grp_busOP603 = _model.DeepClone();
  195. grp_busOP603.JobContent = GrpSchedulePrimaryStepEnum.BusinessOP.GetEnumDescription();
  196. grp_busOP603.ParentStep = (int)GrpSchedulePrimaryStepEnum.Business;
  197. grp_busOP603.Step = (int)GrpSchedulePrimaryStepEnum.BusinessOP;
  198. grp_busOP603.SLevel = 2;
  199. entityList.Add(grp_busOP603);
  200. //OP-OP询价
  201. Grp_ScheduleDetailInfo grp_busOP6032 = _model.DeepClone();
  202. grp_busOP6032.JobContent = GrpSchedulePrimaryStepEnum.BusinessOPChild02.GetEnumDescription();
  203. grp_busOP6032.ParentStep = (int)GrpSchedulePrimaryStepEnum.BusinessOP;
  204. grp_busOP6032.Step = (int)GrpSchedulePrimaryStepEnum.BusinessOPChild02;
  205. grp_busOP6032.SLevel = 3;
  206. entityList.Add(grp_busOP6032);
  207. //OP-OP费用录入
  208. Grp_ScheduleDetailInfo grp_busOP6033 = _model.DeepClone();
  209. grp_busOP6033.JobContent = GrpSchedulePrimaryStepEnum.BusinessOPChild03.GetEnumDescription();
  210. grp_busOP6033.ParentStep = (int)GrpSchedulePrimaryStepEnum.BusinessOP;
  211. grp_busOP6033.Step = (int)GrpSchedulePrimaryStepEnum.BusinessOPChild03;
  212. grp_busOP6033.SLevel = 3;
  213. entityList.Add(grp_busOP6032);
  214. //商邀
  215. Grp_ScheduleDetailInfo grp_busSY604 = _model.DeepClone();
  216. grp_busSY604.JobContent = GrpSchedulePrimaryStepEnum.BusinessSY.GetEnumDescription();
  217. grp_busSY604.ParentStep = (int)GrpSchedulePrimaryStepEnum.Business;
  218. grp_busSY604.Step = (int)GrpSchedulePrimaryStepEnum.BusinessSY;
  219. grp_busSY604.SLevel = 2;
  220. entityList.Add(grp_busSY604);
  221. //商邀-商邀报批
  222. Grp_ScheduleDetailInfo grp_busSY6042 = _model.DeepClone();
  223. grp_busSY6042.JobContent = GrpSchedulePrimaryStepEnum.BusinessSYChild02.GetEnumDescription();
  224. grp_busSY6042.ParentStep = (int)GrpSchedulePrimaryStepEnum.BusinessSY;
  225. grp_busSY6042.Step = (int)GrpSchedulePrimaryStepEnum.BusinessSYChild02;
  226. grp_busSY6042.SLevel = 3;
  227. entityList.Add(grp_busSY6042);
  228. //商邀-商邀费用录入
  229. Grp_ScheduleDetailInfo grp_busSY6043 = _model.DeepClone();
  230. grp_busSY6043.JobContent = GrpSchedulePrimaryStepEnum.BusinessSYChild03.GetEnumDescription();
  231. grp_busSY6043.ParentStep = (int)GrpSchedulePrimaryStepEnum.BusinessSY;
  232. grp_busSY6043.Step = (int)GrpSchedulePrimaryStepEnum.BusinessSYChild03;
  233. grp_busSY6043.SLevel = 3;
  234. entityList.Add(grp_busSY6043);
  235. #endregion
  236. #region 费用审批
  237. //机票费用审批
  238. Grp_ScheduleDetailInfo grp_cost702 = _model.DeepClone();
  239. grp_cost702.JobContent = GrpSchedulePrimaryStepEnum.CostAuditChild02.GetEnumDescription();
  240. grp_cost702.ParentStep = (int)GrpSchedulePrimaryStepEnum.CostAudit;
  241. grp_cost702.Step = (int)GrpSchedulePrimaryStepEnum.CostAuditChild02;
  242. grp_cost702.Duty = _groupConfig.Boss;
  243. grp_cost702.SLevel = 2;
  244. entityList.Add(grp_cost702);
  245. //酒店费用审批
  246. Grp_ScheduleDetailInfo grp_cost703 = _model.DeepClone();
  247. grp_cost703.JobContent = GrpSchedulePrimaryStepEnum.CostAuditChild03.GetEnumDescription();
  248. grp_cost703.ParentStep = (int)GrpSchedulePrimaryStepEnum.CostAudit;
  249. grp_cost703.Step = (int)GrpSchedulePrimaryStepEnum.CostAuditChild03;
  250. grp_cost703.Duty = _groupConfig.Boss;
  251. grp_cost703.SLevel = 2;
  252. entityList.Add(grp_cost703);
  253. //OP费用审批
  254. Grp_ScheduleDetailInfo grp_cost704 = _model.DeepClone();
  255. grp_cost704.JobContent = GrpSchedulePrimaryStepEnum.CostAuditChild04.GetEnumDescription();
  256. grp_cost704.ParentStep = (int)GrpSchedulePrimaryStepEnum.CostAudit;
  257. grp_cost704.Step = (int)GrpSchedulePrimaryStepEnum.CostAuditChild04;
  258. grp_cost704.Duty = _groupConfig.Boss;
  259. grp_cost704.SLevel = 2;
  260. entityList.Add(grp_cost704);
  261. //OP费用审批
  262. Grp_ScheduleDetailInfo grp_cost705 = _model.DeepClone();
  263. grp_cost705.JobContent = GrpSchedulePrimaryStepEnum.CostAuditChild05.GetEnumDescription();
  264. grp_cost705.ParentStep = (int)GrpSchedulePrimaryStepEnum.CostAudit;
  265. grp_cost705.Step = (int)GrpSchedulePrimaryStepEnum.CostAuditChild05;
  266. grp_cost705.Duty = _groupConfig.Boss;
  267. grp_cost705.SLevel = 2;
  268. entityList.Add(grp_cost705);
  269. //增减款项审批
  270. Grp_ScheduleDetailInfo grp_cost706 = _model.DeepClone();
  271. grp_cost706.JobContent = GrpSchedulePrimaryStepEnum.CostAuditChild06.GetEnumDescription();
  272. grp_cost706.ParentStep = (int)GrpSchedulePrimaryStepEnum.CostAudit;
  273. grp_cost706.Step = (int)GrpSchedulePrimaryStepEnum.CostAuditChild06;
  274. grp_cost706.Duty = _groupConfig.Boss;
  275. grp_cost706.SLevel = 2;
  276. entityList.Add(grp_cost706);
  277. #endregion
  278. #region 付款给供应商
  279. //OP费用付款
  280. Grp_ScheduleDetailInfo grp_pay802 = _model.DeepClone();
  281. grp_pay802.JobContent = GrpSchedulePrimaryStepEnum.PayChild02.GetEnumDescription();
  282. grp_pay802.ParentStep = (int)GrpSchedulePrimaryStepEnum.Pay;
  283. grp_pay802.Step = (int)GrpSchedulePrimaryStepEnum.PayChild02;
  284. grp_pay802.SLevel = 2;
  285. entityList.Add(grp_pay802);
  286. //商邀费用付款
  287. Grp_ScheduleDetailInfo grp_pay803 = _model.DeepClone();
  288. grp_pay803.JobContent = GrpSchedulePrimaryStepEnum.PayChild03.GetEnumDescription();
  289. grp_pay803.ParentStep = (int)GrpSchedulePrimaryStepEnum.Pay;
  290. grp_pay803.Step = (int)GrpSchedulePrimaryStepEnum.PayChild03;
  291. grp_pay803.SLevel = 2;
  292. entityList.Add(grp_pay803);
  293. //增减款项付款
  294. Grp_ScheduleDetailInfo grp_pay804 = _model.DeepClone();
  295. grp_pay804.JobContent = GrpSchedulePrimaryStepEnum.PayChild04.GetEnumDescription();
  296. grp_pay804.ParentStep = (int)GrpSchedulePrimaryStepEnum.Pay;
  297. grp_pay804.Step = (int)GrpSchedulePrimaryStepEnum.PayChild04;
  298. grp_pay804.SLevel = 2;
  299. entityList.Add(grp_pay804);
  300. #endregion
  301. #region (目前为空)出行事项会议
  302. #endregion
  303. #region (目前为空)送机
  304. #endregion
  305. #region (目前为空)接机
  306. #endregion
  307. #region 收款
  308. //收款完成
  309. Grp_ScheduleDetailInfo grp_col01 = _model.DeepClone();
  310. grp_col01.JobContent = GrpSchedulePrimaryStepEnum.CollectChild01.GetEnumDescription();
  311. grp_col01.ParentStep = (int)GrpSchedulePrimaryStepEnum.Collect;
  312. grp_col01.Step = (int)GrpSchedulePrimaryStepEnum.CollectChild01;
  313. grp_col01.ExpectBeginDt = dftEndDt;
  314. grp_col01.ExpectEndDt = dftEndDt.AddMonths(3);
  315. grp_col01.SLevel = 2;
  316. entityList.Add(grp_col01);
  317. #endregion
  318. #region (目前为空)团组完成
  319. #endregion
  320. //SqlSugar批量添加
  321. _grpScheduleRep.bulkInsert(entityList);
  322. #endregion
  323. #region 流程管控成员
  324. string sqlPerson = string.Format(@"Select u.Id As SysUserId,u.CnName As SysUserName,JobName as JobStr
  325. From Sys_Users As u With(Nolock)
  326. Inner Join Sys_Department as d With(Nolock) On u.DepId=d.Id
  327. Inner Join Sys_JobPost as j With(Nolock) On u.JobPostId=j.Id
  328. Where d.Id={0} And u.Id not in({1})", DepartmentCode.IC, _groupConfig.FilterUser);
  329. List<Grp_SchedulePersonInfo> personList = await _grpScheduleRep.GetEntityList_SchedulePersonBySql(sqlPerson);
  330. if (personList.Count > 0)
  331. {
  332. foreach (var item in personList)
  333. {
  334. item.CreateUserId = _groupConfig.DefaultUser;
  335. item.ScheduleId = _primaryId;
  336. }
  337. _grpScheduleRep.bulkInsert(personList);
  338. }
  339. #endregion
  340. }
  341. else
  342. {
  343. _grpScheduleRep.RollbackTran();
  344. }
  345. #endregion
  346. _grpScheduleRep.CommitTran();
  347. }
  348. }
  349. public static async void ChangeStepForPrimary(int DiId, GrpSchedulePrimaryStepEnum primary, int isDel, int exception, string remark)
  350. {
  351. //var _grpScheduleRep = AutofacIocManager.Instance.GetService<GrpScheduleRepository>();
  352. string sqlPrimary = string.Format(@" Select * From Grp_Schedule With(Nolock) Where IsDel=0 And DiId={0} ", DiId);
  353. Grp_ScheduleInfo _grpPrimaryInfo = _grpScheduleRep.GetSingleInfoBySqlWithNolock(sqlPrimary);
  354. if (_grpPrimaryInfo != null)
  355. {
  356. _grpPrimaryInfo.PrimaryStep = primary;
  357. _grpPrimaryInfo.IsDel = isDel;
  358. _grpPrimaryInfo.Exception = exception;
  359. _grpPrimaryInfo.Remark += ";" + remark;
  360. var result = await _grpScheduleRep._sqlSugar.Updateable<Grp_ScheduleInfo>()
  361. .Where(s => s.Id == _grpPrimaryInfo.Id)
  362. .UpdateColumns(s => new { s.PrimaryStep, s.IsDel, s.Exception, s.Remark })
  363. .ExecuteCommandAsync();
  364. }
  365. }
  366. #region 流程管控步骤推进
  367. /// <summary>
  368. /// 刷新团组管控最新状态,或推进流程到下一节点
  369. /// </summary>
  370. /// <param name="scheduleId">团组流程Id</param>
  371. public static async void RefreshWorkStep(int scheduleId, bool auto = false)
  372. {
  373. //var _grpScheduleRep = AutofacIocManager.Instance.GetService<GrpScheduleRepository>();
  374. string sqlPrimary = string.Format(@" Select * From Grp_Schedule With(Nolock) Where IsDel=0 And Id={0} ", scheduleId);
  375. Grp_ScheduleInfo _grpPrimaryInfo = _grpScheduleRep.GetSingleInfoBySqlWithNolock(sqlPrimary);
  376. if (_grpPrimaryInfo != null)
  377. {
  378. List<Grp_ScheduleDetailInfo> _list = _grpScheduleRep._sqlSugar.Queryable<Grp_ScheduleDetailInfo>()
  379. .Where(s => s.ScheduleId == scheduleId && s.IsDel != 1 && s.ParentStep == (int)_grpPrimaryInfo.PrimaryStep && s.StepStatus != 2)
  380. .ToList();
  381. if (_list.Count > 0)
  382. {
  383. //未完成主流程节点下所有步骤任务
  384. }
  385. else
  386. {
  387. //可推进节点
  388. if (auto)
  389. {
  390. int nextPrimaryStep = (int)_grpPrimaryInfo.PrimaryStep + 1;
  391. var result = await _grpScheduleRep._sqlSugar.Updateable<Grp_ScheduleInfo>()
  392. .Where(s => s.Id == _grpPrimaryInfo.Id)
  393. .UpdateColumns(s => new { nextPrimaryStep })
  394. .ExecuteCommandAsync();
  395. }
  396. }
  397. //eg:CheckStep_Budget
  398. //switch (_grpPrimaryInfo.PrimaryStep)
  399. //{
  400. // case GrpSchedulePrimaryStepEnum.Budget: CheckStep_Budget(scheduleId); break;
  401. //}
  402. }
  403. }
  404. /// <summary>
  405. /// 暂无需求,先保存,可扩展至查询验证主流程下每一个详细流程步骤对应的业务操作是否完成,需要其他业务提供验证方法
  406. /// 查看流程-经费预算
  407. /// </summary>
  408. /// <param name="scheduleId"></param>
  409. /// <returns>true:已完成所有步骤,false:存在未完成的步骤(Grp_ScheduleDetail.StepStatus:0/1/2)</returns>
  410. private static bool CheckStep_Budget(int scheduleId)
  411. {
  412. List<Grp_ScheduleDetailInfo> _list = _grpScheduleRep._sqlSugar.Queryable<Grp_ScheduleDetailInfo>()
  413. .Where(s => s.ScheduleId == scheduleId && s.IsDel != 1 && s.ParentStep == (int)GrpSchedulePrimaryStepEnum.Budget)
  414. .ToList();
  415. foreach (var item in _list)
  416. {
  417. switch (item.Step)
  418. {
  419. case (int)GrpSchedulePrimaryStepEnum.BudgetChild01:
  420. //验证方法
  421. break;
  422. case (int)GrpSchedulePrimaryStepEnum.BudgetChild02: break;
  423. }
  424. }
  425. return false;
  426. }
  427. #endregion
  428. }
  429. }