untincomeexpensesmanager.pas

销售软件

(*===========================================================*)
(*                                                           *)
(*              Jerk Computer Assembly Manager               *)
(*                                                           *)
(*                    程序作者：杨芹勍                       *)
(*          武汉科技大学 理学院 信息与计算科学031班          *)
(*                  武汉科技大学 莘特工作室                  *)
(*                                                           *)
(*              IDE：Borland Delphi 2006 Update 2            *)
(*                 第三方控件：Raize 4.03                    *)
(*             数据库：Microsoft SQL Server 2000             *)
(*            数据库访问引擎：原生ADO（ADODB_TLB）           *)
(*           数据库管理引擎：JERK DBMANAGER ALPHA            *)
(*                                                           *)
(*           此软件及源代码归 JERK SYSTEM 版权所有           *)
(*            (C)Copyright 2002-2006 Jerk System.            *)
(*                                                           *)
(*===========================================================*)

unit untIncomeExpensesManager;

interface

uses
  Windows,
  Messages,
  SysUtils,
  Variants,
  Classes,
  Graphics,
  Controls,
  Forms,
  Dialogs,
  ComCtrls,
  ExtCtrls,
  Menus,
  StdCtrls,
  Mask,
  ADODB_TLB,
  RzButton,
  RzBtnEdt,
  RzCmboBx,
  RzEdit,
  RzListVw,
  RzRadChk,
  RzSplit,
  RzPanel,
  RzTabs,
  JSDBListView,
  JCAMConsts,
  JCAMUtils,
  JCAMDialogForm,
  JCAMManagerForm,
  JCAMTableViewEditor;

type
  TfrmIncomeExpensesManager = class( TfrmJCAMManagerForm )
    Label3: TLabel;
    edtNoteDate: TRzDateTimeEdit;
    procedure btnStatInfoClick( Sender: TObject );
  private
    { Private declarations }
  public
    procedure StartSurf; override;
  end;

var
  frmIncomeExpensesManager: TfrmIncomeExpensesManager;

implementation

{$R *.dfm}

uses
  untStatInfo,
  untTField,
  untTIncomeExpenses;

{ TfrmIncomeExpensesManager }

procedure TfrmIncomeExpensesManager.btnStatInfoClick( Sender: TObject );
var
  tf: TTableField;
  tie: TTableIncomeExpenses;
begin
  { 整机管理的统计信息 }

  if frmStatInfo <> nil then
    FreeAndNil( frmStatInfo );
  tf := TTableField.Create;
  tf.Connection := Self.Connection;
  tie := TTableIncomeExpenses.Create;
  tie.Connection := Self.Connection;
  frmStatInfo := TfrmStatInfo.Create( Self );
  with frmStatInfo do
  begin
    with StatListView.Items.Add do
    begin
      tf.FieldName := FN_INCOME;
      Caption := tf.FieldChs;
      ImageIndex := dvwInfoList.DefaultImageIndex;
      SubItems.Add( IntToStr( tie.TotalIncomeByCondition( InfoSearchCondition )
        ) );
    end;
    with StatListView.Items.Add do
    begin
      tf.FieldName := FN_EXPENSES;
      Caption := tf.FieldChs;
      ImageIndex := dvwInfoList.DefaultImageIndex;
      SubItems.Add( IntToStr( tie.TotalExpensesByCondition( InfoSearchCondition )
        ) );
    end;
    with StatListView.Items.Add do
    begin
      tf.FieldName := FN_TOTALINCOMEEXPENSES;
      Caption := tf.FieldChs;
      ImageIndex := dvwInfoList.DefaultImageIndex;
      SubItems.Add( IntToStr( tie.TotalIncomeExpensesByCondition(
        InfoSearchCondition ) ) );
    end;
    ShowModal;
  end;
  FreeAndNil( tie );
  FreeAndNil( tf );
  FreeAndNil( frmStatInfo );
end;

procedure TfrmIncomeExpensesManager.StartSurf;
begin
  inherited;

  SetCustomEditTag( edtNoteDate, FN_NOTEDATE );
end;

end.