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");
}
public static void TestDB()
{
//Tools.DBConnParams dbPMS = new Tools.DBConnParams();
//dbPMS.InitMS();
//Tools.IDbConnection connMS = new Tools.MsSqlDbConn(dbPMS);
Tools.DBConnParams dbPMY = new Tools.DBConnParams();
dbPMY.InitMY();
Tools.IDbConnection connMY = new Tools.MySqlDBConn(dbPMY);
var dbP = new Tools.DBConnParams()
{
ServerName = @"kkhproj-db.czuxn57jn8hk.ap-northeast-2.rds.amazonaws.com", ServerID = "admin", ServerPW = "kkh198400", DbName = "proj"
};
Tools.MsSqlDbConn connMS2 = new Tools.MsSqlDbConn(dbP);
IDataReader dr = connMY.GetDataReader($@"select * from lapse");
connMS2.Insert(dr, "lapse");
dr = connMY.GetDataReader($@"select * from mortality");
connMS2.Insert(dr, "mortality");
}
