📄 uform_user_rep.pas
字号:
unit Uform_user_rep;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, QRCtrls, QuickRpt, StdCtrls, Buttons, ComCtrls, DB, ADODB,
ImgList, ExtCtrls;
type
Tform_user_rep = class(TForm)
Panel1: TPanel;
Image1: TImage;
Label2: TLabel;
Label1: TLabel;
Bevel1: TBevel;
Image2: TImage;
Label3: TLabel;
Label4: TLabel;
Label5: TLabel;
Label6: TLabel;
Label7: TLabel;
Label8: TLabel;
Label9: TLabel;
Label10: TLabel;
Label11: TLabel;
Label12: TLabel;
Label13: TLabel;
Label14: TLabel;
Label15: TLabel;
Label16: TLabel;
Label17: TLabel;
Label18: TLabel;
Label19: TLabel;
Label20: TLabel;
Bevel2: TBevel;
Label22: TLabel;
Label23: TLabel;
Label24: TLabel;
Label21: TLabel;
ImageList1: TImageList;
recordset_temp3: TADOQuery;
recordset_temp2: TADOQuery;
recordset_temp: TADOQuery;
Panel2: TPanel;
ListView1: TListView;
Panel3: TPanel;
Panel4: TPanel;
BitBtn3: TBitBtn;
BitBtn2: TBitBtn;
BitBtn1: TBitBtn;
BitBtn4: TBitBtn;
BitBtn5: TBitBtn;
Panel5: TPanel;
QuickRep1: TQuickRep;
ColumnHeaderBand1: TQRBand;
QRShape5: TQRShape;
QRShape6: TQRShape;
QRShape7: TQRShape;
QRShape8: TQRShape;
QRShape9: TQRShape;
QRShape10: TQRShape;
QRLabel1: TQRLabel;
QRLabel2: TQRLabel;
QRLabel4: TQRLabel;
QRLabel6: TQRLabel;
QRLabel7: TQRLabel;
QRLabel5: TQRLabel;
QRLabel8: TQRLabel;
QRShape15: TQRShape;
QRShape11: TQRShape;
QRLabel9: TQRLabel;
QRLabel10: TQRLabel;
QRShape17: TQRShape;
QRLabel3: TQRLabel;
DetailBand1: TQRBand;
QRShape1: TQRShape;
QRShape2: TQRShape;
QRShape3: TQRShape;
QRShape4: TQRShape;
QRShape12: TQRShape;
QRShape13: TQRShape;
QRShape14: TQRShape;
QRShape16: TQRShape;
QRShape18: TQRShape;
QRDBText1: TQRDBText;
QRDBText2: TQRDBText;
QRDBText3: TQRDBText;
QRDBText4: TQRDBText;
QRDBText5: TQRDBText;
QRDBText6: TQRDBText;
QRDBText7: TQRDBText;
QRDBText8: TQRDBText;
QRDBText9: TQRDBText;
PageFooterBand1: TQRBand;
SummaryBand1: TQRBand;
PageHeaderBand1: TQRBand;
TitleBand1: TQRBand;
QRLabel11: TQRLabel;
procedure FormShow(Sender: TObject);
procedure BitBtn2Click(Sender: TObject);
procedure BitBtn1Click(Sender: TObject);
procedure BitBtn3Click(Sender: TObject);
procedure ListView1Click(Sender: TObject);
procedure ListView1DblClick(Sender: TObject);
procedure BitBtn4Click(Sender: TObject);
procedure BitBtn5Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
sdate:tdate;
edate:tdate;
smoney:integer;
emoney:integer;
end;
var
form_user_rep: Tform_user_rep;
implementation
uses Uform_main, Uform_xf_limit, Uform_ljxf_one;
{$R *.dfm}
procedure Tform_user_rep.FormShow(Sender: TObject);
begin
label22.Caption :='';
label24.Caption :='';
label4.Caption :='' ;
label5.Caption :='';
label7.Caption :='';
label10.Caption :='';
label12.Caption :='';
label14.Caption :='';
label15.Caption :='';
label17.Caption :='';
label19.Caption :='';
form_main.Dconnect.Execute('delete * from [LE]');
listview1.Clear ;
end;
procedure Tform_user_rep.BitBtn2Click(Sender: TObject);
var
i:integer;
ListItem: TListItem;
p:^integer;
mm:real;
begin
recordset_temp3.Close ;
form_xf_limit.ShowModal ;
if form_xf_limit.yesno =false then
begin
exit;
end;
form_main.Dconnect.Execute('delete * from [UL]');
sdate:=form_xf_limit.sdate ;
edate:=form_xf_limit.edate ;
smoney:=form_xf_limit.smoney ;
emoney:=form_xf_limit.emoney ;
label22.Caption :=datetostr(sdate) + ' - ' + datetostr(edate);
label24.Caption :=inttostr(smoney) + '￥ - ' + inttostr(emoney) + '￥';
listview1.Clear ;
recordset_temp3.SQL.Clear ;
recordset_temp3.SQL.Add('select * from [UL]');
recordset_temp3.Open ;
recordset_temp.SQL.Clear ;
recordset_temp.SQL.Add('select * from [CUSTOM],[AREA],[FROM]where [CUSTOM_AREA]=[AREA_ID] and [CUSTOM_FROM]=[FROM_ID]');
recordset_temp.open;
for i:=1 to recordset_temp.RecordCount do
begin
recordset_temp2.SQL.Clear ;
recordset_temp2.SQL.Add('select sum([JY_ALLDOLLOR]) from [JY] where [JY_DATE]>#'
+ datetostr(sdate) + '# and [JY_DATE]<#' + datetostr(edate)
+ '# and [JY_CUSTOMID]='
+ inttostr(recordset_temp.Fields[0].asinteger));
recordset_temp2.Open ;
if recordset_temp2.RecordCount <>0 then
begin
mm:=recordset_temp2.Fields[0].AsFloat ;
end;
if ((mm>smoney) and (mm<emoney)) then
begin
listitem:=listview1.Items.Add ;
listitem.Caption :=recordset_temp.Fields[1].AsString ;
listitem.ImageIndex :=0;
listitem.SubItems.Add(recordset_temp.Fields[2].asstring);
listitem.SubItems.Add(recordset_temp.Fields[3].asstring);
listitem.SubItems.Add(format( '%8.2f￥',[mm]));
new(p);
p^ := recordset_temp.Fields[0].AsInteger ;
listitem.Data :=p;
recordset_temp3.Insert ;
recordset_temp3.Fields[1].AsString :=recordset_temp.Fields[1].AsString;
recordset_temp3.Fields[2].AsString :=recordset_temp.Fields[2].asstring;
recordset_temp3.Fields[3].AsString :=recordset_temp.Fields[3].asstring;
recordset_temp3.Fields[4].AsString :=recordset_temp.Fields[11].AsString ;
recordset_temp3.Fields[5].AsString :=recordset_temp.fields[6].AsString ;
recordset_temp3.Fields[6].AsString :=recordset_temp.Fields[8].AsString ;
recordset_temp3.Fields[7].AsString :=recordset_temp.Fields[13].AsString ;
recordset_temp3.Fields[8].AsString :=datetostr(recordset_temp.Fields[9].asdatetime);
recordset_temp3.Fields[9].AsString :=format( '%8.2f￥',[mm]);
recordset_temp3.Post ;
end;
recordset_temp2.Close ;
recordset_temp.Next;
end;
recordset_temp.Close ;
recordset_temp3.Close ;
end;
procedure Tform_user_rep.BitBtn1Click(Sender: TObject);
var
p:^integer;
begin
if listview1.selected=nil then
begin
exit;
end;
p:=listview1.Selected.Data ;
form_ljxf_one.userid :=p^;
form_ljxf_one.sdate:=sdate ;
form_ljxf_one.edate:=edate ;
form_ljxf_one.ShowModal ;
end;
procedure Tform_user_rep.BitBtn3Click(Sender: TObject);
begin
close;
end;
procedure Tform_user_rep.ListView1Click(Sender: TObject);
var
p:^integer;
begin
if listview1.selected=nil then
begin
label4.Caption :='' ;
label5.Caption :='';
label7.Caption :='';
label10.Caption :='';
label12.Caption :='';
label14.Caption :='';
label15.Caption :='';
label17.Caption :='';
label19.Caption :='';
exit;
end;
p:=listview1.Selected.Data;
//show the custom's information
recordset_temp.SQL.Clear;
recordset_temp.SQL.Add('select [CUSTOM_CODE],[CUSTOM_MNAME],[CUSTOM_FNAME],[CUSTOM_TEL]'
+ ',[AREA_NAME],[CUSTOM_ADD],[FROM_NAME],[CUSTOM_POST],[CUSTOM_DATE] from [CUSTOM],[AREA],[FROM] where [FROM_ID]=[CUSTOM_FROM] and [AREA_ID]=[CUSTOM_AREA] and [CUSTOM_ID]=' + inttostr(p^)
);
recordset_temp.Open ;
if recordset_temp.recordcount<>0 then
begin
label4.Caption :=recordset_temp.Fields[0].AsString ;
label5.Caption :=recordset_temp.Fields[1].AsString;
label7.Caption :=recordset_temp.Fields[2].AsString;
label10.Caption :=recordset_temp.Fields[3].AsString;
label12.Caption :=recordset_temp.Fields[4].AsString;
label14.Caption :=recordset_temp.Fields [5].AsString ;
label15.Caption :=recordset_temp.Fields [6].AsString;
label17.Caption :=recordset_temp.Fields [7].AsString;
label19.Caption :=datetostr(recordset_temp.Fields [8].AsDateTime );
end;
end;
procedure Tform_user_rep.ListView1DblClick(Sender: TObject);
var
p:^integer;
begin
if listview1.selected=nil then
begin
exit;
end;
p:=listview1.Selected.Data ;
form_ljxf_one.userid :=p^;
form_ljxf_one.sdate:=sdate ;
form_ljxf_one.edate:=edate ;
form_ljxf_one.ShowModal ;
end;
procedure Tform_user_rep.BitBtn4Click(Sender: TObject);
begin
recordset_temp3.SQL.Clear ;
recordset_temp3.SQL.Add('select * from [UL]');
recordset_temp3.Open ;
qrdbtext1.DataField :='UL_CODE';
qrdbtext2.DataField :='UL_MNAME';
qrdbtext3.DataField :='UL_FNAME';
qrdbtext4.DataField :='UL_AREA';
qrdbtext5.DataField :='UL_ADD';
qrdbtext6.DataField :='UL_POST';
qrdbtext7.DataField :='UL_FROM';
qrdbtext8.DataField :='UL_DATE';
qrdbtext9.DataField :='UL_MONEY';
quickrep1.Preview ;
recordset_temp3.Close ;
end;
procedure Tform_user_rep.BitBtn5Click(Sender: TObject);
begin
recordset_temp3.SQL.Clear ;
recordset_temp3.SQL.Add('select * from [UL]');
recordset_temp3.Open ;
qrdbtext1.DataField :='UL_CODE';
qrdbtext2.DataField :='UL_MNAME';
qrdbtext3.DataField :='UL_FNAME';
qrdbtext4.DataField :='UL_AREA';
qrdbtext5.DataField :='UL_ADD';
qrdbtext6.DataField :='UL_POST';
qrdbtext7.DataField :='UL_FROM';
qrdbtext8.DataField :='UL_DATE';
qrdbtext9.DataField :='UL_MONEY';
quickrep1.Print ;
recordset_temp3.Close ;
end;
end.
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -