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 id , teacher_name , nickname FROM teacher WHERE status = 1 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(); }
/// <summary> /// 將使用者修改內容填入物件 /// </summary> private void GetChengeObj() { ClubPrimary.ClubName = txtClubName.Text.Trim(); //社團老師 if (cbTeacher1.SelectedItem != null) { TeacherObj teach = (TeacherObj)cbTeacher1.SelectedItem; ClubPrimary.RefTeacherID = teach.TeacherID; } else { ClubPrimary.RefTeacherID = ""; } //社團老師2 if (cbTeacher2.SelectedItem != null) { TeacherObj teach = (TeacherObj)cbTeacher2.SelectedItem; ClubPrimary.RefTeacherID2 = teach.TeacherID; } else { ClubPrimary.RefTeacherID2 = ""; } //社團老師3 if (cbTeacher3.SelectedItem != null) { TeacherObj teach = (TeacherObj)cbTeacher3.SelectedItem; ClubPrimary.RefTeacherID3 = teach.TeacherID; } else { ClubPrimary.RefTeacherID3 = ""; } //場地 ClubPrimary.Location = cbLocation.Text.Trim(); //關於 string refText = txtAbout.Text.Replace("\r\n", "<br>"); ClubPrimary.About = refText; //類型 ClubPrimary.ClubCategory = cbCategory.Text; //社團編號(8/7) ClubPrimary.ClubNumber = tbCLUBNumber.Text; //評等 ClubPrimary.Level = cbRank.Text; }
private CLUBRecord GetClub() { CLUBRecord club = new CLUBRecord(); club.ClubName = txtClubName.Text.Trim(); //社團名稱 club.SchoolYear = intSchoolYear.Value; //學年度 club.Semester = intSemester.Value; //學期 club.ClubCategory = cbCategory.Text.Trim(); //類型 club.ClubNumber = tbClubNumber.Text.Trim(); //類型 if (!string.IsNullOrEmpty(tbGrade1Limit.Text.Trim())) //一年級人限 { club.Grade1Limit = tool.StringIsInt_DefIsZero(tbGrade1Limit.Text.Trim()); } if (!string.IsNullOrEmpty(tbGrade2Limit.Text.Trim())) //二年級人限 { club.Grade2Limit = tool.StringIsInt_DefIsZero(tbGrade2Limit.Text.Trim()); } if (!string.IsNullOrEmpty(tbGrade3Limit.Text.Trim())) //三年級人限 { club.Grade3Limit = tool.StringIsInt_DefIsZero(tbGrade3Limit.Text.Trim()); } if (!string.IsNullOrEmpty(tbLimit.Text.Trim())) //三年級人限 { club.Limit = tool.StringIsInt_DefIsZero(tbLimit.Text.Trim()); } if (cbGenderRestrict.SelectedItem != null) //男女限制 { string res = cbGenderRestrict.GetItemText(cbGenderRestrict.SelectedItem); club.GenderRestrict = res; } //社團老師 if (cbTeacher.SelectedItem != null) { TeacherObj cbi = (TeacherObj)cbTeacher.SelectedItem; club.RefTeacherID = cbi.TeacherID; } if (cbTeacher2.SelectedItem != null) { TeacherObj cbi = (TeacherObj)cbTeacher2.SelectedItem; club.RefTeacherID2 = cbi.TeacherID; } if (cbTeacher3.SelectedItem != null) { TeacherObj cbi = (TeacherObj)cbTeacher3.SelectedItem; club.RefTeacherID3 = cbi.TeacherID; } //社團場地 if (!string.IsNullOrEmpty(cbLocation.Text.Trim())) { club.Location = cbLocation.Text.Trim(); } //社團限制 - 科別 DSXmlHelper dsXml = new DSXmlHelper("Department"); foreach (ListViewItem each in listDepartment.Items) { if (each.Checked) { dsXml.AddElement("Dept"); dsXml.AddText("Dept", each.Text); } } club.DeptRestrict = dsXml.BaseElement.OuterXml; club.About = tbAboutClub.Text.Trim(); //簡介 return(club); }
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 id , teacher_name , nickname FROM teacher WHERE status = 1 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); } } }