CourseServiceBus.cs 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310
  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<TmdInfo> addTmdidsCls, List<StuInfo> addStudentsCls, List<ClassListInfo> classLists) = await TriggerStuActivity.GetStuList(client, _dingDing, new List<string> { cls }, courseChange.school);
  49. foreach (var stu in addStudentsCls)
  50. {
  51. try
  52. {
  53. ItemResponse<StuCourse> stuCourse = await client.GetContainer(Constant.TEAMModelOS, "Student").ReadItemAsync<StuCourse>(courseChange.id, new PartitionKey($"StuCourse-{courseChange.school}-{stu.id}"));
  54. if (!stuCourse.Value.classId.Contains(cls))
  55. {
  56. stuCourse.Value.classId.Add(cls);
  57. }
  58. await client.GetContainer(Constant.TEAMModelOS, "Student").ReplaceItemAsync<StuCourse>(stuCourse, courseChange.id, new PartitionKey($"StuCourse-{courseChange.school}-{stu.id}"));
  59. }
  60. catch (CosmosException ex)
  61. {
  62. if (ex.Response.Status == 404)
  63. {
  64. var course = new StuCourse
  65. {
  66. id = courseChange.id,
  67. scode = courseChange.code,
  68. name = courseChange.name,
  69. code = $"StuCourse-{courseChange.school}-{stu.id}",
  70. scope = courseChange.scope,
  71. school = courseChange.school,
  72. creatorId = courseChange.creatorId,
  73. classId = new List<string> { cls },
  74. pk = "StuCourse",
  75. createTime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds()
  76. };
  77. await client.GetContainer(Constant.TEAMModelOS, "Student").CreateItemAsync(course, new PartitionKey(course.code));
  78. }
  79. }
  80. }
  81. foreach (var tmd in addTmdidsCls)
  82. {
  83. try
  84. {
  85. ItemResponse<StuCourse> stuCourse = await client.GetContainer(Constant.TEAMModelOS, "Student").ReadItemAsync<StuCourse>(courseChange.id, new PartitionKey($"StuCourse-{tmd.id}"));
  86. if (!stuCourse.Value.classId.Contains(cls))
  87. {
  88. stuCourse.Value.classId.Add(cls);
  89. }
  90. await client.GetContainer(Constant.TEAMModelOS, "Student").ReplaceItemAsync<StuCourse>(stuCourse, courseChange.id, new PartitionKey($"StuCourse-{tmd.id}"));
  91. }
  92. catch (CosmosException ex)
  93. {
  94. if (ex.Response.Status == 404)
  95. {
  96. var course = new StuCourse
  97. {
  98. id = courseChange.id,
  99. scode = courseChange.code,
  100. name = courseChange.name,
  101. code = $"StuCourse-{tmd.id}",
  102. scope = courseChange.scope,
  103. school = courseChange.school,
  104. creatorId = courseChange.creatorId,
  105. classId = new List<string> { cls },
  106. pk = "StuCourse",
  107. createTime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds()
  108. };
  109. await client.GetContainer(Constant.TEAMModelOS, "Student").CreateItemAsync(course, new PartitionKey(course.code));
  110. }
  111. }
  112. }
  113. }
  114. foreach (var list in courseChange.addList)
  115. {
  116. (List<TmdInfo> addTmdidsCls, List<StuInfo> addStudentsCls, List<ClassListInfo> classLists) = await TriggerStuActivity.GetStuList(client, _dingDing, new List<string> { list }, courseChange.school);
  117. foreach (var stu in addStudentsCls)
  118. {
  119. try
  120. {
  121. ItemResponse<StuCourse> stuCourse = await client.GetContainer(Constant.TEAMModelOS, "Student").ReadItemAsync<StuCourse>(courseChange.id, new PartitionKey($"StuCourse-{stu.schoolId}-{stu.id}"));
  122. if (!stuCourse.Value.stulist.Contains(list))
  123. {
  124. stuCourse.Value.stulist.Add(list);
  125. await client.GetContainer(Constant.TEAMModelOS, "Student").ReplaceItemAsync<StuCourse>(stuCourse, courseChange.id, new PartitionKey($"StuCourse-{stu.schoolId}-{stu.id}"));
  126. }
  127. }
  128. catch (CosmosException ex)
  129. {
  130. if (ex.Response.Status == 404)
  131. {
  132. var course = new StuCourse
  133. {
  134. id = courseChange.id,
  135. scode = courseChange.code,
  136. name = courseChange.name,
  137. code = $"StuCourse-{courseChange.school}-{stu.id}",
  138. scope = courseChange.scope,
  139. school = courseChange.school,
  140. creatorId = courseChange.creatorId,
  141. stulist = new List<string> { list },
  142. pk = "StuCourse",
  143. createTime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds()
  144. };
  145. await client.GetContainer(Constant.TEAMModelOS, "Student").CreateItemAsync(course, new PartitionKey(course.code));
  146. }
  147. }
  148. }
  149. foreach (var tmd in addTmdidsCls)
  150. {
  151. try
  152. {
  153. ItemResponse<StuCourse> stuCourse = await client.GetContainer(Constant.TEAMModelOS, "Student").ReadItemAsync<StuCourse>(courseChange.id, new PartitionKey($"StuCourse-{tmd.id}"));
  154. if (!stuCourse.Value.stulist.Contains(list))
  155. {
  156. stuCourse.Value.stulist.Add(list);
  157. await client.GetContainer(Constant.TEAMModelOS, "Student").ReplaceItemAsync<StuCourse>(stuCourse, courseChange.id, new PartitionKey($"StuCourse-{tmd.id}"));
  158. }
  159. }
  160. catch (CosmosException ex)
  161. {
  162. if (ex.Response.Status == 404)
  163. {
  164. var course = new StuCourse
  165. {
  166. id = courseChange.id,
  167. scode = courseChange.code,
  168. name = courseChange.name,
  169. code = $"StuCourse-{tmd.id}",
  170. scope = courseChange.scope,
  171. school = courseChange.school,
  172. creatorId = courseChange.creatorId,
  173. stulist = new List<string> { list },
  174. pk = "StuCourse",
  175. createTime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds()
  176. };
  177. await client.GetContainer(Constant.TEAMModelOS, "Student").CreateItemAsync(course, new PartitionKey(course.code));
  178. }
  179. }
  180. }
  181. }
  182. foreach (var delCls in courseChange.delClass)
  183. {
  184. (List<TmdInfo> delTmdidsCls, List<StuInfo> delStudentsCls, List<ClassListInfo> classLists) = await TriggerStuActivity.GetStuList(client, _dingDing, new List<string> { delCls }, courseChange.school);
  185. foreach (var stu in delStudentsCls)
  186. {
  187. try
  188. {
  189. ItemResponse<StuCourse> stuCourse = await client.GetContainer(Constant.TEAMModelOS, "Student").ReadItemAsync<StuCourse>(courseChange.id, new PartitionKey($"StuCourse-{courseChange.school}-{stu.id}"));
  190. if (stuCourse.Value.classId.Contains(delCls))
  191. {
  192. stuCourse.Value.classId.Remove(delCls);
  193. }
  194. if (!stuCourse.Value.classId.IsNotEmpty() && !stuCourse.Value.stulist.IsNotEmpty())
  195. {
  196. //当两个列表都不存在时则直接删除
  197. await client.GetContainer(Constant.TEAMModelOS, "Student").DeleteItemAsync<StuCourse>(courseChange.id, new PartitionKey($"StuCourse-{courseChange.school}-{stu.id}"));
  198. }
  199. else
  200. {
  201. await client.GetContainer(Constant.TEAMModelOS, "Student").ReplaceItemAsync<StuCourse>(stuCourse, courseChange.id, new PartitionKey($"StuCourse-{courseChange.school}-{stu.id}"));
  202. }
  203. }
  204. catch (CosmosException ex)
  205. {
  206. }
  207. }
  208. foreach (var tmd in delTmdidsCls)
  209. {
  210. try
  211. {
  212. ItemResponse<StuCourse> stuCourse = await client.GetContainer(Constant.TEAMModelOS, "Student").ReadItemAsync<StuCourse>(courseChange.id, new PartitionKey($"StuCourse-{tmd.id}"));
  213. if (stuCourse.Value.classId.Contains(delCls))
  214. {
  215. stuCourse.Value.classId.Remove(delCls);
  216. }
  217. if (!stuCourse.Value.classId.IsNotEmpty() && !stuCourse.Value.stulist.IsNotEmpty())
  218. {
  219. //当两个列表都不存在时则直接删除
  220. await client.GetContainer(Constant.TEAMModelOS, "Student").DeleteItemAsync<StuCourse>(courseChange.id, new PartitionKey($"StuCourse-{tmd.id}"));
  221. }
  222. else
  223. {
  224. await client.GetContainer(Constant.TEAMModelOS, "Student").ReplaceItemAsync<StuCourse>(stuCourse, courseChange.id, new PartitionKey($"StuCourse-{tmd.id}"));
  225. }
  226. }
  227. catch (CosmosException ex)
  228. {
  229. }
  230. }
  231. }
  232. foreach (var delList in courseChange.delList)
  233. {
  234. (List<TmdInfo> delTmdidsCls, List<StuInfo> delStudentsCls, List<ClassListInfo> classLists) = await TriggerStuActivity.GetStuList(client, _dingDing, new List<string> { delList }, courseChange.school);
  235. foreach (var stu in delStudentsCls)
  236. {
  237. try
  238. {
  239. ItemResponse<StuCourse> stuCourse = await client.GetContainer(Constant.TEAMModelOS, "Student").ReadItemAsync<StuCourse>(courseChange.id, new PartitionKey($"StuCourse-{courseChange.school}-{stu.id}"));
  240. if (stuCourse.Value.stulist.Contains(delList))
  241. {
  242. stuCourse.Value.stulist.Remove(delList);
  243. }
  244. if (!stuCourse.Value.classId.IsNotEmpty() && !stuCourse.Value.stulist.IsNotEmpty())
  245. {
  246. //当两个列表都不存在时则直接删除
  247. await client.GetContainer(Constant.TEAMModelOS, "Student").DeleteItemAsync<StuCourse>(courseChange.id, new PartitionKey($"StuCourse-{courseChange.school}-{stu.id}"));
  248. }
  249. else
  250. {
  251. await client.GetContainer(Constant.TEAMModelOS, "Student").ReplaceItemAsync<StuCourse>(stuCourse, courseChange.id, new PartitionKey($"StuCourse-{courseChange.school}-{stu.id}"));
  252. }
  253. }
  254. catch (CosmosException ex)
  255. {
  256. }
  257. }
  258. foreach (var tmd in delTmdidsCls)
  259. {
  260. try
  261. {
  262. ItemResponse<StuCourse> stuCourse = await client.GetContainer(Constant.TEAMModelOS, "Student").ReadItemAsync<StuCourse>(courseChange.id, new PartitionKey($"StuCourse-{tmd.id}"));
  263. if (stuCourse.Value.stulist.Contains(delList))
  264. {
  265. stuCourse.Value.stulist.Remove(delList);
  266. }
  267. if (!stuCourse.Value.classId.IsNotEmpty() && !stuCourse.Value.stulist.IsNotEmpty())
  268. {
  269. //当两个列表都不存在时则直接删除
  270. await client.GetContainer(Constant.TEAMModelOS, "Student").DeleteItemAsync<StuCourse>(courseChange.id, new PartitionKey($"StuCourse-{tmd.id}"));
  271. }
  272. else
  273. {
  274. await client.GetContainer(Constant.TEAMModelOS, "Student").ReplaceItemAsync<StuCourse>(stuCourse, courseChange.id, new PartitionKey($"StuCourse-{tmd.id}"));
  275. }
  276. }
  277. catch (CosmosException ex)
  278. {
  279. }
  280. }
  281. }
  282. }
  283. catch (Exception ex)
  284. {
  285. await _dingDing.SendBotMsg($"CourseServiceBus-Course\n{ex.Message}{ex.StackTrace}", GroupNames.成都开发測試群組);
  286. }
  287. }
  288. }
  289. }