unit U_OrdeFollower_inputCK;

interface

uses
  Windows, Messages, strUtils, SysUtils, cxTextEdit, Variants, Classes, Graphics,
  Controls, Forms, Dialogs, cxStyles, cxCustomData, cxGraphics, cxFilter, cxData,
  cxDataStorage, cxEdit, DB, cxDBData, cxGridLevel, cxGridCustomTableView,
  cxGridTableView, cxGridDBTableView, cxClasses, cxControls, cxGridCustomView,
  cxGrid, cxMemo, cxRichEdit, ComCtrls, cxContainer, cxMaskEdit, cxButtonEdit,
  StdCtrls, ToolWin, DBClient, ADODB, ExtCtrls, BtnEdit, cxDropDownEdit,
  cxGridCustomPopupMenu, cxGridPopupMenu, cxLookAndFeels, cxLookAndFeelPainters,
  cxNavigator, dxSkinsCore, dxSkinBlack, dxSkinBlue, dxSkinBlueprint,
  dxSkinCaramel, dxSkinCoffee, dxSkinDarkRoom, dxSkinDarkSide,
  dxSkinDevExpressDarkStyle, dxSkinDevExpressStyle, dxSkinFoggy,
  dxSkinGlassOceans, dxSkinHighContrast, dxSkiniMaginary, dxSkinLilian,
  dxSkinLiquidSky, dxSkinLondonLiquidSky, dxSkinMcSkin, dxSkinMetropolis,
  dxSkinMetropolisDark, dxSkinMoneyTwins, dxSkinOffice2007Black,
  dxSkinOffice2007Blue, dxSkinOffice2007Green, dxSkinOffice2007Pink,
  dxSkinOffice2007Silver, dxSkinOffice2010Black, dxSkinOffice2010Blue,
  dxSkinOffice2010Silver, dxSkinOffice2013DarkGray, dxSkinOffice2013LightGray,
  dxSkinOffice2013White, dxSkinPumpkin, dxSkinSeven, dxSkinSevenClassic,
  dxSkinSharp, dxSkinSharpPlus, dxSkinSilver, dxSkinSpringTime, dxSkinStardust,
  dxSkinSummer2008, dxSkinTheAsphaltWorld, dxSkinsDefaultPainters,
  dxSkinValentine, dxSkinVS2010, dxSkinWhiteprint, dxSkinXmas2008Blue,
  dxSkinscxPCPainter, cxCalendar;

