home *** CD-ROM | disk | FTP | other *** search
/ Delphi 5 for Professionals / DELPHI5.iso / Runimage / Delphi50 / Demos / Db / Csdemos / frmexesp.pas < prev    next >
Encoding:
Pascal/Delphi Source File  |  1999-08-11  |  2.1 KB  |  89 lines
  1. unit Frmexesp;
  2.  
  3. interface
  4.  
  5. uses
  6.   SysUtils, Windows, 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.   if  DmEmployee.SalesTable['ORDER_STATUS'] <> NULL then
  74.   BtnShipOrder.Enabled :=
  75.     AnsiCompareText(DmEmployee.SalesTable['ORDER_STATUS'], 'SHIPPED') <> 0;
  76. end;
  77.  
  78. procedure TFrmExecProc.BtnShipOrderClick(Sender: TObject);
  79. begin
  80.   with DmEmployee do
  81.   begin
  82.     ShipOrderProc.Params[0].AsString := SalesTable['PO_NUMBER'];
  83.     ShipOrderProc.ExecProc;
  84.     SalesTable.Refresh;
  85.   end;
  86. end;
  87.  
  88. end.
  89.