dfm_enter.pas

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

unit dfm_enter;

interface

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

type
  Tdfmenter = class(TForm)
    StatusBar1: TStatusBar;
    DBGrid1: TDBGrid;
    Panel1: TPanel;
    Panel2: TPanel;
    delbtn: TBitBtn;
    postbtn: TBitBtn;
    cancelbtn: TBitBtn;
    quitbtn: TBitBtn;
    dstmanrec: TDataSource;
    tbltmanrec: TTable;
    Panel3: TPanel;
    Label4: TLabel;
    Panel4: TPanel;
    Label2: TLabel;
    DBEdit2: TDBEdit;
    Label1: TLabel;
    Label3: TLabel;
    Label5: TLabel;
    DBEdit1: TDBEdit;
    Label6: TLabel;
    DBEdit3: TDBEdit;
    DBEdit5: TDBEdit;
    DBEdit6: TDBEdit;
    Query1: TQuery;
    ComboBox1: TComboBox;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    MaskEdit1: TMaskEdit;
    MaskEdit2: TMaskEdit;
    MaskEdit3: TMaskEdit;
    dstpara: TDataSource;
    tblpara: TTable;
    Query2: TQuery;
    Query3: TQuery;
    Query4: TQuery;
    Query5: TQuery;
    Query6: TQuery;
    DBEdit4: TDBEdit;
    BitBtn1: TBitBtn;
    Label10: TLabel;
    Label11: TLabel;
    MaskEdit4: TMaskEdit;
    MaskEdit5: TMaskEdit;
    Label12: TLabel;
    addbtn: TBitBtn;
    Label13: TLabel;
    Label14: TLabel;
    DBEdit7: TDBEdit;
    BitBtn2: TBitBtn;
    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 BitBtn1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  dfmenter: Tdfmenter;

implementation

uses dbmRainbowMis;

{$R *.DFM}

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

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

procedure Tdfmenter.FormCreate(Sender: TObject);
begin

  tbltmanrec.active:=true;
end;

procedure Tdfmenter.dstmanrecStateChange(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 Tdfmenter.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 Tdfmenter.delbtnClick(Sender: TObject);
begin
  tbltmanrec.delete;
end;

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

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

procedure Tdfmenter.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 (tbltmanrec.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 Tdfmenter.BitBtn1Click(Sender: TObject);
var
//  vztc:floater;
  vztc:Double;
begin
  vztc:=strtofloat(maskedit1.text)*tblpara.fieldbyname('fval').asfloat;
//  tbltmanrec.Edit;
  query2.ParamByName('vtca').asfloat:=int(strtofloat(maskedit2.text)/strtofloat(maskedit1.text)*vztc/strtofloat(maskedit4.text));
  query2.ExecSQL;

  query3.ParamByName('vtcb').asfloat:=int(strtofloat(maskedit3.text)/strtofloat(maskedit1.text)*vztc/strtofloat(maskedit5.text));
  query3.ExecSQL;

  query4.ExecSQL;
  query5.ExecSQL;
  query6.ExecSQL;
  tbltmanrec.Active :=false;
  tbltmanrec.Active :=true;
//  tbltmanrec.post;
end;

procedure Tdfmenter.BitBtn2Click(Sender: TObject);
begin
//  ppReport1.Print;
end;

end.