trafficbookin_unit.pas

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

unit TrafficBookIn_Unit;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ExtCtrls, ToolWin, ComCtrls, Buttons, StdCtrls, DBCtrls, Mask,
  Grids, DBGrids, DB, RpCon, RpConDS, RpBase, RpSystem, RpDefine, RpRave;

type
  TfrmTrafficBookIn = class(TForm)
    Panel1: TPanel;
    Panel2: TPanel;
    ToolBar1: TToolBar;
    btnModfiy: TSpeedButton;
    btnAdd: TSpeedButton;
    btnDel: TSpeedButton;
    btnCancel: TSpeedButton;
    ToolButton2: TToolButton;
    btnSave: TSpeedButton;
    btnClosed: TSpeedButton;
    ToolButton3: TToolButton;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label9: TLabel;
    DBEdit1: TDBEdit;
    DBLookupComboBox1: TDBLookupComboBox;
    DBText1: TDBText;
    DBLookupComboBox2: TDBLookupComboBox;
    DBEdit2: TDBEdit;
    DBLookupComboBox3: TDBLookupComboBox;
    DBLookupComboBox4: TDBLookupComboBox;
    DBEdit3: TDBEdit;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    GroupBox1: TGroupBox;
    Label10: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    Label13: TLabel;
    Label14: TLabel;
    DBEdit5: TDBEdit;
    DBComboBox1: TDBComboBox;
    DBEdit6: TDBEdit;
    DBEdit7: TDBEdit;
    DBComboBox2: TDBComboBox;
    DBGrid1: TDBGrid;
    btnPrint: TSpeedButton;
    ToolButton4: TToolButton;
    SpeedButton3: TSpeedButton;
    btnRefesh: TSpeedButton;
    btnFrist: TSpeedButton;
    btnLast: TSpeedButton;
    btnNext: TSpeedButton;
    btnPrevious: TSpeedButton;
    Panel3: TPanel;
    btnAddRow: TSpeedButton;
    btnDelRow: TSpeedButton;
    ToolButton1: TToolButton;
    RvProject1: TRvProject;
    RvSystem1: TRvSystem;
    RvDataSetConnection1: TRvDataSetConnection;
    RvDataSetConnection2: TRvDataSetConnection;
    procedure SpeedButton1Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure btnClosedClick(Sender: TObject);
    procedure btnAddClick(Sender: TObject);
    procedure btnModfiyClick(Sender: TObject);
    procedure btnCancelClick(Sender: TObject);
    procedure btnSaveClick(Sender: TObject);
    procedure btnAddRowClick(Sender: TObject);
    procedure btnDelRowClick(Sender: TObject);
    procedure SpeedButton3Click(Sender: TObject);
    procedure btnDelClick(Sender: TObject);
    procedure btnPreviousClick(Sender: TObject);
    procedure btnLastClick(Sender: TObject);
    procedure btnFristClick(Sender: TObject);
    procedure btnNextClick(Sender: TObject);
    procedure btnRefeshClick(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure btnPrintClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmTrafficBookIn: TfrmTrafficBookIn;

implementation

uses DateChoice_Unit, ClientDM_Unit;

{$R *.dfm}

procedure TfrmTrafficBookIn.btnAddClick(Sender: TObject);
begin
  with DM.cdsShippingHeader do
  begin
    if State in [dsInsert] then Exit;
    Insert;
    FieldByName('ShippingNumber').AsString :=
      DM.SocketConn.AppServer.GetMaxID('ShippingBillHeader','ShippingNumber',FormatDateTime('yyyymm',Now)+'1000');
  end;
end;

procedure TfrmTrafficBookIn.btnModfiyClick(Sender: TObject);
begin
  DM.cdsShippingHeader.Edit;
end;

procedure TfrmTrafficBookIn.btnCancelClick(Sender: TObject);
begin
  DM.cdsShippingHeader.Cancel;
end;

procedure TfrmTrafficBookIn.btnSaveClick(Sender: TObject);
begin          //保存提交数据
  with DM.cdsShippingHeader do
  begin
    if (ChangeCount > 0) or (State in [dsEdit]) then
    begin
      ApplyUpdates(-1);
      Dm.cdsShippingBody.ApplyUpdates(-1);
      DM.SocketConn.AppServer.GetItems(DBText1.Caption,FieldByName('NextItemID').AsString);
    end;
  end;
end;

procedure TfrmTrafficBookIn.btnAddRowClick(Sender: TObject);
begin
  DM.cdsShippingBody.Append;
  DM.cdsShippingBody.FieldByName('ShippingNumber').AsString := DBText1.Caption;
end;

procedure TfrmTrafficBookIn.btnDelRowClick(Sender: TObject);
begin
  if Application.MessageBox('确定要删除此条信息?','提示',68) = IDNo then Exit;
  begin
    DM.cdsShippingBody.Delete;
    DM.cdsShippingBody.ApplyUpdates(-1);
  end;
end;


procedure TfrmTrafficBookIn.btnDelClick(Sender: TObject);
begin
  if Application.MessageBox('确定要删除此订单吗?','提示',68) = IDNo then Exit;
  DM.cdsShippingBody.Delete;
  DM.cdsShippingBody.ApplyUpdates(-1);
  DM.cdsShippingHeader.Delete;
  DM.cdsShippingHeader.ApplyUpdates(-1);  
end;

procedure TfrmTrafficBookIn.btnPreviousClick(Sender: TObject);
begin
  if Not DM.cdsShippingHeader.Bof then
    DM.cdsShippingHeader.Prior;
end;

procedure TfrmTrafficBookIn.btnLastClick(Sender: TObject);
begin
  DM.cdsShippingHeader.Last;
end;

procedure TfrmTrafficBookIn.btnFristClick(Sender: TObject);
begin
  DM.cdsShippingHeader.First;
end;

procedure TfrmTrafficBookIn.btnNextClick(Sender: TObject);
begin
  if not DM.cdsShippingHeader.Eof then
    DM.cdsShippingHeader.Next;
end;

procedure TfrmTrafficBookIn.btnRefeshClick(Sender: TObject);
begin
  DM.cdsShippingHeader.Refresh;
end;

procedure TfrmTrafficBookIn.btnPrintClick(Sender: TObject);
begin
  RvProject1.ProjectFile := 'ShippingReport.rav';
  RvProject1.Execute;
end;

procedure TfrmTrafficBookIn.FormShow(Sender: TObject);
begin
  with DM.cdsShippingHeader do
  begin
    ACtive := False;
    ACtive := True;
  end;
  with DM.cdsShippingBody do
  begin
    ACtive := False;
    ACtive := True;
  end;
end;

procedure TfrmTrafficBookIn.SpeedButton3Click(Sender: TObject);
var
  GetNumber: Boolean;
  Number: string;
begin
  with DM.cdsShippingHeader do
  begin
    Number := DBText1.Caption;
    Getnumber := InputQuery('查询','输入要查询的单号',Number);
    if GetNumber then
    begin
      Filtered := False;
      Filter := ' ShippingNumber=' + QuotedStr(Number);
      Filtered := True;
    end;
  end;
end;

procedure TfrmTrafficBookIn.SpeedButton1Click(Sender: TObject);
begin
  Flag := 2;
  frmDateChoice := TfrmDateChoice.Create(Self);
  try
    frmDateChoice.ShowModal;
  finally
    frmDateChoice.Free;
  end;
end;

procedure TfrmTrafficBookIn.SpeedButton2Click(Sender: TObject);
begin
  Flag := 3;
  frmDateChoice := TfrmDateChoice.Create(Self);
  try
    frmDateChoice.ShowModal;
  finally
    frmDateChoice.Free;
  end;
end;

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

end.