void _bgWorkerM_DoWork(object sender, DoWorkEventArgs e)
{
if (_reloadQuestion)
{
_QuestionDict = _QDMang.GetQuestionDataByGroupName(GroupName);
}
_dataMDict.Clear();
foreach (UDTMultipleRecordDef data in UDTTransfer.ABUDTMultipleRecordSelectByStudentIDList(_StudentIDList))
{
if (data.Key.Contains(GroupName))
{
string key = data.Key + "_" + data.Data;
if (!_dataMDict.ContainsKey(key))
{
_dataMDict.Add(key, data);
}
}
}
_PriorityData1 = null;
_PriorityData2 = null;
string key1 = GroupName + "_" + _keyName5;
string key2 = GroupName + "_" + _keyName6;
foreach (UDTPriorityDataDef data in UDTTransfer.ABUDTPriorityDataSelectByStudentIDList(_StudentIDList))
{
if (data.Key.Contains(GroupName))
{
if (key1 == data.Key)
{
_PriorityData1 = data;
}
if (key2 == data.Key)
{
_PriorityData2 = data;
}
}
}
}
public StudABCard07Content()
{
InitializeComponent();
this.Group = "綜合表現紀錄表-畢業後計畫";
_StudentIDList = new List <string>();
_KeyNameList = new List <string>();
_KeyNameList.Add(_keyName1);
_KeyNameList.Add(_keyName2);
_KeyNameList.Add(_keyName3);
_KeyNameList.Add(_keyName4);
_KeyNameList.Add(_keyName5);
_KeyNameList.Add(_keyName6);
_flpList = new List <FlowLayoutPanel>();
_flpList.Add(flp1);
_flpList.Add(flp2);
_flpList.Add(flp3);
_flpList.Add(flp4);
_QDMang = new ABCardQuestionDataManager();
_PriorityData1 = new UDTPriorityDataDef();
_PriorityData2 = new UDTPriorityDataDef();
_QuestionDict = _QDMang.GetQuestionDataByGroupName(GroupName);
_dataMDict = new Dictionary <string, UDTMultipleRecordDef>();
_dataPDict = new Dictionary <string, UDTPriorityDataDef>();
_insertPriorityDataList = new List <UDTPriorityDataDef>();
_InsertMultipleRecordDict = new Dictionary <string, UDTMultipleRecordDef>();
_updatePriorityDataList = new List <UDTPriorityDataDef>();
_deleteMultipleRecordList = new List <UDTMultipleRecordDef>();
_ChangeListener.StatusChanged += new EventHandler <ChangeEventArgs>(_ChangeListener_StatusChanged);
_ChangeListener.Add(new DataGridViewSource(dgPriority));
LoadQuestionToUI();
EventHub.CounselChanged += new EventHandler(EventHub_CounselChanged);
_bgWorkerM = new BackgroundWorker();
_bgWorkerM.DoWork += new DoWorkEventHandler(_bgWorkerM_DoWork);
_bgWorkerM.RunWorkerCompleted += new RunWorkerCompletedEventHandler(_bgWorkerM_RunWorkerCompleted);
}
/// <summary>
/// 設定儲存資料
/// </summary>
private void SetData()
{
// 刪除舊資料
_deleteMultipleRecordList = _dataMDict.Values.ToList();
UDTTransfer.ABUDTMultipleRecordDelete(_deleteMultipleRecordList);
_InsertMultipleRecordDict.Clear();
// 儲存資料
for (int idx = 0; idx < 4; idx++)
{
FlowLayoutPanel flp = _flpList[idx];
string KeyName = _KeyNameList[idx];
foreach (Control cr in flp.Controls)
{
if (cr is CheckBox)
{
CheckBox cb = cr as CheckBox;
if (cb.Checked)
{
UDTMultipleRecordDef data1 = new UDTMultipleRecordDef();
data1.StudentID = _intStudentID;
data1.Key = GroupName + "_" + KeyName;
data1.Data = cb.Name;
data1.Remark = "";
// 處理備註資料
foreach (Control t in flp.Controls)
{
if (t is TextBox)
{
if (t.Name == cb.Name)
{
data1.Remark = t.Text;
}
}
}
string insertKey = data1.Key + "_" + cb.Name;
if (!_InsertMultipleRecordDict.ContainsKey(insertKey))
{
_InsertMultipleRecordDict.Add(insertKey, data1);
}
}
}
}
}
// 新增至 UDT
if (_InsertMultipleRecordDict.Count > 0)
{
UDTTransfer.ABUDTMultipleRecordInsert(_InsertMultipleRecordDict.Values.ToList());
}
// 讀存資料
List <UDTPriorityDataDef> insertData = new List <UDTPriorityDataDef>();
List <UDTPriorityDataDef> updateData = new List <UDTPriorityDataDef>();
// 將來就業
UDTPriorityDataDef p1 = dgPriority.Columns[1].Tag as UDTPriorityDataDef;
if (p1 == null)
{
p1 = new UDTPriorityDataDef();
p1.Key = GroupName + "_" + _keyName5;
p1.StudentID = _intStudentID;
}
if (dgPriority.Rows[0].Cells[1].Value != null)
{
p1.P1 = dgPriority.Rows[0].Cells[1].Value.ToString();
}
else
{
p1.P1 = "";
}
if (dgPriority.Rows[1].Cells[1].Value != null)
{
p1.P2 = dgPriority.Rows[1].Cells[1].Value.ToString();
}
else
{
p1.P2 = "";
}
if (dgPriority.Rows[2].Cells[1].Value != null)
{
p1.P3 = dgPriority.Rows[2].Cells[1].Value.ToString();
}
else
{
p1.P3 = "";
}
if (string.IsNullOrEmpty(p1.UID))
{
insertData.Add(p1);
}
else
{
updateData.Add(p1);
}
// 就業地區
UDTPriorityDataDef p2 = dgPriority.Columns[2].Tag as UDTPriorityDataDef;
if (p2 == null)
{
p2 = new UDTPriorityDataDef();
p2.Key = GroupName + "_" + _keyName6;
p2.StudentID = _intStudentID;
}
if (dgPriority.Rows[0].Cells[2].Value != null)
{
p2.P1 = dgPriority.Rows[0].Cells[2].Value.ToString();
}
else
{
p2.P1 = "";
}
if (dgPriority.Rows[1].Cells[2].Value != null)
{
p2.P2 = dgPriority.Rows[1].Cells[2].Value.ToString();
}
else
{
p2.P2 = "";
}
if (dgPriority.Rows[2].Cells[2].Value != null)
{
p2.P3 = dgPriority.Rows[2].Cells[2].Value.ToString();
}
else
{
p2.P3 = "";
}
if (string.IsNullOrEmpty(p2.UID))
{
insertData.Add(p2);
}
else
{
updateData.Add(p2);
}
if (insertData.Count > 0)
{
UDTTransfer.ABUDTPriorityDataInsert(insertData);
}
if (updateData.Count > 0)
{
UDTTransfer.ABUDTPriorityDataUpdate(updateData);
}
}
public StudABCard_PriorityForm_Combo(UDTPriorityDataDef Data)
{
InitializeComponent();
_data = Data;
}
