ScoreCalc.cs 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597
  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 API回傳資料用
  388. #region (二)查詢成績統計首頁表資料用
  389. /// <summary>
  390. /// 查詢總表-活動資料的Base
  391. /// </summary>
  392. public class ScoreCalcActDtoBase
  393. {
  394. public ScoreCalcActDtoBase()
  395. {
  396. editScores = new List<double>();
  397. }
  398. /// <summary>
  399. /// 活動id
  400. /// </summary>
  401. public string id { get; set; }
  402. /// <summary>
  403. /// 活動名稱
  404. /// </summary>
  405. public string name { get; set; }
  406. /// <summary>
  407. /// 類型 exam:評量 | homework:作業 | lessonrecord:課堂紀錄
  408. /// </summary>
  409. public string type { get; set; }
  410. /// <summary>
  411. /// 活動加權數
  412. /// </summary>
  413. public double rate { get; set; }
  414. /// <summary>
  415. /// 個學生最後成績的加減分
  416. /// </summary>
  417. public List<double> editScores { get; set; }
  418. }
  419. /// <summary>
  420. /// 查詢總表-活動資料的詳細列表資料
  421. /// </summary>
  422. public class ScoreCalcActivityActDto : ScoreCalcActDtoBase
  423. {
  424. public ScoreCalcActivityActDto()
  425. {
  426. items = new List<SubActActivity>();
  427. }
  428. /// <summary>
  429. /// 活動子項目資料列表
  430. /// </summary>
  431. public List<SubActActivity> items { get; set; }
  432. }
  433. /// <summary>
  434. /// 查詢總表-活動資料課堂紀錄的詳細列表資料
  435. /// </summary>
  436. public class ScoreCalcLsRecordActDto : ScoreCalcActDtoBase
  437. {
  438. public ScoreCalcLsRecordActDto()
  439. {
  440. items = new List<SubActLsRecord>();
  441. attendStates = new List<AttendStatesCalc>();
  442. }
  443. /// <summary>
  444. /// 出席占比重
  445. /// </summary>
  446. public double attendRate { get; set; }
  447. /// <summary>
  448. /// 記分板占比重
  449. /// </summary>
  450. public double pointRate { get; set; }
  451. /// <summary>
  452. /// 互動占比重
  453. /// </summary>
  454. public double itactRate { get; set; }
  455. /// <summary>
  456. /// 出席公式
  457. /// </summary>
  458. public string stuAttendFunctionId { get; set; }
  459. /// <summary>
  460. /// 記分公式
  461. /// </summary>
  462. public string stuPointFunctionId { get; set; }
  463. /// <summary>
  464. /// 互動公式
  465. /// </summary>
  466. public string stuItactFunctionId { get; set; }
  467. /// <summary>
  468. /// 出席狀態統計資料
  469. /// </summary>
  470. public List<AttendStatesCalc> attendStates { get; set; }
  471. /// <summary>
  472. /// 子項目資料列表
  473. /// </summary>
  474. public List<SubActLsRecord> items { get; set; }
  475. }
  476. /// <summary>
  477. /// 統計出席狀態
  478. /// Uncall,0(未點名)
  479. /// Attended,1(出席)
  480. /// Absent,2(缺席)
  481. /// DayOff,3(請假)
  482. /// Absent_Sick,4(病假)
  483. /// Absent_Personal,5(事假)
  484. /// Absent_Official,6(公假)
  485. /// </summary>
  486. public class AttendStatesCalc
  487. {
  488. /// <summary>
  489. /// 病假次數
  490. /// </summary>
  491. public int Absent_Sick { get; set; }
  492. /// <summary>
  493. /// 缺席次數
  494. /// </summary>
  495. public int Absent { get; set; }
  496. /// <summary>
  497. /// 事假次數
  498. /// </summary>
  499. public int Absent_Personal { get; set; }
  500. /// <summary>
  501. /// 公假次數
  502. /// </summary>
  503. public int Absent_Official { get; set; }
  504. }
  505. /// <summary>
  506. /// 子項目欄位的Base
  507. /// </summary>
  508. public class SubActBase
  509. {
  510. /// <summary>
  511. /// 子項目id
  512. /// </summary>
  513. public string id { get; set; }
  514. /// <summary>
  515. /// 子項目名稱
  516. /// </summary>
  517. public string name { get; set; }
  518. /// <summary>
  519. /// 子項目加權數
  520. /// </summary>
  521. public double rate { get; set; }
  522. /// <summary>
  523. /// 是否為勾選的項目
  524. /// </summary>
  525. public bool use { get; set; }
  526. }
  527. /// <summary>
  528. /// 活動子項目欄位
  529. /// </summary>
  530. public class SubActActivity: SubActBase
  531. {
  532. public SubActActivity()
  533. {
  534. scores = new List<double>();
  535. }
  536. public List<double> scores { get; set; }
  537. }
  538. /// <summary>
  539. /// 課堂紀錄子項目欄位
  540. /// </summary>
  541. public class SubActLsRecord: SubActBase
  542. {
  543. public SubActLsRecord()
  544. {
  545. stuActAttendScores = new List<double>();
  546. stuActPointScores = new List<double>();
  547. stuActItactScores = new List<double>();
  548. }
  549. /// <summary>
  550. /// 出席分數
  551. /// </summary>
  552. public List<double> stuActAttendScores { get; set; }
  553. /// <summary>
  554. /// 記分板分數
  555. /// </summary>
  556. public List<double> stuActPointScores { get; set; }
  557. /// <summary>
  558. /// 互動分數
  559. /// </summary>
  560. public List<double> stuActItactScores { get; set; }
  561. }
  562. /// <summary>
  563. /// 成績統計列表用資料
  564. /// </summary>
  565. public class Calc
  566. {
  567. /// <summary>
  568. /// 成績統計id
  569. /// </summary>
  570. public string id { get; set; }
  571. /// <summary>
  572. /// 成績統計名稱
  573. /// </summary>
  574. public string name { get; set; }
  575. }
  576. #endregion
  577. #endregion
  578. }