private bool IsDirty()
{
#region 資料驗證
foreach (DataGridViewRow row in dataGridView.Rows)
{
foreach (DataGridViewCell cell in row.Cells)
{
if (cell.Tag == null)
{
continue; //Tag是空的
}
if (cell.Tag is SemesterCellInfo) //學年度學期
{
SemesterCellInfo cInfo = cell.Tag as SemesterCellInfo;
if (cInfo.IsDirty)
{
return(true);
}
}
else if (cell.Tag is AbsenceCellInfo) //缺曠別
{
AbsenceCellInfo cInfo = cell.Tag as AbsenceCellInfo;
if (cInfo.IsDirty)
{
return(true);
}
}
}
}
return(false);
#endregion
}
void rb_CheckedChanged(object sender, EventArgs e)
{
#region 缺曠類別建立(事件)
RadioButton rb = sender as RadioButton;
if (rb.Checked)
{
_checkedAbsence = rb.Tag as AbsenceInfo;
foreach (DataGridViewCell cell in dataGridView.SelectedCells)
{
if (cell.ColumnIndex < _startIndex || cell.OwningRow.Visible == false)
{
continue;
}
cell.Value = _checkedAbsence.Abbreviation;
AbsenceCellInfo acInfo = cell.Tag as AbsenceCellInfo;
if (acInfo == null)
{
acInfo = new AbsenceCellInfo();
}
acInfo.SetValue(_checkedAbsence);
cell.Value = acInfo.AbsenceInfo.Abbreviation;
cell.Tag = acInfo;
}
dataGridView.Focus();
}
#endregion
}
private void dataGridView_KeyDown(object sender, KeyEventArgs e)
{
#region 如果按下按鈕
string key = KeyConverter.GetKeyMapping(e);
if (!_absenceList.ContainsKey(key))
{
if (e.KeyCode != Keys.Space && e.KeyCode != Keys.Delete)
{
return;
}
foreach (DataGridViewCell cell in dataGridView.SelectedCells)
{
if (cell.ColumnIndex < _startIndex || cell.OwningRow.Visible == false)
{
continue;
}
cell.Value = null;
AbsenceCellInfo acInfo = cell.Tag as AbsenceCellInfo;
if (acInfo != null)
{
acInfo.SetValue(null);
}
}
}
else
{
AbsenceInfo info = _absenceList[key];
foreach (DataGridViewCell cell in dataGridView.SelectedCells)
{
if (cell.ColumnIndex < _startIndex || cell.OwningRow.Visible == false)
{
continue;
}
AbsenceCellInfo acInfo = cell.Tag as AbsenceCellInfo;
if (acInfo == null)
{
acInfo = new AbsenceCellInfo();
}
acInfo.SetValue(info);
if (acInfo.IsValueChanged)
{
cell.Value = acInfo.AbsenceInfo.Abbreviation;
}
else
{
cell.Value = string.Empty;
acInfo.SetValue(AbsenceInfo.Empty);
}
cell.Tag = acInfo;
}
}
#endregion
}
private void dataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
#region CellDoubleClick
if (e.Button != MouseButtons.Left)
{
return;
}
if (e.ColumnIndex < _startIndex)
{
return;
}
if (e.RowIndex < 0)
{
return;
}
DataGridViewCell cell = dataGridView.Rows[e.RowIndex].Cells[e.ColumnIndex];
cell.Value = _checkedAbsence.Abbreviation;
AbsenceCellInfo acInfo = cell.Tag as AbsenceCellInfo;
if (acInfo == null)
{
acInfo = new AbsenceCellInfo();
}
acInfo.SetValue(_checkedAbsence);
if (acInfo.IsValueChanged)
{
cell.Value = acInfo.AbsenceInfo.Abbreviation;
}
else
{
cell.Value = string.Empty;
acInfo.SetValue(AbsenceInfo.Empty);
}
cell.Tag = acInfo;
#endregion
}
//儲存
private void btnSave_Click(object sender, EventArgs e)
{
#region Save
if (!IsValid())
{
FISCA.Presentation.Controls.MsgBox.Show("資料驗證失敗，請修正後再行儲存", "驗證失敗", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
List <SHAttendanceRecord> InsertHelper = new List <SHAttendanceRecord>(); //新增
List <SHAttendanceRecord> updateHelper = new List <SHAttendanceRecord>(); //更新
List <string> deleteList = new List <string>(); //清空
//List<string> synclist = new List<string>();
ISemester semester = SemesterProvider.GetInstance();
foreach (DataGridViewRow row in dataGridView.Rows)
{
RowTag tag = row.Tag as RowTag;
semester.SetDate(tag.Date);
////log 紀錄修改後的資料 日期部分
if (row.Cells[0].Tag is string)
{
if (!LOG[row.Cells[0].Tag.ToString()].afterData.ContainsKey(tag.Date.ToShortDateString()))
{
LOG[row.Cells[0].Tag.ToString()].afterData.Add(tag.Date.ToShortDateString(), new Dictionary <string, string>());
}
}
else
{
SHAttendanceRecord attRecord = row.Cells[0].Tag as SHAttendanceRecord;
if (!LOG[attRecord.RefStudentID].afterData.ContainsKey(tag.Date.ToShortDateString()))
{
LOG[attRecord.RefStudentID].afterData.Add(tag.Date.ToShortDateString(), new Dictionary <string, string>());
}
}
if (tag.IsNew)
{
#region IsNew
string studentID = row.Cells[0].Tag as string;
SHAttendanceRecord attRecord = new SHAttendanceRecord();
bool hasContent = false;
for (int i = _startIndex; i < dataGridView.Columns.Count; i++)
{
DataGridViewCell cell = row.Cells[i];
if (string.IsNullOrEmpty(("" + cell.Value).Trim()))
{
continue;
}
PeriodInfo pinfo = dataGridView.Columns[i].Tag as PeriodInfo;
AbsenceCellInfo acInfo = cell.Tag as AbsenceCellInfo;
AbsenceInfo ainfo = acInfo.AbsenceInfo;
K12.Data.AttendancePeriod ap = new K12.Data.AttendancePeriod();
ap.Period = pinfo.Name;
ap.AbsenceType = ainfo.Name;
attRecord.PeriodDetail.Add(ap);
hasContent = true;
//log 紀錄修改後的資料 缺曠明細部分
if (!LOG[studentID].afterData[tag.Date.ToShortDateString()].ContainsKey(pinfo.Name))
{
LOG[studentID].afterData[tag.Date.ToShortDateString()].Add(pinfo.Name, ainfo.Name);
}
}
if (hasContent)
{
attRecord.RefStudentID = studentID;
attRecord.SchoolYear = int.Parse("" + row.Cells[ColumnIndex["學年度"]].Value);
attRecord.Semester = int.Parse("" + row.Cells[ColumnIndex["學期"]].Value);
attRecord.OccurDate = DateTime.Parse(tag.Date.ToShortDateString());
InsertHelper.Add(attRecord);
}
#endregion
}
else // 若是原本就有紀錄的
{
#region 是舊的
SHAttendanceRecord attRecord = row.Cells[0].Tag as SHAttendanceRecord;
attRecord.PeriodDetail.Clear(); //清空
bool hasContent = false;
for (int i = _startIndex; i < dataGridView.Columns.Count; i++)
{
DataGridViewCell cell = row.Cells[i];
if (string.IsNullOrEmpty(("" + cell.Value).Trim()))
{
continue;
}
PeriodInfo pinfo = dataGridView.Columns[i].Tag as PeriodInfo;
AbsenceCellInfo acInfo = cell.Tag as AbsenceCellInfo;
AbsenceInfo ainfo = acInfo.AbsenceInfo;
K12.Data.AttendancePeriod ap = new K12.Data.AttendancePeriod();
ap.Period = pinfo.Name;
ap.AbsenceType = ainfo.Name;
attRecord.PeriodDetail.Add(ap);
hasContent = true;
//log 紀錄修改後的資料 缺曠明細部分
if (!LOG[attRecord.RefStudentID].afterData[tag.Date.ToShortDateString()].ContainsKey(pinfo.Name))
{
LOG[attRecord.RefStudentID].afterData[tag.Date.ToShortDateString()].Add(pinfo.Name, ainfo.Name);
}
}
if (hasContent)
{
attRecord.SchoolYear = int.Parse("" + row.Cells[ColumnIndex["學年度"]].Value);
attRecord.Semester = int.Parse("" + row.Cells[ColumnIndex["學期"]].Value);
updateHelper.Add(attRecord);
}
else
{
deleteList.Add(tag.Key);
//log 紀錄被刪除的資料
LOG[attRecord.RefStudentID].afterData.Remove(tag.Date.ToShortDateString());
LOG[attRecord.RefStudentID].deleteData.Add(tag.Date.ToShortDateString());
}
#endregion
}
}
#region InsertHelper
if (InsertHelper.Count > 0)
{
try
{
SHAttendance.Insert(InsertHelper);
}
catch (Exception ex)
{
FISCA.Presentation.Controls.MsgBox.Show("缺曠紀錄新增失敗 : " + ex.Message, "新增失敗", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//log 寫入log
foreach (string each in LOG.Keys)
{
foreach (string date in LOG[each].afterData.Keys)
{
if (!LOG[each].beforeData.ContainsKey(date) && LOG[each].afterData[date].Count > 0)
{
StringBuilder desc = new StringBuilder("");
desc.AppendLine("學生「" + K12.Data.Student.SelectByID(each).Name + "」");
desc.AppendLine("日期「" + date + "」");
foreach (string period in LOG[each].afterData[date].Keys)
{
desc.AppendLine("節次「" + period + "」設為「" + LOG[each].afterData[date][period] + "」");
}
ApplicationLog.Log("學務系統.缺曠資料", "批次新增缺曠資料", "student", each, desc.ToString());
//Log部份
//CurrentUser.Instance.AppLog.Write(EntityType.Student, EntityAction.Insert, _student.ID, desc.ToString(), this.Text, "");
}
}
}
}
#endregion
#region updateHelper
if (updateHelper.Count > 0)
{
try
{
SHAttendance.Update(updateHelper);
}
catch (Exception ex)
{
FISCA.Presentation.Controls.MsgBox.Show("缺曠紀錄更新失敗 : " + ex.Message, "更新失敗", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//log 寫入log
foreach (string each in LOG.Keys)
{
foreach (string date in LOG[each].afterData.Keys)
{
if (LOG[each].beforeData.ContainsKey(date) && LOG[each].afterData[date].Count > 0)
{
bool dirty = false;
StringBuilder desc = new StringBuilder("");
desc.AppendLine("學生「" + K12.Data.Student.SelectByID(each).Name + "」 ");
desc.AppendLine("日期「" + date + "」 ");
foreach (string period in LOG[each].beforeData[date].Keys)
{
if (!LOG[each].afterData[date].ContainsKey(period))
{
LOG[each].afterData[date].Add(period, "");
}
}
foreach (string period in LOG[each].afterData[date].Keys)
{
if (LOG[each].beforeData[date].ContainsKey(period))
{
if (LOG[each].beforeData[date][period] != LOG[each].afterData[date][period])
{
dirty = true;
desc.AppendLine("節次「" + period + "」由「" + LOG[each].beforeData[date][period] + "」變更為「" + LOG[each].afterData[date][period] + "」");
}
}
else
{
dirty = true;
desc.AppendLine("節次「" + period + "」由「」變更為「" + LOG[each].afterData[date][period] + "」 ");
}
}
if (dirty)
{
//Log部份
ApplicationLog.Log("學務系統.缺曠資料", "批次修改缺曠資料", "student", each, desc.ToString());
//CurrentUser.Instance.AppLog.Write(EntityType.Student, EntityAction.Update, _student.ID, desc.ToString(), this.Text, "");
}
}
}
}
}
#endregion
#region deleteList
if (deleteList.Count > 0)
{
try
{
SHAttendance.Delete(deleteList);
}
catch (Exception ex)
{
FISCA.Presentation.Controls.MsgBox.Show("缺曠紀錄刪除失敗 : " + ex.Message, "刪除失敗", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//log 寫入被刪除的資料的log
foreach (string each in LOG.Keys)
{
StringBuilder desc = new StringBuilder("");
desc.AppendLine("學生「" + K12.Data.Student.SelectByID(each).Name + "」");
foreach (string date in LOG[each].deleteData)
{
desc.AppendLine("刪除「" + date + "」缺曠紀錄 ");
}
//Log部份
ApplicationLog.Log("學務系統.缺曠資料", "批次刪除缺曠資料", "student", each, desc.ToString());
//CurrentUser.Instance.AppLog.Write(EntityType.Student, EntityAction.Delete, _student.ID, desc.ToString(), this.Text, "");
}
}
#endregion
//觸發變更事件
//Attendance.Instance.SyncDataBackground(_studentList);
FISCA.Presentation.Controls.MsgBox.Show("儲存缺曠資料成功!", "完成", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
#endregion
}