dfm_para.pas

仓库管理系统 仓库管理系统

unit dfm_para;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  ComCtrls, StdCtrls, Buttons, ExtCtrls, Grids, DBGrids, Db, DBTables, Mask,
  DBCtrls;

type
  Tdfmpara = class(TForm)
    StatusBar1: TStatusBar;
    DBGrid1: TDBGrid;
    Panel2: TPanel;
    postbtn: TBitBtn;
    cancelbtn: TBitBtn;
    quitbtn: TBitBtn;
    dstpara: TDataSource;
    tbltpara: TTable;
    Query1: TQuery;
    BitBtn1: TBitBtn;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure quitbtnClick(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure dstparaStateChange(Sender: TObject);
    procedure addbtnClick(Sender: TObject);
    procedure delbtnClick(Sender: TObject);
    procedure postbtnClick(Sender: TObject);
    procedure cancelbtnClick(Sender: TObject);
    procedure DBGrid1DrawColumnCell(Sender: TObject; const Rect: TRect;
      DataCol: Integer; Column: TColumn; State: TGridDrawState);
    procedure BitBtn1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  dfmpara: Tdfmpara;

implementation

uses dbmRainbowMis;

{$R *.DFM}

procedure Tdfmpara.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  tbltpara.active:=false;
  action:=cafree;
end;

procedure Tdfmpara.quitbtnClick(Sender: TObject);
begin
  close;
end;

procedure Tdfmpara.FormCreate(Sender: TObject);
begin
  tbltpara.active:=true;
end;

procedure Tdfmpara.dstparaStateChange(Sender: TObject);
begin
{    case tbltworker.State of
      dsbrowse:
        begin
          addbtn.Enabled :=true;
          delbtn.Enabled :=true;
//          BitBtn_edit.Enabled :=true;
          postbtn.Enabled :=false;
          cancelbtn.Enabled :=false;
        end;
      dsinsert:
        begin
          addbtn.Enabled :=false;
          delbtn.Enabled :=false;
//          BitBtn_edit.Enabled :=true;
          postbtn.Enabled :=true;
          cancelbtn.Enabled :=true;
        end;
      dsedit:
        begin
          addbtn.Enabled :=false;
          delbtn.Enabled :=false;
//          BitBtn_edit.Enabled :=true;
          postbtn.Enabled :=true;
          cancelbtn.Enabled :=true;
        end;
    end;}
end;

procedure Tdfmpara.addbtnClick(Sender: TObject);
begin
{//  tbltmanrec.Append;
  if Application.MessageBox('此操作将删除表中现有的内容，你要继续吗？',
        '提示信息', MB_OKCANCEL + MB_DEFBUTTON1) = IDOK then
  begin
    tbltmanrec.active:=false;
    tbltmanrec.EmptyTable;
    Query1.ParamByName('vshop').asstring:=combobox1.Text ;
    Query1.ExecSQL;
    tbltmanrec.active:=true;
//    INSERT INTO "customer.db" (custno, company);
//    SELECT custno, company FROM "oldcustomer.db"
  end;}
end;

procedure Tdfmpara.delbtnClick(Sender: TObject);
begin
//  tbltmanrec.delete;
end;

procedure Tdfmpara.postbtnClick(Sender: TObject);
begin
  tbltpara.post;
//  tbltposloca.refresh;
end;

procedure Tdfmpara.cancelbtnClick(Sender: TObject);
begin
  tbltpara.Cancel;
end;

procedure Tdfmpara.DBGrid1DrawColumnCell(Sender: TObject;
  const Rect: TRect; DataCol: Integer; Column: TColumn;
  State: TGridDrawState);
var
 holdColor: TColor;
begin
  holdColor := DBGrid1.Canvas.Brush.Color; {store the original color}
//  if Column = 'EmpNo' then {only do for the cell displaying EmpNo}

    if (tbltpara.RecNo mod 2 <> 0) then begin
      DBGrid1.Canvas.Brush.Color := clAqua;
      DBGrid1.DefaultDrawColumnCell(Rect, DataCol, Column, State);
      DBGrid1.Canvas.Brush.Color := holdColor;
    end
    else
    begin
      DBGrid1.Canvas.Brush.Color := clInfoBk;
      DBGrid1.DefaultDrawColumnCell(Rect, DataCol, Column, State);
      DBGrid1.Canvas.Brush.Color := holdColor;
    end;
end;

procedure Tdfmpara.BitBtn1Click(Sender: TObject);
begin
  tbltpara.edit;
end;

end.