//更新模式傳 目前的補考梯次 直接對該補考梯次更新
public InsertUpdateMakeUpBatchForm(string action, string schoolYear, string semester, UDT_MakeUpBatch batch)
{
InitializeComponent();
_action = action;
_schoolYear = schoolYear;
_semester = semester;
_batch = batch;
_errors = new EnhancedErrorProvider();
_batchNameList = new List <string>();
// 只有新增 模式 才可以讓使用者 編輯 補考梯次名稱、包含班級
if (_action == "新增")
{
txtBatchName.Enabled = true;
lstClass.Enabled = true;
chkSelectAll.Enabled = true;
}
// 修改模式 使用者只能修改 補考說明
if (_action == "修改")
{
this.Text = "管理補考梯次";
txtBatchName.Text = _batch.MakeUp_Batch;
txtDescription.Text = _batch.Description;
txtStartTime.Text = _batch.Start_Time.ToString("yyyy/MM/dd HH:mm:ss");
txtEndTime.Text = _batch.End_Time.ToString("yyyy/MM/dd HH:mm:ss");
}
}
private void GetMakeUpBatch()
{
// 清空舊資料
dataGridViewX1.Rows.Clear();
picLoading.Visible = true;
#region 取得 該學年度學期的 補考梯次
string query = @"
SELECT
*
FROM $make.up.batch
WHERE
school_year = '" + _schoolYear + "'" +
"AND semester = '" + _semester + "'";
QueryHelper qh = new QueryHelper();
DataTable dt = qh.Select(query);
_batchList.Clear(); // 清空
//整理目前的ESL 課程資料
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
UDT_MakeUpBatch batch = new UDT_MakeUpBatch();
batch.UID = "" + dr["uid"];
//補考梯次
batch.MakeUp_Batch = "" + dr["makeup_batch"];
//學年度
batch.School_Year = "" + dr["school_year"];
//學期
batch.Semester = "" + dr["semester"];
//補考說明
batch.Description = "" + dr["description"];
//包含班級id
batch.Included_Class_ID = "" + dr["included_class_id"];
// 是否封存 是=封存
batch.is_archive = "" + dr["is_archive"];
_batchList.Add(batch);
}
}
#endregion
#region 取得學生 補考資料(本梯次內 所有的群組)
//_scaList = K12.Data.SCAttend.SelectByCourseIDs(_CourseIDList);
#endregion
}
// 點下項目後 更新補考群組
private void NodeMouseDown(object sender, MouseEventArgs e)
{
_node_now = (DevComponents.AdvTree.Node)sender;
// 現在選的 node 的 Tag 就是 batch
_selectedBatch = _batchList.Find(b => b.UID == "" + _node_now.Tag);
RefreshDataGridViewXMakeUpGroupView();
}
private void GetMakeUpBatch()
{
_batchList.Clear();
#region 取得補考梯次
string query = @"
SELECT
*
FROM $make.up.batch
WHERE
school_year = '" + _schoolYear + "'" +
"AND semester = '" + _semester + "' ORDER BY makeup_batch ASC";
QueryHelper qh = new QueryHelper();
DataTable dt = qh.Select(query);
//整理目前的補考梯次 資料
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
// 判斷是封存不顯示
if (row["is_archive"] != null)
{
if (row["is_archive"].ToString() == "是")
{
continue;
}
}
UDT_MakeUpBatch batch = new UDT_MakeUpBatch();
batch.UID = "" + row["uid"];
//補考梯次
batch.MakeUp_Batch = "" + row["makeup_batch"];
//學年度
batch.School_Year = "" + row["school_year"];
//學期
batch.Semester = "" + row["semester"];
//補考說明
batch.Description = "" + row["description"];
//包含班級id
batch.Included_Class_ID = "" + row["included_class_id"];
_batchList.Add(batch);
}
}
#endregion
}
private void dataGridViewX1_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (e.Button != MouseButtons.Left)
{
return;
}
if (e.ColumnIndex < 0)
{
return;
}
if (e.RowIndex < 0)
{
return;
}
DataGridViewCell cell = dataGridViewX1.Rows[e.RowIndex].Cells[e.ColumnIndex];
// 找到選取到的 梯次
_selectedBatch = _BatchList.Find(x => x.UID == "" + cell.OwningRow.Tag);
// 修改模式
InsertUpdateMakeUpBatchForm iumbf = new InsertUpdateMakeUpBatchForm("修改", cboSchoolYear.Text, cbosemester.Text, _selectedBatch);
if (iumbf.ShowDialog() == DialogResult.OK)
{
_selectedBatch = iumbf.GetCurrentBatch();
// 回寫畫面資料
foreach (DataGridViewRow drv in dataGridViewX1.Rows)
{
if (drv.IsNewRow)
{
continue;
}
string uid = drv.Tag.ToString();
if (uid == _selectedBatch.UID)
{
drv.Cells[colIsArchive.Index].Value = _selectedBatch.is_archive;
drv.Cells[ColMakeUpBatch.Index].Value = _selectedBatch.MakeUp_Batch;
drv.Cells[ColStartTime.Index].Value = _selectedBatch.Start_Time.ToString("yyyy/MM/dd HH:mm:ss");
drv.Cells[ColEndTime.Index].Value = _selectedBatch.End_Time.ToString("yyyy/MM/dd HH:mm:ss");
drv.Cells[ColIncludedClassID.Index].Value = _selectedBatch.totalclassName;
drv.Cells[ColDescription.Index].Value = _selectedBatch.Description;
break;
}
}
}
// RefreshListView(); //重整畫面
}
// 新增模式 傳 補考群組 物件
public InsertUpdateMakeUpGroupForm(string school_year, string semester, string action, UDT_MakeUpBatch ref_makeup_batch)
{
InitializeComponent();
_school_year = school_year;
_semester = semester;
_dataList = new List <UDT_MakeUpData>();
_groupNameList = new List <string>();
List <TeacherRecord> tRlist = K12.Data.Teacher.SelectAll();
_teacherList = new List <TeacherRecord>();
foreach (TeacherRecord tr in tRlist)
{
if (tr.Status == TeacherRecord.TeacherStatus.刪除)
{
continue;
}
_teacherList.Add(tr);
}
// 老師 依教師姓名排序
_teacherList.Sort((x, y) => { return(x.Name.CompareTo(y.Name)); });
//將教師加入清單
foreach (K12.Data.TeacherRecord teacher in _teacherList)
{
// 老師全名
if (!string.IsNullOrEmpty(teacher.Nickname))
{
cboTeacher.Items.Add(teacher.Name + "(" + teacher.Nickname + ")");
}
else
{
cboTeacher.Items.Add(teacher.Name);
}
}
_dataWorker = new BackgroundWorker();
_dataWorker.DoWork += new DoWorkEventHandler(DataWorker_DoWork);
_dataWorker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(DataWorker_RunWorkerCompleted);
_dataWorker.ProgressChanged += new ProgressChangedEventHandler(DataWorker_ProgressChanged);
_dataWorker.WorkerReportsProgress = true;
_action = action;
_batch = ref_makeup_batch;
}
private void dataGridViewX1_SelectionChanged(object sender, EventArgs e)
{
// 有選擇梯次 才可以產生補考群組
if (dataGridViewX1.SelectedRows.Count > 0)
{
btnGenMakeUpGroup.Enabled = true;
// 一次只能選一條 Row ，所以是第一個
_selectedBatch = _BatchList.Find(x => x.UID == "" + dataGridViewX1.SelectedRows[0].Tag);
}
else
{
btnGenMakeUpGroup.Enabled = false;
}
}
private void GetMakeUpBatch()
{
#region 取得 該學年度學期的 補考梯次
string query = @"
SELECT
*
FROM $make.up.batch
WHERE
school_year = '" + _schoolYear + "'" +
"AND semester = '" + _semester + "'";
QueryHelper qh = new QueryHelper();
DataTable dt = qh.Select(query);
_batchList.Clear(); // 清空
//整理目前的ESL 課程資料
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
UDT_MakeUpBatch batch = new UDT_MakeUpBatch();
batch.UID = "" + dr["uid"];
//補考梯次
batch.MakeUp_Batch = "" + dr["makeup_batch"];
//學年度
batch.School_Year = "" + dr["school_year"];
//學期
batch.Semester = "" + dr["semester"];
//補考說明
batch.Description = "" + dr["description"];
//包含班級id
batch.Included_Class_ID = "" + dr["included_class_id"];
_batchList.Add(batch);
}
}
#endregion
}
public GenMakeUpGroupForm(UDT_MakeUpBatch batch)
{
InitializeComponent();
_batch = batch;
// 解析 classID
_batch.ParseClassXMLIDList();
_classIDList = _batch.classIDList;
_schoolYear = _batch.School_Year;
_semester = _batch.Semester;
_worker = new BackgroundWorker();
_worker.DoWork += new DoWorkEventHandler(Worker_DoWork);
_worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(Worker_RunWorkerCompleted);
_worker.ProgressChanged += new ProgressChangedEventHandler(Worker_ProgressChanged);
_worker.WorkerReportsProgress = true;
_worker.RunWorkerAsync();
}
private void GetMakeUpBatch()
{
_BatchList.Clear();
#region 取得補考梯次
string query = @"
SELECT
*
FROM $make.up.batch
WHERE
school_year = '" + _schoolYear + "'" +
"AND semester = '" + _semester + "' ORDER BY makeup_batch ASC";
QueryHelper qh = new QueryHelper();
DataTable dt = qh.Select(query);
//整理目前的補考梯次 資料
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
UDT_MakeUpBatch batch = new UDT_MakeUpBatch();
batch.UID = "" + row["uid"];
//補考梯次
batch.MakeUp_Batch = "" + row["makeup_batch"];
//學年度
batch.School_Year = "" + row["school_year"];
//學期
batch.Semester = "" + row["semester"];
// 成績輸入開始時間
DateTime st = new DateTime();
if (DateTime.TryParse("" + row["start_time"], out st))
{
batch.Start_Time = st;
}
else
{
batch.Start_Time = st;
}
// 成績輸入結束時間
DateTime et = new DateTime();
if (DateTime.TryParse("" + row["end_time"], out et))
{
batch.End_Time = et;
}
else
{
batch.End_Time = et;
}
//補考說明
batch.Description = "" + row["description"];
//包含班級id
batch.Included_Class_ID = "" + row["included_class_id"];
// 是否封存
batch.is_archive = "" + row["is_archive"];
_BatchList.Add(batch);
}
}
#endregion
}
