realtyc421.pas

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

unit RealtyC421;

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_RealtyC421 = 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;
    Label5: TLabel;
    Edit7: TEdit;
    Label6: TLabel;
    Edit8: TEdit;
    Label7: TLabel;
    Edit9: TEdit;
    DateTimePicker4: TDateTimePicker;
    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;
    Edit20: TEdit;
    Label2: TLabel;
    Label26: TLabel;
    Edit21: TEdit;
    Label27: TLabel;
    Edit22: TEdit;
    Label28: TLabel;
    Edit23: TEdit;
    Label29: TLabel;
    Edit24: TEdit;
    Label30: TLabel;
    Edit25: TEdit;
    Button5: TButton;
    Button7: TButton;
    Button1: TButton;
    Button2: TButton;
    Edit26: TEdit;
    Button3: TButton;
    Label31: TLabel;
    DateTimePicker5: TDateTimePicker;
    procedure FormKeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    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 Edit13Exit(Sender: TObject);
    procedure Edit14Exit(Sender: TObject);
    procedure Edit17Exit(Sender: TObject);
    procedure Edit18Exit(Sender: TObject);
    procedure CheckBox1Click(Sender: TObject);
    procedure edit6Exit(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure edit5Select(Sender: TObject);
    procedure Edit7Exit(Sender: TObject);
    procedure Edit8Exit(Sender: TObject);
    procedure Edit12Exit(Sender: TObject);
    procedure Edit16Exit(Sender: TObject);


  private
    { Private declarations }
  public
    { Public declarations }
     bMod:bool;
     sTable:string;
     cols:integer;
  end;
var
  f_RealtyC421: Tf_RealtyC421;
implementation
uses data, main,RealtyC42,RealtyB22,RealtyA14,RealtyC33;
{$R *.dfm}
//Initial******************************
procedure Tf_RealtyC421.FormCreate(Sender: TObject);
Var
    query,query1:TADOQuery;
    s1,s3,s4:string;
    r1: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_RealtyC42.bMod=false then
    begin
        GetID;
        Datetimepicker1.Date:=date;
        Datetimepicker2.Date:=date;
        Datetimepicker3.Date:=date;
        Datetimepicker4.Date:=date;
        edit23.text:=czy;
    end;

    if f_RealtyC42.bMod then
    begin
        if f_RealtyC42.ListView1.Selected.SubItems[33]='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   r1:=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;

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

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

            datetimepicker1.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;

            datetimepicker2.date:=strtodate(query.fieldbyname('计费开始日期').Value);
            datetimepicker3.Date:=strtodate(query.fieldbyname('计费结束日期').Value);
            edit12.Text:=query.fieldbyname('单价').Value;
            edit13.Text:=query.fieldbyname('金额').Value;
            edit14.Text:=query.fieldbyname('优惠金额').Value;
            edit15.Text:=query.fieldbyname('优惠后金额').Value;
            datetimepicker4.Date:=strtodate(query.fieldbyname('滞纳金截至日期').Value);
            edit16.Text:=query.fieldbyname('滞纳金天数').Value;
            edit17.Text:=query.fieldbyname('滞纳金').Value;
            edit18.Text:=query.fieldbyname('减免缴滞纳金').Value;
            edit19.Text:=query.fieldbyname('应收滞纳金').Value;
            edit20.Text:=query.fieldbyname('应收金额').Value;
            edit21.Text:=query.fieldbyname('已收金额').Value;
            edit26.text:=query.fieldbyname('收全日期').Value;
            edit22.Text:=query.fieldbyname('备注').Value;
            edit23.Text:=query.fieldbyname('制单人').Value;
            edit24.Text:=czy;
            if query.fieldbyname('收取滞纳金').Value<>'N' then checkbox1.Checked:=true
            else checkbox1.Checked:=false;
            if query.fieldbyname('已收全').Value<>'N' then checkbox2.Checked:=true
            else checkbox2.Checked:=false;

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

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

//Close*************************************
procedure Tf_RealtyC421.ToolButton10Click(Sender: TObject);
begin
    close;
end;

procedure Tf_RealtyC421.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;
        exit;
    end;

    if edit4.Text='' then
    begin
        showmessage('仪表不能为空!');
        edit4.SetFocus;
        exit;
    end;

    if edit5.Text='' then
    begin
        showmessage('收费项目不能为空!');
        edit5.SetFocus;
        exit;
    end;

    if edit6.Text='' then
    begin
        showmessage('收费标准不能为空!');
        edit6.SetFocus;
        exit;
    end;

    if edit13.Text='' then
    begin
        showmessage('金额不能为空!');
        edit13.SetFocus;
        exit;
    end;

    r1:=copy(edit3.Text,1,7);
    r3:=mainform.getNum(edit5.Text);