untvip_m.pas

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

unit untVIP_M;

interface

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

type
  TfrmVIP_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;
    Label24: TLabel;
    wwDBEdit20: TwwDBEdit;
    Label26: TLabel;
    wwDBEdit21: TwwDBEdit;
    Label27: TLabel;
    wwDBLookupCombo3: TwwDBLookupCombo;
    CDSVIP: TClientDataSet;
    CDSVIPftype: TStringField;
    SpeedButton1: TSpeedButton;
    Label28: TLabel;
    wwDBEdit19: TwwDBEdit;
    SpeedButton2: TSpeedButton;
    OpenPictureDialog1: TOpenPictureDialog;
    procedure FormCreate(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure btnSaveClick(Sender: TObject);
    procedure btnsaveaddClick(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
  private
    procedure CreateVipData;
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmVIP_M: TfrmVIP_M;

implementation

uses DataProcess, untVIP, Global, untCustomerSearch;

{$R *.dfm}

procedure TfrmVIP_M.CreateVipData;
begin
  CDSvip.Close;
  CDSVip.FieldDefs.Add('ftype',ftString,20);
  CDSvip.CreateDataSet;
  CDSVip.AppendRecord(['金卡']);
  CDSVip.AppendRecord(['银卡']);
  CDSVip.AppendRecord(['储值卡']);
  CDSVip.AppendRecord(['会员卡']);
  CDSVip.open;
end;

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

procedure TfrmVIP_M.FormShow(Sender: TObject);
begin
  inherited;
  CreateVipData;
end;

procedure TfrmVIP_M.btnSaveClick(Sender: TObject);
begin
  if Trim(wwDBEdit18.Text) = '' then
    begin
      messagedlg('会员卡号不能为空 ！ ',mtWarning,[mbok],0);
      Exit;
    end;
  inherited;

end;

procedure TfrmVIP_M.btnsaveaddClick(Sender: TObject);
begin
  if Trim(wwDBEdit18.Text) = '' then
    begin
      messagedlg('会员卡号不能为空 ！ ',mtWarning,[mbok],0);
      Exit;
    end;
  inherited;

end;

procedure TfrmVIP_M.SpeedButton1Click(Sender: TObject);
var
  SearchCDS:TclientDataset;
begin
  inherited;
  openModalForm(TfrmCustomerSearch,self,tForm(frmCustomerSearch));
  if SearchReturnID=0 then
    Exit;

  if CISUnique('tVip','fCustomerID',Inttostr(SearchReturnID)) then
    begin
      messagedlg('当前客户已存在于VIP资料中 ! ',mtWarning,[mbok],0);
      Exit;
    end;

  try
    SearchCDS:=Tclientdataset.create(nil);
    Searchcds.FetchOnDemand:=False;
    GetsqlData(SearchCDS,'tcustomer','fid','fid='+vartosql(SearchReturnID),1);
    if SearchCDS.RecordCount > 0 then
      begin
        with Dataset do
          begin
            Fieldbyname('fcode').AsString:=SearchCDS.fieldbyname('fcode').asstring;
            Fieldbyname('fName').AsString:=SearchCDS.fieldbyname('fName').asstring;
            Fieldbyname('fFullName').AsString:=SearchCDS.fieldbyname('fFullName').asstring;
            Fieldbyname('fEname').AsString:=SearchCDS.fieldbyname('fEname').asstring;
            Fieldbyname('fArea').AsString:=SearchCDS.fieldbyname('fArea').asstring;
            Fieldbyname('fCustomerType').AsString:=SearchCDS.fieldbyname('fCustomerType').asstring;
            Fieldbyname('fAddress').AsString:=SearchCDS.fieldbyname('fAddress').asstring;
            Fieldbyname('fPost').AsString:=SearchCDS.fieldbyname('fPost').asstring;
            Fieldbyname('fTel').AsString:=SearchCDS.fieldbyname('fTel').asstring;
            Fieldbyname('fMobile').AsString:=SearchCDS.fieldbyname('fMobile').asstring;
            Fieldbyname('fFax').AsString:=SearchCDS.fieldbyname('fFax').asstring;
            Fieldbyname('fIdno').AsString:=SearchCDS.fieldbyname('fIdno').asstring;
            Fieldbyname('fDriveIdno').AsString:=SearchCDS.fieldbyname('fDriveIdno').asstring;
            Fieldbyname('fPosition').AsString:=SearchCDS.fieldbyname('fPosition').asstring;
            Fieldbyname('fEmail').AsString:=SearchCDS.fieldbyname('fEmail').asstring;
            Fieldbyname('fTax').AsString:=SearchCDS.fieldbyname('fTax').asstring;
            Fieldbyname('fBank').AsString:=SearchCDS.fieldbyname('fBank').asstring;
            Fieldbyname('fBankNo').AsString:=SearchCDS.fieldbyname('fBankNo').asstring;
            Fieldbyname('fStartDate').AsDateTime:=SearchCDS.fieldbyname('fStartDate').AsDateTime;
            Fieldbyname('fState').AsBoolean:=SearchCDS.fieldbyname('fState').AsBoolean; 
            Fieldbyname('fRemark').AsString:=SearchCDS.fieldbyname('fRemark').asstring;
            Fieldbyname('fCustomerID').AsInteger:=SearchCDS.fieldbyname('fID').AsInteger;             
          end;
      end;
  finally
    SearchCDS.Close;
    Searchcds.Free;
  end;
end;

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

end.