public Trial(DaoTrial trial, DataService service, FmDb par)
{
InitializeComponent();
this.trial = trial;
this.service = service;
parent = par;
labPltfm.Text = trial.pltfm;
labPdct.Text = trial.pdct;
labDate.Text = trial.date;
labActivator.Text = trial.activator;
labOperator.Text = trial.operater;
labInfo.Text = trial.info;
}
//获取所有trial 记录
public List <DaoTrial> getAllTrials()
{
List <DaoTrial> list = null;
if (con != null)
{
try
{
if (con.State != ConnectionState.Open)
{
con.Open();
}
list = new List <DaoTrial>();
string queryStr = @"select id,trialPltfmName,trialPdctName,trialUserId,trialDate,
trialSummaryPath,trialInfo,trialOperator from tabtrials;";
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = con;
cmd.CommandText = queryStr;
using (MySqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
DaoTrial one = new DaoTrial();
one.id = reader.GetInt32(0);
one.pltfm = reader.GetString(1);
one.pdct = reader.GetString(2);
one.activator = reader.GetString(3);
one.date = reader.GetString(4);
one.dbgPath = reader.GetString(5);
one.info = reader.GetString(6);
one.operater = reader.GetString(7);
list.Add(one);
}
}
}
catch (Exception ex)
{
Console.WriteLine("getTrial Error!\n" + ex.Message);
}
}
return(list);
}
