public static DataTable Select(string Lid, string OddsID, string Odds)
{
double Q1 = 0;
double Q2 = 0;
string Sql = "SELECT * FROM `db_odds` where Lid=" + Lid;
DataTable Dt = DbHelperMySQL.DQuery(Sql);
DataRow dr = null;
for (int i = 0; i < Dt.Rows.Count; i++)
{
if (Dt.Rows[i]["pan"].ToString().Trim() == "" || Dt.Rows[i]["pan"].ToString() == null)
{
continue;
}
//dr = Dt.Rows[i];
try
{
double Q1adds = Convert.ToDouble(Dt.Rows[i]["Q1adds"]);
double Q2adds = Convert.ToDouble(Dt.Rows[i]["Q2adds"]);
if (i == 0)
{
Q1 = Q1adds;
Q2 = Q2adds;
dr = Dt.Rows[i];
}
if (Q1 - Q1adds > 0.2 || Q2 - Q2adds > 0.2)
{
Hashtable drs = new Hashtable();
//Console.WriteLine(dr["pan"].ToString());
//Console.Write(Dt.Rows[i]["Q1"].ToString());
//Console.WriteLine(Dt.Rows[i]["Q1adds"] +"---"+ Q1+"--"+ Lid);
drs["Lid"] = Dt.Rows[i]["Lid"].ToString();
drs["Ls"] = Dt.Rows[i]["Ls"].ToString();
drs["Q1"] = Dt.Rows[i]["Q1"].ToString();
drs["Q2"] = Dt.Rows[i]["Q2"].ToString();
drs["H"] = dr["HC"].ToString();
drs["C"] = Dt.Rows[i]["HC"].ToString();
drs["PAN1"] = dr["pan"].ToString();
drs["PAN2"] = Dt.Rows[i]["pan"].ToString();
drs["Q1ODDS"] = dr["Q1adds"].ToString();
drs["Q1ODDS_F"] = Dt.Rows[i]["Q1adds"].ToString();
drs["Q2ODDS"] = dr["Q2adds"].ToString();
drs["Q2ODDS_F"] = Dt.Rows[i]["Q2adds"].ToString();
//drs["stime"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string sql = SqlBuilderHelper.InsertSQL(drs, "acc_log");
Console.WriteLine(sql);
int b = DbHelperMySQL.ExecuteSql(sql);
if (b == 1)
{
//DataRow drr = Conf.WhereLianSai.NewRow();
Pfun.HashToRow(drs);
//Conf.WhereLianSai.Rows.Add(drr);
}
}
if (Q2 - Q2adds > 0.2)
{
//Console.Write(Dt.Rows[i]["Q2"]);
//Console.WriteLine(Dt.Rows[i]["Q2adds"] + "---" + Q2+"--"+ Lid);
}
Q1 = Q1adds;
Q2 = Q2adds;
dr = Dt.Rows[i];
}
catch {
//Console.WriteLine(Dt.Rows[i]["Q1adds"]);
}
}
return(Dt);
}
