submain.pas

学员管理的软件

unit submain;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ImgList, Menus, ComCtrls, ToolWin, Grids, DBGrids, Excel2000,
  OleServer, ADODB, math,DB,INifiles,registry, StdCtrls, jpeg, ExtCtrls,
  shellapi,printers,mmsystem, XPMenu,StrUtils, ExcelXP;

type
  TForm1 = class(TForm)
    MainMenu1: TMainMenu;
    ImageList1: TImageList;
    N1: TMenuItem;
    C1: TMenuItem;
    Q1: TMenuItem;
    T1: TMenuItem;
    M1: TMenuItem;
    TV1: TTreeView;
    DBGrid1: TDBGrid;
    sb: TStatusBar;
    N2: TMenuItem;
    N3: TMenuItem;
    N4: TMenuItem;
    N5: TMenuItem;
    N6: TMenuItem;
    N10: TMenuItem;
    N11: TMenuItem;
    N14: TMenuItem;
    N15: TMenuItem;
    N17: TMenuItem;
    N21: TMenuItem;
    N22: TMenuItem;
    N25: TMenuItem;
    N27: TMenuItem;
    ADOConnection1: TADOConnection;
    ADOTable1: TADOTable;
    ADOQuery1: TADOQuery;
    ExcelApplication1: TExcelApplication;
    ExcelWorkbook1: TExcelWorkbook;
    ExcelWorksheet1: TExcelWorksheet;
    SaveDialog1: TSaveDialog;
    CoolBar1: TCoolBar;
    Panel1: TPanel;
    Image1: TImage;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    ListBox1: TListBox;
    Label6: TLabel;
    ListView1: TListView;
    dh_image: TImageList;
    ToolBar1: TToolBar;
    ToolButton1: TToolButton;
    ToolButton2: TToolButton;
    ToolButton3: TToolButton;
    ToolButton4: TToolButton;
    ToolButton5: TToolButton;
    ToolButton6: TToolButton;
    ToolButton7: TToolButton;
    ToolButton8: TToolButton;
    ToolButton9: TToolButton;
    ToolButton10: TToolButton;
    ToolButton11: TToolButton;
    ToolButton12: TToolButton;
    ToolButton13: TToolButton;
    ToolButton14: TToolButton;
    ToolButton15: TToolButton;
    ToolButton16: TToolButton;
    ToolButton18: TToolButton;
    ToolButton19: TToolButton;
    ToolButton20: TToolButton;
    ToolButton21: TToolButton;
    ToolButton22: TToolButton;
    N18: TMenuItem;
    N20: TMenuItem;
    N29: TMenuItem;
    WORD1: TMenuItem;
    N7: TMenuItem;
    N8: TMenuItem;
    P1: TMenuItem;
    H1: TMenuItem;
    pm_query: TPopupMenu;
    N9: TMenuItem;
    N12: TMenuItem;
    N13: TMenuItem;
    ToolButton23: TToolButton;
    ToolButton24: TToolButton;
    ToolButton25: TToolButton;
    pm_toexcel: TPopupMenu;
    N23: TMenuItem;
    N24: TMenuItem;
    N26: TMenuItem;
    ToolButton26: TToolButton;
    N31: TMenuItem;
    N32: TMenuItem;
    N33: TMenuItem;
    N34: TMenuItem;
    N35: TMenuItem;
    N36: TMenuItem;
    N37: TMenuItem;
    N40: TMenuItem;
    N41: TMenuItem;
    N42: TMenuItem;
    N43: TMenuItem;
    N44: TMenuItem;
    N45: TMenuItem;
    pm_tree_set: TPopupMenu;
    s1: TMenuItem;
    N46: TMenuItem;
    N47: TMenuItem;
    N48: TMenuItem;
    N49: TMenuItem;
    N50: TMenuItem;
    N51: TMenuItem;
    N52: TMenuItem;
    N53: TMenuItem;
    N54: TMenuItem;
    N55: TMenuItem;
    N56: TMenuItem;
    N57: TMenuItem;
    N58: TMenuItem;
    N59: TMenuItem;
    N60: TMenuItem;
    N61: TMenuItem;
    N62: TMenuItem;
    N63: TMenuItem;
    N64: TMenuItem;
    N65: TMenuItem;
    N66: TMenuItem;
    N67: TMenuItem;
    N68: TMenuItem;
    N69: TMenuItem;
    N70: TMenuItem;
    ColorDialog1: TColorDialog;
    N71: TMenuItem;
    ToolButton27: TToolButton;
    PopupMenu1: TPopupMenu;
    N16: TMenuItem;
    N19: TMenuItem;
    N38: TMenuItem;
    N39: TMenuItem;
    N72: TMenuItem;
    R1: TMenuItem;
    N73: TMenuItem;
    N74: TMenuItem;
    Image2: TImage;
    N28: TMenuItem;
    N75: TMenuItem;
    N76: TMenuItem;
    N77: TMenuItem;
    ToolButton28: TToolButton;
    Timer1: TTimer;
    N30: TMenuItem;
    N78: TMenuItem;
    N79: TMenuItem;
    N80: TMenuItem;
    N81: TMenuItem;
    N82: TMenuItem;
    N83: TMenuItem;
    N84: TMenuItem;
    N85: TMenuItem;
    N86: TMenuItem;
    N87: TMenuItem;
    N88: TMenuItem;
    N89: TMenuItem;
    N90: TMenuItem;
    Panel2: TPanel;
    N91: TMenuItem;
    N92: TMenuItem;
    N93: TMenuItem;
    N94: TMenuItem;
    N95: TMenuItem;
    N96: TMenuItem;
    N97: TMenuItem;
    N98: TMenuItem;
    N99: TMenuItem;
    N100: TMenuItem;
    N101: TMenuItem;
    N102: TMenuItem;
    N103: TMenuItem;
    N104: TMenuItem;
    N105: TMenuItem;
    N106: TMenuItem;
    N107: TMenuItem;
    N108: TMenuItem;
    N109: TMenuItem;
    PopupMenu2: TPopupMenu;
    N110: TMenuItem;
    N111: TMenuItem;
    N112: TMenuItem;
    N113: TMenuItem;
    N114: TMenuItem;
    N115: TMenuItem;
    N116: TMenuItem;
    N117: TMenuItem;
    PageScroller1: TPageScroller;
    procedure FormCreate(Sender: TObject);
    procedure TV1Change(Sender: TObject; Node: TTreeNode);
    procedure DBGrid1CellClick(Column: TColumn);
    procedure DBGrid1DrawColumnCell(Sender: TObject; const Rect: TRect;
      DataCol: Integer; Column: TColumn; State: TGridDrawState);
    procedure DBGrid1DblClick(Sender: TObject);

    procedure N14Click(Sender: TObject);
    procedure N10Click(Sender: TObject);
    procedure N17Click(Sender: TObject);
    procedure N2Click(Sender: TObject);
    procedure N91Click(Sender: TObject);
    procedure N5Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormShow(Sender: TObject);
    procedure N4Click(Sender: TObject);
    procedure N20Click(Sender: TObject);
    procedure N28Click(Sender: TObject);
    procedure N25Click(Sender: TObject);
    procedure WORD1Click(Sender: TObject);
    procedure N21Click(Sender: TObject);
    procedure N22Click(Sender: TObject);
    procedure N6Click(Sender: TObject);
    procedure N7Click(Sender: TObject);
    procedure ListView1DblClick(Sender: TObject);
    procedure ListBox1DrawItem(Control: TWinControl; Index: Integer;
      Rect: TRect; State: TOwnerDrawState);
    procedure sbDrawPanel(StatusBar: TStatusBar; Panel: TStatusPanel;
      const Rect: TRect);
    procedure N31Click(Sender: TObject);
    procedure N34Click(Sender: TObject);
    procedure N41Click(Sender: TObject);
    procedure N43Click(Sender: TObject);
    procedure N51Click(Sender: TObject);
    procedure N46Click(Sender: TObject);
    procedure N47Click(Sender: TObject);
    procedure N49Click(Sender: TObject);
    procedure N50Click(Sender: TObject);
    procedure tvclear;
    procedure tvfresh;
    procedure N71Click(Sender: TObject);
    procedure N52Click(Sender: TObject);
    procedure N54Click(Sender: TObject);
    procedure N55Click(Sender: TObject);
    procedure N57Click(Sender: TObject);
    procedure N58Click(Sender: TObject);
    procedure N59Click(Sender: TObject);
    procedure N61Click(Sender: TObject);
    procedure N62Click(Sender: TObject);
    procedure N63Click(Sender: TObject);
    procedure N69Click(Sender: TObject);
    procedure N70Click(Sender: TObject);
    procedure TV1DblClick(Sender: TObject);
    procedure N36Click(Sender: TObject);
    procedure N45Click(Sender: TObject);
    procedure N40Click(Sender: TObject);
    procedure N73Click(Sender: TObject);
    procedure N75Click(Sender: TObject);
    procedure N76Click(Sender: TObject);
    procedure ToolButton28Click(Sender: TObject);
    procedure Timer1Timer(Sender: TObject);
    procedure N74Click(Sender: TObject);
    procedure N78Click(Sender: TObject);
    procedure TV1EndDock(Sender, Target: TObject; X, Y: Integer);
    procedure FormCloseQuery(Sender: TObject; var CanClose: Boolean);
    procedure TV1Click(Sender: TObject);
    procedure TV1MouseDown(Sender: TObject; Button: TMouseButton;
      Shift: TShiftState; X, Y: Integer);
    procedure ToolBar1MouseDown(Sender: TObject; Button: TMouseButton;
      Shift: TShiftState; X, Y: Integer);
    procedure Panel1MouseDown(Sender: TObject; Button: TMouseButton;
      Shift: TShiftState; X, Y: Integer);
    procedure N81Click(Sender: TObject);
    procedure N82Click(Sender: TObject);
    procedure N83Click(Sender: TObject);
    procedure N87Click(Sender: TObject);
    procedure N84Click(Sender: TObject);
    procedure N88Click(Sender: TObject);
    procedure N85Click(Sender: TObject);
    procedure N89Click(Sender: TObject);
    procedure TV1DragOver(Sender, Source: TObject; X, Y: Integer;
      State: TDragState; var Accept: Boolean);
    procedure Panel1DragOver(Sender, Source: TObject; X, Y: Integer;
      State: TDragState; var Accept: Boolean);
    procedure DBGrid1KeyPress(Sender: TObject; var Key: Char);
    procedure DBGrid1KeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure FormActivate(Sender: TObject);
    procedure N92Click(Sender: TObject);
    procedure N93Click(Sender: TObject);
    procedure N94Click(Sender: TObject);
    procedure DBGrid1TitleClick(Column: TColumn);
    procedure DBGrid1MouseDown(Sender: TObject; Button: TMouseButton;
      Shift: TShiftState; X, Y: Integer);
    procedure N110Click(Sender: TObject);
    procedure N113Click(Sender: TObject);
    procedure N115Click(Sender: TObject);
    procedure N116Click(Sender: TObject);
  private
    ProgressBar1:Tprogressbar;
    statusdrawrect:Trect;
    { Private declarations }
  public
   procedure AddColors (s:string;Colors:TColor);
    { Public declarations }
  end;

