ScoreCalc.cs 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725
  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. // 取物件Id用
  459. public class ItemId
  460. {
  461. /// <summary>
  462. /// id
  463. /// </summary>
  464. public string id { get; set; }
  465. }
  466. #region (六)更新公式設定(一次可以處理多個公式)資料用
  467. /// <summary>
  468. /// 更新公式資料 參數
  469. /// </summary>
  470. public class UpdateFormulaRq
  471. {
  472. public UpdateFormulaRq()
  473. {
  474. scoreCalcFunc = new List<ScoreCalcFuncRq>();
  475. }
  476. /// <summary>
  477. /// 項目id
  478. /// </summary>
  479. public string scoreCalcActId { get; set; }
  480. /// <summary>
  481. /// teammodelId
  482. /// </summary>
  483. public string teammodelId { get; set; }
  484. /// <summary>
  485. /// 種類 attend:出席 | point:得分版 | interaction:互動
  486. /// </summary>
  487. public string method { get; set; }
  488. /// <summary>
  489. /// 公式資料列表
  490. /// </summary>
  491. public List<ScoreCalcFuncRq> scoreCalcFunc { get; set; }
  492. }
  493. /// <summary>
  494. /// 更新公式資料用的 細項參數
  495. /// </summary>
  496. public class ScoreCalcFuncRq: ScoreCalcFunc
  497. {
  498. /// <summary>
  499. /// 是否為使用中的公式
  500. /// </summary>
  501. public bool use { get; set; }
  502. }
  503. #endregion
  504. #region API回傳資料用
  505. #region (二)查詢成績統計首頁表資料用
  506. /// <summary>
  507. /// 查詢總表-活動資料的Base
  508. /// </summary>
  509. public class ScoreCalcActDtoBase
  510. {
  511. public ScoreCalcActDtoBase()
  512. {
  513. editScores = new List<double>();
  514. }
  515. /// <summary>
  516. /// 活動id
  517. /// </summary>
  518. public string id { get; set; }
  519. /// <summary>
  520. /// 活動名稱
  521. /// </summary>
  522. public string name { get; set; }
  523. /// <summary>
  524. /// 類型 exam:評量 | homework:作業 | lessonrecord:課堂紀錄
  525. /// </summary>
  526. public string type { get; set; }
  527. /// <summary>
  528. /// 活動加權數
  529. /// </summary>
  530. public double rate { get; set; }
  531. /// <summary>
  532. /// 個學生最後成績的加減分
  533. /// </summary>
  534. public List<double> editScores { get; set; }
  535. }
  536. /// <summary>
  537. /// 查詢總表-活動資料的詳細列表資料
  538. /// </summary>
  539. public class ScoreCalcActivityActDto : ScoreCalcActDtoBase
  540. {
  541. public ScoreCalcActivityActDto()
  542. {
  543. items = new List<SubActActivity>();
  544. }
  545. /// <summary>
  546. /// 活動子項目資料列表
  547. /// </summary>
  548. public List<SubActActivity> items { get; set; }
  549. }
  550. /// <summary>
  551. /// 查詢總表-活動資料課堂紀錄的詳細列表資料
  552. /// </summary>
  553. public class ScoreCalcLsRecordActDto : ScoreCalcActDtoBase
  554. {
  555. public ScoreCalcLsRecordActDto()
  556. {
  557. items = new List<SubActLsRecord>();
  558. attendStates = new List<AttendStatesCalc>();
  559. }
  560. /// <summary>
  561. /// 出席占比重
  562. /// </summary>
  563. public double attendRate { get; set; }
  564. /// <summary>
  565. /// 記分板占比重
  566. /// </summary>
  567. public double pointRate { get; set; }
  568. /// <summary>
  569. /// 互動占比重
  570. /// </summary>
  571. public double itactRate { get; set; }
  572. /// <summary>
  573. /// 出席公式
  574. /// </summary>
  575. public string stuAttendFunctionId { get; set; }
  576. /// <summary>
  577. /// 記分公式
  578. /// </summary>
  579. public string stuPointFunctionId { get; set; }
  580. /// <summary>
  581. /// 互動公式
  582. /// </summary>
  583. public string stuItactFunctionId { get; set; }
  584. /// <summary>
  585. /// 出席狀態統計資料
  586. /// </summary>
  587. public List<AttendStatesCalc> attendStates { get; set; }
  588. /// <summary>
  589. /// 子項目資料列表
  590. /// </summary>
  591. public List<SubActLsRecord> items { get; set; }
  592. }
  593. /// <summary>
  594. /// 統計出席狀態
  595. /// Uncall,0(未點名)
  596. /// Attended,1(出席)
  597. /// Absent,2(缺席)
  598. /// DayOff,3(請假)
  599. /// Absent_Sick,4(病假)
  600. /// Absent_Personal,5(事假)
  601. /// Absent_Official,6(公假)
  602. /// </summary>
  603. public class AttendStatesCalc
  604. {
  605. /// <summary>
  606. /// 病假次數
  607. /// </summary>
  608. public int Absent_Sick { get; set; }
  609. /// <summary>
  610. /// 缺席次數
  611. /// </summary>
  612. public int Absent { get; set; }
  613. /// <summary>
  614. /// 事假次數
  615. /// </summary>
  616. public int Absent_Personal { get; set; }
  617. /// <summary>
  618. /// 公假次數
  619. /// </summary>
  620. public int Absent_Official { get; set; }
  621. }
  622. /// <summary>
  623. /// 子項目欄位的Base
  624. /// </summary>
  625. public class SubActBase
  626. {
  627. /// <summary>
  628. /// 子項目id
  629. /// </summary>
  630. public string id { get; set; }
  631. /// <summary>
  632. /// 子項目名稱
  633. /// </summary>
  634. public string name { get; set; }
  635. /// <summary>
  636. /// 子項目加權數
  637. /// </summary>
  638. public double rate { get; set; }
  639. /// <summary>
  640. /// 是否為勾選的項目
  641. /// </summary>
  642. public bool use { get; set; }
  643. }
  644. /// <summary>
  645. /// 活動子項目欄位
  646. /// </summary>
  647. public class SubActActivity : SubActBase
  648. {
  649. public SubActActivity()
  650. {
  651. scores = new List<double>();
  652. }
  653. public List<double> scores { get; set; }
  654. }
  655. /// <summary>
  656. /// 課堂紀錄子項目欄位
  657. /// </summary>
  658. public class SubActLsRecord : SubActBase
  659. {
  660. public SubActLsRecord()
  661. {
  662. stuActAttendScores = new List<double>();
  663. stuActPointScores = new List<double>();
  664. stuActItactScores = new List<double>();
  665. }
  666. /// <summary>
  667. /// 出席分數
  668. /// </summary>
  669. public List<double> stuActAttendScores { get; set; }
  670. /// <summary>
  671. /// 記分板分數
  672. /// </summary>
  673. public List<double> stuActPointScores { get; set; }
  674. /// <summary>
  675. /// 互動分數
  676. /// </summary>
  677. public List<double> stuActItactScores { get; set; }
  678. }
  679. /// <summary>
  680. /// 成績統計列表用資料
  681. /// </summary>
  682. public class Calc
  683. {
  684. /// <summary>
  685. /// 成績統計id
  686. /// </summary>
  687. public string id { get; set; }
  688. /// <summary>
  689. /// 成績統計名稱
  690. /// </summary>
  691. public string name { get; set; }
  692. }
  693. #endregion
  694. #endregion
  695. }