cgfkdcx11.pas

思微POS连锁超市管理系统 (商业代码),几年前的东西了

unit cgfkdcx11;

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
  Tcgfkdcxmx = 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;
    Query1code: TStringField;
    Query1fkfs: TStringField;
    Query1fkje: TBCDField;
    Query1ryname: TStringField;
    Query1kdrq: TDateTimeField;
    Query1czyname: TStringField;
    Query1yfk: TBooleanField;
    Query1bz: TStringField;
    Query1zt: TStringField;
    Query1ghsname: TStringField;
    dxDBGrid1code: TdxDBGridMaskColumn;
    dxDBGrid1fkfs: TdxDBGridMaskColumn;
    dxDBGrid1fkje: TdxDBGridMaskColumn;
    dxDBGrid1ryname: TdxDBGridMaskColumn;
    dxDBGrid1kdrq: TdxDBGridDateColumn;
    dxDBGrid1czyname: TdxDBGridMaskColumn;
    dxDBGrid1bz: TdxDBGridMaskColumn;
    dxDBGrid1zt: TdxDBGridMaskColumn;
    dxDBGrid1ghsname: TdxDBGridMaskColumn;
    ADOQuery1code: TStringField;
    ADOQuery1cgdh: TStringField;
    ADOQuery1djje: TBCDField;
    ADOQuery1yfje: TBCDField;
    ADOQuery1fkje: TBCDField;
    ADOQuery1bz: TStringField;
    ADOQuery1id: TAutoIncField;
    dxDBGrid2cgdh: TdxDBGridMaskColumn;
    dxDBGrid2djje: TdxDBGridMaskColumn;
    dxDBGrid2yfje: TdxDBGridMaskColumn;
    dxDBGrid2fkje: TdxDBGridMaskColumn;
    dxDBGrid2bz: TdxDBGridMaskColumn;
    BitBtn1: TBitBtn;
    procedure FormCreate(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure PageControl1Change(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  cgfkdcxmx: Tcgfkdcxmx;

implementation

uses MainForm1, dycgfkd1;

{$R *.DFM}

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

procedure Tcgfkdcxmx.Button1Click(Sender: TObject);
var code, ghs: string;
begin
  if Edit1.text = '' then code := '%' else code := Edit1.text;
  if Edit2.text = '' then ghs := '%' else ghs := Edit2.text;
  Query1.close;
  Query1.sql.clear;
  Query1.sql.add('select * from CGFKCX_V');
  Query1.sql.add('where code like :code and ghs like :ghs and (kdrq>=:rq1 and kdrq<=:rq2)');
  Query1.Parameters[0].Value := code;
  Query1.Parameters[1].Value := ghs;
  Query1.Parameters[2].Value := DateTimePicker1.date;
  Query1.Parameters[3].Value := DateTimePicker2.date;
  Query1.open;
end;

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

procedure Tcgfkdcxmx.PageControl1Change(Sender: TObject);
begin
  if Query1.Active = false then
  begin
    PageControl1.ActivePageIndex := 0;
    exit;
  end;
  if Query1.fieldbyname('code').asstring = '' then
  begin
    PageControl1.ActivePageIndex := 0;
    exit;
  end;
  ADOQuery1.Close;
  ADOQuery1.SQL.Clear;
  ADOQuery1.SQL.Add('select * from cgfk002_v where code=:code');
  ADOQuery1.Parameters[0].Value := dxDBGrid1.SelectedNodes[0].Strings[0];
  ADOQuery1.Open;
end;

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

end.