/// <summary> /// 處理報表學期型值 /// </summary> /// <param name="data"></param> /// <param name="idx"></param> /// <returns></returns> public static string Counsel_SemesterData_Parse1(UDTSemesterDataDef data, int idx) { string retVal = ""; if (data != null) { if (idx == 1 && !string.IsNullOrWhiteSpace(data.S1a)) retVal = data.S1a; if (idx == 2 && !string.IsNullOrWhiteSpace(data.S1b)) retVal = data.S1b; if (idx == 3 && !string.IsNullOrWhiteSpace(data.S2a)) retVal = data.S2a; if (idx == 4 && !string.IsNullOrWhiteSpace(data.S2b)) retVal = data.S2b; if (idx == 5 && !string.IsNullOrWhiteSpace(data.S3a)) retVal = data.S3a; if (idx == 6 && !string.IsNullOrWhiteSpace(data.S3b)) retVal = data.S3b; if (idx == 7 && !string.IsNullOrWhiteSpace(data.S4b)) retVal = data.S4b; if (idx == 8 && !string.IsNullOrWhiteSpace(data.S4b)) retVal = data.S4b; if (idx == 9 && !string.IsNullOrWhiteSpace(data.S5b)) retVal = data.S5b; if (idx == 10 && !string.IsNullOrWhiteSpace(data.S5b)) retVal = data.S5b; if (idx == 11 && !string.IsNullOrWhiteSpace(data.S6b)) retVal = data.S6b; if (idx == 12 && !string.IsNullOrWhiteSpace(data.S6b)) retVal = data.S6b; } return retVal; }
/// <summary> /// 載入答案 /// </summary> private void LoadAnswerData() { _udtMrFlp01Dict.Clear(); _udtMrFlp02Dict.Clear(); _udtSdDg01 = _udtSdDg02 = null; _udtSrFlp01 = _udtSrFlp02 = null; List<UDTSingleRecordDef> SingleRecordList = UDTTransfer.ABUDTSingleRecordSelectByStudentIDList(_StudenIDList); foreach(UDTSingleRecordDef data in SingleRecordList) { if(data.Key == enumKey.本人概況_血型.ToString()) _udtSrFlp01=data; if (data.Key == enumKey.本人概況_宗教.ToString()) _udtSrFlp02 = data; } List<UDTSemesterDataDef> SemesterDataList = UDTTransfer.ABUDTSemesterDataSelectByStudentIDList(_StudenIDList); foreach (UDTSemesterDataDef data in SemesterDataList) { if (data.Key == enumKey.本人概況_身高.ToString()) _udtSdDg01 = data; if (data.Key == enumKey.本人概況_體重.ToString()) _udtSdDg02 = data; } List<UDTMultipleRecordDef> MultipleRecordList = UDTTransfer.ABUDTMultipleRecordSelectByStudentIDList(_StudenIDList); foreach (UDTMultipleRecordDef data in MultipleRecordList) { if (data.Key == enumKey.本人概況_生理缺陷.ToString()) if (!_udtMrFlp01Dict.ContainsKey(data.Data)) _udtMrFlp01Dict.Add(data.Data, data); if (data.Key == enumKey.本人概況_曾患特殊疾病.ToString()) if (!_udtMrFlp02Dict.ContainsKey(data.Data)) _udtMrFlp02Dict.Add(data.Data, data); } }
private void SaveAnswerToUDT() { List<UDTSingleRecordDef> iDataList = new List<UDTSingleRecordDef>(); List<UDTSingleRecordDef> uDataList = new List<UDTSingleRecordDef>(); List<UDTSemesterDataDef> isDataList = new List<UDTSemesterDataDef>(); List<UDTSemesterDataDef> usDataList = new List<UDTSemesterDataDef>(); // 血型 if (_udtSrFlp01 == null) { _udtSrFlp01 = new UDTSingleRecordDef(); _udtSrFlp01.StudentID = _intStudentID; } _udtSrFlp01.Key = enumKey.本人概況_血型.ToString(); foreach (Control c in flp01.Controls) { if (c is RadioButton) { _udtSrFlp01.Remark = ""; RadioButton rb = c as RadioButton; if (rb.Checked) { _udtSrFlp01.Data = rb.Name; foreach(Control cr in flp01.Controls) if (cr is TextBox) if (cr.Name == rb.Name) _udtSrFlp01.Remark = cr.Text; } } } if (string.IsNullOrEmpty(_udtSrFlp01.UID)) iDataList.Add(_udtSrFlp01); else uDataList.Add(_udtSrFlp01); // 宗教 if (_udtSrFlp02 == null) { _udtSrFlp02 = new UDTSingleRecordDef(); _udtSrFlp02.StudentID = _intStudentID; } _udtSrFlp02.Key = enumKey.本人概況_宗教.ToString(); foreach (Control c in flp02.Controls) { if (c is RadioButton) { _udtSrFlp02.Remark = ""; RadioButton rb = c as RadioButton; if (rb.Checked) { _udtSrFlp02.Data = rb.Name; foreach (Control cr in flp02.Controls) if (cr is TextBox) if (cr.Name == rb.Name) _udtSrFlp02.Remark = cr.Text; } } } if (string.IsNullOrEmpty(_udtSrFlp02.UID)) iDataList.Add(_udtSrFlp02); else uDataList.Add(_udtSrFlp02); if (iDataList.Count > 0) UDTTransfer.ABUDTSingleRecordInsert(iDataList); if (uDataList.Count > 0) UDTTransfer.ABUDTSingleRecordUpdate(uDataList); // 寫入 身高 if (_udtSdDg01 == null) { _udtSdDg01 = new UDTSemesterDataDef(); _udtSdDg01.StudentID = _intStudentID; _udtSdDg01.Key = enumKey.本人概況_身高.ToString(); } List<string> tmpData1 = new List<string>(); for (int i = 1; i <= 12; i++) { if (dg01.Rows[_Dg01RowIdx].Cells[i].Value != null) tmpData1.Add(dg01.Rows[_Dg01RowIdx].Cells[i].Value.ToString()); else tmpData1.Add(""); } _udtSdDg01.S1a = tmpData1[0]; _udtSdDg01.S1b = tmpData1[1]; _udtSdDg01.S2a = tmpData1[2]; _udtSdDg01.S2b = tmpData1[3]; _udtSdDg01.S3a = tmpData1[4]; _udtSdDg01.S3b = tmpData1[5]; _udtSdDg01.S4a = tmpData1[6]; _udtSdDg01.S4b = tmpData1[7]; _udtSdDg01.S5a = tmpData1[8]; _udtSdDg01.S5b = tmpData1[9]; _udtSdDg01.S6a = tmpData1[10]; _udtSdDg01.S6b = tmpData1[11]; if (string.IsNullOrEmpty(_udtSdDg01.UID)) isDataList.Add(_udtSdDg01); else usDataList.Add(_udtSdDg01); // 體重 if (_udtSdDg02 == null) { _udtSdDg02 = new UDTSemesterDataDef(); _udtSdDg02.StudentID = _intStudentID; _udtSdDg02.Key = enumKey.本人概況_體重.ToString(); } List<string> tmpData2 = new List<string>(); for (int i = 1; i <= 12; i++) { if (dg01.Rows[_Dg02RowIdx].Cells[i].Value != null) tmpData2.Add(dg01.Rows[_Dg02RowIdx].Cells[i].Value.ToString()); else tmpData2.Add(""); } _udtSdDg02.S1a = tmpData2[0]; _udtSdDg02.S1b = tmpData2[1]; _udtSdDg02.S2a = tmpData2[2]; _udtSdDg02.S2b = tmpData2[3]; _udtSdDg02.S3a = tmpData2[4]; _udtSdDg02.S3b = tmpData2[5]; _udtSdDg02.S4a = tmpData2[6]; _udtSdDg02.S4b = tmpData2[7]; _udtSdDg02.S5a = tmpData2[8]; _udtSdDg02.S5b = tmpData2[9]; _udtSdDg02.S6a = tmpData2[10]; _udtSdDg02.S6b = tmpData2[11]; if (string.IsNullOrEmpty(_udtSdDg02.UID)) isDataList.Add(_udtSdDg02); else usDataList.Add(_udtSdDg02); if (isDataList.Count > 0) UDTTransfer.ABUDTSemesterDataInsert(isDataList); if (usDataList.Count > 0) UDTTransfer.ABUDTSemesterDataUpdate(usDataList); List<UDTMultipleRecordDef> delData = new List<UDTMultipleRecordDef>(); List<UDTMultipleRecordDef> InsertData = new List<UDTMultipleRecordDef>(); delData = _udtMrFlp01Dict.Values.ToList(); if (delData.Count > 0) UDTTransfer.ABUDTMultipleRecordDelete(delData); foreach (Control c in flp03.Controls) { if (c is CheckBox) { CheckBox cb = c as CheckBox; if (cb.Checked) { UDTMultipleRecordDef data = new UDTMultipleRecordDef(); data.StudentID = _intStudentID; data.Key = enumKey.本人概況_生理缺陷.ToString(); data.Data = cb.Name; data.Remark = ""; foreach (Control cr in flp03.Controls) if (cr is TextBox) if (cr.Name == cb.Name) data.Remark = cr.Text; InsertData.Add(data); } } } if (InsertData.Count > 0) UDTTransfer.ABUDTMultipleRecordInsert(InsertData); delData.Clear(); InsertData.Clear(); delData = _udtMrFlp02Dict.Values.ToList(); if (delData.Count > 0) UDTTransfer.ABUDTMultipleRecordDelete(delData); foreach (Control c in flp04.Controls) { if (c is CheckBox) { CheckBox cb = c as CheckBox; if (cb.Checked) { UDTMultipleRecordDef data = new UDTMultipleRecordDef(); data.StudentID = _intStudentID; data.Key = enumKey.本人概況_曾患特殊疾病.ToString(); data.Data = cb.Name; data.Remark = ""; foreach (Control cr in flp04.Controls) if (cr is TextBox) if (cr.Name == cb.Name) data.Remark = cr.Text; InsertData.Add(data); } } } if (InsertData.Count > 0) UDTTransfer.ABUDTMultipleRecordInsert(InsertData); }
void _bgWorker_DoWork(object sender, DoWorkEventArgs e) { if (_reloadQuestion) _QuestionDataDict = _QDMang.GetQuestionDataByGroupName(GroupName); _YearlyDataDict.Clear(); foreach (UDTYearlyDataDef data in UDTTransfer.ABUDTYearlyDataSelectByStudentIDList(_StudentIDList)) { if (_ColumIndexDict.ContainsKey(data.Key)) if (!_YearlyDataDict.ContainsKey(data.Key)) _YearlyDataDict.Add(data.Key, data); } // 檢查資料是否完整,沒有資料補資料 foreach (string str in _ColumIndexDict.Keys) { if (!_YearlyDataDict.ContainsKey(str)) { UDTYearlyDataDef data = new UDTYearlyDataDef(); data.Key = str; data.StudentID = _intStudentID; data.G1 = data.G2 = data.G3 = data.G4 = data.G5 = data.G6 = ""; _YearlyDataDict.Add(str, data); } } // 社團與班級幹部 _SemesterDataDict.Clear(); foreach (UDTSemesterDataDef data in UDTTransfer.ABUDTSemesterDataSelectByStudentIDList(_StudentIDList)) { if (_SemesterDataKeyList.Contains(data.Key)) if (!_SemesterDataDict.ContainsKey(data.Key)) _SemesterDataDict.Add(data.Key, data); } // 初始值檢查,沒有建立初始值 foreach (string str in _SemesterDataKeyList) { if (!_SemesterDataDict.ContainsKey(str)) { UDTSemesterDataDef data1 = new UDTSemesterDataDef(); data1.Key = str; data1.StudentID = _intStudentID; data1.S1a = data1.S1b = data1.S2a = data1.S2b = data1.S3a = data1.S3b = data1.S4a = data1.S4b = data1.S5a = data1.S5b = data1.S6a = data1.S6b = ""; _SemesterDataDict.Add(str, data1); } } }