vcekvaderpt.pas
上传用户:hbycfrp
上传日期:2014-09-15
资源大小:603k
文件大小:3k
源码类别:

Delphi控件源码

开发平台:

Delphi

  1. unit vcekvaderpt;
  2. interface
  3. uses
  4.   Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  5.   Mask, StdCtrls, Buttons, ComCtrls, ExtCtrls, Db, DBTables, Grids, DBGrids,
  6.   Qrctrls, QuickRpt;
  7. type
  8.   Tvcek040 = class(TForm)
  9.     DBGrid1: TDBGrid;
  10.     Query1: TQuery;
  11.     Query1SIRKOD: TStringField;
  12.     Query1SNO: TIntegerField;
  13.     Query1CEKNO: TStringField;
  14.     Query1ATAR: TDateField;
  15.     Query1MUSNO: TFloatField;
  16.     Query1FIRADI: TStringField;
  17.     Query1VADE: TDateField;
  18.     Query1TAHSIL: TDateField;
  19.     Query1TIP: TStringField;
  20.     Query1BANKA: TStringField;
  21.     Query1SUBE: TStringField;
  22.     Query1TUTAR: TFloatField;
  23.     DataSource1: TDataSource;
  24.     Panel1: TPanel;
  25.     Label1: TLabel;
  26.     Label2: TLabel;
  27.     Label3: TLabel;
  28.     Edit2: TEdit;
  29.     Edit1: TEdit;
  30.     DateTimePicker2: TDateTimePicker;
  31.     DateTimePicker1: TDateTimePicker;
  32.     BitBtn1: TBitBtn;
  33.     MaskEdit1: TMaskEdit;
  34.     BitBtn2: TBitBtn;
  35.     BitBtn3: TBitBtn;
  36.     Quickrep1: TQuickRep;
  37.     QRBand1: TQRBand;
  38.     QRLabel1: TQRLabel;
  39.     QRLabel14: TQRLabel;
  40.     QRLabel15: TQRLabel;
  41.     QRLabel6: TQRLabel;
  42.     QRBand2: TQRBand;
  43.     QRLabel2: TQRLabel;
  44.     QRLabel3: TQRLabel;
  45.     QRLabel5: TQRLabel;
  46.     QRLabel9: TQRLabel;
  47.     QRShape1: TQRShape;
  48.     QRLabel4: TQRLabel;
  49.     QRLabel7: TQRLabel;
  50.     QRBand3: TQRBand;
  51.     QRDBText2: TQRDBText;
  52.     QRDBText1: TQRDBText;
  53.     QRDBText6: TQRDBText;
  54.     QRDBText10: TQRDBText;
  55.     QRDBText3: TQRDBText;
  56.     QRDBText4: TQRDBText;
  57.     QRDBText5: TQRDBText;
  58.     QRBand4: TQRBand;
  59.     QRExpr1: TQRExpr;
  60.     QRLabel16: TQRLabel;
  61.     procedure BitBtn2Click(Sender: TObject);
  62.     procedure FormClose(Sender: TObject; var Action: TCloseAction);
  63.     procedure BitBtn1Click(Sender: TObject);
  64.     procedure BitBtn3Click(Sender: TObject);
  65.     procedure FormShow(Sender: TObject);
  66.   private
  67.     { Private declarations }
  68.   public
  69.     { Public declarations }
  70.   end;
  71. var
  72.   vcek040: Tvcek040;
  73. implementation
  74. uses unit1,unitgenel;
  75. {$R *.DFM}
  76. procedure Tvcek040.BitBtn2Click(Sender: TObject);
  77. begin
  78.       close;
  79. end;
  80. procedure Tvcek040.FormClose(Sender: TObject; var Action: TCloseAction);
  81. begin
  82.         action:=cafree;
  83. end;
  84. procedure Tvcek040.BitBtn1Click(Sender: TObject);
  85. Var
  86. toplam:Currency;
  87. begin
  88.     Edit1.Text:=DateToStr(DateTimePicker1.Date);
  89.     Edit2.Text:=DateToStr(DateTimePicker2.Date);
  90.     Query1.Close;
  91.     Query1.ParamByName( 'XSIRKOD' ).Text :=sb.sirkod;
  92.     Query1.ParamByName( 'TAR' ).Text :=Edit1.Text;
  93.     Query1.ParamByName( 'TAR1' ).Text :=Edit2.Text;
  94.     Query1.Prepare;
  95.     Query1.Open;
  96.     toplam:=0;
  97.     MaskEdit1.Text:='';
  98.     Query1.First;
  99.      While not Query1.EOF
  100.      do begin
  101.        toplam:=toplam + Query1TUTAR.AsCurrency;
  102.        Query1.Next;
  103.      end;
  104.       MaskEdit1.Text:=FloatToStr(toplam);
  105. end;
  106. procedure Tvcek040.BitBtn3Click(Sender: TObject);
  107. begin
  108.      Qrlabel14.Caption:=Edit1.Text;
  109.      Qrlabel15.Caption:=Edit2.Text;
  110.      Quickrep1.Preview;
  111. end;
  112. procedure Tvcek040.FormShow(Sender: TObject);
  113. begin
  114.       DateTimePicker1.Date:=Date;
  115.       DateTimePicker2.Date:=Date;
  116. end;
  117. end.