realtyj2.pas

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

unit RealtyJ2;

interface

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

type
    Tf_RealtyJ2 = class(TForm)
    L1: TLabel;
    Label4: TLabel;
    Edit1: TEdit;
    Label1: TLabel;
    Label6: TLabel;
    Label12: TLabel;
    Label13: TLabel;
    Edit3: TEdit;
    Label15: TLabel;
    edit8: TEdit;
    Label17: TLabel;
    edit9: TEdit;
    Label18: TLabel;
    Edit5: TEdit;
    ListView1: TListView;
    Button1: TButton;
    edit2: TDateTimePicker;
    Button3: TButton;
    Label19: TLabel;
    edit6: TComboBox;
    Button7: TButton;
    Label2: TLabel;
    Edit4: TEdit;
    PopupMenu1: TPopupMenu;
    N4: TMenuItem;
    N8: TMenuItem;
    N10: TMenuItem;
    Button5: TButton;
    Button6: TButton;
    Button8: TButton;
    Label3: TLabel;
    Edit10: TEdit;
    Edit7: TEdit;
    Button2: TButton;
    procedure FormKeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure Button1Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure ToolButton10Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure getId;
    procedure Button7Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure ToolButton1Click(Sender: TObject);
    procedure N4Click(Sender: TObject);
    procedure N8Click(Sender: TObject);
    procedure N10Click(Sender: TObject);
    procedure ListView1MouseDown(Sender: TObject; Button: TMouseButton;
      Shift: TShiftState; X, Y: Integer);
    procedure Button4Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
    procedure Button8Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure Button10Click(Sender: TObject);
    procedure edit6Select(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
       bOK:bool;
       ss:string;
  end;

var
  f_RealtyJ2: Tf_RealtyJ2;
  sNum:string;

implementation

uses data, main,RealtyL23,RealtyJ31,Car4s931,RealtyJ1,RealtyChange,
     realtyPro,RealtyJA21,RealtyPrint1,RealtyJA2,realtyA11;

{$R *.dfm}

procedure Tf_RealtyJ2.getid;
var
    Query:TADOQuery;
    s:string;
    i:integer;
begin
    s := 'select * from 入库单 where 日期=''' + datetostr(edit2.date)+''' ORDER BY 单号 DESC';
    Query:=TADOQuery.Create(nil);
    Query.Connection:=DataModuleADO.ADOConnection1;
    Query.SQL.Add(s);
    Query.Open ;
    if query.recordcount > 0 then
    begin
        s := query.Fieldbyname('单号').AsString;
        s := Copy(S, 12, 4);
        i := strtoint(s)+1;
        if i<10 then Edit1.Text := 'L' + datetostr(date)+'000'+inttostr(i)
        else if (i > 9) and (i<100) then Edit1.Text := 'L' + datetostr(date)+'00'+inttostr(i)
        else if (i > 99) and (i<1000) then Edit1.Text := 'L' + datetostr(date)+'0'+inttostr(i)
        else if i>999 then Edit1.Text := 'L' + datetostr(date)+inttostr(i);
    end
    else  Edit1.Text := 'L' + datetostr(date)+'0001';
    
    Query.Close;
    Query.Free;
end;

procedure Tf_RealtyJ2.FormCreate(Sender: TObject);
var
    i:integer;
    s:string;
    query:TADOQuery;
begin
    Query:=TADOQuery.Create(nil);
    Query.Connection:=DataModuleADO.ADOConnection1;

    edit6.items.Add('新增业务类型');
    query.SQL.Clear;
    query.SQL.Add('select * from 辅助资料 where 类别='''+'业务类型'+'''');
    query.Open;
    while not query.Eof do
    begin
        edit6.Items.Add(Query.FieldByName('名称').Value);
        query.next;
    end;



    if f_RealtyJA2.bNew=true then
    begin
        edit2.date:=date;
        getId;
        edit4.Text:=czy;
    end;

    if f_RealtyJA2.bNew=false then
    begin
        if f_RealtyJA2.ListView1.Selected.SubItems[6]='Y' THEN
        begin
            button6.Enabled:=false;
            button5.Enabled:=false;
        end;
        
        query.SQL.Clear;
        query.SQL.Add('select * from 入库单 where 单号='''+f_RealtyJA2.ListView1.Selected.Caption+'''');
        query.open;
        if query.RecordCount>0 then
        begin
            edit1.Text:=query.fieldbyname('单号').Value;
            edit2.date:=strtodate(query.fieldbyname('日期').Value);
            edit3.Text:=query.fieldbyname('经手人').Value;

            edit7.text:=query.fieldbyname('部门').Value;
            edit5.Text:=query.fieldbyname('仓库').Value;
            edit6.ItemIndex:=edit6.Items.IndexOf(query.fieldbyname('业务类型').Value);
            edit8.Text:=query.fieldbyname('供应商').Value;
            edit9.Text:=query.fieldbyname('备注').Value;
            edit10.Text:=query.fieldbyname('采购入库单').Value;
            edit4.Text:=query.fieldbyname('操作员').Value;
        end;

        query.SQL.Clear;
        query.SQL.Add('select * from 入库单明细 where 单号='''+edit1.Text+'''');
        query.open;
        while not query.Eof do
        begin
            with listview1.Items.Add do
            begin
                caption:=query.fieldbyname('物料编号').Value;
                subitems.Add(query.fieldbyname('物料名称').value);
                subitems.Add(query.fieldbyname('规格型号').value);
                subitems.Add(query.fieldbyname('计量单位').value);
                subitems.Add(query.fieldbyname('数量').value);
                subitems.Add(query.fieldbyname('单价').value);
                subitems.Add(query.fieldbyname('金额').value);
            end;
            query.Next;
        end;
    end; 
    query.Close;
    query.Free;




end;

//Tab
procedure Tf_RealtyJ2.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_RealtyJ2.Button1Click(Sender: TObject);
begin
    f_RealtyL23:=Tf_RealtyL23.Create(self);
    f_RealtyL23.Button2.Visible:=true;
    f_RealtyL23.ShowModal;

    if  f_RealtyL23.bOk=true then
    begin
       edit3.Text:=f_RealtyL23.sName;
    end;
end;


procedure Tf_RealtyJ2.ToolButton10Click(Sender: TObject);
begin
    close;
    mainform.bRealtyJ2:=false;
end;

procedure Tf_RealtyJ2.Button3Click(Sender: TObject);
begin
    f_RealtyJ31:=Tf_RealtyJ31.Create(self);
    f_RealtyJ31.Button1.Visible:=true;
    f_RealtyJ31.ShowModal;

    if  f_RealtyJ31.bOk=true then
    begin
        edit5.Text:=f_RealtyJ31.ListView1.Selected.SubItems[0];
    end;
end;  


procedure Tf_RealtyJ2.Button7Click(Sender: TObject);
begin
    f_realtyPro:=Tf_realtyPro.Create(self);
    f_realtyPro.Button2.Visible:=true;
    f_realtyPro.ShowModal;

    if  f_realtyPro.bOk=true then
    begin
        edit8.Text:=f_realtyPro.sName;
    end;
end;


procedure Tf_RealtyJ2.FormClose(Sender: TObject; var Action: TCloseAction);
begin
    mainform.bRealtyJ2:=false;
    Action := caFree;
end;

procedure Tf_RealtyJ2.ToolButton1Click(Sender: TObject);

begin
   //
end;

procedure Tf_RealtyJ2.N4Click(Sender: TObject);
var
    query:TADOQuery;
    i:integer;
    d,d1,d2:double;
begin
    f_RealtyJ1:=Tf_RealtyJ1.Create(self);
    f_RealtyJ1.toolButton6.Visible:=true;
    f_RealtyJ1.ShowModal;

    if  f_RealtyJ1.bOK=true then
    begin
        Query:=TADOQuery.Create(nil);
        Query.Connection:=DataModuleADO.ADOConnection1;

        Query.SQL.Add('select * from 物料档案  where 编号='''+f_RealtyJ1.sNum+'''');
        Query.Open ;
        if query.RecordCount>0 then
        begin
            with listview1.items.add do
            begin
                caption:=query.fieldbyname('编号').value;
                subitems.add(query.fieldbyname('名称').value);
                subitems.add(query.fieldbyname('规格型号').value);
                subitems.add(query.fieldbyname('计量单位').value);
                subitems.add('0');
                subitems.add(query.fieldbyname('单价').value);
                subitems.add('0');
            end;
        end;
        query.Close;
        query.Free;
    end;
    if listview1.Items.Count>0 then listview1.Items.Item[0].Selected:=true;

end;

procedure Tf_RealtyJ2.N8Click(Sender: TObject);
var
    d,d1,d2:double;
begin
    if listview1.SelCount=0 then exit;

    mainform.t1:=listview1.Selected.SubItems[3];
    mainform.t2:=listview1.Selected.SubItems[4];

    f_RealtyChange:=Tf_RealtyChange.Create(self);
    f_RealtyChange.ShowModal;


    if  f_RealtyChange.bok=true then
    begin
        listview1.Selected.SubItems[3]:=f_RealtyChange.Edit1.Text;
        listview1.Selected.SubItems[4]:=f_RealtyChange.Edit2.Text;
        listview1.Selected.SubItems[5]:=floattostr(strtofloat(f_RealtyChange.Edit2.Text)*strtofloat(f_RealtyChange.Edit1.Text));
    end;
end;

procedure Tf_RealtyJ2.N10Click(Sender: TObject);
begin
    if listview1.SelCount=0 then exit;

    if(Application.MessageBox(PChar('确认要删除所选记录吗?') ,'提示',Mb_OKCANCEL+Mb_IconInformation)=0) then exit;

    listview1.selected.delete;

    if listview1.Items.Count>0 then listview1.Items.Item[0].Selected:=true;
end;

procedure Tf_RealtyJ2.ListView1MouseDown(Sender: TObject;
  Button: TMouseButton; Shift: TShiftState; X, Y: Integer);
begin
    if button=mbright then
    PopupMenu1.Popup(mouse.CursorPos.X,mouse.CursorPos.Y);
end;

procedure Tf_RealtyJ2.Button4Click(Sender: TObject);
var
    Query:TADOQuery;
begin
    Query:=TADOQuery.Create(nil);
    Query.Connection:=DataModuleADO.ADOConnection1;

    query.sql.add('select * from 入库单 where 单号='''+edit1.text+'''and 审核='''+'Y'+'''');
    query.open;
    if query.recordcount>0 then
    begin
        showmessage('已经审核，不能删除');
        query.close;
        query.free;
        exit;
    end;

    if(Application.MessageBox(PChar('确认要删除所选记录吗?') ,'提示',Mb_OKCANCEL+Mb_IconInformation)=0) then exit;

    DataModuleADO.ADOConnection1.BeginTrans;
    query.sql.clear;
    Query.SQL.Text:='delete  from 入库单明细 where 单号='''+edit1.Text+'''';
    query.ExecSQL;
    DataModuleADO.ADOConnection1.CommitTrans;


    DataModuleADO.ADOConnection1.BeginTrans;
    query.sql.clear;
    Query.SQL.Text:='delete  from 入库单 where 单号='''+edit1.Text+'''';
    query.ExecSQL;
    DataModuleADO.ADOConnection1.CommitTrans;


    query.Close;
    query.Free;

    edit1.Text:='';
    edit2.date:=date;
    edit3.Text:='';
    edit5.Text:='';
    edit6.Text:='';
    edit7.Text:='';
    edit8.Text:='';
    edit9.Text:='';

    listview1.Items.Clear;

end;

procedure Tf_RealtyJ2.Button6Click(Sender: TObject);
var
  i,j:integer;
  s,s1,s2,s3:string;