realtyc431.pas

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

unit RealtyC431;

interface

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

type
    Tf_RealtyC431 = class(TForm)
    Label1: TLabel;
    Edit1: TEdit;
    Label2: TLabel;
    Edit2: TEdit;
    Label3: TLabel;
    Edit3: TEdit;
    Label4: TLabel;
    Edit4: TEdit;
    edit5: TComboBox;
    edit6: TComboBox;
    DateTimePicker1: TDateTimePicker;
    DateTimePicker2: TDateTimePicker;
    DateTimePicker3: TDateTimePicker;
    Label5: TLabel;
    Edit7: TEdit;
    Label6: TLabel;
    Edit8: TEdit;
    Label7: TLabel;
    Edit9: TEdit;
    Label8: TLabel;
    Edit10: TEdit;
    DateTimePicker4: TDateTimePicker;
    Label9: TLabel;
    Edit11: TEdit;
    Label10: TLabel;
    Edit12: TEdit;
    Label11: TLabel;
    Edit13: TEdit;
    Label12: TLabel;
    Edit14: TEdit;
    CheckBox1: TCheckBox;
    Label13: TLabel;
    Edit15: TEdit;
    Label14: TLabel;
    Edit16: TEdit;
    Label15: TLabel;
    Edit17: TEdit;
    Label16: TLabel;
    Label17: TLabel;
    Label18: TLabel;
    Label19: TLabel;
    Label20: TLabel;
    Label21: TLabel;
    Label22: TLabel;
    Label23: TLabel;
    Label24: TLabel;
    Label25: TLabel;
    Edit18: TEdit;
    Edit19: TEdit;
    Edit20: TEdit;
    Button5: TButton;
    Button7: TButton;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Edit21: TEdit;
    Label31: TLabel;
    DateTimePicker5: TDateTimePicker;
    CheckBox2: TCheckBox;
    procedure FormKeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure GetID;
    procedure FormCreate(Sender: TObject);
    procedure Button7Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Edit8Exit(Sender: TObject);
    procedure Edit9Exit(Sender: TObject);
    procedure Edit12Exit(Sender: TObject);
    procedure Edit13Exit(Sender: TObject);
    procedure edit5Exit(Sender: TObject);
    procedure edit5Select(Sender: TObject);
    procedure Edit7Exit(Sender: TObject);
    procedure Edit11Exit(Sender: TObject);

  private
    { Private declarations }
  public
    { Public declarations }
     bMod:bool;
     sTable:string;
     cols:integer;
  end;


var
  f_RealtyC431: Tf_RealtyC431;
implementation
uses data, main,RealtyC43,RealtyA14,RealtyB22,RealtyA15A;
{$R *.dfm}
//Initial******************************
procedure Tf_RealtyC431.FormCreate(Sender: TObject);
Var
    query,query1:TADOQuery;
    s1,s2,s3,s4,s5:string;
