unit U_YEYarnInEdit;

interface

uses
  Windows, Messages, strUtils, SysUtils, Variants, Classes, Graphics, Controls,
  Forms, Dialogs, cxStyles, cxCustomData, cxGraphics, cxFilter, cxData,
  cxDataStorage, cxEdit, DB, cxDBData, StdCtrls, ExtCtrls, ADODB, DBClient,
  cxGridCustomPopupMenu, cxGridPopupMenu, cxGridLevel, MMSystem,
  cxGridCustomTableView, cxGridTableView, cxGridDBTableView, cxClasses,
  cxControls, cxGridCustomView, cxGrid, MovePanel, cxCheckBox, Menus, ComCtrls,
  cxLookAndFeels, cxLookAndFeelPainters, cxNavigator, U_BaseList, dxSkinsCore,
  dxSkinsDefaultPainters, dxDateRanges, dxBarBuiltInMenu, RM_Common, RM_Class,
  RM_GridReport, RM_Dataset, Vcl.ToolWin;

type
  TfrmYEYarnInEdit = class(TfrmBaseList)
    GPM_1: TcxGridPopupMenu;
    CDS_1: TClientDataSet;
    DS_1: TDataSource;
    ADOQueryTemp: TADOQuery;
    ADOQueryCmd: TADOQuery;
    ADOQueryMain: TADOQuery;
    Panel1: TPanel;
    CDS_2: TClientDataSet;
    DS_2: TDataSource;
    GPM_2: TcxGridPopupMenu;
    DS_3: TDataSource;
    CDS_3: TClientDataSet;
    GPM_3: TcxGridPopupMenu;
    Panel2: TPanel;
    Panel4: TPanel;
    cxGrid1: TcxGrid;
    Tv1: TcxGridDBTableView;
    v1Column6: TcxGridDBColumn;
    v1Column11: TcxGridDBColumn;
    v1Column3: TcxGridDBColumn;
    Tv1Column1: TcxGridDBColumn;
    v1Column4: TcxGridDBColumn;
    v2Column6: TcxGridDBColumn;
    v2Column5: TcxGridDBColumn;
    cxGrid1Level1: TcxGridLevel;
    ToolBar1: TToolBar;
    ToolButton2: TToolButton;
    ToolBar2: TToolBar;
    ToolButton1: TToolButton;
    Panel3: TPanel;
    Label4: TLabel;
    Label5: TLabel;
    Label11: TLabel;
    CRTime: TDateTimePicker;
    InNo: TEdit;
    CRType: TComboBox;
    ToolBar3: TToolBar;
    ToolButton3: TToolButton;
    btnGetOutNo: TToolButton;
    ToolButton6: TToolButton;
    ToolButton7: TToolButton;
    ToolButton8: TToolButton;
    edtScan: TEdit;
    Label6: TLabel;
    ToolButton9: TToolButton;
    ToolButton10: TToolButton;
    ToolButton11: TToolButton;
    ToolButton12: TToolButton;
    ToolButton4: TToolButton;
    Tv1Column2: TcxGridDBColumn;
    cxGrid3: TcxGrid;
    TV3: TcxGridDBTableView;
    cxGridDBColumn1: TcxGridDBColumn;
    cxGridDBColumn4: TcxGridDBColumn;
    cxGridDBColumn5: TcxGridDBColumn;
    cxGridDBColumn6: TcxGridDBColumn;
    cxGridDBColumn7: TcxGridDBColumn;
    cxGridDBColumn8: TcxGridDBColumn;
    cxGridDBColumn9: TcxGridDBColumn;
    cxGridDBColumn10: TcxGridDBColumn;
    cxGridLevel1: TcxGridLevel;
    cxGrid2: TcxGrid;
    Tv2: TcxGridDBTableView;
    v2Column3: TcxGridDBColumn;
    Tv2Column2: TcxGridDBColumn;
    cxGridDBColumn2: TcxGridDBColumn;
    Tv2Column3: TcxGridDBColumn;
    Tv2Column4: TcxGridDBColumn;
    cxGridDBColumn3: TcxGridDBColumn;
    Tv2Column1: TcxGridDBColumn;
    v1Column10: TcxGridDBColumn;
    v1Column14: TcxGridDBColumn;
    Tv2Column5: TcxGridDBColumn;
    Tv2Column6: TcxGridDBColumn;
    Tv2Column7: TcxGridDBColumn;
    Tv2Column8: TcxGridDBColumn;
    Tv2Column9: TcxGridDBColumn;
    v1PRTMF: TcxGridDBColumn;
    v1PRTKZ: TcxGridDBColumn;
    cxGridLevel2: TcxGridLevel;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormDestroy(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure Tv2CellDblClick(Sender: TcxCustomGridTableView; ACellViewInfo: TcxGridTableDataCellViewInfo; AButton: TMouseButton; AShift: TShiftState; var AHandled: Boolean);
    procedure ToolButton1Click(Sender: TObject);
    procedure ToolButton2Click(Sender: TObject);
    procedure ToolButton6Click(Sender: TObject);
    procedure ToolButton3Click(Sender: TObject);
    procedure btnGetOutNoClick(Sender: TObject);
    procedure ToolButton7Click(Sender: TObject);
    procedure ToolButton8Click(Sender: TObject);
    procedure edtScanKeyPress(Sender: TObject; var Key: Char);
    procedure ToolButton9Click(Sender: TObject);
    procedure ToolButton10Click(Sender: TObject);
    procedure ToolButton11Click(Sender: TObject);
    procedure ToolButton12Click(Sender: TObject);
    procedure ToolButton4Click(Sender: TObject);
  private
    { Private declarations }
    FScan, FMainId: string;
    procedure PlayWav(MWav: string);
    procedure InitGrid1();
    procedure InitGrid2();
    procedure InitGrid3();
    procedure ScanSubID();
    procedure ScanCIID();
  public

    { Public declarations }
  end;

var
  frmYEYarnInEdit: TfrmYEYarnInEdit;

implementation

uses
  U_DataLink, U_RTFun, U_YEYarnWaitStorage, U_LabelPrint;

{$R *.dfm}
procedure TfrmYEYarnInEdit.PlayWav(MWav: string);
begin
  if FileExists(PChar(ExtractFilePath(Application.ExeName) + 'wav\' + MWav + '.wav')) then
    PlaySound(PChar(ExtractFilePath(Application.ExeName) + 'wav\' + MWav + '.wav'), 0, SND_ASYNC);
end;

procedure TfrmYEYarnInEdit.InitGrid2();
begin
  with ADOQueryTemp do
  begin
    Close;
    sql.Clear;
    sql.Add('select A.*  ');
    sql.Add(',ZPPS=(select Count(KC.StkID) from YE_Yarn_Stock KC  where KC.StkCycles=0 AND KC.Mainid=A.Mainid and KC.StkExists=0  ) ');
    sql.Add(',ZPKGQty=(select sum(StkGrossWeight) from YE_Yarn_Stock KC where KC.StkCycles=0 AND KC.Mainid=A.Mainid and KC.StkExists=0 ) ');
    sql.Add('from YE_Plan_Main A  where 1=1');

    if TRIm(FMainId) <> '' then
      sql.add('and MainId in (' + FMainId + ')')
    else
      sql.add('and 1=2');
    Open;
  end;
  SCreateCDS(ADOQueryTemp, CDS_2);
  SInitCDSData(ADOQueryTemp, CDS_2);
end;

procedure TfrmYEYarnInEdit.InitGrid1();
begin

  with ADOQueryMain do
  begin
    Close;
    sql.Clear;
    sql.Add('select A.IOFlag,A.IONo,A.IOID,B.* from YE_Yarn_IO A    ');
    sql.Add('right join YE_Yarn_Stock B on A.StkId=B.StkId     ');
    sql.Add('where  B.StkExists=0 and  B.StkCycles=0  ');
    if TRIm(FMainId) <> '' then
      sql.add('and MainId in (' + FMainId + ')')
    else
      sql.add('and 1=2');
//    ShowMessage(sql.Text);
    Open;
  end;
  SCreateCDS(ADOQueryMain, CDS_1);
  SInitCDSData(ADOQueryMain, CDS_1);

end;

procedure TfrmYEYarnInEdit.InitGrid3();
begin

  with ADOQueryTemp do
  begin
    Close;
    sql.Clear;
    sql.Add('select A.IOFlag,A.IONo,A.IOID,B.* from YE_Yarn_IO A    ');
    sql.Add('inner join YE_Yarn_Stock B on A.StkId=B.StkId and A.IOCycles=B.StkCycles   ');
    sql.Add('where A.IOFlag=''入库'' and B.StkExists=1 ');
    if TRIm(InNo.Text) <> '' then
      sql.add('and IONO =' + QuotedStr(TRIm(InNo.Text)))
    else
      sql.add('and 1=2');
    Open;
  end;
  SCreateCDS(ADOQueryTemp, CDS_3);
  SInitCDSData(ADOQueryTemp, CDS_3);

end;

procedure TfrmYEYarnInEdit.ScanSubID();
var
  MStkIds: string;
begin
  try
    if Trim(InNo.Text) = '' then
      raise Exception.Create('入库单号不能为空!');
    if CDS_2.IsEmpty then
      raise Exception.Create('未选单不能扫描出库!');

    if not CDS_1.Locate('IONo', Trim(FScan), []) then
      raise Exception.Create('此入库单不包含在待入库的卷数据中');

    MStkIds := '';
    with CDS_1 do
    begin
      First;
      while CDS_1.Locate('IONo', Trim(FScan), []) = True do
      begin
        MStkIds := MStkIds + (Trim(CDS_1.FieldByName('StkId').AsString)) + ',';
        MoveCDS(CDS_1, CDS_3);
        CDS_1.Delete;
      end;
    end;

    MStkIds := copy(MStkIds, 1, Length(MStkIds) - 1);

    try
      ADOQueryCmd.Connection.BeginTrans;

      with ADOQueryCmd do
      begin
        Close;
        Sql.Clear;
        Sql.Add('exec P_YE_Yarn_In ');
        Sql.Add('@StkIds=' + quotedstr(trim(MStkIds)));
        Sql.Add(',@IOTime=' + Quotedstr(FormatDateTime('yyyy-MM-dd', CRTime.DateTime)));
        Sql.Add(',@IOType=' + Quotedstr(crtype.Text));
        Sql.Add(',@IONO=' + Quotedstr(InNo.Text));
        Open;
      end;
      if ADOQueryCmd.FieldByName('intReturn').AsInteger = -1 then
      begin
        raise Exception.Create(pchar(trim(ADOQueryCmd.FieldByName('ShowMsg').AsString)));
      end;

      ADOQueryCmd.Connection.CommitTrans;
      PlayWav('正确');
    except
      ADOQueryCmd.Connection.RollbackTrans;
      raise Exception.Create(PChar(Exception(ExceptObject).Message));
    end;

  except
    application.MessageBox(PChar(Exception(ExceptObject).Message), '提示信息', 0);
//    PlayWav('发货错误');
  end;

end;

procedure TfrmYEYarnInEdit.ScanCIID();
var
  MStkIds: string;
begin
  try
    if Trim(InNo.Text) = '' then
      raise Exception.Create('入库单号不能为空!');
    if CDS_2.IsEmpty then
      raise Exception.Create('未选单不能扫描出库!');

    if not CDS_1.Locate('StkId', Trim(FScan), []) then
      raise Exception.Create('此条码不包含在待入库的卷数据中');
    MStkIds := (Trim(CDS_1.FieldByName('StkId').AsString));

    MoveCDS(CDS_1, CDS_3);
    CDS_1.Delete;

    try
      ADOQueryCmd.Connection.BeginTrans;

      with ADOQueryCmd do
      begin
        Close;
        Sql.Clear;
        Sql.Add('exec P_YE_Yarn_In ');
        Sql.Add('@StkIds=' + quotedstr(trim(MStkIds)));
        Sql.Add(',@IOTime=' + Quotedstr(FormatDateTime('yyyy-MM-dd', CRTime.DateTime)));
        Sql.Add(',@IOType=' + Quotedstr(crtype.Text));
        Sql.Add(',@IONO=' + Quotedstr(InNo.Text));
        Sql.Add(',@StkPosition=' + Quotedstr(''));
        Sql.Add(',@FillId=' + Quotedstr(DCode));
        Sql.Add(',@Filler=' + Quotedstr(DName));
        Open;
      end;
      if ADOQueryCmd.FieldByName('intReturn').AsInteger = -1 then
      begin
        raise Exception.Create(pchar(trim(ADOQueryCmd.FieldByName('ShowMsg').AsString)));
      end;
      ADOQueryCmd.Connection.CommitTrans;
      PlayWav('正确');
    except
      ADOQueryCmd.Connection.RollbackTrans;
      raise Exception.Create(PChar(Exception(ExceptObject).Message));
    end;

  except
    application.MessageBox(PChar(Exception(ExceptObject).Message), '提示信息', 0);
//    PlayWav('发货错误');
  end;

end;

procedure TfrmYEYarnInEdit.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  inherited;
  Action := caFree;
end;

procedure TfrmYEYarnInEdit.FormDestroy(Sender: TObject);
begin
  inherited;
  frmYEYarnInEdit := nil;
end;

procedure TfrmYEYarnInEdit.FormShow(Sender: TObject);
begin
  inherited;
  ReadCxGrid(self.caption + 'Tv1', Tv1, '加弹纱线仓库');
  ReadCxGrid(self.caption + 'Tv2', Tv2, '加弹纱线仓库');
  ReadCxGrid(self.caption + 'Tv3', Tv3, '加弹纱线仓库');
  InitGrid2();
  InitGrid1();
  InitGrid3();
  CRTime.DateTime := SGetServerDate(ADOQueryTemp);
end;

procedure TfrmYEYarnInEdit.Tv2CellDblClick(Sender: TcxCustomGridTableView; ACellViewInfo: TcxGridTableDataCellViewInfo; AButton: TMouseButton; AShift: TShiftState; var AHandled: Boolean);
begin
  if CDS_3.IsEmpty = False then
    Exit;
  if CDS_2.IsEmpty then
    Exit;
  if Application.MessageBox('确定要删除数据吗？', '提示', 32 + 4) <> IDYES then
    Exit;
  CDS_1.DisableControls;
  with CDS_1 do
  begin
    First;
    while not Eof do
    begin
      if Trim(CDS_1.fieldbyname('SubId').AsString) = Trim(CDS_2.fieldbyname('SubId').AsString) then
      begin
        CDS_1.Delete;
      end
      else
        Next;
    end;
  end;
  CDS_1.EnableControls;
  CDS_2.Delete;
end;

procedure TfrmYEYarnInEdit.edtScanKeyPress(Sender: TObject; var Key: Char);
var
  maxno, SMFlag, KYCKFlag, FMainId, ff: string;
  FFQty: Integer;
begin
  if Key = #13 then
  begin
    FScan := TRIM(edtScan.Text);
    edtScan.Text := '';
    if Copy(FScan, 1, 2) = 'RK' then
    begin
      ScanSubID();
    end
    else
    begin
      ScanCIID();
      InitGrid3();
      {if Trim(edtIsSMTH.Text) = '' then
      begin
        if Copy(FScan, 1, 2) = 'BI' then
        begin
          if not JudgeBao() then
            exit;
          SaveCKBao();
          PlaySound('wav/正确.wav', 0, SND_FILENAME or SND_ASYNC);
        end
        else
        begin
          if not JudgeJTM() then
            exit;
          SaveCKJTM();
          PlaySound('wav/正确.wav', 0, SND_FILENAME or SND_ASYNC);
        end;
      end
      else
      begin
        if JudgeJTMCX() then  //检测卷条码
          SaveCKJTMCX();
      end;            }
//      with ADOQueryCmd do
//      begin
//        Close;
//        sql.Clear;
//        sql.Add('exec P_FH_UP_FHQty ''' + Trim(CKNO.Text) + '''');
//        ExecSQL;
//      end;

    end;

  end;
end;

procedure TfrmYEYarnInEdit.ToolButton10Click(Sender: TObject);
begin
  SelOKNo(CDS_1, False);

end;

procedure TfrmYEYarnInEdit.ToolButton11Click(Sender: TObject);
begin
  SelOKNo(CDS_3, True);

end;

procedure TfrmYEYarnInEdit.ToolButton12Click(Sender: TObject);
begin
  SelOKNo(CDS_3, False);

end;

procedure TfrmYEYarnInEdit.ToolButton1Click(Sender: TObject);
var
  MStkIds, MIOIDS: string;
begin
  if CDS_3.IsEmpty then
    Exit;
  if Application.MessageBox('确定要执行此操作吗？', '提示', 32 + 4) <> IDYES then
    Exit;

  try
    if not CDS_3.Locate('SSel', True, []) then
      raise Exception.Create('请选择数据');

    MStkIds := '';
    MIOIDS := '';
    with CDS_3 do
    begin
      while CDS_3.Locate('SSel', True, []) do
      begin
        MStkIds := MStkIds + (Trim(CDS_3.FieldByName('StkId').AsString)) + ',';
        MIOIDS := MIOIDS + (Trim(CDS_3.FieldByName('IOID').AsString)) + ',';
        CDS_3.Delete;
      end;
    end;

    MStkIds := copy(MStkIds, 1, Length(MStkIds) - 1);
    MIOIDS := copy(MIOIDS, 1, Length(MIOIDS) - 1);

    try
      ADOQueryCmd.Connection.BeginTrans;
      with ADOQueryCmd do
      begin
        Close;
        Sql.Clear;
        Sql.Add('exec P_YE_Yarn_ReIn ');
        Sql.Add('@StkIds=' + quotedstr(trim(MStkIds)));
        Sql.Add(',@IOIDS=' + quotedstr(trim(MIOIDS)));
        Sql.Add(',@FillId=' + Quotedstr(DCode));
        Sql.Add(',@Filler=' + Quotedstr(DName));
        Open;
      end;
      if ADOQueryCmd.FieldByName('intReturn').AsInteger = -1 then
      begin
        raise Exception.Create(pchar(trim(ADOQueryCmd.FieldByName('ShowMsg').AsString)));
      end;
      ADOQueryCmd.Connection.CommitTrans;
      PlayWav('正确');
      InitGrid1();
    except
      ADOQueryCmd.Connection.RollbackTrans;
      raise Exception.Create(PChar(Exception(ExceptObject).Message));
    end;
  except
    InitGrid1();
    InitGrid3();
    application.MessageBox(PChar(Exception(ExceptObject).Message), '提示信息', 0);
//    PlayWav('发货错误');
  end;

end;

procedure TfrmYEYarnInEdit.ToolButton2Click(Sender: TObject);
var
  MStkIds: string;
begin
  try
    if Trim(InNo.Text) = '' then
      raise Exception.Create('入库单号不能为空!');
    if CDS_2.IsEmpty then
      raise Exception.Create('未选单不能扫描出库!');

    if not CDS_1.Locate('SSel', True, []) then
      raise Exception.Create('请选择数据');
    MStkIds := '';
    with CDS_1 do
    begin
      while CDS_1.Locate('SSel', True, []) = True do
      begin
        MStkIds := MStkIds + Trim(CDS_1.FieldByName('StkId').AsString) + ',';
        CDS_1.Delete;
      end;
    end;

    MStkIds := copy(MStkIds, 1, Length(MStkIds) - 1);

    try
      ADOQueryCmd.Connection.BeginTrans;

      with ADOQueryCmd do
      begin
        Close;
        Sql.Clear;
        Sql.Add('exec P_YE_Yarn_In ');
        Sql.Add('@StkIds=' + quotedstr(trim(MStkIds)));
        Sql.Add(',@IOTime=' + Quotedstr(FormatDateTime('yyyy-MM-dd', CRTime.DateTime)));
        Sql.Add(',@IOType=' + Quotedstr(crtype.Text));
        Sql.Add(',@IONO=' + Quotedstr(InNo.Text));
        Sql.Add(',@StkPosition=' + Quotedstr(''));
        Sql.Add(',@FillId=' + Quotedstr(DCode));
        Sql.Add(',@Filler=' + Quotedstr(DName));
        Open;
      end;
      if ADOQueryCmd.FieldByName('intReturn').AsInteger = -1 then
      begin
        raise Exception.Create(pchar(trim(ADOQueryCmd.FieldByName('ShowMsg').AsString)));
      end;
      ADOQueryCmd.Connection.CommitTrans;
      PlayWav('正确');
      InitGrid3();
    except
      ADOQueryCmd.Connection.RollbackTrans;
      raise Exception.Create(PChar(Exception(ExceptObject).Message));
    end;

  except
    InitGrid1();
    InitGrid3();
    application.MessageBox(PChar(Exception(ExceptObject).Message), '提示信息', 0);
//    PlayWav('发货错误');
  end;

end;

procedure TfrmYEYarnInEdit.ToolButton3Click(Sender: TObject);
begin
  if Trim(InNo.Text) = '' then
    Exit;

  try
    frmLabelPrint := TfrmLabelPrint.Create(Application);
    with frmLabelPrint do
    begin
      FLMType := 'YEYarnIn1';
      FFiltration1 := Trim(Self.InNo.Text);
      if ShowModal = 1 then
      begin

      end;
    end;
  finally
    frmLabelPrint.Free;
  end;

end;

procedure TfrmYEYarnInEdit.ToolButton4Click(Sender: TObject);
begin
  FMainId := '';
  InitGrid2();
end;

procedure TfrmYEYarnInEdit.btnGetOutNoClick(Sender: TObject);
var
  maxNo: string;
begin
  if GetLSNo(ADOQueryCmd, maxNo, 'RK', 'YE_Yarn_IO', 3, 1) = False then
  begin
    Application.MessageBox('取入库单号失败!', '提示', 0);
    Exit;
  end;
  InNo.Text := Trim(maxNo);
  CRTime.DateTime := SGetServerDate(ADOQueryTemp);
  InitGrid3();
end;

procedure TfrmYEYarnInEdit.ToolButton6Click(Sender: TObject);
var
  maxno, fsj: string;
begin
  try
    frmYEYarnWaitStorage := TfrmYEYarnWaitStorage.Create(Application);
    with frmYEYarnWaitStorage do
    begin
      if ShowModal = 1 then
      begin
        CDS_OrderSel.DisableControls;
        with CDS_OrderSel do
        begin
          First;
          while not Eof do
          begin
            if FieldByName('SSel').Value = True then
            begin
              if Self.CDS_2.Locate('MainId', Trim(CDS_OrderSel.fieldbyname('MainId').AsString), []) = False then
              begin
                with Self.CDS_2 do
                begin
                  Append;
                  FieldByName('MainId').Value := Trim(CDS_OrderSel.fieldbyname('MainId').AsString);
                  FieldByName('YE_Code').Value := Trim(CDS_OrderSel.fieldbyname('YE_Code').AsString);
                  FieldByName('YE_Name').Value := Trim(CDS_OrderSel.fieldbyname('YE_Name').AsString);
                  FieldByName('Y_Spec').Value := Trim(CDS_OrderSel.fieldbyname('Y_Spec').AsString);
                  FieldByName('Y_Color').Value := CDS_OrderSel.fieldbyname('Y_Color').Value;
                  FieldByName('OrderNo').Value := CDS_OrderSel.fieldbyname('OrderNo').Value;
                  FieldByName('FtyName').Value := Trim(CDS_OrderSel.fieldbyname('FtyName').AsString);
                  FieldByName('BatchNo').Value := Trim(CDS_OrderSel.fieldbyname('BatchNo').AsString);
                  FieldByName('YarnTubeType').Value := Trim(CDS_OrderSel.fieldbyname('YarnTubeType').AsString);
                  FieldByName('Y_Name').Value := Trim(CDS_OrderSel.fieldbyname('Y_Name').AsString);
                  FieldByName('Y_Code').Value := Trim(CDS_OrderSel.fieldbyname('Y_Code').AsString);
                  FieldByName('YarnTubeWeight').Value := Trim(CDS_OrderSel.fieldbyname('YarnTubeWeight').AsString);
                  FieldByName('PaperBoxWeight').Value := Trim(CDS_OrderSel.fieldbyname('PaperBoxWeight').AsString);
                  FieldByName('BoxCount').Value := Trim(CDS_OrderSel.fieldbyname('BoxCount').AsString);
                  FieldByName('YarnRackCount').Value := Trim(CDS_OrderSel.fieldbyname('YarnRackCount').AsString);
                  FieldByName('ZPPS').Value := Trim(CDS_OrderSel.fieldbyname('ZPPS').AsString);
                  FieldByName('ZPKGQty').Value := Trim(CDS_OrderSel.fieldbyname('ZPKGQty').AsString);
                  Post;
                end;
              end;
            end;
            Next;
          end;
        end;
        CDS_OrderSel.EnableControls;
      end;
    end;
  finally
    frmYEYarnWaitStorage.Free;
  end;

  FMainId := '';
  CDS_2.DisableControls;
  with CDS_2 do
  begin
    First;
    while not Eof do
    begin
      FMainId := FMainId + Quotedstr(Trim(CDS_2.FieldByName('MainId').AsString)) + ',';
      Next;
    end;
  end;
  FMainId := copy(FMainId, 1, Length(FMainId) - 1);
  CDS_2.EnableControls;

  if Trim(InNo.Text) = '' then
    btnGetOutNo.Click;

  InitGrid1();
  InitGrid3();
end;

procedure TfrmYEYarnInEdit.ToolButton7Click(Sender: TObject);
begin
  tv1.Controller.EditingController.ShowEdit();
  tv3.Controller.EditingController.ShowEdit();
  Close;
end;

procedure TfrmYEYarnInEdit.ToolButton8Click(Sender: TObject);
begin
  WriteCxGrid(self.caption + 'Tv2', Tv2, '加弹纱线仓库');
  WriteCxGrid(self.caption + 'Tv1', Tv1, '加弹纱线仓库');
  WriteCxGrid(self.caption + 'Tv3', Tv3, '加弹纱线仓库');
end;

procedure TfrmYEYarnInEdit.ToolButton9Click(Sender: TObject);
begin
  SelOKNo(CDS_1, True);

end;

end.