fix.pas

劳保用品管理系统

unit fix;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  StdCtrls, Buttons, ExtCtrls, Db, DBTables,ADODB,ComCtrls, Grids, DBGrids;

type
  Tfixfm = class(TForm)
    Panel1: TPanel;
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    TabSheet3: TTabSheet;
    TabSheet4: TTabSheet;
    TabSheet5: TTabSheet;
    TabSheet6: TTabSheet;
    TabSheet7: TTabSheet;
    Panel2: TPanel;
    Panel3: TPanel;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    Label13: TLabel;
    Label14: TLabel;
    Label15: TLabel;
    Label16: TLabel;
    Label18: TLabel;
    Label19: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    Edit6: TEdit;
    Edit7: TEdit;
    ComboBox1: TComboBox;
    ComboBox2: TComboBox;
    ComboBox3: TComboBox;
    ComboBox4: TComboBox;
    ComboBox5: TComboBox;
    ComboBox6: TComboBox;
    ComboBox7: TComboBox;
    Edit8: TEdit;
    ComboBox8: TComboBox;
    BitBtn1: TBitBtn;
    DBGrid1: TDBGrid;
    Label21: TLabel;
    Panel5: TPanel;
    Panel4: TPanel;
    Panel6: TPanel;
    Label17: TLabel;
    Label20: TLabel;
    Label23: TLabel;
    BitBtn2: TBitBtn;
    BitBtn3: TBitBtn;
    Edit9: TEdit;
    Edit11: TEdit;
    Panel7: TPanel;
    Panel8: TPanel;
    Panel9: TPanel;
    Panel12: TPanel;
    Panel13: TPanel;
    DBGrid2: TDBGrid;
    DBGrid3: TDBGrid;
    Label36: TLabel;
    Label37: TLabel;
    Edit20: TEdit;
    BitBtn6: TBitBtn;
    Label38: TLabel;
    Label39: TLabel;
    DBGrid6: TDBGrid;
    Edit14: TEdit;
    Label26: TLabel;
    Panel14: TPanel;
    Label40: TLabel;
    DBGrid7: TDBGrid;
    Panel19: TPanel;
    Panel20: TPanel;
    Panel21: TPanel;
    Panel22: TPanel;
    DBGrid11: TDBGrid;
    DBGrid12: TDBGrid;
    DBGrid15: TDBGrid;
    Label50: TLabel;
    Label53: TLabel;
    Label55: TLabel;
    Edit23: TEdit;
    DBGrid14: TDBGrid;
    Label54: TLabel;
    DBGrid13: TDBGrid;
    DBGrid16: TDBGrid;
    Panel23: TPanel;
    Panel24: TPanel;
    Label56: TLabel;
    Label57: TLabel;
    Label58: TLabel;
    Label59: TLabel;
    Label60: TLabel;
    Edit24: TEdit;
    Label61: TLabel;
    Edit26: TEdit;
    Label63: TLabel;
    Label64: TLabel;
    Edit27: TEdit;
    BitBtn12: TBitBtn;
    BitBtn13: TBitBtn;
    Label65: TLabel;
    Label66: TLabel;
    Edit28: TEdit;
    Edit29: TEdit;
    BitBtn14: TBitBtn;
    Label62: TLabel;
    Edit25: TEdit;
    Label67: TLabel;
    Edit30: TEdit;
    Label69: TLabel;
    Edit32: TEdit;
    BitBtn15: TBitBtn;
    Label70: TLabel;
    Label71: TLabel;
    Edit33: TEdit;
    Edit34: TEdit;
    BitBtn16: TBitBtn;
    DBGrid17: TDBGrid;
    Button1: TButton;
    Panel25: TPanel;
    Panel26: TPanel;
    Panel27: TPanel;
    DBGrid18: TDBGrid;
    DBGrid19: TDBGrid;
    DBGrid20: TDBGrid;
    DBGrid21: TDBGrid;
    BitBtn17: TBitBtn;
    BitBtn18: TBitBtn;
    Label68: TLabel;
    Edit31: TEdit;
    Label72: TLabel;
    DBGrid22: TDBGrid;
    BitBtn19: TBitBtn;
    BitBtn21: TBitBtn;
    BitBtn20: TBitBtn;
    Label74: TLabel;
    Label75: TLabel;
    Label76: TLabel;
    Label77: TLabel;
    Edit35: TEdit;
    Edit36: TEdit;
    Edit37: TEdit;
    BitBtn22: TBitBtn;
    TabSheet10: TTabSheet;
    StatusBar1: TStatusBar;
    DBGrid23: TDBGrid;
    Memo1: TMemo;
    BitBtn23: TBitBtn;
    Label80: TLabel;
    Label22: TLabel;
    Edit10: TEdit;
    BitBtn24: TBitBtn;
    BitBtn25: TBitBtn;
    BitBtn26: TBitBtn;
    Panel15: TPanel;
    Panel16: TPanel;
    Label42: TLabel;
    Label46: TLabel;
    BitBtn9: TBitBtn;
    Edit21: TEdit;
    Panel17: TPanel;
    Label47: TLabel;
    Label48: TLabel;
    Label49: TLabel;
    Edit22: TEdit;
    BitBtn10: TBitBtn;
    Panel18: TPanel;
    Label51: TLabel;
    DBGrid10: TDBGrid;
    BitBtn11: TBitBtn;
    Panel28: TPanel;
    Label41: TLabel;
    Label43: TLabel;
    Label44: TLabel;
    Edit16: TEdit;
    Edit15: TEdit;
    BitBtn8: TBitBtn;
    Label52: TLabel;
    Label73: TLabel;
    Label45: TLabel;
    Panel11: TPanel;
    Label25: TLabel;
    Label30: TLabel;
    edit12: TEdit;
    Edit13: TEdit;
    BitBtn4: TBitBtn;
    DBGrid5: TDBGrid;
    BitBtn5: TBitBtn;
    Panel10: TPanel;
    Label24: TLabel;
    Label27: TLabel;
    Label28: TLabel;
    Label29: TLabel;
    BitBtn7: TBitBtn;
    Label31: TLabel;
    Edit17: TEdit;
    Edit18: TEdit;
    Edit19: TEdit;
    DBGrid4: TDBGrid;
    Edit38: TEdit;
    BitBtn27: TBitBtn;
    TabSheet8: TTabSheet;
    Edit39: TEdit;
    Edit40: TEdit;
    ScrollBox1: TScrollBox;
    ADOConnection1: TADOConnection;
    ADOQuery1: TADOQuery;
    Button2: TButton;
    procedure Edit3KeyPress(Sender: TObject; var Key: Char);
    procedure Edit4KeyPress(Sender: TObject; var Key: Char);
    procedure ComboBox2KeyPress(Sender: TObject; var Key: Char);
    procedure Edit2KeyPress(Sender: TObject; var Key: Char);
    procedure Edit3Exit(Sender: TObject);
    procedure ComboBox1Exit(Sender: TObject);
    procedure ComboBox3Exit(Sender: TObject);
    procedure Edit5KeyPress(Sender: TObject; var Key: Char);
    procedure ComboBox4KeyPress(Sender: TObject; var Key: Char);
    procedure ComboBox5KeyPress(Sender: TObject; var Key: Char);
    procedure ComboBox6KeyPress(Sender: TObject; var Key: Char);
    procedure ComboBox7KeyPress(Sender: TObject; var Key: Char);
    procedure ComboBox8KeyPress(Sender: TObject; var Key: Char);
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
    procedure Edit1KeyPress(Sender: TObject; var Key: Char);
    procedure ComboBox3KeyPress(Sender: TObject; var Key: Char);
    procedure BitBtn2Click(Sender: TObject);
    procedure Edit14Change(Sender: TObject);
    procedure DBGrid6CellClick(Column: TColumn);
    procedure TabSheet6Show(Sender: TObject);
    procedure BitBtn5Click(Sender: TObject);
    procedure BitBtn4Click(Sender: TObject);
    procedure BitBtn6Click(Sender: TObject);
    procedure BitBtn7Click(Sender: TObject);
    procedure BitBtn8Click(Sender: TObject);
    procedure BitBtn9Click(Sender: TObject);
    procedure DBGrid7CellClick(Column: TColumn);
    procedure BitBtn10Click(Sender: TObject);
    procedure BitBtn11Click(Sender: TObject);
    procedure TabSheet3Show(Sender: TObject);
    procedure DBGrid11CellClick(Column: TColumn);
    procedure DBGrid12CellClick(Column: TColumn);
    procedure Edit23Change(Sender: TObject);
    procedure BitBtn12Click(Sender: TObject);
    procedure BitBtn13Click(Sender: TObject);
    procedure BitBtn14Click(Sender: TObject);
    procedure BitBtn15Click(Sender: TObject);
    procedure DBGrid13CellClick(Column: TColumn);
    procedure Button1Click(Sender: TObject);
    procedure BitBtn16Click(Sender: TObject);
    procedure TabSheet2Show(Sender: TObject);
    procedure BitBtn17Click(Sender: TObject);
    procedure BitBtn19Click(Sender: TObject);
    procedure BitBtn20Click(Sender: TObject);
    procedure BitBtn18Click(Sender: TObject);
    procedure BitBtn21Click(Sender: TObject);
    procedure DBGrid22CellClick(Column: TColumn);
    procedure BitBtn22Click(Sender: TObject);
    procedure Edit24KeyPress(Sender: TObject; var Key: Char);
    procedure Edit28KeyPress(Sender: TObject; var Key: Char);
    procedure Edit25KeyPress(Sender: TObject; var Key: Char);
    procedure Edit30KeyPress(Sender: TObject; var Key: Char);
    procedure Edit33KeyPress(Sender: TObject; var Key: Char);
    procedure Edit35KeyPress(Sender: TObject; var Key: Char);
    procedure Edit36KeyPress(Sender: TObject; var Key: Char);
    procedure Edit15KeyPress(Sender: TObject; var Key: Char);
    procedure Edit17KeyPress(Sender: TObject; var Key: Char);
    procedure DBGrid23CellClick(Column: TColumn);
    procedure TabSheet7Show(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure BitBtn23Click(Sender: TObject);
    procedure ComboBox1KeyPress(Sender: TObject; var Key: Char);
    procedure ComboBox1Click(Sender: TObject);
    procedure TabSheet5Show(Sender: TObject);
    procedure Query6AfterPost(DataSet: TDataSet);
    procedure DBGrid4CellClick(Column: TColumn);
    procedure Edit38KeyPress(Sender: TObject; var Key: Char);
    procedure BitBtn24Click(Sender: TObject);
    procedure BitBtn25Click(Sender: TObject);
    procedure BitBtn26Click(Sender: TObject);
    procedure BitBtn27Click(Sender: TObject);
    procedure TabSheet1Show(Sender: TObject);
    procedure Edit39Change(Sender: TObject);
    procedure Edit39KeyPress(Sender: TObject; var Key: Char);
    procedure Edit39DblClick(Sender: TObject);
    procedure Edit40DblClick(Sender: TObject);
    procedure Edit40KeyPress(Sender: TObject; var Key: Char);
    procedure Edit40Change(Sender: TObject);
    procedure Edit40KeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure Edit39KeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure TabSheet1Hide(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  fixfm: Tfixfm;
  a : array of Tcombobox;
  b: array of Tlabel;
  ii:integer;
implementation
{$R *.DFM}
uses mylib,unit4,qryfm;
//打开adoquery通用过程—OPEN方法
procedure OpenADOquery(adoqry:Tadoquery;sqltxt:string);
begin
ADOQry.Close;
ADOQry.SQL.Clear;
ADOQry.SQL.Add(sqltxt);
ADOQry.open;
end;
//执行adoquery通用过程—EXEC方法
procedure EXECADOquery(adoqry:Tadoquery;sqltxt:string);
begin
ADOQry.Close;
ADOQry.SQL.Clear;
ADOQry.SQL.Add(sqltxt);
ADOQry.ExecSQL;
end;


//editchange事件
procedure EditC(ed:Tedit;adoqry:Tadoquery;fm:Tform;sqltxt:string);
var edname:string;
begin
//下面这行可控制退格至没有字符时是否显示所有记录
//当记录较多时最好加上此行
//if length(ed.Text)=0 then exit;
adoqry.Close;
adoqry.sql.Clear;
adoqry.SQL.Add(sqltxt);
adoqry.open;
if adoqry.RecordCount =0 then exit;
fm.Show;
edname:=ed.Name;
if edName ='Edit39' then fm.Tag:=1;
if edName ='Edit40' then fm.Tag:=2;
ed.SetFocus;
end;
//
procedure SaveDataSet(DataSet: TDataSet; FileName: String);
var
  sFormat: String;
  aData: array of String;
  aFmtWidth: array of Integer;
  i: Integer;
  sl: TStringList;
  sToAdd: String;

  procedure PrepareTitle(var s: String; const l: Integer; DisplayName: String; bLeftAlign: Boolean = True);
  const
    sAlignment: array[Boolean] of String = ('-', '');
  var
    sf: String;
  begin
    sf := '%' + sAlignment[bLeftAlign] + IntToStr(l) + 's ';
    s := s + Format(sf, [DisplayName]);
  end;

  procedure PrepareFormatStr(const l: Integer; FieldName: String);
  begin
    SetLength(aFmtWidth, Length(aFmtWidth) + 1);
    aFmtWidth[High(aFmtWidth)] := l;
    SetLength(aData, Length(aData) + 1);
    aData[High(aData)] := FieldName;
  end;

  function PrepareData(afs: array of Integer; a: array of String): String;
  var
    j: Integer;
  begin
    Result := EmptyStr;
    with DataSet do
      for j := Low(a) to High(a) do
        PrepareTitle(Result, afs[j], FieldByName(a[j]).AsString, FieldByName(a[j]).Alignment = taLeftJustify);
  end;

begin
  sFormat := EmptyStr;
  sl := TStringList.Create;
  Screen.Cursor := crSQLWait;
  try
    with DataSet.Fields do begin
      for i := 0 to Count - 1 do begin
        PrepareTitle(sFormat, Fields[i].DisplayWidth, Fields[i].DisplayName, Fields[i].Alignment = taLeftJustify);
      end;
      sl.Add(sFormat);
      sl.Add(' ');
      sFormat := '';
      for i := 0 to Count - 1 do begin
        PrepareFormatStr(Fields[i].DisplayWidth,  Fields[i].FieldName)
      end
    end;
    with DataSet do begin
      First;
      while not Eof do begin
        sToAdd := '';
        sToAdd := PrepareData(aFmtWidth, aData);
        sl.Add(sToAdd);
        Next;
      end;
    end;
    sl.SaveToFile(FileName);
  finally
    sl.Free;
    Screen.Cursor := crDefault;
  end
end;



procedure Tfixfm.Edit3KeyPress(Sender: TObject; var Key: Char);
begin
if key=#13 then
 begin
 edit4.setfocus;
 edit4.text:=getpy1(edit3.text);
 end;
end;

procedure Tfixfm.Edit4KeyPress(Sender: TObject; var Key: Char);
begin
if key=#13 then
  begin
    combobox2.setfocus;
    combobox2.DroppedDown:=true;
  end;
end;

procedure Tfixfm.ComboBox2KeyPress(Sender: TObject; var Key: Char);
begin
if key=#13 then
 begin
 combobox3.setfocus;
 combobox3.DroppedDown:=true;
 end;

end;

procedure Tfixfm.Edit2KeyPress(Sender: TObject; var Key: Char);
begin
if not (key in ['0'..'9',#8,#13]) then key:=#0 ;
if key=#13 then edit3.setfocus;
end;

procedure Tfixfm.Edit3Exit(Sender: TObject);
begin
 edit4.setfocus;
 edit4.text:=getpy1(edit3.text);
end;

procedure Tfixfm.ComboBox1Exit(Sender: TObject);
begin
with dm.table1 do
 begin
    if (combobox1.Text<>'') and (findkey([combobox1.Text])) then
    begin
        edit1.text:=FieldValues['bmbh'];
        exit;
    end;
    if (combobox1.Text<>'') and (not findkey([combobox1.Text])) then
    begin
    MessageDlg('没有此单位名称！', mtWarning, [mbOk], 0);
    exit;
    end;
  end;
end;

procedure Tfixfm.ComboBox3Exit(Sender: TObject);
begin
with dm.table2 do
 begin
    if (combobox3.Text<>'') and (findkey([combobox3.Text])) then
    begin
        edit5.text:=FieldValues['gzbh'];
//        combobox4.setfocus;
//        combobox4.DroppedDown:=true;
        exit;
    end;
    if (combobox3.Text<>'') and (not findkey([combobox3.Text])) then
    begin
    MessageDlg('没有工种！', mtWarning, [mbOk], 0);
    exit;
    end;
  end;
end;

procedure Tfixfm.Edit5KeyPress(Sender: TObject; var Key: Char);
begin
if key=#13 then
 begin
 combobox4.setfocus;
 combobox4.DroppedDown:=true;
 end;

end;

procedure Tfixfm.ComboBox4KeyPress(Sender: TObject; var Key: Char);
begin
if key=#13 then
 begin
 combobox5.setfocus;
 combobox5.DroppedDown:=true;
 end;

end;

procedure Tfixfm.ComboBox5KeyPress(Sender: TObject; var Key: Char);
begin
if key=#13 then
 begin
 combobox6.setfocus;
 combobox6.DroppedDown:=true;
 end;

end;

procedure Tfixfm.ComboBox6KeyPress(Sender: TObject; var Key: Char);