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