unit PayIntf_Get; interface uses SysUtils, Windows, Variants, Classes, Graphics, Controls, Forms, Dialogs, StdCtrls, IdHashMessageDigest, IdGlobal, IdHash, HTTPApp, DateUtils, IdHTTP, superobject, DBClient, iniFiles; type {** 输入控制 符号 * 必须输入 M * 非必须输入 O * 不可输入 - * 条件必输 C * 类型 符号 长度 示例 * 字符串 S （20） S(20) 20位长度字符串 * 整数 N （10） N(10) 10位长度整数 * 数字（带小数） N (10,2) N(10,2)整数10位，小数2位数字 } //数据结构：支付 PUpPayData = ^TUpPayData; TUpPayData = record terminalNo: string; //[C]终端编号:支付的中行MIS终端编号,当支付方式是01或02时必填 orderNo: string; //[M]订单编号:大售检票系统中的订单编号 orderAmount: string; //[M]订单金额:12位，以分为单位，比如1分=000000000001 cashAmount: string; //[C]现金支付金额:当支付方式是00或02时必填,12位，以分为单位，比如1分=000000000001 misAmount: string; //[C]MIS支付金额:当支付方式是01或02时必填,12位，以分为单位，比如1分=000000000001 salesman: string; //[O]销售员 orderTime: string; //[M]下单时间:格式：yyyyMMddHHmmss payType: string; //[M]支付方式: 00现金; 01中行MIS; 02组合支付(现金+中行MIS) merchantNo: string; //[M]商户编号:财务结算中心分配的商户编号 tellerNo: string; //[M]销售员编号 orgInfo: string; //[O]预留信息:原交易要素，用于反向交易时定位原交易 orderDetail: string; //[M]订单详情 sign: string; //[M]签名数据:使用1.3通讯方式中的示例进行签名 end; PDownPayData = ^TDownPayData; TDownPayData = record return_code: string; //[M]返回状态码:通讯码为SUCCESS/FAIL return_desc: string; //[M]返回信息:当return_code为FAIL时返回信息为错误原因 ,例如:签名失败,参数格式校验错误 result_code: string; //[O]业务结果:SUCCESS/FAIL orderNo: string; //[O]售检票系统订单号:当result_code是SUCCESS才有返回 merchantOrderNo: string; //[O]财务结算中心订单号:当result_code是SUCCESS才有返回 succTime: string; //[O]订单成功时间:当result_code是SUCCESS才有返回,格式:yyyyMMddHHmmss succAmount: integer; //[O]成功金额:成功金额:当result_code是SUCCESS才有返回,12位，以分为单位，比如1分=000000000001 end; //数据结构：退票 PUpRefundData = ^TUpRefundData; TUpRefundData = record orderNo: string; //[M]订单编号:深大售检票系统中的订单编号 refundAmount: integer; //[M]退款金额:12位，以分为单位，比如1分=000000000001 end; PDownRefundData = ^TDownRefundData; TDownRefundData = record return_code: string; //[M]返回状态码:通讯码为SUCCESS/FAIL return_desc: string; //[M]返回信息:当return_code为FAIL时返回信息为错误原因,例如:签名失败/参数格式校验错误 result_code: string; //[O]业务结果:SUCCESS/FAIL orderNo: string; //[O]售检票系统订单号:当result_code是SUCCESS才有返回 refundTime: string; //[O]订单退款成功时间:当result_code是SUCCESS才有返回 refundAmount: integer; //[O]退款金额:当result_code是SUCCESS才有返回,12位，以分为单位，比如1分=000000000001 end; const L: integer = 12; //金额:12位，以分为单位，比如1分=000000000001 // Key: string = ‘QAZWSXEDCTGFREDW@#$%123123‘; //秘钥key需要与财务结算系统保持一致，不可随意更改 // Url_Pay: string = ‘http://localhost:8080/pay/ParkingAction.createOrder.do‘; // Url_Refund:string = ‘http://localhost:8080/pay/ParkingAction.refundOrder.do‘; procedure MyWriteLog(const mStr:string); function CheckInvalid(UpPayData: TUpPayData; var sMsg: string): boolean; function CheckInvalid_Refund(UpRefundData: TUpRefundData; var sMsg: string): boolean; function ExchangeMoney(Value: string): string; function FormatData(var UpPayData: TUpPayData; var sMsg: string): boolean; function BulidParam(nType: integer; UpPayData: TUpPayData): string; function BulidParam_Refund(nType: integer; UpRefundData: TUpRefundData): string; function ret_mymd5(const sVaule: string): string; function GetSign(var UpPayData: TUpPayData; var sMsg: string): boolean; function PostIntf(UpPayData: TUpPayData; var sJson,sMsg: string): boolean; function PostIntf_Refund(UpRefundData: TUpRefundData; var sJson,sMsg: string): boolean; function GetJsonArr(Cds_BillList: TClientDataSet): string; //提交支付接口函数 function Tkt_PayIntf(UpPayData: TUpPayData; DownPayData: TDownPayData): boolean; //提交退款接口函数 function Tkt_RefundIntf(UpRefundData: TUpRefundData; DownRefundData: TDownRefundData): boolean; implementation uses unit1; function Tkt_PayIntf(UpPayData: TUpPayData; DownPayData: TDownPayData): boolean; var sMsg,sJson: string; JO: ISuperObject; begin {** * 1、检查必要条件 * 2、格式化数据 * 3、获取签名 * 4、提交接口 * 5、解析返回Json *} Result := False; try if not CheckInvalid(UpPayData, sMsg) then begin MyWriteLog(sMsg); Application.MessageBox(Pchar(sMsg), ‘提示‘, MB_OK); Exit; end; if not FormatData(UpPayData, sMsg) then begin MyWriteLog(sMsg); Application.MessageBox(Pchar(sMsg), ‘提示‘, MB_OK); Exit; end; if not GetSign(UpPayData, sMsg) then begin MyWriteLog(sMsg); Application.MessageBox(Pchar(sMsg), ‘提示‘, MB_OK); Exit; end; if not PostIntf(UpPayData, sJson, sMsg) then //提交接口 begin MyWriteLog(‘返回信息：‘ + sJson); Application.MessageBox(Pchar(sMsg), ‘提示‘, MB_OK); Exit; end; //解析返回的Json MyWriteLog(‘解析Json：‘ + sJson); try sMsg := ‘解析Json错误！‘; JO := SO(sJson); if UpperCase(JO.O[‘return_code‘].AsString) = ‘FAIL‘ then begin sMsg := ‘返回状态码：【‘ + JO.O[‘return_code‘].AsString + ‘:‘ + JO.O[‘return_desc‘].AsString + ‘】‘; MyWriteLog(sMsg); Application.MessageBox(Pchar(sMsg), ‘提示‘, MB_OK); Exit; end; if UpperCase(JO.O[‘result_code‘].AsString) = ‘FAIL‘ then begin sMsg := ‘返回业务结果：【‘ + JO.O[‘result_code‘].AsString + ‘】‘; MyWriteLog(sMsg); Application.MessageBox(Pchar(sMsg), ‘提示‘, MB_OK); Exit; end; //只有为SUCCESS才返回以下信息 if UpperCase(JO.O[‘result_code‘].AsString) = ‘SUCCESS‘ then begin DownPayData.orderNo := JO.O[‘result_code‘].AsString; DownPayData.merchantOrderNo := JO.O[‘merchantOrderNo‘].AsString; DownPayData.succTime := JO.O[‘succTime‘].AsString; DownPayData.succAmount := JO.O[‘succAmount‘].AsInteger; sMsg := ‘返回业务结果：【‘ + JO.O[‘result_code‘].AsString + ‘】‘; MyWriteLog(sMsg); Result := True; end; except on e:exception do begin sMsg := ‘解析异常：‘ + e.Message; MyWriteLog(sMsg); Application.MessageBox(Pchar(sMsg), ‘提示‘, MB_OK); Exit; end; end; except on e:exception do begin sMsg := ‘接口异常[售票]：‘ + e.Message; MyWriteLog(sMsg); Application.MessageBox(Pchar(sMsg), ‘提示‘, MB_OK); Exit; end; end; end; function Tkt_RefundIntf(UpRefundData: TUpRefundData; DownRefundData: TDownRefundData): boolean; var sMsg,sJson: string; JO: ISuperObject; begin try {** * 1、检查必要条件 * 2、提交接口 * 3、解析返回Json *} Result := False; if not CheckInvalid_Refund(UpRefundData, sMsg) then begin Application.MessageBox(Pchar(sMsg), ‘提示‘, MB_OK); Exit; end; MyWriteLog(‘提交信息：‘ + BulidParam_Refund(1,UpRefundData)); if not PostIntf_Refund(UpRefundData, sJson, sMsg) then //提交接口 begin MyWriteLog(‘返回信息：‘ + sJson); Application.MessageBox(Pchar(sMsg), ‘提示‘, MB_OK); Exit; end; //解析返回的Json MyWriteLog(‘解析Json：‘ + sJson); try sMsg := ‘解析Json错误！‘; JO := SO(sJson); if UpperCase(JO.O[‘return_code‘].AsString) = ‘FAIL‘ then begin sMsg := ‘返回状态码：【‘ + JO.O[‘return_code‘].AsString + ‘:‘ + JO.O[‘return_desc‘].AsString + ‘】‘; MyWriteLog(sMsg); Application.MessageBox(Pchar(sMsg), ‘提示‘, MB_OK); Exit; end; if UpperCase(JO.O[‘result_code‘].AsString) = ‘FAIL‘ then begin sMsg := ‘返回业务结果：【‘ + JO.O[‘result_code‘].AsString + ‘】‘; MyWriteLog(sMsg); Application.MessageBox(Pchar(sMsg), ‘提示‘, MB_OK); Exit; end; //只有为SUCCESS才返回以下信息 if UpperCase(JO.O[‘result_code‘].AsString) = ‘SUCCESS‘ then begin DownRefundData.orderNo := JO.O[‘orderNo‘].AsString; DownRefundData.refundTime := JO.O[‘refundTime‘].AsString; DownRefundData.refundAmount := JO.O[‘refundAmount‘].AsInteger; sMsg := ‘返回业务结果：【‘ + JO.O[‘result_code‘].AsString + ‘】‘; MyWriteLog(sMsg); Result := True; end; except on e:exception do begin sMsg := ‘解析异常：‘ + e.Message; MyWriteLog(sMsg); Application.MessageBox(Pchar(sMsg), ‘提示‘, MB_OK); Exit; end; end; except on e:exception do begin sMsg := ‘接口异常[退票]：‘ + e.Message; MyWriteLog(sMsg); Application.MessageBox(Pchar(sMsg), ‘提示‘, MB_OK); Exit; end; end; end; function PostIntf(UpPayData: TUpPayData; var sJson,sMsg: string): boolean; var Temp: string; IdHttp: TIdHTTP; begin sMsg := ‘提交接口错误！‘; sJson := ‘‘; Result := False; Temp := g_sPayUrl + ‘?‘; Temp := Temp + BulidParam(0, UpPayData); Temp := AnsiToUtf8(Temp); MyWriteLog(‘提交表单：‘ + Temp); IdHttp := TIdHTTP.Create(nil); try try IdHttp.HTTPOptions := IdHttp.HTTPOptions + [hoKeepOrigProtocol]; IdHttp.ProtocolVersion := pv1_1; IdHttp.Request.Accept := ‘image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, */*‘; IdHttp.Request.UserAgent := ‘Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; Maxthon; .NET CLR 1.1.4322)‘; IdHttp.Request.ContentEncoding := ‘utf-8‘; IdHttp.Request.ContentType := ‘text/xml;Charset=UTF-8‘; //正式提交接口 sJson := IdHttp.Get(Temp); sJson := UTF8Decode(sJson); sJson := StringReplace(sJson, ‘\‘, ‘‘, [rfReplaceAll]); sJson := StringReplace(sJson, ‘"{"‘, ‘[{"‘, [rfReplaceAll]); sJson := StringReplace(sJson, ‘"}"‘, ‘"}]‘, [rfReplaceAll]); if sJson = ‘‘ then begin sMsg := ‘错误：接口返回数据为空！‘; Exit; end; Result := True; except on e: Exception do begin sMsg := ‘提交接口异常:‘ + e.Message; MyWriteLog(sMsg); Exit; end; end; finally FreeAndNil(IdHttp); end; end; function PostIntf_Refund(UpRefundData: TUpRefundData; var sJson,sMsg: string): boolean; var Temp: string; IdHttp: TIdHTTP; begin sMsg := ‘提交接口错误！‘; sJson := ‘‘; Result := False; Temp := g_sRefundUrl + ‘?‘; Temp := Temp + BulidParam_Refund(0, UpRefundData); Temp := AnsiToUtf8(Temp); IdHttp := TIdHTTP.Create(nil); try try IdHttp.HTTPOptions := IdHttp.HTTPOptions + [hoKeepOrigProtocol]; IdHttp.ProtocolVersion := pv1_1; IdHttp.Request.Accept := ‘image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, */*‘; IdHttp.Request.UserAgent := ‘Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; Maxthon; .NET CLR 1.1.4322)‘; IdHttp.Request.ContentEncoding := ‘utf-8‘; IdHttp.Request.ContentType := ‘text/xml;Charset=UTF-8‘; //正式提交接口 sJson := IdHttp.Get(Temp); sJson := UTF8Decode(sJson); sJson := StringReplace(sJson, ‘\‘, ‘‘, [rfReplaceAll]); sJson := StringReplace(sJson, ‘"{"‘, ‘[{"‘, [rfReplaceAll]); sJson := StringReplace(sJson, ‘"}"‘, ‘"}]‘, [rfReplaceAll]); if sJson = ‘‘ then begin sMsg := ‘错误：接口返回数据为空！‘; Exit; end; Result := True; except on e: Exception do begin sMsg := ‘提交接口异常:‘ + e.Message; MyWriteLog(sMsg); Exit; end; end; finally FreeAndNil(IdHttp); end; end; function BulidParam(nType: integer; UpPayData: TUpPayData): string; var i: integer; Temp: string; Hash: THashedStringList; begin Hash := THashedStringList.Create; try Hash.Add(‘terminalNo=‘ + UpPayData.terminalNo); Hash.Add(‘orderNo=‘ + UpPayData.orderNo); Hash.Add(‘orderAmount=‘ + UpPayData.orderAmount); Hash.Add(‘cashAmount=‘ + UpPayData.cashAmount); Hash.Add(‘misAmount=‘ + UpPayData.misAmount); Hash.Add(‘salesman=‘ + UpPayData.salesman); Hash.Add(‘orderTime=‘ + UpPayData.orderTime); Hash.Add(‘payType=‘ + UpPayData.payType); Hash.Add(‘merchantNo=‘ + UpPayData.merchantNo); Hash.Add(‘tellerNo=‘ + UpPayData.tellerNo); Hash.Add(‘orgInfo=‘ + UpPayData.orgInfo); if UpPayData.sign <> ‘‘ then begin Hash.Add(‘orderDetail=‘ + HttpEncode(UTF8Encode(UpPayData.orderDetail))); //订单明细字段需要进行URL编码 <--提交接口的时候 Hash.Add(‘sign=‘ + UpPayData.sign); end else begin Hash.Add(‘orderDetail=‘ + UpPayData.orderDetail); end; Hash.Sort; if nType = 0 then begin for i := 0 to Hash.Count-1 do begin Temp := Temp + Trim(Hash.Strings[i]) + ‘&‘; end; Result := Copy(Temp,1,Length(Temp)-1); //去除最后一个字符"&" end else begin for i := 0 to Hash.Count-1 do begin Temp := Temp + ‘"‘ + Trim(Hash.Strings[i]) + ‘",‘; end; Temp := StringRePlace(Temp,‘=‘,‘","‘,[rfRePLaceAll]); Result := ‘{‘ + Copy(Temp,1,Length(Temp)-1) + ‘}‘; //去除最后一个字符"," end; finally FreeAndNil(Hash); end; end; function BulidParam_Refund(nType: integer; UpRefundData: TUpRefundData): string; var Temp: string; begin if nType = 0 then begin Temp := ‘orderNo‘ + UpRefundData.orderNo + ‘&‘; Temp := Temp + ‘refundAmount‘ + IntToStr(UpRefundData.refundAmount); Result := Temp; end else begin Temp := ‘{‘; Temp := Temp + ‘"orderNo":"‘ + Trim(UpRefundData.orderNo) + ‘",‘; Temp := Temp + ‘"refundAmount":"‘ + IntToStr(UpRefundData.refundAmount) + ‘"‘; Temp := Temp + ‘}‘; Result := Temp; end; end; function ret_mymd5(const sVaule: string): string; var mymd5: TIdHashMessageDigest5; begin try mymd5 := TIdHashMessageDigest5.Create; Result := (mymd5.AsHex(mymd5.HashValue(sVaule))); finally mymd5.Free; end; end; function GetSign(var UpPayData: TUpPayData; var sMsg: string): boolean; var Temp: string; begin Result := False; sMsg := ‘获取签名失败！‘; try Temp := BulidParam(0, UpPayData); MyWriteLog(‘获取字符串：‘ + Temp); Temp := Temp + g_sKey; MyWriteLog(‘获取密钥：‘ + g_sKey); Temp := ret_mymd5(Temp); UpPayData.sign := LowerCase(Temp); //签名小写 sMsg := ‘获取签名成功！‘; MyWriteLog(‘获取签名成功：‘ + UpPayData.sign); Result := True; except on e:exception do begin sMsg := ‘获取签名异常：‘ + e.Message; MyWriteLog(sMsg); Exit; end; end; end; function CheckInvalid(UpPayData: TUpPayData; var sMsg: string): boolean; begin Result := False; sMsg := ‘检查传入参数失败！‘; try //必填项检查 if UpPayData.orderNo = ‘‘ then begin sMsg := ‘订单编号必须填写！‘; Exit; end; if UpPayData.orderAmount = ‘‘ then begin sMsg := ‘订单金额必须填写！‘; Exit; end; if UpPayData.orderTime = ‘‘ then begin sMsg := ‘下单时间必须填写！‘; Exit; end; if UpPayData.payType = ‘‘ then begin sMsg := ‘支付方式必须填写！‘; Exit; end; if UpPayData.merchantNo = ‘‘ then begin sMsg := ‘商户编号必须填写！‘; Exit; end; if UpPayData.tellerNo = ‘‘ then begin sMsg := ‘销售员编号必须填写！‘; Exit; end; if UpPayData.orderDetail = ‘‘ then begin sMsg := ‘订单明细必须填写！‘; Exit; end; if (UpPayData.payType <> ‘00‘) and (UpPayData.payType <> ‘01‘) and (UpPayData.payType <> ‘02‘) then begin sMsg := ‘非00/01/02的支付方式！‘; Exit; end; //下单时间:格式：yyyyMMddHHmmss try VarToDateTime(UpPayData.orderTime) except sMsg := ‘下单时间格式错误！‘; Exit; end; //[C]终端编号:支付的中行MIS终端编号,当支付方式是01或02时必填 if (UpPayData.payType = ‘01‘) or (UpPayData.payType = ‘02‘) then begin if UpPayData.terminalNo = ‘‘ then begin sMsg := ‘中行MIS终端编号必须填写！‘; Exit; end; end; //[C]现金支付金额:当支付方式是00或02时必填,12位，以分为单位，比如1分=000000000001 if (UpPayData.payType = ‘00‘) or (UpPayData.payType = ‘02‘) then begin if UpPayData.cashAmount = ‘‘ then begin sMsg := ‘必须填写现金金额！‘; Exit; end; end; //[C]MIS支付金额:当支付方式是01或02时必填,12位，以分为单位，比如1分=000000000001 if (UpPayData.payType = ‘01‘) or (UpPayData.payType = ‘02‘) then begin if UpPayData.misAmount = ‘‘ then begin sMsg := ‘必须填写MIS支付金额！‘; Exit; end; end; if StrToFloatDef(UpPayData.orderAmount, 0) = 0 then begin sMsg := ‘订单金额为零！‘; Exit; end; if (StrToFloatDef(UpPayData.cashAmount, 0) = 0) or (StrToFloatDef(UpPayData.misAmount, 0) = 0) then begin sMsg := ‘现金和Mis支付的金额均为零！‘; Exit; end; if Length(UpPayData.orderAmount) > L then begin sMsg := ‘订单金额长度不允许超过‘ + IntToStr(L) + ‘位数！‘; Exit; end; if Length(UpPayData.cashAmount) > L then begin sMsg := ‘现金金额长度不允许超过‘ + IntToStr(L) + ‘位数！‘; Exit; end; if Length(UpPayData.misAmount) > L then begin sMsg := ‘Mis支付金额长度不允许超过‘ + IntToStr(L) + ‘位数！‘; Exit; end; sMsg := ‘检查传入参数通过！‘; Result := True; except on e:exception do begin sMsg := ‘检查传入参数异常：‘ + e.Message; MyWriteLog(sMsg); Exit; end; end; end; function CheckInvalid_Refund(UpRefundData: TUpRefundData; var sMsg: string): boolean; begin Result := False; sMsg := ‘检查传入参数失败！‘; try //必填项检查 if UpRefundData.orderNo = ‘‘ then begin sMsg := ‘退单编号必须填写！‘; Exit; end; if (UpRefundData.refundAmount <= 0) then begin sMsg := ‘退单金额必须大于零！‘; Exit; end; if (UpRefundData.refundAmount > 99999) then //若未赋值，则系统默认最大整数值 begin sMsg := ‘必须输入退款金额！‘; Exit; end; sMsg := ‘检查传入参数通过！‘; Result := True; except on e:exception do begin sMsg := ‘检查传入参数异常：‘ + e.Message; MyWriteLog(sMsg); Exit; end; end; end; function ExchangeMoney(Value: string): string; var S,Temp: string; i: integer; begin Result := ‘0‘; S := Value; S := FormatFloat(‘0.00‘, StrToFloatDef(S, 0)); //保留小数点两位 S := FloatToStr(StrToFloat(S) * 100); //转换为分 for i := 1 to L-Length(S) do begin Temp := Temp + ‘0‘; end; Result := Temp + S; //格式化长度为12位数 end; function FormatData(var UpPayData: TUpPayData; var sMsg: string): boolean; begin Result := False; sMsg := ‘格式化数据错误！‘; try UpPayData.orderAmount := ExChangeMoney(UpPayData.orderAmount); UpPayData.cashAmount := ExChangeMoney(UpPayData.cashAmount); UpPayData.misAmount := ExChangeMoney(UpPayData.misAmount); sMsg := ‘格式化数据成功！‘; Result := True; Except on e:exception do begin sMsg := ‘格式化数据异常：‘ + e.Message; MyWriteLog(sMsg); Exit; end; end; end; procedure MyWriteLog(const mStr:string); var f: textfile; myDir,myFileName: string; FileHandle:Integer; LogType,LogDate,ModuleID: String; begin LogType := ‘INFO‘; LogDate := FormatDateTime(‘YYYY-MM-DD hh:nn:ss zzz‘, Now); ModuleID := ‘‘; // if not (CanLogFile in FLogFlags) then exit; //------写入文件部分的实现--开始 myDir := ExtractFilePath(Paramstr(0)); //确定文件名称 myFileName := FormatDateTime(‘"PayIntf"yyyymmdd".log"‘, Date); //如果可执行目录下不存在log目录创建之 if not DirectoryExists(myDir + ‘\log‘) then CreateDir(myDir + ‘\log‘); //如果当日日志文件不存在，则创建文件并释放句柄 if not FileExists(myDir + ‘\log\‘ + myFileName) then begin FileHandle:=FileCreate(myDir + ‘\log\‘ + myFileName);//创建文件 FileClose(FileHandle);//释放句柄 end; try//try...except...statements AssignFile(f, myDir + ‘\log\‘ + myFileName); Append(f); Writeln(f, ‘$$‘+Format(‘%6s‘,[LogType])+‘$$ ‘+Format(‘%12s‘,[ModuleID])+‘$$‘+LogDate + chr(9) + mStr); Flush(f); CloseFile(f); //-----写入文件部分的实现--结束 except//try...except...statements end;//try...except...statements end; function GetJsonArr(Cds_BillList: TClientDataSet): string; var Temp, ticketType,ticketSpecies, ticketFrom,ticketNum:string; ticketPrice,ticketAmount:Integer; cds_Temp: TClientDataSet; begin {** * ******获取订单明细组合成JSON数组字符串********** * 票型 ticketType S M * 票种 ticketSpecies S M * 来源 ticketFrom S M * 票价 ticketPrice N M 以分为单位 * 数量 ticketNum S M * 金额 ticketAmount N M 以分为单位，金额=票价*数量 **} Result := ‘‘; Temp := ‘‘; if Cds_BillList.IsEmpty then Exit; cds_Temp := TClientDataSet.Create(nil); try try cds_Temp.Data := Cds_BillList.Data; with cds_Temp do begin First; While Not Eof do begin ticketType := FieldByName(‘TicketModelName‘).AsString; ticketSpecies := FieldByName(‘TicketKindName‘).AsString; ticketFrom := ‘TicketBySell‘; ticketPrice := StrToInt(ExchangeMoney(CurrToStr(FieldByName(‘TicketPrice‘).AsCurrency))); ticketNum := IntToStr(FieldByName(‘TicketCount‘).AsInteger); ticketAmount := StrToInt(ExchangeMoney(CurrToStr(FieldByName(‘PaySum‘).AsCurrency))); Temp := ‘{‘; Temp := Temp + ‘"ticketType":"‘ + Trim(ticketType) + ‘",‘; Temp := Temp + ‘"ticketSpecies":"‘ + Trim(ticketSpecies) + ‘",‘; Temp := Temp + ‘"ticketFrom":"‘ + Trim(ticketFrom) + ‘",‘; Temp := Temp + ‘"ticketPrice":"‘ + IntToStr(ticketPrice) + ‘",‘; Temp := Temp + ‘"ticketNum":"‘ + Trim(ticketNum) + ‘",‘; Temp := Temp + ‘"ticketAmount":"‘ + IntToStr(ticketAmount) + ‘"‘; Temp := Temp + ‘},‘; Next; end; end; if Temp <> ‘‘ then begin Result := ‘[‘ + Copy(Temp,1,Length(Temp)-1) + ‘]‘; //去除最后一位的"," end; finally FreeAndNil(cds_Temp); end; except on e:exception do begin Result := ‘‘; Exit; end; end; end; end.