unit xschdxzsp1;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  Db, ADODB, dxCntner, dxTL, dxDBCtrl, dxDBGrid, StdCtrls, Buttons,
  dxEditor, dxExEdtr, dxEdLib, dxDBELib, dxDBEdtr, dxDBTLCl, dxGrClms,
  ExtCtrls;

type
  Txschxzsp = class(TForm)
    Panel1: TPanel;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    BitBtn3: TBitBtn;
    Edit1: TEdit;
    Edit3: TEdit;
    Edit2: TEdit;
    dxDBGrid2: TdxDBGrid;
    dxDBGrid2code: TdxDBGridMaskColumn;
    dxDBGrid2name: TdxDBGridMaskColumn;
    dxDBGrid2lsj: TdxDBGridMaskColumn;
    dxDBGrid2kcsl: TdxDBGridMaskColumn;
    dxDBGrid2barcode: TdxDBGridMaskColumn;
    dxDBGrid2mainghs: TdxDBGridMaskColumn;
    dxDBGrid2jldw: TdxDBGridMaskColumn;
    dxDBGrid2bzgg: TdxDBGridMaskColumn;
    ADOQuery1: TADOQuery;
    ADOQuery1code: TStringField;
    ADOQuery1name: TStringField;
    ADOQuery1barcode: TStringField;
    ADOQuery1mainghs: TStringField;
    ADOQuery1jldw: TStringField;
    ADOQuery1bzgg: TBCDField;
    ADOQuery1kcsl: TBCDField;
    DataSource1: TDataSource;
    ADOQuery1lsj: TBCDField;
    ADOQuery1lb: TStringField;
    dxDBGrid2Column9: TdxDBGridMaskColumn;
    ADOQuery1jhj: TBCDField;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure Edit1KeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure FormCreate(Sender: TObject);
    procedure dxDBGrid2DblClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  xschxzsp: Txschxzsp;

implementation

uses MainForm1, xschd1;

{$R *.DFM}

procedure Txschxzsp.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  action := cafree;
end;

procedure Txschxzsp.BitBtn1Click(Sender: TObject);
begin
  with xschd do
  begin
    if (ADOTable2.FieldByName('spname').Value <> '') then
    begin
      ADOTable2.edit;
      ADOTable2.FieldByName('spcode').Value := ADOQuery1code.Value;
      ADOTable2.FieldByName('spname').Value := ADOQuery1name.Value;
      ADOTable2.FieldByName('jldw').Value := ADOQuery1jldw.Value;
      ADOTable2.FieldByName('dj').Value := ADOQuery1lsj.Value;
      ADOTable2.FieldByName('bzgg').Value := ADOQuery1bzgg.Value;
      ADOTable2.FieldByName('kcsl').Value := ADOQuery1kcsl.Value;
      ADOTable2.FieldByName('js').Value := 0;
      ADOTable2.FieldByName('ss').Value := 0;
      ADOTable2.FieldByName('sl').Value := 0;
      ADOTable2.FieldByName('sui').Value := 0;
      ADOTable2.FieldByName('je').Value := 0;
      ADOTable2.FieldByName('jhj').Value := ADOQuery1jhj.Value;
      Query1.Close;
      Query1.SQL.Clear;
      Query1.SQL.Add('select top 1  CONVERT (char(10),kdrq,20) ,code,dj from xsdj_v where spcode=:code3 and kh=:kh order by kdrq desc');
      Query1.Parameters[0].Value := ADOQuery1code.Value;
      Query1.Parameters[1].Value := ADOTable1kh.Value;
      Query1.Open;
      ADOTable2.FieldByName('dj').Value := Query1.fieldbyname('dj').Value;
      ADOTable2.Post;
    end
    else
    begin
      ADOTable2.Append;
      ADOTable2.FieldByName('spcode').Value := ADOQuery1code.Value;
      ADOTable2.FieldByName('spname').Value := ADOQuery1name.Value;
      ADOTable2.FieldByName('jldw').Value := ADOQuery1jldw.Value;
      ADOTable2.FieldByName('dj').Value := ADOQuery1lsj.Value;
      ADOTable2.FieldByName('bzgg').Value := ADOQuery1bzgg.Value;
      ADOTable2.FieldByName('kcsl').Value := ADOQuery1kcsl.Value;
      ADOTable2.FieldByName('js').Value := 0;
      ADOTable2.FieldByName('ss').Value := 0;
      ADOTable2.FieldByName('sl').Value := 0;
      ADOTable2.FieldByName('sui').Value := 0;
      ADOTable2.FieldByName('je').Value := 0;
      ADOTable2.FieldByName('jhj').Value := ADOQuery1jhj.Value;
      Query1.Close;
      Query1.SQL.Clear;
      Query1.SQL.Add('select top 1  CONVERT (char(10),kdrq,20) ,code,dj from xsdj_v where spcode=:code3 and kh=:kh order by kdrq desc');
      Query1.Parameters[0].Value := ADOQuery1code.Value;
      Query1.Parameters[1].Value := ADOTable1kh.Value;
      Query1.Open;
      ADOTable2.FieldByName('dj').Value := Query1.fieldbyname('dj').Value;
      ADOTable2.Post;
    end;
  end;