type
  TfrmOrdeFollower_inputCK = class(TForm)
    ToolBar2: TToolBar;
    ToolButton1: TToolButton;
    ToolButton2: TToolButton;
    cxGrid1: TcxGrid;
    Tv1: TcxGridDBTableView;
    v1PRTSpec: TcxGridDBColumn;
    v1PRTColor: TcxGridDBColumn;
    cxGrid1Level1: TcxGridLevel;
    v1PRTKZ: TcxGridDBColumn;
    v1ClothUnit: TcxGridDBColumn;
    ADOTemp: TADOQuery;
    ADOCmd: TADOQuery;
    DataSource1: TDataSource;
    Order_Sub: TClientDataSet;
    DataSource2: TDataSource;
    ADOZDY: TADOQuery;
    CDS_ZDY: TClientDataSet;
    ADOQueryTmp: TADOQuery;
    v1Column1: TcxGridDBColumn;
    v1Column2: TcxGridDBColumn;
    v1Column3: TcxGridDBColumn;
    v1Column4: TcxGridDBColumn;
    v1Column5: TcxGridDBColumn;
    v1Qty2: TcxGridDBColumn;
    Panel1: TPanel;
    Label22: TLabel;
    Label23: TLabel;
    cxGridPopupMenu1: TcxGridPopupMenu;
    TBSave: TToolButton;
    TBClose: TToolButton;
    ToolButton3: TToolButton;
    Tv1Column2: TcxGridDBColumn;
    Tv1Column4: TcxGridDBColumn;
    Tv1Column5: TcxGridDBColumn;
    Tv1Column6: TcxGridDBColumn;
    Tv1Column7: TcxGridDBColumn;
    Tv1Column8: TcxGridDBColumn;
    Tv1Column10: TcxGridDBColumn;
    Tv1Column3: TcxGridDBColumn;
    Tv1Column1: TcxGridDBColumn;
    procedure TBCloseClick(Sender: TObject);
    procedure TVZDYCellDblClick(Sender: TcxCustomGridTableView; ACellViewInfo: TcxGridTableDataCellViewInfo; AButton: TMouseButton; AShift: TShiftState; var AHandled: Boolean);
    procedure Button1Click(Sender: TObject);
    procedure TVZDYKeyPress(Sender: TObject; var Key: Char);
    procedure FormShow(Sender: TObject);
    procedure TBSaveClick(Sender: TObject);
    procedure v1OrderUnitPropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
    procedure v1PRTUnitPropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
    procedure v1PRTColorPropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
    procedure ToolButton2Click(Sender: TObject);
    procedure FactoryNoNamePropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
    procedure v1Column1PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
    procedure v1PRTMFPropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
    procedure v1OrderQtyPropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
    procedure v1ClothQtyPropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
    procedure v1Column2PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
    procedure FactoryNoNamePropertiesChange(Sender: TObject);
    procedure CompanyNamePropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
    procedure JHPlacePropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
    procedure v1Column1PropertiesEditValueChanged(Sender: TObject);
    procedure fromConNoKeyPress(Sender: TObject; var Key: Char);
    procedure v1ClothUnitPropertiesEditValueChanged(Sender: TObject);
    procedure fromConNoPropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
    procedure v1Column6PropertiesEditValueChanged(Sender: TObject);
    procedure ToolButton1Click(Sender: TObject);
    procedure v1C_ColorPropertiesEditValueChanged(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure Tv1Column1PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
    procedure ToolButton3Click(Sender: TObject);
    procedure Tv1Column8PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
    procedure Tv1Column5PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
    procedure Tv1Column2PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
  private
    FXS: Integer;
    procedure InitData();
    procedure ZDYHelp(FButn: TcxButtonEdit; LType: string);
    function SaveData(): Boolean;
    function SaveDataCK(): Boolean;
    function YFData(fMainID, FsubID: string): Boolean;
    procedure DoQuery(fkeyNo: string);
    procedure DoKc();
    { Private declarations }
  public
    PState: Integer;
    FMainId, FConType: string;

    { Public declarations }
  end;

var
  frmOrdeFollower_inputCK: TfrmOrdeFollower_inputCK;

implementation

uses
  U_DataLink, U_ZDYHelp, U_Fun, U_ZdyAttachGYS, U_ClothContractList_help,
  U_ClothContractList_CGSel, U_ClothContractList_TpSel, U_ZdyAttachCP;

{$R *.dfm}
procedure TfrmOrdeFollower_inputCK.DoKc();
begin
  {Label22.Caption := '匹数：0';
  Label23.Caption := '数量：0';
  if Order_Sub.IsEmpty then
    exit;
  if trim(Order_Sub.fieldbyname('C_CodeName').AsString) = '' then
    exit;
  IF  trim(Order_Sub.fieldbyname('C_Color').AsString)='' then exit;
  if trim(FactoryNoName.Text) = '' then
//    exit;
  with ADOTemp do
  begin
    close;
    sql.Clear;
    sql.Add('exec P_Get_Contract');
    sql.Add('@begdate=''' + Trim(Order_Sub.fieldbyname('C_CodeName').AsString) + ''' ');
    sql.Add(',@enddate=''' + trim(FactoryNoName.Text) + ''' ');
    sql.Add(',@conType=''查询库存'' ');
    sql.Add(',@status=''' + inttostr(1) + '''  ');
    open;
  end;
  if not ADOTemp.IsEmpty then
  begin
    Label22.Caption := '匹数：' + trim(ADOTemp.fieldbyname('N_PS').AsString);
    Label23.Caption := '数量：' + trim(ADOTemp.fieldbyname('N_Qty').AsString);
  end; }
end;

procedure TfrmOrdeFollower_inputCK.DoQuery(fkeyNo: string);
begin
 { with ADOTemp do
  begin
    close;
    sql.Clear;
    sql.Add('select * from Contract_Main ');
    sql.Add('where conNo=' + quotedstr(trim(fkeyNo)));
    open;
    if not IsEmpty then
    begin
      FactoryNoName.Text := fieldbyname('FactoryNoName').AsString;
      LXPerson.Text := fieldbyname('LXPerson').AsString;
      LXPerson.Text := fieldbyname('LXPerson').AsString;
      LXTel.Text := fieldbyname('LXPerson').AsString;
      fromConNo.Hint := fieldbyname('mainID').AsString;
    end
    else
    begin
      application.MessageBox('此采购计划单号错误！', '提示信息', 0);
      exit;
    end;
  end;

  with ADOTemp do
  begin
    close;
    sql.Clear;
    sql.Add('select * ');
    sql.Add('from Contract_Main A');
    sql.Add('inner join  Contract_sub B on B.MainID=A.mainID ');
    sql.Add('where A.conNo=' + quotedstr(trim(fkeyNo)));
    open;
    if not IsEmpty then
    begin
      SCreateCDS20(ADOTemp, Order_Sub);
      SInitCDSData20(ADOTemp, Order_Sub);
    end
    else
    begin
    end;
  end;
  with Order_Sub do
  begin
    DisableControls;
    First;
    while not eof do
    begin
      edit;
      fieldbyname('fromMainID').Value := fieldbyname('MainID').AsString;
      fieldbyname('fromsubID').Value := fieldbyname('subID').AsString;
      fieldbyname('MainID').Value := '';
      fieldbyname('subID').Value := '';
      post;
      next;
    end;
    First;
    EnableControls;
  end;
     }
end;

function TfrmOrdeFollower_inputCK.YFData(fMainID, FsubID: string): Boolean;
var
  CRID, OrdMainId, YFID, FComTaiTou, FCRID, FFactoryName: string;
begin
{  Result := False;
  try
    with ADOQueryTmp do
    begin
      Close;
      SQL.Clear;
      sql.Add('select * from YF_Money_KC where FactoryName=''' + Trim(FactoryNoName.Text) + '''');
      Open;
    end;
    if not ADOQueryTmp.IsEmpty then
    begin
      CRID := ADOQueryTmp.fieldbyname('CRID').AsString;
    end
    else
    begin
      with ADOCmd do
      begin
        Close;
        sql.Clear;
        sql.Add('Update YF_Money_CRID set CRID=CRID+1');
        sql.Add('select * from YF_Money_CRID ');
        Open;
      end;
      CRID := ADOCmd.fieldbyname('CRID').AsString;
      with ADOCmd do
      begin
        Close;
        SQL.Clear;
        sql.Add('select * from YF_Money_KC ');
        sql.add('where CRID=' + quotedstr(trim(CRID)));
        Open;
      end;
      with ADOCmd do
      begin
        Append;
        FieldByName('CRID').Value := StrToInt(CRID);
        FieldByName('FactoryName').Value := Trim(FactoryNoName.Text);
        FieldByName('ZdyStr1').Value := '应付付';
        Post;
      end;
    end;

    with ADOQueryTmp do
    begin
      Close;
      sql.Clear;
      sql.Add('select * from YF_Money_CR where mainID=''' + Trim(fMainID) + '''');
      sql.Add('and subID=''' + Trim(FsubID) + '''');
      sql.Add('and YFName=''坯布费用'' ');
      Open;
    end;
    if ADOQueryTmp.IsEmpty then
    begin
      if GetLSNo(ADOCmd, YFID, 'YF', 'YF_Money_CR', 3, 1) = False then
      begin
        Application.MessageBox('取坯布应付最大号失败!', '提示', 0);
        Exit;
      end;
    end
    else
    begin
      YFID := Trim(ADOQueryTmp.fieldbyname('YFID').AsString);
    end;
    with ADOCmd do
    begin
      Close;
      sql.Clear;
      sql.Add('select * from YF_Money_CR where YFID=''' + Trim(YFID) + '''');
      Open;
    end;
    with ADOCmd do
    begin
      if ADOQueryTmp.IsEmpty then
        Append
      else
        Edit;
      FieldByName('YFID').Value := Trim(YFID);
      FieldByName('YFTypeId').Value := Trim(ConNo.Text);
      FieldByName('CRID').Value := StrToInt(CRID);
      FieldByName('Filler').Value := Trim(DName);
      FieldByName('CRType').Value := '应付款登记';
      FieldByName('CRFlag').Value := '应付付';
      FieldByName('QtyFlag').Value := 1;
      FieldByName('FactoryName').Value := Trim(FactoryNoName.Text);
      FieldByName('CRTime').Value := formatDateTime('yyyy-MM-dd', DeliveryDate.Date);
      FieldByName('Qty').Value := Order_Sub.fieldbyname('C_Qty').Value;
      FieldByName('PS').Value := Order_Sub.fieldbyname('Qty1').Value;
      FieldByName('T_Qty').Value := Order_Sub.fieldbyname('T_Qty').Value;
      FieldByName('YFType').Value := '自动生成';
      FieldByName('Price').Value := Order_Sub.fieldbyname('Price').asfloat;
      FieldByName('HuiLv').Value := 1;
      FieldByName('BZType').Value := '人民币';
      FieldByName('ComTaiTou').Value := Trim(FComTaiTou);
      FieldByName('QtyUnit').Value := Trim(Order_Sub.fieldbyname('C_Unit').AsString);
      FieldByName('YFName').Value := '坯布费用';
      FieldByName('MainId').Value := Trim(fMainID);
      FieldByName('subID').Value := Trim(FsubID);
      Post;
    end;

    with ADOCmd do
    begin
      Close;
      sql.Clear;
      sql.Add('Update YF_Money_CR Set Money=Price*Qty,BBMoney=Price*Qty,T_money=Price*T_Qty ');
      sql.Add(' where YFID=''' + Trim(YFID) + '''');
      ExecSQL;
    end;
    with ADOCmd do
    begin
      Close;
      sql.Clear;
      sql.Add(' Update YF_Money_KC Set KCMoney=(select isnull(Sum(Money*QtyFlag),0) from YF_Money_CR A where A.CRID=YF_Money_KC.CRID)');
      sql.Add(',KCBBMoney=(select isnull(Sum(BBMoney*QtyFlag),0) from YF_Money_CR A where A.CRID=YF_Money_KC.CRID)');
      sql.Add(' where CRID=' + CRID);
      ExecSQL;
    end;
    Result := True;
  except
  end;  }
end;

procedure TfrmOrdeFollower_inputCK.TBCloseClick(Sender: TObject);
begin
  WriteCxGrid(self.Caption, Tv1, '坯布投坯');
  Close;
end;

procedure TfrmOrdeFollower_inputCK.InitData();
begin
//  with ADOQueryTmp do
//  begin
//    Close;
//    SQL.Clear;
//    sql.Add('select * ');
//    sql.Add('from Contract_Main A');
//    sql.Add('where  A.mainID= ''' + Trim(fMainID) + ''' ');
//    Open;
//    if not ADOQueryTmp.IsEmpty then
//    begin
//      SCSHData(ADOQueryTmp, ScrollBox1, 0);
//    end;
//  end;

  with ADOQueryTmp do
  begin
    Close;
    SQL.Clear;
    sql.Add('select *,Gf=(select factoryNoName from Contract_Main X where X.mainID=A.frommainID), ');
    sql.Add('fdhNO=(select conNo from Contract_Main X where X.mainID=A.frommainID) ');
    sql.Add('from  Contract_sub A inner join Contract_Main B on A.mainid=B.mainid ');
    sql.Add('where  A.mainID= ''' + Trim(fMainID) + ''' ');
    Open;
    SCreateCDS20(ADOQueryTmp, Order_Sub);
    SInitCDSData20(ADOQueryTmp, Order_Sub);

  end;

  if PState = 0 then
  begin
    with ADOTemp do
    begin
      Close;
      SQL.Clear;
      sql.Add('select Top 1* from Contract_Main order by FillTime desc ');
      Open;
    end;
//    QDTime.DateTime := SGetServerDate(ADOTemp);
//    DeliveryDate.DateTime := SGetServerDate(ADOTemp);
//    QDTime.Checked := True;
//    DeliveryDate.Checked := False;
//    ConNo.Text := '自动生成';
  end;
//  PanZDY.Visible := False;
end;

procedure TfrmOrdeFollower_inputCK.ZDYHelp(FButn: TcxButtonEdit; LType: string);
var
  FType, ZDYName, FText: string;
begin
//  PanZDY.Visible := True;
//  PanZDY.Left := FButn.Left;
//  PanZDY.Top := FButn.Top + FButn.Height;
  with ADOZDY do
  begin
    Filtered := False;
    Close;
    SQL.Clear;
    SQL.Add('select RTrim(ZDYNo) ZDYNo,RTrim(ZDYName) ZDYName from KH_ZDY where Type=''' + Trim(LType) + '''');
    Open;
  end;
  FText := Trim(FButn.Text);
  if FText <> '' then
    SDofilter(ADOZDY, ' ZDYName like ' + QuotedStr('%' + Trim(FText) + '%'))
  else
    SDofilter(ADOZDY, '');
//  VHelpZDYName.Summary.GroupFormat := Trim(FButn.Name);
end;

procedure TfrmOrdeFollower_inputCK.TVZDYCellDblClick(Sender: TcxCustomGridTableView; ACellViewInfo: TcxGridTableDataCellViewInfo; AButton: TMouseButton; AShift: TShiftState; var AHandled: Boolean);
var
  FName: string;
begin
  if ADOZDY.IsEmpty then
    Exit;
//  FName := Trim(VHelpZDYName.Summary.GroupFormat);
  TcxButtonEdit(FindComponent(FName)).Text := Trim(ADOZDY.fieldbyname('ZDYName').AsString);
  TcxButtonEdit(FindComponent(FName)).Hint := Trim(ADOZDY.fieldbyname('ZDYNO').AsString);
//  PanZDY.Visible := False;
end;

procedure TfrmOrdeFollower_inputCK.Button1Click(Sender: TObject);
begin
//  PanZDY.Visible := False;
end;

procedure TfrmOrdeFollower_inputCK.TVZDYKeyPress(Sender: TObject; var Key: Char);
begin
//  if Key = #13 then
//  begin
//    if ADOZDY.IsEmpty then
//      Exit;
//    TcxButtonEdit(FindComponent(VHelpZDYName.Summary.GroupFormat)).Text := Trim(ADOZDY.fieldbyname('ZDYName').AsString);
//    TcxButtonEdit(FindComponent(VHelpZDYName.Summary.GroupFormat)).Hint := Trim(ADOZDY.fieldbyname('ZDYNO').AsString);
//    PanZDY.Visible := False;
//    ADOZDY.Active := False;
//  end;
end;

procedure TfrmOrdeFollower_inputCK.FormShow(Sender: TObject);
begin
 { if Trim(DParameters1)='1' then
  begin
    v1Price.Visible:=False;
    v1ClothQty.Visible:=False;
    v1PRTQty.Visible:=False;
  end else
  begin
    v1Price.Visible:=True;
    v1ClothQty.Visible:=True;
    v1PRTQty.Visible:=True;
  end;  }
//  readCXgrid(self.Caption, tv1);
  ReadCxGrid(self.Caption, Tv1, '坯布投坯');
  InitData();
end;

function TfrmOrdeFollower_inputCK.SaveDataCK(): Boolean;
var
  maxno, conmaxno: string;
begin
  try
    ADOCmd.Connection.BeginTrans;
    ///保存主表
    with ADOCmd do
    begin
      Close;
      sql.Clear;
      SQL.Add('select * from Contract_Main where MainId=''' + Trim(fMainID) + '''');
      Open;
    end;
    with ADOCmd do
    begin

      if Trim(fMainID) = '' then
      begin
        Append;
        if GetLSNo(ADOTemp, conmaxno, 'T', 'Contract_Main', 3, 1) = False then
        begin
          ADOCmd.Connection.RollbackTrans;
          Application.MessageBox('生成流水号异常！', '提示', 0);
          exit;
        end;
//          conNo.Text := trim(maxno);
        if GetLSNo(ADOTemp, maxno, 'CM', 'Contract_Main', 3, 1) = False then
        begin
          ADOCmd.Connection.RollbackTrans;
          Application.MessageBox('生成流水号异常！', '提示', 0);
          exit;
        end;
      end
      else
      begin
        maxno := Trim(fMainID);
        Edit;
      end;

      FieldByName('MainId').Value := Trim(maxno);

      if Trim(fMainID) = '' then
      begin
        FieldByName('Filler').Value := Trim(DName);
        FieldByName('conNo').Value := trim(conmaxno);
      end
      else
      begin
        FieldByName('Editer').Value := Trim(DName);
        FieldByName('EditTime').Value := SGetServerDateTime(ADOTemp);
      end;
      FieldByName('ConType').Value := '坯布投坯';
      FieldByName('GXnote1').Value := '电脑端';
      FieldByName('BatchNo').Value := Order_Sub.fieldbyname('BatchNo').AsString;
//      FieldByName('conNo').Value := trim(conmaxno);
      FieldByName('status').Value := '0';
      FieldByName('fromconNo').Value := Order_Sub.fieldbyname('fromconNo').AsString;
      FieldByName('fromMainID').Value := Order_Sub.fieldbyname('fromMainID').AsString;
      FieldByName('JHPlace').Value := Order_Sub.fieldbyname('JHPlace').AsString;
      FieldByName('QDTime').Value := SGetServerDateTime(ADOTemp);
      FieldByName('DeliveryDate').Value := Order_Sub.fieldbyname('DeliveryDate').AsString;
      FieldByName('FactoryNoName').Value := Order_Sub.fieldbyname('FactoryNoName').AsString;
      FieldByName('ToFactoryName').Value := Order_Sub.fieldbyname('ToFactoryName').AsString;
      Post;
    end;
    fMainID := Trim(maxno);
    ///保存子表
    with Order_Sub do
    begin
      First;
      while not Eof do
      begin
        if Trim(Order_Sub.fieldbyname('C_Unit').AsString) = 'Kg' then
        begin
        end;
        if Trim(Order_Sub.fieldbyname('SubId').AsString) = '' then
        begin
          if GetLSNo(ADOTemp, maxno, 'CS', 'Contract_Sub', 3, 1) = False then
          begin
            ADOCmd.Connection.RollbackTrans;
            Application.MessageBox('取子流水号失败！', '提示', 0);
            Exit;
          end;
        end
        else
        begin
          maxno := Trim(Order_Sub.fieldbyname('SubId').AsString);
        end;
        with ADOCmd do
        begin
          Close;
          SQL.Clear;
          sql.Add('select * from Contract_Sub where MainId=''' + Trim(fMainID) + '''');
          sql.Add(' and SubId=''' + Trim(maxno) + '''');
          Open;
        end;
        with ADOCmd do
        begin
          if Trim(Order_Sub.fieldbyname('SubId').AsString) = '' then
            Append
          else
            Edit;
          FieldByName('MainId').Value := Trim(fMainID);
          FieldByName('SubId').Value := Trim(maxno);
//          FieldByName('ConNo').Value := Trim(ConNo.Text);
          FieldByName('conNo').Value := trim(conmaxno);
          RTSetSaveDataCDS(ADOCmd, Tv1, Order_Sub, 'Contract_Sub', 1);
          FieldByName('C_Codename').Value := Trim(Order_Sub.fieldbyname('C_Codename').AsString);
          FieldByName('MFqty').Value := StrToFloatdef((Order_Sub.fieldbyname('MFqty').AsString), 0);
          FieldByName('KZqty').Value := StrToFloatdef((Order_Sub.fieldbyname('KZqty').AsString), 0);
          FieldByName('fromMainID').Value := Trim(Order_Sub.fieldbyname('fromMainID').AsString);
          FieldByName('fromsubID').Value := Trim(Order_Sub.fieldbyname('fromsubID').AsString);
          FieldByName('KCsubid').Value := Trim(Order_Sub.fieldbyname('KCsubid').AsString);
          FieldByName('KCMainID').Value := Trim(Order_Sub.fieldbyname('KCMainID').AsString);
          FieldByName('C_Status').Value := '0';
          FieldByName('Qty2').Value := Order_Sub.fieldbyname('Qty2').AsFloat;          
          FieldByName('Qty1').Value := Order_Sub.fieldbyname('Qty1').AsFloat;
          FieldByName('C_Qty').Value := Order_Sub.fieldbyname('C_Qty').AsFloat;
          if Trim(Order_Sub.fieldbyname('C_Qty').AsString) = '' then
          begin
            FieldByName('C_Qty').Value := 0;
          end;

          if Trim(Order_Sub.fieldbyname('Price').AsString) = '' then
          begin
            FieldByName('Price').Value := 0;
          end;

          Post;
        end;
        Order_Sub.Edit;
        Order_Sub.FieldByName('SubId').Value := Trim(maxno);

        Next;
      end;
    end;
    ADOCmd.Connection.CommitTrans;
    Result := True;
  except
    Result := False;
    ADOCmd.Connection.RollbackTrans;
    Application.MessageBox('保存失败！', '提示', 0);
  end;
end;

function TfrmOrdeFollower_inputCK.SaveData(): Boolean;
var
  maxno, conmaxno: string;
begin
  try
    ADOCmd.Connection.BeginTrans;
    ///保存主表
    with ADOCmd do
    begin
      Close;
      sql.Clear;
      SQL.Add('select * from Contract_Main where MainId=''' + Trim(fMainID) + '''');
      Open;
    end;
    with ADOCmd do
    begin

      if Trim(fMainID) = '' then
      begin
        Append;
        if GetLSNo(ADOTemp, conmaxno, '', 'Contract_Main', 3, 1) = False then
        begin
          ADOCmd.Connection.RollbackTrans;
          Application.MessageBox('生成流水号异常！', '提示', 0);
          exit;
        end;
//          conNo.Text := trim(maxno);
        if GetLSNo(ADOTemp, maxno, 'CM', 'Contract_Main', 3, 1) = False then
        begin
          ADOCmd.Connection.RollbackTrans;
          Application.MessageBox('生成流水号异常！', '提示', 0);
          exit;
        end;
      end
      else
      begin
        maxno := Trim(fMainID);
        Edit;
      end;

      FieldByName('MainId').Value := Trim(maxno);
//      SSetsaveSql(ADOCmd, 'Contract_Main', ScrollBox1, 0);
//      FieldByName('LXPerson').Value := Trim(LXPerson.Text);
//      FieldByName('LXTel').Value := Trim(LXTel.Text);
      if Trim(fMainID) = '' then
      begin
        FieldByName('Filler').Value := Trim(DName);
      end
      else
      begin
        FieldByName('Editer').Value := Trim(DName);
        FieldByName('EditTime').Value := SGetServerDateTime(ADOTemp);
      end;
      FieldByName('ConType').Value := '坯布到货';
      FieldByName('BatchNo').Value := Order_Sub.fieldbyname('BatchNo').AsString;
      FieldByName('conNo').Value := trim(conmaxno);
      FieldByName('status').Value := '0';
      FieldByName('fromconNo').Value := Order_Sub.fieldbyname('fromconNo').AsString;
      FieldByName('fromMainID').Value := Order_Sub.fieldbyname('fromMainID').AsString;
      FieldByName('JHPlace').Value := Order_Sub.fieldbyname('JHPlace').AsString;
      FieldByName('QDTime').Value := SGetServerDateTime(ADOTemp);
      FieldByName('DeliveryDate').Value := Order_Sub.fieldbyname('DeliveryDate').AsString;
      FieldByName('FactoryNoName').Value := Order_Sub.fieldbyname('FactoryNoName').AsString;
//      FieldByName('JHPlace').Value := Order_Sub.fieldbyname('JHPlace').AsString;
      Post;
    end;
    fMainID := Trim(maxno);
    ///保存子表
    with Order_Sub do
    begin
      First;
      while not Eof do
      begin
        if Trim(Order_Sub.fieldbyname('C_Unit').AsString) = 'Kg' then
        begin
        end;
        if Trim(Order_Sub.fieldbyname('SubId').AsString) = '' then
        begin
          if GetLSNo(ADOTemp, maxno, 'CS', 'Contract_Sub', 3, 1) = False then
          begin
            ADOCmd.Connection.RollbackTrans;
            Application.MessageBox('取子流水号失败！', '提示', 0);
            Exit;
          end;
        end
        else
        begin
          maxno := Trim(Order_Sub.fieldbyname('SubId').AsString);
        end;
        with ADOCmd do
        begin
          Close;
          SQL.Clear;
          sql.Add('select * from Contract_Sub where MainId=''' + Trim(fMainID) + '''');
          sql.Add(' and SubId=''' + Trim(maxno) + '''');
          Open;
        end;
        with ADOCmd do
        begin
          if Trim(Order_Sub.fieldbyname('SubId').AsString) = '' then
            Append
          else
            Edit;
          FieldByName('MainId').Value := Trim(fMainID);
          FieldByName('SubId').Value := Trim(maxno);
//          FieldByName('ConNo').Value := Trim(ConNo.Text);
          FieldByName('conNo').Value := trim(conmaxno);
          FieldByName('C_Codename').Value := Trim(Order_Sub.fieldbyname('C_Codename').AsString);
          FieldByName('MFqty').Value := Trim(Order_Sub.fieldbyname('MFqty').AsString);
          FieldByName('KZqty').Value := Trim(Order_Sub.fieldbyname('KZqty').AsString);
          FieldByName('fromMainID').Value := Trim(Order_Sub.fieldbyname('fromMainID').AsString);
          FieldByName('fromsubID').Value := Trim(Order_Sub.fieldbyname('fromsubID').AsString);
          FieldByName('C_Status').Value := '0';
          FieldByName('Qty2').Value := Order_Sub.fieldbyname('Qty2').AsFloat;
          FieldByName('Qty1').Value := Order_Sub.fieldbyname('Qty1').AsFloat;
          FieldByName('C_Qty').Value := Order_Sub.fieldbyname('C_Qty').AsFloat;
          if Trim(Order_Sub.fieldbyname('C_Qty').AsString) = '' then
          begin
            FieldByName('C_Qty').Value := 0;
          end;

          if Trim(Order_Sub.fieldbyname('Price').AsString) = '' then
          begin
            FieldByName('Price').Value := 0;
          end;
//          RTSetSaveDataCDS(ADOCmd, Tv1, Order_Sub, 'Contract_Sub', 0);
          Post;
        end;
        Order_Sub.Edit;
        Order_Sub.FieldByName('SubId').Value := Trim(maxno);
    //Order_Sub.Post;
        Next;
      end;
    end;
    ADOCmd.Connection.CommitTrans;
    Result := True;
  except
    Result := False;
    ADOCmd.Connection.RollbackTrans;
    Application.MessageBox('保存失败！', '提示', 0);
  end;
end;

procedure TfrmOrdeFollower_inputCK.TBSaveClick(Sender: TObject);
begin
  if Order_Sub.IsEmpty then
  begin
    Application.MessageBox('明细不能为空！', '提示', 0);
    exit;
  end;

  if Order_Sub.Locate('FactoryNoName', null, []) = True then
  begin
    Application.MessageBox('供方不能为空!', '提示', 0);
    Exit;
  end;
  if Order_Sub.Locate('C_CodeName', '', []) = True then
  begin
    Application.MessageBox('品名不能为空!', '提示', 0);
    Exit;
  end;
//  if Order_Sub.Locate('ConNo', null, []) = True then
//  begin
//    Application.MessageBox('合同不能为空!', '提示', 0);
//    Exit;
//  end;
//  if Order_Sub.Locate('C_Color', '', []) = True then
//  begin
//    Application.MessageBox('颜色不能为空!', '提示', 0);
//    Exit;
//  end;
//  if Order_Sub.Locate('C_Unit', null, []) then
//  begin
//    Application.MessageBox('数量单位不能为空!', '提示', 0);
//    Exit;
//  end;
//  with ADOTemp do
//  begin
//    close;
//    sql.Clear;
//    sql.Add('select *  from KH_Zdy_Attachment A  where Type=''GYS''');
//    sql.Add('and  zdyName=''' + trim(FactoryNoName.text) + ''' ');
//    open;
//  end;
//  if ADOTemp.IsEmpty then
//  begin
//    application.MessageBox('加工厂不存在！', '提示信息', 0);
//    exit;
//  end;

  if SaveData() then
  begin
    Application.MessageBox('保存成功！', '提示', 0);
//    ConNo.Text := '';
//    FactoryNoName.Text := '';
//    CompanyName.Text := '';
//    LXPerson.Text := '';
//    LXTel.Text := '';
//    JHPlace.Text := '';
    Order_Sub.EmptyDataSet;
    PState := 0;
    fMainID := '';
//    ConNo.Text := '自动生成';
  end;
end;

procedure TfrmOrdeFollower_inputCK.v1OrderUnitPropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
begin
  try
    frmZDYHelp := TfrmZDYHelp.Create(Application);
    with frmZDYHelp do
    begin
      flag := 'OrdUnit';
      flagname := '单位';
      if ShowModal = 1 then
      begin
        Self.Order_Sub.Edit;
        Self.Order_Sub.FieldByName('OrderUnit').Value := Trim(ClientDataSet1.fieldbyname('ZDYName').AsString);
      end;
    end;
  finally
    frmZDYHelp.Free;
  end;
end;

procedure TfrmOrdeFollower_inputCK.v1PRTUnitPropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
begin
  try
    frmZDYHelp := TfrmZDYHelp.Create(Application);
    with frmZDYHelp do
    begin
      flag := 'OrdUnit';
      flagname := '单位';
      if ShowModal = 1 then
      begin
        Self.Order_Sub.Edit;
        Self.Order_Sub.FieldByName('PRTUnit').Value := Trim(ClientDataSet1.fieldbyname('ZDYName').AsString);
      end;
    end;
  finally
    frmZDYHelp.Free;
  end;
end;

procedure TfrmOrdeFollower_inputCK.v1PRTColorPropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
begin
  try
    frmZDYHelp := TfrmZDYHelp.Create(Application);
    with frmZDYHelp do
    begin
      flag := 'OrdColor';
      flagname := '颜色';
      if ShowModal = 1 then
      begin
        Self.Order_Sub.Edit;
        Self.Order_Sub.FieldByName('PRTColor').Value := Trim(ClientDataSet1.fieldbyname('ZDYName').AsString);
      end;
    end;
  finally
    frmZDYHelp.Free;
  end;
end;

procedure TfrmOrdeFollower_inputCK.ToolButton2Click(Sender: TObject);
begin
  if Order_Sub.IsEmpty then
    Exit;
  if Trim(Order_Sub.fieldbyname('SubId').AsString) <> '' then
  begin
    with ADOCmd do
    begin
      close;
      sql.Clear;
      sql.Add('select * from JYOrder_Sub_AnPai ');
      sql.Add('where subID=''' + Trim(Order_Sub.fieldbyname('subID').AsString) + '''');
      open;
    end;
    if not ADOCmd.IsEmpty then
    begin
      Application.MessageBox('已回仓，不能删除投坯计划！', '提示', 0);
      Exit;
    end;
    if Application.MessageBox('确定要删除数据吗？', '提示', 32 + 4) <> IDYES then
      Exit;
    with ADOCmd do
    begin
      Close;
      sql.Clear;
      sql.Add('delete Contract_Sub where SubId=''' + Trim(Order_Sub.fieldbyname('SubId').AsString) + '''');
      ExecSQL;
    end;
  end;
  Order_Sub.Delete;
end;

procedure TfrmOrdeFollower_inputCK.FactoryNoNamePropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
begin
  if Trim(fMainID) <> '' then
  begin
    with ADOTemp do
    begin
      Close;
      sql.Clear;
      sql.Add('select * from YF_Money_CR A where exists(');
      sql.Add('select * from Contract_Sub_MX B inner join Contract_Sub C on B.SubId=C.SubId ');
      sql.Add(' where C.Mainid=''' + Trim(fMainID) + '''');
      sql.Add(' and B.MXID=A.YFTypeId)');
      Open;
    end;
    if ADOTemp.IsEmpty = False then
    begin
      Application.MessageBox('已经产生应付款不能修改供应商!', '提示', 0);
      Exit;
    end;
  end;

//  try
//    frmZdyAttachGYS := TfrmZdyAttachGYS.Create(Application);
//    with frmZdyAttachGYS do
//    begin
//      if ShowModal = 1 then
//      begin
//        FactoryNoName.Text := Trim(CDS_HZ.fieldbyname('ZDYName').AsString);
//        FactoryNoName.Hint := Trim(CDS_HZ.fieldbyname('ZdyCode').AsString);
//        LXTel.Text := Trim(CDS_HZ.fieldbyname('DEFstr2').AsString);
//        LXPerson.Text := Trim(CDS_HZ.fieldbyname('DEFstr4').AsString);
//      end;
//    end;
//  finally
//    frmZdyAttachGYS.Free;
//  end;
end;

procedure TfrmOrdeFollower_inputCK.v1Column1PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
begin

 { try
    frmClothContractList_Help := TfrmClothContractList_Help.Create(Application);
    with frmClothContractList_Help do
    begin
//      ToolButton1.Visible := True;
      if ShowModal = 1 then
      begin
        frmClothContractList_Help.Order_Main.DisableControls;
        with frmClothContractList_Help.Order_Main do
        begin
          First;
          while frmClothContractList_Help.Order_Main.Locate('SSel', True, []) do
          begin
            with Self.Order_Sub do
            begin
              edit;
//              FieldByName('DeliveryDate').Value := Trim(FormatDateTime('yyyy-MM-dd', Now));
              FieldByName('KCMainID').Value := Trim(frmClothContractList_Help.Order_Main.fieldbyname('mainid').AsString);
              FieldByName('KCSubID').Value := Trim(frmClothContractList_Help.Order_Main.fieldbyname('SUbid').AsString);
//              FieldByName('fromConNo').Value := frmClothContractList_Help.Order_Main.fieldbyname('ConNo').Value;
//              FieldByName('FactoryNoName').Value := frmClothContractList_Help.Order_Main.fieldbyname('FactoryNoName').Value;
//              FieldByName('FactoryNo').Value := frmClothContractList_Help.Order_Main.fieldbyname('FactoryNo').Value;
              FieldByName('C_codename').Value := frmClothContractList_Help.Order_Main.fieldbyname('C_CodeName').Value;
//              FieldByName('C_color').Value := frmClothContractList_Help.Order_Main.fieldbyname('C_color').Value;
//              FieldByName('KZQty').Value := frmClothContractList_Help.Order_Main.fieldbyname('KZQty').Value;
//              FieldByName('MFQty').Value := frmClothContractList_Help.Order_Main.fieldbyname('MFQty').Value;
              fieldbyname('C_UNit').Value := 'M';
            end;
            frmClothContractList_Help.Order_Main.Delete;
          end;
        end;
        frmClothContractList_Help.Order_Main.EnableControls;

      end;
    end;
  finally
    frmClothContractList_Help.Free;
  end;  }


  try
    frmZdyAttachCP := TfrmZdyAttachCP.Create(Application);
    with frmZdyAttachCP do
    begin
      FType := '成品';
      if ShowModal = 1 then
      begin
        Self.Order_Sub.Edit;
//        Self.Order_Sub.FieldByName('C_Code').Value := Trim(CDS_HZ.fieldbyname('ZdyCode').AsString);
        Self.Order_Sub.FieldByName('CP_CodeName').Value := Trim(CDS_HZ.fieldbyname('ZDYName').AsString);
//        Self.Order_Sub.FieldByName('C_Color').Value := Trim(CDS_HZ.fieldbyname('DEFstr3').AsString);
    //    Self.Order_Sub.FieldByName('SOrddefstr4').Value:=Trim(ClientDataSet1.fieldbyname('Note').AsString);
        Self.Order_Sub.Post;

      end;
    end;
  finally
    frmZdyAttachCP.Free;
  end;
//  self.tv1.Controller.EditingController.ShowEdit();
//  DoKc();

end;

procedure TfrmOrdeFollower_inputCK.v1PRTMFPropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
begin
  try
    frmZDYHelp := TfrmZDYHelp.Create(Application);
    with frmZDYHelp do
    begin
      flag := 'KZ';
      flagname := '克重单位';
      if ShowModal = 1 then
      begin
        Self.Order_Sub.Edit;
        Self.Order_Sub.FieldByName('KZUnit').Value := Trim(ClientDataSet1.fieldbyname('ZDYName').AsString);
      end;
    end;
  finally
    frmZDYHelp.Free;
  end;
end;

procedure TfrmOrdeFollower_inputCK.v1OrderQtyPropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
begin
  try
    frmZDYHelp := TfrmZDYHelp.Create(Application);
    with frmZDYHelp do
    begin
      flag := 'MF';
      flagname := '门幅单位';
      if ShowModal = 1 then
      begin
        Self.Order_Sub.Edit;
        Self.Order_Sub.FieldByName('MFUnit').Value := Trim(ClientDataSet1.fieldbyname('ZDYName').AsString);
      end;
    end;
  finally
    frmZDYHelp.Free;
  end;
end;

procedure TfrmOrdeFollower_inputCK.v1ClothQtyPropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
begin
  try
    frmZDYHelp := TfrmZDYHelp.Create(Application);
    with frmZDYHelp do
    begin
      flag := 'PriceUnit';
      flagname := '计价单位';
      if ShowModal = 1 then
      begin
        Self.Order_Sub.Edit;
        Self.Order_Sub.FieldByName('PriceUnit').Value := Trim(ClientDataSet1.fieldbyname('ZDYName').AsString);
      end;
    end;
  finally
    frmZDYHelp.Free;
  end;
end;

procedure TfrmOrdeFollower_inputCK.v1Column2PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
begin
  try
    frmZDYHelp := TfrmZDYHelp.Create(Application);
    with frmZDYHelp do
    begin
      flag := 'OrderUnit';
      flagname := '单位';
      if ShowModal = 1 then
      begin
        Self.Order_Sub.Edit;
        Self.Order_Sub.FieldByName('C_Unit').Value := Trim(ClientDataSet1.fieldbyname('ZDYName').AsString);
      end;
    end;
  finally
    frmZDYHelp.Free;
  end;
end;

procedure TfrmOrdeFollower_inputCK.FactoryNoNamePropertiesChange(Sender: TObject);
begin
  {if FXS=99 then
  begin
    PanZDY.Visible:=False;
    FXS:=0;
    Exit;
  end;
  ZDYHelp(FactoryNoName,'FactoryNo1Name');  }
end;

procedure TfrmOrdeFollower_inputCK.CompanyNamePropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
begin
  try
    frmZDYHelp := TfrmZDYHelp.Create(Application);
    with frmZDYHelp do
    begin
      flag := 'OrdDefStr2';
      flagname := '需方';
      if ShowModal = 1 then
      begin
        FXS := 99;
//        CompanyName.Text := Trim(ClientDataSet1.fieldbyname('ZDYName').AsString);
      end;
    end;
  finally
    frmZDYHelp.Free;
  end;
end;

procedure TfrmOrdeFollower_inputCK.JHPlacePropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
begin
{try
    frmZdyAttachGYS:=TfrmZdyAttachGYS.Create(Application);
    with frmZdyAttachGYS do
    begin
      if ShowModal=1 then
      begin
        JHPlace.Text:=Trim(CDS_HZ.fieldbyname('ZDYName').AsString);
      //  FactoryNoName.Text:=Trim(CDS_HZ.fieldbyname('ZDYName').AsString);
     //   FactoryNoName.Hint:=Trim(CDS_HZ.fieldbyname('ZdyCode').AsString);
     //   LXTel.Text:=Trim(CDS_HZ.fieldbyname('DEFstr2').AsString);
      //  LXPerson.Text:=Trim(CDS_HZ.fieldbyname('DEFstr4').AsString);
      end;
    end;
  finally
    frmZdyAttachGYS.Free;
  end;
  }
end;

procedure TfrmOrdeFollower_inputCK.v1Column1PropertiesEditValueChanged(Sender: TObject);
var
  mvalue: string;
begin
  mvalue := TcxTextEdit(Sender).EditingText;

  if trim(mvalue) = '' then
    exit;

  if rightBstr(trim(mvalue), 1) <> '#' then
  begin
    mvalue := trim(mvalue) + '#';
  end;

  with Order_Sub do
  begin
    Edit;
    FieldByName('C_CodeName').Value := Trim(mvalue);
    Post;
  end;
  self.tv1.Controller.EditingController.ShowEdit();
  DoKc();
end;

procedure TfrmOrdeFollower_inputCK.fromConNoKeyPress(Sender: TObject; var Key: Char);
begin
  if Key = #13 then
  begin
//    DoQuery(fromConNo.text);
  end;
end;

procedure TfrmOrdeFollower_inputCK.v1ClothUnitPropertiesEditValueChanged(Sender: TObject);
var
  mvalue, fieldname: string;
begin
  if Trim(TcxTextEdit(Sender).EditingText) <> '' then
  begin
    mvalue := TcxTextEdit(Sender).EditingText;
  end
  else
  begin
    mvalue := '0';
  end;
  fieldname := Tv1.Controller.FocusedColumn.DataBinding.FilterFieldName;
  with Order_Sub do
  begin
    Edit;
    FieldByName(Trim(fieldname)).Value := mvalue;
    Post;
  end;
  with Order_Sub do
  begin
    Edit;
    FieldByName('money').Value := strtofloat(format('%.2f', [FieldByName('C_Qty').AsFloat * FieldByName('Price').AsFloat]));
    Post;
  end;
  self.tv1.Controller.EditingController.ShowEdit();
end;

procedure TfrmOrdeFollower_inputCK.fromConNoPropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
begin
{try
    frmClothContractList_CG_help:=TfrmClothContractList_CG_help.Create(Application);
    with frmClothContractList_CG_help do
    begin
      if ShowModal=1 then
      begin
        fromConNO.Text:=Trim(Order_Main.fieldbyname('ConNO').AsString);
      end;
    end;
  finally
    frmClothContractList_CG_help.Free;
  end;
      DoQuery(fromConNo.text);}
end;

procedure TfrmOrdeFollower_inputCK.v1Column6PropertiesEditValueChanged(Sender: TObject);
var
  mvalue, fieldname: string;
begin
  if Trim(TcxTextEdit(Sender).EditingText) <> '' then
  begin
    mvalue := TcxTextEdit(Sender).EditingText;
  end
  else
  begin
    mvalue := '0';
  end;
  fieldname := Tv1.Controller.FocusedColumn.DataBinding.FilterFieldName;
  with Order_Sub do
  begin
    Edit;
    FieldByName(Trim(fieldname)).Value := mvalue;
    Post;
  end;
  with Order_Sub do
  begin
    Edit;
    FieldByName('T_money').Value := strtofloat(format('%.2f', [FieldByName('T_Qty').AsFloat * FieldByName('Price').AsFloat]));
    Post;
  end;
  self.tv1.Controller.EditingController.ShowEdit();
end;

procedure TfrmOrdeFollower_inputCK.ToolButton1Click(Sender: TObject);
begin
  try
    frmClothContractList_Help := TfrmClothContractList_Help.Create(Application);
    with frmClothContractList_Help do
    begin
//      ToolButton1.Visible := True;
      if ShowModal = 1 then
      begin
        frmClothContractList_Help.Order_Main.DisableControls;
        with frmClothContractList_Help.Order_Main do
        begin
          First;
          while frmClothContractList_Help.Order_Main.Locate('SSel', True, []) do
          begin
            with Self.Order_Sub do
            begin
              edit;
              FieldByName('DeliveryDate').Value := Trim(FormatDateTime('yyyy-MM-dd', Now));
              FieldByName('CRType').Value := '投坯出库';
              FieldByName('KCMainID').Value := Trim(frmClothContractList_Help.Order_Main.fieldbyname('mainid').AsString);
              FieldByName('KCSubID').Value := Trim(frmClothContractList_Help.Order_Main.fieldbyname('SUbid').AsString);
              FieldByName('FactoryNoName').Value := frmClothContractList_Help.Order_Main.fieldbyname('FactoryNoName').Value;
              FieldByName('JHPlace').Value := frmClothContractList_Help.Order_Main.fieldbyname('JHPlace').Value;
              FieldByName('ToFactoryName').Value := frmClothContractList_Help.Order_Main.fieldbyname('JHPlace').Value;
              FieldByName('C_codename').Value := frmClothContractList_Help.Order_Main.fieldbyname('C_CodeName').Value;
              FieldByName('BatchNo').Value := frmClothContractList_Help.Order_Main.fieldbyname('BatchNo').Value;
              fieldbyname('C_UNit').Value := 'M';
            end;
            frmClothContractList_Help.Order_Main.Delete;
          end;
        end;
        frmClothContractList_Help.Order_Main.EnableControls;

      end;
    end;
  finally
    frmClothContractList_Help.Free;
  end;
//  with Order_Sub do
//  begin
//    Append;
//    fieldbyname('PriceUnit').Value := '人民币';
//    fieldbyname('C_UNit').Value := 'M';
//    Post;
//  end;
{  frmClothContractList_Help:=TfrmClothContractList_Help.create(self);
  with frmClothContractList_Help do
  begin
    if showmodal=1 then
    begin
    with Order_Main do
    begin
      DisableControls;
      First;
      while not eof do
      begin
        IF fieldbyname('ssel').AsBoolean then
        begin
          Order_Sub.Append;
          Order_Sub.Fieldbyname('gf').Value:=trim(Fieldbyname('FactoryNoName').AsString);
          Order_Sub.Fieldbyname('fdhNO').Value:=trim(Fieldbyname('conNo').AsString);
          Order_Sub.Fieldbyname('fromMainID').Value:=trim(Fieldbyname('MainID').AsString);
          Order_Sub.Fieldbyname('fromsubID').Value:=trim(Fieldbyname('subID').AsString);
          Order_Sub.Fieldbyname('C_CodeName').Value:=trim(Fieldbyname('C_CodeName').AsString);
          Order_Sub.Fieldbyname('C_spec').Value:=trim(Fieldbyname('C_spec').AsString);
//          Order_Sub.Fieldbyname('KZQty').Value:=Fieldbyname('KZQty').AsFloat;
//          Order_Sub.Fieldbyname('MFQty').Value:=Fieldbyname('MFQty').AsFloat;
    //      Order_Sub.Fieldbyname('Qty1').Value:=Fieldbyname('N_ps').AsFloat ;
    //      Order_Sub.Fieldbyname('C_Qty').Value:=Fieldbyname('N_Qty').AsFloat ;
          Order_Sub.Fieldbyname('C_Unit').Value:=trim(Fieldbyname('C_Unit').AsString);
          Order_Sub.Post;
        end;
        next;
      end;
      First;
      EnableControls;
    end;
    end;
  end;  }
end;

procedure TfrmOrdeFollower_inputCK.v1C_ColorPropertiesEditValueChanged(Sender: TObject);
var
  mvalue: string;
begin
  mvalue := TcxTextEdit(Sender).EditingText;

  if trim(mvalue) = '' then
    exit;

  if rightBstr(trim(mvalue), 1) <> '#' then
  begin
    mvalue := trim(mvalue) + '#';
  end;

  with Order_Sub do
  begin
    Edit;
    FieldByName('C_Color').Value := Trim(mvalue);
    Post;
  end;

  with ADOTemp do
  begin
    close;
    sql.Clear;
    sql.Add('select *  from KH_Zdy_Attachment A ');
    sql.Add('where zdyName=' + quotedstr(trim(Order_Sub.fieldbyname('C_CodeName').AsString)));
    sql.Add('and DEFstr3=' + quotedstr(trim(Order_Sub.fieldbyname('C_Color').AsString)));
    open;
  end;
  if ADOTemp.IsEmpty then
  begin
    application.MessageBox('颜色不存在！', '提示信息', 0);
    with Order_Sub do
    begin
      Edit;
      FieldByName('C_Color').Value := '';
      Post;
    end;
  end;
  with Order_Sub do
  begin
    Edit;
    FieldByName('C_Code').Value := trim(ADOTemp.fieldbyname('ZDYCode').AsString);
    Post;
  end;

  self.tv1.Controller.EditingController.ShowEdit();

end;

procedure TfrmOrdeFollower_inputCK.FormCreate(Sender: TObject);
begin
  cxGrid1.Align := Alclient;
end;

procedure TfrmOrdeFollower_inputCK.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  writeCXgrid(self.Caption, tv1);
end;

procedure TfrmOrdeFollower_inputCK.Tv1Column1PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
begin
  try
    frmClothContractList_CGSel := TfrmClothContractList_CGSel.Create(Application);
    with frmClothContractList_CGSel do
    begin
//      ToolButton1.Visible := True;
      if ShowModal = 1 then
      begin
        frmClothContractList_CGSel.Order_Main.DisableControls;
        with frmClothContractList_CGSel.Order_Main do
        begin
          First;
          while frmClothContractList_CGSel.Order_Main.Locate('SSel', True, []) do
          begin
            with Self.Order_Sub do
            begin
              edit;
              FieldByName('DeliveryDate').Value := Trim(FormatDateTime('yyyy-MM-dd', Now));
              FieldByName('fromMainID').Value := Trim(frmClothContractList_CGSel.Order_Main.fieldbyname('mainid').AsString);
              FieldByName('fromSubID').Value := Trim(frmClothContractList_CGSel.Order_Main.fieldbyname('SUbid').AsString);
              FieldByName('fromConNo').Value := frmClothContractList_CGSel.Order_Main.fieldbyname('ConNo').Value;
              FieldByName('FactoryNoName').Value := frmClothContractList_CGSel.Order_Main.fieldbyname('FactoryNoName').Value;
              FieldByName('FactoryNo').Value := frmClothContractList_CGSel.Order_Main.fieldbyname('FactoryNo').Value;
              FieldByName('C_codename').Value := frmClothContractList_CGSel.Order_Main.fieldbyname('C_CodeName').Value;
              FieldByName('KZQty').Value := frmClothContractList_CGSel.Order_Main.fieldbyname('KZQty').Value;
              FieldByName('MFQty').Value := frmClothContractList_CGSel.Order_Main.fieldbyname('MFQty').Value;
              fieldbyname('C_UNit').Value := 'M';
            end;
            frmClothContractList_CGSel.Order_Main.Delete;
          end;
        end;
        frmClothContractList_CGSel.Order_Main.EnableControls;

      end;
    end;
  finally
    frmClothContractList_CGSel.Free;
  end;
end;

procedure TfrmOrdeFollower_inputCK.ToolButton3Click(Sender: TObject);
begin
  if Order_Sub.IsEmpty then
  begin
    Application.MessageBox('明细不能为空！', '提示', 0);
    exit;
  end;
  if Order_Sub.Locate('ToFactoryName', null, []) = True then
  begin
    Application.MessageBox('染厂不能为空!', '提示', 0);
    Exit;
  end;
  if Order_Sub.Locate('CP_CodeName', '', []) = True then
  begin
    Application.MessageBox('品名不能为空!', '提示', 0);
    Exit;
  end;
  if Order_Sub.Locate('CP_CodeName', null, []) = True then
  begin
    Application.MessageBox('品名不能为空!', '提示', 0);
    Exit;
  end;
  if Order_Sub.Locate('BatchNo', '', []) = True then
  begin
    Application.MessageBox('批次号不能为空!', '提示', 0);
    Exit;
  end;
  if Order_Sub.Locate('BatchNo', null, []) = True then
  begin
    Application.MessageBox('批次号不能为空!', '提示', 0);
    Exit;
  end;
  if Order_Sub.Locate('CRType', null, []) = True then
  begin
    Application.MessageBox('类型不能为空!', '提示', 0);
    Exit;
  end;
  if Order_Sub.Locate('CRType', '', []) = True then
  begin
    Application.MessageBox('类型不能为空!', '提示', 0);
    Exit;
  end;
  if Order_Sub.Locate('CRTYpe;ConNo', VarArrayOf(['投坯出库', Null]), [loPartialKey]) = True then
  begin
    Application.MessageBox('投坯出库的数据，投坯计划不能为空!', '提示', 0);
    Exit;
  end;
  if SaveDataCK() then
  begin
    Application.MessageBox('保存成功！', '提示', 0);
//    ConNo.Text := '';
//    FactoryNoName.Text := '';
//    CompanyName.Text := '';
//    LXPerson.Text := '';
//    LXTel.Text := '';
//    JHPlace.Text := '';
    Order_Sub.EmptyDataSet;
    PState := 0;
    fMainID := '';
//    ConNo.Text := '自动生成';
  end;
end;

procedure TfrmOrdeFollower_inputCK.Tv1Column8PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
begin
  try
    frmClothContractList_TpSel := TfrmClothContractList_TpSel.Create(Application);
    with frmClothContractList_TpSel do
    begin
//      ToolButton1.Visible := True;
      FFactoryNoName := Self.Order_Sub.fieldbyname('JHPlace').AsString;
      if ShowModal = 1 then
      begin
        frmClothContractList_TpSel.Order_Main.DisableControls;
        with frmClothContractList_TpSel.Order_Main do
        begin
          First;
          while frmClothContractList_TpSel.Order_Main.Locate('SSel', True, []) do
          begin
            with Self.Order_Sub do
            begin
              edit;
              FieldByName('DeliveryDate').Value := Trim(FormatDateTime('yyyy-MM-dd', Now));
              FieldByName('fromMainID').Value := Trim(frmClothContractList_TpSel.Order_Main.fieldbyname('mainid').AsString);
              FieldByName('fromSubID').Value := Trim(frmClothContractList_TpSel.Order_Main.fieldbyname('SUbid').AsString);
              FieldByName('fromConNo').Value := frmClothContractList_TpSel.Order_Main.fieldbyname('ConNo').Value;
//              FieldByName('FactoryNoName').Value := frmClothContractList_TpSel.Order_Main.fieldbyname('FactoryNoName').Value;
//              FieldByName('FactoryNo').Value := frmClothContractList_TpSel.Order_Main.fieldbyname('FactoryNo').Value;
              FieldByName('CP_CodeName').Value := frmClothContractList_TpSel.Order_Main.fieldbyname('C_CodeName').Value;
              FieldByName('C_Color').Value := frmClothContractList_TpSel.Order_Main.fieldbyname('C_Color').Value;
              FieldByName('ConNo').Value := frmClothContractList_TpSel.Order_Main.fieldbyname('ConNo').Value;
              FieldByName('JHPlace').Value := frmClothContractList_TpSel.Order_Main.fieldbyname('FactoryNoName').Value;
              fieldbyname('C_UNit').Value := 'M';
            end;
            frmClothContractList_TpSel.Order_Main.Delete;
          end;
        end;
        frmClothContractList_TpSel.Order_Main.EnableControls;

      end;
    end;
  finally
    frmClothContractList_TpSel.Free;
  end;
end;

procedure TfrmOrdeFollower_inputCK.Tv1Column5PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
begin
  try
    frmZdyAttachGYS := TfrmZdyAttachGYS.Create(Application);
    with frmZdyAttachGYS do
    begin
      if ShowModal = 1 then
      begin
        Self.Order_Sub.Edit;
        Self.Order_Sub.FieldByName('JHPlace').Value := Trim(CDS_HZ.fieldbyname('ZDYName').AsString);
      end;
    end;
  finally
    frmZdyAttachGYS.Free;
  end;
end;

procedure TfrmOrdeFollower_inputCK.Tv1Column2PropertiesButtonClick(Sender: TObject; AButtonIndex: Integer);
begin
  try
    frmZdyAttachGYS := TfrmZdyAttachGYS.Create(Application);
    with frmZdyAttachGYS do
    begin
      if ShowModal = 1 then
      begin
        Self.Order_Sub.Edit;
        Self.Order_Sub.FieldByName('ToFactoryName').Value := Trim(CDS_HZ.fieldbyname('ZDYName').AsString);
      end;
    end;
  finally
    frmZdyAttachGYS.Free;
  end;
end;

end.