2,498
社区成员
发帖
与我相关
我的任务
分享
procedure TFmBarcodePrint.ADODS_M_barcode300_dtlAfterPost(
DataSet: TDataSet);
var
qry_tmp:TADOQuery;
i,j,mark:Integer;
bk:TBookmark;
begin
inherited;
bk:=ADODS_M_barcode300_dtl.GetBookmark;
qry_tmp:=TADOQuery.Create(Self);
qry_tmp.Clone(ADODS_M_barcode300_dtl);
ADODS_M_barcode300_dtl.First;
for i:=1 to ADODS_M_barcode300_dtl.RecordCount do
begin
mark:=0;
qry_tmp.First;
for j:=1 to qry_tmp.RecordCount do
begin
if ADODS_M_barcode300_dtl.FieldByName('barcodeNo_100').AsString=qry_tmp.FieldByName('barcodeNO_100').AsString then mark:=mark+1;
if mark>1 then
begin
Application.MessageBox('请勿输入重复值', 'Barcode_300', MB_OK +
MB_ICONSTOP);
FreeAndNil(qry_tmp);
ADODS_M_barcode300_dtl.Delete;
Exit;
end;
qry_tmp.Next;
end;
ADODS_M_barcode300_dtl.Next;
end;
FreeAndNil(qry_tmp);
ADODS_M_barcode300_dtl.GotoBookmark(bk);
end;