xyda_u.pas

比较完整的系统 比较完整的系统

unit xyda_u;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Buttons, ExtCtrls, DBCtrls, Mask, DB, DBTables,
  ComCtrls, sCustomComboEdit, sTooledit, ExtDlgs,jpeg,
  ADODB;

type
  Txyda = class(TForm)
    DataSource1: TDataSource;
    Table1: TTable;
    Label1: TLabel;
    DBEdit1: TDBEdit;
    Label2: TLabel;
    DBEdit2: TDBEdit;
    Label4: TLabel;
    Label5: TLabel;
    DBEdit5: TDBEdit;
    Label6: TLabel;
    DBEdit6: TDBEdit;
    Label7: TLabel;
    DBEdit7: TDBEdit;
    Label8: TLabel;
    DBEdit8: TDBEdit;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    DBEdit11: TDBEdit;
    Label12: TLabel;
    Label13: TLabel;
    DBEdit13: TDBEdit;
    Label14: TLabel;
    Label15: TLabel;
    DBEdit15: TDBEdit;
    Label16: TLabel;
    DBEdit16: TDBEdit;
    Label17: TLabel;
    Label18: TLabel;
    Label19: TLabel;
    DBCheckBox1: TDBCheckBox;
    Label20: TLabel;
    DBCheckBox4: TDBCheckBox;
    Label21: TLabel;
    Label22: TLabel;
    DBEdit22: TDBEdit;
    Label23: TLabel;
    DBEdit23: TDBEdit;
    Label30: TLabel;
    Label31: TLabel;
    Label32: TLabel;
    DBEdit32: TDBEdit;
    Label33: TLabel;
    DBEdit33: TDBEdit;
    Label34: TLabel;
    DBEdit34: TDBEdit;
    Label35: TLabel;
    Label36: TLabel;
    Label37: TLabel;
    DBEdit37: TDBEdit;
    Label38: TLabel;
    DBEdit38: TDBEdit;
    Label39: TLabel;
    Label40: TLabel;
    DBEdit40: TDBEdit;
    Label41: TLabel;
    DBEdit41: TDBEdit;
    Label42: TLabel;
    DBEdit42: TDBEdit;
    Label43: TLabel;
    Label44: TLabel;
    DBEdit44: TDBEdit;
    Label45: TLabel;
    DBEdit45: TDBEdit;
    Label46: TLabel;
    DBEdit46: TDBEdit;
    Label47: TLabel;
    Label48: TLabel;
    DBEdit48: TDBEdit;
    Label49: TLabel;
    DBEdit49: TDBEdit;
    Label52: TLabel;
    Label3: TLabel;
    GroupBox1: TGroupBox;
    Label24: TLabel;
    DBEdit24: TDBEdit;
    Label25: TLabel;
    DBEdit25: TDBEdit;
    Label26: TLabel;
    DBEdit26: TDBEdit;
    Label27: TLabel;
    DBEdit27: TDBEdit;
    Label28: TLabel;
    DBEdit28: TDBEdit;
    Label29: TLabel;
    DBEdit29: TDBEdit;
    GroupBox2: TGroupBox;
    DBCheckBox2: TDBCheckBox;
    DBCheckBox3: TDBCheckBox;
    DBCheckBox5: TDBCheckBox;
    DBCheckBox6: TDBCheckBox;
    DBCheckBox7: TDBCheckBox;
    DBCheckBox8: TDBCheckBox;
    GroupBox3: TGroupBox;
    DBCheckBox9: TDBCheckBox;
    DBCheckBox10: TDBCheckBox;
    DBCheckBox11: TDBCheckBox;
    DBCheckBox12: TDBCheckBox;
    DBCheckBox13: TDBCheckBox;
    DBCheckBox14: TDBCheckBox;
    DBCheckBox15: TDBCheckBox;
    Label51: TLabel;
    DBEdit50: TDBEdit;
    Label50: TLabel;
    Label53: TLabel;
    DBEdit51: TDBEdit;
    Label54: TLabel;
    Label55: TLabel;
    DBEdit53: TDBEdit;
    Label56: TLabel;
    Label57: TLabel;
    DBNavigator1: TDBNavigator;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    sDateEdit1: TsDateEdit;
    Database1: TDatabase;
    DBComboBox1: TDBComboBox;
    Table1BDEDesigner: TStringField;
    Table1BDEDesigner2: TStringField;
    Table1BDEDesigner3: TStringField;
    Table1BDEDesigner4: TDateTimeField;
    Table1BDEDesigner5: TStringField;
    Table1BDEDesigner6: TStringField;
    Table1BDEDesigner7: TStringField;
    Table1BDEDesigner8: TStringField;
    Table1BDEDesigner9: TStringField;
    Table1BDEDesigner10: TStringField;
    Table1BDEDesigner11: TStringField;
    Table1BDEDesigner12: TStringField;
    Table1BDEDesigner13: TStringField;
    Table1BDEDesigner14: TDateTimeField;
    Table1BDEDesigner15: TStringField;
    Table1BDEDesigner16: TStringField;
    Table1BDEDesigner17: TDateTimeField;
    Table1BDEDesigner18: TDateTimeField;
    Table1BDEDesigner19: TStringField;
    Table1BDEDesigner20: TBooleanField;
    Table1IC: TBooleanField;
    Table1BDEDesigner21: TBooleanField;
    Table1BDEDesigner22: TIntegerField;
    Table1BDEDesigner23: TBooleanField;
    Table1BDEDesigner24: TIntegerField;
    Table1BDEDesigner25: TFloatField;
    Table1BDEDesigner26: TFloatField;
    Table1BDEDesigner27: TIntegerField;
    Table1BDEDesigner28: TIntegerField;
    Table1BDEDesigner29: TIntegerField;
    Table1BDEDesigner30: TIntegerField;
    Table1BDEDesigner31: TIntegerField;
    Table1BDEDesigner32: TIntegerField;
    Table1BDEDesigner33: TDateTimeField;
    Table1BDEDesigner34: TDateTimeField;
    Table1BDEDesigner35: TBooleanField;
    Table1BDEDesigner36: TBooleanField;
    Table1BDEDesigner37: TBooleanField;
    Table1BDEDesigner38: TBooleanField;
    Table1BDEDesigner39: TFloatField;
    Table1BDEDesigner40: TFloatField;
    Table1BDEDesigner41: TFloatField;
    Table1BDEDesigner42: TDateTimeField;
    Table1BDEDesigner43: TStringField;
    Table1BDEDesigner44: TBooleanField;
    Table1BDEDesigner45: TBooleanField;
    Table1BDEDesigner46: TBooleanField;
    Table1BDEDesigner47: TBooleanField;
    Table1BDEDesigner48: TBooleanField;
    Table1BDEDesigner49: TBooleanField;
    Table1BDEDesigner50: TBooleanField;
    Table1BDEDesigner51: TIntegerField;
    Table1BDEDesigner52: TIntegerField;
    Table1BDEDesigner53: TDateTimeField;
    Table1BDEDesigner54: TIntegerField;
    Table1BDEDesigner55: TIntegerField;
    Table1BDEDesigner56: TIntegerField;
    Table1BDEDesigner57: TDateTimeField;
    Table1BDEDesigner58: TIntegerField;
    Table1BDEDesigner59: TIntegerField;
    Table1BDEDesigner60: TIntegerField;
    Table1BDEDesigner61: TDateTimeField;
    Table1BDEDesigner62: TIntegerField;
    Table1BDEDesigner63: TIntegerField;
    Table1BDEDesigner64: TIntegerField;
    Table1BDEDesigner66: TDateTimeField;
    Label58: TLabel;
    DBEdit3: TDBEdit;
    DBComboBox3: TDBComboBox;
    DBComboBox4: TDBComboBox;
    DBComboBox5: TDBComboBox;
    sDateEdit2: TsDateEdit;
    sDateEdit3: TsDateEdit;
    sDateEdit4: TsDateEdit;
    sDateEdit5: TsDateEdit;
    sDateEdit6: TsDateEdit;
    sDateEdit7: TsDateEdit;
    sDateEdit8: TsDateEdit;
    sDateEdit9: TsDateEdit;
    sDateEdit10: TsDateEdit;
    DBEdit52: TDBEdit;
    Table1BDEDesigner65: TBlobField;
    Table1BDEDesigner67: TStringField;
    Table2: TTable;
    DBComboBox2: TDBComboBox;
    DBComboBox6: TDBComboBox;
    DBComboBox7: TDBComboBox;
    DBComboBox8: TDBComboBox;
    Table1isbmp: TSmallintField;
    savetofile: TBitBtn;
    OpenPictureDialog1: TOpenPictureDialog;
    Image1: TImage;
    savetodb: TBitBtn;
    ADOConnection1: TADOConnection;
    ADOTable1: TADOTable;
    Image2: TImage;
    clear_btn: TBitBtn;
    procedure Table1AfterScroll(DataSet: TDataSet);
    procedure Table1BeforePost(DataSet: TDataSet);
    procedure Table1AfterInsert(DataSet: TDataSet);
    procedure FormCreate(Sender: TObject);
    procedure DBComboBox1DropDown(Sender: TObject);
    procedure sDateEdit1AcceptDate(Sender: TObject; var aDate: TDateTime;
      var CanAccept: Boolean);
    procedure DBComboBox2DropDown(Sender: TObject);
    procedure DBComboBox3DropDown(Sender: TObject);
    procedure DBComboBox4DropDown(Sender: TObject);
    procedure DBComboBox5DropDown(Sender: TObject);
    procedure sDateEdit2AcceptDate(Sender: TObject; var aDate: TDateTime;
      var CanAccept: Boolean);
    procedure DBComboBox6DropDown(Sender: TObject);
    procedure DBComboBox7DropDown(Sender: TObject);
    procedure DBComboBox8DropDown(Sender: TObject);
    procedure savetofileClick(Sender: TObject);
    procedure Image1DblClick(Sender: TObject);
    procedure savetodbClick(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure clear_btnClick(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure BitBtn2Click(Sender: TObject);
    procedure Table1BeforeInsert(DataSet: TDataSet);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  xyda: Txyda;
  xybh:integer;

implementation

uses jlyda_u;

{$R *.dfm}

procedure Txyda.Table1AfterScroll(DataSet: TDataSet);
var
i:string;
//locatesuccess:string;
strm:tadoblobstream;
jpegimage:tjpegimage;
bitmap:tbitmap;
begin
    if table1.FieldValues['出生日期']<>null then
       sdateedit1.text:=datetostr(table1.FieldValues['出生日期'])
    else
       sdateedit1.text:='    -  -  ';
    if table1.FieldValues['准考证日期']<>null then
       sdateedit2.text:=datetostr(table1.FieldValues['准考证日期'])
    else
       sdateedit2.text:='    -  -  ';
    if table1.FieldValues['报名时间']<>null then
       sdateedit3.text:=datetostr(table1.FieldValues['报名时间'])
    else
       sdateedit3.text:='    -  -  ';
    if table1.FieldValues['进班时间']<>null then
       sdateedit4.text:=datetostr(table1.FieldValues['进班时间'])
    else
       sdateedit4.text:='    -  -  ';
    if table1.FieldValues['预约考桩时间']<>null then
       sdateedit5.text:=datetostr(table1.FieldValues['预约考桩时间'])
    else
       sdateedit5.text:='    -  -  ';
    if table1.FieldValues['预约考路时间']<>null then
       sdateedit6.text:=datetostr(table1.FieldValues['预约考路时间'])
    else
       sdateedit6.text:='    -  -  ';
    if table1.FieldValues['第二次付费日期']<>null then
       sdateedit7.text:=datetostr(table1.FieldValues['第二次付费日期'])
    else
       sdateedit7.text:='    -  -  ';
    if table1.FieldValues['科目一时间']<>null then
       sdateedit8.text:=datetostr(table1.FieldValues['科目一时间'])
    else
       sdateedit8.text:='    -  -  ';
    if table1.FieldValues['科目二时间']<>null then
       sdateedit9.text:=datetostr(table1.FieldValues['科目二时间'])
    else
       sdateedit9.text:='    -  -  ';
    if table1.FieldValues['科目三时间']<>null then
       sdateedit10.text:=datetostr(table1.FieldValues['科目三时间'])
    else
       sdateedit10.text:='    -  -  ';
  i:= table1.Fieldbyname('学号').AsString;
  adotable1.Open;
  adotable1.Locate('学号',i,[loCaseInsensitive]);
///如下显示方法不适用于paradox中的graphic字段的显示。
  strm:= tadoblobstream.Create(tblobfield(adotable1.fieldbyname('照片')),bmread);
  try    //try1
  strm.position :=0;
  image1.Picture.Graphic:= nil;
  //DBIMAGE1.DataField := '';
  //显示时，BMP、JPEG两种图像数据必需分别处理
  if adotable1.fieldbyname('isbmp').asstring ='1' then
    begin    //begin11
    bitmap := tbitmap.Create ;
    try     //try11
    bitmap.LoadFromStream(strm);
    image1.Picture.Graphic := bitmap;
    //DBIMAGE1.DataField := '照片';
    finally
    bitmap.Free;
    end;    //end try11
    end     //end begin11
    else if adotable1.fieldbyname('isbmp').asstring ='0' then
    begin   //begin12
    jpegimage := tjpegimage.Create ;
    try     //try12
    jpegimage.LoadFromStream(strm);