1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
| // -----------------------------
// SI06 Test du numéro de série du colis
//------------------------------
procedure TestColisSerie(adIp : string; numeroCmd : string; ligne : string; lot : string; sMod : string; sAct : string; OraSession : TOracleSession; SerSocket : TServerSocket; idConnex : integer; Trace : TMemo);
var
oqSelect : TOracleQuery;
begin
oqSelect := TOracleQuery.Create(Nil);
oqSelect.Session := OraSession;
Try
oqSelect.Close;
oqSelect.SQL.Clear;
oqSelect.SQL.Add('select count(*) as total from COLXRES where NUMXCOL=:num and LIGXCOL=:lig and LT1XCOL=:lot');
oqSelect.DeclareAndSet('num', otInteger, StrToInt(numeroCmd));
oqSelect.DeclareAndSet('lig', otInteger, StrToInt(ligne));
oqSelect.DeclareAndSet('lot', otInteger, lot);
if TestRequete(oqSelect, 'OPENREQ') then
begin
if oqSelect.Field('total') > 0 then
begin
envoiMsgSocket(idConnex, numeroCmd, 'NUMSERIEDEJA', SerSocket, Trace);
maj_raoxres('', adIp, sMod, sAct, '', numeroCmd, '', '', '', 'Prep Chariot - Num Serie déjà saisi', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'N', 'N', 'N', 'A', OraSession);
end
else
begin
envoiMsgSocket(idConnex, numeroCmd, 'SERIEOK', SerSocket, Trace);
maj_raoxres('', adIp, sMod, sAct, '', numeroCmd, '', '', '', 'Prep Chariot - Num Serie Ok', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'N', 'N', 'N', 'A', OraSession);
end;
end
else
begin
envoiMsgSocket(idConnex, numeroCmd, 'ANOMALIERECHSERIE', SerSocket, Trace);
maj_raoxres('', adIp, sMod, sAct, '', numeroCmd, '', '', '', 'Prep Chariot - Anomalie recherche num série', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'N', 'N', 'N', 'A', OraSession);
end;
Finally
oqSelect.Close; oqSelect.Free;
End;
end; |
Partager