customerbooking_unit.pas

客户关系管理系统 DELPHI7下的

unit CustomerBooking_Unit;

interface

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

type
  TfrmCustomerBooking = class(TForm)
    Label1: TLabel;
    Label2: TLabel;
    DBEdit2: TDBEdit;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    DBEdit7: TDBEdit;
    Label8: TLabel;
    DBEdit8: TDBEdit;
    Label9: TLabel;
    DBEdit9: TDBEdit;
    Label10: TLabel;
    DBEdit10: TDBEdit;
    DBText1: TDBText;
    DBComboBox1: TDBComboBox;
    DBLookupComboBox1: TDBLookupComboBox;
    DBLookupComboBox3: TDBLookupComboBox;
    DBCheckBox1: TDBCheckBox;
    SpeedButton2: TSpeedButton;
    btnAdd: TBitBtn;
    btnDel: TBitBtn;
    btnSave: TBitBtn;
    btnFind: TBitBtn;
    btnRefresh: TBitBtn;
    DBGrid1: TDBGrid;
    DBEdit1: TDBEdit;
    SpeedButton3: TSpeedButton;
    btnCancel: TBitBtn;
    btnClosed: TBitBtn;
    Panel1: TPanel;
    GroupBox1: TGroupBox;
    procedure btnFindClick(Sender: TObject);
    procedure btnAddClick(Sender: TObject);
    procedure btnDelClick(Sender: TObject);
    procedure btnRefreshClick(Sender: TObject);
    procedure btnSaveClick(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure SpeedButton3Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure btnCancelClick(Sender: TObject);
    procedure btnClosedClick(Sender: TObject);
    procedure DBGrid1DrawColumnCell(Sender: TObject; const Rect: TRect;
      DataCol: Integer; Column: TColumn; State: TGridDrawState);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmCustomerBooking: TfrmCustomerBooking;

implementation

uses DM_Unit, DataChoice_Unit;

{$R *.dfm}

procedure TfrmCustomerBooking.btnFindClick(Sender: TObject);
var
  BookBool: Boolean;
  BookID: string;
begin
  BookID := DBText1.Caption;
  BookBool := InputQuery('查询','输入要查询的编号',BookID);
  if BookBool then
  begin
    with DM.cdsCustomerBooking do
    begin
      Filtered := False;
      Filter := ' ID=' + QUotedStr(BookID);
      Filtered := True;
    end;
  end;
end;

procedure TfrmCustomerBooking.btnAddClick(Sender: TObject);
begin
  DM.DataSetInsert(DM.cdsCustomerBooking);
  DM.cdsCustomerBooking.FieldByName('ID').AsString := DM.GenerateNumber('CustomerBooking','ID');
 // DBText1.Caption := DM.GenerateNumber('CustomerBooking','ID');
end;

procedure TfrmCustomerBooking.btnDelClick(Sender: TObject);
begin
  DM.DataSetDelete(DM.cdsCustomerBooking);
end;

procedure TfrmCustomerBooking.btnRefreshClick(Sender: TObject);
begin
  with DM.cdsCustomerBooking do
  begin
    Filtered := False;
    Filter := '';
    Filtered := True;
  end;
end;

procedure TfrmCustomerBooking.btnSaveClick(Sender: TObject);
begin
  DM.DataSetSave(DM.cdsCustomerBooking);
end;

procedure TfrmCustomerBooking.SpeedButton2Click(Sender: TObject);
begin
  Flag := 1;
  frmDataChoice := TfrmDataChoice.Create(Self);
  try
    frmDataChoice.ShowModal;
  finally
    frmDataChoice.Free;
  end;
end;

procedure TfrmCustomerBooking.SpeedButton3Click(Sender: TObject);
begin
  Flag := 2;
  frmDataChoice := TfrmDataChoice.Create(Self);
  try
    frmDataChoice.ShowModal;
  finally
    frmDataChoice.Free;
  end;
end;

procedure TfrmCustomerBooking.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
  Action := caFree;
  frmCustomerBooking := nil;
end;

procedure TfrmCustomerBooking.btnCancelClick(Sender: TObject);
begin
  DM.DataSetCancel(DM.cdsCustomerBooking);
end;

procedure TfrmCustomerBooking.btnClosedClick(Sender: TObject);
begin
  Close;
end;

procedure TfrmCustomerBooking.DBGrid1DrawColumnCell(Sender: TObject;
  const Rect: TRect; DataCol: Integer; Column: TColumn;
  State: TGridDrawState);
begin
  if DBGrid1.DataSource.DataSet.FieldByName('REMINDTIME').AsString = DateToStr(Date) then
  begin
    DBGrid1.Canvas.Brush.Color := clRed;
    DBGrid1.DefaultDrawColumnCell(Rect, DataCol, Column, State);
  end;
end;

end.