public Trial getTrialById(string pltfm, string pdct, string userId, string date)
{
Trial ret = null;
if (con != null)
{
try
{
if (con.State != ConnectionState.Open)
{
con.Open();
}
string query = @"select * from tabTrials where
trialPltfmName=@pltfm and
trialPdctName=@pdct and
trialUserId=@userId and
trialDate=@date;";
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = con;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@pltfm", pltfm);
cmd.Parameters.AddWithValue("@pdct", pdct);
cmd.Parameters.AddWithValue("@userId", userId);
cmd.Parameters.AddWithValue("@date", date);
using (MySqlDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
ret = new Trial();
}
ret.Id = reader.GetInt32(0);
ret.TrPltfmName = reader.GetString(1);
ret.TrPdctName = reader.GetString(2);
ret.TrUserId = reader.GetString(3);
ret.TrDate = reader.GetString(4);
ret.TrSummaryPath = reader.GetString(5);
ret.TrDebugPath = reader.GetString(6);
ret.TrInfo = reader.GetString(7);
ret.TrOperator = reader.GetString(8);
Console.WriteLine(ret);
}
}
catch (Exception ex)
{
MyLogger.WriteLine(ex.Message);
}
}
return(ret);
}
//获取某条trial 记录
public Trial getTrialByUidDate(string uid, string datestr)
{
Trial ret = new Trial();
if (con != null)
{
try
{
if (con.State != ConnectionState.Open)
{
con.Open();
}
MyLogger.WriteLine("date:" + datestr + " userid:" + uid);
string queryPage = @"select * from tabTrials where trialUserId=@userId
and trialDate=@datestr";
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = con;
cmd.CommandText = queryPage;
cmd.Parameters.AddWithValue("@userId", uid);
cmd.Parameters.AddWithValue("@datestr", datestr);
//查询Trial记录，并封装到类
using (MySqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
ret.Id = reader.GetInt32(0);
ret.TrPltfmName = reader.GetString(1);
ret.TrPdctName = reader.GetString(2);
ret.TrUserId = reader.GetString(3);
ret.TrDate = reader.GetString(4);
ret.TrSummaryPath = reader.GetString(5);
ret.TrDebugPath = reader.GetString(6);
ret.TrInfo = reader.GetString(7);
ret.TrOperator = reader.GetString(8);
}
MyLogger.WriteLine("get trial ok!" + ret);
}
}
catch
{
MyLogger.WriteLine("when query page trial list error!");
}
}
return(ret);
}
public List <Trial> getPageListByuid(int pageNow, int pageSize, string userId, ref int pageCount)
{
int rowCount = 0;
List <Trial> trialList = null;
//防止不正确的页数
if (pageNow < 1)
{
pageNow = 1;
}
//开始分页操作
if (con != null)
{
try
{
if (con.State != ConnectionState.Open)
{
con.Open();
}
string query = @"select count(*) from tabTrials where trialUserId=@userId;";
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = con;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@userId", userId);
//查询记录数
using (MySqlDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
rowCount = reader.GetInt32(0);
}
MyLogger.WriteLine("tabTrials has " + rowCount + " lines");
}
if (rowCount == 0)
{
return(trialList);
}
else
{
trialList = new List <Trial>();
}
}
catch (Exception ex)
{
MyLogger.WriteLine(ex.Message);
}
try
{
//配置要查询的行数，页数
pageCount = (rowCount - 1) / pageSize + 1;
int rowStart = (pageNow - 1) * pageSize;
//查询记录
string queryPage = @"select * from tabTrials where trialUserId=@userId limit @start,@size";
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = con;
cmd.CommandText = queryPage;
cmd.Parameters.AddRange(new MySqlParameter[] {
new MySqlParameter("@userId", userId),
new MySqlParameter("@start", rowStart),
new MySqlParameter("@size", pageSize),
});
//查询Trial记录，并封装到类
using (MySqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
Trial ret = new Trial();
ret.Id = reader.GetInt32(0);
ret.TrPltfmName = reader.GetString(1);
ret.TrPdctName = reader.GetString(2);
ret.TrUserId = reader.GetString(3);
ret.TrDate = reader.GetString(4);
ret.TrSummaryPath = reader.GetString(5);
ret.TrDebugPath = reader.GetString(6);
ret.TrInfo = reader.GetString(7);
ret.TrOperator = reader.GetString(8);
trialList.Add(ret);
}
}
}
catch
{
MyLogger.WriteLine("when query page trial list error!");
}
}
return(trialList);
}