Exemplo n.º 1
0
        /// <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);
        }