deletedb.pas

三层ERP系统 (SQL)

unit DeleteDB;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Grids, DBGridEh, StdCtrls, ExtCtrls, inifiles,
  Base_C, DBClient, DB;

type
  Tfrmdeletedb = class(TfrmBase_C)
    Panel1: TPanel;
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Label2: TLabel;
    Label4: TLabel;
    Edit2: TEdit;
    Edit1: TEdit;
    Edit3: TEdit;
    Panel2: TPanel;
    DBGridEh1: TDBGridEh;
    CDSdatabase: TClientDataSet;
    DSdatabase: TDataSource;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    procedure DBGridEh1GetCellParams(Sender: TObject; Column: TColumnEh;
      AFont: TFont; var Background: TColor; State: TGridDrawState);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure Button1Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Edit3Exit(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmdeletedb: Tfrmdeletedb;

implementation

uses Global, DataProcess;

{$R *.dfm}

procedure Tfrmdeletedb.DBGridEh1GetCellParams(Sender: TObject;
  Column: TColumnEh; AFont: TFont; var Background: TColor;
  State: TGridDrawState);
begin
  inherited;
  if dbgrideh1.SumList.RecNo mod 2=1 then
    background:=$00EAEFED
    else
    background:=clWhite;
end;

procedure Tfrmdeletedb.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
  inherited;
  frmdeletedb:=nil;
end;

procedure Tfrmdeletedb.Button1Click(Sender: TObject);
var
  s:string;
  ini:Tinifile;
begin
  inherited;
  if Trim(Edit1.Text)='' then
    begin
      messagedlg('SQL祅