private void InsertResult(string id, Dictionary <int, double[][]> resByPol) { // 데이터 전환 to list<object[]> var lst = new List <object[]>(); object[] obj; var now = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); foreach (var kv in resByPol) { for (int rowNo = 0; rowNo < kv.Value.Length; rowNo++) { obj = new object[14]; obj[0] = id; obj[1] = now; obj[2] = kv.Key; obj[3] = (RSettings.InsertsByMth ? rowNo + 1 : 0); for (int i = 0; i < kv.Value[rowNo].Length; i++) { obj[4 + i] = kv.Value[rowNo][i]; } lst.Add(obj); } } // db입력 var dbParams = new Tools.DBConnParams(); dbParams.InitMY(); Tools.MySqlDBConn dbConn = new Tools.MySqlDBConn(dbParams); dbConn.Insert(lst, @"proj_result"); }
public static void InsertMort() { var dt = new List <object[]>(); var line = new object[121 + 3]; line[0] = "2009"; line[1] = "UL"; line[2] = 1; for (int age = 0; age <= 120; age++) { if (age == 120) { line[age + 3] = 1.0; } else { line[age + 3] = 0.001 * age; } } dt.Add(line); line = new object[121 + 3]; line[0] = "2009"; line[1] = "UL"; line[2] = 2; for (int age = 0; age <= 120; age++) { if (age == 120) { line[age + 3] = 1.0; } else { line[age + 3] = (0.001 * age) * 0.8; } } dt.Add(line); var dp = new Tools.DBConnParams(); dp.InitMY(); Tools.MySqlDBConn conn = new Tools.MySqlDBConn(dp); conn.Insert(dt, "mortality"); }
public static void InsertLapse() { var dt = new List <object[]>(); // 1번째 라인 var line = new object[120 + 3]; line[0] = "2009"; line[1] = "UL"; line[2] = "InPayment"; for (int yr = 1; yr <= 120; yr++) { if (yr >= 20) { line[yr + 2] = 0.03; } else { line[yr + 2] = Math.Max(0.03, 0.1 - yr * 0.01); } } dt.Add(line); // 2번째 라인 line = new object[120 + 3]; line[0] = "2009"; line[1] = "UL"; line[2] = "AfterPayment"; for (int yr = 1; yr <= 120; yr++) { line[yr + 2] = 0.03; } dt.Add(line); var dp = new Tools.DBConnParams(); dp.InitMY(); Tools.MySqlDBConn conn = new Tools.MySqlDBConn(dp); conn.Insert(dt, "lapse"); }