8/7/2018 11:47 AM | |
Posts: 50 Rating:
|
I am trying to print archive tag value from archive control table. I am using ID as a selection filter to print. Here I am not using OCX ArchiveControlTable, I am trying to design customized report print layout. But by wring following script I am not able to print archive data of selected ID Please help. Here is script, "CYCLE1_SET_PARA" is Archive #include "apdefap.h" void OnClick(char* lpszPictureName, char* lpszObjectName, char* lpszPropertyName) { #define R_CYCLE_START_TIME_1 "R_CYCLE_START_TIME_1" #define R_CYCLE_END_TIME_1 "R_CYCLE_END_TIME_1" #define CurrentUserName "CurrentUserName" #define C1_CD_H2O2_INJ_PRT_R "C1_CD_H2O2_INJ_PRT_R" #define C1_DC_H2O2_INJ_PRT_R "C1_DC_H2O2_INJ_PRT_R" #define C1_LINE_1_R "C1_LINE_1_R" #define C1_LINE_2_R "C1_LINE_2_R" #define C1_DH_TIME_HH_R "C1_DH_TIME_HH_R" #define C1_DH_TIME_MM_R "C1_DH_TIME_MM_R" #define C1_CD_TIME_HH_R "C1_CD_TIME_HH_R" #define C1_CD_TIME_MM_R "C1_CD_TIME_MM_R" #define C1_DC_TIME_HH_R "C1_DC_TIME_HH_R" #define C1_DC_TIME_MM_R "C1_DC_TIME_MM_R" #define C1_AR_TIME_HH_R "C1_AR_TIME_HH_R" #define C1_AR_TIME_MM_R "C1_AR_TIME_MM_R" #define C1_AA_TIME_HH_R "C1_AA_TIME_HH_R" #define C1_AA_TIME_MM_R "C1_AA_TIME_MM_R" #define C1_DH_GEN_AF_cfm_R "C1_DH_GEN_AF_cfm_R" #define C1_DH_PRT_INT_min_R "C1_DH_PRT_INT_min_R" #define C1_DH_AIR_INLET_RH_R "C1_DH_AIR_INLET_RH_R" #define C1_CD_GEN_AF_cfm_R "C1_CD_GEN_AF_cfm_R" #define C1_CD_INJ_RATE_gmin_R "C1_CD_INJ_RATE_gmin_R" #define C1_CD_PRT_INT_min_R "C1_CD_PRT_INT_min_R" #define C1_DC_GEN_AF_cfm_R "C1_DC_GEN_AF_cfm_R" #define C1_DC_INJ_RATE_gm_R "C1_DC_INJ_RATE_gm_R" #define C1_DC_PRT_INT_min_R "C1_DC_PRT_INT_min_R" #define C1_AR_GEN_AF_cfm_R "C1_AR_GEN_AF_cfm_R" #define C1_AR_PRT_INT_min_R "C1_AR_PRT_INT_min_R" #define C1_AA_GEN_AF_cfm_R "C1_AA_GEN_AF_cfm_R" #define C1_AA_PRT_INT_min_R "C1_AA_PRT_INT_min_R" #define R_EQUIPMENT_ID_R "R_EQUIPMENT_ID_R" #define R_PRODUCT_NAME_R "R_PRODUCT_NAME_R" #define R_BATCH_NUMBER_R "R_BATCH_NUMBER_R" #define R_PHASE_NAME_R "R_PHASE_NAME_R" //#define R_CYCLE_NUMBER "DB72,DBW4" char* val1= ""; char* val2= ""; char* val3= ""; char* val4= ""; char* val5=""; char* val6=""; char* val7=""; char* val8=""; char* val9=""; char* val10=""; char* val11=""; char* val12=""; char* val13=""; char* val14=""; char* val15=""; char* val16=""; char* val17=""; char* val18=""; char* val19=""; char* val20=""; char* val21=""; char* val22=""; char* val23=""; char* val24=""; char* val25=""; char* val26=""; char* val27=""; char* val28=""; char* val29 =""; char* val30 =""; char* val31=""; char* val32=""; char* val33=""; char filter[250]; char filter1[250]; char temp1[100], temp2[100], temp3[100]; char szStr1[200]; char szStr2[200]; char szStr3[200]; char szStr4[200]; int a = GetPropWord(lpszPictureName,"Control2","SelectedID"); UAHCONNECT hConnect; if ( uaConnect( &hConnect ) ) { UAHARCHIVE hArchive; if ( uaQueryArchiveByName( hConnect, "CYCLE1_SET_PARA", &hArchive ) ) { if ( uaArchiveOpen( hArchive ) ) { // strcpy(temp1, " DATA_LOG_TM >= "); //strcpy(temp2, " AND DATA_LOG_TM <= "); // strcpy(temp3, "'"); //sprintf(szStr1,"%s",GetTagChar(R_CYCLE_START_TIME_1 )); // sprintf(szStr2,"%s",GetTagChar(R_CYCLE_END_TIME_1)); sprintf ( filter, "%s%i", "ID = ", a ); ///sprintf(filter, "%s'%s.000'%s'%s.000'", temp1, szStr1, temp2, szStr2); uaArchiveSetFilter( hArchive, filter ); uaArchiveRequery( hArchive ); if ( uaArchiveMoveFirst( hArchive ) ) { uaArchiveGetFieldValueString(hArchive,1,val1,50); SetTagChar(C1_CD_H2O2_INJ_PRT_R, val1); uaArchiveGetFieldValueString(hArchive,2,val2,50); SetTagChar(C1_DC_H2O2_INJ_PRT_R, val2); uaArchiveGetFieldValueString(hArchive,3,val3,50); SetTagChar(C1_LINE_1_R, val3); uaArchiveGetFieldValueString(hArchive,4,val4,50); SetTagChar(C1_LINE_2_R, val4); uaArchiveGetFieldValueString(hArchive,5, val5,50); SetTagChar(C1_DH_TIME_HH_R, val5); uaArchiveGetFieldValueString(hArchive,6,val6,50); SetTagChar(C1_DH_TIME_MM_R, val6); uaArchiveGetFieldValueString(hArchive,7,val7,20); SetTagChar(C1_CD_TIME_HH_R, val7); uaArchiveGetFieldValueString(hArchive,8,val8,20); SetTagChar(C1_CD_TIME_MM_R, val8); uaArchiveGetFieldValueString(hArchive,9,val9,20); SetTagChar(C1_DC_TIME_HH_R, val9); uaArchiveGetFieldValueString(hArchive,10,val10,20); SetTagChar(C1_DC_TIME_MM_R, val10); uaArchiveGetFieldValueString(hArchive,11,val11,20); SetTagChar(C1_AR_TIME_HH_R, val11); uaArchiveGetFieldValueString(hArchive,12,val12,20); SetTagChar(C1_AR_TIME_MM_R, val12); uaArchiveGetFieldValueString(hArchive,13,val13,20); SetTagChar(C1_AA_TIME_HH_R, val13); uaArchiveGetFieldValueString(hArchive,14,val14,20); SetTagChar(C1_AA_TIME_MM_R, val14); uaArchiveGetFieldValueString(hArchive,15,val15,20); SetTagChar(C1_DH_GEN_AF_cfm_R, val15); uaArchiveGetFieldValueString(hArchive,16,val16,20); SetTagChar(C1_DH_PRT_INT_min_R, val16); uaArchiveGetFieldValueString(hArchive,17,val17,20); SetTagChar(C1_DH_AIR_INLET_RH_R, val17); uaArchiveGetFieldValueString(hArchive,18,val18,20); SetTagChar(C1_CD_GEN_AF_cfm_R, val18); uaArchiveGetFieldValueString(hArchive, 19, val19, 20); SetTagChar(C1_CD_INJ_RATE_gmin_R, val19); uaArchiveGetFieldValueString(hArchive,20,val20, 20); SetTagChar(C1_CD_PRT_INT_min_R, val20); uaArchiveGetFieldValueString(hArchive,21,val21,20); SetTagChar(C1_DC_GEN_AF_cfm_R, val21); uaArchiveGetFieldValueString(hArchive,22,val22,20); SetTagChar(C1_DC_INJ_RATE_gm_R, val22); uaArchiveGetFieldValueString(hArchive,23,val23,20); SetTagChar(C1_DC_PRT_INT_min_R, val23); uaArchiveGetFieldValueString(hArchive,24,val24,20); SetTagChar(C1_AR_GEN_AF_cfm_R, val24); uaArchiveGetFieldValueString(hArchive,25,val25,20); SetTagChar(C1_AR_PRT_INT_min_R, val25); uaArchiveGetFieldValueString(hArchive,26,val26,20); SetTagChar(C1_AA_GEN_AF_cfm_R, val26); uaArchiveGetFieldValueString(hArchive,27,val27,20); SetTagChar(C1_AA_PRT_INT_min_R, val27); uaArchiveGetFieldValueString(hArchive,28,val28,50); SetTagChar(R_EQUIPMENT_ID_R, val28); uaArchiveGetFieldValueString(hArchive,29,val29,50); SetTagChar(R_PRODUCT_NAME_R, val29); uaArchiveGetFieldValueString(hArchive,30,val30,50); SetTagChar(R_BATCH_NUMBER_R, val30); uaArchiveGetFieldValueString(hArchive,30,val31,50); SetTagChar(R_PHASE_NAME_R, val31); } else { printf("Datensatz nicht vorhanden --- Data record not existing\r\n"); } uaArchiveClose( hArchive ); } else { printf( "Open failed.\r\n" ); } uaReleaseArchive( hArchive ); } else { printf( "Query failed.\r\n" ); } uaDisconnect( hConnect ); RPTJobPreview("NewRPL0_"); //Return-Type: BOOL } else { printf( "Connect failed.\r\n" ); } } ------------------------------------------------------------------------------------------ |
Last edited by: Jen_Moderator at: 8/7/2018 1:55:48 PMNew subject after splitting |
|
8/7/2018 1:59 PM | |
Joined: 6/19/2017 Last visit: 9/6/2024 Posts: 8171 Rating:
|
Closed cause question posted twice.
|
Follow us on