public int InsertProbability(DataTable table, int year)
{
int result = 0;
// var table = this.SelectPopularNum(year);
operation.ClearTable("NumProbability");
var parameters = new SQLiteParameter[3];
SQLiteParameter p;
foreach (DataRow row in table.Rows)
{
p = new SQLiteParameter();
p.ParameterName = "@Num";
p.DbType = System.Data.DbType.Int32;
p.Value = int.Parse(row["NUM"].ToString());
parameters[0] = p;
p = new SQLiteParameter();
p.ParameterName = "@Frq";
p.DbType = System.Data.DbType.Int32;
p.Value = int.Parse(row["COUNT1"].ToString());
parameters[1] = p;
p = new SQLiteParameter();
p.ParameterName = "@Per";
p.DbType = System.Data.DbType.Double;
p.Value = double.Parse(row["Percent"].ToString());
parameters[2] = p;
result = operation.Insert(ScriptHelper.GetScriptFromFile("InsertNumProbability"), parameters);
}
return(result);
}