var
  label3_str,label4_str:string;
  isasc:boolean=true;
  ex1:boolean=true;
  ex2:boolean=true;
  ex3:boolean=true;
  ex4:boolean=false;
  Form1: TForm1;
  num:integer;
  min:string;
implementation

{$R *.dfm}
uses Main,st_sx,sj_zero,st_dc,yh_new,
yh_sel,login,p_word_set,p_backup_db,
P_DB_manage,P_qr_report,P_st_insert,P_st_oper,
sj_four_rand,graphic_exam,other_graphic,report_st,
report_sj,U_prn_set,U_global_setting,global,U_tip,
P_which_key;

const
displaywidth=1024;
displayheight=768;
var
olddisplaywidth,olddisplayheight:integer;

procedure update_txb;
var
num:integer;
begin
num:=1;
with main.DataModule2 do
begin
aq3.Close;
aq3.SQL.Clear;
aq3.SQL.Add('select * from 题型表');
aq3.Open;
if aq3.Eof then exit
else aq3.First;
while not aq3.Eof do
begin
try
aq2.Close;
aq2.SQL.Clear;
aq2.SQL.Add('update 题型表 set id='+inttostr(num)+' where name='''+
trim(aq3.FieldValues['name'])+'''');
inc(num);
aq2.ExecSQL;
aq3.Next;
except
begin
messagedlg('数据库内部错误，无法执行此操作！',mterror,[mbok],0);
exit;
end;
end;

end;
end;
end;

procedure update_zsdb;
var
num:integer;
begin
num:=1;
with main.DataModule2 do
begin
aq3.Close;
aq3.SQL.Clear;
aq3.SQL.Add('select * from 知识点表');
aq3.Open;
if aq3.Eof then exit
else aq3.First;
while not aq3.Eof do
begin
try
aq2.Close;
aq2.SQL.Clear;
aq2.SQL.Add('update 知识点表 set id='+inttostr(num)+' where name='''+
trim(aq3.FieldValues['name'])+''' and subname='''+
trim(aq3.FieldValues['subname'])+'''');
inc(num);
aq2.ExecSQL;
aq3.Next;
except
begin
messagedlg('数据库内部错误，无法执行此操作！',mterror,[mbok],0);
exit;
end;
end;

end;
end;
end;

procedure update_sjb;
var
num:integer;
begin
num:=0;
with main.DataModule2 do
begin
aq3.Close;
aq3.SQL.Clear;
aq3.SQL.Add('select * from 试卷表');
aq3.Open;
if aq3.Eof then exit
else aq3.First;
while not aq3.Eof do
begin
try
aq2.Close;
aq2.SQL.Clear;
aq2.SQL.Add('update 试卷表 set 试卷号='+inttostr(num)+' where 试卷名称='''+
trim(aq3.FieldValues['试卷名称'])+''' and 出卷人='''+
trim(aq3.FieldValues['出卷人'])+'''');
inc(num);
aq2.ExecSQL;
aq3.Next;
except
begin
messagedlg('数据库内部错误，无法执行此操作！',mterror,[mbok],0);
exit;
end;
end;
end;
end;
end;

procedure playsound(soundfile:string);
begin
mcisendstring(pchar('close '+soundfile),nil,0,0);
mcisendstring(pchar('open '+soundfile),nil,0,0);
mcisendstring(pchar('play '+soundfile),nil,0,0);
end;
procedure TForm1.FormCreate(Sender: TObject);
var
  node,tempnode,temppnode:Ttreenode;
  ll:Tstringlist;
  i:integer;
  s:string;
  myfile:Tinifile;
  devmode:Tdevicemode;
  temp:integer;
  formtop:boolean;
begin
myfile:=Tinifile.Create(extractfilepath(application.ExeName)+'myfile.ini');
global.blnopensound:=myfile.ReadBool('other_setting','opensound',false);
formtop:=myfile.ReadBool('other_setting','ontop',false);
if formtop then
form1.FormStyle:=fsstayontop
else
form1.FormStyle:=fsnormal;
case myfile.ReadInteger('form_setting','auto_size',2) of
0:begin
if screen.Width <> displaywidth then
begin
  if enumdisplaysettings(nil,0,devmode) then
  begin
    olddisplaywidth:=devmode.dmPelsWidth;
    olddisplayheight:=devmode.dmPelsHeight;
    devmode.dmFields:=dm_pelswidth or dm_pelsheight;
    devmode.dmPelsWidth:=displaywidth;
    devmode.dmPelsHeight:=displayheight;
    if changedisplaysettings(devmode,cds_test)=disp_change_successful then
      changedisplaysettings(devmode,cds_updateregistry);
  end;
end;
end;
1:
begin
scaled:=true;
if(screen.Width <> displaywidth) then
begin
height:=longint(height)*longint(screen.height) div displayheight;
width:=longint(width)*longint(screen.width) div displaywidth;
scaleby(screen.Width,displaywidth);
end;
end;