public Worker(CaculateItems ci, OleDbConnection conn, string testid)
{
this.ci = ci;
this.conn = conn;
db = new DataBase(testid);
}
public void PersonProcess(string TestId)
{
CaculateItems ci = new CaculateItems();
conn = Connect.getConnection();
string sql = "select PERSON_ID,SEX,AGE,HEIGHT,WEIGHT from T_TEST_PERSON where TEST_ID=@1";
cmd = new OleDbCommand(sql, conn);
cmd.Parameters.AddWithValue("@1", TestId);
conn.Open();
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ci.Personid = (string)reader[0];
ci.Sex = (string)reader[1];
ci.Age = (int)reader[2];
ci.Height = (float)reader[3];
try { ci.Weight = (float)reader[4]; } catch (Exception ex) {
ci.Weight = 1;
}
Worker w = new Worker(ci, conn, TestId);
w.Process();
}
conn.Close();
reader.Close();
}
