unit uFrame_STSVRS;

interface

uses
  System.SysUtils, System.Types, System.UITypes, System.Classes, System.Variants, 
  FMX.Types, FMX.Graphics, FMX.Controls, FMX.Forms, FMX.Dialogs, FMX.StdCtrls,
  uFrameBase,uKsoap,uPucFun,uShowInfo, FMX.Objects;

type
  TFrame_STSVRS = class(TFrameBase)
    TxtError: TText;
  private
    { Private declarations }
  public
     function DoExec():boolean;override;  //判断输入是否有效,执行插入主表,或打开窗体
     function CheckValid(var sTxt:string):boolean;override;
  end;

var
  Frame_STSVRS: TFrame_STSVRS;

implementation

{$R *.fmx}

uses uDM;

function TFrame_STSVRS.CheckValid(var sTxt:string):boolean; //返回面次数据
begin
   Result:=false;
   if not GetRadioTxt(sTxt) then  //没有选择,提示出错信息
   begin
       ErrorLayout(GridLayout,TxtError,'请选择TOP面/BOT面');
       Exit;
   end;
   Result:=true;
   TxtError.Text:='';
end;

function TFrame_STSVRS.DoExec():boolean;
var
    LotNoRecord:TLotNoRecord;
    vId:Integer;
    sTxt,sError:string;
    vP_ID:Double;
begin
    Result:=false;
    if CheckValid(sTxt) then  //上传数据
    begin
       LotNoRecord:=TLotNoRecord.Create('-1');  //初始化记录
       LotNoRecord.P_LOT:=ksoap.P_Lot;
       LotNoRecord.P_Enable:='Y';
       LotNoRecord.P_ID:=0;
       LotNoRecord.P_ORG_CODE:=ksoap.P_ORG_CODE;       //廠區
       LotNoRecord.P_NUM:=ksoap.P_WORK_NUM;            //工號
       LotNoRecord.P_PC:=ksoap.P_PC;            //製程
       LotNoRecord.P_LINE:=ksoap.P_LINE;         //線別
       LotNoRecord.P_LINE_NUM:=ksoap.P_LINE_NUM;     //線別編號
       LotNoRecord.P_SIDE:=sTxt;               //面次
       LotNoRecord.P_CREATION_DATE:=FormatDateTime('yyyymmdd hh:mm:ss',Now);

       sError:='';
       vP_ID:=Ksoap.Thread_cf_traceability_seq_f(ksoap.P_ORG_CODE,sError);
       LotNoRecord.P_ID:=vP_ID;
       if vP_ID=0 then
       BEGIN
           dm.InsertMain(vId,LotNoRecord,true);
           ShowInfoOK('連接數據庫服務器失敗數據暫存本地,正在生產中...');
           Result:=true;
       END
       ELSE
       BEGIN
           //直接调用API,出错再保存本地
           if not Ksoap.Thread_Insert_CM_WIP_PROCESS_LINE_HISTORY_NEW(LotNoRecord,sError) then  //提交主表不成功
           begin
              if sError='連接數據庫服務器失败' then
              begin
                 dm.InsertMain(vId,LotNoRecord,true);
                 ShowInfoOK('連接數據庫服務器失敗數據暫存本地,正在生產中...');
                 Result:=true;
              end
              else
                 ShowError(sError);
           end
           else
           begin
               ShowInfoOK('上傳成功,正在生產中...');
               Result:=true;
           end;
       END;
    end;
end;


end.