home *** CD-ROM | disk | FTP | other *** search
/ PC Pro 1999 February / DPPCPRO0299.ISO / February / Delphi / Install / DATA.Z / FRMEXESP.PAS < prev    next >
Encoding:
Pascal/Delphi Source File  |  1996-06-11  |  2.1 KB  |  88 lines
  1. unit Frmexesp;
  2.  
  3. interface
  4.  
  5. uses
  6.   SysUtils, WinTypes, WinProcs, Messages, Classes, Graphics, Controls,
  7.   StdCtrls, Forms, DBCtrls, DB, DBGrids, Buttons, DBTables, Mask, Grids,
  8.   ExtCtrls;
  9.  
  10. type
  11.   TFrmExecProc = class(TForm)
  12.     DBGrid1: TDBGrid;
  13.     ScrollBox: TScrollBox;
  14.     Label1: TLabel;
  15.     EditCUST_NO: TDBEdit;
  16.     Label2: TLabel;
  17.     EditCUSTOMER: TDBEdit;
  18.     Label3: TLabel;
  19.     EditCONTACT_FIRST: TDBEdit;
  20.     EditCONTACT_LAST: TDBEdit;
  21.     EditPHONE_NO: TDBEdit;
  22.     Label6: TLabel;
  23.     EditADDRESS_LINE: TDBEdit;
  24.     EditADDRESS_LINE2: TDBEdit;
  25.     EditCITY: TDBEdit;
  26.     EditSTATE_PROVINCE: TDBEdit;
  27.     EditCOUNTRY: TDBEdit;
  28.     EditPOSTAL_CODE: TDBEdit;
  29.     DBNavigator: TDBNavigator;
  30.     Panel1: TPanel;
  31.     Panel3: TPanel;
  32.     Panel2: TPanel;
  33.     DBCheckBox1: TDBCheckBox;
  34.     Label4: TLabel;
  35.     BtnShipOrder: TSpeedButton;
  36.     BitBtn1: TBitBtn;
  37.     SalesSource: TDataSource;
  38.     procedure SalesSourceDataChange(Sender: TObject; Field: TField);
  39.     procedure BtnShipOrderClick(Sender: TObject);
  40.     procedure FormShow(Sender: TObject);
  41.     procedure FormHide(Sender: TObject);
  42.   private
  43.     { private declarations }
  44.   public
  45.     { public declarations }
  46.   end;
  47.  
  48. var
  49.   FrmExecProc: TFrmExecProc;
  50.  
  51. implementation
  52.  
  53. uses DmCSDemo;
  54.  
  55. {$R *.DFM}
  56.  
  57. procedure TFrmExecProc.FormShow(Sender: TObject);
  58. begin
  59.   DmEmployee.SalesTable.Open;
  60.   DmEmployee.CustomerTable.Open;
  61.   { Enable DataEvents from the SalesTable for this form now }
  62.   SalesSource.Enabled := True;
  63. end;
  64.  
  65. procedure TFrmExecProc.FormHide(Sender: TObject);
  66. begin
  67.   { Disable DataEvents from the SalesTable for this form now }
  68.   SalesSource.Enabled := False;
  69. end;
  70.  
  71. procedure TFrmExecProc.SalesSourceDataChange(Sender: TObject; Field: TField);
  72. begin
  73.   BtnShipOrder.Enabled :=
  74.     CompareText(DmEmployee.SalesTable['ORDER_STATUS'], 'SHIPPED') <> 0;
  75. end;
  76.  
  77. procedure TFrmExecProc.BtnShipOrderClick(Sender: TObject);
  78. begin
  79.   with DmEmployee do
  80.   begin
  81.     ShipOrderProc.Params[0].AsString := SalesTable['PO_NUMBER'];
  82.     ShipOrderProc.ExecProc;
  83.     SalesTable.Refresh;
  84.   end;
  85. end;
  86.  
  87. end.
  88.