/// <summary> /// 儲存DataGridView的資料到DB /// </summary> private void SaveDataGridViewValue() { List <DAO.TagMappingRecord> recList = new List <DAO.TagMappingRecord>(); //取得DataDataGridViewRow資料 foreach (DataGridViewRow row in dataGridViewX1.Rows) { //遇到空白的MyTagName即跳到下個loop if (row.Cells[0].Value == null) { continue; } String MyTagName = row.Cells[0].Value.ToString().Trim(); String SysTagName = ""; if (row.Cells[1].Value != null) { SysTagName = row.Cells[1].Value.ToString().Trim(); } DAO.TagMappingRecord rec = new DAO.TagMappingRecord(MyTagName, SysTagName); recList.Add(rec); } // 存入DB DAO.TagMapping.SaveByRecordList(recList); }
/// <summary> /// 儲存DataGridView的資料到DB /// </summary> private void SaveDataGridViewValue() { List<DAO.TagMappingRecord> recList = new List<DAO.TagMappingRecord>(); //取得DataDataGridViewRow資料 foreach (DataGridViewRow row in dataGridViewX1.Rows) { //遇到空白的MyTagName即跳到下個loop if (row.Cells[0].Value == null) { continue; } String MyTagName = row.Cells[0].Value.ToString().Trim(); String SysTagName = ""; if (row.Cells[1].Value != null) { SysTagName = row.Cells[1].Value.ToString().Trim(); } DAO.TagMappingRecord rec = new DAO.TagMappingRecord(MyTagName, SysTagName); recList.Add(rec); } // 存入DB DAO.TagMapping.SaveByRecordList(recList); }