CourseServiceBus.cs 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318
  1. using Azure.Cosmos;
  2. using Microsoft.Azure.WebJobs;
  3. using System;
  4. using System.Collections.Generic;
  5. using System.Text;
  6. using System.Text.Json;
  7. using System.Threading.Tasks;
  8. using TEAMModelOS.SDK.DI;
  9. using TEAMModelOS.SDK.Extension;
  10. using TEAMModelOS.SDK;
  11. using TEAMModelOS.SDK.Models;
  12. using TEAMModelOS.SDK.Models.Cosmos.Common;
  13. using HTEXLib.COMM.Helpers;
  14. namespace TEAMModelFunction
  15. {
  16. public class CourseServiceBus
  17. {
  18. private readonly AzureCosmosFactory _azureCosmos;
  19. private readonly DingDing _dingDing;
  20. public CourseServiceBus(AzureCosmosFactory azureCosmos, DingDing dingDing)
  21. {
  22. _azureCosmos = azureCosmos;
  23. _dingDing = dingDing;
  24. }
  25. /// <summary>
  26. /// 完善课程变更
  27. /// </summary>
  28. /// <data msg>
  29. /// CourseChange
  30. ///// </data>
  31. /// <param name="msg"></param>
  32. /// <returns></returns>
  33. [FunctionName("Course")]
  34. public async Task Course([ServiceBusTrigger("%Azure:ServiceBus:ActiveTask%", "course", Connection = "Azure:ServiceBus:ConnectionString")] string msg)
  35. {
  36. var client = _azureCosmos.GetCosmosClient();
  37. try
  38. {
  39. //await _dingDing.SendBotMsg($"ServiceBus,CourseChange:{msg}", GroupNames.醍摩豆服務運維群組);
  40. var jsonMsg = JsonDocument.Parse(msg);
  41. CourseChange courseChange = msg.ToObject<CourseChange>();
  42. if (courseChange == null)
  43. {
  44. return;
  45. }
  46. foreach (var cls in courseChange.addClass)
  47. {
  48. (List<RMember> tchList, List<RGroupList> classLists) = await GroupListService.GetStutmdidListids(client, _dingDing, new List<string> { cls }, courseChange.school);
  49. var addStudentsCls = tchList.FindAll(x => x.type == 2);
  50. var addTmdidsCls = tchList.FindAll(x => x.type == 1);
  51. foreach (var stu in addStudentsCls)
  52. {
  53. try
  54. {
  55. ItemResponse<StuCourse> stuCourse = await client.GetContainer(Constant.TEAMModelOS, "Student").ReadItemAsync<StuCourse>(courseChange.id, new PartitionKey($"StuCourse-{courseChange.school}-{stu.id}"));
  56. if (!stuCourse.Value.classId.Contains(cls))
  57. {
  58. stuCourse.Value.classId.Add(cls);
  59. }
  60. await client.GetContainer(Constant.TEAMModelOS, "Student").ReplaceItemAsync<StuCourse>(stuCourse, courseChange.id, new PartitionKey($"StuCourse-{courseChange.school}-{stu.id}"));
  61. }
  62. catch (CosmosException ex)
  63. {
  64. if (ex.Response.Status == 404)
  65. {
  66. var course = new StuCourse
  67. {
  68. id = courseChange.id,
  69. scode = courseChange.code,
  70. name = courseChange.name,
  71. code = $"StuCourse-{courseChange.school}-{stu.id}",
  72. scope = courseChange.scope,
  73. school = courseChange.school,
  74. creatorId = courseChange.creatorId,
  75. classId = new List<string> { cls },
  76. pk = "StuCourse",
  77. createTime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds()
  78. };
  79. await client.GetContainer(Constant.TEAMModelOS, "Student").CreateItemAsync(course, new PartitionKey(course.code));
  80. }
  81. }
  82. }
  83. foreach (var tmd in addTmdidsCls)
  84. {
  85. try
  86. {
  87. ItemResponse<StuCourse> stuCourse = await client.GetContainer(Constant.TEAMModelOS, "Student").ReadItemAsync<StuCourse>(courseChange.id, new PartitionKey($"StuCourse-{tmd.id}"));
  88. if (!stuCourse.Value.classId.Contains(cls))
  89. {
  90. stuCourse.Value.classId.Add(cls);
  91. }
  92. await client.GetContainer(Constant.TEAMModelOS, "Student").ReplaceItemAsync<StuCourse>(stuCourse, courseChange.id, new PartitionKey($"StuCourse-{tmd.id}"));
  93. }
  94. catch (CosmosException ex)
  95. {
  96. if (ex.Response.Status == 404)
  97. {
  98. var course = new StuCourse
  99. {
  100. id = courseChange.id,
  101. scode = courseChange.code,
  102. name = courseChange.name,
  103. code = $"StuCourse-{tmd.id}",
  104. scope = courseChange.scope,
  105. school = courseChange.school,
  106. creatorId = courseChange.creatorId,
  107. classId = new List<string> { cls },
  108. pk = "StuCourse",
  109. createTime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds()
  110. };
  111. await client.GetContainer(Constant.TEAMModelOS, "Student").CreateItemAsync(course, new PartitionKey(course.code));
  112. }
  113. }
  114. }
  115. }
  116. foreach (var list in courseChange.addList)
  117. {
  118. (List<RMember> tchList, List<RGroupList> classLists) = await GroupListService.GetStutmdidListids(client, _dingDing, new List<string> { list }, courseChange.school);
  119. var addStudentsCls = tchList.FindAll(x => x.type == 2);
  120. var addTmdidsCls = tchList.FindAll(x => x.type == 1);
  121. foreach (var stu in addStudentsCls)
  122. {
  123. try
  124. {
  125. ItemResponse<StuCourse> stuCourse = await client.GetContainer(Constant.TEAMModelOS, "Student").ReadItemAsync<StuCourse>(courseChange.id, new PartitionKey($"StuCourse-{stu.code}-{stu.id}"));
  126. if (!stuCourse.Value.stulist.Contains(list))
  127. {
  128. stuCourse.Value.stulist.Add(list);
  129. await client.GetContainer(Constant.TEAMModelOS, "Student").ReplaceItemAsync<StuCourse>(stuCourse, courseChange.id, new PartitionKey($"StuCourse-{stu.code}-{stu.id}"));
  130. }
  131. }
  132. catch (CosmosException ex)
  133. {
  134. if (ex.Response.Status == 404)
  135. {
  136. var course = new StuCourse
  137. {
  138. id = courseChange.id,
  139. scode = courseChange.code,
  140. name = courseChange.name,
  141. code = $"StuCourse-{courseChange.school}-{stu.id}",
  142. scope = courseChange.scope,
  143. school = courseChange.school,
  144. creatorId = courseChange.creatorId,
  145. stulist = new List<string> { list },
  146. pk = "StuCourse",
  147. createTime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds()
  148. };
  149. await client.GetContainer(Constant.TEAMModelOS, "Student").CreateItemAsync(course, new PartitionKey(course.code));
  150. }
  151. }
  152. }
  153. foreach (var tmd in addTmdidsCls)
  154. {
  155. try
  156. {
  157. ItemResponse<StuCourse> stuCourse = await client.GetContainer(Constant.TEAMModelOS, "Student").ReadItemAsync<StuCourse>(courseChange.id, new PartitionKey($"StuCourse-{tmd.id}"));
  158. if (!stuCourse.Value.stulist.Contains(list))
  159. {
  160. stuCourse.Value.stulist.Add(list);
  161. await client.GetContainer(Constant.TEAMModelOS, "Student").ReplaceItemAsync<StuCourse>(stuCourse, courseChange.id, new PartitionKey($"StuCourse-{tmd.id}"));
  162. }
  163. }
  164. catch (CosmosException ex)
  165. {
  166. if (ex.Response.Status == 404)
  167. {
  168. var course = new StuCourse
  169. {
  170. id = courseChange.id,
  171. scode = courseChange.code,
  172. name = courseChange.name,
  173. code = $"StuCourse-{tmd.id}",
  174. scope = courseChange.scope,
  175. school = courseChange.school,
  176. creatorId = courseChange.creatorId,
  177. stulist = new List<string> { list },
  178. pk = "StuCourse",
  179. createTime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds()
  180. };
  181. await client.GetContainer(Constant.TEAMModelOS, "Student").CreateItemAsync(course, new PartitionKey(course.code));
  182. }
  183. }
  184. }
  185. }
  186. foreach (var delCls in courseChange.delClass)
  187. {
  188. (List<RMember> tchList, List<RGroupList> classLists) = await GroupListService.GetStutmdidListids(client, _dingDing, new List<string> { delCls }, courseChange.school);
  189. var delStudentsCls = tchList.FindAll(x => x.type == 2);
  190. var delTmdidsCls = tchList.FindAll(x => x.type == 1);
  191. foreach (var stu in delStudentsCls)
  192. {
  193. try
  194. {
  195. ItemResponse<StuCourse> stuCourse = await client.GetContainer(Constant.TEAMModelOS, "Student").ReadItemAsync<StuCourse>(courseChange.id, new PartitionKey($"StuCourse-{courseChange.school}-{stu.id}"));
  196. if (stuCourse.Value.classId.Contains(delCls))
  197. {
  198. stuCourse.Value.classId.Remove(delCls);
  199. }
  200. if (!stuCourse.Value.classId.IsNotEmpty() && !stuCourse.Value.stulist.IsNotEmpty())
  201. {
  202. //当两个列表都不存在时则直接删除
  203. await client.GetContainer(Constant.TEAMModelOS, "Student").DeleteItemAsync<StuCourse>(courseChange.id, new PartitionKey($"StuCourse-{courseChange.school}-{stu.id}"));
  204. }
  205. else
  206. {
  207. await client.GetContainer(Constant.TEAMModelOS, "Student").ReplaceItemAsync<StuCourse>(stuCourse, courseChange.id, new PartitionKey($"StuCourse-{courseChange.school}-{stu.id}"));
  208. }
  209. }
  210. catch (CosmosException ex)
  211. {
  212. }
  213. }
  214. foreach (var tmd in delTmdidsCls)
  215. {
  216. try
  217. {
  218. ItemResponse<StuCourse> stuCourse = await client.GetContainer(Constant.TEAMModelOS, "Student").ReadItemAsync<StuCourse>(courseChange.id, new PartitionKey($"StuCourse-{tmd.id}"));
  219. if (stuCourse.Value.classId.Contains(delCls))
  220. {
  221. stuCourse.Value.classId.Remove(delCls);
  222. }
  223. if (!stuCourse.Value.classId.IsNotEmpty() && !stuCourse.Value.stulist.IsNotEmpty())
  224. {
  225. //当两个列表都不存在时则直接删除
  226. await client.GetContainer(Constant.TEAMModelOS, "Student").DeleteItemAsync<StuCourse>(courseChange.id, new PartitionKey($"StuCourse-{tmd.id}"));
  227. }
  228. else
  229. {
  230. await client.GetContainer(Constant.TEAMModelOS, "Student").ReplaceItemAsync<StuCourse>(stuCourse, courseChange.id, new PartitionKey($"StuCourse-{tmd.id}"));
  231. }
  232. }
  233. catch (CosmosException ex)
  234. {
  235. }
  236. }
  237. }
  238. foreach (var delList in courseChange.delList)
  239. {
  240. (List<RMember> tchList, List<RGroupList> classLists) = await GroupListService.GetStutmdidListids(client, _dingDing, new List<string> { delList }, courseChange.school);
  241. var delStudentsCls = tchList.FindAll(x => x.type == 2);
  242. var delTmdidsCls = tchList.FindAll(x => x.type == 1);
  243. foreach (var stu in delStudentsCls)
  244. {
  245. try
  246. {
  247. ItemResponse<StuCourse> stuCourse = await client.GetContainer(Constant.TEAMModelOS, "Student").ReadItemAsync<StuCourse>(courseChange.id, new PartitionKey($"StuCourse-{courseChange.school}-{stu.id}"));
  248. if (stuCourse.Value.stulist.Contains(delList))
  249. {
  250. stuCourse.Value.stulist.Remove(delList);
  251. }
  252. if (!stuCourse.Value.classId.IsNotEmpty() && !stuCourse.Value.stulist.IsNotEmpty())
  253. {
  254. //当两个列表都不存在时则直接删除
  255. await client.GetContainer(Constant.TEAMModelOS, "Student").DeleteItemAsync<StuCourse>(courseChange.id, new PartitionKey($"StuCourse-{courseChange.school}-{stu.id}"));
  256. }
  257. else
  258. {
  259. await client.GetContainer(Constant.TEAMModelOS, "Student").ReplaceItemAsync<StuCourse>(stuCourse, courseChange.id, new PartitionKey($"StuCourse-{courseChange.school}-{stu.id}"));
  260. }
  261. }
  262. catch (CosmosException ex)
  263. {
  264. }
  265. }
  266. foreach (var tmd in delTmdidsCls)
  267. {
  268. try
  269. {
  270. ItemResponse<StuCourse> stuCourse = await client.GetContainer(Constant.TEAMModelOS, "Student").ReadItemAsync<StuCourse>(courseChange.id, new PartitionKey($"StuCourse-{tmd.id}"));
  271. if (stuCourse.Value.stulist.Contains(delList))
  272. {
  273. stuCourse.Value.stulist.Remove(delList);
  274. }
  275. if (!stuCourse.Value.classId.IsNotEmpty() && !stuCourse.Value.stulist.IsNotEmpty())
  276. {
  277. //当两个列表都不存在时则直接删除
  278. await client.GetContainer(Constant.TEAMModelOS, "Student").DeleteItemAsync<StuCourse>(courseChange.id, new PartitionKey($"StuCourse-{tmd.id}"));
  279. }
  280. else
  281. {
  282. await client.GetContainer(Constant.TEAMModelOS, "Student").ReplaceItemAsync<StuCourse>(stuCourse, courseChange.id, new PartitionKey($"StuCourse-{tmd.id}"));
  283. }
  284. }
  285. catch (CosmosException ex)
  286. {
  287. }
  288. }
  289. }
  290. }
  291. catch (Exception ex)
  292. {
  293. await _dingDing.SendBotMsg($"CourseServiceBus-Course\n{ex.Message}{ex.StackTrace}", GroupNames.成都开发測試群組);
  294. }
  295. }
  296. }
  297. }