untcustomer_m.pas

用delphi编写的数据库管理软件

unit untCustomer_M;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, BaseInfo_M, StdCtrls, Mask, wwdbedit, ExtCtrls, DB, DBClient,
  wwdblook, wwcheckbox, DBCtrlsEh, ExtDlgs, Buttons;

type
  TfrmCustomer_M = class(TfrmBaseInfo_M)
    Label9: TLabel;
    wwDBEdit8: TwwDBEdit;
    Label11: TLabel;
    wwDBEdit12: TwwDBEdit;
    Label3: TLabel;
    wwDBLookupCombo1: TwwDBLookupCombo;
    CDSType: TClientDataSet;
    Label4: TLabel;
    wwDBLookupCombo2: TwwDBLookupCombo;
    Label5: TLabel;
    Label6: TLabel;
    wwDBEdit2: TwwDBEdit;
    wwDBEdit3: TwwDBEdit;
    Label7: TLabel;
    Label8: TLabel;
    wwDBEdit4: TwwDBEdit;
    wwDBEdit5: TwwDBEdit;
    Label10: TLabel;
    wwDBEdit6: TwwDBEdit;
    wwDBEdit7: TwwDBEdit;
    Label12: TLabel;
    Label13: TLabel;
    Label14: TLabel;
    wwDBEdit9: TwwDBEdit;
    wwDBEdit10: TwwDBEdit;
    Label15: TLabel;
    wwDBEdit11: TwwDBEdit;
    Label16: TLabel;
    wwDBEdit13: TwwDBEdit;
    Label17: TLabel;
    wwDBEdit14: TwwDBEdit;
    Label25: TLabel;
    DBDateTimeEditEh2: TDBDateTimeEditEh;
    Label22: TLabel;
    Label18: TLabel;
    wwCheckBox1: TwwCheckBox;
    Label19: TLabel;
    wwDBEdit15: TwwDBEdit;
    Label20: TLabel;
    Label21: TLabel;
    wwDBEdit16: TwwDBEdit;
    wwDBEdit17: TwwDBEdit;
    CDSArea: TClientDataSet;
    CDSTypefid: TAutoIncField;
    CDSTypefcode: TWideStringField;
    CDSTypefname: TWideStringField;
    CDSTypefremark: TWideStringField;
    CDSAreafID: TIntegerField;
    CDSAreafParentID: TIntegerField;
    CDSAreafParentCode: TWideStringField;
    CDSAreafCode: TWideStringField;
    CDSAreafName: TWideStringField;
    CDSAreafNotes: TWideStringField;
    Label23: TLabel;
    wwDBEdit18: TwwDBEdit;
    SpeedButton1: TSpeedButton;
    OpenPictureDialog1: TOpenPictureDialog;
    wwDBEdit19: TwwDBEdit;
    Label24: TLabel;
    SpeedButton2: TSpeedButton;
    procedure FormCreate(Sender: TObject);
    procedure btnSaveClick(Sender: TObject);
    procedure btnsaveaddClick(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmCustomer_M: TfrmCustomer_M;

implementation

uses untCustomer, DataProcess;

{$R *.dfm}

procedure TfrmCustomer_M.FormCreate(Sender: TObject);
begin
  inherited;
  GetsqlData(CDStype,'tRentType','Fid',' fid>0 ',10);
  GetsqlData(CDSArea,'tArea','Fid',' fid>0 ',10);  
  Maintable:='tCustomer';
  MasterField:='fcode';
  ParentForm:=frmCustomer;
end;

procedure TfrmCustomer_M.btnSaveClick(Sender: TObject);
begin
  if trim(wwDBEdit3.text)='' then
    begin
      messagedlg('客户地址不能为空',mtWarning,[mbok],0);
      Exit;
    end;
  if trim(wwDBEdit10.text)='' then
    begin
      messagedlg('客户手机不能为空',mtWarning,[mbok],0);
      Exit;
    end;
  inherited;

end;

procedure TfrmCustomer_M.btnsaveaddClick(Sender: TObject);
begin
  if trim(wwDBEdit3.text)='' then
    begin
      messagedlg('客户地址不能为空',mtWarning,[mbok],0);
      Exit;
    end;
  if trim(wwDBEdit10.text)='' then
    begin
      messagedlg('客户手机不能为空',mtWarning,[mbok],0);
      Exit;
    end;
  inherited;

end;

procedure TfrmCustomer_M.SpeedButton1Click(Sender: TObject);
var
sImgFile:String;
begin
  inherited;
  if OpenPictureDialog1.Execute then
  begin
  sImgFile:=OpenPictureDialog1.FileName ;
  Dataset.FieldByName('fPicture').AsString:=sImgFile;
  end
end;

procedure TfrmCustomer_M.SpeedButton2Click(Sender: TObject);
var
sImgFile:String;
begin
  inherited;
  if OpenPictureDialog1.Execute then
  begin
  sImgFile:=OpenPictureDialog1.FileName ;
  Dataset.FieldByName('fPicture1').AsString:=sImgFile;
  end
end;

end.