public static string test_2result_odd() { BsonDocument doc = Analyse2Result.get_best(1, 50); IWindow.write_break(); IWindow.write(Analyse2Result.get_info(doc)); IWindow.write_break(); return("COMPUTE OK!!!"); }
public static string test_all_2result_odd() { StringBuilder sb = new StringBuilder(); string sql = " select * from a_odd where type_id in (2,3,4)"; DataTable dt_temp = SQLServerHelper.get_table(sql); List <BsonDocument> list = new List <BsonDocument>(); foreach (DataRow row in dt_temp.Rows) { if (row["m5"].ToString() == "Y") { continue; } BsonDocument doc = Analyse2Result.get_best(Convert.ToInt32(row["id"].ToString()), 50); list.Add(doc); for (int i = 0; i < dt_temp.Rows.Count; i++) { if (dt_temp.Rows[i]["event_id"].ToString() == row["event_id"].ToString() && dt_temp.Rows[i]["type_id"].ToString() == row["type_id"].ToString() && dt_temp.Rows[i]["m1"].ToString() == row["m1"].ToString() && dt_temp.Rows[i]["m2"].ToString() == row["m2"].ToString() && dt_temp.Rows[i]["m3"].ToString() == row["m3"].ToString() && dt_temp.Rows[i]["m4"].ToString() == row["m4"].ToString() && dt_temp.Rows[i]["m5"].ToString() == row["m5"].ToString() && dt_temp.Rows[i]["m6"].ToString() == row["m6"].ToString() && dt_temp.Rows[i]["o1"].ToString() == row["o1"].ToString() && dt_temp.Rows[i]["o2"].ToString() == row["o2"].ToString() && dt_temp.Rows[i]["o3"].ToString() == row["o3"].ToString() && dt_temp.Rows[i]["o4"].ToString() == row["o4"].ToString() && dt_temp.Rows[i]["o5"].ToString() == row["o5"].ToString() && dt_temp.Rows[i]["o6"].ToString() == row["o6"].ToString()) { dt_temp.Rows[0]["m5"] = "Y"; } } } List <BsonDocument> list_result = get_list_by_persent_desc(list); sb.AppendLine("-------------------------------------------------------------------------------------------------------------"); foreach (BsonDocument doc_show in list_result) { sb.Append(Analyse2Result.get_info(doc_show)); sb.Append(""); sb.AppendLine("-------------------------------------------------------------------------------------------------------------"); } Log.create_log_file(sb.ToString()); IWindow.write_break(); int count = 0; foreach (BsonDocument doc_show in list_result) { count = count + 1; if (count == 11) { break; } IWindow.write(Analyse2Result.get_info(doc_show)); IWindow.write_break(); } return("COMPUTE OK!!!"); }