unit RealtyA321;

interface

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

type
    Tf_RealtyA321 = class(TForm)
    Button2: TButton;
    Label2: TLabel;
    Button1: TButton;
    Edit3: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    Edit6: TEdit;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    DateTimePicker1: TDateTimePicker;
    edit1: TComboBox;
    Label9: TLabel;
    Edit7: TEdit;
    Button3: TButton;
    Edit2: TComboBox;
    procedure FormCreate(Sender: TObject);
    procedure FormKeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure Button2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Edit2Select(Sender: TObject);


  private
    { Private declarations }
  public
    { Public declarations }
      bOK:bool;
  end;

var
  f_RealtyA321: Tf_RealtyA321;


implementation

uses data, main,RealtyA32,RealtyA11,RealtyA12,RealtyA13,RealtyA14,RealtyA15,Car4s931;
{$R *.dfm}

//初始化
procedure Tf_RealtyA321.FormCreate(Sender: TObject);
var
    query:TADOQuery;
    s,s1,s2,s3:string;
begin
     bok:=false;
     Caption:=f_RealtyA32.CaptionName+' '+'新增/修改';


     DateTimepicker1.Date:=date;

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

     if f_RealtyA32.pagecontrol1.ActivePageIndex=0 then  s1:='管理區(qū)';
     if f_RealtyA32.pagecontrol1.ActivePageIndex=1 then  s1:='樓宇';
     if f_RealtyA32.pagecontrol1.ActivePageIndex=2 then  s1:='房間';
     if f_RealtyA32.pagecontrol1.ActivePageIndex=3 then  s1:='停車場';
     if f_RealtyA32.pagecontrol1.ActivePageIndex=4 then  s1:='車位';




    edit2.Items.Add('新增驗收結(jié)果');
    query.SQL.Clear;
    query.SQL.Add('select * from 輔助資料 where 類別='''+'驗收結(jié)果'+'''');
    query.Open;
    while not query.Eof do
    begin
         edit2.Items.Add(query.fieldbyname('名稱').Value);
         query.Next;
    end;

     if f_RealtyA32.PageControl1.ActivePageIndex=0 then
     begin
        query.SQL.Clear;
        query.SQL.Add('select * from 房產(chǎn)驗收項目 where 類別='''+'管理區(qū)驗收項目'+'''');
        query.Open;
        while not query.Eof do
        begin
            edit1.Items.Add(query.fieldbyname('名稱').value);
            query.Next;
        end;

        Label9.Caption:='管理區(qū)';
     end;

     if f_RealtyA32.PageControl1.ActivePageIndex=1 then
     begin
        query.SQL.Clear;
        query.SQL.Add('select * from 房產(chǎn)驗收項目 where 類別='''+'樓宇驗收項目'+'''');
        query.Open;
        while not query.Eof do
        begin
            edit1.Items.Add(query.fieldbyname('名稱').value);
            query.Next;
        end;

        Label9.Caption:='樓宇';
     end;

     if f_RealtyA32.PageControl1.ActivePageIndex=2 then
     begin
        query.SQL.Clear;
        query.SQL.Add('select * from 房產(chǎn)驗收項目 where 類別='''+'房間驗收項目'+'''');
        query.Open;
        while not query.Eof do
        begin
            edit1.Items.Add(query.fieldbyname('名稱').value);
            query.Next;
        end;

        Label9.Caption:='房間';
     end;

     if f_RealtyA32.PageControl1.ActivePageIndex=3 then
     begin
        query.SQL.Clear;
        query.SQL.Add('select * from 房產(chǎn)驗收項目 where 類別='''+'停車場驗收項目'+'''');
        query.Open;
        while not query.Eof do
        begin
            edit1.Items.Add(query.fieldbyname('名稱').value);
            query.Next;
        end;

        Label9.Caption:='停車場';
     end;

     if f_RealtyA32.PageControl1.ActivePageIndex=4 then
     begin
        query.SQL.Clear;
        query.SQL.Add('select * from 房產(chǎn)驗收項目 where 類別='''+'車位驗收項目'+'''');
        query.Open;
        while not query.Eof do
        begin
            edit1.Items.Add(query.fieldbyname('名稱').value);
            query.Next;
        end;

        Label9.Caption:='車位';
     end;


     if f_RealtyA32.bMod=true then
     begin
          if f_RealtyA32.pagecontrol1.ActivePageIndex=0 then  s2:=f_RealtyA32.listview1.Selected.Subitems[7];
          if f_RealtyA32.pagecontrol1.ActivePageIndex=1 then  s2:=f_RealtyA32.listview2.Selected.Subitems[7];
          if f_RealtyA32.pagecontrol1.ActivePageIndex=2 then  s2:=f_RealtyA32.listview3.Selected.Subitems[7];
          if f_RealtyA32.pagecontrol1.ActivePageIndex=3 then  s2:=f_RealtyA32.listview4.Selected.Subitems[7];
          if f_RealtyA32.pagecontrol1.ActivePageIndex=4 then  s2:=f_RealtyA32.listview5.Selected.Subitems[7];

          if f_RealtyA32.pagecontrol1.ActivePageIndex=0 then  s3:=f_RealtyA32.listview1.Selected.Subitems[0];
          if f_RealtyA32.pagecontrol1.ActivePageIndex=1 then  s3:=f_RealtyA32.listview2.Selected.Subitems[0];
          if f_RealtyA32.pagecontrol1.ActivePageIndex=2 then  s3:=f_RealtyA32.listview3.Selected.Subitems[0];
          if f_RealtyA32.pagecontrol1.ActivePageIndex=3 then  s3:=f_RealtyA32.listview4.Selected.Subitems[0];
          if f_RealtyA32.pagecontrol1.ActivePageIndex=4 then  s3:=f_RealtyA32.listview5.Selected.Subitems[0];

         s:='select * from 房產(chǎn)驗收 where 所屬單位='''+s2;
        s:=s+''' and 類別='''+s1;
        s:=s+''' and 審核='''+'Y';
        s:=s+''' and 驗收項目='''+s3+'''';

        query.SQL.Clear;
        query.SQL.Add(s);
        query.Open;
        if query.RecordCount>0 then Button1.Enabled:=false;

         if f_RealtyA32.PageControl1.ActivePageIndex=0 then
         begin
             s1:=f_RealtyA32.ListView1.Selected.SubItems[7]+'--'+f_RealtyA32.ListView1.Selected.Caption;
             edit7.text:=s1;
             edit1.ItemIndex:=Edit1.Items.IndexOf(f_RealtyA32.ListView1.Selected.SubItems[0]);
             edit2.ItemIndex:=Edit2.Items.IndexOf(f_RealtyA32.ListView1.Selected.SubItems[1]);
             DateTimePicker1.Date:=strtodate(f_RealtyA32.ListView1.Selected.SubItems[2]);
             edit3.Text:=f_RealtyA32.ListView1.Selected.SubItems[3];
             edit4.Text:=f_RealtyA32.ListView1.Selected.SubItems[4];
             edit5.Text:=f_RealtyA32.ListView1.Selected.SubItems[5];
             edit6.Text:=f_RealtyA32.ListView1.Selected.SubItems[6];
         end;

         if f_RealtyA32.PageControl1.ActivePageIndex=1 then
         begin
             s1:=f_RealtyA32.ListView2.Selected.SubItems[7]+'--'+f_RealtyA32.ListView2.Selected.Caption;
             edit7.text:=s1;
             edit1.ItemIndex:=Edit1.Items.IndexOf(f_RealtyA32.ListView2.Selected.SubItems[0]);
             edit2.ItemIndex:=Edit2.Items.IndexOf(f_RealtyA32.ListView2.Selected.SubItems[1]);
             DateTimePicker1.Date:=strtodate(f_RealtyA32.ListView2.Selected.SubItems[2]);
             edit3.Text:=f_RealtyA32.ListView2.Selected.SubItems[3];
             edit4.Text:=f_RealtyA32.ListView2.Selected.SubItems[4];
             edit5.Text:=f_RealtyA32.ListView2.Selected.SubItems[5];
             edit6.Text:=f_RealtyA32.ListView2.Selected.SubItems[6];
         end;

         if f_RealtyA32.PageControl1.ActivePageIndex=2 then
         begin
             s1:=f_RealtyA32.ListView3.Selected.SubItems[7]+'--'+f_RealtyA32.ListView3.Selected.Caption;
             edit7.text:=s1;
             edit1.ItemIndex:=Edit1.Items.IndexOf(f_RealtyA32.ListView3.Selected.SubItems[0]);
             edit2.ItemIndex:=Edit2.Items.IndexOf(f_RealtyA32.ListView3.Selected.SubItems[1]);
             DateTimePicker1.Date:=strtodate(f_RealtyA32.ListView3.Selected.SubItems[2]);
             edit3.Text:=f_RealtyA32.ListView3.Selected.SubItems[3];
             edit4.Text:=f_RealtyA32.ListView3.Selected.SubItems[4];
             edit5.Text:=f_RealtyA32.ListView3.Selected.SubItems[5];
             edit6.Text:=f_RealtyA32.ListView3.Selected.SubItems[6];
         end;

         if f_RealtyA32.PageControl1.ActivePageIndex=3 then
         begin
             s1:=f_RealtyA32.ListView4.Selected.SubItems[7]+'--'+f_RealtyA32.ListView4.Selected.Caption;
             edit7.text:=s1;
             edit1.ItemIndex:=Edit1.Items.IndexOf(f_RealtyA32.ListView4.Selected.SubItems[0]);
             edit2.ItemIndex:=Edit2.Items.IndexOf(f_RealtyA32.ListView4.Selected.SubItems[1]);
             DateTimePicker1.Date:=strtodate(f_RealtyA32.ListView4.Selected.SubItems[2]);
             edit3.Text:=f_RealtyA32.ListView4.Selected.SubItems[3];
             edit4.Text:=f_RealtyA32.ListView4.Selected.SubItems[4];
             edit5.Text:=f_RealtyA32.ListView4.Selected.SubItems[5];
             edit6.Text:=f_RealtyA32.ListView4.Selected.SubItems[6];
         end;

         if f_RealtyA32.PageControl1.ActivePageIndex=4 then
         begin
             s1:=f_RealtyA32.ListView5.Selected.SubItems[7]+'--'+f_RealtyA32.ListView5.Selected.Caption;
             edit7.text:=s1;
             edit1.ItemIndex:=Edit1.Items.IndexOf(f_RealtyA32.ListView5.Selected.SubItems[0]);
             edit2.ItemIndex:=Edit2.Items.IndexOf(f_RealtyA32.ListView5.Selected.SubItems[1]);
             DateTimePicker1.Date:=strtodate(f_RealtyA32.ListView5.Selected.SubItems[2]);
             edit3.Text:=f_RealtyA32.ListView5.Selected.SubItems[3];
             edit4.Text:=f_RealtyA32.ListView5.Selected.SubItems[4];
             edit5.Text:=f_RealtyA32.ListView5.Selected.SubItems[5];
             edit6.Text:=f_RealtyA32.ListView5.Selected.SubItems[6];
         end;
     end;
end;

//Tab
procedure Tf_RealtyA321.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;


procedure Tf_RealtyA321.Button2Click(Sender: TObject);
begin
    close;
end;

procedure Tf_RealtyA321.Button1Click(Sender: TObject);
Var
     query:TADOQuery;
     s,s1,s2,s3,s4,r1,r2,r3:string;
begin
     if f_RealtyA32.pagecontrol1.ActivePageIndex=0 then  s1:='管理區(qū)';
     if f_RealtyA32.pagecontrol1.ActivePageIndex=1 then  s1:='樓宇';
     if f_RealtyA32.pagecontrol1.ActivePageIndex=2 then  s1:='房間';
     if f_RealtyA32.pagecontrol1.ActivePageIndex=3 then  s1:='停車場';
     if f_RealtyA32.pagecontrol1.ActivePageIndex=4 then  s1:='車位';

     if edit1.Text='' then
     begin
          showmessage('驗收項目不能為空');
          edit1.SetFocus;
          exit;
     end;

     if edit2.Text='' then
     begin
          showmessage('驗收結(jié)果不能為空');
          edit2.SetFocus;
          exit;
     end;

     if Edit7.Text='' then
     begin
         showmessage(s1+'不能為空');
         edit7.SetFocus;
         exit;
     end
     else s3:=mainform.getNum(Edit7.Text);
     s4:=mainform.getLastName(Edit7.Text);



     if edit2.Text='' then edit2.Text:='-';
     if edit3.Text='' then edit3.Text:='-';
     if edit4.Text='' then edit4.Text:='-';
     if edit5.Text='' then edit5.Text:='-';
     if edit6.Text='' then edit6.Text:='-';

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



     if  f_RealtyA32.bMod=false then
     begin
        query.SQL.Add('select * from 房產(chǎn)驗收 where 類別='''+s1+''' and 所屬單位='''+s3+''' and 驗收項目='''+edit1.Text+'''');
        query.Open;
        if query.RecordCount>0 then
        begin
           showmessage('驗收項目重復(fù)');
           edit1.SetFocus;
           exit;
        end;

        s:='insert into 房產(chǎn)驗收 (驗收項目,驗收結(jié)果,驗收日期,負(fù)責(zé)人,驗收人,驗收說明,備注,類別,所屬單位,審核)';
        s:=s+'values(:s1,:s2,:s3,:s4,:s5,:s6,:s7,:s8,:s9,:s10)';

        query.SQL.Clear;
        query.SQL.Add(s);

        query.Parameters.ParamByName('s1').Value:=edit1.Text;
        query.Parameters.ParamByName('s2').Value:=edit2.Text;
        query.Parameters.ParamByName('s3').Value:=datetostr(datetimepicker1.Date);
        query.Parameters.ParamByName('s4').Value:=edit3.Text;
        query.Parameters.ParamByName('s5').Value:=edit4.Text;
        query.Parameters.ParamByName('s6').Value:=edit5.Text;
        query.Parameters.ParamByName('s7').Value:=edit6.Text;
        query.Parameters.ParamByName('s8').Value:=s1;
        query.Parameters.ParamByName('s9').Value:=s3;
        query.Parameters.ParamByName('s10').Value:='N';

        DataModuleADO.ADOConnection1.BeginTrans;
        query.ExecSQL;
        DataModuleADO.ADOConnection1.CommitTrans;

        if f_RealtyA32.pagecontrol1.ActivePageIndex=0 then
        with f_RealtyA32.ListView1.Items.Add do
        begin
            Caption:=s4;
            subitems.Add(edit1.Text);
            subitems.Add(edit2.Text);
            subitems.Add(datetostr(datetimepicker1.Date));
            subitems.Add(edit3.Text);
            subitems.Add(edit4.Text);
            subitems.Add(edit5.Text);
            subitems.Add(edit6.Text);
            subitems.Add(s3);
        end;

        if f_RealtyA32.pagecontrol1.ActivePageIndex=1 then
        with f_RealtyA32.ListView2.Items.Add do
        begin
            Caption:=s4;