end;

procedure Txschxzsp.BitBtn2Click(Sender: TObject);
begin
  with xschd do
  begin
    ADOTable2.Append;
    ADOTable2.FieldByName('spcode').Value := ADOQuery1code.Value;
    ADOTable2.FieldByName('spname').Value := ADOQuery1name.Value;
    ADOTable2.FieldByName('jldw').Value := ADOQuery1jldw.Value;
    ADOTable2.FieldByName('dj').Value := ADOQuery1lsj.Value;
    ADOTable2.FieldByName('bzgg').Value := ADOQuery1bzgg.Value;
    ADOTable2.FieldByName('kcsl').Value := ADOQuery1kcsl.Value;
    ADOTable2.FieldByName('js').Value := 0;
    ADOTable2.FieldByName('ss').Value := 0;
    ADOTable2.FieldByName('sl').Value := 0;
    ADOTable2.FieldByName('sui').Value := 0;
    ADOTable2.FieldByName('je').Value := 0;
    ADOTable2.FieldByName('jhj').Value := ADOQuery1jhj.Value;
    Query1.Close;
    Query1.SQL.Clear;
    Query1.SQL.Add('select top 1  CONVERT (char(10),kdrq,20) ,code,dj from xsdj_v where spcode=:code3 and kh=:kh order by kdrq desc');
    Query1.Parameters[0].Value := ADOQuery1code.Value;
    Query1.Parameters[1].Value := ADOTable1kh.Value;
    Query1.Open;
    ADOTable2.FieldByName('dj').Value := Query1.fieldbyname('dj').Value;
    ADOTable2.Post;
  end;
end;

procedure Txschxzsp.Edit1KeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
var aa, bb, cc: string;
begin
  if key = 13 then
  begin
    if Edit1.Text = '' then aa := '%' else aa := Edit1.Text;
    if Edit2.Text = '' then bb := '%' else bb := Edit2.Text;
    if Edit3.Text = '' then cc := '%' else cc := Edit3.Text;
    ADOQuery1.Close;
    ADOQuery1.Parameters[0].Value := aa;
    ADOQuery1.Parameters[1].Value := bb;
    ADOQuery1.Parameters[2].Value := cc;
    ADOQuery1.Parameters[3].Value := xschd.ADOTable1ck.Value;
    ADOQuery1.Open;
  end;
end;

procedure Txschxzsp.FormCreate(Sender: TObject);
var aa, bb, cc: string;
begin
  if Edit1.Text = '' then aa := '%' else aa := Edit1.Text;
  if Edit2.Text = '' then bb := '%' else bb := Edit2.Text;
  if Edit3.Text = '' then cc := '%' else cc := Edit3.Text;
  ADOQuery1.Close;
  ADOQuery1.Parameters[0].Value := aa;
  ADOQuery1.Parameters[1].Value := bb;
  ADOQuery1.Parameters[2].Value := cc;
  ADOQuery1.Parameters[3].Value := xschd.ADOTable1ck.Value;
  ADOQuery1.Open;
end;

procedure Txschxzsp.dxDBGrid2DblClick(Sender: TObject);
begin
  BitBtn2.Click;
  Close;
end;

end.