unitdetail.pas

一个不错的系统

unit UnitDetail;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ExtCtrls, StdCtrls, DBCtrls, Grids, DBGrids, Mask, ADODB,
  ToolWin, ComCtrls, ImgList, DB, Buttons, Math, QRCtrls, QuickRpt;

type
  TfrmDetail = class(TForm)
    ScrollBox1: TScrollBox;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label20: TLabel;
    Label10: TLabel;
    Label9: TLabel;
    Label18: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    Label14: TLabel;
    Label15: TLabel;
    DBEdit2: TDBEdit;
    DBComboBox1: TDBComboBox;
    DBEdit3: TDBEdit;
    DBComboBox4: TDBComboBox;
    DBEdit5: TDBEdit;
    DBEdit6: TDBEdit;
    DBComboBox2: TDBComboBox;
    DBComboBox3: TDBComboBox;
    DBComboBox5: TDBComboBox;
    DBEdit10: TDBEdit;
    DBEdit11: TDBEdit;
    DBEdit13: TDBEdit;
    DBMemo1: TDBMemo;
    DBEdit14: TDBEdit;
    Label1: TLabel;
    Label22: TLabel;
    Label24: TLabel;
    Label25: TLabel;
    Label26: TLabel;
    Label28: TLabel;
    Label29: TLabel;
    Label31: TLabel;
    Label32: TLabel;
    DBEdit17: TDBEdit;
    DBComboBox6: TDBComboBox;
    DBEdit18: TDBEdit;
    Label33: TLabel;
    DBNavigator1: TDBNavigator;
    ToolBar1: TToolBar;
    DBEdit1: TDBEdit;
    ToolButton3: TToolButton;
    Label13: TLabel;
    DBComboBox8: TDBComboBox;
    Label17: TLabel;
    Label19: TLabel;
    Label21: TLabel;
    Label23: TLabel;
    Label34: TLabel;
    Label35: TLabel;
    DBComboBox9: TDBComboBox;
    DBComboBox10: TDBComboBox;
    DBEdit20: TDBEdit;
    DBEdit21: TDBEdit;
    DBComboBox7: TDBComboBox;
    Label16: TLabel;
    DBEdit22: TDBEdit;
    DBComboBox11: TDBComboBox;
    DBComboBox12: TDBComboBox;
    Label50: TLabel;
    Edit2: TEdit;
    SpeedButton1: TSpeedButton;
    Label54: TLabel;
    Label38: TLabel;
    DBComboBox13: TDBComboBox;
    DBComboBox16: TDBComboBox;
    DBComboBox17: TDBComboBox;
    Label39: TLabel;
    DBEdit4: TDBEdit;
    DBEdit7: TDBEdit;
    DBComboBox18: TDBComboBox;
    DBEdit8: TDBEdit;
    DBComboBox19: TDBComboBox;
    DBEdit9: TDBEdit;
    DBEdit12: TDBEdit;
    DBComboBox20: TDBComboBox;
    DBEdit15: TDBEdit;
    DBEdit16: TDBEdit;
    DBComboBox21: TDBComboBox;
    DBEdit19: TDBEdit;
    DBEdit23: TDBEdit;
    DBComboBox22: TDBComboBox;
    DBEdit24: TDBEdit;
    Label27: TLabel;
    Panel1: TPanel;
    Panel2: TPanel;
    Panel3: TPanel;
    Label30: TLabel;
    Label36: TLabel;
    Label37: TLabel;
    Label40: TLabel;
    Label41: TLabel;
    Label42: TLabel;
    Label43: TLabel;
    Label44: TLabel;
    DBEdit25: TDBEdit;
    DBEdit26: TDBEdit;
    DBComboBox23: TDBComboBox;
    DBComboBox24: TDBComboBox;
    DBEdit27: TDBEdit;
    DBComboBox25: TDBComboBox;
    DBComboBox26: TDBComboBox;
    DBComboBox27: TDBComboBox;
    Label45: TLabel;
    DBComboBox28: TDBComboBox;
    ToolButton1: TToolButton;
    SpeedButton2: TSpeedButton;
    QuickRep1: TQuickRep;
    DetailBand1: TQRBand;
    QRShape97: TQRShape;
    QRShape2: TQRShape;
    QRLabel1: TQRLabel;
    QRDBText1: TQRDBText;
    QRLabel2: TQRLabel;
    QRLabel3: TQRLabel;
    QRLabel4: TQRLabel;
    QRLabel5: TQRLabel;
    QRLabel6: TQRLabel;
    QRLabel7: TQRLabel;
    QRLabel8: TQRLabel;
    QRLabel10: TQRLabel;
    QRLabel11: TQRLabel;
    QRDBText2: TQRDBText;
    QRDBText3: TQRDBText;
    QRDBText5: TQRDBText;
    QRDBText6: TQRDBText;
    QRLabel13: TQRLabel;
    QRLabel14: TQRLabel;
    QRLabel15: TQRLabel;
    QRLabel16: TQRLabel;
    QRLabel17: TQRLabel;
    QRLabel18: TQRLabel;
    QRDBText7: TQRDBText;
    QRDBText8: TQRDBText;
    QRDBText9: TQRDBText;
    QRDBText10: TQRDBText;
    QRLabel19: TQRLabel;
    QRLabel20: TQRLabel;
    QRLabel21: TQRLabel;
    QRDBText12: TQRDBText;
    QRLabel22: TQRLabel;
    QRLabel23: TQRLabel;
    QRLabel24: TQRLabel;
    QRLabel25: TQRLabel;
    QRLabel26: TQRLabel;
    QRLabel27: TQRLabel;
    QRLabel28: TQRLabel;
    QRLabel29: TQRLabel;
    QRLabel30: TQRLabel;
    QRLabel31: TQRLabel;
    QRLabel33: TQRLabel;
    QRLabel34: TQRLabel;
    QRLabel35: TQRLabel;
    QRLabel36: TQRLabel;
    QRLabel37: TQRLabel;
    QRLabel38: TQRLabel;
    QRLabel39: TQRLabel;
    QRLabel40: TQRLabel;
    QRLabel41: TQRLabel;
    QRLabel42: TQRLabel;
    QRLabel43: TQRLabel;
    QRLabel44: TQRLabel;
    QRLabel45: TQRLabel;
    QRLabel46: TQRLabel;
    QRDBText17: TQRDBText;
    QRDBText18: TQRDBText;
    QRDBText19: TQRDBText;
    QRDBText20: TQRDBText;
    QRDBText21: TQRDBText;
    QRDBText22: TQRDBText;
    QRDBText23: TQRDBText;
    QRDBText24: TQRDBText;
    QRDBText25: TQRDBText;
    QRDBText26: TQRDBText;
    QRDBText27: TQRDBText;
    QRDBText28: TQRDBText;
    QRDBText29: TQRDBText;
    QRDBText30: TQRDBText;
    QRDBText31: TQRDBText;
    QRDBText32: TQRDBText;
    QRDBText33: TQRDBText;
    QRDBText34: TQRDBText;
    QRDBText35: TQRDBText;
    QRDBText36: TQRDBText;
    QRDBText37: TQRDBText;
    QRLabel49: TQRLabel;
    QRLabel65: TQRLabel;
    QRLabel67: TQRLabel;
    QRLabel50: TQRLabel;
    QRLabel51: TQRLabel;
    QRLabel12: TQRLabel;
    QRDBText4: TQRDBText;
    QRDBText11: TQRDBText;
    QRDBText38: TQRDBText;
    QRDBText39: TQRDBText;
    QRDBText40: TQRDBText;
    QRDBText41: TQRDBText;
    QRDBText42: TQRDBText;
    QRDBText43: TQRDBText;
    QRDBText44: TQRDBText;
    QRDBText45: TQRDBText;
    QRDBText46: TQRDBText;
    QRDBText47: TQRDBText;
    QRDBText48: TQRDBText;
    QRDBText49: TQRDBText;
    QRDBText50: TQRDBText;
    QRDBText51: TQRDBText;
    QRDBText52: TQRDBText;
    QRDBText53: TQRDBText;
    QRDBText54: TQRDBText;
    QRLabel32: TQRLabel;
    QRDBText55: TQRDBText;
    QRLabel47: TQRLabel;
    QRLabel48: TQRLabel;
    QRDBRichText1: TQRDBRichText;
    QRLabel9: TQRLabel;
    QRLabel52: TQRLabel;
    QRDBText16: TQRDBText;
    QRLabel53: TQRLabel;
    QRLabel54: TQRLabel;
    QRExpr1: TQRExpr;
    QRDBText13: TQRDBText;
    QRDBText14: TQRDBText;
    QRDBText15: TQRDBText;
    QRShape1: TQRShape;
    QRShape3: TQRShape;
    QRShape4: TQRShape;
    QRShape5: TQRShape;
    QRShape6: TQRShape;
    QRShape7: TQRShape;
    QRShape8: TQRShape;
    QRShape9: TQRShape;
    QRShape10: TQRShape;
    QRShape11: TQRShape;
    QRShape12: TQRShape;
    QRShape13: TQRShape;
    QRShape14: TQRShape;
    QRShape15: TQRShape;
    QRShape16: TQRShape;
    QRShape17: TQRShape;
    QRShape18: TQRShape;
    QRShape19: TQRShape;
    QRShape20: TQRShape;
    QRShape21: TQRShape;
    QRShape22: TQRShape;
    QRShape23: TQRShape;
    QRShape24: TQRShape;
    QRShape25: TQRShape;
    QRShape26: TQRShape;
    QRShape27: TQRShape;
    QRShape28: TQRShape;
    QRShape29: TQRShape;
    QRShape30: TQRShape;
    QRShape31: TQRShape;
    QRShape32: TQRShape;
    QRShape33: TQRShape;
    QRShape34: TQRShape;
    QRShape35: TQRShape;
    QRShape36: TQRShape;
    QRShape37: TQRShape;
    QRShape38: TQRShape;
    QRShape39: TQRShape;
    QRShape40: TQRShape;
    QRShape41: TQRShape;
    QRShape42: TQRShape;
    QRShape43: TQRShape;
    QRShape44: TQRShape;
    PageHeaderBand1: TQRBand;
    DBEdit28: TDBEdit;
    DBEdit29: TDBEdit;
    procedure FormKeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure FormCreate(Sender: TObject);
    procedure DBComboBox3Enter(Sender: TObject);
    procedure DBComboBox4Enter(Sender: TObject);
    procedure DBComboBox5Enter(Sender: TObject);
    procedure DBComboBox6Enter(Sender: TObject);
    procedure DBEdit6Exit(Sender: TObject);
    procedure DBComboBox9Enter(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure DBEdit18Exit(Sender: TObject);
    procedure DBEdit17Exit(Sender: TObject);
    procedure DBComboBox2Change(Sender: TObject);
    procedure DBEdit16Exit(Sender: TObject);
    procedure DBComboBox14Enter(Sender: TObject);
    procedure DBComboBox15Enter(Sender: TObject);
    procedure DBComboBox16Enter(Sender: TObject);
    procedure DBComboBox18Enter(Sender: TObject);
    procedure DBEdit21Exit(Sender: TObject);
    procedure DBEdit20Exit(Sender: TObject);
    procedure DBEdit6KeyPress(Sender: TObject; var Key: Char);
    procedure DBComboBox10Change(Sender: TObject);
    procedure DBNavigator1Click(Sender: TObject; Button: TNavigateBtn);
    procedure DBComboBox1Change(Sender: TObject);
    procedure DBNavigator2Click(Sender: TObject; Button: TNavigateBtn);
    procedure DBNavigator1BeforeAction(Sender: TObject;
      Button: TNavigateBtn);
    procedure DBMemo1Enter(Sender: TObject);
    procedure DBMemo1Exit(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure DetailBand1BeforePrint(Sender: TQRCustomBand;
      var PrintBand: Boolean);
    procedure DBEdit2Enter(Sender: TObject);
    procedure DBComboBox1Enter(Sender: TObject);
    procedure DBEdit14Exit(Sender: TObject);
  private
    { Private declarations }
    procedure GetItemList(Sender: TObject;FieldName:String);
    function CheckIDCard(IDCard:String):Boolean;
    procedure RaiseError;
    function UpdateIDCard(OldIDCard:String):String;
  public
    { Public declarations }
  end;

var
  frmDetail: TfrmDetail;

implementation

uses UnitDialog, UnitSearch, UnitDatabase, UnitCommon;

{$R *.dfm}

procedure TfrmDetail.FormKeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  if Key=13 then Perform(WM_NEXTDLGCTL,0,0);
end;

procedure TfrmDetail.FormCreate(Sender: TObject);
begin
  DBEdit28.Field.EditMask:='999999;1; ';
  DBEdit29.Field.EditMask:='999999;1; ';
  DBEdit17.Field.EditMask:='9999-99-99;1; ';
  DBEdit18.Field.EditMask:='9999-99-99;1; ';
  DBEdit6.Field.EditMask:='99999999999999999a;1; ';
end;

procedure TfrmDetail.DBComboBox3Enter(Sender: TObject);
begin
  GetItemList(Sender,'MFolk');
end;

procedure TfrmDetail.DBComboBox4Enter(Sender: TObject);
begin
  GetItemList(Sender,'MProvince');
end;

procedure TfrmDetail.DBComboBox5Enter(Sender: TObject);
begin
  GetItemList(Sender,'MCity');
end;

procedure TfrmDetail.DBComboBox6Enter(Sender: TObject);