/// <summary>
/// 提取DataSet中的检测项目信息
/// </summary>
/// <param name="proResultlist">检测结果集合</param>
/// <param name="x">当前循环的行数</param>
/// <param name="y">当前循环的列数</param>
/// <param name="z">起始循环的列数</param>
/// <param name="w">结束循环的列数</param>
/// <param name="dsItem">DataSet数据</param>
/// <param name="SheetName">Sheet名称</param>
/// <param name="newSheetName">新的Sheet名称</param>
/// <returns></returns>
public static List <ProResult> AddProResult(List <ProResult> proResultlist, int x, int y, int z, int w, DataSet dsItem, string SheetName, string newSheetName)
{
var examine = dsItem.Tables[SheetName].Rows[x][y].ToString();
var result = "";
for (int k = z; k < w; k++)
{
if (!string.IsNullOrEmpty(dsItem.Tables[SheetName].Rows[x][k].ToString()))
{
result += dsItem.Tables[SheetName].Rows[x][k].ToString() + ";";
}
}
if (!string.IsNullOrEmpty(examine) && !string.IsNullOrEmpty(result) && !examine.Contains("文字") && !examine.Contains("评估"))
{
ProResult proResult = new ProResult()
{
examine = examine,
result = result,
proName = newSheetName
};
proResultlist.Add(proResult);
}
return(proResultlist);
}
/// <summary>
/// 提取DataSet中的检测项目信息
/// </summary>
/// <param name="proResultlist">检测结果集合</param>
/// <param name="x">当前循环的行数</param>
/// <param name="y">当前循环的列数</param>
/// <param name="z">起始循环的列数</param>
/// <param name="w">结束循环的列数</param>
/// <param name="dsItem">DataSet数据</param>
/// <param name="SheetName">Sheet名称</param>
/// <param name="newSheetName">新的Sheet名称</param>
/// <returns></returns>
public static List<ProResult> AddProResult(List<ProResult> proResultlist, int x, int y, int z, int w, DataSet dsItem, string SheetName, string newSheetName)
{
var examine = dsItem.Tables[SheetName].Rows[x][y].ToString();
var result = "";
for (int k = z; k < w; k++)
{
if (!string.IsNullOrEmpty(dsItem.Tables[SheetName].Rows[x][k].ToString()))
{
result += dsItem.Tables[SheetName].Rows[x][k].ToString() + ";";
}
}
if (!string.IsNullOrEmpty(examine) && !string.IsNullOrEmpty(result) && !examine.Contains("文字") && !examine.Contains("评估"))
{
ProResult proResult = new ProResult()
{
examine = examine,
result = result,
proName = newSheetName
};
proResultlist.Add(proResult);
}
return proResultlist;
}
