/// <summary>
/// 行的数据转为实体,方便修改数据库
/// </summary>
/// <param name="row"></param>
/// <returns></returns>
private LevelValueEntity rowToEntity(DataGridViewRow row)
{
LevelValueEntity levelValue = new LevelValueEntity();
levelValue.ID = row.Cells["ID"].Value == null ? 0: int.Parse(row.Cells["ID"].Value.ToString());
levelValue.OilTableTypeComparisonTableID = int.Parse(row.Cells["OilTableTypeComparisonTableID"].Value.ToString());
levelValue.itemName = row.Cells["itemName"].Value == null ? string.Empty : row.Cells["itemName"].Value.ToString();
levelValue.itemCode = row.Cells["itemCode"].Value == null ? string.Empty : row.Cells["itemCode"].Value.ToString();
levelValue.belowLess = row.Cells["<Less"].Value.ToString();
levelValue.More_Less = row.Cells["Less-More"].Value == null ? string.Empty : row.Cells["Less-More"].Value.ToString();
levelValue.aboveMore = row.Cells[">More"].Value == null ? string.Empty : row.Cells[">More"].Value.ToString();
levelValue.strMore = row.Cells["More"].Value == null ? string.Empty : row.Cells["More"].Value.ToString(); // null : float.Parse(row.Cells["More"].Value.ToString()) as float?;
levelValue.strLess = row.Cells["Less"].Value == null ? string.Empty : row.Cells["Less"].Value.ToString(); //null : float.Parse(row.Cells["Less"].Value.ToString()) as float?;
//if (row.Cells["More"].Value == null)
// levelValue.More = null;
//else
// levelValue.More = float.Parse(row.Cells["More"].Value.ToString()) as float?;
//if (row.Cells["Less"].Value == null)
// levelValue.Less = null;
//else
// levelValue.Less = float.Parse(row.Cells["Less"].Value.ToString());
return(levelValue);
}
/// <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）则从更新数据库，否则（该行是才添加的还没存到数据库）添加到数据库
{
}
}
