|
// *********************************************************
// インポート
// *********************************************************
void App_01::Import( void )
{
Buff->Resize( 10000 );
if ( TxtIn.Get( Buff ) ) {
Buff->RemoveLastchar();
Token.CreateToken( Buff, "," );
Work->operator = (
"insert into 郵便番号インポート"
" values("
);
// 郵便番号(7桁)
if ( Token.nCount < 1 ) {
Item->SetChar( 0, 0 );
}
else {
Item->operator = (Token.Token[0]);
Item->SetChar( 7, 0 );
}
Item->Enclose( "'" );
Work->operator += (Item);
Work->operator += (",");
// 都道府県名(半角カタカナ)
if ( Token.nCount < 2 ) {
Item->SetChar( 0, 0 );
}
else {
Item->operator = (Token.Token[1]);
Item->SetChar( 50, 0 );
}
Item->Enclose( "'" );
Work->operator += (Item);
Work->operator += (",");
// 市区町村名(半角カタカナ)
if ( Token.nCount < 3 ) {
Item->SetChar( 0, 0 );
}
else {
Item->operator = (Token.Token[2]);
Item->SetChar( 50, 0 );
}
Item->Enclose( "'" );
Work->operator += (Item);
Work->operator += (",");
// 町域名(半角カタカナ)
if ( Token.nCount < 4 ) {
Item->SetChar( 0, 0 );
}
else {
Item->operator = (Token.Token[3]);
Item->SetChar( 50, 0 );
}
Item->Enclose( "'" );
Work->operator += (Item);
Work->operator += (",");
// 都道府県名
if ( Token.nCount < 5 ) {
Item->SetChar( 0, 0 );
}
else {
Item->operator = (Token.Token[4]);
Item->SetChar( 50, 0 );
}
Item->Enclose( "'" );
Work->operator += (Item);
Work->operator += (",");
// 市区町村名
if ( Token.nCount < 6 ) {
Item->SetChar( 0, 0 );
}
else {
Item->operator = (Token.Token[5]);
Item->SetChar( 50, 0 );
}
Item->Enclose( "'" );
Work->operator += (Item);
Work->operator += (",");
// 町域名
if ( Token.nCount < 7 ) {
Item->SetChar( 0, 0 );
}
else {
Item->operator = (Token.Token[6]);
Item->SetChar( 50, 0 );
}
Item->Enclose( "'" );
Work->operator += (Item);
Work->operator += (")");
CurDb->Query( Work );
nCount++;
Pbar->Next();
}
else {
bCancel = true;
}
}
| |