dfm_manrec.pas

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

unit dfm_manrec;

interface

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

type
  Tdfmmanrec = class(TForm)
    StatusBar1: TStatusBar;
    DBGrid1: TDBGrid;
    Panel1: TPanel;
    Panel2: TPanel;
    addbtn: TBitBtn;
    delbtn: TBitBtn;
    postbtn: TBitBtn;
    cancelbtn: TBitBtn;
    quitbtn: TBitBtn;
    dstmanrec: TDataSource;
    Label2: TLabel;
    Label4: TLabel;
    DBEdit2: TDBEdit;
    Label3: TLabel;
    Label5: TLabel;
    DBEdit1: TDBEdit;
    DBEdit3: TDBEdit;
    Label1: TLabel;
    DBEdit5: TDBEdit;
    Label6: TLabel;
    DBEdit6: TDBEdit;
    Label7: TLabel;
    DBComboBox1: TDBComboBox;
    Label10: TLabel;
    DBEdit8: TDBEdit;
    tbltmanrec: TADOTable;
    Label11: TLabel;
    DBEdit9: TDBEdit;
    DBEdit7: TDBEdit;
    Label8: TLabel;
    DBLookupComboBox1: TDBLookupComboBox;
    DataSource1: TDataSource;
    atblbranch: TADOTable;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure quitbtnClick(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure dstmanrecStateChange(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 tbltmanrecBeforeDelete(DataSet: TDataSet);
    procedure FormKeyPress(Sender: TObject; var Key: Char);
    procedure DBGrid1TitleClick(Column: TColumn);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  dfmmanrec: Tdfmmanrec;

implementation

uses dbmRainbowMis, chHeadUnit;

{$R *.DFM}

procedure Tdfmmanrec.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  tbltmanrec.active:=false;
  atblbranch.Active:=false;
  action:=cafree;
end;

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

procedure Tdfmmanrec.FormCreate(Sender: TObject);
begin
  tbltmanrec.active:=true;
  atblbranch.Active:=true;
  //  dfmflow.Visible:=false;
end;

procedure Tdfmmanrec.dstmanrecStateChange(Sender: TObject);
begin
    case tbltmanrec.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 Tdfmmanrec.addbtnClick(Sender: TObject);
begin
  tbltmanrec.Append;
end;

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

procedure Tdfmmanrec.postbtnClick(Sender: TObject);
begin
  tbltmanrec.post;
//  tbltposloca.refresh;
end;

procedure Tdfmmanrec.cancelbtnClick(Sender: TObject);
begin
  tbltmanrec.Cancel;
end;

procedure Tdfmmanrec.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 tbltmanrec.FieldByName('Foutdate').Asdatetime=0 then begin

    end
    else
    begin
      DBGrid1.Canvas.Brush.Color := clred;
      DBGrid1.DefaultDrawColumnCell(Rect, DataCol, Column, State);
      DBGrid1.Canvas.Brush.Color := holdColor;
    end;
{  holdColor := DBGrid1.Canvas.Brush.Color;


    if (tbltmanrec.RecNo mod 2 <> 0) then begin
      DBGrid1.Canvas.Brush.Color := clMoneyGreen;
      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 Tdfmmanrec.tbltmanrecBeforeDelete(DataSet: TDataSet);
begin
  if Application.MessageBox('确定要删除当前记录吗？', '删除 记录', Mb_YesNo + Mb_IconWarning) =Id_No then
    Abort;
end;

procedure Tdfmmanrec.FormKeyPress(Sender: TObject; var Key: Char);
begin
  chHeadUnit.tabventer(dfmmanrec,Key);
end;

procedure Tdfmmanrec.DBGrid1TitleClick(Column: TColumn);
begin
//  chHeadUnit.TitClick(column);
end;

end.