/// <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; } }