/// <summary>
/// 转换表中的值
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public static DataTable Convert_TableValue(DataTable dt)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Columns.Count == 4) //根据输出列数判断是否是Soil
{
if (dt.Columns[0].ColumnName == "作业站") //根据列名判断作物范围
{
dt.Rows[i][0] = DataBaseOperate.getVillName(dt.Rows[i][0].ToString());
}
else if (dt.Columns[0].ColumnName == "作业区")
{
dt.Rows[i][0] = DataBaseOperate.getTownName(dt.Rows[i][0].ToString());
}
dt.Rows[i][1] = ((DateTime)dt.Rows[i][1]).ToShortDateString();
dt.Rows[i][2] = DataBaseOperate.get_CropCHName(dt.Rows[i][2].ToString());
dt.Rows[i][3] = Math.Round((double)dt.Rows[i][3], 3);
}
else //soil
{
if (dt.Columns[0].ColumnName == "作业站")
{
dt.Rows[i][0] = DataBaseOperate.getVillName(dt.Rows[i][0].ToString());
}
else if (dt.Columns[0].ColumnName == "作业区")
{
dt.Rows[i][0] = DataBaseOperate.getTownName(dt.Rows[i][0].ToString());
}
dt.Rows[i][1] = ((DateTime)dt.Rows[i][1]).ToShortDateString();
dt.Rows[i][2] = DataBaseOperate.get_CropCHName(dt.Rows[i][2].ToString());
dt.Rows[i][3] = DataBaseOperate.get_NutrientCHName(dt.Rows[i][3].ToString());
dt.Rows[i][4] = Math.Round((double)dt.Rows[i][4], 4);
}
}
return(dt);
}