realtyc42.pas

物业管理系统系统特点 一、 实现集中式管理 系统将集团公司、各分公司、各物业管理处连接到一起

unit RealtyC42;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, dbcgrids, Grids, DBGrids, DB, ADODB, StdCtrls, Buttons, ExtCtrls,
  StrUtils, ExtDlgs, ComCtrls, math, ImgList, Menus, ToolWin;

type
    Tf_RealtyC42 = class(TForm)
    GroupBox1: TGroupBox;
    ListView1: TListView;
    TreeView1: TTreeView;
    Edit1: TEdit;
    Edit2: TEdit;
    Label1: TLabel;
    Label2: TLabel;
    Button1: TButton;
    Button3: TButton;
    Button2: TButton;
    Button4: TButton;
    Button5: TButton;
    Button6: TButton;
    Label3: TLabel;
    Button7: TButton;
    Button8: TButton;
    Label4: TLabel;
    Edit3: TEdit;
    Button9: TButton;
    Label5: TLabel;
    Edit4: TEdit;
    Label6: TLabel;
    Edit5: TEdit;
    Label7: TLabel;
    Label8: TLabel;
    DateTimePicker1: TDateTimePicker;
    DateTimePicker2: TDateTimePicker;
    procedure FormKeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure ListView1CustomDrawItem(Sender: TCustomListView;
      Item: TListItem; State: TCustomDrawState; var DefaultDraw: Boolean);

    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormCreate(Sender: TObject);
    procedure TreeView1Click(Sender: TObject);
    procedure TreeView1CustomDrawItem(Sender: TCustomTreeView;
      Node: TTreeNode; State: TCustomDrawState; var DefaultDraw: Boolean);
    procedure Button3Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
    procedure Button7Click(Sender: TObject);
    procedure Button8Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button9Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);

  private
    { Private declarations }
  public
    { Public declarations }
     bMod:bool;
     sTable:string;
     cols:integer;
     sNum:string;
     bOk:bool;
  end;
  
var
  f_RealtyC42: Tf_RealtyC42;
implementation
uses data, main,RealtyC421,RealtyC42A,RealtyPrint1;
{$R *.dfm}

//Init*********************************
procedure Tf_RealtyC42.FormCreate(Sender: TObject);
begin
    getStructure(TreeView1);
    datetimepicker1.date:=date;
    datetimepicker2.date:=date;
end;

procedure Tf_RealtyC42.TreeView1Click(Sender: TObject);
Var
    query,query1,query2,query3,query4:TADOQuery;
    nLevel:integer;
    s,s1,s2,s3,s4,s5,s6,s7,s8,s9,s10:string;
    r1,r2,r3:string;
