mfeeagr.c

电力与银行通讯的源码 1.应用tuxedo中间件. 2.与银行的前置机通讯. 3.proc*c 的应用

					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*DSK6        25  //代收款6 Numeric(15,4) Default 0,*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_DSK6,&d_DSK6,15,4);
				if (d_DSK6 != 0){
					sprintf(szTemp,"%15s%2s%20.2f",szTemp1,F_DSK6,d_DSK6);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*DSK7        26  //代收款7 Numeric(15,4) Default 0,*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_DSK7,&d_DSK7,15,4);
				if (d_DSK7 != 0){
					sprintf(szTemp,"%15s%2s%20.2f",szTemp1,F_DSK7,d_DSK7);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*DSK8        27  //代收款8 Numeric(15,4) Default 0,*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_DSK8,&d_DSK8,15,4);
				if (d_DSK8 != 0){
					sprintf(szTemp,"%15s%2s%20.2f",szTemp1,F_DSK8,d_DSK8);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*PZM         28  //平止码 Numeric(10,2),*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_PZM,&d_PZM,10,2);
				if (d_PZM != 0){
					sprintf(szTemp,"%15s%2s%20.2f",szTemp1,F_PZM,d_PZM);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*PQM         29  //平起码 Numeric(10,2),*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_PQM,&d_PQM,10,2);
				if (d_PQM != 0){
					sprintf(szTemp,"%15s%2s%20.2f",szTemp1,F_PQM,d_PQM);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*FZM         30  //峰止码 Numeric(10,2),*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_FZM,&d_FZM,10,2);
				if (d_FZM != 0){
					sprintf(szTemp,"%15s%2s%20.2f",szTemp1,F_FZM,d_FZM);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*FQM         31  //峰起码 Numeric(10,2),*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_FQM,&d_FQM,10,2);
				if (d_FQM != 0){
					sprintf(szTemp,"%15s%2s%20.2f",szTemp1,F_FQM,d_FQM);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*GZM         32  //谷止码 Numeric(10,2),*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_GZM,&d_GZM,10,2);
				if (d_GZM != 0){
					sprintf(szTemp,"%15s%2s%20.2f",szTemp1,F_GZM,d_GZM);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*GQM         33  //谷起码 Numeric(10,2),*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_GQM,&d_GQM,10,2);
				if (d_GQM != 0){
					sprintf(szTemp,"%15s%2s%20.2f",szTemp1,F_GQM,d_GQM);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*WGZM        34  //无功止码 Numeric(10,2),*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_WGZM,&d_WGZM,10,2);
				if (d_WGZM != 0){
					sprintf(szTemp,"%15s%2s%20.2f",szTemp1,F_WGZM,d_WGZM);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*WGQM        35  //无功起码 Numeric(10,2),*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_WGQM,&d_WGQM,10,2);
				if (d_WGQM != 0){
					sprintf(szTemp,"%15s%2s%20.2f",szTemp1,F_WGQM,d_WGQM);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*PBS         38  //平变损 Numeric(13,0) DEFAULT 0,*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_PBS,&d_PBS,13,0);
				if (d_PBS != 0){
					sprintf(szTemp,"%15s%2s%20.0f",szTemp1,F_PBS,d_PBS);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*FBS         39  //峰变损 Numeric(13,0) DEFAULT 0,*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_FBS,&d_FBS,13,0);
				if (d_FBS != 0){
					sprintf(szTemp,"%15s%2s%20.0f",szTemp1,F_FBS,d_FBS);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*GBS         40  //谷变损 Numeric(13,0) DEFAULT 0,*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_GBS,&d_GBS,13,0);
				if (d_GBS != 0){
					sprintf(szTemp,"%15s%2s%20.0f",szTemp1,F_GBS,d_GBS);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*WGBS        41  //无功变损 Numeric(13,0) DEFAULT 0,*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_WGBS,&d_WGBS,13,0);
				if (d_WGBS != 0){
					sprintf(szTemp,"%15s%2s%20.0f",szTemp1,F_WGBS,d_WGBS);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*PJFDL       42  //平计费电量 Numeric(13,0) DEFAULT 0,*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_PJFDL,&d_PJFDL,13,0);
				if (d_PJFDL != 0){
					sprintf(szTemp,"%15s%2s%20.0f",szTemp1,F_PJFDL,d_PJFDL);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*FJFDL       43  //峰计费电量 Numeric(13,0) DEFAULT 0,*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_FJFDL,&d_FJFDL,13,0);
				if (d_FJFDL != 0){
					sprintf(szTemp,"%15s%2s%20.0f",szTemp1,F_FJFDL,d_FJFDL);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*GJFDL       44  //谷计费电量 Numeric(13,0) DEFAULT 0,*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_GJFDL,&d_GJFDL,13,0);
				if (d_GJFDL != 0){
					sprintf(szTemp,"%15s%2s%20.0f",szTemp1,F_GJFDL,d_GJFDL);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*WGJFDL      45  //无功计费电量 Numeric(13,0) DEFAULT 0,*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_WGJFDL,&d_WGJFDL,13,0);
				if (d_WGJFDL != 0){
					sprintf(szTemp,"%15s%2s%20.0f",szTemp1,F_WGJFDL,d_WGJFDL);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*JFRL        46  //计费容量 Numeric(13,0) DEFAULT 0,*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_JFRL,&d_JFRL,13,0);
				if (d_JFRL != 0){
					sprintf(szTemp,"%15s%2s%20.0f",szTemp1,F_JFRL,d_JFRL);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*GLYS        47  //功率因数 Numeric(3,2),*/
				/*DB_ConvertNumericToDouble(&theDatabase,&cs_GLYS,&d_GLYS,3,2);*/
				if (i_GLYS != 0){
					sprintf(szTemp,"%15s%2s%20d",szTemp1,F_GLYS,i_GLYS);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*TZL         48  //调整率 Numeric(6,4),*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_TZL,&d_TZL,6,4);
				if (d_TZL != 0){
					sprintf(szTemp,"%15s%2s%20.4f",szTemp1,F_TZL,d_TZL);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*PDFDJ       53  //平电费单价 Numeric(15,4) Default 0,*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_PDFDJ,&d_PDFDJ,15,4);
				if (d_PDFDJ != 0){
					sprintf(szTemp,"%15s%2s%20.4f",szTemp1,F_PDFDJ,d_PDFDJ);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*FDFDJ       54  //峰电费单价 Numeric(15,4) Default 0,*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_FDFDJ,&d_FDFDJ,15,4);
				if (d_FDFDJ != 0){
					sprintf(szTemp,"%15s%2s%20.4f",szTemp1,F_FDFDJ,d_FDFDJ);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*GDFDJ       55  //谷电费单价 Numeric(15,4) Default 0,*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_GDFDJ,&d_GDFDJ,15,4);
				if (d_GDFDJ != 0){
					sprintf(szTemp,"%15s%2s%20.4f",szTemp1,F_GDFDJ,d_GDFDJ);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*JBDFDJ      56  //基本电费单价 Numeric(15,4) Default 0,*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_JBDFDJ,&d_JBDFDJ,15,4);
				if (d_JBDFDJ != 0){
					sprintf(szTemp,"%15s%2s%20.4f",szTemp1,F_JBDFDJ,d_JBDFDJ);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*DSK1DJ      58  //代收款1单价 Numeric(15,4) Default 0,*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_DSK1DJ,&d_DSK1DJ,15,4);
				if (d_DSK1DJ != 0){
					sprintf(szTemp,"%15s%2s%20.4f",szTemp1,F_DSK1DJ,d_DSK1DJ);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*DSK2DJ      59  //代收款2单价 Numeric(15,4) Default 0,*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_DSK2DJ,&d_DSK2DJ,15,4);
				if (d_DSK2DJ != 0){
					sprintf(szTemp,"%15s%2s%20.4f",szTemp1,F_DSK2DJ,d_DSK2DJ);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*DSK3DJ      60  //代收款3单价 Numeric(15,4) Default 0,*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_DSK3DJ,&d_DSK3DJ,15,4);
				if (d_DSK3DJ != 0){
					sprintf(szTemp,"%15s%2s%20.4f",szTemp1,F_DSK3DJ,d_DSK3DJ);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*DSK4DJ      61  //代收款4单价 Numeric(15,4) Default 0,*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_DSK4DJ,&d_DSK4DJ,15,4);
				if (d_DSK4DJ != 0){
					sprintf(szTemp,"%15s%2s%20.4f",szTemp1,F_DSK4DJ,d_DSK4DJ);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*DSK5DJ      62  //代收款5单价 Numeric(15,4) Default 0,*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_DSK5DJ,&d_DSK5DJ,15,4);
				if (d_DSK5DJ != 0){
					sprintf(szTemp,"%15s%2s%20.4f",szTemp1,F_DSK5DJ,d_DSK5DJ);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*DSK6DJ      63  //代收款6单价 Numeric(15,4) Default 0,*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_DSK6DJ,&d_DSK6DJ,15,4);
				if (d_DSK6DJ != 0){
					sprintf(szTemp,"%15s%2s%20.4f",szTemp1,F_DSK6DJ,d_DSK6DJ);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*DSK7DJ      64  //代收款7单价 Numeric(15,4) Default 0,*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_DSK7DJ,&d_DSK7DJ,15,4);
				if (d_DSK7DJ != 0){
					sprintf(szTemp,"%15s%2s%20.4f",szTemp1,F_DSK7DJ,d_DSK7DJ);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*DSK8DJ      65  //代收款8单价 Numeric(15,4) Default 0,*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_DSK8DJ,&d_DSK8DJ,15,4);
				if (d_DSK8DJ != 0){
					sprintf(szTemp,"%15s%2s%20.4f",szTemp1,F_DSK8DJ,d_DSK8DJ);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*PDL         71  //平抄见电量 Numeric(13,0) DEFAULT 0,*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_PDL,&d_PDL,13,0);
				if (d_PDL != 0){
					sprintf(szTemp,"%15s%2s%20.0f",szTemp1,F_PDL,d_PDL);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*FDL         72  //峰抄见电量 Numeric(13,0) DEFAULT 0,*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_FDL,&d_FDL,13,0);
				if (d_FDL != 0){
					sprintf(szTemp,"%15s%2s%20.0f",szTemp1,F_FDL,d_FDL);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*GDL         73  //谷抄见电量 Numeric(13,0) DEFAULT 0,*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_GDL,&d_GDL,13,0);
				if (d_GDL != 0){
					sprintf(szTemp,"%15s%2s%20.0f",szTemp1,F_GDL,d_GDL);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*WGDL        74  //无功抄见电量 Numeric(13,0) DEFAULT 0,*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_WGDL,&d_WGDL,13,0);
				if (d_WGDL != 0){
					sprintf(szTemp,"%15s%2s%20.0f",szTemp1,F_WGDL,d_WGDL);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
				/*DL          75  //总表抄见电量 Numeric(13,0) DEFAULT 0,*/
				DB_ConvertNumericToDouble(&theDatabase,&cs_DL,&d_DL,13,0);
				if (d_DL != 0){
					sprintf(szTemp,"%15s%2s%20.0f",szTemp1,F_DL,d_DL);
					if (iDetailCount <= (iResultCount * MAX_DETAIL_ONE)){ strcat(szResultDetail,szTemp);j++;};
					iDetailCount ++;
				}
			}
/*	MW_Trace("OK8");*/
		}
		DB_SQLDone(&theDatabase);
	}
	DB_ExecuteSQL(&theDatabase,szDropSql);
/*	MW_Trace("OK8");*/
	/*输出结果*/
/*		2	实际的结果记录数n	4	如不等于上面的值，则认为查询结果太多
		3	费用明细记录数m		4	用于校验*/
 /* 	sprintf(szTemp,"%13s%13s",sum,qcje);
	memcpy(szOutBuf+26,szTemp,26); */
	sprintf(szTemp,"%13s%13s%4d%4d",iResultCount,iDetailCount);*/
	memcpy(szOutBuf+34,szTemp,34);
/*	MW_SetValueInt(&mwMidWare,DETAIL_COUNT,"DETAIL_COUNT",iDetailCount);
	MW_SetValue(&mwMidWare,RESULT,"RESULT",szResult,strlen(szResult));
	MW_SetValue(&mwMidWare,DETAIL_DATA,"DETAIL_DATA",szResultDetail,strlen(szResultDetail));*/
	gf_Return(&mwMidWare,iResultCount,"");
	return;
}