public static void NpgsqlDBImportPerson(ModelPerson mPerson) { string conn_str = "Server=localhost;Port=5432;User ID=xiao;Database=note;Password=xiao;Enlist=true"; using (NpgsqlConnection conn = new NpgsqlConnection(conn_str)) { //PostgreSQLへ接続 conn.Open(); List <ImportEventItem> orderList = new List <ImportEventItem>(); int evid = GetLastId("event", 10000000, conn); int chid = GetLastId("event_item", 11000000, conn); int personid = GetLastId("person", 21000000, conn); foreach (var item in mPerson.Items) { string cmd_str = string.Format("insert into person (id, name, category, status, memo, name2, name3, address, input_date) values " + "('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}');", ++personid, QuoConv(item.Name), QuoConv(item.Category), QuoConv(item.Status), QuoConv(item.Memo), QuoConv(item.Name2), QuoConv(item.Name3), QuoConv(item.Address), QuoConv(item.InputDate.ToString("yyyy-MM-dd"))); NpgsqlCommand cmd = new NpgsqlCommand(cmd_str, conn); var rtn1 = cmd.ExecuteNonQuery(); cmd_str = string.Format("select Count(*) from event where name = '{0}' or name = '{1}' or name = '{2}' ", QuoConv(item.Name), QuoConv(item.Name2), QuoConv(item.Name3)); cmd = new NpgsqlCommand(cmd_str, conn); int rtnCount = 0; using (NpgsqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { if (!dr.IsDBNull(0)) { rtnCount = dr.GetInt32(0); } } } if (rtnCount > 0) { continue; } cmd_str = string.Format("insert into event (id, name, category, status, sorted) values ('{0}', '{1}', '{2}', '{3}', '{4}');", ++evid, QuoConv(item.Name), "Communicate", "Finished", "Person"); cmd = new NpgsqlCommand(cmd_str, conn); rtn1 = cmd.ExecuteNonQuery(); cmd_str = string.Format("insert into event_item (id, date, memo, time, parent_id) values ('{0}', '{1}', '{2}', '{3}', '{4}');", ++chid, QuoConv(item.InputDate.ToString("yyyy-MM-dd")), "", 0.1, evid); cmd = new NpgsqlCommand(cmd_str, conn); rtn1 = cmd.ExecuteNonQuery(); Console.WriteLine("Insert success! {0}", item.Name); } Console.WriteLine("Insert Complete!"); conn.Close(); } }
private void InitializePerson() { mPerson = new ModelPerson(); mPerson.Read(); curGroup = new List <ViewPerson>(); }