--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/hhsdb.cpp	Tue Apr 05 18:44:57 2011 +0900
@@ -0,0 +1,167 @@
+// Filename   : hhsdb.cpp
+// Last Change: 07-Mar-2011.
+//
+
+#include "hhsdb.h"
+#include "wx/wxsqlite3.h"
+
+// for all others, include the necessary headers (this file is usually all you
+// need because it includes almost all "standard" wxWidgets headers)
+#ifndef WX_PRECOMP
+    #include "wx/utils.h"
+    #include "wx/textfile.h"
+    #include "wx/tokenzr.h"
+#endif
+
+// Constructor
+FrameHhsDB::FrameHhsDB( wxWindow* parent, wxWindowID id, const wxString& title, const wxPoint& pos, const wxSize& size, long style )
+    : wxFrame( parent, id, title, pos, size, style )
+{
+	this->SetSizeHints( wxDefaultSize, wxDefaultSize );
+	
+	wxBoxSizer* bSizer;
+	bSizer = new wxBoxSizer( wxVERTICAL );
+	
+	m_panel = new wxPanel( this, wxID_ANY, wxDefaultPosition, wxDefaultSize, wxTAB_TRAVERSAL );
+
+	wxBoxSizer* bSizerPanel;
+	bSizerPanel = new wxBoxSizer( wxVERTICAL );
+	
+    wxString wildcard = wxT("CSV files (*.csv) | *.csv");
+	m_filePicker = new wxFilePickerCtrl( m_panel, ID_CSVPK, wxT("CSVファイルを指定します"), wxT("Select a file"), wildcard, wxDefaultPosition, wxSize( 400,-1 ), wxFLP_DEFAULT_STYLE|wxFLP_FILE_MUST_EXIST|wxFLP_OPEN );
+	bSizerPanel->Add( m_filePicker, 0, wxEXPAND|wxALL, 5 );
+	
+	m_grid = new wxGrid( m_panel, wxID_ANY, wxDefaultPosition, wxDefaultSize, 0 );
+	
+	// Grid
+	m_grid->CreateGrid( 200, 6 );
+	m_grid->EnableEditing( true );
+	m_grid->EnableGridLines( true );
+	m_grid->EnableDragGridSize( false );
+	m_grid->SetMargins( 0, 0 );
+	
+	// Columns
+	m_grid->EnableDragColMove( false );
+	m_grid->EnableDragColSize( true );
+	m_grid->SetColLabelSize( 30 );
+	m_grid->SetColLabelValue( 0, wxT("被保険者番号") );
+	m_grid->SetColLabelValue( 1, wxT("氏名") );
+	m_grid->SetColLabelValue( 2, wxT("カナ氏名") );
+	m_grid->SetColLabelValue( 3, wxT("住所") );
+	m_grid->SetColLabelValue( 4, wxT("生年月日") );
+	m_grid->SetColLabelValue( 5, wxT("性別") );
+	m_grid->SetColLabelAlignment( wxALIGN_CENTRE, wxALIGN_CENTRE );
+	
+	// Rows
+	m_grid->EnableDragRowSize( true );
+	m_grid->SetRowLabelSize( 40 );
+	m_grid->SetRowLabelAlignment( wxALIGN_RIGHT, wxALIGN_CENTRE );
+	
+	// Label Appearance
+	
+	// Cell Defaults
+	m_grid->SetDefaultCellAlignment( wxALIGN_LEFT, wxALIGN_TOP );
+	bSizerPanel->Add( m_grid, 1, wxEXPAND|wxALL, 5 );
+	
+	wxBoxSizer* bSizerBtns;
+	bSizerBtns = new wxBoxSizer( wxHORIZONTAL );
+	
+	m_staticText = new wxStaticText( m_panel, wxID_ANY, wxT("パスワード"), wxDefaultPosition, wxDefaultSize, 0 );
+	
+	m_textCtrlPassword = new wxTextCtrl( m_panel, ID_PSWD, wxEmptyString, wxDefaultPosition, wxDefaultSize, wxTE_PASSWORD );
+	m_textCtrlPassword->SetMaxLength( 4 ); 
+	
+	m_btnDBUpdate = new wxButton( m_panel, ID_HHSUP, wxT("DB更新"), wxDefaultPosition, wxDefaultSize, 0 );
+	m_btnDBUpdate->Enable( false );
+
+	m_btnCancel = new wxButton( m_panel, wxID_CANCEL, wxT("キャンセル"), wxDefaultPosition, wxDefaultSize, 0 );
+	m_btnCancel->SetDefault(); 
+	
+	bSizerBtns->Add( 0, 0, 1, wxEXPAND, 5 );    // spacer
+	bSizerBtns->Add( m_staticText,       0, wxALL, 5 );
+	bSizerBtns->Add( m_textCtrlPassword, 0, wxALL, 5 );
+	bSizerBtns->Add( m_btnDBUpdate,      0, wxALL, 5 );
+	bSizerBtns->Add( m_btnCancel,        0, wxALL, 5 );
+	
+	bSizerPanel->Add( bSizerBtns, 0, wxALIGN_RIGHT|wxEXPAND, 5 );
+	
+	m_panel->SetSizer( bSizerPanel );
+	m_panel->Layout();
+	bSizerPanel->Fit( m_panel );
+
+	bSizer->Add( m_panel, 1, wxEXPAND|wxALL, 0 );
+	this->SetSizer( bSizer );
+	this->Layout();
+}
+// Destructor
+FrameHhsDB::~FrameHhsDB()
+{
+}
+
+// Event Table
+BEGIN_EVENT_TABLE(FrameHhsDB, wxFrame)
+    EVT_FILEPICKER_CHANGED( ID_CSVPK, FrameHhsDB::ReadCSV )
+    EVT_TEXT( ID_PSWD, FrameHhsDB::CheckPassword )
+    EVT_BUTTON( ID_HHSUP,    FrameHhsDB::UpdateHhsDB )
+    EVT_BUTTON( wxID_CANCEL, FrameHhsDB::OnClose )
+END_EVENT_TABLE()
+
+// Event Handlers
+void FrameHhsDB::UpdateHhsDB(wxCommandEvent& WXUNUSED(event))
+{
+    //this->m_filePicker->
+    wxString gszFile = wxGetCwd() + wxT("/db/hhs.db");
+    wxSQLite3Database hhsdb;
+    hhsdb.Open( gszFile );
+
+    wxSQLite3Statement stmt = hhsdb.PrepareStatement("INSERT INTO hhs_master VALUES ( ?, ?, ?, ?, ?, ? )");
+
+    //stmt.Bind( 1, hhs );
+    //stmt.Bind( 2, hhs );
+    //stmt.Bind( 3, hhs );
+    //stmt.Bind( 4, hhs );
+    //stmt.Bind( 5, hhs );
+    //stmt.Bind( 6, hhs );
+    wxSQLite3ResultSet q = stmt.ExecuteQuery();
+
+    stmt.Finalize();
+    hhsdb.Close();
+}
+
+void FrameHhsDB::ReadCSV(wxFileDirPickerEvent& WXUNUSED(event))
+{
+    wxString filename = m_filePicker->GetPath();
+    wxTextFile file;
+    if ( file.Open(filename) ) {
+        if ( file.GetLineCount() > 200 ) {
+            wxMessageBox(wxT("件数が200件を超えました．"));
+            return;
+        }
+        for ( size_t r=0; r<file.GetLineCount(); r++ ) {
+            int c = 0;
+            wxStringTokenizer tkz( file[r], wxT(",") );
+            while ( tkz.HasMoreTokens() ) {
+                wxString token = tkz.GetNextToken();
+                m_grid->SetCellValue( r, c, token );
+                c++;
+            }
+        }
+    }
+}
+
+void FrameHhsDB::CheckPassword(wxCommandEvent& WXUNUSED(event))
+{
+    wxString pw = this->m_textCtrlPassword->GetLineText(0);
+    if ( pw.IsSameAs(wxT("9999")) ) {
+        this->m_btnDBUpdate->Enable( true );
+    }
+    else {
+        this->m_btnDBUpdate->Enable( false );
+    }
+}
+
+void FrameHhsDB::OnClose(wxCommandEvent& WXUNUSED(event))
+{
+    Close(true);
+}
+