uconnact.pas

是个办公系统,可以实现财务上的管理和人员的流动

unit Uconnact;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, ExtCtrls, Buttons, ComCtrls, Mask, DBCtrls;

type
  TfrmContact = class(TForm)
    GroupBox1: TGroupBox;
    Label3: TLabel;
    Label1: TLabel;
    Label4: TLabel;
    Label2: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label21: TLabel;
    Label22: TLabel;
    Label23: TLabel;
    Label24: TLabel;
    Label25: TLabel;
    Label26: TLabel;
    bbtnSave: TBitBtn;
    bbtnReset: TBitBtn;
    bbtnQuit: TBitBtn;
    Label7: TLabel;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    DBEdit5: TDBEdit;
    DBEdit6: TDBEdit;
    DBEdit7: TDBEdit;
    DBEdit8: TDBEdit;
    DBComboBox1: TDBComboBox;
    DBComboBox2: TDBComboBox;
    DBMemo1: TDBMemo;
    DateTimePicker1: TDateTimePicker;
    DateTimePicker2: TDateTimePicker;
    procedure bbtnResetClick(Sender: TObject);
    procedure bbtnSaveClick(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure bbtnQuitClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmContact: TfrmContact;

implementation

uses MyData;

{$R *.dfm}

procedure TfrmContact.bbtnResetClick(Sender: TObject);
begin
  dm.ATContact.Edit;
  DBEdit4.Text:=FormatDateTime('YYYY-MM-DD',Date);
end;

procedure TfrmContact.bbtnSaveClick(Sender: TObject);
begin
 dm.ATContact.Edit;
 with dm.AQCustInfo do
  begin
   close;
   sql.Clear;
   sql.Add('update Customers set OrderDate='''+FormatDateTime('YYYY-MM-DD',DateTimePicker1.Date)+'''');
   sql.Add('where Cusname='''+Trim(DBEdit2.Text)+'''');
   ExecSQL;
  end;
 dm.ATContact.FieldByName('FinishDate').AsDateTime:=StrToDate(FormatDateTime('YYYY-MM-DD',DateTimePicker2.Date));
 dm.ATContact.Post;
 ShowMessage('该项目已签订了合同，请注意下次预约日期！');
end;

procedure TfrmContact.FormShow(Sender: TObject);
begin
  DateTimePicker1.Date:=Date;
  DateTimePicker2.Date:=Date;
  DBEdit4.Text:=FormatDateTime('YYYY-MM-DD',Date);
end;

procedure TfrmContact.bbtnQuitClick(Sender: TObject);
begin
  close;
end;

end.