/// <summary>
/// 傳入學生資料+兄弟姊妹資料,為更新模式,
/// </summary>
public EditForm(StudentRecord student, SiblingRecord sibling)
{
InitializeComponent();
_student = student;
_sibling = sibling;
//設定舊資料至畫面上
BindData();
}
private void btnDelete_Click(object sender, EventArgs e)
{
//使用者確定有選取資料
if (listView1.SelectedItems.Count > 0)
{
DialogResult dr = MessageBox.Show("是否刪除資料?", "警告", MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
StringBuilder sb_log = new StringBuilder();
sb_log.AppendLine(string.Format("刪除「{0}」兄弟姊妹資料：", _student.Name));
List <SiblingRecord> SiblingList = new List <SiblingRecord>();
foreach (ListViewItem item in listView1.SelectedItems)
{
SiblingRecord sibling = (SiblingRecord)item.Tag;
SiblingList.Add(sibling);
sb_log.AppendLine(string.Format("稱謂「{0}」", sibling.SiblingTitle));
sb_log.AppendLine(string.Format("姓名「{0}」", sibling.SiblingName));
sb_log.AppendLine(string.Format("生日「{0}」", sibling.Birthday.ToString("yyyy/MM/dd")));
sb_log.AppendLine(string.Format("學校「{0}」", sibling.SchoolName));
sb_log.AppendLine(string.Format("班級「{0}」", sibling.ClassName));
sb_log.AppendLine(string.Format("備註「{0}」", sibling.Remark));
sb_log.AppendLine("");
}
//開始刪除資料
try
{
tool._a.DeletedValues(SiblingList);
}
catch (Exception ex)
{
MessageBox.Show("刪除失敗:" + ex.Message);
return;
}
FISCA.LogAgent.ApplicationLog.Log("兄弟姊妹模組", "刪除", sb_log.ToString());
//刪除後更新畫面
_bgw.RunWorkerAsync();
}
else
{
MessageBox.Show("已取消");
}
}
else
{
MessageBox.Show("未選擇資料");
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
if (listView1.SelectedItems.Count == 1)
{
SiblingRecord record = (SiblingRecord)listView1.SelectedItems[0].Tag;
EditForm editForm = new EditForm(_student, record);
DialogResult dr = editForm.ShowDialog();
//如果確認,就更新系統
if (dr == DialogResult.OK)
{
_bgw.RunWorkerAsync();
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
StringBuilder sb_log = new StringBuilder();
if (_sibling == null)
{
sb_log.AppendLine(string.Format("新增學生「{0}」兄弟姊妹資料：", _student.Name));
sb_log.AppendLine(string.Format("稱謂「{0}」", cbTitle.Text));
sb_log.AppendLine(string.Format("姓名「{0}」", tbName.Text));
sb_log.AppendLine(string.Format("生日「{0}」", tbBirthday.Text));
sb_log.AppendLine(string.Format("學校「{0}」", tbSchoolName.Text));
sb_log.AppendLine(string.Format("班級「{0}」", tbClassName.Text));
sb_log.AppendLine(string.Format("備註「{0}」", tbRemark.Text));
//新增模式
_sibling = new SiblingRecord();
_sibling.ClassName = tbClassName.Text;
//如果生日有輸入,且是日期格式
DateTime checkDateTime;
DateTime.TryParse(tbBirthday.Text, out checkDateTime);
if (!string.IsNullOrEmpty(tbBirthday.Text) && checkDateTime != null)
{
_sibling.Birthday = checkDateTime;
}
_sibling.SchoolName = tbSchoolName.Text;
_sibling.SiblingName = tbName.Text;
_sibling.SiblingTitle = cbTitle.Text;
_sibling.Remark = tbRemark.Text;
//新增資料須指定學生ID
_sibling.StudnetID = int.Parse(_student.ID); //包含學生ID
//將資料儲存置資料庫
try
{
tool._a.InsertValues(new List <SiblingRecord>()
{
_sibling
});
}
catch (Exception ex)
{
MessageBox.Show("新增失敗:" + ex.Message);
return;
}
FISCA.LogAgent.ApplicationLog.Log("兄弟姊妹模組", "新增", sb_log.ToString());
this.DialogResult = DialogResult.OK;
}
else
{
sb_log.AppendLine(string.Format("更新學生「 {0} 」兄弟姊妹資料：", _student.Name));
sb_log.AppendLine(string.Format("稱謂由「{0}」變更為「{1}」", _sibling.SiblingTitle, cbTitle.Text));
sb_log.AppendLine(string.Format("姓名由「{0}」變更為「{1}」", _sibling.SiblingName, tbName.Text));
sb_log.AppendLine(string.Format("生日由「{0}」變更為「{1}」", _sibling.Birthday.ToString("yyyy/MM/dd"), tbBirthday.Text));
sb_log.AppendLine(string.Format("學校由「{0}」變更為「{1}」", _sibling.SchoolName, tbSchoolName.Text));
sb_log.AppendLine(string.Format("班級由「{0}」變更為「{1}」", _sibling.ClassName, tbClassName.Text));
sb_log.AppendLine(string.Format("備註由「{0}」變更為「{1}」", _sibling.Remark, tbRemark.Text));
sb_log.AppendLine("");
//更新模式
_sibling.ClassName = tbClassName.Text;
//生日格式正確才儲存
DateTime checkDateTime;
DateTime.TryParse(tbBirthday.Text, out checkDateTime);
if (checkDateTime != null)
{
_sibling.Birthday = checkDateTime;
}
_sibling.SchoolName = tbSchoolName.Text;
_sibling.SiblingName = tbName.Text;
_sibling.SiblingTitle = cbTitle.Text;
_sibling.Remark = tbRemark.Text;
//將資料儲存置資料庫
//更新不須指定學生ID
try
{
tool._a.UpdateValues(new List <SiblingRecord>()
{
_sibling
});
}
catch (Exception ex)
{
MessageBox.Show("更新失敗:" + ex.Message);
return;
}
FISCA.LogAgent.ApplicationLog.Log("兄弟姊妹模組", "更新", sb_log.ToString());
this.DialogResult = DialogResult.OK;
}
}
