cekodenen.pas

Basic Marketing stock Program

unit cekodenen;

interface

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

type
  Tcek050 = 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;
    QRBand3: TQRBand;
    QRDBText2: TQRDBText;
    QRDBText1: TQRDBText;
    QRDBText6: TQRDBText;
    QRDBText10: TQRDBText;
    QRDBText3: TQRDBText;
    QRDBText4: TQRDBText;
    QRBand4: TQRBand;
    QRExpr1: TQRExpr;
    QRLabel16: TQRLabel;
    QRLabel7: TQRLabel;
    QRDBText5: TQRDBText;
    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;
    Panel1: TPanel;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Edit2: TEdit;
    Edit1: TEdit;
    DateTimePicker2: TDateTimePicker;
    DateTimePicker1: TDateTimePicker;
    BitBtn1: TBitBtn;
    MaskEdit1: TMaskEdit;
    BitBtn2: TBitBtn;
    BitBtn3: TBitBtn;
    DBGrid1: TDBGrid;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  cek050: Tcek050;

implementation

uses unit1,unitgenel;

{$R *.DFM}

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

procedure Tcek050.BitBtn1Click(Sender: TObject);
Var
toplam: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;
    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 Tcek050.BitBtn3Click(Sender: TObject);
begin
     Qrlabel14.Caption:=Edit1.Text;
     Qrlabel15.Caption:=Edit2.Text;
     Quickrep1.Preview;

end;

procedure Tcek050.BitBtn2Click(Sender: TObject);
begin
        close;
end;

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

end;

end.