begin
    query:=TADOQuery.Create(nil);
    query.Connection:=DataModuleADO.ADOConnection1;
    query1:=TADOQuery.Create(nil);
    query1.Connection:=DataModuleADO.ADOConnection1;

    query.SQL.Add('select * from 收费项目 where 费用项目类型='''+'车位收费项目'+'''');
    query.Open;
    while not query.Eof do
    begin
        Edit5.Items.Add(query.fieldbyname('编号').Value+'--'+query.fieldbyname('名称').Value);
        query.Next;
    end;

    if f_RealtyC43.bMod=false then
    begin
        Datetimepicker1.Date:=date;
        Datetimepicker2.Date:=date;
        Datetimepicker3.Date:=date;
        Datetimepicker4.Date:=date;
        Datetimepicker5.Date:=date;
        edit18.Text:=czy;
        GetID;
    end;

    if f_RealtyC43.bMod then
    begin
        if f_RealtyC43.listview1.selected.subitems[23]='Y' then button7.enabled:=false;

        query.sql.Clear;
        query.SQL.add('select * from 车位费用 where 单号='''+mainform.t1+'''');
        query.Open;
        if query.RecordCount>0 then
        begin
            query1.sql.Clear;
            query1.SQL.add('select * from 车位 where 编号='''+query.fieldbyname('车位').value+'''');
            query1.Open;
            if query1.RecordCount>0 then   s1:=query1.fieldbyname('编号').value+'--'+query1.fieldbyname('名称').Value;

            query1.sql.Clear;
            query1.SQL.add('select * from 房间 where 编号='''+query.fieldbyname('房间').value+'''');
            query1.Open;
            if query1.RecordCount>0 then   s2:=query1.fieldbyname('编号').value+'--'+query1.fieldbyname('名称').Value;

            query1.sql.Clear;
            query1.SQL.add('select * from 客户资料 where 客户代码='''+query.fieldbyname('客户').value+'''');
            query1.Open;
            if query1.RecordCount>0 then   s3:=query1.fieldbyname('客户代码').value+'--'+query1.fieldbyname('客户名称').Value;

            query1.sql.Clear;
            query1.SQL.add('select * from 收费项目 where 编号='''+query.fieldbyname('收费项目').value+'''');
            query1.Open;
            if query1.RecordCount>0 then   s4:=query1.fieldbyname('编号').value+'--'+query1.fieldbyname('名称').Value;

            query1.sql.Clear;
            query1.SQL.add('select * from 收费标准 where 编号='''+query.fieldbyname('收费标准').value+'''');
            query1.Open;
            if query1.RecordCount>0 then
            begin
                s5:=query1.fieldbyname('编号').value+'--'+query1.fieldbyname('名称').Value;
            end;

            edit1.Text:=query.fieldbyname('单号').Value;
            edit2.Text:=s1;
            edit3.Text:=s2;
            edit4.Text:=s3;
            edit5.ItemIndex:=edit5.Items.IndexOf(s4);

            edit6.Items.Add(s5);
            edit6.ItemIndex:=edit6.Items.IndexOf(s5);

            datetimepicker1.date:=strtodate(query.fieldbyname('应收日期').Value);
            datetimepicker2.date:=strtodate(query.fieldbyname('计费开始日期').Value);
            datetimepicker3.Date:=strtodate(query.fieldbyname('计费结束日期').Value);

            datetimepicker5.Date:=strtodate(query.fieldbyname('收费月份').Value+'-01');

            edit7.Text:=query.fieldbyname('单价').Value;

            edit8.Text:=query.fieldbyname('金额').Value;
            edit9.Text:=query.fieldbyname('优惠金额').Value;
            edit10.Text:=query.fieldbyname('优惠后金额').Value;
            datetimepicker4.Date:=strtodate(query.fieldbyname('滞纳金截至日期').Value);
            edit11.Text:=query.fieldbyname('滞纳金天数').Value;

            edit12.Text:=query.fieldbyname('滞纳金').Value;
            edit13.Text:=query.fieldbyname('减免缴滞纳金').Value;
            edit14.Text:=query.fieldbyname('应收滞纳金').Value;
            if query.fieldbyname('收取滞纳金').Value<>'N' then checkbox1.Checked:=true
            else checkbox1.Checked:=false;
            edit15.Text:=query.fieldbyname('应收金额').Value;

            edit16.Text:=query.fieldbyname('已收金额').Value;
            if query.fieldbyname('已收全').Value<>'N' then checkbox2.Checked:=true
            else checkbox2.Checked:=false;
            edit21.text:=query.fieldbyname('收全日期').Value;
            edit17.Text:=query.fieldbyname('备注').Value;
            edit18.Text:=query.fieldbyname('制单人').Value;

            edit19.Text:=czy;
            edit20.Text:=query.fieldbyname('审核人').Value;
        end;
    end;
    query1.close;
    query1.free;
    query.close;
    query.free;
end;

procedure Tf_RealtyC431.GetID;
Var
    query:TADOQuery;
    s:string;
    i:integer;
begin
    query:=TADOQuery.Create(nil);
    query.Connection:=DataModuleADO.ADOConnection1;

    s := 'select top 1 * from 车位费用 ORDER BY  单号 DESC';

    Query.SQL.Add(s);
    Query.Open ;
    if query.recordcount > 0 then
    begin
        s:= Query.Fieldbyname('单号').AsString;
        s:= Copy(S, 1, 7);
        i:= strtoint(s)+1;
        if i<10 then edit1.text := '000000'+inttostr(i)
        else if (i > 9) and (i<100) then edit1.text := '00000'+inttostr(i)
        else if (i > 99) and (i<1000) then edit1.text := '0000'+inttostr(i)
        else if (i > 999) and (i<10000) then edit1.text := '000'+inttostr(i)
        else if (i > 9999) and (i<100000) then edit1.text := '00'+inttostr(i)
        else if (i > 99999) and (i<1000000) then edit1.text := '0'+inttostr(i)
        else if i>999999 then edit1.text := inttostr(i);
    end
    else  edit1.text := '0000001';

    query.Close;
    query.free;
end;

//Tab****************************************
procedure Tf_RealtyC431.FormKeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
    if key=13 then
        Begin
            key:=0;
            perform(WM_NEXTDLGCTL,0,0);
        end
    else if key=VK_ESCAPE then close;
end;

//FreeForm**********************************
procedure Tf_RealtyC431.FormClose(Sender: TObject; var Action: TCloseAction);
begin
    Action := caFree;
end;


procedure Tf_RealtyC431.Button7Click(Sender: TObject);
Var
    query,query1:TADOQuery;
    s,s1,s2,s3,s4,s5,s6,s7,s8,s9,r1,r2,rr,r3,r5:string;
    i,j:integer;
begin
    if edit1.Text='' then
    begin
        showmessage('单号不能为空!');
        edit1.SetFocus;
        exit;
    end;

    if edit2.Text='' then
    begin
        showmessage('车位不能为空!');
        edit2.SetFocus;
        exit;
    end;
    if edit3.Text='' then
    begin
        showmessage('房间不能为空!');
        edit3.SetFocus;