begin
    listview1.Items.Clear;

    nLevel:=treeview1.Selected.Level;

    Query:=TADOQuery.Create(nil);
    Query.Connection:=DataModuleADO.ADOConnection1;
    Query1:=TADOQuery.Create(nil);
    Query1.Connection:=DataModuleADO.ADOConnection1;
    Query2:=TADOQuery.Create(nil);
    Query2.Connection:=DataModuleADO.ADOConnection1;
    Query3:=TADOQuery.Create(nil);
    Query3.Connection:=DataModuleADO.ADOConnection1;
    Query4:=TADOQuery.Create(nil);
    Query4.Connection:=DataModuleADO.ADOConnection1;


    if nLevel=0 then
    begin
        s:='select * from 抄表费用 where 单号 like ''%'+Edit1.text;
        s:=s+'%'' and 收费月份>='''+copy(datetostr(datetimepicker1.Date),1,7);
        s:=s+''' and 收费月份<='''+copy(datetostr(datetimepicker2.Date),1,7);
        s:=s+''' order by 单号 asc';

        query.SQL.Clear;
        Query.SQL.Add(s);
        Query.Open ;
        while not Query.Eof do
        begin
            s:='select * from 客户资料 where 客户代码='''+Query.FieldByName('客户').Value;
            s:=s+''' and 客户名称 like ''%'+edit2.Text+'%''';
            query1.SQL.Clear;
            Query1.SQL.Add(s);
            Query1.Open ;
            if query1.RecordCount>0 then
            begin
                s1:=query1.fieldbyname('客户名称').value;

                s:='select * from 房间 where 编号='''+Query.FieldByName('房间').Value;
                s:=s+''' and 名称 like ''%'+edit3.Text+'%''';
                query2.SQL.Clear;
                Query2.SQL.Add(s);
                Query2.Open ;
                if query2.RecordCount>0 then
                begin
                    r1:=query2.fieldbyname('名称').Value;
                    s2:=query2.fieldbyname('楼宇').Value;
                    s3:=mainform.getName('楼宇',s2);
                    s4:=query2.fieldbyname('管理区').Value;
                    s5:=mainform.getName('管理区',s4);
                    s6:=query2.fieldbyname('管理处').Value;
                    s7:=mainform.getName('组织机构',s6);

                    s:='select * from 管理区 where 编号='''+s4;
                    s:=s+''' and 名称 like ''%'+edit4.Text+'%''';
                    query3.SQL.Clear;
                    Query3.SQL.Add(s);
                    Query3.Open ;
                    if query3.RecordCount>0 then
                    begin
                        s:='select * from 楼宇 where 编号='''+s2;
                        s:=s+''' and 名称 like ''%'+edit5.Text+'%''';
                        query3.SQL.Clear;
                        Query3.SQL.Add(s);
                        Query3.Open ;
                        if query3.RecordCount>0 then
                        begin
                            query3.SQL.clear;
                            query3.SQL.add('select * from 收费项目 where 编号='''+query.fieldbyname('收费项目').Value+'''');
                            query3.Open;
                            if query3.RecordCount>0 then s8:=query3.fieldbyname('名称').Value;

                            query3.SQL.clear;
                            query3.SQL.add('select * from 收费标准 where 编号='''+query.fieldbyname('收费标准').Value+'''');
                            query3.Open;
                            if query3.RecordCount>0 then s9:=query3.fieldbyname('名称').Value;

                            with ListView1.Items.Add do
                            begin
                                Caption:=s1;
                                SubItems.Add(Query.FieldbyName('客户').Value);
                                SubItems.Add(r1);
                                SubItems.Add(Query.FieldByName('单号').Value);
                                SubItems.Add(Query.FieldByName('单价').Value);


                                SubItems.Add(Query.FieldByName('仪表').Value);
                                SubItems.Add(Query.FieldByName('金额').Value);
                                SubItems.Add(Query.FieldByName('优惠金额').Value);
                                SubItems.Add(Query.FieldByName('优惠后金额').Value);

                                SubItems.Add(Query.FieldByName('滞纳金').Value);
                                SubItems.Add(Query.FieldByName('减免缴滞纳金').Value);
                                SubItems.Add(Query.FieldByName('应收滞纳金').Value);
                                SubItems.Add(Query.FieldByName('收取滞纳金').Value);
                                SubItems.Add(Query.FieldByName('应收金额').Value);


                                SubItems.Add(Query.FieldByName('应收日期').Value);
                                SubItems.Add(Query.FieldByName('上次读数').Value);

                                SubItems.Add(Query.FieldByName('本次读数').Value);
                                SubItems.Add(Query.FieldByName('实际行度').Value);
                                SubItems.Add(Query.FieldByName('滞纳金截至日期').Value);
                                SubItems.Add(Query.FieldByName('滞纳金天数').Value);


                                SubItems.Add(s6);
                                SubItems.Add(s7);
                                SubItems.Add(s4);

                                SubItems.Add(s5);
                                SubItems.Add(s2);
                                SubItems.Add(s3);
                                SubItems.Add(Query.FieldByName('收费项目').Value);
                                SubItems.Add(s8);

                                SubItems.Add(Query.FieldByName('收费标准').Value);
                                SubItems.Add(s9);
                                SubItems.Add(Query.FieldByName('备注').Value);
                                SubItems.Add(Query.FieldByName('制单人').Value);
                                SubItems.Add(Query.FieldByName('修订人').Value);

                                SubItems.Add(Query.FieldByName('审核人').Value);
                                SubItems.Add(Query.FieldByName('审核').Value);
                            end;
                        end;
                    end;
                end;
            end;
            query.Next;
        end;
    end;




    if nLevel>0 then
    begin
        s:='select * from 组织机构 where 名称 = '''+treeview1.Selected.Text+'''';

        query.SQL.Clear;
        Query.SQL.Add(s);
        Query.Open ;
        if query.RecordCount>0 then
        begin
            s1:=Query.FieldByName('stampt').Value;

            s:='select * from 组织机构 where 组织机构类别='''+'管理处';
            s:=s+''' and stampt like '''+s1+'%''';

            query1.SQL.Clear;
            Query1.SQL.Add(s);
            Query1.Open ;
            while not Query1.Eof do
            begin
                s:='select * from 抄表费用 where 单号 like ''%'+Edit1.text;
                s:=s+'%'' and 收费月份>='''+copy(datetostr(datetimepicker1.Date),1,7);
                s:=s+''' and 收费月份<='''+copy(datetostr(datetimepicker2.Date),1,7);
                s:=s+''' order by 单号 asc';

                query.SQL.Clear;
                Query.SQL.Add(s);
                Query.Open ;
                while not Query.Eof do
                begin
                    s:='select * from 客户资料 where 客户代码 ='''+query.fieldbyname('客户').Value;
                    s:=s+''' and 客户名称 like ''%'+edit2.Text;
                    s:=s+'%'' and 管理处 ='''+Query1.FieldByName('编号').Value+'''';
                    query2.SQL.Clear;
                    Query2.SQL.Add(s);
                    Query2.Open ;
                    if query2.RecordCount>0 then
                    begin
                        s1:=query2.fieldbyname('客户名称').Value;

                        s:='select * from 房间 where 编号='''+Query.FieldByName('房间').Value;
                        s:=s+''' and 名称 like ''%'+edit3.Text+'%''';
                        query3.SQL.Clear;
                        Query3.SQL.Add(s);
                        Query3.Open ;
                        if query3.RecordCount>0 then
                        begin
                            r1:=query3.fieldbyname('名称').Value;
                            s2:=query3.fieldbyname('楼宇').Value;
                            s3:=mainform.getName('楼宇',s2);
                            s4:=query3.fieldbyname('管理区').Value;
                            s5:=mainform.getName('管理区',s4);
                            s6:=query3.fieldbyname('管理处').Value;
                            s7:=mainform.getName('组织机构',s6);

                            s:='select * from 管理区 where 编号='''+s4;
                            s:=s+''' and 名称 like ''%'+edit4.Text+'%''';
                            query3.SQL.Clear;
                            Query3.SQL.Add(s);
                            Query3.Open ;
                            if query3.RecordCount>0 then
                            begin
                                s:='select * from 楼宇 where 编号='''+s2;
                                s:=s+''' and 名称 like ''%'+edit5.Text+'%''';
                                query3.SQL.Clear;
                                Query3.SQL.Add(s);
                                Query3.Open ;
                                if query3.RecordCount>0 then
                                begin
                                    query4.SQL.clear;
                                    query4.SQL.add('select * from 收费项目 where 编号='''+query.fieldbyname('收费项目').Value+'''');
                                    query4.Open;
                                    if query4.RecordCount>0 then s8:=query4.fieldbyname('名称').Value;

                                    query4.SQL.clear;
                                    query4.SQL.add('select * from 收费标准 where 编号='''+query.fieldbyname('收费标准').Value+'''');
                                    query4.Open;
                                    if query4.RecordCount>0 then s9:=query4.fieldbyname('名称').Value;

                                    with ListView1.Items.Add do
                                    begin
                                        Caption:=s1;
                                        SubItems.Add(Query.FieldbyName('客户').Value);
                                        SubItems.Add(r1);
                                        SubItems.Add(Query.FieldByName('单号').Value);
                                        SubItems.Add(Query.FieldByName('单价').Value);

                                        SubItems.Add(Query.FieldByName('仪表').Value);
                                        SubItems.Add(Query.FieldByName('金额').Value);
                                        SubItems.Add(Query.FieldByName('优惠金额').Value);
                                        SubItems.Add(Query.FieldByName('优惠后金额').Value);

                                        SubItems.Add(Query.FieldByName('滞纳金').Value);
                                        SubItems.Add(Query.FieldByName('减免缴滞纳金').Value);
                                        SubItems.Add(Query.FieldByName('应收滞纳金').Value);
                                        SubItems.Add(Query.FieldByName('收取滞纳金').Value);
                                        SubItems.Add(Query.FieldByName('应收金额').Value);


                                        SubItems.Add(Query.FieldByName('应收日期').Value);
                                        SubItems.Add(Query.FieldByName('上次读数').Value);

                                        SubItems.Add(Query.FieldByName('本次读数').Value);
                                        SubItems.Add(Query.FieldByName('实际行度').Value);
                                        SubItems.Add(Query.FieldByName('滞纳金截至日期').Value);
                                        SubItems.Add(Query.FieldByName('滞纳金天数').Value);


                                        SubItems.Add(s6);
                                        SubItems.Add(s7);
                                        SubItems.Add(s4);