unit GetMoney;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, dxBar, dxBarExtItems, StdCtrls, dxCntner, dxEditor, dxExEdtr,
  dxDBEdtr, dxDBELib, DB, ADODB,data, cxControls, cxContainer, cxEdit,
  cxTextEdit, cxMaskEdit, cxDropDownEdit, cxLookupEdit, cxDBLookupEdit,
  dxTL, dxDBCtrl, dxDBGrid, ExtCtrls, dxDBTLCl, dxGrClms, dxEdLib, FR_DSet,
  FR_DBSet, FR_Class, FR_Desgn;

type
  TfrmGetMoney = class(TForm)
    dxBarManager1: TdxBarManager;
    dxBarLargeButton1: TdxBarLargeButton;
    dxBarLargeButton2: TdxBarLargeButton;
    dxBarLargeButton3: TdxBarLargeButton;
    dxBarLargeButton4: TdxBarLargeButton;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    Panel1: TPanel;
    Label2: TLabel;
    cxLookupComboBox1: TcxLookupComboBox;
    Panel2: TPanel;
    DataSource2: TDataSource;
    GroupBox2: TGroupBox;
    dxDBGrid2: TdxDBGrid;
    ADOQuery3: TADOQuery;
    DataSource3: TDataSource;
    dxDBGrid2UnitId: TdxDBGridColumn;
    dxDBGrid2InDate: TdxDBGridDateColumn;
    dxDBGrid2GetMoney: TdxDBGridMaskColumn;
    Label3: TLabel;
    dxEdit1: TdxEdit;
    Label4: TLabel;
    dxEdit2: TdxEdit;
    Label1: TLabel;
    ADOQuery4: TADOQuery;
    Label5: TLabel;
    dxEdit3: TdxEdit;
    dxDBGrid2Column4: TdxDBGridPickColumn;
    dxDBGrid2Column5: TdxDBGridPickColumn;
    dxBarLargeButton5: TdxBarLargeButton;
    Label6: TLabel;
    Edit1: TEdit;
    frReport1: TfrReport;
    frDBDataSet1: TfrDBDataSet;
    dxBarLargeButton6: TdxBarLargeButton;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormDestroy(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure cxLookupComboBox1PropertiesChange(Sender: TObject);
    procedure dxBarLargeButton1Click(Sender: TObject);
    procedure dxBarLargeButton3Click(Sender: TObject);
    procedure dxBarLargeButton4Click(Sender: TObject);
    procedure dxBarLargeButton2Click(Sender: TObject);
    procedure dxBarLargeButton5Click(Sender: TObject);
    procedure ADOQuery3AfterPost(DataSet: TDataSet);
    procedure dxBarLargeButton6Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmGetMoney: TfrmGetMoney;

implementation

{$R *.dfm}

procedure TfrmGetMoney.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
  action:=cafree;
end;

procedure TfrmGetMoney.FormDestroy(Sender: TObject);
begin
  frmGetMoney:=nil;
end;

procedure TfrmGetMoney.FormCreate(Sender: TObject);
begin
  ADOQuery1.Open;
end;

procedure TfrmGetMoney.cxLookupComboBox1PropertiesChange(Sender: TObject);
var stemp:string;
begin
  stemp:=trim(cxLookupComboBox1.Text);
  ADOQuery4.Close;
  ADOQuery4.SQL.Text :='select ClientName from tbClient where ClientId='''+stemp+'''';
  ADOQuery4.Open;
  Edit1.Text:=ADOQuery4.Fields[0].asstring;
  
  ADOQuery3.Close;
  ADOQuery3.SQL.Text:='select * from InMoneys where Unitid='''+stemp+'''';
  ADOQuery3.Open;
  ADOQuery4.Close;
  ADOQuery4.SQL.Text :='select sum(RealMoney) from tbSaleSubs where Unitid='''+stemp+'''';
  ADOQuery4.Open;
  dxEdit1.Text :=ADOQuery4.Fields[0].AsString;
  ADOQuery4.Close;
  ADOQuery4.SQL.Text :='select sum(getmoney) from InMoneys where Unitid='''+stemp+'''';
  ADOQuery4.Open;
  dxEdit2.Text :=ADOQuery4.Fields[0].AsString;
  if (dxEdit1.Text<>'') and (dxEdit2.Text<>'')  then
  dxEdit3.Text:=floattostr(strtofloat(dxEdit1.Text)-strtofloat(dxEdit2.Text));

end;

procedure TfrmGetMoney.dxBarLargeButton1Click(Sender: TObject);
begin
  if trim(cxLookupComboBox1.Text)<>'' then
  begin
    ADOQuery3.Append;
    ADOQuery3.FieldByName('unitid').AsString:=trim(cxLookupComboBox1.Text);
    ADOQuery3.FieldByName('indate').AsString:=formatdatetime('YYYY-MM-DD',now);
  end;
end;

procedure TfrmGetMoney.dxBarLargeButton3Click(Sender: TObject);
begin
  if trim(cxLookupComboBox1.Text)<>'' then
  ADOQuery3.Delete;
end;

procedure TfrmGetMoney.dxBarLargeButton4Click(Sender: TObject);
begin
  close;
end;

procedure TfrmGetMoney.dxBarLargeButton2Click(Sender: TObject);
begin
    if trim(cxLookupComboBox1.Text)<>'' then
  if ADOQuery3.State in dseditmodes then ADOQuery3.Post;
end;

procedure TfrmGetMoney.dxBarLargeButton5Click(Sender: TObject);
begin
  cxLookupComboBox1PropertiesChange(nil);
end;

procedure TfrmGetMoney.ADOQuery3AfterPost(DataSet: TDataSet);
begin
  cxLookupComboBox1PropertiesChange(nil);
end;

procedure TfrmGetMoney.dxBarLargeButton6Click(Sender: TObject);
begin
  if Edit1.Text<>'' then
  begin
    frvariables['uername']:='河北春雨出版社';
    frvariables['ueraddress']:='地址：石家莊友誼大街186號二樓255室';
    frvariables['dwbh']:=cxLookupComboBox1.Text;
    frvariables['dwmc']:=Edit1.Text;
    frvariables['je']:=dxEdit1.Text;
    frvariables['hk']:=dxEdit2.Text;
    frvariables['qk']:=dxEdit3.Text;
    frvariables['date']:=formatdatetime('YYYY-MM-DD',now);
    frvariables['username']:='張小春';
    frReport1.ShowReport;
  end
  else
  begin
    application.MessageBox(pchar('請選擇單位!'),'提示',0);
    exit;
  end;
end;

end.