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); } } }
// 取得資料 private string GetItemString(UDTYearlyDataDef data) { string retVal = ""; switch (_GradeYear) { case 1: retVal = data.G1; break; case 2: retVal = data.G2; break; case 3: retVal = data.G3; break; case 4: retVal = data.G4; break; case 5: retVal = data.G5; break; case 6: retVal = data.G6; break; } return(retVal); }
public StudABCard_YearlyForm_TextDropDown(UDTYearlyDataDef data) { InitializeComponent(); _data = data; _TextBoxDropDownDic = new Dictionary <string, TextBoxDropDown>(); foreach (Control cr in this.panelEx1.Controls) { if (cr is TextBoxDropDown) { TextBoxDropDown dd = cr as TextBoxDropDown; _TextBoxDropDownDic.Add(cr.Name, dd); } } foreach (string key in _TextBoxDropDownDic.Keys) { CheckedListBox itm = new CheckedListBox(); itm.Name = key; itm.LostFocus += new EventHandler(itm_LostFocus); _CheckList.Add(itm); } }
public StudABCard_YearlyForm_Text(UDTYearlyDataDef data) { InitializeComponent(); _data = data; }
private void SetData() { _insertDataList.Clear(); _updateDataList.Clear(); foreach (DataGridViewColumn drc in dgData.Columns) { string key = GroupName + "_" + drc.HeaderText; if (_ColumIndexDict.ContainsKey(key)) { UDTYearlyDataDef data = drc.Tag as UDTYearlyDataDef; if (data == null) { data = new UDTYearlyDataDef(); data.StudentID = _intStudentID; } data.Key = key; foreach (KeyValuePair <string, int> rowDa in _RowIndexDict) { if (rowDa.Key == "一年級") { if (dgData.Rows[rowDa.Value].Cells[drc.Index].Value != null) { data.G1 = dgData.Rows[rowDa.Value].Cells[drc.Index].Value.ToString(); } else { data.G1 = ""; } } if (rowDa.Key == "二年級") { if (dgData.Rows[rowDa.Value].Cells[drc.Index].Value != null) { data.G2 = dgData.Rows[rowDa.Value].Cells[drc.Index].Value.ToString(); } else { data.G2 = ""; } } if (rowDa.Key == "三年級") { if (dgData.Rows[rowDa.Value].Cells[drc.Index].Value != null) { data.G3 = dgData.Rows[rowDa.Value].Cells[drc.Index].Value.ToString(); } else { data.G3 = ""; } } if (rowDa.Key == "四年級") { if (dgData.Rows[rowDa.Value].Cells[drc.Index].Value != null) { data.G4 = dgData.Rows[rowDa.Value].Cells[drc.Index].Value.ToString(); } else { data.G4 = ""; } } if (rowDa.Key == "五年級") { if (dgData.Rows[rowDa.Value].Cells[drc.Index].Value != null) { data.G5 = dgData.Rows[rowDa.Value].Cells[drc.Index].Value.ToString(); } else { data.G5 = ""; } } if (rowDa.Key == "六年級") { if (dgData.Rows[rowDa.Value].Cells[drc.Index].Value != null) { data.G6 = dgData.Rows[rowDa.Value].Cells[drc.Index].Value.ToString(); } else { data.G6 = ""; } } } if (string.IsNullOrEmpty(data.UID)) { _insertDataList.Add(data); } else { _updateDataList.Add(data); } } } }
/// <summary> /// 儲存其它資料 /// </summary> private void SaveYearlyData() { List <UDTYearlyDataDef> insertDataList = new List <UDTYearlyDataDef>(); List <UDTYearlyDataDef> updateDataList = new List <UDTYearlyDataDef>(); foreach (DataGridViewColumn drc in dgYearly.Columns) { string name = drc.HeaderText.Replace("(元)", ""); string key = GroupName + "_" + name; if (_ColumIndexDict.ContainsKey(key)) { UDTYearlyDataDef data = drc.Tag as UDTYearlyDataDef; if (data == null) { data = new UDTYearlyDataDef(); data.StudentID = _intStudentID; } data.Key = key; foreach (KeyValuePair <string, int> rowDa in _RowIndexDict) { if (rowDa.Key == "一年級") { if (dgYearly.Rows[rowDa.Value].Cells[drc.Index].Value != null) { data.G1 = dgYearly.Rows[rowDa.Value].Cells[drc.Index].Value.ToString(); } else { data.G1 = ""; } } if (rowDa.Key == "二年級") { if (dgYearly.Rows[rowDa.Value].Cells[drc.Index].Value != null) { data.G2 = dgYearly.Rows[rowDa.Value].Cells[drc.Index].Value.ToString(); } else { data.G2 = ""; } } if (rowDa.Key == "三年級") { if (dgYearly.Rows[rowDa.Value].Cells[drc.Index].Value != null) { data.G3 = dgYearly.Rows[rowDa.Value].Cells[drc.Index].Value.ToString(); } else { data.G3 = ""; } } if (rowDa.Key == "四年級") { if (dgYearly.Rows[rowDa.Value].Cells[drc.Index].Value != null) { data.G4 = dgYearly.Rows[rowDa.Value].Cells[drc.Index].Value.ToString(); } else { data.G4 = ""; } } if (rowDa.Key == "五年級") { if (dgYearly.Rows[rowDa.Value].Cells[drc.Index].Value != null) { data.G5 = dgYearly.Rows[rowDa.Value].Cells[drc.Index].Value.ToString(); } else { data.G5 = ""; } } if (rowDa.Key == "六年級") { if (dgYearly.Rows[rowDa.Value].Cells[drc.Index].Value != null) { data.G6 = dgYearly.Rows[rowDa.Value].Cells[drc.Index].Value.ToString(); } else { data.G6 = ""; } } } if (string.IsNullOrEmpty(data.UID)) { insertDataList.Add(data); } else { updateDataList.Add(data); } } } if (insertDataList.Count > 0) { UDTTransfer.ABUDTYearlyDataInsert(insertDataList); } if (updateDataList.Count > 0) { UDTTransfer.ABUDTYearlyDataUpdate(updateDataList); } }