ActivityService.cs 34 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610
  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. StuActivity stuActivity= await client.GetContainer(Constant.TEAMModelOS, "Student").ReadItemAsync<StuActivity>(activity.id, new PartitionKey($"Activity-{member.code.Replace("Base-", "")}-{member.id}"));
  182. stuActivity.classIds.Remove(groupChange.listid);
  183. if (stuActivity.classIds.IsNotEmpty())
  184. {
  185. await client.GetContainer(Constant.TEAMModelOS, "Student").ReplaceItemAsync<StuActivity>(stuActivity,activity.id, new PartitionKey(stuActivity.code));
  186. }
  187. else {
  188. await client.GetContainer(Constant.TEAMModelOS, "Student").DeleteItemAsync<StuActivity>(activity.id, new PartitionKey($"Activity-{member.code.Replace("Base-", "")}-{member.id}"));
  189. }
  190. }
  191. catch (CosmosException)
  192. {
  193. continue;
  194. // 继续执行 删除失败
  195. }
  196. }
  197. foreach (Member member in groupChange.tmdleave)
  198. {
  199. try
  200. {
  201. await updateClassResulte(client, classResults, standerAnswers, member.id, groupChange.listid);
  202. StuActivity stuActivity= await client.GetContainer(Constant.TEAMModelOS, "Student").ReadItemAsync<StuActivity>(activity.id, new PartitionKey($"Activity-{member.id}"));
  203. stuActivity.classIds.Remove(groupChange.listid);
  204. if (stuActivity.classIds.IsNotEmpty())
  205. {
  206. await client.GetContainer(Constant.TEAMModelOS, "Student").ReplaceItemAsync<StuActivity>(stuActivity, activity.id, new PartitionKey(stuActivity.code));
  207. }
  208. else
  209. {
  210. await client.GetContainer(Constant.TEAMModelOS, "Student").DeleteItemAsync<StuActivity>(activity.id, new PartitionKey($"Activity-{member.id}"));
  211. }
  212. }
  213. catch (CosmosException)
  214. {
  215. continue;
  216. // 继续执行 删除失败
  217. }
  218. }
  219. foreach (Member member in groupChange.tchleave)
  220. {
  221. try
  222. {
  223. StuActivity stuActivity= await client.GetContainer(Constant.TEAMModelOS, "Teacher").ReadItemAsync<StuActivity>(activity.id, new PartitionKey($"Activity-{member.id}"));
  224. stuActivity.classIds.Remove(groupChange.listid);
  225. if (stuActivity.classIds.IsNotEmpty())
  226. {
  227. await client.GetContainer(Constant.TEAMModelOS, "Teacher").ReplaceItemAsync<StuActivity>(stuActivity, activity.id, new PartitionKey(stuActivity.code));
  228. }
  229. else
  230. {
  231. await client.GetContainer(Constant.TEAMModelOS, "Teacher").DeleteItemAsync<StuActivity> (activity.id, new PartitionKey($"Activity-{member.id}"));
  232. }
  233. }
  234. catch (CosmosException)
  235. {
  236. continue;
  237. // 继续执行 删除失败
  238. }
  239. }
  240. }
  241. } catch (CosmosException e) {
  242. await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")}-GroupListService-FixActivity\n{e.Message}\n{e.StackTrace}CosmosException{e.Status}", GroupNames.成都开发測試群組);
  243. }
  244. catch (Exception ex)
  245. {
  246. await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")}-GroupListService-FixActivity\n{ex.Message}{ex.StackTrace}{groupChange.ToJsonString()}{type}", GroupNames.醍摩豆服務運維群組);
  247. }
  248. }
  249. public static async Task FixStuCourse(CosmosClient client, DingDing _dingDing, GroupChange groupChange)
  250. {
  251. //1.查找学校或教师的课程是否包含该名单的课程。
  252. 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}'";
  253. List<Course> courses = new List<Course>();
  254. if (groupChange.scope.Equals("school") && !string.IsNullOrEmpty(groupChange.school))
  255. {
  256. await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIterator<Course>(queryText: query,
  257. requestOptions: new QueryRequestOptions() { PartitionKey = new Azure.Cosmos.PartitionKey($"Course-{groupChange.school}") }))
  258. {
  259. courses.Add(item);
  260. }
  261. }
  262. if (groupChange.scope.Equals("private") && !string.IsNullOrEmpty(groupChange.creatorId))
  263. {
  264. await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Teacher").GetItemQueryIterator<Course>(queryText: query,
  265. requestOptions: new QueryRequestOptions() { PartitionKey = new Azure.Cosmos.PartitionKey($"Course-{groupChange.creatorId}") }))
  266. {
  267. courses.Add(item);
  268. }
  269. }
  270. long nowtime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
  271. // await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")}-GroupListService-FixStuCourse\n名单发生变更 需要处理的课程\n{courses.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
  272. //2.获取课程的id 并尝试添加或移除对应的学生课程记录StuCourse。
  273. foreach (var course in courses)
  274. {
  275. //学生新加入名单的
  276. foreach (Member member in groupChange.stujoin)
  277. {
  278. var stucourse = new StuCourse
  279. {
  280. id = course.id,
  281. scode = course.code,
  282. name = course.name,
  283. code = $"StuCourse-{member.code.Replace("Base-", "")}-{member.id}",
  284. scope = course.scope,
  285. school = course.school,
  286. creatorId = course.creatorId,
  287. pk = "StuCourse",
  288. stulist = new List<string> { groupChange.listid },
  289. createTime = nowtime
  290. };
  291. // await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")}-GroupListService-FixStuCourse\n名单发生变更 新建课程中间表\n{stucourse.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
  292. await client.GetContainer(Constant.TEAMModelOS, "Student").UpsertItemAsync(stucourse, new PartitionKey(stucourse.code));
  293. }
  294. //tmd新加入的
  295. foreach (Member member in groupChange.tmdjoin)
  296. {
  297. var stucourse = new StuCourse
  298. {
  299. id = course.id,
  300. scode = course.code,
  301. name = course.name,
  302. code = $"StuCourse-{member.id}",
  303. scope = course.scope,
  304. school = course.school,
  305. creatorId = course.creatorId,
  306. pk = "StuCourse",
  307. stulist = new List<string> { groupChange.listid },
  308. createTime = nowtime
  309. };
  310. // await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")}-GroupListService-FixStuCourse\n名单发生变更 新建课程中间表\n{stucourse.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
  311. await client.GetContainer(Constant.TEAMModelOS, "Student").UpsertItemAsync(stucourse, new PartitionKey(stucourse.code));
  312. }
  313. //移除名单的。 在点击相关的课程,再去二次校验是否存在,不存在则再去删除。
  314. foreach (var delStu in groupChange.stuleave)
  315. {
  316. await client.GetContainer(Constant.TEAMModelOS, "Student").DeleteItemStreamAsync(course.id, new PartitionKey($"StuCourse-{delStu.code.Replace("Base-", "")}-{delStu.id}"));
  317. }
  318. foreach (var delTmd in groupChange.tmdleave)
  319. {
  320. await client.GetContainer(Constant.TEAMModelOS, "Student").DeleteItemStreamAsync(course.id, new PartitionKey($"StuCourse-{delTmd}"));
  321. }
  322. }
  323. }
  324. public static async Task<string> SaveStuActivity(CosmosClient client, DingDing _dingDing, List<StuActivity> stuActivities, List<StuActivity> tmdActivities, List<StuActivity> tchActivities)
  325. {
  326. try
  327. {
  328. if (stuActivities.IsNotEmpty())
  329. {
  330. foreach (var x in stuActivities)
  331. {
  332. await client.GetContainer(Constant.TEAMModelOS, "Student").UpsertItemAsync(x, new PartitionKey(x.code));
  333. }
  334. }
  335. if (tmdActivities.IsNotEmpty())
  336. {
  337. foreach (var x in tmdActivities)
  338. {
  339. await client.GetContainer(Constant.TEAMModelOS, "Student").UpsertItemAsync(x, new PartitionKey(x.code));
  340. }
  341. }
  342. if (tchActivities.IsNotEmpty())
  343. {
  344. foreach (var x in tchActivities)
  345. {
  346. await client.GetContainer(Constant.TEAMModelOS, "Teacher").UpsertItemAsync(x, new PartitionKey(x.code));
  347. }
  348. }
  349. }
  350. catch (Exception ex)
  351. {
  352. await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")}-OS,TriggerStuActivity-SaveStuActivity\n{ex.Message}\n{ex.StackTrace}", GroupNames.醍摩豆服務運維群組);
  353. }
  354. return "";
  355. }
  356. public static async Task RefreshStuActivity(CoreAPIHttpService _coreAPIHttpService ,CosmosClient client, DingDing _dingDing, string id, string code)
  357. {
  358. MQActivity activity = null;
  359. try
  360. {
  361. var aactivity = await client.GetContainer(Constant.TEAMModelOS, "Common").ReadItemStreamAsync(id, new Azure.Cosmos.PartitionKey(code));
  362. using var da = await JsonDocument.ParseAsync(aactivity.ContentStream);
  363. activity = da.ToObject<MQActivity>();
  364. }
  365. catch (CosmosException)
  366. {
  367. activity = null;
  368. }
  369. if (activity != null)
  370. {
  371. List<Task<ItemResponse<StuActivity>>> tasks = new List<Task<ItemResponse<StuActivity>>>();
  372. List<string> classes = ExamService.getClasses(activity.classes, activity.stuLists);
  373. (List<RMember> tmdIds, List<RGroupList> classLists) = await GroupListService.GetStutmdidListids(_coreAPIHttpService, client, _dingDing, classes, activity.school);
  374. var students = tmdIds.FindAll(x => x.type == 2);
  375. var tmdids = tmdIds.FindAll(x => x.type == 1);
  376. if (tmdids.IsNotEmpty())
  377. {
  378. foreach (RMember tmdid in tmdids)
  379. {
  380. var response = await client.GetContainer(Constant.TEAMModelOS, "Student").ReadItemStreamAsync(activity.id, new PartitionKey($"Activity-{tmdid.id}"));
  381. if (response.Status == 200) {
  382. using var json = await JsonDocument.ParseAsync(response.ContentStream);
  383. StuActivity stu = json.ToObject<StuActivity>();
  384. stu.id = activity.id;
  385. stu.scode = activity.code;
  386. stu.name = activity.name;
  387. stu.source = activity.source;
  388. stu.scope = activity.scope;
  389. stu.school = activity.school;
  390. stu.creatorId = activity.creatorId;
  391. stu.type = activity.pk;
  392. stu.subjects = activity.pk.ToLower().Equals("exam") && activity.subjects.IsNotEmpty() ? new List<string>() { activity.subjects[0].id } : new List<string>() { "" };
  393. stu.startTime = activity.startTime;
  394. stu.endTime = activity.endTime;
  395. stu.blob = activity.blob;
  396. stu.owner = activity.owner;
  397. stu.createTime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
  398. tasks.Add(client.GetContainer(Constant.TEAMModelOS, "Student").ReplaceItemAsync(stu,stu.id, new PartitionKey(stu.code)));
  399. }
  400. }
  401. }
  402. if (students.IsNotEmpty())
  403. {
  404. foreach (RMember student in students)
  405. {
  406. var response = await client.GetContainer(Constant.TEAMModelOS, "Student").ReadItemStreamAsync(activity.id, new PartitionKey($"Activity-{activity.school}-{student.id}"));
  407. if (response.Status == 200)
  408. {
  409. using var json = await JsonDocument.ParseAsync(response.ContentStream);
  410. StuActivity stu = json.ToObject<StuActivity>();
  411. stu.id = activity.id;
  412. stu.scode = activity.code;
  413. stu.name = activity.name;
  414. stu.source = activity.source;
  415. stu.scope = activity.scope;
  416. stu.school = activity.school;
  417. stu.creatorId = activity.creatorId;
  418. stu.type = activity.pk;
  419. stu.subjects = activity.pk.ToLower().Equals("exam") && activity.subjects.IsNotEmpty() ? new List<string>() { activity.subjects[0].id } : new List<string>() { "" };
  420. stu.startTime = activity.startTime;
  421. stu.endTime = activity.endTime;
  422. stu.blob = activity.blob;
  423. stu.owner = activity.owner;
  424. stu.createTime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
  425. tasks.Add(client.GetContainer(Constant.TEAMModelOS, "Student").ReplaceItemAsync(stu, stu.id, new PartitionKey(stu.code)));
  426. }
  427. //await client.GetContainer(Constant.TEAMModelOS, "Student").UpsertItemAsync(stucourse, new PartitionKey(stucourse.code));
  428. }
  429. }
  430. await Task.WhenAll(tasks);
  431. }
  432. }
  433. public static async Task updateClassResulte(CosmosClient client,List<ExamClassResult> classResults, List<PaperSimple> standerAnswers, string id,string stuListId)
  434. {
  435. if (classResults.Count > 0)
  436. {
  437. foreach (var item in classResults)
  438. {
  439. if (item.info.id.Equals(stuListId)) {
  440. int index = item.studentIds.IndexOf(id);
  441. if (index == -1)
  442. {
  443. List<List<string>> standard = new List<List<string>>();
  444. foreach (PaperSimple simple in standerAnswers)
  445. {
  446. standard = simple.answers;
  447. }
  448. List<double> ansPoint = new List<double>();
  449. List<List<string>> anc = new List<List<string>>();
  450. List<List<Details>> mark = new List<List<Details>>();
  451. foreach (List<string> num in standard)
  452. {
  453. List<string> newAns = new List<string>();
  454. foreach (string san in num)
  455. {
  456. newAns.Add(san);
  457. }
  458. anc.Add(newAns);
  459. ansPoint.Add(-1);
  460. mark.Add(new List<Details>());
  461. }
  462. item.mark.Add(mark);
  463. item.ans.Add(anc);
  464. item.studentIds.Add(id);
  465. item.studentScores.Add(ansPoint);
  466. item.studentAnswers.Add(new List<string>());
  467. item.sum.Add(0);
  468. }
  469. else
  470. {
  471. item.mark.RemoveAt(index);
  472. item.ans.RemoveAt(index);
  473. item.studentIds.RemoveAt(index);
  474. item.studentScores.RemoveAt(index);
  475. item.studentAnswers.RemoveAt(index);
  476. item.sum.RemoveAt(index);
  477. }
  478. }
  479. await client.GetContainer(Constant.TEAMModelOS, "Common").ReplaceItemAsync(item, item.id, new PartitionKey($"{item.code}"));
  480. }
  481. }
  482. }
  483. public static async Task DeleteActivity(CoreAPIHttpService _coreAPIHttpService, CosmosClient client, DingDing _dingDing, ActivityList activityList) {
  484. List<(string pId, List<string> gid)> ps = new List<(string pId, List<string> gid)>();
  485. if (activityList.groupLists.Count > 0)
  486. {
  487. var group = activityList.groupLists;
  488. foreach (var keys in group)
  489. {
  490. foreach (KeyValuePair<string, List<string>> pp in keys)
  491. {
  492. ps.Add((pp.Key, pp.Value));
  493. }
  494. }
  495. }
  496. List<string> classes = ExamService.getClasses(activityList.classes, activityList.stuLists);
  497. (List<RMember> tmdIds, List<RGroupList> classLists) = await GroupListService.GetStutmdidListids(_coreAPIHttpService, client, _dingDing, classes, activityList.school, ps);
  498. var addStudentsCls = tmdIds.FindAll(x => x.type == 2);
  499. var addTmdidsCls = tmdIds.FindAll(x => x.type == 1);
  500. List<string> tmds = new List<string>();
  501. if (addTmdidsCls.IsNotEmpty())
  502. {
  503. tmds.AddRange(addTmdidsCls.Select(x => x.id).ToList());
  504. }
  505. List<StuActivity> stuActivities = new List<StuActivity>();
  506. List<StuActivity> tmdActivities = new List<StuActivity>();
  507. List<StuActivity> tchActivities = new List<StuActivity>();
  508. if (tmds.IsNotEmpty())
  509. {
  510. tmds.ForEach(x =>
  511. {
  512. tmdActivities.Add(new StuActivity
  513. {
  514. id = activityList.id,
  515. code = $"Activity-{x}",
  516. });
  517. });
  518. }
  519. if (addStudentsCls.IsNotEmpty())
  520. {
  521. addStudentsCls.ForEach(x =>
  522. {
  523. stuActivities.Add(new StuActivity
  524. {
  525. id = activityList.id,
  526. code = $"Activity-{x.code.Replace("Base-", "")}-{x.id}",
  527. });
  528. });
  529. }
  530. (List<RMember> tchList, List<RGroupList> classInfos) = await GroupListService.GetStutmdidListids(_coreAPIHttpService, client, _dingDing, activityList.tchLists, activityList.school, ps);
  531. (string standard, List<string> tmdids, string school, List<string> update, int statistics) list = (null, null, null, new List<string> { StatisticsService.TeacherVote }, 0);
  532. if (tchList.IsNotEmpty())
  533. {
  534. list.tmdids = tchList.Select(x => x.id).ToList();
  535. School school = null;
  536. if (!string.IsNullOrEmpty(activityList.school))
  537. {
  538. school = await client.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<School>(activityList.school, new Azure.Cosmos.PartitionKey("Base"));
  539. list.school = school.id;
  540. list.standard = school.standard;
  541. }
  542. tchList.ForEach(x =>
  543. {
  544. tchActivities.Add(new StuActivity
  545. {
  546. id = activityList.id,
  547. code = $"Activity-{x.id}",
  548. });
  549. });
  550. }
  551. await ActivityService.DeleteStuActivity(client, _dingDing, stuActivities, tmdActivities, tchActivities);
  552. }
  553. public static async Task<string> DeleteStuActivity(CosmosClient client, DingDing _dingDing, List<StuActivity> stuActivities, List<StuActivity> tmdActivities, List<StuActivity> tchActivities)
  554. {
  555. try
  556. {
  557. if (stuActivities.IsNotEmpty())
  558. {
  559. foreach (var x in stuActivities)
  560. {
  561. await client.GetContainer(Constant.TEAMModelOS, "Student").DeleteItemStreamAsync(x.id, new PartitionKey(x.code));
  562. }
  563. }
  564. if (tmdActivities.IsNotEmpty())
  565. {
  566. foreach (var x in tmdActivities)
  567. {
  568. await client.GetContainer(Constant.TEAMModelOS, "Student").DeleteItemStreamAsync(x.id, new PartitionKey(x.code));
  569. }
  570. }
  571. if (tchActivities.IsNotEmpty())
  572. {
  573. foreach (var x in tchActivities)
  574. {
  575. await client.GetContainer(Constant.TEAMModelOS, "Teacher").DeleteItemStreamAsync(x.id, new PartitionKey(x.code));
  576. }
  577. }
  578. }
  579. catch (Exception ex)
  580. {
  581. await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")}-OS,TriggerStuActivity-DeleteStuActivity\n{ex.Message}\n{ex.StackTrace}", GroupNames.醍摩豆服務運維群組);
  582. }
  583. return "";
  584. }
  585. }
  586. public class ActivityList
  587. {
  588. public string id { get; set; }
  589. public string school { get; set; }
  590. /// <summary>
  591. /// 行政班
  592. /// </summary>
  593. public List<string> classes { get; set; } = new List<string>();
  594. /// <summary>
  595. /// 学生名单(包含自定义个人学生名单,学校教学班)
  596. /// </summary>
  597. public List<string> stuLists { get; set; } = new List<string>();
  598. /// <summary>
  599. /// 教研组名单
  600. /// </summary>
  601. public List<string> tchLists { get; set; } = new List<string>();
  602. public List<Dictionary<string, List<string>>> groupLists { get; set; } = new List<Dictionary<string, List<string>>>();
  603. }
  604. }