unitkasagircikrpt.pas

Basic Marketing stock Program

unit Unitkasagircikrpt;

interface

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

type
  Tkasagircikrpt = class(TForm)
    DBGrid1: TDBGrid;
    Panel1: TPanel;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Edit2: TEdit;
    Edit1: TEdit;
    DateTimePicker2: TDateTimePicker;
    DateTimePicker1: TDateTimePicker;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    BitBtn3: TBitBtn;
    Query1: TQuery;
    DataSource1: TDataSource;
    girtoplam: TMoneyEdit;
    ciktoplam: TMoneyEdit;
    Label4: TLabel;
    QuickRep1: TQuickRep;
    QRBand1: TQRBand;
    QRLabel1: TQRLabel;
    QRLabel14: TQRLabel;
    QRLabel15: TQRLabel;
    QRBand2: TQRBand;
    QRLabel2: TQRLabel;
    QRLabel3: TQRLabel;
    QRLabel5: TQRLabel;
    QRLabel9: TQRLabel;
    QRShape1: TQRShape;
    QRBand3: TQRBand;
    QRDBText2: TQRDBText;
    QRDBText1: TQRDBText;
    QRDBText6: TQRDBText;
    QRDBText10: TQRDBText;
    QRBand4: TQRBand;
    QRLabel16: TQRLabel;
    QRLabel4: TQRLabel;
    QRDBText3: TQRDBText;
    QRLabel6: TQRLabel;
    QRLabel7: TQRLabel;
    QRLabel8: TQRLabel;
    QRShape2: TQRShape;
    QRShape3: TQRShape;
    Label5: TLabel;
    bakiye: TMoneyEdit;
    QRLabel10: TQRLabel;
    QRLabel11: TQRLabel;
    QRSysData1: TQRSysData;
    QRLabel12: TQRLabel;
    Query1SIRKOD: TStringField;
    Query1KASAFISNO: TFloatField;
    Query1KASATARIH: TDateField;
    Query1KASAACIKLAMA: TStringField;
    Query1KASAISLEM: TStringField;
    Query1KASATUTAR: TFloatField;
    kasat: TdxMemData;
    kasatFISNO: TIntegerField;
    kasatTARIH: TDateField;
    kasatACIKLAMA: TStringField;
    kasatGTUTAR: TFloatField;
    kasatCTUTAR: TCurrencyField;
    procedure BitBtn1Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure DateTimePicker1Change(Sender: TObject);
    procedure DateTimePicker2Change(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  kasagircikrpt: Tkasagircikrpt;

implementation

uses unit1,unitgenel;


{$R *.DFM}

procedure Tkasagircikrpt.BitBtn1Click(Sender: TObject);
Var
girtop,ciktop:Currency;
begin
    Edit1.Text:=DateToStr(DateTimePicker1.Date);
    Edit2.Text:=DateToStr(DateTimePicker2.Date);
    Query1.Close;
    Query1.ParamByName( 'XSIRKOD' ).Text :=sb.sirkod;
    Query1.ParamByName( 'TAR' ).Text :=Edit1.Text;
    Query1.ParamByName( 'TAR1' ).Text :=Edit2.Text;
    Query1.Prepare;
    Query1.Open;
    girtop:=0;
    ciktop:=0;
    girtoplam.TextAsFloat:=0;
    ciktoplam.TextAsFloat:=0;
    kasat.close;
    kasat.Open;
    Query1.First;
     While not Query1.EOF
     do begin
       if Query1KASAISLEM.Text='G軷蒉' then
         Begin
           kasat.append;
           kasat.edit;
           kasatFISNO.Value:=query1KASAFISNO.AsInteger;
           kasatTARIH.Value:=query1KASATARIH.value;
           kasatACIKLAMA.Value:=query1KASAACIKLAMA.Value;
           kasatGTUTAR.Value:=query1KASATUTAR.Value;
           kasat.post;
           girtop:=girtop + Query1KASATUTAR.AsCurrency;
           girtoplam.TextAsFloat:=girtop;
         End;
       if Query1KASAISLEM.Text='荌KI