unit khzl;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DB, ADODB, Grids, DBGridEh, dxfColorButton, cxTextEdit,
  cxCurrencyEdit, cxLookAndFeelPainters, StdCtrls, cxButtons, cxControls,
  cxFilterControl, cxDBFilterControl, bsSkinCtrls, HzSpell, Menus;

type
  Tkhzlck = class(TForm)
    dxfColorButton1: TdxfColorButton;
    DBGridEh1: TDBGridEh;
    DataSource1: TDataSource;
    table1: TADOQuery;
    ePanel1: TbsSkinExPanel;
    DBFc1: TcxDBFilterControl;
    cxButton1: TcxButton;
    py: THzSpell;
    PopupMenu1: TPopupMenu;
    N1: TMenuItem;
    procedure dxfColorButton1Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure cxButton1Click(Sender: TObject);
    procedure table1NewRecord(DataSet: TDataSet);
    procedure DBGridEh1Columns1UpdateData(Sender: TObject;
      var Text: String; var Value: Variant; var UseText, Handled: Boolean);
    procedure N1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  khzlck: Tkhzlck;

implementation

{$R *.dfm}

uses sjk;

procedure Tkhzlck.dxfColorButton1Click(Sender: TObject);
begin
table1.UpdateBatch();
end;

procedure Tkhzlck.FormCreate(Sender: TObject);
begin
table1.Open;
epanel1.RollState:=true;
end;

procedure Tkhzlck.cxButton1Click(Sender: TObject);
begin
table1.Close;
table1.SQL.Clear;
table1.SQL.Add('select * from khzl where ');
table1.SQL.Add(dbfc1.FilterText);
table1.Open;
epanel1.RollState:=true;
end;

procedure Tkhzlck.table1NewRecord(DataSet: TDataSet);
begin
table1.Edit;
table1['khbh']:=inttostr(table1.RecordCount+1);
table1['ljxf']:=0;
table1['ljqk']:=0;
end;

procedure Tkhzlck.DBGridEh1Columns1UpdateData(Sender: TObject;
  var Text: String; var Value: Variant; var UseText, Handled: Boolean);
begin
table1.Edit;
table1['zjm']:=py.PyHeadOfHz(text);
end;

procedure Tkhzlck.N1Click(Sender: TObject);
begin
if table1['ljqk']<=0 then
table1.Delete else
showmessage('此客戶尚有欠款，不能刪除！');

end;

end.