void _bgWorkerLoad_DoWork(object sender, DoWorkEventArgs e)
{
// 取得學生類別
_StudentTagList = QueryTransfer.GetStudentTagList();
_SelectMappingDict1 = GetExcessCreditsBase1();
_SelectMappingDict2 = GetExcessCreditsBase2();
_SelectMappingDict3 = GetExcessCreditsBase3();
// 取得設定檔
_UDTConfigList = UDTTransfer.UDTConfigSelectByName(conf_name);
if (_UDTConfigList.Count > 0)
{
UDTConfig cd = _UDTConfigList[0];
if (!string.IsNullOrWhiteSpace(cd.Data))
{
try
{
_ConfigXML = XElement.Parse(cd.Data);
}
catch
{
}
}
}
}
/// <summary>
/// 取得學生綜合表現答案
/// </summary>
/// <param name="StudentIDList"></param>
private void GetStudentABCardAnswerDict(List <string> StudentIDList)
{
_AnswerDict.Clear();
// 取得學生綜合表現答案
List <UDT_ABCardDataDef> ABCardDataList = UDTTransfer.GetABCardDataListByStudentList(StudentIDList);
foreach (string str in StudentIDList)
{
int id = int.Parse(str);
List <AnswerPkey> dataList = new List <AnswerPkey>();
foreach (UDT_ABCardDataDef data in ABCardDataList.Where(x => x.StudentID == id))
{
XElement ansElmRoot = XElement.Parse(data.Content);
foreach (XElement elm in ansElmRoot.Elements("Ans"))
{
AnswerPkey apk = new AnswerPkey();
apk.dataElement = elm;
apk.Label = data.SubjectName;
apk.Name = elm.Attribute("name").Value;
apk.StudentID = id;
apk.TemplateID = data.TemplateID;
dataList.Add(apk);
}
}
if (dataList.Count > 0)
{
_AnswerDict.Add(str, dataList);
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (DateTimeParse())
{
if (!Compare())
{
//刪掉原有資料
UDTTransfer.UDTEnrolmntExcessInputDateDelete(_EnrolmentExcessInputDateList);
List <UDT_EnrolmentExcessInputDate> list = new List <UDT_EnrolmentExcessInputDate>();
UDT_EnrolmentExcessInputDate each = new UDT_EnrolmentExcessInputDate();
each.StartDate = DateTime.Parse(tbStartDateTime.Text);
each.EndDate = DateTime.Parse(tbEndDateTime.Text);
list.Add(each);
// 新增資料
UDTTransfer.UDTEnrolmentExcessInputDateInsert(list);
MsgBox.Show("儲存成功!!");
this.Close();
}
else
{
MsgBox.Show("[結束時間]不可小於[開始時間]!!");
return;
}
}
else
{
MsgBox.Show("請輸入正確資料\n再進行儲存動作!!");
return;
}
}
public override void InitializeExport(SmartSchool.API.PlugIn.Export.ExportWizard wizard)
{
wizard.ExportableFields.AddRange(ExportItemList);
wizard.ExportPackage += delegate(object sender, SmartSchool.API.PlugIn.Export.ExportPackageEventArgs e)
{
int RowCount = 0;
foreach (DAL.UserDefData udd in UDTTransfer.GetDataFromUDT(e.List))
{
RowData row = new RowData();
row.ID = udd.RefID;
foreach (string field in e.ExportFields)
{
if (wizard.ExportableFields.Contains(field))
{
switch (field)
{
case "欄位名稱": row.Add(field, udd.FieldName); break;
case "值": row.Add(field, udd.Value); break;
}
}
}
RowCount++;
e.Items.Add(row);
}
};
}
private void btnReset_Click(object sender, EventArgs e)
{
if (FISCA.Presentation.Controls.MsgBox.Show("將清除所有題目與選項恢復到系統預設值，執行後請重新登入系統，請問確認執行?", "清空題目", MessageBoxButtons.YesNo, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) == System.Windows.Forms.DialogResult.Yes)
{
List <UDTQuestionsDataDef> list = UDTTransfer.ABUDTQuestionsDataSelectAll();
UDTTransfer.ABUDTQuestionsDataDelete(list);
}
}
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);
}
}
}
public StudentInfoTransfer()
{
_StudentInfoList = new List <StudentInfo>();
_StudentHistoryDict = new Dictionary <string, List <SchoolYearSemester> >();
_updateRecList = new List <UpdateRecordRecord>();
_StudQuizDataDefList = new List <UDT_StudQuizDataDef>();
_UDTTransfer = new UDTTransfer();
_QuizDef = new List <UDT_QuizDef>();
}
private void ClearAll()
{
List <UDTQuestionsDataDef> delData = new List <UDTQuestionsDataDef>();
foreach (QuestionData qd in _QuestionDataList)
{
delData.Add(qd.GetUpdateData());
}
UDTTransfer.ABUDTQuestionsDataDelete(delData);
}
private void InsertUDT(List <QuestionData> dataList)
{
List <UDTQuestionsDataDef> newData = new List <UDTQuestionsDataDef>();
foreach (QuestionData qd in dataList)
{
newData.Add(qd.GetUpdateData());
}
UDTTransfer.ABUDTQuestionsDataInsert(newData);
}
void _bgWorker_DoWork(object sender, DoWorkEventArgs e)
{
_data = null;
foreach (UDTSingleRecordDef data in UDTTransfer.ABUDTSingleRecordSelectByStudentIDList(_StudentIDList))
{
if (data.Key.Contains(GroupName) || data.Key.Contains((NewKey)))
{
_data = data;
}
}
}
static void _bgLLoadUDT_DoWork(object sender, DoWorkEventArgs e)
{
UDTTransfer.CreateUDTTable();
#region 自訂驗證規則
FactoryProvider.FieldFactory.Add(new FieldValidatorFactory());
#endregion
#region 加入自動加入班級類別
List <string> nameList = new List <string> ();
nameList.Add("普通班");
nameList.Add("體育班");
nameList.Add("美術班");
nameList.Add("音樂班");
nameList.Add("舞蹈班");
nameList.Add("資優班");
nameList.Add("資源班");
nameList.Add("特教班");
nameList.Add("技藝專班");
nameList.Add("機構式非學校自學班");
// 取得班級分類
List <TagConfigRecord> TagRecList = TagConfig.SelectByCategory(TagCategory.Class);
List <TagConfigRecord> AddTagRecList = new List <TagConfigRecord>();
List <string> hasNameList = new List <string>();
foreach (TagConfigRecord rec in TagRecList)
{
if (rec.Prefix == "班級分類")
{
hasNameList.Add(rec.Name);
}
}
// 檢查是否新增
foreach (string name in nameList)
{
if (!hasNameList.Contains(name))
{
TagConfigRecord rec = new TagConfigRecord();
rec.Name = name;
rec.Prefix = "班級分類";
rec.Category = "Class";
AddTagRecList.Add(rec);
}
}
if (AddTagRecList.Count > 0)
{
TagConfig.Insert(AddTagRecList);
}
#endregion
}
public ABCardPrintManager()
{
_DataDict = new Dictionary <string, string>();
_MappingField = new List <string>();
_ABCardTemplateDict = new Dictionary <int, UDT_ABCardTemplateDefinitionDef>();
_AnswerDict = new Dictionary <string, List <AnswerPkey> >();
foreach (UDT_ABCardTemplateDefinitionDef data in UDTTransfer.GetABCardTemplate())
{
_ABCardTemplateDict.Add(int.Parse(data.UID), data);
}
}
/// <summary>
/// 建構子
/// </summary>
/// <param name="type"></param>
public StudInterviewDataReportForm(SelectType type)
{
InitializeComponent();
_UDTTransfer = new UDTTransfer();
_studIDList = new List <string>();
_TeacherIDList = new List <string>();
_studDataDict = new Dictionary <string, StudentRecord>();
_bgWorker = new BackgroundWorker();
_dataDictList = new List <Dictionary <string, string> >();
_UserSelectType = type;
_bgWorker.DoWork += new DoWorkEventHandler(_bgWorker_DoWork);
_bgWorker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(_bgWorker_RunWorkerCompleted);
}
/// <summary>
/// 取得項目
/// </summary>
/// <param name="name"></param>
/// <param name="itmType"></param>
/// <returns></returns>
public List <string> GetItemList(ItemType itmType)
{
List <string> retVal = new List <string>();
UDT_SystemListDef data = UDTTransfer.GetSystemListByName(itmType.ToString());
XElement elmData = XElement.Parse(data.Content);
if (elmData != null)
{
retVal = (from elm in elmData.Elements("item") select elm.Attribute("name").Value).ToList();
}
return(retVal);
}
private void btnSave_Click(object sender, EventArgs e)
{
if (_QuestionData != null)
{
_QuestionData.ControlType = cbxControlType.Text;
_QuestionData.QuestionType = cbxQuestionType.Text;
_QuestionData.DisplayOrder = intDisplayOrder.Value;
_QuestionData.CanPrint = chkCanPrint.Checked;
_QuestionData.CanStudentEdit = chkCanStudentEdit.Checked;
_QuestionData.CanTeacherEdit = chkCanTeacherEdit.Checked;
if (dgItems.Rows.Count > 0)
{
List <QuestionItem> qiList = new List <QuestionItem>();
foreach (DataGridViewRow drv in dgItems.Rows)
{
if (drv.IsNewRow)
{
continue;
}
bool hasR = false;
if (drv.Cells[colHasRemark.Index].Value != null)
{
hasR = bool.Parse(drv.Cells[colHasRemark.Index].Value.ToString());
}
QuestionItem qi;
string key = drv.Cells[colName.Index].Value.ToString();
if (hasR)
{
qi = new QuestionItem(key, hasR);
}
else
{
qi = new QuestionItem(key);
}
qiList.Add(qi);
}
_QuestionData.itemList = qiList;
}
List <UDTQuestionsDataDef> data = new List <UDTQuestionsDataDef>();
data.Add(_QuestionData.GetUpdateData());
UDTTransfer.ABUDTQuestionsDataUpdate(data);
// 呼叫同步
EventHub.OnCounselChanged();
FISCA.Presentation.Controls.MsgBox.Show("儲存完成!");
}
}
public static void Main()
{
_bgLLoadUDT.DoWork += _bgLLoadUDT_DoWork;
_bgLLoadUDT.RunWorkerCompleted += _bgLLoadUDT_RunWorkerCompleted;
_bgLLoadUDT.RunWorkerAsync();
Dictionary <string, UDT_HighConcern> _HighConcernDict = new Dictionary <string, UDT_HighConcern>();
_HighConcernDict = UDTTransfer.GetHighConcernDictAll();
ListPaneField HighConcernField = new ListPaneField("高關懷特殊身分");
HighConcernField.GetVariable += delegate(object sender, GetVariableEventArgs e)
{
if (_HighConcernDict.ContainsKey(e.Key))
{
e.Value = "是";
}
};
K12.Presentation.NLDPanels.Student.AddListPaneField(HighConcernField);
ListPaneField HighCountField = new ListPaneField("高關懷減免人數");
HighCountField.GetVariable += delegate(object sender, GetVariableEventArgs e)
{
if (_HighConcernDict.ContainsKey(e.Key))
{
e.Value = _HighConcernDict[e.Key].NumberReduce;
}
};
K12.Presentation.NLDPanels.Student.AddListPaneField(HighCountField);
ListPaneField HighDocNoField = new ListPaneField("高關懷文號");
HighDocNoField.GetVariable += delegate(object sender, GetVariableEventArgs e)
{
if (_HighConcernDict.ContainsKey(e.Key))
{
e.Value = _HighConcernDict[e.Key].DocNo;
}
};
K12.Presentation.NLDPanels.Student.AddListPaneField(HighDocNoField);
// 當高關懷特殊身分有更新
FISCA.InteractionService.SubscribeEvent("KH_HighConcern_HighConcernContent", (sender, args) =>
{
_HighConcernDict = UDTTransfer.GetHighConcernDictAll();
HighConcernField.Reload();
HighCountField.Reload();
HighDocNoField.Reload();
});
}
void _bgWorker_DoWork(object sender, DoWorkEventArgs e)
{
_dataDict.Clear();
foreach (UDTSingleRecordDef data in UDTTransfer.ABUDTSingleRecordSelectByStudentIDList(_StudentIDList))
{
if (data.Key.Contains(GroupName))
{
if (!_dataDict.ContainsKey(data.Key))
{
_dataDict.Add(data.Key, data);
}
}
}
}
void _bgWorker_DoWork(object sender, DoWorkEventArgs e)
{
LoadQuestion();
_UDTSingleRecordDict.Clear();
string key = GroupName + "_監護人_";
// 讀取資料
foreach (UDTSingleRecordDef data in UDTTransfer.ABUDTSingleRecordSelectByStudentIDList(_StudentIDList))
{
// 監護人
if (data.Key.Contains(key))
{
string newkey = data.Key.Replace(key, "");
if (!_UDTSingleRecordDict.ContainsKey(newkey))
{
_UDTSingleRecordDict.Add(newkey, data);
}
}
// 兄弟姊妹排行
if (data.Key.Contains(KeySiblingNoStr))
{
if (!_UDTSingleRecordDict.ContainsKey(KeySiblingNoStr))
{
_UDTSingleRecordDict.Add(KeySiblingNoStr, data);
}
}
}
_UDTYearlyDataDict.Clear();
string key1 = GroupName + "_";
foreach (UDTYearlyDataDef data in UDTTransfer.ABUDTYearlyDataSelectByStudentIDList(_StudentIDList))
{
if (data.Key.Contains(key1))
{
if (!_UDTYearlyDataDict.ContainsKey(data.Key))
{
_UDTYearlyDataDict.Add(data.Key, data);
}
}
}
_UDTSiblingList = UDTTransfer.ABUDTSiblingSelectByStudentIDList(_StudentIDList);
_UDTRelativeList = UDTTransfer.ABUDTRelativeSelectByStudentIDList(_StudentIDList);
}
/// <summary>
/// 取得國籍中英文對照,回傳中文,英文
/// </summary>
/// <returns></returns>
public static Dictionary <string, string> GetNationalityMappingDict()
{
Dictionary <string, string> retVal = new Dictionary <string, string>();
List <UDT_NationalityMapping> dataList = UDTTransfer.UDTNationalityMappingSelectAll();
foreach (UDT_NationalityMapping data in dataList)
{
if (!retVal.ContainsKey(data.Name))
{
retVal.Add(data.Name, data.Eng_Name);
}
}
return(retVal);
}
/// <summary>
/// 匯入前準備
/// </summary>
/// <param name="Option"></param>
public override void Prepare(ImportOption Option)
{
_Option = Option;
_HighConcernDict = UDTTransfer.GetHighConcernDictAll();
_StudentNumIDDict = UDTTransfer.GetStudentNumIDDictAll();
// 取得學生資料
List <string> studentIDList = _StudentNumIDDict.Values.ToList();
List <StudentRecord> recList = Student.SelectByIDs(studentIDList);
foreach (StudentRecord rec in recList)
{
_StudentRecDict.Add(rec.ID, rec);
}
}
private void FillTimes()
{
_EnrolmentExcessInputDateList = UDTTransfer.UDTEnrolmentExcessInputDateSelect();
if (_EnrolmentExcessInputDateList.Count >= 1)
{
UDT_EnrolmentExcessInputDate each = _EnrolmentExcessInputDateList[0];
string startTime = each.StartDate.HasValue ? each.StartDate.Value.ToString(DateTimeFormat) : "";
string endTime = each.EndDate.HasValue ? each.EndDate.Value.ToString(DateTimeFormat) : "";
tbStartDateTime.Text = startTime;
tbEndDateTime.Text = endTime;
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
if (lvData.SelectedItems.Count == 1)
{
// 傳入資料
Forms.StudABCard_YearlyForm_03 form = new Forms.StudABCard_YearlyForm_03(_YearlyDataDict, lvData.SelectedItems[0].Text);
if (_QuestionDataDict.ContainsKey("特殊專長"))
{
form.SetFlp01Items((from data in _QuestionDataDict["特殊專長"].itemList select data.Key).ToList());
}
if (_QuestionDataDict.ContainsKey("休閒興趣"))
{
form.SetFlp02Items((from data in _QuestionDataDict["休閒興趣"].itemList select data.Key).ToList());
}
if (form.ShowDialog() == DialogResult.OK)
{
List <UDTYearlyDataDef> insertData = new List <UDTYearlyDataDef>();
List <UDTYearlyDataDef> updateData = new List <UDTYearlyDataDef>();
foreach (UDTYearlyDataDef data in form.GetData().Values)
{
if (string.IsNullOrEmpty(data.UID))
{
insertData.Add(data);
}
else
{
updateData.Add(data);
}
}
if (insertData.Count > 0)
{
UDTTransfer.ABUDTYearlyDataInsert(insertData);
}
if (updateData.Count > 0)
{
UDTTransfer.ABUDTYearlyDataUpdate(updateData);
}
_BGRun();
}
}
}
protected override void OnSaveButtonClick(EventArgs e)
{
SetData();
if (_insertDataList.Count > 0)
{
UDTTransfer.ABUDTSingleRecordInsert(_insertDataList);
}
if (_updateDataList.Count > 0)
{
UDTTransfer.ABUDTSingleRecordUpdate(_updateDataList);
}
this.CancelButtonVisible = this.SaveButtonVisible = false;
cbxGradeYear.Enabled = true;
}
/// <summary>
/// 新增項目
/// </summary>
/// <param name="itemName"></param>
/// <param name="itmType"></param>
public void AddItem(string itemName, ItemType itmType)
{
UDT_SystemListDef data = UDTTransfer.GetSystemListByName(itmType.ToString());
XElement elmData = XElement.Parse(data.Content);
List <UDT_SystemListDef> update = new List <UDT_SystemListDef>();
if (elmData != null)
{
XElement elm = new XElement("item");
elm.SetAttributeValue("name", itemName);
elmData.Add(elm);
}
data.Content = elmData.ToString();
update.Add(data);
UDTTransfer.UpdateSystemList(update);
}
protected override void OnSaveButtonClick(EventArgs e)
{
dgData.EndEdit();
SetData();
if (_insertDataList.Count > 0)
{
UDTTransfer.ABUDTYearlyDataInsert(_insertDataList);
}
if (_updateDataList.Count > 0)
{
UDTTransfer.ABUDTYearlyDataUpdate(_updateDataList);
}
this.CancelButtonVisible = this.SaveButtonVisible = false;
_BGRun();
}
/// <summary>
/// 依群組名稱取的資料
/// </summary>
/// <param name="Name"></param>
/// <returns></returns>
public Dictionary <string, QuestionData> GetQuestionDataByGroupName(string Name)
{
Dictionary <string, QuestionData> retVal = new Dictionary <string, QuestionData>();
List <UDTQuestionsDataDef> dataList = UDTTransfer.ABUDTQuestionsDataSelectByGroupName(Name);
dataList = (from da in dataList orderby da.Group, da.Name select da).ToList();
foreach (UDTQuestionsDataDef ud in dataList)
{
QuestionData qd = new QuestionData(ud);
if (!retVal.ContainsKey(qd.Name))
{
retVal.Add(qd.Name, qd);
}
}
return(retVal);
}
void _bgWorker_DoWork(object sender, DoWorkEventArgs e)
{
if (_reloadQuestion)
{
_QuestionDataDict = _QDMang.GetQuestionDataByGroupName(GroupName);
}
_UDTYearlyDataDict.Clear();
foreach (UDTYearlyDataDef data in UDTTransfer.ABUDTYearlyDataSelectByStudentIDList(_StudentIDList))
{
if (data.Key.Contains(GroupName))
{
if (!_UDTYearlyDataDict.ContainsKey(data.Key))
{
_UDTYearlyDataDict.Add(data.Key, data);
}
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
this.DialogResult = System.Windows.Forms.DialogResult.OK;
SetData();
List <UDTSiblingDef> dataList = new List <UDTSiblingDef>();
dataList.Add(_data);
if (string.IsNullOrEmpty(_data.UID))
{
UDTTransfer.ABUDTSiblingInsert(dataList);
}
else
{
UDTTransfer.ABUDTSiblingUpdate(dataList);
}
this.Close();
}
public ABCardQuestionDataManager()
{
_QuestionDataList = new List <QuestionData>();
_UDTQuestionsDataList = UDTTransfer.ABUDTQuestionsDataSelectAll();
//UDTTransfer.ABUDTQuestionsDataDelete(_UDTQuestionsDataList);
//_UDTQuestionsDataList = UDTTransfer.ABUDTQuestionsDataSelectAll();
foreach (UDTQuestionsDataDef UQ in _UDTQuestionsDataList)
{
QuestionData qd = new QuestionData(UQ);
_QuestionDataList.Add(qd);
}
// 當沒有資料放入預設
if (_UDTQuestionsDataList.Count < 1)
{
AddDefaultQuestionItems();
}
}
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;
}
}
}
}
