sort.pas

这是应一个市委的朋友要求给做一个物品管理软件。 初始密码:admin

unit sort;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ExtCtrls, Grids, DBGridEh, Menus, StdCtrls, EhLibADO;

type
  Tfsort = class(TForm)
    Panel1: TPanel;
    Panel2: TPanel;
    PopupMenu1: TPopupMenu;
    A1: TMenuItem;
    M1: TMenuItem;
    D1: TMenuItem;
    R1: TMenuItem;
    N1: TMenuItem;
    L1: TMenuItem;
    Label1: TLabel;
    Label2: TLabel;
    rb1: TRadioButton;
    rb2: TRadioButton;
    Label3: TLabel;
    tb_name: TEdit;
    Button1: TButton;
    Button2: TButton;
    dg_view: TDBGridEh;
    procedure Button2Click(Sender: TObject);
    procedure R1Click(Sender: TObject);
    procedure rb1KeyPress(Sender: TObject; var Key: Char);
    procedure tb_nameKeyPress(Sender: TObject; var Key: Char);
    procedure Button1Click(Sender: TObject);
    procedure A1Click(Sender: TObject);
    procedure M1Click(Sender: TObject);
    procedure D1Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure L1Click(Sender: TObject);
    procedure rb1Click(Sender: TObject);
    procedure dg_viewKeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
  private
    flag : char;
    { Private declarations }
  public
    { Public declarations }
  end;

var
  fsort: Tfsort;

implementation
uses dm,vks;

{$R *.dfm}

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

procedure Tfsort.R1Click(Sender: TObject);
begin
  fdm.qsort.Close;
  if rb1.Checked then fdm.qsort.Filter := 'type=''S''' else fdm.qsort.Filter := 'type=''O''';
  fdm.qsort.Filtered := true;
  fdm.qsort.Open;
end;

procedure Tfsort.rb1KeyPress(Sender: TObject; var Key: Char);
begin
  if key=#13 then tb_name.SetFocus;
end;

procedure Tfsort.tb_nameKeyPress(Sender: TObject; var Key: Char);
begin
  if (key=#13) and (tb_name.Text<>'') then Button1Click(Sender);
end;

procedure Tfsort.Button1Click(Sender: TObject);
var
  cnt : string;
  sflag : char;
begin
  if tb_name.Text='' then
  begin
    vks.info(1009);
    tb_name.SetFocus;
    exit;
  end;
  with fdm.q do
  begin
    close;
    if rb1.Checked then sflag:='S' else sflag:='O';
    sql.Text := 'select count(1) as cnt from [sort] where type='''+sflag+''' and name='''+tb_name.Text+'''';
    if flag='M' then sql.Text := sql.Text + ' and id<>'+dg_view.Fields[0].AsString;
    try
      Open;
      cnt := FieldByName('cnt').AsString;
      close;
      if cnt<>'0' then
      begin
        vks.info(1010);
        exit;
      end;
      if flag='A' then
        sql.Text := 'insert into [sort](name,type) values('''+tb_name.Text+''','''+sflag+''')'
      else
        sql.Text := 'update [sort] set name='''+tb_name.Text+''',type='''+sflag+''' where id='+dg_view.Fields[0].AsString;
      try
        execsql;
        A1Click(Sender);
        R1Click(Sender);
      except
        close;
        vks.info(1008);
      end;
    except
      close;
      vks.info(1008);
    end;
  end;
end;

procedure Tfsort.A1Click(Sender: TObject);
begin
  flag := 'A';
  tb_name.Clear;
  tb_name.SetFocus;
end;

procedure Tfsort.M1Click(Sender: TObject);
begin
if fdm.qsort.RecordCount>0 then
  begin
    flag := 'M';
    tb_name.Text := dg_view.Fields[1].AsString;
    if dg_view.Fields[2].AsString='物品类别' then rb1.Checked:=true else rb2.Checked:=true;
    tb_name.SetFocus;
  end;
end;

procedure Tfsort.D1Click(Sender: TObject);
begin
if (fdm.qsort.RecordCount>0) and (vks.box('确定要删除本数据吗?'#13#10'如果没有关联数据,将能被删除.','操作员数据删除窗口')) then
begin
  with fdm.q do
  begin
    close;
    sql.Text := 'delete from [sort] where id='+dg_view.Fields[0].AsString;
    try
      execsql;
      A1Click(Sender);
      R1Click(Sender);
      close;
    except
      close;
      vks.info(1008);
    end;
  end;
end;
end;

procedure Tfsort.FormShow(Sender: TObject);
begin
  flag := 'A';
  R1Click(Sender);
end;

procedure Tfsort.L1Click(Sender: TObject);
begin
  with fdm.q do
  begin
    close;
    sql.Text := 'update [sort] set flag=not flag where id='+dg_view.Fields[0].AsString;
    try
      execsql;
      A1Click(Sender);
      R1Click(Sender);
      close;
    except
      close;
      vks.info(1008);
    end;
  end;
end;

procedure Tfsort.rb1Click(Sender: TObject);
begin
  R1Click(Sender);
end;

procedure Tfsort.dg_viewKeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  if key=vk_f3 then A1Click(Sender);
  if key=vk_f4 then M1Click(Sender);
  if key=vk_delete then D1Click(Sender);
  if key=vk_f5 then R1Click(Sender);
  if key=vk_f6 then L1Click(Sender);
end;

end.