ActivityService.cs 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583
  1. using Azure;
  2. using Azure.Cosmos;
  3. using System;
  4. using System.Collections.Generic;
  5. using System.IO;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Text.Json;
  9. using System.Threading.Tasks;
  10. using TEAMModelOS.SDK.DI;
  11. using TEAMModelOS.SDK.Extension;
  12. using TEAMModelOS.SDK;
  13. using TEAMModelOS.SDK.Models;
  14. using TEAMModelOS.SDK.Models.Cosmos.Common;
  15. using TEAMModelOS.SDK.Models.Service;
  16. using HTEXLib.COMM.Helpers;
  17. namespace TEAMModelOS.SDK
  18. {
  19. public class ActivityService
  20. {
  21. public static async Task FixActivity(CosmosClient client, DingDing _dingDing, GroupChange groupChange, string type)
  22. {
  23. try
  24. {
  25. var query = $"SELECT distinct c.owner, c.id,c.code, c.classes,c.stuLists,c.subjects,c.progress,c.scope,c.startTime,c.school,c.creatorId,c.name,c.pk ,c.endTime FROM c where c.pk='{type}' " +
  26. $" and (( array_contains(c.classes,'{groupChange.listid}')) or ( array_contains(c.stuLists,'{groupChange.listid}'))or ( array_contains(c.tchLists,'{groupChange.listid}')))";
  27. //$"and A1 in('{groupChange.listid}') ";
  28. List<MQActivity> datas = new List<MQActivity>();
  29. if (groupChange.scope.Equals("school", StringComparison.OrdinalIgnoreCase) && !string.IsNullOrEmpty(groupChange.school))
  30. {
  31. await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Common").GetItemQueryIterator<MQActivity>(queryText: query,
  32. requestOptions: new QueryRequestOptions() { PartitionKey = new Azure.Cosmos.PartitionKey($"{type}-{groupChange.school}") }))
  33. {
  34. datas.Add(item);
  35. }
  36. ///还要处理该学校每个老师发布的班级的
  37. List<SchoolTeacher> teachers = new List<SchoolTeacher>();
  38. await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIterator<SchoolTeacher>(queryText: $"SELECT c.id, c.name FROM c",
  39. requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Teacher-{groupChange.school}") }))
  40. {
  41. teachers.Add(item);
  42. }
  43. foreach (var techer in teachers)
  44. {
  45. var queryTech = $"SELECT distinct c.owner, c.id,c.code, c.classes,c.stuLists,c.subjects,c.progress,c.scope,c.startTime,c.school,c.creatorId,c.name,c.pk ,c.endTime FROM c " +
  46. $" where c.school='{groupChange.school}' and c.pk='{type}'" +
  47. $" and (( array_contains(c.classes,'{groupChange.listid}')) or ( array_contains(c.stuLists,'{groupChange.listid}')))";
  48. // $" and A1 in('{groupChange.listid}') ";
  49. await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Common").GetItemQueryIterator<MQActivity>(queryText: queryTech,
  50. requestOptions: new QueryRequestOptions() { PartitionKey = new Azure.Cosmos.PartitionKey($"{type}-{techer.id}") }))
  51. {
  52. datas.Add(item);
  53. }
  54. }
  55. }
  56. if (groupChange.scope.Equals("private", StringComparison.OrdinalIgnoreCase) && !string.IsNullOrEmpty(groupChange.creatorId))
  57. {
  58. await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Common").GetItemQueryIterator<MQActivity>(queryText: query,
  59. requestOptions: new QueryRequestOptions() { PartitionKey = new Azure.Cosmos.PartitionKey($"{type}-{groupChange.creatorId}") }))
  60. {
  61. datas.Add(item);
  62. }
  63. }
  64. long nowtime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
  65. foreach (MQActivity activity in datas)
  66. {
  67. //已经完结的不再允许加入,还未开始的。
  68. if (string.IsNullOrEmpty(activity.progress) || activity.progress.Equals("finish") || activity.progress.Equals("pending"))
  69. {
  70. continue;
  71. }
  72. List<string> classes = ExamService.getClasses(activity.classes, activity.stuLists);
  73. List<ExamClassResult> classResults = new List<ExamClassResult>();
  74. List<PaperSimple> standerAnswers = new List<PaperSimple>();
  75. if (type.Equals("Exam")) {
  76. if (groupChange.scope.Equals("school"))
  77. {
  78. await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Common").GetItemQueryIterator<ExamClassResult>(queryText: $"select value(c) from c where c.examId = '{activity.id}'",
  79. requestOptions: new QueryRequestOptions() { PartitionKey = new Azure.Cosmos.PartitionKey($"ExamClassResult-{groupChange.school}") }))
  80. {
  81. classResults.Add(item);
  82. }
  83. }
  84. else {
  85. await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Common").GetItemQueryIterator<ExamClassResult>(queryText: $"select value(c) from c where c.examId = '{activity.id}'",
  86. requestOptions: new QueryRequestOptions() { PartitionKey = new Azure.Cosmos.PartitionKey($"ExamClassResult-{groupChange.creatorId}") }))
  87. {
  88. classResults.Add(item);
  89. }
  90. }
  91. await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Common").GetItemQueryIterator<PaperSimple>(
  92. queryText: $"select A0.answers from c join A0 in c.papers where c.id = '{activity.id}'",
  93. requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"{activity.code}") }))
  94. {
  95. standerAnswers.Add(item);
  96. }
  97. }
  98. //stujoin新加入名单的
  99. foreach (Member member in groupChange.stujoin)
  100. {
  101. await updateClassResulte(client, classResults, standerAnswers, member.id, groupChange.listid);
  102. var stucourse = new StuActivity
  103. {
  104. id = activity.id,
  105. scode = activity.code,
  106. name = activity.name,
  107. code = $"Activity-{member.code.Replace("Base-", "")}-{member.id}",
  108. scope = activity.scope,
  109. school = activity.school,
  110. creatorId = activity.creatorId,
  111. pk = "Activity",
  112. type = type,
  113. subjects = activity.pk.ToLower().Equals("exam") && activity.subjects.IsNotEmpty() ? new List<string>() { activity.subjects[0].id } : new List<string>() { "" },
  114. startTime = activity.startTime,
  115. endTime = activity.endTime,
  116. blob = activity.blob,
  117. owner = activity.owner,
  118. createTime = nowtime,
  119. taskStatus = -1,
  120. classIds = classes
  121. };
  122. await client.GetContainer(Constant.TEAMModelOS, "Student").UpsertItemAsync(stucourse, new PartitionKey(stucourse.code));
  123. }
  124. //tmdjoin新加入的
  125. foreach (Member member in groupChange.tmdjoin)
  126. {
  127. await updateClassResulte(client, classResults, standerAnswers, member.id,groupChange.listid);
  128. var stucourse = new StuActivity
  129. {
  130. id = activity.id,
  131. scode = activity.code,
  132. name = activity.name,
  133. code = $"Activity-{member.id}",
  134. scope = activity.scope,
  135. school = activity.school,
  136. creatorId = activity.creatorId,
  137. pk = "Activity",
  138. type = type,
  139. subjects = activity.pk.ToLower().Equals("exam") && activity.subjects.IsNotEmpty() ? new List<string>() { activity.subjects[0].id } : new List<string>() { "" },
  140. startTime = activity.startTime,
  141. endTime = activity.endTime,
  142. blob = activity.blob,
  143. owner = activity.owner,
  144. createTime = nowtime,
  145. taskStatus = -1,
  146. classIds = classes
  147. };
  148. await client.GetContainer(Constant.TEAMModelOS, "Student").UpsertItemAsync(stucourse, new PartitionKey(stucourse.code));
  149. }
  150. //tchjoin新加入的
  151. foreach (Member member in groupChange.tchjoin)
  152. {
  153. //await updateClassResulte(client, classResults, standerAnswers, member.id);
  154. var stucourse = new StuActivity
  155. {
  156. id = activity.id,
  157. scode = activity.code,
  158. name = activity.name,
  159. code = $"Activity-{member.id}",
  160. scope = activity.scope,
  161. school = activity.school,
  162. creatorId = activity.creatorId,
  163. pk = "Activity",
  164. type = type,
  165. subjects = activity.pk.ToLower().Equals("exam") && activity.subjects.IsNotEmpty() ? new List<string>() { activity.subjects[0].id } : new List<string>() { "" },
  166. startTime = activity.startTime,
  167. endTime = activity.endTime,
  168. blob = activity.blob,
  169. owner = activity.owner,
  170. createTime = nowtime,
  171. taskStatus = -1,
  172. classIds = classes
  173. };
  174. await client.GetContainer(Constant.TEAMModelOS, "Teacher").UpsertItemAsync(stucourse, new PartitionKey(stucourse.code));
  175. }
  176. foreach (Member member in groupChange.stuleave)
  177. {
  178. try
  179. {
  180. await updateClassResulte(client, classResults, standerAnswers, member.id, groupChange.listid);
  181. await client.GetContainer(Constant.TEAMModelOS, "Student").DeleteItemAsync<StuActivity>(activity.id, new PartitionKey($"Activity-{member.code.Replace("Base-", "")}-{member.id}"));
  182. }
  183. catch (CosmosException)
  184. {
  185. continue;
  186. // 继续执行 删除失败
  187. }
  188. }
  189. foreach (Member member in groupChange.tmdleave)
  190. {
  191. try
  192. {
  193. await updateClassResulte(client, classResults, standerAnswers, member.id, groupChange.listid);
  194. await client.GetContainer(Constant.TEAMModelOS, "Student").DeleteItemAsync<StuActivity>(activity.id, new PartitionKey($"Activity-{member.id}"));
  195. }
  196. catch (CosmosException)
  197. {
  198. continue;
  199. // 继续执行 删除失败
  200. }
  201. }
  202. foreach (Member member in groupChange.tchleave)
  203. {
  204. try
  205. {
  206. await client.GetContainer(Constant.TEAMModelOS, "Teacher").DeleteItemAsync<StuActivity>(activity.id, new PartitionKey($"Activity-{member.id}"));
  207. }
  208. catch (CosmosException)
  209. {
  210. continue;
  211. // 继续执行 删除失败
  212. }
  213. }
  214. }
  215. } catch (CosmosException e) {
  216. await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")}-GroupListService-FixActivity\n{e.Message}\n{e.StackTrace}CosmosException{e.Status}", GroupNames.成都开发測試群組);
  217. }
  218. catch (Exception ex)
  219. {
  220. await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")}-GroupListService-FixActivity\n{ex.Message}{ex.StackTrace}{groupChange.ToJsonString()}{type}", GroupNames.醍摩豆服務運維群組);
  221. }
  222. }
  223. public static async Task FixStuCourse(CosmosClient client, DingDing _dingDing, GroupChange groupChange)
  224. {
  225. //1.查找学校或教师的课程是否包含该名单的课程。
  226. var query = $"select distinct c.code,c.id,c.no,c.name,c.scope, c.creatorId,c.school from c join A0 in c.schedule where A0.stulist = '{groupChange.listid}'";
  227. List<Course> courses = new List<Course>();
  228. if (groupChange.scope.Equals("school") && !string.IsNullOrEmpty(groupChange.school))
  229. {
  230. await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIterator<Course>(queryText: query,
  231. requestOptions: new QueryRequestOptions() { PartitionKey = new Azure.Cosmos.PartitionKey($"Course-{groupChange.school}") }))
  232. {
  233. courses.Add(item);
  234. }
  235. }
  236. if (groupChange.scope.Equals("private") && !string.IsNullOrEmpty(groupChange.creatorId))
  237. {
  238. await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Teacher").GetItemQueryIterator<Course>(queryText: query,
  239. requestOptions: new QueryRequestOptions() { PartitionKey = new Azure.Cosmos.PartitionKey($"Course-{groupChange.creatorId}") }))
  240. {
  241. courses.Add(item);
  242. }
  243. }
  244. long nowtime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
  245. // await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")}-GroupListService-FixStuCourse\n名单发生变更 需要处理的课程\n{courses.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
  246. //2.获取课程的id 并尝试添加或移除对应的学生课程记录StuCourse。
  247. foreach (var course in courses)
  248. {
  249. //学生新加入名单的
  250. foreach (Member member in groupChange.stujoin)
  251. {
  252. var stucourse = new StuCourse
  253. {
  254. id = course.id,
  255. scode = course.code,
  256. name = course.name,
  257. code = $"StuCourse-{member.code.Replace("Base-", "")}-{member.id}",
  258. scope = course.scope,
  259. school = course.school,
  260. creatorId = course.creatorId,
  261. pk = "StuCourse",
  262. stulist = new List<string> { groupChange.listid },
  263. createTime = nowtime
  264. };
  265. // await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")}-GroupListService-FixStuCourse\n名单发生变更 新建课程中间表\n{stucourse.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
  266. await client.GetContainer(Constant.TEAMModelOS, "Student").UpsertItemAsync(stucourse, new PartitionKey(stucourse.code));
  267. }
  268. //tmd新加入的
  269. foreach (Member member in groupChange.tmdjoin)
  270. {
  271. var stucourse = new StuCourse
  272. {
  273. id = course.id,
  274. scode = course.code,
  275. name = course.name,
  276. code = $"StuCourse-{member.id}",
  277. scope = course.scope,
  278. school = course.school,
  279. creatorId = course.creatorId,
  280. pk = "StuCourse",
  281. stulist = new List<string> { groupChange.listid },
  282. createTime = nowtime
  283. };
  284. // await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")}-GroupListService-FixStuCourse\n名单发生变更 新建课程中间表\n{stucourse.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
  285. await client.GetContainer(Constant.TEAMModelOS, "Student").UpsertItemAsync(stucourse, new PartitionKey(stucourse.code));
  286. }
  287. //移除名单的。 在点击相关的课程,再去二次校验是否存在,不存在则再去删除。
  288. foreach (var delStu in groupChange.stuleave)
  289. {
  290. await client.GetContainer(Constant.TEAMModelOS, "Student").DeleteItemStreamAsync(course.id, new PartitionKey($"StuCourse-{delStu.code.Replace("Base-", "")}-{delStu.id}"));
  291. }
  292. foreach (var delTmd in groupChange.tmdleave)
  293. {
  294. await client.GetContainer(Constant.TEAMModelOS, "Student").DeleteItemStreamAsync(course.id, new PartitionKey($"StuCourse-{delTmd}"));
  295. }
  296. }
  297. }
  298. public static async Task<string> SaveStuActivity(CosmosClient client, DingDing _dingDing, List<StuActivity> stuActivities, List<StuActivity> tmdActivities, List<StuActivity> tchActivities)
  299. {
  300. try
  301. {
  302. if (stuActivities.IsNotEmpty())
  303. {
  304. foreach (var x in stuActivities)
  305. {
  306. await client.GetContainer(Constant.TEAMModelOS, "Student").UpsertItemAsync(x, new PartitionKey(x.code));
  307. }
  308. }
  309. if (tmdActivities.IsNotEmpty())
  310. {
  311. foreach (var x in tmdActivities)
  312. {
  313. await client.GetContainer(Constant.TEAMModelOS, "Student").UpsertItemAsync(x, new PartitionKey(x.code));
  314. }
  315. }
  316. if (tchActivities.IsNotEmpty())
  317. {
  318. foreach (var x in tchActivities)
  319. {
  320. await client.GetContainer(Constant.TEAMModelOS, "Teacher").UpsertItemAsync(x, new PartitionKey(x.code));
  321. }
  322. }
  323. }
  324. catch (Exception ex)
  325. {
  326. await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")}-OS,TriggerStuActivity-SaveStuActivity\n{ex.Message}\n{ex.StackTrace}", GroupNames.醍摩豆服務運維群組);
  327. }
  328. return "";
  329. }
  330. public static async Task RefreshStuActivity(CoreAPIHttpService _coreAPIHttpService ,CosmosClient client, DingDing _dingDing, string id, string code)
  331. {
  332. MQActivity activity = null;
  333. try
  334. {
  335. var aactivity = await client.GetContainer(Constant.TEAMModelOS, "Common").ReadItemStreamAsync(id, new Azure.Cosmos.PartitionKey(code));
  336. using var da = await JsonDocument.ParseAsync(aactivity.ContentStream);
  337. activity = da.ToObject<MQActivity>();
  338. }
  339. catch (CosmosException)
  340. {
  341. activity = null;
  342. }
  343. if (activity != null)
  344. {
  345. List<Task<ItemResponse<StuActivity>>> tasks = new List<Task<ItemResponse<StuActivity>>>();
  346. List<string> classes = ExamService.getClasses(activity.classes, activity.stuLists);
  347. (List<RMember> tmdIds, List<RGroupList> classLists) = await GroupListService.GetStutmdidListids(_coreAPIHttpService, client, _dingDing, classes, activity.school);
  348. var students = tmdIds.FindAll(x => x.type == 2);
  349. var tmdids = tmdIds.FindAll(x => x.type == 1);
  350. if (tmdids.IsNotEmpty())
  351. {
  352. foreach (RMember tmdid in tmdids)
  353. {
  354. var response = await client.GetContainer(Constant.TEAMModelOS, "Student").ReadItemStreamAsync(activity.id, new PartitionKey($"Activity-{tmdid.id}"));
  355. if (response.Status == 200) {
  356. using var json = await JsonDocument.ParseAsync(response.ContentStream);
  357. StuActivity stu = json.ToObject<StuActivity>();
  358. stu.id = activity.id;
  359. stu.scode = activity.code;
  360. stu.name = activity.name;
  361. stu.source = activity.source;
  362. stu.scope = activity.scope;
  363. stu.school = activity.school;
  364. stu.creatorId = activity.creatorId;
  365. stu.type = activity.pk;
  366. stu.subjects = activity.pk.ToLower().Equals("exam") && activity.subjects.IsNotEmpty() ? new List<string>() { activity.subjects[0].id } : new List<string>() { "" };
  367. stu.startTime = activity.startTime;
  368. stu.endTime = activity.endTime;
  369. stu.blob = activity.blob;
  370. stu.owner = activity.owner;
  371. stu.createTime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
  372. tasks.Add(client.GetContainer(Constant.TEAMModelOS, "Student").ReplaceItemAsync(stu,stu.id, new PartitionKey(stu.code)));
  373. }
  374. }
  375. }
  376. if (students.IsNotEmpty())
  377. {
  378. foreach (RMember student in students)
  379. {
  380. var response = await client.GetContainer(Constant.TEAMModelOS, "Student").ReadItemStreamAsync(activity.id, new PartitionKey($"Activity-{activity.school}-{student.id}"));
  381. if (response.Status == 200)
  382. {
  383. using var json = await JsonDocument.ParseAsync(response.ContentStream);
  384. StuActivity stu = json.ToObject<StuActivity>();
  385. stu.id = activity.id;
  386. stu.scode = activity.code;
  387. stu.name = activity.name;
  388. stu.source = activity.source;
  389. stu.scope = activity.scope;
  390. stu.school = activity.school;
  391. stu.creatorId = activity.creatorId;
  392. stu.type = activity.pk;
  393. stu.subjects = activity.pk.ToLower().Equals("exam") && activity.subjects.IsNotEmpty() ? new List<string>() { activity.subjects[0].id } : new List<string>() { "" };
  394. stu.startTime = activity.startTime;
  395. stu.endTime = activity.endTime;
  396. stu.blob = activity.blob;
  397. stu.owner = activity.owner;
  398. stu.createTime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
  399. tasks.Add(client.GetContainer(Constant.TEAMModelOS, "Student").ReplaceItemAsync(stu, stu.id, new PartitionKey(stu.code)));
  400. }
  401. //await client.GetContainer(Constant.TEAMModelOS, "Student").UpsertItemAsync(stucourse, new PartitionKey(stucourse.code));
  402. }
  403. }
  404. await Task.WhenAll(tasks);
  405. }
  406. }
  407. public static async Task updateClassResulte(CosmosClient client,List<ExamClassResult> classResults, List<PaperSimple> standerAnswers, string id,string stuListId)
  408. {
  409. if (classResults.Count > 0)
  410. {
  411. foreach (var item in classResults)
  412. {
  413. if (item.info.id.Equals(stuListId)) {
  414. int index = item.studentIds.IndexOf(id);
  415. if (index == -1)
  416. {
  417. List<List<string>> standard = new List<List<string>>();
  418. foreach (PaperSimple simple in standerAnswers)
  419. {
  420. standard = simple.answers;
  421. }
  422. List<double> ansPoint = new List<double>();
  423. List<List<string>> anc = new List<List<string>>();
  424. List<List<Details>> mark = new List<List<Details>>();
  425. foreach (List<string> num in standard)
  426. {
  427. List<string> newAns = new List<string>();
  428. foreach (string san in num)
  429. {
  430. newAns.Add(san);
  431. }
  432. anc.Add(newAns);
  433. ansPoint.Add(-1);
  434. mark.Add(new List<Details>());
  435. }
  436. item.mark.Add(mark);
  437. item.ans.Add(anc);
  438. item.studentIds.Add(id);
  439. item.studentScores.Add(ansPoint);
  440. item.studentAnswers.Add(new List<string>());
  441. item.sum.Add(0);
  442. }
  443. else
  444. {
  445. item.mark.RemoveAt(index);
  446. item.ans.RemoveAt(index);
  447. item.studentIds.RemoveAt(index);
  448. item.studentScores.RemoveAt(index);
  449. item.studentAnswers.RemoveAt(index);
  450. item.sum.RemoveAt(index);
  451. }
  452. }
  453. await client.GetContainer(Constant.TEAMModelOS, "Common").ReplaceItemAsync(item, item.id, new PartitionKey($"{item.code}"));
  454. }
  455. }
  456. }
  457. public static async Task DeleteActivity(CoreAPIHttpService _coreAPIHttpService, CosmosClient client, DingDing _dingDing, ActivityList activityList) {
  458. List<(string pId, List<string> gid)> ps = new List<(string pId, List<string> gid)>();
  459. if (activityList.groupLists.Count > 0)
  460. {
  461. var group = activityList.groupLists;
  462. foreach (var keys in group)
  463. {
  464. foreach (KeyValuePair<string, List<string>> pp in keys)
  465. {
  466. ps.Add((pp.Key, pp.Value));
  467. }
  468. }
  469. }
  470. List<string> classes = ExamService.getClasses(activityList.classes, activityList.stuLists);
  471. (List<RMember> tmdIds, List<RGroupList> classLists) = await GroupListService.GetStutmdidListids(_coreAPIHttpService, client, _dingDing, classes, activityList.school, ps);
  472. var addStudentsCls = tmdIds.FindAll(x => x.type == 2);
  473. var addTmdidsCls = tmdIds.FindAll(x => x.type == 1);
  474. List<string> tmds = new List<string>();
  475. if (addTmdidsCls.IsNotEmpty())
  476. {
  477. tmds.AddRange(addTmdidsCls.Select(x => x.id).ToList());
  478. }
  479. List<StuActivity> stuActivities = new List<StuActivity>();
  480. List<StuActivity> tmdActivities = new List<StuActivity>();
  481. List<StuActivity> tchActivities = new List<StuActivity>();
  482. if (tmds.IsNotEmpty())
  483. {
  484. tmds.ForEach(x =>
  485. {
  486. tmdActivities.Add(new StuActivity
  487. {
  488. id = activityList.id,
  489. code = $"Activity-{x}",
  490. });
  491. });
  492. }
  493. if (addStudentsCls.IsNotEmpty())
  494. {
  495. addStudentsCls.ForEach(x =>
  496. {
  497. stuActivities.Add(new StuActivity
  498. {
  499. id = activityList.id,
  500. code = $"Activity-{x.code.Replace("Base-", "")}-{x.id}",
  501. });
  502. });
  503. }
  504. (List<RMember> tchList, List<RGroupList> classInfos) = await GroupListService.GetStutmdidListids(_coreAPIHttpService, client, _dingDing, activityList.tchLists, activityList.school, ps);
  505. (string standard, List<string> tmdids, string school, List<string> update, int statistics) list = (null, null, null, new List<string> { StatisticsService.TeacherVote }, 0);
  506. if (tchList.IsNotEmpty())
  507. {
  508. list.tmdids = tchList.Select(x => x.id).ToList();
  509. School school = null;
  510. if (!string.IsNullOrEmpty(activityList.school))
  511. {
  512. school = await client.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<School>(activityList.school, new Azure.Cosmos.PartitionKey("Base"));
  513. list.school = school.id;
  514. list.standard = school.standard;
  515. }
  516. tchList.ForEach(x =>
  517. {
  518. tchActivities.Add(new StuActivity
  519. {
  520. id = activityList.id,
  521. code = $"Activity-{x.id}",
  522. });
  523. });
  524. }
  525. await ActivityService.DeleteStuActivity(client, _dingDing, stuActivities, tmdActivities, tchActivities);
  526. }
  527. public static async Task<string> DeleteStuActivity(CosmosClient client, DingDing _dingDing, List<StuActivity> stuActivities, List<StuActivity> tmdActivities, List<StuActivity> tchActivities)
  528. {
  529. try
  530. {
  531. if (stuActivities.IsNotEmpty())
  532. {
  533. foreach (var x in stuActivities)
  534. {
  535. await client.GetContainer(Constant.TEAMModelOS, "Student").DeleteItemStreamAsync(x.id, new PartitionKey(x.code));
  536. }
  537. }
  538. if (tmdActivities.IsNotEmpty())
  539. {
  540. foreach (var x in tmdActivities)
  541. {
  542. await client.GetContainer(Constant.TEAMModelOS, "Student").DeleteItemStreamAsync(x.id, new PartitionKey(x.code));
  543. }
  544. }
  545. if (tchActivities.IsNotEmpty())
  546. {
  547. foreach (var x in tchActivities)
  548. {
  549. await client.GetContainer(Constant.TEAMModelOS, "Teacher").DeleteItemStreamAsync(x.id, new PartitionKey(x.code));
  550. }
  551. }
  552. }
  553. catch (Exception ex)
  554. {
  555. await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")}-OS,TriggerStuActivity-DeleteStuActivity\n{ex.Message}\n{ex.StackTrace}", GroupNames.醍摩豆服務運維群組);
  556. }
  557. return "";
  558. }
  559. }
  560. public class ActivityList
  561. {
  562. public string id { get; set; }
  563. public string school { get; set; }
  564. /// <summary>
  565. /// 行政班
  566. /// </summary>
  567. public List<string> classes { get; set; } = new List<string>();
  568. /// <summary>
  569. /// 学生名单(包含自定义个人学生名单,学校教学班)
  570. /// </summary>
  571. public List<string> stuLists { get; set; } = new List<string>();
  572. /// <summary>
  573. /// 教研组名单
  574. /// </summary>
  575. public List<string> tchLists { get; set; } = new List<string>();
  576. public List<Dictionary<string, List<string>>> groupLists { get; set; } = new List<Dictionary<string, List<string>>>();
  577. }
  578. }