public static void PrintDealInfoSum(DateTime date)
{
string sql = ("SELECT Time, ClsName, TestResult, ClassValue, DealsInfo, DealsData FROM TestData WHERE [Time] >= @Time1 AND [Time] < @Time2 ORDER BY Time, ClsName");
SqlCommand cmd = new SqlCommand(string.Format(sql));
cmd.Parameters.AddWithValue("@Time1", WekaUtils.GetTimeFromDate(date));
cmd.Parameters.AddWithValue("@Time2", WekaUtils.GetTimeFromDate(date.AddDays(1)));
var dt = DbHelper.Instance.ExecuteDataTable(cmd);
StringBuilder sb = new StringBuilder();
foreach (System.Data.DataRow row in dt.Rows)
{
var clsInfo = new CandidateClassifier(row["ClsName"].ToString(), 0, 0, 'B', -1, null);
clsInfo.SetData((string)row["TestResult"], (string)row["ClassValue"], (byte[])row["DealsInfo"], (byte[])row["DealsData"]);
string s = clsInfo.Deals.PrintAll();
sb.AppendLine(clsInfo.Name);
sb.AppendLine(s);
}
Console.WriteLine(sb.ToString());
Console.ReadLine();
}
public static void PrintDealInfoDetail(string clsInfoName, DateTime date)
{
string sql = ("SELECT Time, ClsName, TestResult, ClassValue, DealsInfo, DealsData FROM TestData WHERE [Time] = @Time AND ClsName = @ClsName");
SqlCommand cmd = new SqlCommand(string.Format(sql));
cmd.Parameters.AddWithValue("@Time", WekaUtils.GetTimeFromDate(date));
cmd.Parameters.AddWithValue("@ClsName", clsInfoName);
var dt = DbHelper.Instance.ExecuteDataTable(cmd);
var row = dt.Rows[0];
var clsInfo = new CandidateClassifier(clsInfoName, 0, 0, 'B', -1, null);
clsInfo.SetData((string)row["TestResult"], (string)row["ClassValue"], (byte[])row["DealsInfo"], (byte[])row["DealsData"]);
string s = clsInfo.Deals.PrintAll(true);
Console.WriteLine(s);
Console.ReadLine();
}