unit3.pas

劳保管理 ACCESS数据库 作为设计的一个参考

unit Unit3;

interface

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

type
  TForm3 = 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;
    Table1: TTable;
    Table2: TTable;
    Table3: TTable;
    Table4: TTable;
    Query1: TQuery;
    DataSource1: TDataSource;
    Query2: TQuery;
    DataSource2: TDataSource;
    Query2lbmc: TStringField;
    Query2ffrq: TDateTimeField;
    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;
    DataSource3: TDataSource;
    DataSource4: TDataSource;
    DataSource5: TDataSource;
    DataSource6: TDataSource;
    DataSource7: TDataSource;
    Query3: TQuery;
    Query4: TQuery;
    Query5: TQuery;
    Query6: TQuery;
    Query7: TQuery;
    Query3xm: TStringField;
    Query3ygbh: TStringField;
    Query4bmbh: TStringField;
    Query4bmmc: TStringField;
    Query5bmbh: TStringField;
    Query5bmmc: TStringField;
    Query6xm: TStringField;
    Query6xmdm: TStringField;
    Query6xb: TStringField;
    Query6gzfgg: TStringField;
    Query6mygg: TStringField;
    Query6cygg: TStringField;
    Query6bwx: TStringField;
    Query6bjx: TStringField;
    Query6jx: TStringField;
    Query6jyx: TStringField;
    Query6xz: TStringField;
    Query7bmbh: TStringField;
    Query7xm: TStringField;
    Query7xmdm: TStringField;
    Query7ygbh: TStringField;
    Query7xb: TStringField;
    Query7gzbh: TStringField;
    Query7gzfgg: TStringField;
    Query7mygg: TStringField;
    Query7cygg: TStringField;
    Query7bwx: TStringField;
    Query7bjx: TStringField;
    Query7jx: TStringField;
    Query7jyx: TStringField;
    Query7xz: TStringField;
    Query8: TQuery;
    Query9: TQuery;
    Panel14: TPanel;
    Label40: TLabel;
    DBGrid7: TDBGrid;
    DataSource8: TDataSource;
    Query10: TQuery;
    Table5: TTable;
    Query11: TQuery;
    DataSource9: TDataSource;
    Query12: TQuery;
    DataSource10: TDataSource;
    Panel19: TPanel;
    Panel20: TPanel;
    Panel21: TPanel;
    Panel22: TPanel;
    DBGrid11: TDBGrid;
    DBGrid12: TDBGrid;
    DBGrid15: TDBGrid;
    Label50: TLabel;
    Label53: TLabel;
    Label55: TLabel;
    Edit23: TEdit;
    DataSource11: TDataSource;
    Query13: TQuery;
    Query14: TQuery;
    Query15: TQuery;
    DataSource12: TDataSource;
    DataSource13: TDataSource;
    Query13bmbh: TStringField;
    Query13bmmc: TStringField;
    Query14xm: TStringField;
    Query14ygbh: TStringField;
    Query14xb: TStringField;
    Query15lbmc: TStringField;
    Query15ffrq: TDateTimeField;
    Query12bmbh: TStringField;
    Query12bmmc: TStringField;
    DBGrid14: TDBGrid;
    Label54: TLabel;
    DataSource14: TDataSource;
    Query16: TQuery;
    StringField1: TStringField;
    StringField3: TStringField;
    StringField4: TStringField;
    StringField5: TStringField;
    StringField6: TStringField;
    StringField8: TStringField;
    StringField9: TStringField;
    StringField10: TStringField;
    StringField11: TStringField;
    StringField12: TStringField;
    StringField13: TStringField;
    StringField14: TStringField;
    StringField15: TStringField;
    StringField16: TStringField;
    Query15bmbh: TStringField;
    Query15ygbh: TStringField;
    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;
    Table6: TTable;
    DataSource15: TDataSource;
    Query17: TQuery;
    DataSource16: TDataSource;
    Query18: TQuery;
    Query17gzbh: TStringField;
    Query17gzmc: TStringField;
    Query18gzbh: TStringField;
    Query18lbmc: TStringField;
    DBGrid17: TDBGrid;
    Button1: TButton;
    DataSource17: TDataSource;
    Query19: TQuery;
    Panel25: TPanel;
    Panel26: TPanel;
    Panel27: TPanel;
    DBGrid18: TDBGrid;
    DBGrid19: TDBGrid;
    DBGrid20: TDBGrid;
    DBGrid21: TDBGrid;
    BitBtn17: TBitBtn;
    BitBtn18: TBitBtn;
    Label68: TLabel;
    Edit31: TEdit;
    Label72: TLabel;
    Table7: TTable;
    Table8: TTable;
    Table9: TTable;
    DBGrid22: TDBGrid;
    BitBtn19: TBitBtn;
    DataSource18: TDataSource;
    Query20: TQuery;
    Query20bmmc: TStringField;
    Query21: TQuery;
    Query22: TQuery;
    DataSource19: TDataSource;
    DataSource20: TDataSource;
    DataSource21: TDataSource;
    Query23: TQuery;
    Query20bmbh: TStringField;
    BitBtn21: TBitBtn;
    Query21bmmc: TStringField;
    Query21ygbh: TStringField;
    Query21xm: TStringField;
    Query21lbmc: TStringField;
    Query21gg: TStringField;
    Query21sl: TFloatField;
    Query22lbmc: TStringField;
    Query22gg: TStringField;
    Query22zsl: TFloatField;
    Query23lbmc: TStringField;
    Query23gg: TStringField;
    Query23zsl: TFloatField;
    BitBtn20: TBitBtn;
    Table10: TTable;
    Label74: TLabel;
    Label75: TLabel;
    Label76: TLabel;
    Label77: TLabel;
    Edit35: TEdit;
    Edit36: TEdit;
    Edit37: TEdit;
    BitBtn22: TBitBtn;
    TabSheet10: TTabSheet;
    StatusBar1: TStatusBar;
    DBGrid23: TDBGrid;
    DataSource22: TDataSource;
    Query24: TQuery;
    Query19bmbh: TStringField;
    Query19xm: TStringField;
    Query19xmdm: TStringField;
    Query19ygbh: TStringField;
    Query19xb: TStringField;
    Query19gzbh: TStringField;
    Query19gzfgg: TStringField;
    Query19mygg: TStringField;
    Query19cygg: TStringField;
    Query19bwx: TStringField;
    Query19bjx: TStringField;
    Query19jx: TStringField;
    Query19jyx: TStringField;
    Query19xz: TStringField;
    Query25: TQuery;
    Memo1: TMemo;
    BitBtn23: TBitBtn;
    Label80: TLabel;
    Table11: TTable;
    Label22: TLabel;
    Edit10: TEdit;
    Query18ffzq: TSmallintField;
    Query15ffzq: TSmallintField;
    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;
    Query3bmbh: TStringField;
    BitBtn5: TBitBtn;
    Query24bmbh: TStringField;
    Query24bmmc: TStringField;
    Query2ffzq: TSmallintField;
    Panel10: TPanel;
    Label24: TLabel;
    Label27: TLabel;
    Label28: TLabel;
    Label29: TLabel;
    BitBtn7: TBitBtn;
    Label31: TLabel;
    Edit17: TEdit;
    Edit18: TEdit;
    Edit19: TEdit;
    DBGrid4: TDBGrid;
    Edit38: TEdit;
    DataSource23: TDataSource;
    Query26: TQuery;
    Query27: TQuery;
    PrintAtOnceEx1: TPrintAtOnceEx;
    PrintAtOnceEx2: TPrintAtOnceEx;
    PrintAtOnceEx3: TPrintAtOnceEx;
    BitBtn27: TBitBtn;
    PrintAtOnceEx4: TPrintAtOnceEx;
    TabSheet8: TTabSheet;
    Panel29: TPanel;
    Label32: TLabel;
    Edit39: TEdit;
    Button2: TButton;
    Button3: TButton;
    Database1: TDatabase;
    Table12: TTable;
    Table13: TTable;
    BatchMove1: TBatchMove;
    OpenDialog1: TOpenDialog;
    Query28: TQuery;
    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 Table3PostError(DataSet: TDataSet; E: EDatabaseError;
      var Action: TDataAction);
    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 Button3Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form3: TForm3;
implementation
{$R *.DFM}
uses mylib;
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;