annotate src/myframe.cpp @ 21:eb3f5c7c990f

small changes.
author pyon@macmini
date Mon, 25 Jul 2011 05:20:55 +0900
parents b67c74848dd0
children 05f76f9f9186
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
0
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
1 // Filename : mainframe.cpp
21
eb3f5c7c990f small changes.
pyon@macmini
parents: 16
diff changeset
2 // Last Change: 22-Jul-2011.
0
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
3 //
12
9452ed888d10 start EazyPrint implementation.
pyon@macmini
parents: 11
diff changeset
4 #include "wx/html/htmprint.h"
9452ed888d10 start EazyPrint implementation.
pyon@macmini
parents: 11
diff changeset
5 #include "wx/print.h"
0
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
6
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
7 #include "symbol.h"
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
8 #include "common.h"
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
9 #include "myframe.h"
21
eb3f5c7c990f small changes.
pyon@macmini
parents: 16
diff changeset
10 #include "ccnframe.h"
0
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
11 #include "hhsdb.h"
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
12 #include "htmlhelp.h"
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
13 #include "main.h"
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
14 #include "wx/wxsqlite3.h"
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
15
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
16 // resources
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
17 // the application icon (under Windows and OS/2 it is in resources and even
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
18 // though we could still include the XPM here it would be unused)
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
19 #if !defined(__WXMSW__) && !defined(__WXPM__)
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
20 #include "sample.xpm"
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
21 #include "print.xpm"
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
22 #include "index.xpm"
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
23 #endif
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
24
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
25 //////////////////////////////////////////////////////////////////////////
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
26 // control constructor
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
27 MyCmdBox::MyCmdBox( wxWindow *parent, wxWindowID id, const wxString value, const wxPoint pos, const wxSize size, long style )
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
28 : wxTextCtrl( parent, id, value, pos, size, style )
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
29 {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
30 // for search history
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
31 hist = wxGetApp().searchhist;
16
b67c74848dd0 fix bugs.
pyon@macmini
parents: 14
diff changeset
32 histpos = 10;
0
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
33
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
34 // for autocomplete hhs
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
35 wxString gszFile = wxGetCwd() + wxT("/db/ccn.db");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
36 wxSQLite3Database ccndb;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
37 ccndb.Open( gszFile );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
38 wxSQLite3Statement stmt = ccndb.PrepareStatement("SELECT hhsno FROM path ORDER BY path DESC LIMIT 500");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
39 wxSQLite3ResultSet q = stmt.ExecuteQuery();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
40
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
41 gszFile = wxGetCwd() + wxT("/db/hhs.db");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
42 wxSQLite3Database hhsdb;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
43 hhsdb.Open( gszFile );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
44 wxSQLite3ResultSet q2;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
45
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
46 wxString hhsno;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
47 while ( q.NextRow() ) {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
48 hhsno = q.GetString(0);
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
49
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
50 recenthhs.Add(hhsno);
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
51
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
52 wxSQLite3Statement stmt2 = hhsdb.PrepareStatement("SELECT name FROM hhs_master WHERE hhsno = ?");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
53 stmt2.Bind( 1, hhsno );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
54 q2 = stmt2.ExecuteQuery();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
55 if ( !q2.IsNull(0) ) {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
56 while ( q2.NextRow() ) {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
57 recentname.Add(q2.GetString(0));
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
58 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
59 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
60 else {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
61 recentname.Add(wxEmptyString);
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
62 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
63 stmt2.Finalize();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
64 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
65 stmt.Finalize();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
66
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
67 hhsdb.Close();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
68 ccndb.Close();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
69 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
70
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
71 // destructor
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
72 MyCmdBox::~MyCmdBox()
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
73 {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
74 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
75
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
76 // Event Table
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
77 BEGIN_EVENT_TABLE( MyCmdBox, wxTextCtrl )
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
78 EVT_CHAR( MyCmdBox::OnChar )
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
79 EVT_TEXT_ENTER( ID_CMD, MyCmdBox::OnCmd )
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
80 END_EVENT_TABLE()
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
81
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
82 // Event Handlers
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
83 void MyCmdBox::OnChar( wxKeyEvent& event )
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
84 {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
85 if ( event.GetKeyCode() == 13 ) {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
86 event.Skip();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
87 return;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
88 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
89
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
90 if ( event.GetKeyCode() == 45 ) { // テンキーの"-"キーで一文字削除
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
91 wxString s = this->GetStringSelection();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
92 if ( s.IsEmpty() ) {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
93 long p = this->GetInsertionPoint();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
94 this->Remove( p-1, p );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
95 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
96 else {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
97 this->Cut();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
98 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
99 return;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
100 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
101
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
102 MyFrame *mf = (MyFrame*)FindWindowById( ID_MAIN );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
103
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
104 if ( event.GetKeyCode() == WXK_UP ) { // ↑
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
105 mf->m_statusBar->SetStatusText( wxEmptyString, 0 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
106 histpos--;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
107 if ( histpos < 0 ) histpos = 0;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
108 this->ChangeValue( hist[histpos] );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
109 return;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
110 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
111 else if ( event.GetKeyCode() == WXK_DOWN ) { // ↓
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
112 mf->m_statusBar->SetStatusText( wxEmptyString, 0 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
113 histpos++;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
114 if ( histpos >= hist.GetCount() ) {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
115 histpos = hist.GetCount();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
116 this->Clear();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
117 return;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
118 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
119 this->ChangeValue( hist[histpos] );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
120 return;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
121 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
122
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
123 if ( event.GetKeyCode() == WXK_ESCAPE ) { // clear by ESC
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
124 this->Clear();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
125 mf->m_statusBar->SetStatusText( wxEmptyString, 0 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
126 return;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
127 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
128
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
129 this->Cut();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
130 int c = event.GetKeyCode();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
131 if ( c >= 48 && c <= 57 ) { // [0-9]
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
132 c -= 48;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
133 wxString input = this->GetLineText(0) + wxString::Format(wxT("%d"),c);
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
134 if ( input.Len() < 5 ) {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
135 event.Skip();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
136 return;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
137 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
138 // autocomplete
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
139 mf->m_statusBar->SetStatusText( wxEmptyString, 0 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
140 for ( int i=0; i<recenthhs.GetCount(); i++ ) {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
141 if ( recenthhs[i].StartsWith( input ) ) {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
142 this->ChangeValue( recenthhs[i] );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
143 this->SetSelection( input.Len(), 10 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
144
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
145 wxString msg = wxT("もしかして... ") + recentname[i] + wxT(" ?!");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
146 mf->m_statusBar->SetStatusText( msg, 0 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
147
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
148 return;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
149 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
150 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
151 event.Skip();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
152 return;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
153 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
154
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
155 event.Skip();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
156 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
157
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
158 void MyCmdBox::OnCmd( wxCommandEvent& event )
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
159 {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
160 wxHtmlWindow *h = (wxHtmlWindow*)FindWindowById( ID_HTML );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
161 wxGrid *g = (wxGrid*)FindWindowById( ID_CCN );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
162 wxSplitterWindow *s = (wxSplitterWindow*)FindWindowById( ID_SPLT );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
163 s->ReplaceWindow( h, g );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
164 h->Show(true);
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
165 g->Show(false);
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
166
8
db7bd315e52c editing mark-sheet image.
pyon@macmini
parents: 3
diff changeset
167 wxRegEx reHhs(wxT("^0[1238][0-9]{8}$")); // 1:被保番チェック
db7bd315e52c editing mark-sheet image.
pyon@macmini
parents: 3
diff changeset
168 wxRegEx reCno(wxT("^[0-9]{1,2}$")); // 2:開くフォルダの番号
14
5ce7757b4350 finish EasyPrint implement.
pyon@macmini
parents: 12
diff changeset
169 wxRegEx rePrint(wxT("^\\+$")); // 3:印刷するフォルダの番号
0
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
170
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
171 wxString cmd;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
172 cmd = this->GetLineText(0);
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
173 int cond = 0;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
174 if ( reHhs.Matches( cmd ) )
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
175 cond = 1;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
176 else if ( reCno.Matches( cmd ) )
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
177 cond = 2;
8
db7bd315e52c editing mark-sheet image.
pyon@macmini
parents: 3
diff changeset
178 else if ( rePrint.Matches( cmd ) )
db7bd315e52c editing mark-sheet image.
pyon@macmini
parents: 3
diff changeset
179 cond = 3;
0
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
180
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
181 wxString htmlbody;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
182
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
183 MyFrame *mf = (MyFrame*)FindWindowById( ID_MAIN );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
184 wxHtmlWindow *hr = (wxHtmlWindow*)FindWindowById( ID_HTML );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
185 switch (cond) {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
186 // 被保険者番号が入力されたら
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
187 case 1: {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
188 wxString hhs = cmd;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
189 mf->m_statusBar->SetStatusText( wxEmptyString, 0 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
190 this->SetSelection( 0, this->GetLastPosition() );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
191
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
192 // 被保険者検索
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
193 wxString gszFile = wxGetCwd() + wxT("/db/hhs.db");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
194 wxSQLite3Database hhsdb;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
195 hhsdb.Open( gszFile );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
196
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
197 wxSQLite3Statement stmt = hhsdb.PrepareStatement("SELECT name FROM hhs_master WHERE hhsno = ?");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
198 stmt.Bind( 1, hhs );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
199 wxSQLite3ResultSet q = stmt.ExecuteQuery();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
200
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
201 wxString name = wxT("登録なし");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
202 if ( q.IsNull(0) ) {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
203 wxString msg = wxT("データベースに存在しない被保険者です.") + hhs;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
204 mf->m_statusBar->SetStatusText( msg, 0 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
205 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
206 else {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
207 name = q.GetString(0);
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
208 hist.Add( hhs );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
209 histpos++;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
210 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
211 stmt.Finalize();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
212 hhsdb.Close();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
213
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
214 // パス検索
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
215 gszFile = wxGetCwd() + wxT("/db/ccn.db");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
216 wxSQLite3Database ccndb;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
217 ccndb.Open( gszFile );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
218
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
219 stmt = ccndb.PrepareStatement("SELECT path FROM path WHERE hhsno = ? ORDER BY path DESC");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
220 stmt.Bind( 1, hhs );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
221 q = stmt.ExecuteQuery();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
222 if ( q.IsNull(0) ) {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
223 hr->LoadPage( wxT("html/notfound.html") );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
224 mf->m_statusBar->SetStatusText( wxT("データが存在しません."), 0 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
225 return;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
226 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
227
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
228 path.Clear();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
229 wxRegEx reDate(wxT("(^.*20[0-9]{2}.)(20[0-9]{2})([0-2][0-9])([0-9]{2})(.*$)"));
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
230
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
231 int i=1;
11
07adad93df84 ver2.9 Add Name-View
pyon@macmini
parents: 10
diff changeset
232 int clrflg = -1;
0
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
233 while ( q.NextRow() ) {
11
07adad93df84 ver2.9 Add Name-View
pyon@macmini
parents: 10
diff changeset
234 wxString filepath = q.GetString(0);
10
24e0775af32e Add Name-View.
pyon@macmini
parents: 8
diff changeset
235 // 氏名画像生成
11
07adad93df84 ver2.9 Add Name-View
pyon@macmini
parents: 10
diff changeset
236 wxDir dir(filepath);
07adad93df84 ver2.9 Add Name-View
pyon@macmini
parents: 10
diff changeset
237 wxString file;
07adad93df84 ver2.9 Add Name-View
pyon@macmini
parents: 10
diff changeset
238 if ( !dir.IsOpened() ) return;
10
24e0775af32e Add Name-View.
pyon@macmini
parents: 8
diff changeset
239
11
07adad93df84 ver2.9 Add Name-View
pyon@macmini
parents: 10
diff changeset
240 if ( clrflg == -1 ) {
10
24e0775af32e Add Name-View.
pyon@macmini
parents: 8
diff changeset
241 bool cout = dir.GetFirst( &file, wxT("*.jpg"), wxDIR_FILES );
24e0775af32e Add Name-View.
pyon@macmini
parents: 8
diff changeset
242 if ( cout ) {
24e0775af32e Add Name-View.
pyon@macmini
parents: 8
diff changeset
243 wxString s = filepath + wxFILE_SEP_PATH + file;
24e0775af32e Add Name-View.
pyon@macmini
parents: 8
diff changeset
244 wxImage img_org( s, wxBITMAP_TYPE_JPEG );
24e0775af32e Add Name-View.
pyon@macmini
parents: 8
diff changeset
245 wxImage img_name;
24e0775af32e Add Name-View.
pyon@macmini
parents: 8
diff changeset
246 img_name = img_org.GetSubImage( wxRect( wxPoint(328,556), wxSize(626,288) ) );
11
07adad93df84 ver2.9 Add Name-View
pyon@macmini
parents: 10
diff changeset
247 img_name = img_name.Scale( 200, 92 );
10
24e0775af32e Add Name-View.
pyon@macmini
parents: 8
diff changeset
248 img_name.SaveFile( wxT("tmp/tmp.jpg") );
11
07adad93df84 ver2.9 Add Name-View
pyon@macmini
parents: 10
diff changeset
249
07adad93df84 ver2.9 Add Name-View
pyon@macmini
parents: 10
diff changeset
250 // HTML生成
07adad93df84 ver2.9 Add Name-View
pyon@macmini
parents: 10
diff changeset
251 htmlbody = wxT("<html><body>");
07adad93df84 ver2.9 Add Name-View
pyon@macmini
parents: 10
diff changeset
252 htmlbody += wxT("<table border=0>");
07adad93df84 ver2.9 Add Name-View
pyon@macmini
parents: 10
diff changeset
253 htmlbody += wxT("<tr bgcolor=\"#ffffcc\"><td>該当者: </td><td></td></tr>");
07adad93df84 ver2.9 Add Name-View
pyon@macmini
parents: 10
diff changeset
254 htmlbody += wxT("<tr><td><b>") + name + wxT("</b></td>");
07adad93df84 ver2.9 Add Name-View
pyon@macmini
parents: 10
diff changeset
255 htmlbody += wxT("<td> ( ") + hhs + wxT(" )") + wxT("</td></tr>");
07adad93df84 ver2.9 Add Name-View
pyon@macmini
parents: 10
diff changeset
256 htmlbody += wxT("</table><br /><br />");
07adad93df84 ver2.9 Add Name-View
pyon@macmini
parents: 10
diff changeset
257 htmlbody += wxT("<table border=0>");
07adad93df84 ver2.9 Add Name-View
pyon@macmini
parents: 10
diff changeset
258 htmlbody += wxT("<tr><td bgcolor=\"#ffffcc\">番号1の画像情報:</td></tr>");
07adad93df84 ver2.9 Add Name-View
pyon@macmini
parents: 10
diff changeset
259 htmlbody += wxT("<tr><td><img src=\"tmp/tmp.jpg\" /></td></tr>");
07adad93df84 ver2.9 Add Name-View
pyon@macmini
parents: 10
diff changeset
260 htmlbody += wxT("</table>");
07adad93df84 ver2.9 Add Name-View
pyon@macmini
parents: 10
diff changeset
261 htmlbody += wxT("<br /><br />検索結果");
07adad93df84 ver2.9 Add Name-View
pyon@macmini
parents: 10
diff changeset
262 htmlbody += wxT("<table border=1>");
07adad93df84 ver2.9 Add Name-View
pyon@macmini
parents: 10
diff changeset
263 htmlbody += wxT("<tr bgcolor=\"#ffcc33\"><th>番号</th><th>日付</th><th>フォルダ</th></tr>");
10
24e0775af32e Add Name-View.
pyon@macmini
parents: 8
diff changeset
264 }
11
07adad93df84 ver2.9 Add Name-View
pyon@macmini
parents: 10
diff changeset
265 clrflg = 1;
07adad93df84 ver2.9 Add Name-View
pyon@macmini
parents: 10
diff changeset
266 }
10
24e0775af32e Add Name-View.
pyon@macmini
parents: 8
diff changeset
267
24e0775af32e Add Name-View.
pyon@macmini
parents: 8
diff changeset
268 path.Add(filepath);
24e0775af32e Add Name-View.
pyon@macmini
parents: 8
diff changeset
269 wxString date = filepath;
0
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
270 reDate.ReplaceAll( &date, wxT("\\2-\\3-\\4") );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
271
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
272 if ( clrflg ) {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
273 htmlbody += wxT("<tr bgcolor=\"#ffffcc\">");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
274 clrflg = 0;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
275 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
276 else {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
277 htmlbody += wxT("<tr bgcolor=\"#ffff99\">");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
278 clrflg = 1;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
279 }
1
e0cf49906039 start editing preview.cpp / preview.h
pyon@macmini
parents: 0
diff changeset
280 htmlbody += wxT("<td align=\"center\">") + wxString::Format(wxT("%d"),i++) + wxT("</td>"); // 番号
e0cf49906039 start editing preview.cpp / preview.h
pyon@macmini
parents: 0
diff changeset
281 htmlbody += wxT("<td>") + date + wxT("</td>"); // 日付
e0cf49906039 start editing preview.cpp / preview.h
pyon@macmini
parents: 0
diff changeset
282 htmlbody += wxT("<td>") + q.GetString(0) + wxT("</td></tr>"); // フォルダパス
0
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
283 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
284 stmt.Finalize();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
285 ccndb.Close();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
286 path.Shrink();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
287
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
288 htmlbody += wxT("</table>");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
289 htmlbody += wxT("<br />");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
290 htmlbody += wxT("<div>");
14
5ce7757b4350 finish EasyPrint implement.
pyon@macmini
parents: 12
diff changeset
291 htmlbody += wxT("テンキーの「+」ボタンで番号1の画像を印刷できます.<br />");
0
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
292 htmlbody += wxT("フォルダを開くには,番号を入力してください.<br />");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
293 htmlbody += wxT("他の被保険者を検索するには,被保番を入力してください.");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
294 htmlbody += wxT("</div>");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
295 htmlbody += wxT("</body></html>");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
296
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
297 hr->SetPage( htmlbody );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
298
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
299 break;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
300 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
301 // フォルダ表示
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
302 case 2: {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
303 this->SetSelection( 0, this->GetLastPosition() );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
304 long val;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
305 cmd.ToLong( &val, 10 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
306 val--;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
307 if ( path.IsEmpty()
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
308 || val < 0
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
309 || val > path.GetCount()-1 ) {
11
07adad93df84 ver2.9 Add Name-View
pyon@macmini
parents: 10
diff changeset
310 mf->m_statusBar->SetStatusText( wxT("不適切な入力です.警告コード2"), 0 );
0
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
311 break;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
312 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
313 wxString execmd = wxT("explorer ") + path[val];
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
314 wxExecute( execmd );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
315 mf->m_statusBar->SetStatusText( wxEmptyString, 0 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
316
16
b67c74848dd0 fix bugs.
pyon@macmini
parents: 14
diff changeset
317 WriteLog( cmd, path[val] );
0
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
318 break;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
319 }
8
db7bd315e52c editing mark-sheet image.
pyon@macmini
parents: 3
diff changeset
320 // ファイル印刷
db7bd315e52c editing mark-sheet image.
pyon@macmini
parents: 3
diff changeset
321 case 3: {
11
07adad93df84 ver2.9 Add Name-View
pyon@macmini
parents: 10
diff changeset
322 this->SetSelection( 0, this->GetLastPosition() );
07adad93df84 ver2.9 Add Name-View
pyon@macmini
parents: 10
diff changeset
323 if ( path.IsEmpty() ) {
07adad93df84 ver2.9 Add Name-View
pyon@macmini
parents: 10
diff changeset
324 mf->m_statusBar->SetStatusText( wxT("不適切な入力です.警告コード3"), 0 );
07adad93df84 ver2.9 Add Name-View
pyon@macmini
parents: 10
diff changeset
325 break;
07adad93df84 ver2.9 Add Name-View
pyon@macmini
parents: 10
diff changeset
326 }
12
9452ed888d10 start EazyPrint implementation.
pyon@macmini
parents: 11
diff changeset
327 PrintImages( path[0] );
16
b67c74848dd0 fix bugs.
pyon@macmini
parents: 14
diff changeset
328 WriteLog( cmd, path[0] );
8
db7bd315e52c editing mark-sheet image.
pyon@macmini
parents: 3
diff changeset
329 break;
db7bd315e52c editing mark-sheet image.
pyon@macmini
parents: 3
diff changeset
330 }
0
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
331 // 制御用コマンド
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
332 case 0: {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
333 path.Clear();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
334 if ( cmd.Cmp(wxT("s")) == 0 ) {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
335 hr->LoadPage( wxT("html/start.html") );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
336 this->ChangeValue( wxEmptyString );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
337 mf->m_statusBar->SetStatusText( wxEmptyString, 0 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
338 return;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
339 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
340 if ( cmd.Cmp(wxT("c")) == 0 ) {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
341 hr->LoadPage( wxT("Searcher2.conf") );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
342 this->ChangeValue( wxEmptyString );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
343 mf->m_statusBar->SetStatusText( wxEmptyString, 0 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
344 return;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
345 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
346 if ( cmd.Cmp(wxT("t")) == 0 ) {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
347 hr->LoadPage( wxT("html/todo.html") );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
348 this->ChangeValue( wxEmptyString );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
349 mf->m_statusBar->SetStatusText( wxEmptyString, 0 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
350 return;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
351 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
352 if ( cmd.Cmp(wxT("l")) == 0 ) {
10
24e0775af32e Add Name-View.
pyon@macmini
parents: 8
diff changeset
353 hr->LoadPage( wxT("tmp/log.txt") );
0
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
354 this->ChangeValue( wxEmptyString );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
355 mf->m_statusBar->SetStatusText( wxEmptyString, 0 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
356 return;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
357 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
358 if ( cmd.Cmp(wxT("**")) == 0 ) {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
359 mf->m_statusBar->SetStatusText( wxT("Now Saving..."), 0 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
360 mf->Close();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
361 return;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
362 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
363
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
364 mf->m_statusBar->SetStatusText( wxT("不適切な入力です."), 0 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
365 this->SetSelection( 0, this->GetLastPosition() );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
366
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
367 break;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
368 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
369 //
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
370 default: {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
371 break;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
372 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
373 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
374 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
375
12
9452ed888d10 start EazyPrint implementation.
pyon@macmini
parents: 11
diff changeset
376 // functions
9452ed888d10 start EazyPrint implementation.
pyon@macmini
parents: 11
diff changeset
377 void MyCmdBox::PrintImages( wxString& path )
9452ed888d10 start EazyPrint implementation.
pyon@macmini
parents: 11
diff changeset
378 {
14
5ce7757b4350 finish EasyPrint implement.
pyon@macmini
parents: 12
diff changeset
379 wxHtmlPrintout hpout( wxT("Searcher2") );
5ce7757b4350 finish EasyPrint implement.
pyon@macmini
parents: 12
diff changeset
380 hpout.SetMargins( 0,0,0,0,0 );
5ce7757b4350 finish EasyPrint implement.
pyon@macmini
parents: 12
diff changeset
381 wxPrintDialogData pd;
5ce7757b4350 finish EasyPrint implement.
pyon@macmini
parents: 12
diff changeset
382 wxPrinter p( &pd );
12
9452ed888d10 start EazyPrint implementation.
pyon@macmini
parents: 11
diff changeset
383
9452ed888d10 start EazyPrint implementation.
pyon@macmini
parents: 11
diff changeset
384 wxDir dir(path);
9452ed888d10 start EazyPrint implementation.
pyon@macmini
parents: 11
diff changeset
385 wxString file;
9452ed888d10 start EazyPrint implementation.
pyon@macmini
parents: 11
diff changeset
386 if ( !dir.IsOpened() ) return;
9452ed888d10 start EazyPrint implementation.
pyon@macmini
parents: 11
diff changeset
387
9452ed888d10 start EazyPrint implementation.
pyon@macmini
parents: 11
diff changeset
388 bool cout = dir.GetFirst( &file, wxT("*.jpg"), wxDIR_FILES );
14
5ce7757b4350 finish EasyPrint implement.
pyon@macmini
parents: 12
diff changeset
389 bool mask_flg = true;
5ce7757b4350 finish EasyPrint implement.
pyon@macmini
parents: 12
diff changeset
390 wxRect cmname( wxPoint(156,224), wxSize(1204,122) );
5ce7757b4350 finish EasyPrint implement.
pyon@macmini
parents: 12
diff changeset
391 wxRect cmno( wxPoint(856,1024), wxSize(1060,598) );
12
9452ed888d10 start EazyPrint implementation.
pyon@macmini
parents: 11
diff changeset
392 while ( cout ) {
9452ed888d10 start EazyPrint implementation.
pyon@macmini
parents: 11
diff changeset
393 file = path + wxFILE_SEP_PATH + file;
9452ed888d10 start EazyPrint implementation.
pyon@macmini
parents: 11
diff changeset
394 file.Replace( wxT("\\"), wxT("/") );
9452ed888d10 start EazyPrint implementation.
pyon@macmini
parents: 11
diff changeset
395 wxString html;
9452ed888d10 start EazyPrint implementation.
pyon@macmini
parents: 11
diff changeset
396
14
5ce7757b4350 finish EasyPrint implement.
pyon@macmini
parents: 12
diff changeset
397 if ( mask_flg ) { // 1枚目はマスクする
5ce7757b4350 finish EasyPrint implement.
pyon@macmini
parents: 12
diff changeset
398 wxImage img_org( file, wxBITMAP_TYPE_JPEG );
5ce7757b4350 finish EasyPrint implement.
pyon@macmini
parents: 12
diff changeset
399 img_org.SetRGB( cmname, 255, 255, 255 );
5ce7757b4350 finish EasyPrint implement.
pyon@macmini
parents: 12
diff changeset
400 img_org.SetRGB( cmno, 255, 255, 255 );
5ce7757b4350 finish EasyPrint implement.
pyon@macmini
parents: 12
diff changeset
401 img_org.SaveFile( wxT("tmp/tmp.jpg") );
5ce7757b4350 finish EasyPrint implement.
pyon@macmini
parents: 12
diff changeset
402
5ce7757b4350 finish EasyPrint implement.
pyon@macmini
parents: 12
diff changeset
403 html = html + wxT("<html><body>");
5ce7757b4350 finish EasyPrint implement.
pyon@macmini
parents: 12
diff changeset
404 html = html + wxT("<img src=\"tmp/tmp.jpg\" width=\"750\" height=\"1060\"/>");
5ce7757b4350 finish EasyPrint implement.
pyon@macmini
parents: 12
diff changeset
405 html = html + wxT("</body></html>");
5ce7757b4350 finish EasyPrint implement.
pyon@macmini
parents: 12
diff changeset
406 hpout.SetHtmlText( html, wxEmptyString, false );
5ce7757b4350 finish EasyPrint implement.
pyon@macmini
parents: 12
diff changeset
407 p.Print( NULL, &hpout, true );
5ce7757b4350 finish EasyPrint implement.
pyon@macmini
parents: 12
diff changeset
408 pd = p.GetPrintDialogData();
5ce7757b4350 finish EasyPrint implement.
pyon@macmini
parents: 12
diff changeset
409 mask_flg = false;
5ce7757b4350 finish EasyPrint implement.
pyon@macmini
parents: 12
diff changeset
410 }
5ce7757b4350 finish EasyPrint implement.
pyon@macmini
parents: 12
diff changeset
411 else {
5ce7757b4350 finish EasyPrint implement.
pyon@macmini
parents: 12
diff changeset
412 html = html + wxT("<html><body>");
5ce7757b4350 finish EasyPrint implement.
pyon@macmini
parents: 12
diff changeset
413 html = html + wxT("<img src=\"") + file + wxT("\" width=\"750\" height=\"1060\"/>");
5ce7757b4350 finish EasyPrint implement.
pyon@macmini
parents: 12
diff changeset
414 html = html + wxT("</body></html>");
5ce7757b4350 finish EasyPrint implement.
pyon@macmini
parents: 12
diff changeset
415 hpout.SetHtmlText( html, wxEmptyString, false );
5ce7757b4350 finish EasyPrint implement.
pyon@macmini
parents: 12
diff changeset
416 p.Print( NULL, &hpout, false );
5ce7757b4350 finish EasyPrint implement.
pyon@macmini
parents: 12
diff changeset
417 }
12
9452ed888d10 start EazyPrint implementation.
pyon@macmini
parents: 11
diff changeset
418 cout = dir.GetNext( &file );
9452ed888d10 start EazyPrint implementation.
pyon@macmini
parents: 11
diff changeset
419 }
9452ed888d10 start EazyPrint implementation.
pyon@macmini
parents: 11
diff changeset
420 return;
9452ed888d10 start EazyPrint implementation.
pyon@macmini
parents: 11
diff changeset
421 }
9452ed888d10 start EazyPrint implementation.
pyon@macmini
parents: 11
diff changeset
422
16
b67c74848dd0 fix bugs.
pyon@macmini
parents: 14
diff changeset
423 // 検索履歴をログに保存
b67c74848dd0 fix bugs.
pyon@macmini
parents: 14
diff changeset
424 void MyCmdBox::WriteLog( wxString& cmd, wxString& path )
b67c74848dd0 fix bugs.
pyon@macmini
parents: 14
diff changeset
425 {
b67c74848dd0 fix bugs.
pyon@macmini
parents: 14
diff changeset
426 wxString logfn = wxGetCwd() + wxFILE_SEP_PATH + wxT("tmp") + wxFILE_SEP_PATH + wxT("log.txt");
b67c74848dd0 fix bugs.
pyon@macmini
parents: 14
diff changeset
427 wxTextFile logFile;
b67c74848dd0 fix bugs.
pyon@macmini
parents: 14
diff changeset
428 logFile.Open( logfn );
b67c74848dd0 fix bugs.
pyon@macmini
parents: 14
diff changeset
429 wxDateTime now = wxDateTime::Now();
b67c74848dd0 fix bugs.
pyon@macmini
parents: 14
diff changeset
430 wxString log = now.Format( wxT("%Y-%m-%d %H:%M:%S") ) + wxT(" ") + cmd + wxT(" ") + path;
b67c74848dd0 fix bugs.
pyon@macmini
parents: 14
diff changeset
431 logFile.AddLine( log );
b67c74848dd0 fix bugs.
pyon@macmini
parents: 14
diff changeset
432 logFile.Write();
b67c74848dd0 fix bugs.
pyon@macmini
parents: 14
diff changeset
433 logFile.Close();
b67c74848dd0 fix bugs.
pyon@macmini
parents: 14
diff changeset
434
b67c74848dd0 fix bugs.
pyon@macmini
parents: 14
diff changeset
435 return;
b67c74848dd0 fix bugs.
pyon@macmini
parents: 14
diff changeset
436 }
b67c74848dd0 fix bugs.
pyon@macmini
parents: 14
diff changeset
437
0
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
438 //////////////////////////////////////////////////////////////////////////
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
439 // frame constructor
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
440 MyFrame::MyFrame( wxWindow* parent, wxWindowID id, const wxString& title )
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
441 : wxFrame( parent, id, title )
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
442 {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
443 this->SetSizeHints( wxDefaultSize, wxDefaultSize );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
444 // set the frame icon
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
445 SetIcon(wxICON(sample));
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
446
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
447 // メニューバー
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
448 m_menubar = new wxMenuBar();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
449
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
450 m_menuFile = new wxMenu();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
451 m_menuFile->Append( ID_MUPHHS, wxT("被保険者DB更新"), wxT("Update hhs-db") );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
452 m_menuFile->Append( ID_MLSCCN, wxT("インデックス更新一覧"), wxT("List index") );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
453 m_menuFile->AppendSeparator(); //----
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
454 wxMenu *menuMaintain = new wxMenu();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
455 m_menuFile->AppendSubMenu( menuMaintain, wxT("メンテナンス") );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
456 menuMaintain->Append( ID_MDBBKUP, wxT("データベースバックアップ"), wxT("Backup DBs") );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
457 menuMaintain->Append( ID_MDBOPT, wxT("データベース最適化"), wxT("Optimize DBs") );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
458 menuMaintain->Enable( ID_MDBOPT, false );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
459 menuMaintain->Append( ID_MCHKHHS, wxT("被保者整合性チェック"), wxT("Check hhs") );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
460 m_menuFile->AppendSeparator(); //----
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
461 wxMenu *menuOpendir = new wxMenu();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
462 m_menuFile->AppendSubMenu( menuOpendir, wxT("フォルダを開く") );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
463 menuOpendir->Append( ID_MOAD, wxT("アプリケーションフォルダ"), wxT("Open App Folder") );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
464 menuOpendir->Append( ID_MODD, wxT("データフォルダ"), wxT("Open Data Folder") );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
465 m_menuFile->AppendSeparator(); //----
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
466 m_menuFile->Append( wxID_EXIT, wxT("終了(&X)\tAlt-X"), wxT("Quit this program") );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
467
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
468 m_menuHelp = new wxMenu();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
469 m_menuHelp->Append( ID_MHELP, wxT("&Help"), wxT("Show help") );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
470 m_menuHelp->Append( wxID_ABOUT, wxT("&About...\tF1"), wxT("Show about dialog") );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
471
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
472 // now append the freshly created menu to the menu bar...
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
473 m_menubar->Append( m_menuFile, wxT("ファイル(&F)") );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
474 m_menubar->Append( m_menuHelp, wxT("ヘルプ(&H)") );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
475
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
476 this->SetMenuBar( m_menubar );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
477
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
478 // ツールバー
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
479 //m_toolBar = new wxToolBar( this, wxID_ANY, wxDefaultPosition, wxDefaultSize, wxTB_HORIZONTAL|wxNO_BORDER );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
480 //wxBitmap bmpPrint( print_xpm );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
481 //wxBitmap bmpIndex( index_xpm );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
482
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
483 // ステータスバー
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
484 int widths[] = { -1, 120, 100 };
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
485 m_statusBar = this->CreateStatusBar( WXSIZEOF(widths), wxST_SIZEGRIP );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
486 m_statusBar->SetStatusWidths( WXSIZEOF(widths), widths );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
487 m_statusBar->SetStatusText( wxEmptyString, 0 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
488
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
489 wxBoxSizer* bSizer;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
490 bSizer = new wxBoxSizer( wxVERTICAL );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
491
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
492 // controls here
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
493 m_panelHead = new wxPanel( this, wxID_ANY, wxDefaultPosition, wxDefaultSize );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
494 wxBoxSizer* bSizerHead;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
495 bSizerHead = new wxBoxSizer( wxHORIZONTAL );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
496
3
75fefb53d983 update preview.
pyon@macmini
parents: 1
diff changeset
497 /* after version 2.11
0
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
498 m_staticTextHname = new wxStaticText( m_panelHead, wxID_ANY, wxT("氏名カナ検索"), wxDefaultPosition, wxDefaultSize, 0 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
499 bSizerHead->Add( m_staticTextHname, 0, wxALL, 5 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
500
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
501 m_searchCtrlHname = new wxSearchCtrl( m_panelHead, ID_SRCHHHS, wxT("3字以上入力"), wxDefaultPosition, wxSize(200,20), 0 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
502 #ifndef __WXMAC__
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
503 m_searchCtrlHname->ShowSearchButton( true );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
504 #endif
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
505 bSizerHead->Add( m_searchCtrlHname, 0, wxALL, 1 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
506
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
507 m_bitmapMkidx = new wxStaticBitmap( m_panelHead, wxID_ANY, wxNullBitmap, wxDefaultPosition, wxDefaultSize, 0 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
508 bSizerHead->Add( m_bitmapMkidx, 0, wxALL, 1 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
509 */
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
510
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
511 bSizerHead->AddStretchSpacer( 1 ); // spacer
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
512
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
513 m_staticTextIdx = new wxStaticText( m_panelHead, wxID_ANY, wxT("インデックス"), wxDefaultPosition, wxDefaultSize, 0 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
514 bSizerHead->Add( m_staticTextIdx, 0, wxALIGN_CENTER_VERTICAL|wxALL, 5 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
515
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
516 m_datePicker = new wxDatePickerCtrl( m_panelHead, ID_DTIDX, wxDefaultDateTime, wxDefaultPosition, wxDefaultSize, wxDP_SHOWCENTURY|wxDP_DROPDOWN );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
517 bSizerHead->Add( m_datePicker, 0, wxALIGN_CENTER_VERTICAL|wxALL, 5 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
518
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
519 m_buttonMkidx = new wxButton( m_panelHead, ID_MKIDX, wxT("作成"), wxDefaultPosition, wxSize(50,25), 0 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
520 bSizerHead->Add( m_buttonMkidx, 0, wxALL, 5 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
521
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
522 m_panelHead->SetSizer( bSizerHead );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
523 m_panelHead->Layout();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
524 bSizerHead->Fit( m_panelHead );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
525
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
526 // メインペイン
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
527 wxBoxSizer* bSizerHtml;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
528 bSizerHtml = new wxBoxSizer( wxVERTICAL );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
529 m_splitter = new wxSplitterWindow( this, ID_SPLT, wxDefaultPosition, wxDefaultSize, 0 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
530
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
531 // 検索結果Html
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
532 m_html = new wxHtmlWindow( m_splitter, ID_HTML, wxDefaultPosition, wxDefaultSize, wxHW_SCROLLBAR_AUTO );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
533 m_html->LoadPage( wxT("html/start.html") );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
534
3
75fefb53d983 update preview.
pyon@macmini
parents: 1
diff changeset
535 /* after version 2.11
0
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
536 // 被保険者カナ検索Grid
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
537 m_gridHhs = new wxGrid( m_panelHtml, ID_HLST, wxDefaultPosition, wxDefaultSize, 0 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
538 m_gridHhs->CreateGrid( 0, 5 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
539 m_gridHhs->EnableEditing( true );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
540 m_gridHhs->EnableGridLines( true );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
541 m_gridHhs->EnableDragGridSize( false );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
542 m_gridHhs->SetMargins( 0, 0 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
543
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
544 // Columns
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
545 m_gridHhs->AutoSizeColumns();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
546 m_gridHhs->EnableDragColMove( false );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
547 m_gridHhs->SetColLabelValue( 0, wxT("番号") );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
548 m_gridHhs->SetColLabelValue( 1, wxT("氏名") );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
549 m_gridHhs->SetColLabelValue( 2, wxT("カナ") );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
550 m_gridHhs->SetColLabelValue( 3, wxT("生年月日") );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
551 m_gridHhs->SetColLabelValue( 4, wxT("住所") );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
552 m_gridHhs->SetColLabelAlignment( wxALIGN_CENTRE, wxALIGN_CENTRE );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
553
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
554 // Cell Defaults
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
555 m_gridHhs->SetDefaultCellAlignment( wxALIGN_LEFT, wxALIGN_BOTTOM );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
556 m_gridHhs->Hide();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
557
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
558 bSizerHtml->Add( m_gridHhs, 0, wxALL, 5 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
559 */
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
560
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
561 // 審査会合議体表示Grid
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
562 m_gridCcn = new wxGrid( m_splitter, ID_CCN, wxDefaultPosition, wxDefaultSize, 0 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
563 m_gridCcn->CreateGrid( 0, 2 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
564 m_gridCcn->EnableEditing( true );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
565 m_gridCcn->EnableGridLines( true );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
566 m_gridCcn->EnableDragGridSize( false );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
567 m_gridCcn->SetMargins( 0, 0 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
568 m_gridCcn->SetDefaultCellAlignment( wxALIGN_CENTRE, wxALIGN_BOTTOM );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
569 m_gridCcn->Show(false);
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
570
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
571 // Columns
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
572 m_gridCcn->AutoSizeColumns();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
573 m_gridCcn->EnableDragColMove( false );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
574 m_gridCcn->SetColLabelValue( 0, wxT("審査会年月日") );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
575 m_gridCcn->SetColLabelValue( 1, wxT("DB更新時刻") );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
576 m_gridCcn->SetColSize( 0, 100 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
577 m_gridCcn->SetColSize( 1, 200 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
578 m_gridCcn->SetColLabelAlignment( wxALIGN_CENTRE, wxALIGN_CENTRE );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
579
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
580 m_splitter->Initialize( m_html );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
581 m_splitter->SetSizer( bSizerHtml );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
582 m_splitter->Layout();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
583 bSizerHtml->Fit( m_splitter );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
584
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
585 // コマンドライン
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
586 m_panelCmd = new wxPanel( this, wxID_ANY, wxDefaultPosition, wxDefaultSize );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
587 wxBoxSizer* bSizerCmd;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
588 bSizerCmd = new wxBoxSizer( wxHORIZONTAL );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
589
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
590 m_staticTextCmd = new wxStaticText( m_panelCmd, wxID_ANY, wxT("コマンド?"), wxDefaultPosition, wxDefaultSize, 0 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
591 bSizerCmd->Add( m_staticTextCmd, 0, wxALL, 5 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
592
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
593 m_cmdbox = new MyCmdBox( m_panelCmd, ID_CMD, wxEmptyString, wxDefaultPosition, wxDefaultSize, wxTE_PROCESS_ENTER );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
594 bSizerCmd->Add( m_cmdbox, 1, wxALL, 3 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
595 m_cmdbox->SetFocus();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
596
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
597 m_panelCmd->SetSizer( bSizerCmd );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
598 m_panelCmd->Layout();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
599 bSizerCmd->Fit( m_panelCmd );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
600
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
601
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
602 bSizer->Add( m_panelHead, 0, wxEXPAND|wxTOP, 1 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
603 bSizer->Add( m_splitter, 1, wxEXPAND|wxALL, 1 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
604 bSizer->Add( m_panelCmd, 0, wxEXPAND|wxALL, 0 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
605
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
606 this->SetSizer( bSizer );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
607 this->Layout();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
608 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
609
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
610 // destructor
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
611 MyFrame::~MyFrame()
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
612 {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
613 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
614
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
615 // Event Table
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
616 BEGIN_EVENT_TABLE( MyFrame, wxFrame )
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
617 EVT_MENU( wxID_EXIT, MyFrame::OnQuit )
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
618 EVT_MENU( wxID_ABOUT, MyFrame::OnAbout )
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
619 EVT_MENU( ID_MUPHHS, MyFrame::OnUpdateHhsDb )
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
620 EVT_MENU( ID_MLSCCN, MyFrame::OnListCcn )
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
621 EVT_MENU( ID_MDBBKUP, MyFrame::OnBackupDB )
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
622 EVT_MENU( ID_MDBOPT, MyFrame::OnOptimizeDB )
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
623 EVT_MENU( ID_MCHKHHS, MyFrame::OnCheckHhs )
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
624 EVT_MENU( ID_MOAD, MyFrame::OnOpenAppDir )
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
625 EVT_MENU( ID_MODD, MyFrame::OnOpenDataDir )
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
626 EVT_MENU( ID_MHELP, MyFrame::OnHelp )
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
627
3
75fefb53d983 update preview.
pyon@macmini
parents: 1
diff changeset
628 //EVT_TEXT_ENTER( ID_SRCHHHS, MyFrame::OnHhsSearch ) after version 2.11
0
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
629 EVT_BUTTON( ID_MKIDX, MyFrame::OnMkIndex )
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
630
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
631 EVT_CLOSE( MyFrame::SaveConfig )
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
632 END_EVENT_TABLE()
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
633
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
634 // Event Handlers
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
635 /* 終了 */
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
636 void MyFrame::OnQuit(wxCommandEvent& WXUNUSED(event))
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
637 {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
638 Close(true);
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
639 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
640
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
641 /* オンラインヘルプ */
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
642 void MyFrame::OnHelp(wxCommandEvent& WXUNUSED(event))
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
643 {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
644 HtmlHelpFrame *f = (HtmlHelpFrame*)FindWindowById( ID_HELP );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
645
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
646 if ( f == NULL ) {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
647 HtmlHelpFrame *helpframe = new HtmlHelpFrame( wxT("Online Help"), ID_HELP );
14
5ce7757b4350 finish EasyPrint implement.
pyon@macmini
parents: 12
diff changeset
648 helpframe->SetSize(600,600);
0
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
649 helpframe->Show(true);
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
650 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
651 else {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
652 f->Raise();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
653 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
654 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
655
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
656 /* バージョン情報 */
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
657 void MyFrame::OnAbout(wxCommandEvent& WXUNUSED(event))
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
658 {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
659 wxSQLite3Database sqlite;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
660 wxMessageBox(
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
661 wxString::Format(
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
662 wxT("Version %d.%d ( build %d ) by %s\n")
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
663 wxT("with SQLite library %s\n")
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
664 wxT("running under %s."),
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
665 VER, REV, BLD, wxVERSION_STRING,
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
666 sqlite.GetVersion().c_str(),
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
667 wxGetOsDescription().c_str()
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
668 ),
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
669 wxT("About this program"), wxOK | wxICON_INFORMATION, this );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
670 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
671
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
672 /* 被保険者検索 */
3
75fefb53d983 update preview.
pyon@macmini
parents: 1
diff changeset
673 /* after version 2.11
0
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
674 void MyFrame::OnHhsSearch(wxCommandEvent& WXUNUSED(event))
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
675 {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
676 this->m_html->Hide();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
677 this->m_gridCcn->Hide();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
678 this->m_gridHhs->Show(true);
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
679
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
680 wxString gszFile = wxGetCwd() + wxT("/db/hhs.db");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
681 wxSQLite3Database hhsdb;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
682 hhsdb.Open( gszFile );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
683
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
684 wxSQLite3Statement stmt = hhsdb.PrepareStatement("SELECT count(*) FROM hhs_master WHERE kana LIKE ?");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
685 stmt.Bind( 1, this->m_searchCtrlHname->GetValue() );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
686 wxSQLite3ResultSet q = stmt.ExecuteQuery();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
687 wxString cnt = q.GetString(0);
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
688
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
689 if ( cnt.Cmp(wxT("0")) == '0' ) {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
690 wxString msg = cnt + wxT("指定した条件の被保険者はいませんでした.");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
691 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
692 else {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
693 wxString msg = cnt + wxT("件マッチしました.");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
694 return ; // test now
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
695
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
696 stmt = hhsdb.PrepareStatement("SELECT hhs, name, kana, addr, birth, sex FROM hhs_master ORDER BY birth DESC");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
697 q = stmt.ExecuteQuery();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
698 wxSQLite3ResultSet q = stmt.ExecuteQuery();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
699 while ( q.NextRow() ) {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
700 wxString hhs = q.GetString(0);
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
701 wxString name = q.GetString(1);
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
702 wxString kana = q.GetString(2);
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
703 wxString addr = q.GetString(3);
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
704 wxString birth = q.GetString(4);
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
705 wxString sex = q.GetString(5);
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
706 // ここに gridに 追加するコード
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
707 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
708 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
709
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
710 stmt.Finalize();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
711 hhsdb.Close();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
712 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
713 */
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
714
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
715 /* インデックス作成 */
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
716 void MyFrame::OnMkIndex(wxCommandEvent& WXUNUSED(event))
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
717 {
21
eb3f5c7c990f small changes.
pyon@macmini
parents: 16
diff changeset
718 FrameHhsDB *f = (FrameHhsDB*)FindWindowById( ID_HHSDB );
0
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
719
21
eb3f5c7c990f small changes.
pyon@macmini
parents: 16
diff changeset
720 if ( f == NULL ) {
eb3f5c7c990f small changes.
pyon@macmini
parents: 16
diff changeset
721 FrameHhsDB *hhsdb = new FrameHhsDB( this, ID_HHSDB );
eb3f5c7c990f small changes.
pyon@macmini
parents: 16
diff changeset
722 hhsdb->Show(true);
0
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
723 }
21
eb3f5c7c990f small changes.
pyon@macmini
parents: 16
diff changeset
724 else {
eb3f5c7c990f small changes.
pyon@macmini
parents: 16
diff changeset
725 f->Raise();
eb3f5c7c990f small changes.
pyon@macmini
parents: 16
diff changeset
726 }
eb3f5c7c990f small changes.
pyon@macmini
parents: 16
diff changeset
727 return;
0
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
728 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
729
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
730 /* インデックス更新一覧 */
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
731 void MyFrame::OnListCcn(wxCommandEvent& WXUNUSED(event))
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
732 {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
733 this->m_splitter->ReplaceWindow( this->m_html, this->m_gridCcn );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
734 this->m_gridCcn->Show(true);
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
735 this->m_html->Show(false);
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
736 MyCmdBox *c = (MyCmdBox*)FindWindowById( ID_CMD );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
737 c->Clear();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
738
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
739 wxString gszFile = wxGetCwd() + wxT("/db/ccn.db");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
740 wxSQLite3Database ccndb;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
741 ccndb.Open( gszFile );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
742
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
743 wxSQLite3Statement stmt = ccndb.PrepareStatement("SELECT ymd, time FROM ccn ORDER BY ymd DESC, time DESC");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
744 wxSQLite3ResultSet q = stmt.ExecuteQuery();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
745 int r=0;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
746 while ( q.NextRow() ) {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
747 wxString ymd = q.GetString(0);
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
748 wxString time = q.GetString(1);
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
749 this->m_gridCcn->AppendRows(1);
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
750 this->m_gridCcn->SetCellValue(r,0,ymd);
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
751 this->m_gridCcn->SetCellValue(r,1,time);
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
752 r++;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
753 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
754
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
755 stmt.Finalize();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
756 ccndb.Close();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
757 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
758
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
759 /* 被保険者DB更新 */
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
760 void MyFrame::OnUpdateHhsDb(wxCommandEvent& WXUNUSED(event))
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
761 {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
762 FrameHhsDB *f = (FrameHhsDB*)FindWindowById( ID_HHSDB );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
763
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
764 if ( f == NULL ) {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
765 FrameHhsDB *hhsdb = new FrameHhsDB( this, ID_HHSDB );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
766 hhsdb->Show(true);
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
767 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
768 else {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
769 f->Raise();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
770 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
771 return;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
772 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
773
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
774 /* 被保険者整合性チェック */
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
775 void MyFrame::OnCheckHhs(wxCommandEvent& WXUNUSED(event))
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
776 {
10
24e0775af32e Add Name-View.
pyon@macmini
parents: 8
diff changeset
777 wxString logfn = wxGetCwd() + wxT("/tmp/checkhhs.log");
0
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
778 wxTextFile logFile;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
779 logFile.Open( logfn );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
780 logFile.Clear();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
781
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
782 wxString gszFile = wxGetCwd() + wxT("/db/ccn.db");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
783 wxSQLite3Database ccndb;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
784 ccndb.Open( gszFile );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
785 wxSQLite3Statement stmt = ccndb.PrepareStatement("ATTACH 'db/hhs.db' AS hhs");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
786 wxSQLite3ResultSet q = stmt.ExecuteQuery();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
787 stmt = ccndb.PrepareStatement("SELECT hhsno FROM path EXCEPT SELECT hhsno FROM hhs.hhs_master");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
788 q = stmt.ExecuteQuery();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
789
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
790 while ( q.NextRow() ) {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
791 logFile.AddLine( q.GetString(0) );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
792 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
793 stmt.Finalize();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
794 ccndb.Close();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
795
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
796 logFile.Write();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
797 logFile.Close();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
798
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
799 wxString msg = wxT("結果を ") + logfn + wxT(" に保存しました.");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
800 wxMessageBox( msg );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
801 return;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
802 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
803
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
804 /* DBバックアップ */
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
805 void MyFrame::OnBackupDB(wxCommandEvent& WXUNUSED(event))
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
806 {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
807 wxDateTime now = wxDateTime::Now();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
808 wxString nowstr = now.Format(wxT("%Y%m%d%H%M%S"));
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
809
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
810 wxString org = wxGetCwd() + wxT("/db/ccn.db");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
811 wxString bk = wxGetCwd() + wxT("/db/") + nowstr + wxT("_ccn.db");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
812 wxCopyFile( org, bk, 0 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
813
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
814 org = wxGetCwd() + wxT("/db/hhs.db");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
815 bk = wxGetCwd() + wxT("/db/") + nowstr + wxT("_hhs.db");
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
816 wxCopyFile( org, bk, 0 );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
817
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
818 wxMessageBox( wxT("バックアップ終了.") );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
819 return;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
820 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
821
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
822 /* DB最適化 */
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
823 void MyFrame::OnOptimizeDB(wxCommandEvent& WXUNUSED(event))
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
824 {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
825 return;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
826 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
827
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
828 /* アプリケーションフォルダを開く */
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
829 void MyFrame::OnOpenAppDir(wxCommandEvent& WXUNUSED(event))
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
830 {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
831 wxStandardPaths appdir;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
832 wxString execmd = wxT("explorer ") + appdir.GetDataDir();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
833 wxExecute( execmd );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
834 return;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
835 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
836
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
837 /* データフォルダを開く */
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
838 void MyFrame::OnOpenDataDir(wxCommandEvent& WXUNUSED(event))
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
839 {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
840 wxString datadir = wxGetApp().rootdir;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
841 wxString execmd = wxT("explorer ") + datadir;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
842 wxExecute( execmd );
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
843 return;
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
844 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
845
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
846
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
847 /* 設定を保存 */
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
848 void MyFrame::SaveConfig(wxCloseEvent& WXUNUSED(event))
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
849 {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
850 if ( !IsIconized() && !IsMaximized() ) {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
851 wxGetApp().rect = this->GetRect();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
852 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
853
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
854 int i = m_cmdbox->hist.GetCount();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
855 for ( int j=0; j<5; j++ ) {
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
856 wxGetApp().searchhist[j] = m_cmdbox->hist[--i];
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
857 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
858
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
859 Destroy();
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
860 }
c174ac668e9f First commit ! (ver2.8)
pyon@macmini
parents:
diff changeset
861