realtyc411.pas

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

unit RealtyC411;

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_RealtyC411 = class(TForm)
    Label1: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Label3: TLabel;
    Edit3: TEdit;
    Label4: TLabel;
    Edit4: TEdit;
    edit5: TComboBox;
    edit6: TComboBox;
    DateTimePicker1: TDateTimePicker;
    DateTimePicker2: TDateTimePicker;
    DateTimePicker3: TDateTimePicker;
    Edit7: TEdit;
    Edit8: TEdit;
    Edit9: TEdit;
    Edit10: TEdit;
    DateTimePicker4: TDateTimePicker;
    Edit11: TEdit;
    Label10: TLabel;
    Edit12: TEdit;
    Label11: TLabel;
    Edit13: TEdit;
    Label12: TLabel;
    Edit14: TEdit;
    CheckBox1: TCheckBox;
    CheckBox2: 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;
    Label26: TLabel;
    Label27: TLabel;
    Label28: TLabel;
    Label29: TLabel;
    Label30: TLabel;
    ComboBox1: TComboBox;
    Label2: TLabel;
    Button5: TButton;
    Button7: TButton;
    Button1: TButton;
    Button2: TButton;
    Edit20: TDateTimePicker;
    Label5: TLabel;
    DateTimePicker5: TDateTimePicker;
    procedure FormKeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure NN6Click(Sender: TObject);
    procedure GetID;
    procedure FormCreate(Sender: TObject);
    procedure ToolButton10Click(Sender: TObject);
    procedure Button7Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Edit7Exit(Sender: TObject);
    procedure Edit8Exit(Sender: TObject);
    procedure Edit11Exit(Sender: TObject);
    procedure Edit12Exit(Sender: TObject);
    procedure CheckBox1Click(Sender: TObject);
    procedure edit5Select(Sender: TObject);
    procedure edit6Exit(Sender: TObject);

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


var
  f_RealtyC411: Tf_RealtyC411;
implementation
uses data, main,RealtyC41,RealtyB22,RealtyA14;
{$R *.dfm}
//Initial******************************
procedure Tf_RealtyC411.FormCreate(Sender: TObject);
Var
    query,query1:TADOQuery;
    s1,s2,s3,s4:string;
begin

    query:=TADOQuery.Create(nil);
    query.Connection:=DataModuleADO.ADOConnection1;
    query1:=TADOQuery.Create(nil);
    query1.Connection:=DataModuleADO.ADOConnection1;

    combobox1.Items.Add('01--业主');
    combobox1.Items.Add('01--租户');
    combobox1.Items.Add('01--空置');
    combobox1.Items.Add('01--代缴');

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

    if f_RealtyC41.bMod=false then
    begin
        GetID;
        Datetimepicker1.Date:=date;
        Datetimepicker2.Date:=date;
        Datetimepicker3.Date:=date;
        Datetimepicker4.Date:=date;
        Edit20.Date:=date;
        checkbox2.Enabled:=false;
        edit17.text:=czy;
    end;

    if f_RealtyC41.bMod=true then
    begin
        if f_RealtyC41.ListView1.Selected.SubItems[30]='Y' then button7.Enabled:=false;

        query.sql.Clear;
        query.SQL.add('select * from 常规费用 where 单号='''+f_RealtyC41.listview1.Selected.subitems[2]+'''');
        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;

            edit1.Text:=query.fieldbyname('单号').Value;
            edit2.Text:=s1;
            edit3.Text:=s2;
            edit5.ItemIndex:=edit5.Items.IndexOf(query.fieldbyname('收费项目').value+'--'+mainform.getName('收费项目',query.fieldbyname('收费项目').value));

            s4:=query.fieldbyname('收费标准').value+'--'+mainform.getName('收费标准',query.fieldbyname('收费标准').value);
            edit6.Items.Add(s4);
            edit6.ItemIndex:=edit6.Items.IndexOf(s4);

            datetimepicker1.date:=strtodate(query.fieldbyname('应收日期').Value);
            datetimepicker2.date:=strtodate(query.fieldbyname('计费开始日期').Value);
            datetimepicker3.Date:=strtodate(query.fieldbyname('计费结束日期').Value);
            edit4.Text:=query.fieldbyname('单价').Value;
            edit7.Text:=query.fieldbyname('金额').Value;

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

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

            if query.fieldbyname('已收全').Value<>'N' then checkbox2.Checked:=true
            else checkbox2.Checked:=false;

            edit20.Date:=strtodate(query.fieldbyname('收全日期').Value);

            combobox1.ItemIndex:=combobox1.Items.IndexOf(query.fieldbyname('收取费用类型').Value);

            edit16.Text:=query.fieldbyname('备注').Value;
            edit17.Text:=query.fieldbyname('制单人').Value;
            edit18.Text:=czy;


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

procedure Tf_RealtyC411.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_RealtyC411.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_RealtyC411.FormClose(Sender: TObject; var Action: TCloseAction);
begin
    Action := caFree;
end;

//Close*************************************
procedure Tf_RealtyC411.NN6Click(Sender: TObject);
begin
    close;
end;

procedure Tf_RealtyC411.ToolButton10Click(Sender: TObject);
begin
     close;
end;

procedure Tf_RealtyC411.Button7Click(Sender: TObject);                              
Var
    query,query1,query2:TADOQuery;
    s,s1,s2,s3,s4,s5,s6,s7,s8,s9,s10,r1,r2,r3,r4,r5:string;
    i,j:integer;
begin
    r1:=copy(edit3.Text,1,7);
    r4:=mainform.getNum(edit5.Text);
    r5:=mainform.getNum(edit6.text);
    if edit1.Text='' then
    begin
        showmessage('单号不能为空!');
        edit1.SetFocus;
        exit;
    end;