前阵子做疫情项目出现过一次,结果今天有犯了一个错误,做个备注,警戒自己!!!

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