tablefield.pas

三层ERP系统 (SQL)

unit Tablefield;

interface

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

type
  Tfrmtablefield = class(TfrmMDIBase)
    Panel1: TPanel;
    Panel2: TPanel;
    DBGridEh1: TDBGridEh;
    Label1: TLabel;
    Edit1: TEdit;
    CDSBaseinfo: TClientDataSet;
    DSbaseinfo: TDataSource;
    CDSBaseinfofid: TAutoIncField;
    CDSBaseinfoftableName: TWideStringField;
    CDSBaseinfofname: TWideStringField;
    CDSBaseinfoftype: TWideStringField;
    CDSBaseinfoflength: TIntegerField;
    CDSBaseinfofisnullable: TBooleanField;
    CDSBaseinfofdesc: TWideStringField;
    CDSBaseinfofisvisible: TBooleanField;
    Button1: TButton;
    Button2: TButton;
    btnModify: TButton;
    btncancel: TButton;
    btnsave: TButton;
    Panel3: TPanel;
    btnExit: TButton;
    procedure DBGridEh1GetCellParams(Sender: TObject; Column: TColumnEh;
      AFont: TFont; var Background: TColor; State: TGridDrawState);
    procedure FormDestroy(Sender: TObject);
    procedure FormCloseQuery(Sender: TObject; var CanClose: Boolean);
    procedure DSbaseinfoStateChange(Sender: TObject);
    procedure DSbaseinfoDataChange(Sender: TObject; Field: TField);
    procedure FormCreate(Sender: TObject);
    procedure DBGridEh1KeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure Button2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure btnExitClick(Sender: TObject);
    procedure btnModifyClick(Sender: TObject);
    procedure btncancelClick(Sender: TObject);
    procedure btnsaveClick(Sender: TObject);
  private
    function CheckSave :Boolean;
    procedure newload;
    procedure SaveAll;
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmtablefield: Tfrmtablefield;

implementation

uses Global, DataProcess;

{$R *.dfm}

procedure Tfrmtablefield.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 Tfrmtablefield.FormDestroy(Sender: TObject);
begin
  inherited;
  frmtablefield:=nil;
end;

function Tfrmtablefield.CheckSave: Boolean;
begin
Result:=true;
if CDSbaseinfo.State in [dsEdit] then
   Case Messagedlg('眤璶玂