/// <summary> /// 更新数据库,如果是新添加的行则添加数据库,否则更新数据库 /// </summary> /// <param name="row"> 实体</param> private void updateRow(LevelValueEntity row) { if (row == null) { return; } LevelValueAccess access = new LevelValueAccess(); if (row.ID > 0) //如果行在数据库中存在(即ID字段不为0)则从更新数据库,否则(该行是才添加的还没存到数据库)添加到数据库 { int reslut = access.Update(row, row.ID.ToString()); } if (row.ID != 0) //如果行在数据库中存在(即ID字段不为0)则从更新数据库,否则(该行是才添加的还没存到数据库)添加到数据库 { } }
/// <summary> /// 将数据绑定到表格上,有刷新表格的作用 /// </summary> /// <param name="rowList"></param> private void BindDgdViewAll() { this.dgvSetLevelValue.Rows.Clear(); LevelValueAccess levelValueAccess = new LevelValueAccess(); this._LevelValueEntityList = levelValueAccess.Get("1=1").ToList(); OilTableTypeComparisonTableEntity oilTableTypeComTableEntity = (OilTableTypeComparisonTableEntity)this.toolStripComboBox1.ComboBox.SelectedItem; List <LevelValueEntity> rowList = this._LevelValueEntityList.Where(o => o.OilTableTypeComparisonTableID == oilTableTypeComTableEntity.ID).ToList(); if (rowList == null) { return; } foreach (LevelValueEntity levelValue in rowList) { this.dgvSetLevelValue.Rows.Add(levelValue.ID, levelValue.OilTableTypeComparisonTableID, levelValue.itemName, levelValue.itemCode, levelValue.belowLess, levelValue.strLess, levelValue.More_Less, levelValue.strMore, levelValue.aboveMore); } #region "可以注释" //for (int rowIndex = 0; rowIndex < rowList.Count; rowIndex++) //{ //int index = this.dgvSetLevelValue.Rows.Add(); //this.dgvSetLevelValue.Rows[index].Cells["ID"].Value = rowList[rowIndex].ID; //this.dgvSetLevelValue.Rows[index].Cells["OilTableTypeComparisonTableID"].Value = rowList[rowIndex].ID; //this.dgvSetLevelValue.Rows[index].Cells["itemName"].Value = rowList[rowIndex].itemName; //this.dgvSetLevelValue.Rows[index].Cells["itemCode"].Value = rowList[rowIndex].itemCode; //this.dgvSetLevelValue.Rows[index].Cells["<Less"].Value = rowList[rowIndex].belowLess; //this.dgvSetLevelValue.Rows[index].Cells["Less"].Value = rowList[rowIndex].Less; //this.dgvSetLevelValue.Rows[index].Cells["Less-More"].Value = rowList[rowIndex].More_Less; //this.dgvSetLevelValue.Rows[index].Cells["More"].Value = rowList[rowIndex].More; //this.dgvSetLevelValue.Rows[index].Cells[">More"].Value = rowList[rowIndex].aboveMore; //} #endregion }