realtyj21.pas

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

unit RealtyJ21;

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_RealtyJ21 = class(TForm)
    L1: TLabel;
    Label4: TLabel;
    Edit1: TEdit;
    Label1: TLabel;
    Label6: TLabel;
    Label17: TLabel;
    edit6: TEdit;
    ListView1: TListView;
    edit2: TDateTimePicker;
    Label19: TLabel;
    edit5: TComboBox;
    Label2: TLabel;
    Edit7: TEdit;
    Label3: TLabel;
    edit4: TDateTimePicker;
    Button6: TButton;
    Button8: TButton;
    PopupMenu1: TPopupMenu;
    N4: TMenuItem;
    N8: TMenuItem;
    D1: TMenuItem;
    Button1: TButton;
    Label12: TLabel;
    Edit3: TEdit;
    Button2: TButton;
    procedure FormKeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure FormCreate(Sender: TObject);
    procedure ToolButton10Click(Sender: TObject);
    procedure getId;

    procedure N4Click(Sender: TObject);
    procedure N8Click(Sender: TObject);
    procedure D1Click(Sender: TObject);
    procedure ListView1MouseDown(Sender: TObject; Button: TMouseButton;
      Shift: TShiftState; X, Y: Integer);
    procedure Button6Click(Sender: TObject);
    procedure Button8Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    { Public declarations }
       bOK:bool;
       ss:string;
  end;

var
  f_RealtyJ21: Tf_RealtyJ21;
  sNum:string;

implementation

uses data, main,Car4s931,RealtyJ1,RealtyPrint1,RealtyJA21,RealtyA11,RealtyChange3;

{$R *.dfm}

procedure Tf_RealtyJ21.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, 13, 4);
        i := strtoint(s)+1;
        if i<10 then Edit1.Text := 'CG' + datetostr(date)+'000'+inttostr(i)
        else if (i > 9) and (i<100) then Edit1.Text := 'CG' + datetostr(date)+'00'+inttostr(i)
        else if (i > 99) and (i<1000) then Edit1.Text := 'CG' + datetostr(date)+'0'+inttostr(i)
        else if i>999 then Edit1.Text := 'CG' + datetostr(date)+inttostr(i);
    end
    else  Edit1.Text := 'CG' + datetostr(date)+'0001';
    Query.Close;
    Query.Free;
end;

procedure Tf_RealtyJ21.FormCreate(Sender: TObject);
var
    i:integer;
    s:string;
    query:TADOQuery;
begin

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


    edit5.Items.Add('年度');
    edit5.Items.Add('第一季度');
    edit5.Items.Add('第二季度');
    edit5.Items.Add('第三季度');
    edit5.Items.Add('第四季度');
    edit5.Items.Add('一月份');
    edit5.Items.Add('二月份');
    edit5.Items.Add('三月份');
    edit5.Items.Add('四月份');
    edit5.Items.Add('五月份');
    edit5.Items.Add('六月份');
    edit5.Items.Add('七月份');
    edit5.Items.Add('八月份');
    edit5.Items.Add('九月份');
    edit5.Items.Add('十月份');
    edit5.Items.Add('十一月份');
    edit5.Items.Add('十二月份');


    if f_RealtyJA21.bNew=true then
    begin
        edit2.date:=date;
        getId;
        edit7.Text:=czy;
    end;

    if f_RealtyJA21.bNew=false then
    begin
        if f_RealtyJA21.ListView1.Selected.SubItems[5]='Y' then button6.Enabled:=false;

        query.SQL.Clear;
        query.SQL.Add('select * from 采购计划 where 单号='''+f_RealtyJA21.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;
            edit4.date:=strtodate(query.fieldbyname('计划年度').Value+'-01-01');
            edit5.ItemIndex:=edit5.Items.IndexOf(query.fieldbyname('计划区间').Value);
            edit6.Text:=query.fieldbyname('备注').Value;
            edit7.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_RealtyJ21.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_RealtyJ21.ToolButton10Click(Sender: TObject);
begin
    close;
end;



procedure Tf_RealtyJ21.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 ;
        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('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_RealtyJ21.N8Click(Sender: TObject);
var
    d,d1,d2:double;
begin
    f_RealtyChange3:=Tf_RealtyChange3.Create(self);
    f_RealtyChange3.ShowModal;


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

end;

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

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

    listview1.selected.delete;

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