ScoreCalc.cs 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670
  1. using DocumentFormat.OpenXml.Spreadsheet;
  2. using System;
  3. using System.Collections.Generic;
  4. using System.Linq;
  5. using System.Text;
  6. using System.Threading.Tasks;
  7. namespace TEAMModelOS.SDK.Models.Cosmos.School
  8. {
  9. /// <summary>
  10. /// 成績計算總覽
  11. /// </summary>
  12. public class ScoreCalcBase : CosmosEntity
  13. {
  14. public ScoreCalcBase()
  15. {
  16. pk = "ScoreCalc";
  17. members = new List<ScoreCalcMember>();
  18. //scores = new List<double>();
  19. //scoresOrg = new List<double>();
  20. editScores = new List<double>();
  21. }
  22. /// <summary>
  23. /// 名稱
  24. /// </summary>
  25. public string name { get; set; }
  26. /// <summary>
  27. /// 課程ID
  28. /// </summary>
  29. public string courseId { get; set; }
  30. /// <summary>
  31. /// 班級ID(行政班)
  32. /// </summary>
  33. public string classId { get; set; }
  34. /// <summary>
  35. /// 班級ID(選課班、個人課程ID)
  36. /// </summary>
  37. public string grouplistId { get; set; }
  38. /// <summary>
  39. /// 成員名單
  40. /// </summary>
  41. public List<ScoreCalcMember> members { get; set; }
  42. /// <summary>
  43. /// 各成員成績總覽
  44. /// </summary>
  45. //public List<double> scores { get; set; }
  46. /// <summary>
  47. /// 各成員成績總覽最初系統計算結果
  48. /// </summary>
  49. //public List<double> scoresOrg { get; set; }
  50. /// <summary>
  51. /// 各學生最後成績的加減分
  52. /// </summary>
  53. public List<double> editScores { get; set; }
  54. /// <summary>
  55. /// 總覽分項權重類型 count:加權 | percentage:百分比
  56. /// </summary>
  57. public string rateType { get; set; }
  58. }
  59. /// <summary>
  60. /// 成績計算總覽分項-活動基底Class
  61. /// </summary>
  62. public class ScoreCalcActivityBase : CosmosEntity
  63. {
  64. public ScoreCalcActivityBase()
  65. {
  66. pk = "ScoreCalcAct";
  67. itemRates = new List<double>();
  68. //itemScores = new List<double>();
  69. //itemScoresOrg = new List<double>();
  70. //stuScores = new List<double>();
  71. }
  72. /// <summary>
  73. /// 成績計算ID
  74. /// </summary>
  75. public string scorecalcId { get; set; }
  76. /// <summary>
  77. /// 活動名稱
  78. /// </summary>
  79. public string name { get; set; }
  80. /// <summary>
  81. /// 類型 exam:評量 | homework:作業 | lessonrecord:課堂紀錄
  82. /// </summary>
  83. public string type { get; set; }
  84. /// <summary>
  85. /// 總加權數
  86. /// </summary>
  87. public double rate { get; set; }
  88. /// <summary>
  89. /// 個學生最後成績的加減分
  90. /// </summary>
  91. public List<double> editScores { get; set; }
  92. /// <summary>
  93. /// 各活動權重
  94. /// </summary>
  95. public List<double> itemRates { get; set; }
  96. /// <summary>
  97. /// 各活動權重類型 count:加權 | percentage:百分比
  98. /// </summary>
  99. //public string itemRateType { get; set; }
  100. /// <summary>
  101. /// 各活動分數最終結果 - 一門課全部學生的平均 - 編輯後
  102. /// </summary>
  103. //public List<double> itemScores { get; set; }
  104. /// <summary>
  105. /// 各活動分數最初系統計算結果 - 一門課全部學生的平均 - 原始
  106. /// </summary>
  107. //public List<double> itemScoresOrg { get; set; }
  108. /// <summary>
  109. /// 最終成績 - 一個項目總平均 - 編輯後
  110. /// </summary>
  111. //public double score { get; set; }
  112. /// <summary>
  113. /// 最終成績系統計算結果 - 一個項目總平均 - 原始
  114. /// </summary>
  115. //public double scoreOrg { get; set; }
  116. /// <summary>
  117. /// 各學生所有活動結算成績 - 此項目所有學生的計算後分數
  118. /// </summary>
  119. //public List<double> stuScores { get; set; }
  120. }
  121. /// <summary>
  122. /// 成績計算總覽分項-評量、作業
  123. /// </summary>
  124. public class ScoreCalcActivity : ScoreCalcActivityBase
  125. {
  126. public ScoreCalcActivity()
  127. {
  128. items = new List<ScoreCalcActivityItems>();
  129. stuActScores = new List<List<double>>();
  130. stuActScoresOrg = new List<List<double>>();
  131. }
  132. /// <summary>
  133. /// 被選取的活動列表
  134. /// </summary>
  135. public List<ScoreCalcActivityItems> items { get; set; }
  136. /// <summary>
  137. /// 各活動所屬學生成績
  138. /// </summary>
  139. public List<List<double>> stuActScores { get; set; }
  140. /// <summary>
  141. /// 各活動所屬學生成績最初系統計算結果
  142. /// </summary>
  143. public List<List<double>> stuActScoresOrg { get; set; }
  144. }
  145. /// <summary>
  146. /// 成績計算總覽分項-課堂紀錄
  147. /// </summary>
  148. public class ScoreCalcLsRecord : ScoreCalcActivityBase
  149. {
  150. public ScoreCalcLsRecord()
  151. {
  152. items = new List<ScoreCalcActivityItems>();
  153. stuActAttendOrgVals = new List<List<double>>();
  154. stuActAttendScores = new List<List<double>>();
  155. //stuAttendScores = new List<double>();
  156. stuActPointOrgVals = new List<List<double>>();
  157. stuActPointScores = new List<List<double>>();
  158. //stuPointScores = new List<double>();
  159. stuActItactOrgVals = new List<List<double>>();
  160. stuActItactScores = new List<List<double>>();
  161. //stuItactScores = new List<double>();
  162. }
  163. /// <summary>
  164. /// 出席加權數
  165. /// </summary>
  166. public double attendRate { get; set; }
  167. /// <summary>
  168. /// 記分板加權數
  169. /// </summary>
  170. public double pointRate { get; set; }
  171. /// <summary>
  172. /// 互動加權數
  173. /// </summary>
  174. public double itactRate { get; set; }
  175. /// <summary>
  176. /// 總加權數
  177. /// </summary>
  178. /// <summary>
  179. /// 被選取的課堂紀錄列表
  180. /// </summary>
  181. public List<ScoreCalcActivityItems> items { get; set; }
  182. #region ==========出席==========
  183. /// <summary>
  184. /// 課堂紀錄出席 採用的公式ID (依照items順序 第一個課堂紀錄公式 第二個...)
  185. /// </summary>
  186. public string stuAttendFunctionId { get; set; }
  187. /// <summary>
  188. /// 各學生各課堂紀錄出席 系統原值
  189. /// </summary>
  190. public List<List<double>> stuActAttendOrgVals { get; set; }
  191. /// <summary>
  192. /// 各學生各課堂紀錄出席 分數
  193. /// </summary>
  194. public List<List<double>> stuActAttendScores { get; set; }
  195. /// <summary>
  196. /// 各學生所有課堂紀錄出席 分數
  197. /// </summary>
  198. //public List<double> stuAttendScores { get; set; }
  199. #endregion
  200. #region ==========記分板==========
  201. /// <summary>
  202. /// 課堂紀錄記分板 採用的公式ID
  203. /// </summary>
  204. public string stuPointFunctionId { get; set; }
  205. /// <summary>
  206. /// 各學生各課堂紀錄記分板 系統原值
  207. /// </summary>
  208. public List<List<double>> stuActPointOrgVals { get; set; }
  209. /// <summary>
  210. /// 各學生各課堂紀錄記分板 分數
  211. /// </summary>
  212. public List<List<double>> stuActPointScores { get; set; }
  213. /// <summary>
  214. /// 各學生所有課堂紀錄記分板 分數
  215. /// </summary>
  216. //public List<double> stuPointScores { get; set; }
  217. #endregion
  218. #region ==========互動==========
  219. /// <summary>
  220. /// 課堂紀錄互動 採用的公式ID
  221. /// </summary>
  222. public string stuItactFunctionId { get; set; }
  223. /// <summary>
  224. /// 各學生各課堂紀錄互動 系統原值
  225. /// </summary>
  226. public List<List<double>> stuActItactOrgVals { get; set; }
  227. /// <summary>
  228. /// 各學生各課堂紀錄互動 分數
  229. /// </summary>
  230. public List<List<double>> stuActItactScores { get; set; }
  231. /// <summary>
  232. /// 各學生所有課堂紀錄互動 分數
  233. /// </summary>
  234. //public List<double> stuItactScores { get; set; }
  235. #endregion
  236. }
  237. public class ScoreCalcMember
  238. {
  239. /// <summary>
  240. /// ID(學生ID、TMID)
  241. /// </summary>
  242. public string id { get; set; }
  243. public string name { get; set; }
  244. /// <summary>
  245. /// 座號
  246. /// </summary>
  247. public string no { get; set; }
  248. }
  249. /// <summary>
  250. /// 測驗、作業
  251. /// </summary>
  252. public class ScoreCalcActivityItems
  253. {
  254. /// <summary>
  255. /// 活動ID (測驗:examId 作業:homeworkId)
  256. /// </summary>
  257. public string id { get; set; }
  258. /// <summary>
  259. /// 活動分區鍵
  260. /// </summary>
  261. public string code { get; set; }
  262. /// <summary>
  263. /// 發布對象 學校(school)/個人(private)
  264. /// </summary>
  265. //public string scope { get; set; }
  266. /// <summary>
  267. /// (評量專有)擁有者 學校(school)/個人(teacher)
  268. /// </summary>
  269. //public string owner { get; set; }
  270. /// <summary>
  271. /// 活動名稱
  272. /// </summary>
  273. public string name { get; set; }
  274. /// <summary>
  275. /// 活動進度 pending 待发布 | going 已发布 | finish 已结束
  276. /// </summary>
  277. //public string progress { get; set; }
  278. /// <summary>
  279. /// 活動評分狀態(評量專用) 0未评分,1已评分
  280. /// </summary>
  281. //public int sStatus { get; set; } = 0;
  282. /// <summary>
  283. /// 評測類型(評量專用) 0:線上評量 | 1:課中評量 | 2.卷卡合一
  284. /// </summary>
  285. //public string source { get; set; }
  286. /// <summary>
  287. /// 創建時間 (milliseconds 13位數)
  288. /// </summary>
  289. public long createTime { get; set; }
  290. /// <summary>
  291. /// 是否使用(是否被勾選) true:使用
  292. /// </summary>
  293. public bool use { get; set; }
  294. }
  295. /// <summary>
  296. /// 老師成績計算公式 code:"ScoreCalcFunc-{TMID}"
  297. /// </summary>
  298. public class ScoreCalcFunc : CosmosEntity
  299. {
  300. public ScoreCalcFunc()
  301. {
  302. pk = "ScoreCalcActFormula";
  303. keyvals = new List<ScoreCalcFuncTemplateKeyval>();
  304. }
  305. public string name { get; set; }
  306. public string scorecalcActId { get; set; }
  307. /// <summary>
  308. /// 類型 exam:評量 | homework:作業 | lessonrecord:課堂紀錄
  309. /// </summary>
  310. public string type { get; set; }
  311. /// <summary>
  312. /// 種類 attend:出席 | point:得分版 | interaction:互動
  313. /// </summary>
  314. public string method { get; set; }
  315. /// <summary>
  316. /// 模板 simpleAttend: 簡單出席計算法 | attendRate:出席率計算法 | custom:自訂
  317. /// </summary>
  318. public string template { get; set; }
  319. /// <summary>
  320. /// 公式鍵值定義
  321. /// </summary>
  322. public List<ScoreCalcFuncTemplateKeyval> keyvals { get; set; }
  323. /// <summary>
  324. /// 公式內容
  325. /// </summary>
  326. public string content { get; set; }
  327. }
  328. public class ScoreCalcFuncTemplateKeyval
  329. {
  330. public string key { get; set; }
  331. public string val { get; set; }
  332. //public string type { get; set; }
  333. //public string describe { get; set; }
  334. }
  335. /// <summary>
  336. /// 評量活動取系統資料
  337. /// </summary>
  338. public class ExamItem
  339. {
  340. /// <summary>
  341. /// 評量id
  342. /// </summary>
  343. public string examId { get; set; }
  344. /// <summary>
  345. /// 評量名稱
  346. /// </summary>
  347. public string name { get; set; }
  348. /// <summary>
  349. /// 評量學生Id列表
  350. /// </summary>
  351. public List<string> studentIds { get; set; }
  352. /// <summary>
  353. /// 評量分數列表
  354. /// </summary>
  355. public List<double> sum { get; set; }
  356. }
  357. /// <summary>
  358. /// 取作業活動Id
  359. /// </summary>
  360. public class HomeworkItem
  361. {
  362. /// <summary>
  363. /// 作業id
  364. /// </summary>
  365. public string id { get; set; }
  366. /// <summary>
  367. /// 作業名稱
  368. /// </summary>
  369. public string name { get; set; }
  370. /// <summary>
  371. /// 作業代碼 包含學生座號
  372. /// </summary>
  373. public string code { get; set; }
  374. /// <summary>
  375. /// 分數
  376. /// </summary>
  377. public double score { get; set; }
  378. /// <summary>
  379. /// pk
  380. /// </summary>
  381. public string pk { get; set; }
  382. /// <summary>
  383. /// school id
  384. /// </summary>
  385. public string school { get; set; }
  386. }
  387. #region (四)更新成績統計首頁表資料用
  388. /// <summary>
  389. /// 更新成績統計首頁表資料 參數
  390. /// </summary>
  391. public class UpdateSscoreCalcRq
  392. {
  393. public UpdateSscoreCalcRq()
  394. {
  395. ScoreCalcAct = new List<ScoreCalcAct>();
  396. editScores = new List<double>();
  397. }
  398. /// <summary>
  399. /// 成績統計id
  400. /// </summary>
  401. public string id { get; set; }
  402. /// <summary>
  403. /// teammodelId
  404. /// </summary>
  405. public string teammodelId { get; set; }
  406. /// <summary>
  407. /// 成績統計名稱
  408. /// </summary>
  409. public string name { get; set; }
  410. /// <summary>
  411. /// 成績統計名稱
  412. /// </summary>
  413. public List<ScoreCalcAct> ScoreCalcAct { get; set; }
  414. /// <summary>
  415. /// 成績統計的加減分
  416. /// </summary>
  417. public List<double> editScores { get; set; }
  418. }
  419. /// <summary>
  420. /// 更新成績統計首頁表資料 參數ScoreCalcAct
  421. /// </summary>
  422. public class ScoreCalcAct
  423. {
  424. public ScoreCalcAct()
  425. {
  426. editScores = new List<double>();
  427. }
  428. /// <summary>
  429. /// 項目id
  430. /// </summary>
  431. public string id { get; set; }
  432. /// <summary>
  433. /// 項目類別
  434. /// </summary>
  435. public string type { get; set; }
  436. /// <summary>
  437. /// 出席比重
  438. /// </summary>
  439. public double attendRate { get; set; }
  440. /// <summary>
  441. /// 記分比重
  442. /// </summary>
  443. public double pointRate { get; set; }
  444. /// <summary>
  445. /// 互動比重
  446. /// </summary>
  447. public double itactRate { get; set; }
  448. /// <summary>
  449. /// 總比重
  450. /// </summary>
  451. public double rate { get; set; }
  452. /// <summary>
  453. /// 項目成績的加減分
  454. /// </summary>
  455. public List<double> editScores { get; set; }
  456. }
  457. #endregion
  458. #region API回傳資料用
  459. #region (二)查詢成績統計首頁表資料用
  460. /// <summary>
  461. /// 查詢總表-活動資料的Base
  462. /// </summary>
  463. public class ScoreCalcActDtoBase
  464. {
  465. public ScoreCalcActDtoBase()
  466. {
  467. editScores = new List<double>();
  468. }
  469. /// <summary>
  470. /// 活動id
  471. /// </summary>
  472. public string id { get; set; }
  473. /// <summary>
  474. /// 活動名稱
  475. /// </summary>
  476. public string name { get; set; }
  477. /// <summary>
  478. /// 類型 exam:評量 | homework:作業 | lessonrecord:課堂紀錄
  479. /// </summary>
  480. public string type { get; set; }
  481. /// <summary>
  482. /// 活動加權數
  483. /// </summary>
  484. public double rate { get; set; }
  485. /// <summary>
  486. /// 個學生最後成績的加減分
  487. /// </summary>
  488. public List<double> editScores { get; set; }
  489. }
  490. /// <summary>
  491. /// 查詢總表-活動資料的詳細列表資料
  492. /// </summary>
  493. public class ScoreCalcActivityActDto : ScoreCalcActDtoBase
  494. {
  495. public ScoreCalcActivityActDto()
  496. {
  497. items = new List<SubActActivity>();
  498. }
  499. /// <summary>
  500. /// 活動子項目資料列表
  501. /// </summary>
  502. public List<SubActActivity> items { get; set; }
  503. }
  504. /// <summary>
  505. /// 查詢總表-活動資料課堂紀錄的詳細列表資料
  506. /// </summary>
  507. public class ScoreCalcLsRecordActDto : ScoreCalcActDtoBase
  508. {
  509. public ScoreCalcLsRecordActDto()
  510. {
  511. items = new List<SubActLsRecord>();
  512. attendStates = new List<AttendStatesCalc>();
  513. }
  514. /// <summary>
  515. /// 出席占比重
  516. /// </summary>
  517. public double attendRate { get; set; }
  518. /// <summary>
  519. /// 記分板占比重
  520. /// </summary>
  521. public double pointRate { get; set; }
  522. /// <summary>
  523. /// 互動占比重
  524. /// </summary>
  525. public double itactRate { get; set; }
  526. /// <summary>
  527. /// 出席公式
  528. /// </summary>
  529. public string stuAttendFunctionId { get; set; }
  530. /// <summary>
  531. /// 記分公式
  532. /// </summary>
  533. public string stuPointFunctionId { get; set; }
  534. /// <summary>
  535. /// 互動公式
  536. /// </summary>
  537. public string stuItactFunctionId { get; set; }
  538. /// <summary>
  539. /// 出席狀態統計資料
  540. /// </summary>
  541. public List<AttendStatesCalc> attendStates { get; set; }
  542. /// <summary>
  543. /// 子項目資料列表
  544. /// </summary>
  545. public List<SubActLsRecord> items { get; set; }
  546. }
  547. /// <summary>
  548. /// 統計出席狀態
  549. /// Uncall,0(未點名)
  550. /// Attended,1(出席)
  551. /// Absent,2(缺席)
  552. /// DayOff,3(請假)
  553. /// Absent_Sick,4(病假)
  554. /// Absent_Personal,5(事假)
  555. /// Absent_Official,6(公假)
  556. /// </summary>
  557. public class AttendStatesCalc
  558. {
  559. /// <summary>
  560. /// 病假次數
  561. /// </summary>
  562. public int Absent_Sick { get; set; }
  563. /// <summary>
  564. /// 缺席次數
  565. /// </summary>
  566. public int Absent { get; set; }
  567. /// <summary>
  568. /// 事假次數
  569. /// </summary>
  570. public int Absent_Personal { get; set; }
  571. /// <summary>
  572. /// 公假次數
  573. /// </summary>
  574. public int Absent_Official { get; set; }
  575. }
  576. /// <summary>
  577. /// 子項目欄位的Base
  578. /// </summary>
  579. public class SubActBase
  580. {
  581. /// <summary>
  582. /// 子項目id
  583. /// </summary>
  584. public string id { get; set; }
  585. /// <summary>
  586. /// 子項目名稱
  587. /// </summary>
  588. public string name { get; set; }
  589. /// <summary>
  590. /// 子項目加權數
  591. /// </summary>
  592. public double rate { get; set; }
  593. /// <summary>
  594. /// 是否為勾選的項目
  595. /// </summary>
  596. public bool use { get; set; }
  597. }
  598. /// <summary>
  599. /// 活動子項目欄位
  600. /// </summary>
  601. public class SubActActivity : SubActBase
  602. {
  603. public SubActActivity()
  604. {
  605. scores = new List<double>();
  606. }
  607. public List<double> scores { get; set; }
  608. }
  609. /// <summary>
  610. /// 課堂紀錄子項目欄位
  611. /// </summary>
  612. public class SubActLsRecord : SubActBase
  613. {
  614. public SubActLsRecord()
  615. {
  616. stuActAttendScores = new List<double>();
  617. stuActPointScores = new List<double>();
  618. stuActItactScores = new List<double>();
  619. }
  620. /// <summary>
  621. /// 出席分數
  622. /// </summary>
  623. public List<double> stuActAttendScores { get; set; }
  624. /// <summary>
  625. /// 記分板分數
  626. /// </summary>
  627. public List<double> stuActPointScores { get; set; }
  628. /// <summary>
  629. /// 互動分數
  630. /// </summary>
  631. public List<double> stuActItactScores { get; set; }
  632. }
  633. /// <summary>
  634. /// 成績統計列表用資料
  635. /// </summary>
  636. public class Calc
  637. {
  638. /// <summary>
  639. /// 成績統計id
  640. /// </summary>
  641. public string id { get; set; }
  642. /// <summary>
  643. /// 成績統計名稱
  644. /// </summary>
  645. public string name { get; set; }
  646. }
  647. #endregion
  648. #endregion
  649. }