📄 myapi.pc
字号:
{
stDBRecord_id.bnj_id = -1;
break;
}
stDBRecord_id.bnj_id = 0;
break;
case 9:
strncpy( stFileRecord->hzddrq, cElement, 25 );
if (cElement[0] == '\0')
{
stDBRecord_id.hzddrq_id = -1;
break;
}
stDBRecord_id.hzddrq_id = 0;
break;
case 10:
strncpy( stFileRecord->fxfw, cElement, 5 );
if (cElement[0] == '\0')
{
stDBRecord_id.fxfw_id = -1;
break;
}
stDBRecord_id.fxfw_id = 0;
break;
case 11:
strncpy( stFileRecord->kq, cElement, 7 );
if (cElement[0] == '\0')
{
stDBRecord_id.kq_id = -1;
break;
}
stDBRecord_id.kq_id = 0;
break;
case 12:
strncpy( stFileRecord->tykh, cElement, 13 );
if (cElement[0] == '\0')
{
stDBRecord_id.tykh_id = -1;
break;
}
stDBRecord_id.tykh_id = 0;
break;
case 13:
strncpy( stFileRecord->jb, cElement, 7 );
if (cElement[0] == '\0')
{
stDBRecord_id.jb_id = -1;
break;
}
stDBRecord_id.jb_id = 0;
break;
case 14:
strncpy( stFileRecord->bz, cElement, 161 );
if (cElement[0] == '\0')
{
stDBRecord_id.bz_id = -1;
break;
}
stDBRecord_id.bz_id = 0;
break;
case 15:
strncpy( stFileRecord->xyf, cElement, 2 );
if (cElement[0] == '\0')
{
stDBRecord_id.xyf_id = -1;
break;
}
stDBRecord_id.xyf_id = 0;
break;
case 16:
strncpy( stFileRecord->n1, cElement, 3 );
if (cElement[0] == '\0')
{
stDBRecord_id.pc_id = -1;
break;
}
stDBRecord_id.pc_id = 0;
break;
case 17:
strncpy( stFileRecord->n2, cElement, 3 );
if (cElement[0] == '\0')
{
stDBRecord_id.kz_id = -1;
break;
}
stDBRecord_id.kz_id = 0;
break;
case 18:
strncpy( stFileRecord->n3, cElement, 3 );
if (cElement[0] == '\0')
{
stDBRecord_id.bym_id = -1;
break;
}
stDBRecord_id.bym_id = 0;
break;
case 19:
strncpy( stFileRecord->n4, cElement, 3 );
if (cElement[0] == '\0')
{
stDBRecord_id.bym_id = -1;
break;
}
stDBRecord_id.bym_id = 0;
break;
default:
break;
}
}
pLine++;
}
if( i == 19 )
return(1);
else
return(0);
}
/* Convert the BKMLFileRecord to BKMLDBRecord */
void myapi_ConvertToDBRecord(struct stBKMLFileRec *stFileRec, struct stBKMLDBRec *stDBRecord )
{
stDBRecord->key = lg_Key;
strcpy( stDBRecord->bkdh, stFileRec->bkdh );
strcpy( stDBRecord->bkmc, stFileRec->bkmc );
strcpy( stDBRecord->fbkjmc, stFileRec->fbkjmc );
strcpy( stDBRecord->cbrq, stFileRec->cbrq );
stDBRecord->dj = stFileRec->dj;
stDBRecord->yj = stFileRec->yj;
stDBRecord->jj = stFileRec->jj;
stDBRecord->bnj = stFileRec->bnj;
stDBRecord->nj = NULL;
stDBRecord_id.nj_id = -1;
strcpy( stDBRecord->hzddrq, stFileRec->hzddrq );
strcpy( stDBRecord->fxfw, stFileRec->fxfw );
strcpy( stDBRecord->kq, stFileRec->kq );
strcpy( stDBRecord->tykh, stFileRec->tykh );
strcpy( stDBRecord->jb, stFileRec->jb );
stDBRecord->pc = atoi(stFileRec->n1);
stDBRecord->kz = atoi(stFileRec->n2);
stDBRecord->bym = atoi(strcat(stFileRec->n3,stFileRec->n4));
strcpy( stDBRecord->bz, stFileRec->bz );
strcpy( stDBRecord->xyf, stFileRec->xyf );
stDBRecord->bbdyfl = NULL;
stDBRecord_id.bbdyfl_id = -1;
stDBRecord->wbdyfl = NULL;
stDBRecord_id.wbdyfl_id = -1;
stDBRecord->bblsfl = NULL;
stDBRecord_id.bblsfl_id = -1;
stDBRecord->wblsfl = NULL;
stDBRecord_id.wblsfl_id = -1;
}
/* insert the record into the t_fsbkjhmlnr table */
int InsertSndBKJHMLNRRec(struct stBKMLDBRec *stDBRecord )
{
EXEC SQL WHENEVER SQLERROR DO sqlerror();
EXEC SQL INSERT INTO T_FSBKJHMLNR VALUES (:stDBRecord->bkdh, :stDBRecord->bkmc :stDBRecord_id.bkmc_id,
:stDBRecord->fbkjmc :stDBRecord_id.fbkjmc_id, :stDBRecord->cbrq :stDBRecord_id.cbrq_id,
:stDBRecord->dj :stDBRecord_id.dj_id, :stDBRecord->yj :stDBRecord_id.yj_id,
:stDBRecord->jj :stDBRecord_id.jj_id, :stDBRecord->bnj :stDBRecord_id.bnj_id,
:stDBRecord->nj :stDBRecord_id.nj_id, :stDBRecord->hzddrq :stDBRecord_id.hzddrq_id,
:stDBRecord->fxfw :stDBRecord_id.fxfw_id, :stDBRecord->kq :stDBRecord_id.kq_id,
:stDBRecord->tykh :stDBRecord_id.tykh_id, :stDBRecord->jb :stDBRecord_id.jb_id,
:stDBRecord->pc :stDBRecord_id.pc_id, :stDBRecord->kz :stDBRecord_id.kz_id,
:stDBRecord->bym :stDBRecord_id.bym_id, :stDBRecord->xyf :stDBRecord_id.xyf_id,
:stDBRecord->bbdyfl :stDBRecord_id.bbdyfl_id, :stDBRecord->wbdyfl :stDBRecord_id.wbdyfl_id,
:stDBRecord->bblsfl :stDBRecord_id.bblsfl_id, :stDBRecord->wblsfl :stDBRecord_id.wblsfl_id,
:stDBRecord->bz :stDBRecord_id.bz_id, :stDBRecord->key);
EXEC SQL COMMIT WORK;
return(1);
}
/* update the table to locate the relative flag */
int UpdateSndLogRecStatus()
{
char sjzt = FSRZ_WAITFOR_SND;
EXEC SQL WHENEVER SQLERROR DO sqlerror();
EXEC SQL UPDATE T_FSRZ SET SJZT = :sjzt, JSSJ = SYSDATE
WHERE FSXH = :lg_Key;
EXEC SQL COMMIT WORK RELEASE;
return(1);
}
/* Print out to test Convert BKMLFileRecord to BKMLDBRecord */
void myapi_TestShowResult(struct stBKMLFileRec *stFileRec, struct stBKMLDBRec *stDBRecord )
{
printf( "@@%s@@ @@%s@@\n",stDBRecord->bkdh, stFileRec->bkdh );
printf( "@@%s@@ @@%s@@\n",stDBRecord->bkmc, stFileRec->bkmc );
printf( "@@%s@@ @@%s@@\n",stDBRecord->fbkjmc, stFileRec->fbkjmc );
printf( "@@%s@@ @@%s@@\n",stDBRecord->cbrq, stFileRec->cbrq );
printf( "@@%f@@ @@%f@@\n",stDBRecord->dj , stFileRec->dj);
printf( "@@%f@@ @@%f@@\n",stDBRecord->yj , stFileRec->yj);
printf( "@@%f@@ @@%f@@\n",stDBRecord->jj , stFileRec->jj);
printf( "@@%f@@ @@%f@@\n",stDBRecord->bnj , stFileRec->bnj);
printf( "@@%f@@\n",stDBRecord->nj );
printf( "@@%s@@ @@%s@@\n",stDBRecord->hzddrq, stFileRec->hzddrq );
printf( "@@%s@@ @@%s@@\n",stDBRecord->fxfw, stFileRec->fxfw );
printf( "@@%s@@ @@%s@@\n",stDBRecord->kq, stFileRec->kq );
printf( "@@%s@@ @@%s@@\n",stDBRecord->tykh, stFileRec->tykh );
printf( "@@%s@@ @@%s@@\n",stDBRecord->jb, stFileRec->jb );
printf( "@@%i@@\n", stDBRecord->pc );
printf( "@@%i@@\n", stDBRecord->kz );
printf( "@@%i@@\n", stDBRecord->bym );
printf( "@@%s@@ @@%s@@\n",stDBRecord->bz, stFileRec->bz );
printf( "@@%s@@ @@%s@@\n",stDBRecord->xyf, stFileRec->xyf );
printf( "@@%f@@\n", stDBRecord->bbdyfl );
printf( "@@%f@@\n", stDBRecord->wbdyfl );
printf( "@@%f@@\n", stDBRecord->bblsfl );
printf( "@@%f@@\n", stDBRecord->wblsfl );
printf( "@@%s@@\n",stFileRec->n1 );
printf( "@@%s@@\n",stFileRec->n2 );
printf( "@@%s@@\n",stFileRec->n3 );
printf( "@@%s@@\n",stFileRec->n4 );
}
void ProcessError( char *LOG, char *sErrorMessage1, char *sErrorMessage2 )
{
FILE* hErrorFile;
char cDateTime[100],tempstr[100];
int i,j,len,n;
long filesize;
char bakfile[100];
tempstr[0]='\0';
len=strlen(sErrorMessage1);
for(i=0;i<=len;i++)
{
if(sErrorMessage1[i]=='%')
{
n=i;
if(len!=i+1)
{
for(j=0;j<200&&sErrorMessage1[i+2]!='\0';j++,i++)
tempstr[j]=sErrorMessage1[i+2];
tempstr[j]='\0';
}
break;
}
if(sErrorMessage1[i]=='\0')
{
n=i;
tempstr[0] = '\0';
break;
}
}
sErrorMessage1[n]='\0';
hErrorFile = fopen( ERROR_LOG_FILE, "a" );
if( hErrorFile == NULL )
{
printf( "Critical! Cannot open ERROR_LOG_FILE for append or cannot create!\n");
return;
}
fseek( hErrorFile, 0 ,SEEK_END );
filesize = ftell(hErrorFile);
if (filesize > 5242880)
{
fclose(hErrorFile );
sprintf(bakfile, "mv %s %s.bak", ERROR_LOG_FILE, ERROR_LOG_FILE);
system(bakfile);
hErrorFile = fopen( ERROR_LOG_FILE, "a" );
if( hErrorFile == NULL )
{
printf( "Critical! Cannot open ERROR_LOG_FILE for append or cannot create!\n");
return;
}
}
fseek( hErrorFile, 0 ,SEEK_END );
fputs( "\n",hErrorFile);
fputs( LOG ,hErrorFile);
printf("\n%s",LOG);
fputs( sErrorMessage1,hErrorFile );
printf("%s",sErrorMessage1);
fputs( sErrorMessage2,hErrorFile );
printf("%s",sErrorMessage2);
fputs( tempstr,hErrorFile );
printf("%s\n",tempstr);
fputs( "\n",hErrorFile);
fclose( hErrorFile );
sprintf( cDateTime, "date >> %s\n", ERROR_LOG_FILE );
system( cDateTime );
system( "date");
}
void movefile()
{
char cCommand[MAX_LINE_LEN];
/* move the source fsbkjhml data file to the backup directory*/
sprintf( cCommand, "mv -f %s %s", filename, BACKUP_DIRECTORY );
system( cCommand );
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -