unitpulldownfm.pas.~1~

一款房产中介软件

Unit UnitPullDownUnit;

Interface

Uses
   Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
   Dialogs, LbButton, ExtCtrls, StdCtrls, DBCtrls, AAFont, AACtrls, DB,
   ADODB, Grids, DBGridEh, DBCtrlsEh, Mask, ComCtrls;

Type
   TUnitPullDownForm = Class(TForm)
      LbButton4: TLbButton;
      LbButton2: TLbButton;
      AALabel1: TLabel;
      DBText1: TDBText;
      AALabel2: TLabel;
      DBText2: TDBText;
      AALabel31: TLabel;
      DBText3: TDBText;
      AALabel32: TLabel;
      DBText4: TDBText;
      AALabel3: TLabel;
      DBText5: TDBText;
      AALabel4: TLabel;
      DBText6: TDBText;
      Bevel1: TBevel;
      ADOQuery1: TADOQuery;
      DataSource1: TDataSource;
      DataSource2: TDataSource;
      ADOQuery2: TADOQuery;
      PageControl1: TPageControl;
      TabSheet1: TTabSheet;
      TabSheet2: TTabSheet;
      TabSheet3: TTabSheet;
      Panel1: TPanel;
      AALabel9: TLabel;
      AALabel5: TLabel;
      AALabel6: TLabel;
      AALabel18: TLabel;
      AALabel11: TLabel;
      AALabel7: TLabel;
      AALabel8: TLabel;
      AALabel10: TLabel;
      AALabel12: TLabel;
      AALabel13: TLabel;
      AALabel14: TLabel;
      AALabel19: TLabel;
      AALabel20: TLabel;
      AALabel21: TLabel;
      AALabel22: TLabel;
      AALabel25: TLabel;
      AALabel26: TLabel;
      AALabel15: TLabel;
      AALabel16: TLabel;
      AALabel17: TLabel;
      AALabel23: TLabel;
      AALabel24: TLabel;
      AALabel27: TLabel;
      AALabel28: TLabel;
      AALabel29: TLabel;
      AALabel30: TLabel;
      AALabel33: TLabel;
      AALabel34: TLabel;
      AALabel35: TLabel;
      AALabel37: TLabel;
      AALabel36: TLabel;
      AALabel38: TLabel;
      AALabel39: TLabel;
      AALabel40: TLabel;
      AALabel41: TLabel;
      AALabel42: TLabel;
      AALabel43: TLabel;
      AALabel44: TLabel;
      DBEdit1: TDBEdit;
      DBEdit2: TDBEdit;
      DBNumberEditEh1: TDBNumberEditEh;
      DBNumberEditEh3: TDBNumberEditEh;
      DBNumberEditEh4: TDBNumberEditEh;
      DBDateTimeEditEh1: TDBDateTimeEditEh;
      DBDateTimeEditEh2: TDBDateTimeEditEh;
      DBDateTimeEditEh3: TDBDateTimeEditEh;
      DBDateTimeEditEh4: TDBDateTimeEditEh;
      DBDateTimeEditEh5: TDBDateTimeEditEh;
      DBMemo1: TDBMemo;
      DBComboBox1: TDBComboBox;
      DBComboBox2: TDBComboBox;
      DBGridEH1: TDBGridEh;
      LbButton1: TLbButton;
      DBNumberEditEh5: TDBNumberEditEh;
      DBNumberEditEh6: TDBNumberEditEh;
      DBNumberEditEh7: TDBNumberEditEh;
      DBNumberEditEh8: TDBNumberEditEh;
      DBNumberEditEh9: TDBNumberEditEh;
      DBNumberEditEh10: TDBNumberEditEh;
      Panel3: TPanel;
      GroupBox1: TGroupBox;
      AALabel45: TLabel;
      AALabel46: TLabel;
      AALabel47: TLabel;
      AALabel48: TLabel;
      AALabel49: TLabel;
      AALabel50: TLabel;
      AALabel51: TLabel;
      AALabel52: TLabel;
      AALabel53: TLabel;
      AALabel54: TLabel;
      AALabel55: TLabel;
      AALabel56: TLabel;
      AALabel57: TLabel;
      AALabel58: TLabel;
      AALabel59: TLabel;
      AALabel60: TLabel;
      AALabel61: TLabel;
      AALabel62: TLabel;
      AALabel63: TLabel;
      AALabel64: TLabel;
      DBNumberEditEh11: TDBNumberEditEh;
      DBNumberEditEh12: TDBNumberEditEh;
      DBNumberEditEh13: TDBNumberEditEh;
      DBNumberEditEh14: TDBNumberEditEh;
      DBDateTimeEditEh6: TDBDateTimeEditEh;
      DBDateTimeEditEh7: TDBDateTimeEditEh;
      DBDateTimeEditEh8: TDBDateTimeEditEh;
      DBDateTimeEditEh9: TDBDateTimeEditEh;
      GroupBox2: TGroupBox;
      AALabel65: TLabel;
      AALabel66: TLabel;
      AALabel67: TLabel;
      AALabel68: TLabel;
      AALabel69: TLabel;
      AALabel70: TLabel;
      AALabel71: TLabel;
      AALabel72: TLabel;
      AALabel73: TLabel;
      AALabel74: TLabel;
      AALabel75: TLabel;
      AALabel76: TLabel;
      AALabel77: TLabel;
      AALabel78: TLabel;
      AALabel79: TLabel;
      AALabel80: TLabel;
      AALabel81: TLabel;
      AALabel82: TLabel;
      AALabel83: TLabel;
      AALabel84: TLabel;
      DBNumberEditEh15: TDBNumberEditEh;
      DBNumberEditEh16: TDBNumberEditEh;
      DBNumberEditEh17: TDBNumberEditEh;
      DBNumberEditEh18: TDBNumberEditEh;
      DBDateTimeEditEh10: TDBDateTimeEditEh;
      DBDateTimeEditEh11: TDBDateTimeEditEh;
      DBDateTimeEditEh12: TDBDateTimeEditEh;
      DBDateTimeEditEh13: TDBDateTimeEditEh;
      AALabel85: TLabel;
      AALabel86: TLabel;
      AALabel87: TLabel;
      AALabel88: TLabel;
      DBNumberEditEh19: TDBNumberEditEh;
      DBNumberEditEh20: TDBNumberEditEh;
      Panel2: TPanel;
      AALabel89: TLabel;
      AALabel90: TLabel;
      AALabel91: TLabel;
      AALabel92: TLabel;
      AALabel93: TLabel;
      AALabel102: TLabel;
      AALabel103: TLabel;
      Bevel2: TBevel;
      DBEdit3: TDBEdit;
      DBEdit4: TDBEdit;
      DBComboBox3: TDBComboBox;
      GroupBox3: TGroupBox;
      AALabel94: TLabel;
      AALabel95: TLabel;
      AALabel96: TLabel;
      AALabel97: TLabel;
      AALabel98: TLabel;
      AALabel99: TLabel;
      AALabel100: TLabel;
      AALabel101: TLabel;
      AALabel104: TLabel;
      AALabel105: TLabel;
      AALabel106: TLabel;
      DBText7: TDBText;
      AALabel107: TLabel;
      DBNumberEditEh21: TDBNumberEditEh;
      DBNumberEditEh22: TDBNumberEditEh;
      DBDateTimeEditEh14: TDBDateTimeEditEh;
      DBDateTimeEditEh15: TDBDateTimeEditEh;
      GroupBox4: TGroupBox;
      AALabel108: TLabel;
      AALabel109: TLabel;
      AALabel110: TLabel;
      AALabel111: TLabel;
      AALabel112: TLabel;
      AALabel113: TLabel;
      AALabel114: TLabel;
      AALabel115: TLabel;
      AALabel116: TLabel;
      AALabel117: TLabel;
      AALabel118: TLabel;
      DBText8: TDBText;
      AALabel119: TLabel;
      DBNumberEditEh23: TDBNumberEditEh;
      DBNumberEditEh24: TDBNumberEditEh;
      DBDateTimeEditEh16: TDBDateTimeEditEh;
      DBDateTimeEditEh17: TDBDateTimeEditEh;
      DBDateTimeEditEh18: TDBDateTimeEditEh;
      DBNumberEditEh25: TDBNumberEditEh;
      DBNumberEditEh26: TDBNumberEditEh;
      AALabel120: TLabel;
      DBText9: TDBText;
      AALabel121: TLabel;
      DBNumberEditEh27: TDBNumberEditEh;
      AALabel122: TLabel;
      AALabel123: TLabel;
      DBNumberEditEh28: TDBNumberEditEh;
      AALabel124: TLabel;
      AALabel125: TLabel;
      DBNumberEditEh29: TDBNumberEditEh;
      AALabel126: TLabel;
      AALabel127: TLabel;
      DBNumberEditEh2: TDBNumberEditEh;
      AALabel128: TLabel;
      DBNumberEditEh30: TDBNumberEditEh;
      AALabel129: TLabel;
      AALabel130: TLabel;
      AALabel131: TLabel;
      DBNumberEditEh31: TDBNumberEditEh;
      AALabel132: TLabel;
      AALabel133: TLabel;
      AALabel134: TLabel;
      AALabel135: TLabel;
      AALabel136: TLabel;
      AALabel137: TLabel;
      DBDateTimeEditEh19: TDBDateTimeEditEh;
      DBDateTimeEditEh20: TDBDateTimeEditEh;
      AALabel138: TLabel;
      AALabel139: TLabel;
      DBDateTimeEditEh21: TDBDateTimeEditEh;
      AALabel140: TLabel;
      AALabel141: TLabel;
      DBDateTimeEditEh22: TDBDateTimeEditEh;
      LbButton3: TLbButton;
      LbButton5: TLbButton;
      AALabel143: TLabel;
      AALabel142: TLabel;
      Procedure FormClose(Sender: TObject; Var Action: TCloseAction);
      Procedure LbButton4Click(Sender: TObject);
      Procedure LbButton2Click(Sender: TObject);
      Procedure DBDateTimeEditEh1Exit(Sender: TObject);
      Procedure DBDateTimeEditEh2Exit(Sender: TObject);
      Procedure DBDateTimeEditEh3Exit(Sender: TObject);
      Procedure DBDateTimeEditEh4Exit(Sender: TObject);
      Procedure DBDateTimeEditEh5Exit(Sender: TObject);
      Procedure FormCreate(Sender: TObject);
      Procedure DBComboBox2Change(Sender: TObject);
      Procedure FormShow(Sender: TObject);
      Procedure DBNumberEditEh1Change(Sender: TObject);
      Procedure DBNumberEditEh3Change(Sender: TObject);
      Procedure LbButton1Click(Sender: TObject);
      Procedure DBComboBox1Change(Sender: TObject);
      Procedure LbButton3Click(Sender: TObject);
      Procedure DBNumberEditEh8Change(Sender: TObject);
      Procedure DBNumberEditEh5Change(Sender: TObject);
      Procedure DBNumberEditEh19Change(Sender: TObject);
      Procedure DBNumberEditEh11Change(Sender: TObject);
      Procedure DBNumberEditEh15Change(Sender: TObject);
      Procedure TabSheet3Show(Sender: TObject);
      Procedure DBNumberEditEh1KeyUp(Sender: TObject; Var Key: word;
         Shift: TShiftState);
      Procedure DBNumberEditEh25Change(Sender: TObject);
      Procedure DBNumberEditEh26Change(Sender: TObject);
      Procedure LbButton5Click(Sender: TObject);
      Procedure DBNumberEditEh31Change(Sender: TObject);
      Procedure DBNumberEditEh30Change(Sender: TObject);
   Private
    { Private declarations }
   Public
    { Public declarations }
   End;

