uni_item.pas

来自「一个非常不错的经费报销管理软件」· PAS 代码 · 共 211 行

unit Uni_Item;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Menus, XPMenu, ComCtrls, ToolWin, ExtCtrls, DB, StdCtrls, Mask,
  DBCtrls, ADODB, StrUtils;

type
  TFrm_Item = class(TForm)
    TB_Main: TToolBar;
    TB_Insert: TToolButton;
    TB_Update: TToolButton;
    TB_Delete: TToolButton;
    TB_Post: TToolButton;
    TB_Cancel: TToolButton;
    TB_Refresh: TToolButton;
    TB_Help: TToolButton;
    TB_Close: TToolButton;
    XPMenu1: TXPMenu;
    PopupMenu1: TPopupMenu;
    N_State: TMenuItem;
    Tree: TTreeView;
    Panel1: TPanel;
    P_Edit: TPanel;
    Splitter1: TSplitter;
    Label1: TLabel;
    DB_cClassNum: TDBEdit;
    DataSource1: TDataSource;
    Label2: TLabel;
    DBEdit2: TDBEdit;
    CoolBar1: TCoolBar;
    StatusBar1: TStatusBar;
    ToolButton1: TToolButton;
    ToolButton2: TToolButton;
    ToolButton3: TToolButton;
    ToolButton4: TToolButton;
    procedure N_StateClick(Sender: TObject);
    procedure TB_RefreshClick(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure TreeClick(Sender: TObject);
    procedure TB_InsertClick(Sender: TObject);
    procedure TB_UpdateClick(Sender: TObject);
    procedure TB_DeleteClick(Sender: TObject);
    procedure TB_PostClick(Sender: TObject);
    procedure TB_CancelClick(Sender: TObject);
    procedure TB_CloseClick(Sender: TObject);
    procedure TreeDblClick(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    { Public declarations }
    strid,strNo,strName:string;
  end;

var
//  iGrade:Integer;
  Frm_Item: TFrm_Item;

implementation

uses Uni_Function,Uni_dm,Uni_Main;

{$R *.dfm}

procedure TFrm_Item.N_StateClick(Sender: TObject);
var
  i:Integer;
begin
  for i :=0  to TB_Main.ButtonCount-1  do TB_Main.Buttons[i].Enabled:=not TB_Main.Buttons[i].Enabled;
  P_Edit.Enabled:=TB_Post.Enabled;

end;

procedure TFrm_Item.TB_RefreshClick(Sender: TObject);
begin
  TreeRead('bsItem');
  Tree.Items.Clear;
  Tree.LoadFromFile('SPTREE.TXT');
  Tree.TopItem.Expanded:=True;
end;

procedure TFrm_Item.FormShow(Sender: TObject);
begin
  TB_RefreshClick(Sender);
  if Choosed then TB_Main.Visible:=False;
end;

procedure TFrm_Item.TreeClick(Sender: TObject);
var
  L,R:Integer;
  str:String;
begin
  L:=Pos('[',(Sender as TTreeView).Selected.Text);
  R:=Pos(']',(Sender as TTreeView).Selected.Text);
  str:=MidBStr((Sender as TTreeView).Selected.Text,L+1,R-L-1);
  //
  with DM do
  begin
    bsItem.Close;
    bsItem.Open;
    if not bsItem.Locate('cNum',str,[]) then
    begin
      MessageBoxError('获取经费项目数据错误！');
    end;
    //else
    //begin
    //  iGrade:=bsItem.FieldByName('iGrade').AsInteger;
    //end;
  end;
end;

procedure TFrm_Item.TB_InsertClick(Sender: TObject);
begin
  N_StateClick(Sender);
  with DM do
  begin
    bsItem.Insert;
    bsItem.FieldByName('id').AsString:=GetGUID;
    bsItem.FieldByName('istate').AsInteger:=0;
    bsItem.Post;
  end;
end;

procedure TFrm_Item.TB_UpdateClick(Sender: TObject);
begin
  N_StateClick(Sender);
end;

procedure TFrm_Item.TB_DeleteClick(Sender: TObject);
begin
  if (Tree.Selected.Index<0) or (Tree.Selected.Count>0)  then Exit;
  if DM.bsItem.FieldByName('cNum').AsString='0' then Exit;
  if not DM.bsItem.IsEmpty then
  begin
    DM.bsItem.Edit;
    DM.bsItem.FieldByName('iState').AsInteger:=-1;
    DM.bsItem.Post;
  end;
  TB_RefreshClick(Sender);
end;

procedure TFrm_Item.TB_PostClick(Sender: TObject);
begin
  {//
  if MessageBoxQuery('请确认，上级科目是'+Tree.Selected.Text+'，保存吗？')=IDNO then
  begin
    TB_CancelClick(Sender);
    Exit;
  end;
  //}
  N_StateClick(Sender);
  DM.bsItem.Edit;
  DM.bsItem.FieldByName('iState').AsInteger:=1;
  DM.bsItem.FieldByName('iGrade').AsInteger:=Length(Trim(DB_cClassNum.Text)) div 2;
  DM.bsItem.Post;
  TB_RefreshClick(Sender);
end;

procedure TFrm_Item.TB_CancelClick(Sender: TObject);
begin
  N_StateClick(Sender);
  DM.bsItem.Cancel;
  if DM.bsItem.FieldByName('iState').AsInteger=0 then
    DM.bsItem.Delete;
end;

procedure TFrm_Item.TB_CloseClick(Sender: TObject);
begin
  Close;
end;

procedure TFrm_Item.TreeDblClick(Sender: TObject);
begin
  if (Choosed) and (Tree.Selected.Count<=0) then
  begin
    try
      strid:=DM.bsItem.FieldByName('id').AsString;
      strNo:=DM.bsItem.FieldByName('cNum').AsString;
      strName:=DM.bsItem.FieldByName('cName').AsString;
      {
      with DM do
      begin
        if trim(TBname)='' then
        begin
          strid:=bsItem.FieldByName('id').AsString;
        end
        else
        begin
          TADOQuery(FindComponent(TBname)).Edit;
          TADOQuery(FindComponent(TBname)).FieldByName('cItemNum').AsString:=bsItem.FieldByName('id').AsString;
        end;
      end;
      }
    //
    except
      MessageBoxInfo('科目选取失败！');
    end;
    Close;
  end;
end;

procedure TFrm_Item.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  Choosed:=False;
end;

end.