xSQL:='SELECT TICKNO FROM SUBCTLDOC WHERE COMPID =:xCompID AND TICKDT=:xDueDay AND TICKTP=:xSubID AND INTYPE=:xInType';
QryTemp.Close;
QryTemp.SQL.Clear;
QryTemp.SQL.Add(xSQL);
QryTemp.ParamByName('xCompID').AsString := xCompID;
QryTemp.ParamByName('xDueDay').AsString := xDueDay;
QryTemp.ParamByName('xSubID').AsString := xSubID;
QryTemp.ParamByName('xInType').AsString := xInType;
QryTemp.Open;
if not QryTemp.eof then ReSult := QryTemp.FieldByName('TICKNO').AsInteger else ReSult := -1;
QryTemp.Close;
QryTemp.SQL.Clear;
QryTemp.SQL.Add(xSQL);
QryTemp.ParamByName('xCompID').AsString := xCompID;
QryTemp.ParamByName('xDueDay').AsString := xDueDay;
QryTemp.ParamByName('xSubID').AsString := xSubID;
QryTemp.ParamByName('xInType').AsString := xInType;
QryTemp.Open;
if not QryTemp.eof then ReSult := QryTemp.FieldByName('TICKNO').AsInteger else ReSult := -1;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货