private void SaveSetting() { List <Setting> UDTlist = _A.Select <Setting>(); _A.DeletedValues(UDTlist); //清除UDT資料 UDTlist.Clear(); //清空UDTlist foreach (DataGridViewRow row in dataGridViewX1.Rows) //取得DataDataGridViewRow資料 { if (row.Cells[0].Value == null) //遇到空白的Target即跳到下個loop { continue; } String target = row.Cells[0].Value.ToString(); String source = ""; if (row.Cells[1].Value != null) { source = row.Cells[1].Value.ToString(); } Setting obj = new Setting(); obj.Target = target; obj.Source = source; UDTlist.Add(obj); } _A.InsertValues(UDTlist); //回存到UDT }
private void btnSave_Click(object sender, EventArgs e) { if (CheckData()) { DSXmlHelper DSXml = new DSXmlHelper("Xml"); StringBuilder sb = new StringBuilder(); sb.AppendLine("已修改評量比例"); foreach (DataGridViewRow row in dataGridViewX1.Rows) { if (row.IsNewRow) { continue; } XmlElement xmle = DSXml.AddElement("Item"); xmle.SetAttribute("Name", "" + row.Cells[0].Value); xmle.SetAttribute("Proportion", "" + row.Cells[1].Value); //Log sb.AppendLine(string.Format("名稱「{0}」比例「{1}」", "" + row.Cells[0].Value, "" + row.Cells[1].Value)); } //先刪掉 try { List <WeightProportion> listdelete = _AccessHelper.Select <WeightProportion>(); _AccessHelper.DeletedValues(listdelete); //新增一組全新的 List <WeightProportion> list = new List <WeightProportion>(); wp.Proportion = DSXml.BaseElement.OuterXml; list.Add(wp); _AccessHelper.InsertValues(list); FISCA.LogAgent.ApplicationLog.Log("社團", "修改評量比例", sb.ToString()); } catch (Exception ex) { MsgBox.Show("儲存失敗!!\n" + ex.Message); SmartSchool.ErrorReporting.ReportingService.ReportException(ex); return; } MsgBox.Show("儲存成功!!"); this.Close(); } else { MsgBox.Show("資料錯誤請修正後儲存!!"); } }
/// <summary> /// 清除社團參與記錄 /// </summary> private void buttonX1_Click(object sender, EventArgs e) { List <string> list2 = new List <string>(); List <CLUBRecord> list1 = _A.Select <CLUBRecord>(string.Format("school_year={0} and semester={1}", integerInput1.Value.ToString(), integerInput2.Value.ToString())); foreach (CLUBRecord each in list1) { list2.Add(each.UID); } List <SCJoin> list3 = _A.Select <SCJoin>("ref_club_id in ('" + string.Join("','", list2) + "')"); _A.DeletedValues(list3); }
private void btnClear_Click(object sender, EventArgs e) { DialogResult dr = MsgBox.Show("您確定要把標記之社團參與記錄移除?", MessageBoxButtons.YesNo, MessageBoxDefaultButton.Button2); if (dr == System.Windows.Forms.DialogResult.Yes) { List <SCJoin> RemoveList = new List <SCJoin>(); foreach (DataGridViewRow row in dataGridViewX1.Rows) { StudRepeatObj obj = (StudRepeatObj)row.DataBoundItem; if (obj.Change) //如果資料有修改 { RemoveList.AddRange(obj._RemoveList); } } try { _AccessHelper.DeletedValues(RemoveList); } catch (Exception ex) { MsgBox.Show("清除作業發生錯誤\n" + ex.Message); return; } MsgBox.Show("社團參與記錄清除成功!!"); this.Close(); } else { MsgBox.Show("已中止操作!!"); } }
private void dataGridViewX1_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex > -1 && e.ColumnIndex == 5) { string studentName = dataGridViewX1.Rows[e.RowIndex].Cells[3].Value.ToString(); string scorerID = dataGridViewX1.Rows[e.RowIndex].Tag.ToString(); DialogResult result = MsgBox.Show(string.Format("確定刪除 {0} 評分員身分?", studentName), "提醒", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { try { AccessHelper access = new AccessHelper(); access.DeletedValues(access.Select <UDT.Scorer>(string.Format("uid = {0}", scorerID))); MsgBox.Show("刪除成功"); ReloadDataGridView(); } catch (Exception ex) { MsgBox.Show(ex.Message); } } } }
public void SaveMappingRecord() //儲存上次Mapping紀錄 { AccessHelper _A = new AccessHelper(); List <UpdateRecordReportUDT> UDTlist = _A.Select <UpdateRecordReportUDT>(); _A.DeletedValues(UDTlist); //清除UDT資料 UDTlist = new List <UpdateRecordReportUDT>(); //清空UDTlist foreach (DataGridViewRow row in dataGridViewX1.Rows) //取得DataDataGridViewRow資料 { if (row.Cells[0].Value == null) //遇到空白的Target即跳到下個loop { continue; } String target = row.Cells[0].Value.ToString(); String source = ""; if (row.Cells[1].Value != null) { source = row.Cells[1].Value.ToString(); } UpdateRecordReportUDT obj = new UpdateRecordReportUDT(); obj.Target = target; obj.Source = source; UDTlist.Add(obj); } _A.InsertValues(UDTlist); //回存到UDT }
protected void Save() { dataGridViewX1.EndEdit(); if (!IsValid(dataGridViewX1)) { MsgBox.Show("請先修正錯誤"); return; } List <DomainCode_DomainMakeUp> newList = new List <DomainCode_DomainMakeUp>(); foreach (DataGridViewRow row in dataGridViewX1.Rows) { if (row.IsNewRow) { continue; } DomainCode_DomainMakeUp cc = new DomainCode_DomainMakeUp(); cc.Domain = "" + row.Cells[chDomainName.Index].Value; cc.Code = "" + row.Cells[chCode.Index].Value; newList.Add(cc); } _accessHelper.DeletedValues(_list.ToArray()); _accessHelper.InsertValues(newList.ToArray()); ClassCodeMapper.Instance.Reload(); this.DialogResult = DialogResult.OK; }
private void btnSave_Click(object sender, EventArgs e) { Dictionary <string, AbsenceUDT> auDic = new Dictionary <string, AbsenceUDT>(); foreach (DataGridViewRow row in dgv.Rows) { if (row.IsNewRow) { continue; } string target = row.Cells[colTarget.Index].Value + ""; string source = row.Cells[colSource.Index].Value + ""; string key = target + "_" + source; if (!auDic.ContainsKey(key)) { AbsenceUDT au = new AbsenceUDT(); au.Target = target; au.Source = source; auDic.Add(key, au); } } if (auDic.Count > 0) { _A.DeletedValues(_auList); _A.InsertValues(auDic.Values); } this.Close(); }
/// <summary> /// 自動修正選擇資料 /// </summary> /// <param name="EntityIDs"></param> public void ExecuteAutoCorrect(IEnumerable <string> EntityIDs) { //Log StringBuilder sb = new StringBuilder(); List <AssnAddress> list = new List <AssnAddress>(); //如果是null / 表示修正所有資料 if (K12.Data.Utility.Utility.IsNullOrEmpty(EntityIDs)) { sb.AppendLine("已進行:社團上課地點空值檢查"); sb.AppendLine("自動修正「所有」之錯誤資料"); sb.AppendLine("刪除資料如下:"); sb.AppendLine(""); foreach (AssociationAddressRATRecord APeach in RATRecords) { if (AssnciationDic.ContainsKey(APeach.課地點UID)) { AssnAddress aa = AssnciationDic[APeach.課地點UID]; string schoolyear = CourseDic[aa.AssociationID].SchoolYear.HasValue ? CourseDic[aa.AssociationID].SchoolYear.Value.ToString() : ""; string Semester = CourseDic[aa.AssociationID].Semester.HasValue ? CourseDic[aa.AssociationID].Semester.Value.ToString() : ""; sb.AppendLine("上課地點「" + aa.Address + "」" + "資料系統編號(UID)「" + aa.UID + "」上課學年度「" + aa.SchoolYear + "」上課學期「" + aa.Semester + "」"); sb.AppendLine("(社團對應資料 - 學年度「" + schoolyear + "」學期「" + Semester + "」名稱「" + CourseDic[aa.AssociationID].Name + "」)"); list.Add(aa); } //_accessHelper.Select<AssnAddress> } } else //修正部份 { sb.AppendLine("已進行:社團上課地點空值檢查"); sb.AppendLine("自動修正「已選擇」之錯誤項目"); sb.AppendLine("刪除資料如下:"); sb.AppendLine(""); foreach (string Entityeach in EntityIDs) { if (AssnciationDic.ContainsKey(Entityeach)) { AssnAddress aa = AssnciationDic[Entityeach]; string schoolyear = CourseDic[aa.AssociationID].SchoolYear.HasValue ? CourseDic[aa.AssociationID].SchoolYear.Value.ToString() : ""; string Semester = CourseDic[aa.AssociationID].Semester.HasValue ? CourseDic[aa.AssociationID].Semester.Value.ToString() : ""; sb.AppendLine("上課地點「" + aa.Address + "」" + "資料系統編號(UID)「" + aa.UID + "」上課學年度「" + aa.SchoolYear + "」上課學期「" + aa.Semester + "」"); sb.AppendLine("(社團對應資料 - 學年度「" + schoolyear + "」學期「" + Semester + "」名稱「" + CourseDic[aa.AssociationID].Name + "」)"); list.Add(AssnciationDic[Entityeach]); } } } DialogResult dr = MsgBox.Show("即將刪除選取之資料\n您確定要進行自動修正嗎??", MessageBoxButtons.YesNo, MessageBoxDefaultButton.Button2); if (dr == DialogResult.Yes) { _accessHelper.DeletedValues(list.ToArray()); ApplicationLog.Log("資料合理性檢查", "社團上課地點空值檢查(高雄市適用)", sb.ToString()); } else { MsgBox.Show("已取消自動修正!!"); } }
private void dataGridViewX1_UserDeletingRow(object sender, DataGridViewRowCancelEventArgs e) { DialogResult dr = MsgBox.Show("您確定於封存資料中,刪除選擇之書面記錄(輔導)?", MessageBoxButtons.YesNo, MessageBoxDefaultButton.Button2); if (dr == DialogResult.No) { MsgBox.Show("已中止刪除資料!"); e.Cancel = true; } else { //說明: //CurrentRow的TAG內存之UID / 是WriteCounselingUDT的UID //欲取得GraduateUDT資料,需要先取得WriteCounselingUDT //後由WriteCounselingUDT的RefUDT_ID取得GraduateUDT資料 List <string> uidList = new List <string>(); foreach (DataGridViewRow each in dataGridViewX1.SelectedRows) { string UID = "" + each.Cells[0].Tag; if (!string.IsNullOrEmpty(UID)) { uidList.Add(UID); } } //取得所選的書面資料 List <WriteCounselingUDT> listUDT2 = _AccessHelper.Select <WriteCounselingUDT>(UDT_S.PopOneCondition("UID", uidList)); if (listUDT2.Count > 0) { StringBuilder sb = new StringBuilder(); sb.Append("班級「" + _StudentUdt.ClassName + "」"); sb.Append("座號「" + (_StudentUdt.SeatNo.HasValue ? _StudentUdt.SeatNo.Value.ToString() : "") + "」"); sb.Append("姓名「" + _StudentUdt.Name + "」"); sb.AppendLine("學號「" + _StudentUdt.StudentNumber + "」"); foreach (WriteCounselingUDT each in listUDT2) { sb.AppendLine("已刪除書面(輔導)資料「" + each.Name + each.Format + "」"); } _AccessHelper.DeletedValues(listUDT2.ToArray()); ApplicationLog.Log("畢業生檔案檢索.書面資料(輔導)", "刪除", sb.ToString()); MsgBox.Show("已刪除所選書面資料(輔導)"); e.Cancel = true; OnPrimaryKeyChanged(null); } else { MsgBox.Show("刪除書面資料發生錯誤!"); e.Cancel = true; } } }
public void BGW_DoWork(object sender, DoWorkEventArgs e) { try { int progress = 10; AccessHelper access = new AccessHelper(); List <UDT.SubjectClassSelection> scsNewList = access.Select <UDT.SubjectClassSelection>(); // 讀取要修改的科目資料 CheckState != Indeterminate List <string> subjectIDList = new List <string>(); foreach (DataGridViewRow dr in dataGridViewX1.Rows) { if ("" + dr.Cells[0].Value != "Indeterminate") { subjectIDList.Add("" + dr.Tag); } } BGW.ReportProgress(progress); // 刪除舊資料(班級選課管理):刪除CheckState != Indeterminate 的資料 string subjectIDs = string.Join(",", subjectIDList); foreach (var _class in classDic) { progress += 40 / classDic.Count; BGW.ReportProgress(progress); List <UDT.SubjectClassSelection> scsOLDList = access.Select <UDT.SubjectClassSelection>("ref_class_id = " + _class.Key + " AND ref_subject_id IN(" + subjectIDs + ")"); access.DeletedValues(scsOLDList); } // 新增資料(班級選課管理):新增CheckState == Checked 的資料 foreach (DataGridViewRow dr in dataGridViewX1.Rows) { progress += 60 / dataGridViewX1.Rows.Count; BGW.ReportProgress(progress); // 勾選的科目 if ("" + dr.Cells[0].Value == "Checked") { // 班級 foreach (var _class in classDic) { UDT.SubjectClassSelection scs = new UDT.SubjectClassSelection(); scs.RefSubjectID = int.Parse("" + dr.Tag); scs.RefClassID = int.Parse(_class.Key); scsNewList.Add(scs); } } } // 儲存新資料 scsNewList.SaveAll(); } catch (Exception ex) { e.Result = ex; } }
/// <summary> /// 儲存 /// </summary> private void buttonX1_Click(object sender, EventArgs e) { int x = 1; DSXmlHelper dsx = new DSXmlHelper("xml"); foreach (DataGridViewRow row in dataGridViewX1.Rows) { if (row.IsNewRow) { continue; } foreach (DataGridViewCell cell in row.Cells) { if (cell is DataGridViewComboBoxExCell) { string name = "" + cell.Value; if (ClubDic.ContainsKey(name)) { CLUBRecord cr = ClubDic[name]; dsx.AddElement("Club"); dsx.SetAttribute("Club", "Index", x.ToString()); dsx.SetAttribute("Club", "Ref_Club_ID", cr.UID); x++; } } } } List <string> list = K12.Presentation.NLDPanels.Student.SelectedSource; List <StudentRecord> StudentList = Student.SelectByIDs(list); List <VolunteerRecord> VolList = new List <VolunteerRecord>(); List <VolunteerRecord> DelList = _A.Select <VolunteerRecord>(string.Format("ref_student_id in ('{0}')", string.Join("','", list))); foreach (StudentRecord stud in StudentList) { VolunteerRecord Vol = new VolunteerRecord(); Vol.SchoolYear = integerInput1.Value; Vol.Semester = integerInput2.Value; Vol.RefStudentID = stud.ID; Vol.Content = dsx.BaseElement.OuterXml; VolList.Add(Vol); } _A.DeletedValues(DelList); //清掉選擇學生的社團記錄 _A.InsertValues(VolList); //新增 MsgBox.Show("儲存完成!!"); }
/// <summary> /// 按年級計算各班該年級排名 /// </summary> public void Execute() { AccessHelper access = new AccessHelper(); // 0.刪除學年度、學期、週次的週排行資料 List <UDT.WeeklyRank> listRank = access.Select <UDT.WeeklyRank>(string.Format("school_year = {0} AND semester = {1} AND week_number = {2}", this._schoolYear, this._semester, this._weekNo)); access.DeletedValues(listRank); // 1.對於每個年級 foreach (int grade in _dicAllClassByGrade.Keys) { List <UDT.WeeklyStats> weeklyStats = new List <UDT.WeeklyStats>(); // 建立分數名次清單 List <int> listScoreRank = new List <int>(); // 2.找出該年級所有班級 foreach (ClassRecord _class in _dicAllClassByGrade[grade]) { // 3.找出班級週統計成績 weeklyStats.Add(this._dicWeeklyStatsByClassID[_class.ID]); listScoreRank.Add(this._dicWeeklyStatsByClassID[_class.ID].WeekTotal); } // 4.計算排名 // 4.0 排序分數名次清單 //listScoreRank.OrderByDescending(score => score).ToList(); //listScoreRank.Sort(); listScoreRank = listScoreRank.OrderByDescending(x => x).ToList(); //List<UDT.WeeklyStats> result = weeklyStats.OrderByDescending(x => x.WeekTotal).ToList(); //int n = 1; foreach (UDT.WeeklyStats ws in weeklyStats) { // 找出分數所對應的排名 int rank = listScoreRank.IndexOf(ws.WeekTotal) + 1; // 4.1 建立排名物件 UDT.WeeklyRank wr = this.createRankObject(ws, rank, grade); // 5. 判斷是否前5週連2 checkIfTop2In5Weeks(wr); // 6. 判斷是否連8週前三 checkIfTop3In8Weeks(wr); _listUpdateWeeklyRank.Add(wr); //n++; } } // 5.寫入資料庫 access.InsertValues(_listUpdateWeeklyRank); }
/// <summary> /// 刪除綜合紀錄表 複選記錄 /// </summary> /// <param name="dataList"></param> public static void ABUDTMultipleRecordDelete(List<UDTMultipleRecordDef> dataList) { if (dataList.Count > 0) { AccessHelper accHelper = new AccessHelper(); foreach (UDTMultipleRecordDef data in dataList) data.Deleted = true; accHelper.DeletedValues(dataList); } }
/// <summary> /// 刪除ABCard樣板內容 /// </summary> /// <param name="RecList"></param> public static void DeleteABCardTemplate(List <UDT_ABCardTemplateDefinitionDef> RecList) { AccessHelper accHelper = new AccessHelper(); foreach (UDT_ABCardTemplateDefinitionDef rec in RecList) { rec.Deleted = true; } accHelper.DeletedValues(RecList); }
/// <summary> /// 刪除設定資料 /// </summary> /// <param name="dataList"></param> public static void DeleteConfigData(List <UDT_ScoreConfig> dataList) { foreach (UDT_ScoreConfig data in dataList) { data.Deleted = true; } AccessHelper accessHelper = new AccessHelper(); accessHelper.DeletedValues(dataList); }
/// <summary> /// 刪除國籍中英文對照UDT /// </summary> /// <param name="dataList"></param> public static void UDTNationalityMappingDelete(List <UDT_NationalityMapping> dataList) { foreach (UDT_NationalityMapping data in dataList) { data.Deleted = true; } AccessHelper accessHelper = new AccessHelper(); accessHelper.DeletedValues(dataList); }
/// <summary> /// 刪除多筆建議重修名單 /// </summary> /// <param name="dataList"></param> public static void UDTSuggestListDelete(List<UDTSuggestListDef> dataList) { if (dataList.Count > 0) { foreach (UDTSuggestListDef data in dataList) data.Deleted = true; AccessHelper accessHelper = new AccessHelper(); accessHelper.DeletedValues(dataList); } }
private void btnSave_Click(object sender, EventArgs e) { _new.Clear(); if (ValidateData()) { List <GpaRef> insert = new List <GpaRef>(); foreach (DataGridViewRow row in dgv.Rows) { if (row.IsNewRow) { continue; } string schoolYear = row.Cells[colSchoolYear.Index].Value + ""; string semester = row.Cells[colSemester.Index].Value + ""; string grade = row.Cells[colGrade.Index].Value + ""; string max = row.Cells[colMax.Index].Value + ""; string avg = row.Cells[colAvg.Index].Value + ""; decimal d; GpaRef gr = new GpaRef(); gr.SchoolYear = int.Parse(schoolYear); gr.Semester = int.Parse(semester); gr.Grade = int.Parse(grade); gr.Max = decimal.TryParse(max, out d) ? d : 0; gr.Avg = decimal.TryParse(avg, out d) ? d : 0; insert.Add(gr); string key1 = schoolYear + "學年度" + semester + "學期" + grade + "年級最高GPA"; string key2 = schoolYear + "學年度" + semester + "學期" + grade + "年級平均GPA"; if (!_new.ContainsKey(key1)) { _new.Add(key1, max); } if (!_new.ContainsKey(key2)) { _new.Add(key2, avg); } } _A.DeletedValues(_Records); _A.InsertValues(insert); FiscaLogWriter(); MessageBox.Show("儲存完成"); LoadData(); } else { MessageBox.Show("資料有誤,請確認後再儲存"); } }
/// <summary> /// 刪除設定檔 /// </summary> /// <param name="dataList"></param> public static void UDTConfigDelete(List <UDTConfig> dataList) { if (dataList.Count > 0) { foreach (UDTConfig data in dataList) { data.Deleted = true; } AccessHelper accessHelper = new AccessHelper(); accessHelper.DeletedValues(dataList); } }
/// <summary> /// 刪除學生體適能資料 /// </summary> /// <param name="DataList"></param> public static void UDTStudentFitnessRecordListDelete(List<UDT_StudentFitnessRecord> DataList) { if (DataList.Count > 0) { foreach (UDT_StudentFitnessRecord data in DataList) { // Deleted 設成 true 才會真刪除 data.Deleted = true; } AccessHelper accessHelper = new AccessHelper(); accessHelper.DeletedValues(DataList); } }
/// <summary> /// 刪除比序績分主檔 /// </summary> /// <param name="dataList"></param> public static void UDTEnrolmentExcessCreditsDelete(List <UDT_EnrolmentExcessCredits> dataList) { if (dataList.Count > 0) { foreach (UDT_EnrolmentExcessCredits data in dataList) { data.Deleted = true; } AccessHelper accessHelper = new AccessHelper(); accessHelper.DeletedValues(dataList); } }
/// <summary> /// 刪除學生體適能資料 /// </summary> /// <param name="DataList"></param> public static void DeleteByRecordList(List <StudentFitnessRecord> DataList) { if (DataList.Count > 0) { foreach (StudentFitnessRecord data in DataList) { // Deleted 設成 true 才會真刪除 data.Deleted = true; } AccessHelper accessHelper = new AccessHelper(); accessHelper.DeletedValues(DataList); } }
private void btnDelete_Click(object sender, EventArgs e) { if (_RunningItem != null) { if (MessageBox.Show("確認刪除: " + _RunningItem.Name + " ?", "ishcool", MessageBoxButtons.OKCancel) == System.Windows.Forms.DialogResult.OK) { List <ExamTemplateRecord> delete = new List <ExamTemplateRecord>(); delete.Add(_RunningItem); _A.DeletedValues(delete); ReLoad(); } } }
/// <summary> /// 刪除學生體適能資料 /// </summary> /// <param name="rec"></param> public static void DeleteByRecord(StudentFitnessRecord rec) { if (rec != null) { // Deleted 設成 true 才會真刪除 rec.Deleted = true; List <StudentFitnessRecord> recList = new List <StudentFitnessRecord>(); recList.Add(rec); AccessHelper accessHelper = new AccessHelper(); accessHelper.DeletedValues(recList); } }
/// <summary> /// 重設 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { try { AccessHelper _A = new AccessHelper(); List <UpdateRecordReportUDT> UDTlist = _A.Select <UpdateRecordReportUDT>(); _A.DeletedValues(UDTlist); //清除UDT資料 dataGridViewX1.Rows.Clear(); //清除datagridview資料 LoadLastRecord(); //再次讀入Mapping設定 } catch { MessageBox.Show("網路或資料庫異常,請稍後再試..."); } }
private void btnSave_Click(object sender, EventArgs e) { if (DateTimeParse()) { if (!Compare()) { List <DTScore> list = new List <DTScore>(); DTScore each = new DTScore(); each.Start = DateTime.Parse(tbStartDateTime.Text); each.End = DateTime.Parse(tbEndDateTime.Text); list.Add(each); try { //刪掉原有資料 _AccessHelper.DeletedValues(Low_DTClubList); //New _AccessHelper.InsertValues(list); //LOG StringBuilder sb = new StringBuilder(); sb.AppendLine("已修改成績輸入時間"); string start = each.Start.HasValue ? each.Start.Value.ToString("yyyy/MM/dd HH:mm") : ""; string end = each.End.HasValue ? each.End.Value.ToString("yyyy/MM/dd HH:mm") : ""; sb.AppendLine(string.Format("開始時間「{0}」結束時間「{1}」", start, end)); FISCA.LogAgent.ApplicationLog.Log("社團", "修改成績輸入時間", sb.ToString()); } catch (Exception ex) { MsgBox.Show("儲存失敗!!\n" + ex.Message); SmartSchool.ErrorReporting.ReportingService.ReportException(ex); return; } MsgBox.Show("儲存成功!!"); this.Close(); } else { MsgBox.Show("[結束時間]不可小於[開始時間]!!"); return; } } else { MsgBox.Show("請輸入正確資料\n再進行儲存動作!!"); return; } }
// 複製評分紀錄 public static void SnapshotScoreSheet(List <string> listScoreSheetID) { AccessHelper access = new AccessHelper(); // 取得原快照資料並刪除 if (listScoreSheetID.Count > 0) { access.DeletedValues(access.Select <UDT.SnapshotScoreSheet>(string.Format("ref_score_sheet_id IN({0})", string.Join(",", listScoreSheetID)))); // 取得計算週排名的評分紀錄 List <UDT.ScoreSheet> listData = access.Select <UDT.ScoreSheet>(string.Format("uid IN({0})", string.Join(",", listScoreSheetID))); List <UDT.SnapshotScoreSheet> listInsertData = new List <UDT.SnapshotScoreSheet>(); // Data Sync foreach (UDT.ScoreSheet data in listData) { UDT.SnapshotScoreSheet ss = new UDT.SnapshotScoreSheet(); ss.RefScoreSheetID = int.Parse(data.UID); ss.SchoolYear = data.SchoolYear; ss.Semester = data.Semester; ss.RefPeriodID = data.RefPeriodID; ss.RefPlaceID = data.RefPlaceID; ss.RefDeductionItemID = data.RefDeductionItemID; ss.RefDeductionStandardID = data.RefDeductionStandardID; ss.Remark = data.Remark; ss.Picture1 = data.Picture1; ss.Pic1Comment = data.Pic1Comment; ss.Pic1Size = data.Pic1Size; ss.Pic1LocalUrl = data.Pic1LocalUrl; ss.Picture2 = data.Picture2; ss.Pic2Comment = data.Pic2Comment; ss.Pic2Size = data.Pic2Size; ss.Pic2LocalUrl = data.Pic2LocalUrl; ss.Acount = data.Acount; ss.CreateTime = data.CreateTime; ss.LastUpdateName = data.LastUpdateName; ss.LastUpdateBy = data.LastUpdateBy; ss.CheckedTime = data.CheckedTime; ss.CheckedName = data.CheckedName; ss.CanceledBy = data.CanceledBy; ss.CanceledReason = data.CanceledReason; listInsertData.Add(ss); } // 新增快照資料 access.InsertValues(listInsertData); } }
private void calculateRank() { // 1.刪除學年度學期 學期排名資料 AccessHelper access = new AccessHelper(); List <UDT.SemesterRank> listSemesterRank = access.Select <UDT.SemesterRank>(string.Format("school_year ={0} AND semester = {1}", this._schoolYear, this._semester)); access.DeletedValues(listSemesterRank); // 2.按年級排名 for (int gradeYear = 1; gradeYear <= 3; gradeYear++) { List <UDT.SemesterStats> listSemesterStats = _dicSemesterStatsByGradeYear[gradeYear]; //建立分數名次清單 // 計算規則: 名次加總*100 - 週總分平均 List <int> listScore = new List <int>(); foreach (UDT.SemesterStats semesterStats in _dicSemesterStatsByGradeYear[gradeYear]) { int score = semesterStats.RankTotal * 100 - semesterStats.AverageScore; listScore.Add(score); } listScore = listScore.OrderBy(e => e).ToList(); // 遞增排: 最小的為第一名 foreach (UDT.SemesterStats ss in listSemesterStats) { int rank = listScore.IndexOf(ss.RankTotal * 100 - ss.AverageScore) + 1; // 建立排名物件 UDT.SemesterRank sr = new UDT.SemesterRank(); sr.RefSemesterStatsID = int.Parse(ss.UID); sr.SchoolYear = ss.SchoolYear; sr.Semester = ss.Semester; sr.RefClassID = ss.RefClassID; sr.GradeYear = ss.GradeYear; sr.CreateTime = DateTime.Now; sr.RankTotal = ss.RankTotal; sr.AverageScore = ss.AverageScore; sr.Rank = rank; sr.CreatedBy = this._userAccount; this.listInsertSemesterRank.Add(sr); } } // 資料庫更新 access.InsertValues(listInsertSemesterRank); }
/// <summary> /// 更新設定 /// </summary> /// <param name="rec"></param> public static void SaveByRecordList(List <TagMappingRecord> recList) { List <TagMappingRecord> dataList = new List <TagMappingRecord>(); AccessHelper accessHelper = new AccessHelper(); // 先刪除所有資料 dataList = accessHelper.Select <TagMappingRecord>(); accessHelper.DeletedValues(dataList); if (recList.Count > 0) { // 新增此次所有資料 accessHelper.InsertValues(recList); } }
/// <summary> /// 更新設定 /// </summary> /// <param name="rec"></param> public static void SaveByRecordList(List<TagMappingRecord> recList) { List<TagMappingRecord> dataList = new List<TagMappingRecord>(); AccessHelper accessHelper = new AccessHelper(); // 先刪除所有資料 dataList = accessHelper.Select<TagMappingRecord>(); accessHelper.DeletedValues(dataList); if (recList.Count > 0) { // 新增此次所有資料 accessHelper.InsertValues(recList); } }
private void calculateScore() { // 1.刪除學年度學期的學期統計資料 AccessHelper access = new AccessHelper(); List <UDT.SemesterStats> listSemesterStats = access.Select <UDT.SemesterStats>(string.Format("school_year = {0} AND semester = {1}", _schoolYear, _semester)); access.DeletedValues(listSemesterStats); // 2.針對每個班級 foreach (string classID in this._dicWeeklyRankByClassID.Keys) { int rankTotal = 0; int totalScore = 0; int averageScore = 0; int weekNo = 0; int gradeYear = 0; // 2.1 找出該班級所有週排名資料 foreach (UDT.WeeklyRank weeklyRank in this._dicWeeklyRankByClassID[classID]) { // 2.2 計算學期週排名次加總 rankTotal += weeklyRank.Rank; // 2.3 計算學期週排總分平均 totalScore += weeklyRank.WeekTotal; gradeYear = weeklyRank.GradeYear; weekNo++; } averageScore = totalScore / weekNo; UDT.SemesterStats stats = new UDT.SemesterStats(); stats.SchoolYear = int.Parse(_schoolYear); stats.Semester = int.Parse(_semester); stats.RefClassID = int.Parse(classID); stats.GradeYear = gradeYear; stats.RankTotal = rankTotal; stats.AverageScore = averageScore; stats.CreateTime = DateTime.Now; stats.CreatedBy = _userAccount; listInsertSemesterStats.Add(stats); } // 寫入資料庫 access.InsertValues(listInsertSemesterStats); }
private void SaveBtn_Click(object sender, EventArgs e) { AccessHelper access = new AccessHelper(); List <AbsenceUDT> absenceList = access.Select <AbsenceUDT>(); access.DeletedValues(absenceList); List <AbsenceUDT> InsertAbList = new List <AbsenceUDT>(); foreach (DataGridViewRow dr in dataGridViewX1.Rows) { AbsenceUDT udt = new AbsenceUDT(); List <string> jsonList = new List <string>(); for (int i = 2; i < dr.Cells["actor"].ColumnIndex; i++) { if (dr.Cells[i].Value != null) { if (bool.Parse("" + dr.Cells[i].Value) == true) { string name = dataGridViewX1.Columns[i].HeaderText; string abbr = dataGridViewX1.Columns[i].Name; jsonList.Add("{" + string.Format("\"Abbr\":\"{0}\",\"Name\":\"{1}\"", abbr, name) + "}"); } } } if (jsonList.Count > 0) { udt.Absence = "[" + string.Join(",", jsonList) + "]"; udt.Period = "" + dr.Cells["period"].Value; InsertAbList.Add(udt); } udt.Actor = "" + dr.Cells["actor"].Value; udt.StarTime = DateTime.Parse(("" + dr.Cells["star_time"].Value) == "" ? "00:00:00" : ("" + dr.Cells["star_time"].Value)); udt.EndTime = DateTime.Parse(("" + dr.Cells["end_time"].Value) == "" ? "00:00:00" : ("" + dr.Cells["end_time"].Value)); } access.InsertValues(InsertAbList); MsgBox.Show("儲存成功!!"); this.Close(); }
private void calculateScore() { // 0. 刪除日期區間週統計 AccessHelper access = new AccessHelper(); List <UDT.WeeklyStats> listWeeklyStats = access.Select <UDT.WeeklyStats>(string.Format("school_year = {0} AND semester = {1} AND week_number = {2}", this._schoolYear, this._semester, this._weekNo)); access.DeletedValues(listWeeklyStats); // 1. 針對每個班級 foreach (string classID in dicClassDataByID.Keys) { decimal score = _baseScore; // 1.1 找出該班級的所有評分紀錄 if (dicRecordsByClassID.ContainsKey(classID)) { // 1.2 計算總分 foreach (UDT.ScoreSheet sheet in dicRecordsByClassID[classID]) { if (this._listExistCheckItem.Contains("" + sheet.RefCheckItemID))// 如果評分項目存在系統的話採計扣分 { score += sheet.Score; } } } UDT.WeeklyStats weeklyStats = new UDT.WeeklyStats(); weeklyStats.SchoolYear = int.Parse(this._schoolYear); weeklyStats.semester = int.Parse(this._semester); weeklyStats.RefClassID = int.Parse(classID); weeklyStats.GradeYear = int.Parse("" + dicClassDataByID[classID]["grade_year"]); weeklyStats.WeekTotal = (int)score; weeklyStats.WeekNumber = this._weekNo; weeklyStats.CreateTime = DateTime.Now; weeklyStats.CreatedBy = ""; weeklyStats.StartDate = this._startDate; weeklyStats.EndDate = this._endDate; _listInsertWeeklyStats.Add(weeklyStats); } // 1.3 更新資料庫 access.InsertValues(_listInsertWeeklyStats); }
private void button4_Click(object sender, EventArgs e) { if (MessageBox.Show("您確定要刪除這個系所組別?", "注意!", MessageBoxButtons.YesNo, MessageBoxIcon.Information) != System.Windows.Forms.DialogResult.Yes) return; List<ActiveRecord> recs = new List<ActiveRecord>(); foreach(DataGridViewRow row in this.dataGridView1.SelectedRows) { recs.Add((UDT.DepartmentGroup)row.Tag); } AccessHelper ah = new AccessHelper(); try { ah.DeletedValues(recs); this.RefreshData(); } catch (Exception ex) { Util.ShowMsg("刪除科目資料時發生錯誤!", "注意!"); } }
/// <summary> /// 刪除多筆學生輔導老師 /// </summary> /// <param name="CounselStudent_List"></param> public void DeleteCounselStudentList(List<DAO.UDT_CounselStudent_ListDef> CounselStudent_List) { List<UDT_CounselStudent_ListDef> DelCounselStudentList = new List<UDT_CounselStudent_ListDef>(); foreach (UDT_CounselStudent_ListDef rec in CounselStudent_List) { rec.Deleted = true; DelCounselStudentList.Add(rec); } AccessHelper accessHelper = new AccessHelper(); accessHelper.DeletedValues(DelCounselStudentList.ToArray()); }
/// <summary> /// 刪除 UDT_StudTypeWeight 內資料 /// </summary> /// <param name="data"></param> public static void DeleteDataToUDT_StudTypeWeight(List<UserDefData_StudTypeWeight> data) { AccessHelper accHelper = new AccessHelper(); accHelper.DeletedValues(data.ToArray()); }
/// <summary> /// 刪除單筆關懷 /// </summary> /// <param name="CareRecordDef"></param> public void DeleteCareRecord(UDT_CounselCareRecordDef CareRecordDef) { AccessHelper accHelper = new AccessHelper(); List<UDT_CounselCareRecordDef> CareRecordDefList = new List<UDT_CounselCareRecordDef>(); CareRecordDef.Deleted = true; CareRecordDefList.Add(CareRecordDef); accHelper.DeletedValues(CareRecordDefList.ToArray()); }
private static void DeleteCourse() { if (RetakeAdmin.Instance.SelectedSource.Count > 0) { DialogResult dr = MsgBox.Show("您確定要刪除課程?\n\n本功能將會串連刪除:\n(課程,修課學生,成績,缺曠)", MessageBoxButtons.YesNo, MessageBoxDefaultButton.Button2); if (dr == DialogResult.Yes) { AccessHelper _accessHelper = new AccessHelper(); //刪缺曠 List<UDTAttendanceDef> attendanceList = _accessHelper.Select<UDTAttendanceDef>("ref_course_id in ('" + string.Join("','", RetakeAdmin.Instance.SelectedSource) + "')"); _accessHelper.DeletedValues(attendanceList); //時間區間 List<UDTTimeSectionDef> timeSectionList = _accessHelper.Select<UDTTimeSectionDef>("ref_course_id in ('" + string.Join("','", RetakeAdmin.Instance.SelectedSource) + "')"); _accessHelper.DeletedValues(timeSectionList); //刪學生 List<UDTScselectDef> cselectList = _accessHelper.Select<UDTScselectDef>("ref_course_id in ('" + string.Join("','", RetakeAdmin.Instance.SelectedSource) + "')"); _accessHelper.DeletedValues(cselectList); //刪課程 List<UDTCourseDef> courseList = _accessHelper.Select<UDTCourseDef>("UID in ('" + string.Join("','", RetakeAdmin.Instance.SelectedSource) + "')"); _accessHelper.DeletedValues(courseList); MsgBox.Show("刪除成功!!"); RetakeEvents.RaiseAssnChanged(); } } else { MsgBox.Show("請選擇課程!!"); } }
/// <summary> /// 刪除輔導系統設定內容 /// </summary> /// <param name="RecList"></param> public static void DeleteSystemList(List<UDT_SystemListDef> RecList) { AccessHelper accessHelper = new AccessHelper(); foreach (UDT_SystemListDef rec in RecList) rec.Deleted = true; accessHelper.DeletedValues(RecList); }
/// <summary> /// 刪除學生體適能資料 /// </summary> /// <param name="rec"></param> public static void DeleteByRecord(StudentFitnessRecord rec) { if (rec != null) { // Deleted 設成 true 才會真刪除 rec.Deleted = true; List<StudentFitnessRecord> recList = new List<StudentFitnessRecord>(); recList.Add(rec); AccessHelper accessHelper = new AccessHelper(); accessHelper.DeletedValues(recList); } }
/// <summary> /// 刪除多筆輔導使用者自訂欄位 /// </summary> /// <param name="dataList"></param> public void DeleteCounselUserDefineDataList(List<UDT_CounselUserDefDataDef> dataList) { List<UDT_CounselUserDefDataDef> dtList = new List<UDT_CounselUserDefDataDef>(); foreach (UDT_CounselUserDefDataDef rec in dataList) { rec.Deleted = true; dtList.Add(rec); } AccessHelper accessHelper = new AccessHelper(); accessHelper.DeletedValues(dtList); }
/// <summary> /// 刪除多筆課表 /// </summary> /// <param name="dataList"></param> public static void UDTCourseTimetableDelete(List<UDTCourseTimetableDef> dataList) { if (dataList.Count > 0) { AccessHelper accessHelper = new AccessHelper(); foreach (UDTCourseTimetableDef data in dataList) data.Deleted = true; accessHelper.DeletedValues(dataList); } }
/// <summary> /// 刪除ABCard樣板內容 /// </summary> /// <param name="RecList"></param> public static void DeleteABCardTemplate(List<UDT_ABCardTemplateDefinitionDef> RecList) { AccessHelper accHelper = new AccessHelper(); foreach (UDT_ABCardTemplateDefinitionDef rec in RecList) rec.Deleted = true; accHelper.DeletedValues(RecList); }
/// <summary> /// 刪除 成績輸入時間 /// </summary> /// <param name="dataList"></param> public static void UDTScoreInputDateDelete(List<UDTScoreInputDateDef> dataList) { AccessHelper accessHelper = new AccessHelper(); foreach (UDTScoreInputDateDef data in dataList) data.Deleted = true; accessHelper.DeletedValues(dataList); }
/// <summary> /// 刪除成績計算比例原則 /// </summary> /// <param name="dataList"></param> public static void UDTWeightProportionDelete(List<UDTWeightProportionDef> dataList) { foreach (UDTWeightProportionDef data in dataList) data.Deleted = true; AccessHelper _accessHelper = new AccessHelper(); _accessHelper.DeletedValues(dataList); }
//原本被標為退選的,按下退選後沒有反應。 //原本被標為加選的,按下退選後刪除該加退選紀錄。 //原本沒有標示的,按下退選後會加入一筆退選紀錄。 private void btnRemove_Click(object sender, EventArgs e) { if (this.dataGridViewX1.SelectedRows.Count < 1) { return; } List<ActiveRecord> addRecs = new List<ActiveRecord>(); List<ActiveRecord> delRecs = new List<ActiveRecord>(); this.btnRemove.Enabled = false; foreach (DataGridViewRow row in this.dataGridViewX1.SelectedRows) { SHCourseRecord course = (SHCourseRecord)row.Tag; if (row.Cells[0].Value.ToString() == "") { UDT.AddDropCourse ad = new UDT.AddDropCourse(); ad.CourseID = int.Parse(course.ID); ad.StudentID = int.Parse(this.PrimaryKey); ad.AddOrDrop = this.dropCourse; addRecs.Add(ad); } if (row.Cells[0].Value.ToString() == this.addCourse) { UDT.AddDropCourse ad = this.dicAddDropList[course.ID]; delRecs.Add(ad); } } try { AccessHelper ah = new AccessHelper(); if (delRecs.Count > 0) ah.DeletedValues(delRecs); if (addRecs.Count > 0) ah.InsertValues(addRecs); this.OnPrimaryKeyChanged(EventArgs.Empty); this.saveLogs(delRecs, addRecs); } catch (Exception ex) { Util.ShowMsg(ex.Message, "退選課程"); this.btnRemove.Enabled = true; } //this.btnRemove.Enabled = true; }
/// <summary> /// 刪除測驗資料 /// </summary> /// <param name="QuizName"></param> public void DeleteQuizData(UDT_QuizDef QuizData) { AccessHelper accHelper = new AccessHelper(); QuizData.Deleted = true; List<UDT_QuizDef> delList = new List<UDT_QuizDef>(); delList.Add(QuizData); accHelper.DeletedValues(delList.ToArray()); }
/// <summary> /// 刪除一筆 UDT 晤談紀錄 /// </summary> /// <param name="StudentInterviewRecord"></param> public void DeleteCounselStudentInterviewRecord(DAO.UDT_CounselStudentInterviewRecordDef StudentInterviewRecord) { StudentInterviewRecord.Deleted = true; AccessHelper accHelper = new AccessHelper(); List<UDT_CounselStudentInterviewRecordDef> delList = new List<UDT_CounselStudentInterviewRecordDef>(); delList.Add(StudentInterviewRecord); accHelper.DeletedValues(delList.ToArray()); }
/// <summary> /// 刪除多筆學生測驗 /// </summary> /// <param name="studQuizDataList"></param> /// <param name="isInsert"></param> public void DeleteStudQuizDataLlist(List<UDT_StudQuizDataDef> studQuizDataList) { AccessHelper accHelper = new AccessHelper(); foreach (UDT_StudQuizDataDef rec in studQuizDataList) rec.Deleted = true; accHelper.DeletedValues(studQuizDataList.ToArray()); }
/// <summary> /// 刪除 UDT 內資料 /// </summary> /// <param name="data"></param> public static void DeleteDataToUDT(List<DAL.UserDefData> data) { AccessHelper accHelper = new AccessHelper(); accHelper.DeletedValues(data.ToArray()); }
/// <summary> /// 刪除多筆修課 /// </summary> /// <param name="DataList"></param> public static void UDTSCSelectDelete(List<UDTScselectDef> DataList) { if (DataList.Count > 0) { AccessHelper accessHelper = new AccessHelper(); foreach (UDTScselectDef data in DataList) data.Deleted = true; accessHelper.DeletedValues(DataList); } }
protected override void OnSaveData() { if (!this.is_validated()) { MessageBox.Show("請先修正錯誤再儲存。"); return; } //Delete All Records List<ActiveRecord> deleteRecs = new List<ActiveRecord>(); foreach (UDT.CourseInstructor ci in this.records) { deleteRecs.Add(ci); } //Save new Record List<ActiveRecord> insertRecs = new List<ActiveRecord>(); foreach (DataGridViewRow row in this.dataGridViewX1.Rows) { if (!row.IsNewRow) { UDT.CourseInstructor ins = new UDT.CourseInstructor(); //SHSchool.Data.SHTCInstructRecord tcr = new SHTCInstructRecord(); ins.CourseID = int.Parse(this.PrimaryKey); ins.TeacherID = int.Parse(row.Cells[1].Value.ToString()); ins.TagID = int.Parse(row.Cells[0].Value.ToString()); //ins.Role = row.Cells[1].Value.ToString(); //此欄位已不再使用。2012/3/16, kevin. ins.IsScored = (row.Cells["IsScored"].Value != null && (bool)row.Cells["IsScored"].Value); /* if (row.Cells["IsScored"].Value != null && (bool)row.Cells["IsScored"].Value) { // item is checked ins.IsScored = true; } else { // item is null ins.IsScored = false; } */ insertRecs.Add(ins); } } AccessHelper ah = new AccessHelper(); //delete //if (this.deletedList.Count > 0) ah.DeletedValues(deleteRecs); //insert if (insertRecs.Count > 0) ah.SaveAll(insertRecs); this.OnPrimaryKeyChanged(EventArgs.Empty); ResetDirtyStatus(); /* ==== Log for deleted records =====*/ /* foreach (UDT.CourseInstructor ci in this.records) { Log.LogAgent agt = new Log.LogAgent(); agt.ActionType = Log.LogActionType.Delete; this.AddLog(ci, agt); agt.Save("授課教師.課程", "刪除","", Log.LogTargetCategory.Course, ci.CourseID.ToString()); } * */ /* ==== Log for inserted records =====*/ K12.Data.CourseRecord course = K12.Data.Course.SelectByID(this.PrimaryKey); StringBuilder sb = new StringBuilder(string.Format("課程「{0}」,學年度「{1}」,學期「{2}」 \n", course.Name, course.SchoolYear, EMBACore.DataItems.SemesterItem.GetSemesterByCode(course.Semester + "").Name)); sb.Append("授課教師更改為: \n"); foreach (UDT.CourseInstructor ci in insertRecs) { string teacherName = this.dicTeachers[ci.TeacherID.ToString()].Name; string role = this.dicTags[ci.TagID.ToString()].TagFullName; sb.Append(string.Format("教師:{0} , 角色:{1} , 成績管理:{2} \n ", teacherName, role, ci.IsScored ? "是" : "否")); //Log.LogAgent agt = new Log.LogAgent(); //agt.ActionType = Log.LogActionType.AddNew; //this.AddLog(ci, agt); //agt.Save("授課教師.課程", "新增", "", Log.LogTargetCategory.Course, ci.CourseID.ToString()); } FISCA.LogAgent.ApplicationLog.Log("課程.資料項目.教授 / 助教 / 助理", "修改", "course", this.PrimaryKey, sb.ToString()); }
private void btnAdd_Click(object sender, EventArgs e) { if (this.dataGridViewX2.SelectedRows.Count < 1) { return; } List<ActiveRecord> addRecs = new List<ActiveRecord>(); List<ActiveRecord> delRecs = new List<ActiveRecord>(); this.btnAdd.Enabled = false; foreach (DataGridViewRow row in this.dataGridViewX2.SelectedRows) { SHCourseRecord course = (SHCourseRecord)row.Tag; //如果原本是被標註退選的,應該要把該退選紀錄移除 if (this.dicAddDropList.ContainsKey(course.ID)) { if (this.dicAddDropList[course.ID].AddOrDrop.ToUpper() == this.dropCourse) { delRecs.Add(this.dicAddDropList[course.ID]); } } else { UDT.AddDropCourse ad = new UDT.AddDropCourse(); ad.StudentID = int.Parse(this.PrimaryKey); ad.CourseID = int.Parse(course.ID); ad.AddOrDrop = this.addCourse; addRecs.Add(ad); } } try { AccessHelper ah = new AccessHelper(); if (delRecs.Count > 0) ah.DeletedValues(delRecs); if (addRecs.Count > 0) ah.InsertValues(addRecs); this.OnPrimaryKeyChanged(EventArgs.Empty); this.saveLogs(delRecs, addRecs); } catch (Exception ex) { Util.ShowMsg(ex.Message, "加選課程"); this.btnAdd.Enabled = true; } //this.btnAdd.Enabled = true ; //應該要等資料讀取完後才 enabled, 2012/5/2, kevin. }
private void button4_Click(object sender, EventArgs e) { if (MessageBox.Show("您確定要刪除這個科目?", "注意!", MessageBoxButtons.YesNo, MessageBoxIcon.Information) != System.Windows.Forms.DialogResult.Yes) return; StringBuilder sb = new StringBuilder("刪除科目如下:"); List<ActiveRecord> recs = new List<ActiveRecord>(); foreach(DataGridViewRow row in this.dataGridView1.SelectedRows) { UDT.Subject subj = (UDT.Subject)row.Tag; sb.Append( makeSubjMsg(subj)); recs.Add(subj); } AccessHelper ah = new AccessHelper(); try { ah.DeletedValues(recs); FISCA.LogAgent.ApplicationLog.Log("科目管理", "刪除", "", "", sb.ToString()); this.RefreshData(); } catch (Exception ex) { Util.ShowMsg("刪除科目資料時發生錯誤!", "注意!"); } }
/// <summary> /// 刪除1筆個案會議 /// </summary> /// <param name="CaseMeetingRecord"></param> public void DeleteCaseMeetingRecord(DAO.UDT_CounselCaseMeetingRecordDef CaseMeetingRecord) { CaseMeetingRecord.Deleted = true; List<DAO.UDT_CounselCaseMeetingRecordDef> DelCaseMeetingRecordList = new List<UDT_CounselCaseMeetingRecordDef>(); DelCaseMeetingRecordList.Add(CaseMeetingRecord); AccessHelper accessHelper = new AccessHelper(); accessHelper.DeletedValues(DelCaseMeetingRecordList.ToArray()); }