unit cgdddcx11;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  ComCtrls, Db, DBTables, EHGrids, DBGridEh, StdCtrls, Menus, ADODB,
  ExtCtrls, dxDBTLCl, dxGrClms, dxTL, dxDBCtrl, dxDBGrid, dxCntner, Buttons;

type
  Tckdcxmx = class(TForm)
    DataSource1: TDataSource;
    DataSource2: TDataSource;
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    PopupMenu1: TPopupMenu;
    N1: TMenuItem;
    Query1: TADOQuery;
    Panel1: TPanel;
    Label1: TLabel;
    Label2: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    DateTimePicker1: TDateTimePicker;
    DateTimePicker2: TDateTimePicker;
    Button1: TButton;
    dxDBGrid2: TdxDBGrid;
    ADOQuery1: TADOQuery;
    dxDBGrid1: TdxDBGrid;
    ADOQuery1spcode: TStringField;
    ADOQuery1spname: TStringField;
    ADOQuery1jldw: TStringField;
    ADOQuery1bzgg: TBCDField;
    ADOQuery1js: TBCDField;
    ADOQuery1ss: TBCDField;
    ADOQuery1sl: TBCDField;
    ADOQuery1je: TBCDField;
    dxDBGrid2spcode: TdxDBGridMaskColumn;
    dxDBGrid2spname: TdxDBGridMaskColumn;
    dxDBGrid2jldw: TdxDBGridMaskColumn;
    dxDBGrid2bzgg: TdxDBGridMaskColumn;
    dxDBGrid2js: TdxDBGridMaskColumn;
    dxDBGrid2ss: TdxDBGridMaskColumn;
    dxDBGrid2sl: TdxDBGridMaskColumn;
    dxDBGrid2dj: TdxDBGridMaskColumn;
    dxDBGrid2je: TdxDBGridMaskColumn;
    Query1code: TStringField;
    Query1kdrq: TDateTimeField;
    Query1dkr: TStringField;
    Query1dcckname: TStringField;
    Query1drckname: TStringField;
    Query1ywy: TStringField;
    Query1name: TStringField;
    Query1bz: TStringField;
    dxDBGrid1code: TdxDBGridMaskColumn;
    dxDBGrid1kdrq: TdxDBGridDateColumn;
    dxDBGrid1dkr: TdxDBGridMaskColumn;
    dxDBGrid1dcckname: TdxDBGridMaskColumn;
    dxDBGrid1drckname: TdxDBGridMaskColumn;
    dxDBGrid1ywy: TdxDBGridMaskColumn;
    dxDBGrid1name: TdxDBGridMaskColumn;
    dxDBGrid1bz: TdxDBGridMaskColumn;
    Label3: TLabel;
    Edit3: TEdit;
    ADOQuery1jhj: TBCDField;
    Label6: TLabel;
    Edit4: TEdit;
    TabSheet3: TTabSheet;
    Panel2: TPanel;
    Label7: TLabel;
    Edit5: TEdit;
    Button2: TButton;
    Label8: TLabel;
    DateTimePicker3: TDateTimePicker;
    Label9: TLabel;
    DateTimePicker4: TDateTimePicker;
    dxDBGrid3: TdxDBGrid;
    ADOQuery2: TADOQuery;
    DataSource3: TDataSource;
    ADOQuery2spcode: TStringField;
    ADOQuery2spname: TStringField;
    ADOQuery2sl: TBCDField;
    ADOQuery2jhj: TBCDField;
    ADOQuery2je: TBCDField;
    ADOQuery2dcck: TStringField;
    dxDBGrid3spcode: TdxDBGridMaskColumn;
    dxDBGrid3spname: TdxDBGridMaskColumn;
    dxDBGrid3sl: TdxDBGridMaskColumn;
    dxDBGrid3jhj: TdxDBGridMaskColumn;
    dxDBGrid3je: TdxDBGridMaskColumn;
    dxDBGrid3dcck: TdxDBGridMaskColumn;
    Query1zt: TStringField;
    dxDBGrid1Column9: TdxDBGridMaskColumn;
    ADOQuery2drck: TStringField;
    dxDBGrid3Column7: TdxDBGridMaskColumn;
    BitBtn1: TBitBtn;
    procedure FormCreate(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure PageControl1Change(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  ckdcxmx: Tckdcxmx;

implementation

uses MainForm1, dycKdd1;

{$R *.DFM}

procedure Tckdcxmx.FormCreate(Sender: TObject);
begin
  DateTimePicker1.DateTime := MainForm.DateTimePicker2.DateTime;
  DateTimePicker2.DateTime := MainForm.DateTimePicker1.DateTime;
  DateTimePicker3.DateTime := MainForm.DateTimePicker2.DateTime;
  DateTimePicker4.DateTime := MainForm.DateTimePicker1.DateTime;
end;

procedure Tckdcxmx.Button1Click(Sender: TObject);
var code, ghs, ck: string;
begin
  if Edit1.text = '' then code := '%' else code := Edit1.text;
  if Edit2.text = '' then ghs := '%' else ghs := Edit2.text;
  if Edit3.text = '' then ck := '%' else ck := Edit3.text;
  Query1.close;
  Query1.sql.clear;
  Query1.sql.add('select * from ckddcx_v');
  Query1.sql.add('where (code like :code and code in(select code from ckdd002_v where spcode like :spcode)) and dcck like :ghs and drck like :ck and (kdrq>=:rq1 and kdrq<=:rq2)');
  Query1.Parameters[0].Value := code;
  Query1.Parameters[1].Value := Edit4.text + '%';
  Query1.Parameters[2].Value := ghs;
  Query1.Parameters[3].Value := ck;
  Query1.Parameters[4].Value := datetostr(DateTimePicker1.date);
  Query1.Parameters[5].Value := datetostr(DateTimePicker2.date);
  Query1.open;
end;

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

procedure Tckdcxmx.PageControl1Change(Sender: TObject);
begin
  try
    ADOQuery1.Close;
    ADOQuery1.SQL.Clear;
    ADOQuery1.SQL.Add('select * from ckdd002_v where code=:code');
    ADOQuery1.Parameters[0].Value := dxDBGrid1.SelectedNodes[0].Strings[0];
    ADOQuery1.Open;
  except
  end;
end;

procedure Tckdcxmx.Button2Click(Sender: TObject);
begin
  ADOQuery2.Close;
  ADOQuery2.Parameters[0].Value := datetostr(DateTimePicker3.date);
  ADOQuery2.Parameters[1].Value := datetostr(DateTimePicker4.date);
  ADOQuery2.Parameters[2].Value := Edit5.text + '%';
  ADOQuery2.Open;
end;

procedure Tckdcxmx.BitBtn1Click(Sender: TObject);
begin
  Application.CreateForm(Tdyckdd, dyckdd);
  dyckdd.ADOQuery1.Close;
  dyckdd.ADOQuery1.Sql.clear;
  dyckdd.ADOQuery1.Sql.add('select * from ckddcx_v where code=:code');
  dyckdd.ADOQuery1.Parameters[0].Value := dxDBGrid1.SelectedNodes[0].Strings[0];
  dyckdd.ADOQuery1.Open;
  dyckdd.ADOQuery2.Close;
  dyckdd.ADOQuery2.Sql.clear;
  dyckdd.ADOQuery2.Sql.add('select * from ckdd002_v where code=:code order by id');
  dyckdd.ADOQuery2.Parameters[0].Value := dxDBGrid1.SelectedNodes[0].Strings[0];
  dyckdd.ADOQuery2.Open;
  dyckdd.ShowModal;
end;

end.