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);
}
}
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);
}
}
}
public StudABCard_YearlyForm_Combo(UDTYearlyDataDef data)
{
InitializeComponent();
_data = data;
}
/// <summary>
/// 報表用解析輔導綜合紀錄學年型
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public static string Counsel_Yearly_Parse2(UDTYearlyDataDef data,int gr)
{
string retVal = "";
if (data != null)
{
if (gr==1 && !string.IsNullOrWhiteSpace(data.G1))
retVal= data.G1;
if (gr==2 && !string.IsNullOrWhiteSpace(data.G2))
retVal= data.G2;
if (gr==3 && !string.IsNullOrWhiteSpace(data.G3))
retVal= data.G3;
if (gr==4 && !string.IsNullOrWhiteSpace(data.G4))
retVal= data.G4;
if (gr==5 && !string.IsNullOrWhiteSpace(data.G5))
retVal= data.G5;
if (gr==6 && !string.IsNullOrWhiteSpace(data.G6))
retVal= data.G6;
}
return retVal;
}
/// <summary>
/// 報表用解析輔導綜合紀錄學年型 一：；二：；..
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public static string Counsel_Yearly_Parse1(UDTYearlyDataDef data)
{
List<string> retVal = new List<string>();
if (data != null)
{
if (!string.IsNullOrWhiteSpace(data.G1))
retVal.Add("一："+data.G1);
if (!string.IsNullOrWhiteSpace(data.G2))
retVal.Add("二："+data.G2);
if (!string.IsNullOrWhiteSpace(data.G3))
retVal.Add("三："+data.G3);
if (!string.IsNullOrWhiteSpace(data.G4))
retVal.Add("四："+data.G4);
if (!string.IsNullOrWhiteSpace(data.G5))
retVal.Add("五："+data.G5);
if (!string.IsNullOrWhiteSpace(data.G6))
retVal.Add("六："+data.G6);
}
return string.Join("；", retVal.ToArray());
}
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;
}
/// <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);
}