vcekodmrpt.pas

Basic Marketing stock Program

unit vcekodmrpt;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  Grids, DBGrids, Mask, StdCtrls, Buttons, ComCtrls, ExtCtrls, Db,
  DBTables, Qrctrls, QuickRpt;

type
  Tvcek030 = class(TForm)
    QuickRep1: TQuickRep;
    QRBand1: TQRBand;
    QRLabel1: TQRLabel;
    QRLabel14: TQRLabel;
    QRLabel15: TQRLabel;
    QRLabel6: TQRLabel;
    QRBand2: TQRBand;
    QRLabel2: TQRLabel;
    QRLabel3: TQRLabel;
    QRLabel5: TQRLabel;
    QRLabel9: TQRLabel;
    QRShape1: TQRShape;
    QRLabel4: TQRLabel;
    QRLabel7: TQRLabel;
    QRBand3: TQRBand;
    QRDBText2: TQRDBText;
    QRDBText1: TQRDBText;
    QRDBText6: TQRDBText;
    QRDBText10: TQRDBText;
    QRDBText3: TQRDBText;
    QRDBText4: TQRDBText;
    QRDBText5: TQRDBText;
    QRBand4: TQRBand;
    QRExpr1: TQRExpr;
    QRLabel16: TQRLabel;
    Query1: TQuery;
    Query1SIRKOD: TStringField;
    Query1SNO: TIntegerField;
    Query1CEKNO: TStringField;
    Query1ATAR: TDateField;
    Query1MUSNO: TFloatField;
    Query1FIRADI: TStringField;
    Query1VADE: TDateField;
    Query1TAHSIL: TDateField;
    Query1TIP: TStringField;
    Query1BANKA: TStringField;
    Query1SUBE: TStringField;
    Query1TUTAR: TFloatField;
    DataSource1: TDataSource;
    Panel2: TPanel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    DateTimePicker2: TDateTimePicker;
    DateTimePicker1: TDateTimePicker;
    BitBtn4: TBitBtn;
    MaskEdit1: TMaskEdit;
    BitBtn5: TBitBtn;
    BitBtn6: TBitBtn;
    DBGrid1: TDBGrid;
    tum: TCheckBox;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormShow(Sender: TObject);
    procedure BitBtn4Click(Sender: TObject);
    procedure BitBtn6Click(Sender: TObject);
    procedure BitBtn5Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  vcek030: Tvcek030;

implementation

uses unit1,unitgenel;

{$R *.DFM}

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

procedure Tvcek030.FormShow(Sender: TObject);
begin
      DateTimePicker1.Date:=Date;
      DateTimePicker2.Date:=Date;

end;

procedure Tvcek030.BitBtn4Click(Sender: TObject);
Var
toplam:Currency;
begin
    Edit1.Text:=DateToStr(DateTimePicker1.Date);
    Edit2.Text:=DateToStr(DateTimePicker2.Date);
    Query1.Close;
    Query1.ParamByName( 'XSIRKOD' ).Text :=sb.sirkod;
    if tum.Checked=true then
      Begin
        Query1.ParamByName( 'TAR' ).Text :='01.01.2001';
        Query1.ParamByName( 'TAR1' ).Text:='31.12.2099';
      end;
    if tum.Checked=false then
      Begin
        Query1.ParamByName( 'TAR' ).Text :=Edit1.Text;
        Query1.ParamByName( 'TAR1' ).Text :=Edit2.Text;
      end;
    Query1.Prepare;
    Query1.Open;
    toplam:=0;
    MaskEdit1.Text:='';
    Query1.First;
     While not Query1.EOF
     do begin
       toplam:=toplam + Query1TUTAR.AsCurrency;
       Query1.Next;
     end;
      MaskEdit1.Text:=FloatToStr(toplam);

end;

procedure Tvcek030.BitBtn6Click(Sender: TObject);
begin
     Qrlabel14.Caption:=Edit1.Text;
     Qrlabel15.Caption:=Edit2.Text;
     Quickrep1.Preview;

end;

procedure Tvcek030.BitBtn5Click(Sender: TObject);
begin
        CLOSE;
end;

end.