前阵子做疫情项目出现过一次,结果今天有犯了一个错误,做个备注,警戒自己!!!
/// <summary>
/// 循环按照编号去取某个员工的某个指标的值
/// </summary>
/// <param name="taskList"></param>
/// <returns></returns>
public static DataSet GetGroupExamineFormDataItems(List<string> taskList,string code)
{
DataSet ds = new DataSet();
DataTable tb = new DataTable();
tb.Columns.Add("EmployeeName");
tb.Columns.Add("SelectValue");
tb.Columns.Add("TaskId");
ds.Tables.Add(tb);
foreach (string item in taskList)
{
List<SqlParameter> param = new List<SqlParameter>();
param.Add(new SqlParameter("@Id", item));
param.Add(new SqlParameter("@Code", code));
SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "GetGroupExamineFormDataItems", param.ToArray());
while (reader.Read())
{
DataRow row = tb.NewRow();
row[0] = reader[0];
row[1] = reader[1];
row[2] = item;
tb.Rows.Add(row);
}
reader.Close();
}
return ds;
}