void BGW_DoWork(object sender, DoWorkEventArgs e)
{
_DefaultSchoolYear = tool.StringIsInt_DefIsZero(K12.Data.School.DefaultSchoolYear);
_DefaultSemester = tool.StringIsInt_DefIsZero(K12.Data.School.DefaultSemester);
//取得老師資料
TeacherList.Clear();
DataTable dt = _QueryHelper.Select("select teacher.id,teacher.teacher_name,teacher.nickname from teacher ORDER by teacher_name");
foreach (DataRow row in dt.Rows)
{
TeacherObj obj = new TeacherObj();
obj.TeacherID = "" + row[0];
obj.TeacherName = "" + row[1];
obj.TeacherNickName = "" + row[2];
TeacherList.Add(obj);
}
//取得場地[GROUP BY]
string TableName = Tn._CLUBRecordUDT;
dt = _QueryHelper.Select("select location from " + TableName.ToLower() + " group by location ORDER by location");
ClubLocation.Clear();
foreach (DataRow row in dt.Rows)
{
string loc = "" + row[0];
ClubLocation.Add(loc);
}
ClubLocation.Sort();
//取得社團類型[Group By]
TableName = Tn._CLUBRecordUDT;
dt = _QueryHelper.Select("select club_category from " + TableName.ToLower() + " group by club_category ORDER by club_category");
ClubCategory.Clear();
foreach (DataRow row in dt.Rows)
{
string loc = "" + row[0];
if (string.IsNullOrEmpty(loc))
continue;
ClubCategory.Add(loc);
}
ClubCategory.Sort();
//取得科別資料
deptList = tool.GetQueryDeptList();
}
void BGW_DoWork(object sender, DoWorkEventArgs e)
{
//StudentNameDic.Clear();
//取得社團資料
List<CLUBRecord> ClubPrimaryList = _AccessHelper.Select<CLUBRecord>(string.Format("UID = '{0}'", this.PrimaryKey));
if (ClubPrimaryList.Count != 1)
{
//如果取得2門以上 或 沒取得社團時
e.Cancel = true;
return;
}
ClubPrimary = ClubPrimaryList[0];
Log_ClubPrimary = ClubPrimary.CopyExtension();
//取得場地[GROUP BY]
string TableName = Tn._CLUBRecordUDT;
DataTable dt = _QueryHelper.Select("select location from " + TableName.ToLower() + " group by location ORDER by location");
ClubLocation.Clear();
foreach (DataRow row in dt.Rows)
{
string loc = "" + row[0];
ClubLocation.Add(loc);
}
ClubLocation.Sort();
//取得社團類型[Group By]
TableName = Tn._CLUBRecordUDT;
dt = _QueryHelper.Select("select club_category from " + TableName.ToLower() + " group by club_category ORDER by club_category");
ClubCategory.Clear();
foreach (DataRow row in dt.Rows)
{
string loc = "" + row[0];
if (string.IsNullOrEmpty(loc))
continue;
ClubCategory.Add(loc);
}
ClubCategory.Sort();
//取得老師資料
TeacherList.Clear();
TeacherDic.Clear();
TeacherNameDic.Clear();
dt = _QueryHelper.Select("select teacher.id,teacher.teacher_name,teacher.nickname from teacher ORDER by teacher_name");
foreach (DataRow row in dt.Rows)
{
TeacherObj obj = new TeacherObj();
obj.TeacherID = "" + row[0];
obj.TeacherName = ("" + row[1]).Trim();
obj.TeacherNickName = ("" + row[2]).Trim();
TeacherList.Add(obj);
if (!TeacherDic.ContainsKey(obj.TeacherID))
{
TeacherDic.Add(obj.TeacherID, obj);
}
if (!TeacherNameDic.ContainsKey(obj.TeacherFullName))
{
TeacherNameDic.Add(obj.TeacherFullName, obj);
}
}
}
