customers_unit.pas

货源代理管理系统 同样是DELPHI7下的

unit Customers_Unit;

interface

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

type
  TfrmCustomers = class(TForm)
    Panel1: TPanel;
    btnAdd: TSpeedButton;
    btnModfiy: TSpeedButton;
    btnDel: TSpeedButton;
    btnCancel: TSpeedButton;
    btnSave: TSpeedButton;
    btnClosed: TSpeedButton;
    btnFind: TSpeedButton;
    btnRefresh: TSpeedButton;
    Panel2: TPanel;
    DBGrid1: TDBGrid;
    Panel3: TPanel;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    DBText1: TDBText;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    DBLookupComboBox1: TDBLookupComboBox;
    DBLookupComboBox2: TDBLookupComboBox;
    procedure btnAddClick(Sender: TObject);
    procedure btnModfiyClick(Sender: TObject);
    procedure btnDelClick(Sender: TObject);
    procedure btnCancelClick(Sender: TObject);
    procedure btnSaveClick(Sender: TObject);
    procedure btnClosedClick(Sender: TObject);
    procedure btnFindClick(Sender: TObject);
    procedure btnRefreshClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmCustomers: TfrmCustomers;

implementation

uses ClientDM_Unit;

{$R *.dfm}

procedure TfrmCustomers.btnAddClick(Sender: TObject);
begin
  DM.cdsCustomer.Insert;
  DM.cdsCustomer.FieldByName('CustomerID').AsString :=
     DM.SocketConn.AppServer.GetMaxID('Customers','CustomerID','1000');
end;

procedure TfrmCustomers.btnModfiyClick(Sender: TObject);
begin
  DM.cdsCustomer.Edit;
end;

procedure TfrmCustomers.btnDelClick(Sender: TObject);
begin
  if Application.MessageBox('确定要删除吗?','提示',68) = IDNo then
    Exit;
  DM.cdsCustomer.Delete;
  DM.cdsCustomer.ApplyUpdates(0);
end;

procedure TfrmCustomers.btnCancelClick(Sender: TObject);
begin
  DM.cdsCustomer.Cancel;
end;

procedure TfrmCustomers.btnSaveClick(Sender: TObject);
begin
  if DM.cdsCustomer.State in [dsInsert,dsEdit] then
  begin
    DM.cdsCustomer.Post;
    DM.cdsCustomer.ApplyUpdates(0);
  end;
end;

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

procedure TfrmCustomers.btnFindClick(Sender: TObject);
var
  CustomerBool: Boolean;
  CustomerID: string;
begin
  CustomerID := DBText1.Caption;
  CustomerBool := InputQuery('请输入要查询编号','查询',CustomerID);
  if CustomerBool then
  begin
    DM.cdsCustomer.Filtered := False;
    DM.cdsCustomer.Filter :=' CustomerID=' + QuotedStr(CustomerID);
    DM.cdsCustomer.Filtered := True;
  end;
end;

procedure TfrmCustomers.btnRefreshClick(Sender: TObject);
begin
  DM.cdsCustomer.Filtered := False;
  DM.cdsCustomer.Filter :='';
  DM.cdsCustomer.Filtered := True;
end;

end.