Var
   UnitPullDownForm : TUnitPullDownForm;
   area             : double;
   BendLoadDB       : Boolean;
Implementation
Uses DM, ViewUnitUnit, PUBFunction;
{$R *.dfm}

Procedure TUnitPullDownForm.FormClose(Sender: TObject;
   Var Action: TCloseAction);
Begin
   Action := cafree;
   UnitPullDownForm := Nil;
End;

Procedure TUnitPullDownForm.LbButton4Click(Sender: TObject);
Begin
   ADOQuery1.Cancel;
   Close;

End;

Procedure TUnitPullDownForm.LbButton2Click(Sender: TObject);
Begin
   If Trim(DBEdit1.Text) = '' Then Begin
      Application.MessageBox('拆迁还建协定书编号不能为空！', '错误警告',
         MB_ICONERROR);
      Exit;
   End;
   If DBComboBox1.Text = '分期' Then Begin
      ADOQuery1.fieldbyname('已收款').Text := DBNumberEditEh28.Text;
      ADOQuery1.fieldbyname('未收款').Text := DBNumberEditEh29.Text;
   End Else Begin
      ADOQuery1.fieldbyname('已收款').Text := DBNumberEditEh10.Text;
      ADOQuery1.fieldbyname('未收款').AsFloat := 0;
   End;

   ADOQuery1.fieldbyname('公司编号').AsString :=
      DBText1.Caption;
   ADOQuery1.fieldbyname('项目编号').AsString :=
      DBText3.Caption;
   ADOQuery1.fieldbyname('幢号').AsString :=
      DBText5.Caption;
   ADOQuery1.fieldbyname('房号').AsString :=
      DBText6.Caption;
   ViewUnitForm.ADOQuery4.edit;