realtyj3.pas

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

unit RealtyJ3;

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_RealtyJ3 = class(TForm)
    L1: TLabel;
    Label4: TLabel;
    Edit1: TEdit;
    Label1: TLabel;
    Label6: 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;
    Button6: TButton;
    Button8: TButton;
    Button2: TButton;
    Edit7: TEdit;
    Label12: TLabel;
    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 N4Click(Sender: TObject);
    procedure N8Click(Sender: TObject);
    procedure N10Click(Sender: TObject);
    procedure ListView1MouseDown(Sender: TObject; Button: TMouseButton;
      Shift: TShiftState; X, Y: Integer);
    procedure Button6Click(Sender: TObject);
    procedure Button8Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure edit6Select(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
       bOK:bool;
       ss:string;
  end;

var
  f_RealtyJ3: Tf_RealtyJ3;
  sNum:string;

implementation

uses data, main,RealtyL23,RealtyJ31,Car4s931,RealtyChange1,realtyUse,
     RealtyJ3A,RealtyPrint1,RealtyJA3,realtyA11;

{$R *.dfm}

procedure Tf_RealtyJ3.getid;
var
    i:integer;
    query:TADOQuery;
    s:string;
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 := 'C' + datetostr(date)+'000'+inttostr(i)
        else if (i > 9) and (i<100) then Edit1.Text := 'C' + datetostr(date)+'00'+inttostr(i)
        else if (i > 99) and (i<1000) then Edit1.Text := 'C' + datetostr(date)+'0'+inttostr(i)
        else if i>999 then Edit1.Text := 'C' + datetostr(date)+inttostr(i);
    end
    else  Edit1.Text := 'C' + datetostr(date)+'0001';
    Query.Close;
    Query.Free;
end;

procedure Tf_RealtyJ3.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_RealtyJA3.bNew=true then
    begin
        edit2.date:=date;
        getId;
        edit4.Text:=czy;
    end;

    if f_RealtyJA3.bNew=false then
    begin
        if f_RealtyJA3.ListView1.Selected.SubItems[6]='Y' then button6.Enabled:=false;
        query.SQL.Clear;
        query.SQL.Add('select * from 出库单 where 单号='''+f_RealtyJA3.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;
            edit4.Text:=query.fieldbyname('操作员').Value;
        end;

        query.SQL.Clear;
        query.SQL.Add('select * from 出库单明细 where 单号='''+f_RealtyJA3.ListView1.Selected.Caption+'''');
        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_RealtyJ3.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_RealtyJ3.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_RealtyJ3.ToolButton10Click(Sender: TObject);
begin
    close;
    mainform.bRealtyJ3:=false;
end;

procedure Tf_RealtyJ3.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_RealtyJ3.Button7Click(Sender: TObject);
begin
    f_realtyUse:=Tf_realtyUse.Create(self);
    f_realtyUse.Button2.Visible:=true;
    f_realtyUse.ShowModal;

    if  f_realtyUse.bOk=true then
    begin
        edit8.Text:=f_realtyUse.sname;
    end;
end;

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

procedure Tf_RealtyJ3.N4Click(Sender: TObject);
var
    query:TADOQuery;
    i:integer;
    d,d1,d2:double;
begin
    if edit5.Text='' then
    begin
        showmessage('请先选择仓库');
        exit;
    end;
    f_RealtyJ3A:=Tf_RealtyJ3A.Create(self);
    f_RealtyJ3A.ShowModal;

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

        Query.SQL.Add('select * from 库存  where 物料编号='''+f_RealtyJ3A.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;
            query.Next;
        end;
        query.Close;
        query.Free;
    end; 

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

end;

procedure Tf_RealtyJ3.N8Click(Sender: TObject);
var
    query:TADOQuery;
    d,d1,d2:double;
begin
    if listview1.SelCount=0 then exit;
    f_RealtyChange1:=Tf_RealtyChange1.Create(self);
    f_RealtyChange1.ShowModal;   

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