unit9.pas

毕业设计(带论文)—试卷生成系统,做的不错

unit Unit9;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Buttons, ExtCtrls, DBCtrls, ComCtrls, Mask, Grids,
  DBGrids, DB, DBTables;

type
  Treadproform = class(TForm)
    PageControl2: TPageControl;
    TabSheet4: TTabSheet;
    TabSheet5: TTabSheet;
    Label1: TLabel;
    Label2: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    DBMemo1: TDBMemo;
    DBEdit1: TDBEdit;
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    DBMemo2: TDBMemo;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    DBEdit5: TDBEdit;
    DBRadioGroup1: TDBRadioGroup;
    TabSheet2: TTabSheet;
    Label10: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    Label13: TLabel;
    Label14: TLabel;
    DBMemo3: TDBMemo;
    DBEdit8: TDBEdit;
    DBEdit9: TDBEdit;
    DBEdit10: TDBEdit;
    DBEdit11: TDBEdit;
    DBRadioGroup2: TDBRadioGroup;
    TabSheet3: TTabSheet;
    Label15: TLabel;
    Label16: TLabel;
    Label17: TLabel;
    Label18: TLabel;
    Label19: TLabel;
    DBMemo4: TDBMemo;
    DBEdit12: TDBEdit;
    DBEdit13: TDBEdit;
    DBEdit14: TDBEdit;
    DBEdit15: TDBEdit;
    DBRadioGroup3: TDBRadioGroup;
    DBEdit6: TDBEdit;
  //  DBEdit7: TDBEdit;
    Panel1: TPanel;
    DBNavigator1: TDBNavigator;
    BitBtn1: TBitBtn;
    DBGrid1: TDBGrid;
    DBMemo5: TDBMemo;
    DBMemo6: TDBMemo;
    DBMemo7: TDBMemo;
    DBMemo8: TDBMemo;
    Query1: TQuery;
    DBNavigator2: TDBNavigator;
    DataSource1: TDataSource;
    TreeView1: TTreeView;
    BitBtn2: TBitBtn;
    BitBtn3: TBitBtn;
    Query2: TQuery;
    DBComboBox1: TDBComboBox;
    Label20: TLabel;
    Label21: TLabel;
    Label22: TLabel;
    Label23: TLabel;
    Label24: TLabel;
    function checknewreadpro:boolean;
    procedure DBNavigator2Click(Sender: TObject; Button: TNavigateBtn);
    procedure FormActivate(Sender: TObject);
    procedure TabSheet4Show(Sender: TObject);
    procedure TabSheet5Show(Sender: TObject);
    procedure TreeView1Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure TreeView1MouseDown(Sender: TObject; Button: TMouseButton;
      Shift: TShiftState; X, Y: Integer);
    procedure DBNavigator1Click(Sender: TObject; Button: TNavigateBtn);
    procedure DBEdit1Change(Sender: TObject);
  private
    { Private declarations }
  public
  temp:integer;
    { Public declarations }
  end;

var
  readproform: Treadproform;
  addreadpro:boolean;
implementation

uses Unit4, Unit3;

{$R *.dfm}



function Treadproform.checknewreadpro:boolean;
var
success:boolean;
begin
success:=true;
with DataModule4.Table_readpro do
begin
if DBEdit1.Text='' then
success:=false;
if DBEdit2.Text='' then
success:=false;
 if DBEdit3.Text='' then
success:=false;
if DBEdit4.Text='' then
success:=false;
if DBEdit5.Text='' then
success:=false;
if DBComboBox1.Text='' then
success:=false;
if DBMemo1.Text='' then
success:=false;
if DBMemo2.Text='' then
success:=false;

if DBRadioGroup1.Value='' then
success:=false;
//if DBRadioGroup1.
//if DBRadioGroup1.
if not success then
begin
showmessage('红色项必须填写,请补上未填的红色项!');
end;
  checknewreadpro:=success;
end;

end;

procedure Treadproform.DBNavigator2Click(Sender: TObject; Button: TNavigateBtn);
begin
 DBMemo1.DataSource:=DataModule4.DataSource_readpro;
  DBEdit1.DataSource:=DataModule4.DataSource_readpro;
  DBEdit6.DataSource:=DataModule4.DataSource_readpro ;
  DBComboBox1.DataSource:=DataModule4.DataSource_readpro;
  DBMemo2.DataSource:=DataModule4.DataSource_readpro;
  DBEdit2.DataSource:=DataModule4.DataSource_readpro;
  DBEdit3.DataSource:=DataModule4.DataSource_readpro ;
  DBEdit4.DataSource:=DataModule4.DataSource_readpro;
   DBEdit5.DataSource:=DataModule4.DataSource_readpro;
   DBRadioGroup1.DataSource:=DataModule4.DataSource_readpro;
   DBMemo3.DataSource:=DataModule4.DataSource_readpro;
  DBEdit8.DataSource:=DataModule4.DataSource_readpro ;
  DBEdit9.DataSource:=DataModule4.DataSource_readpro;
   DBEdit10.DataSource:=DataModule4.DataSource_readpro;
    DBEdit11.DataSource:=DataModule4.DataSource_readpro;
    DBRadioGroup2.DataSource:=DataModule4.DataSource_readpro;
       DBMemo4.DataSource:=DataModule4.DataSource_readpro;
  DBEdit12.DataSource:=DataModule4.DataSource_readpro ;
  DBEdit13.DataSource:=DataModule4.DataSource_readpro;
   DBEdit14.DataSource:=DataModule4.DataSource_readpro;
    DBEdit15.DataSource:=DataModule4.DataSource_readpro;
    DBRadioGroup3.DataSource:=DataModule4.DataSource_readpro;
//  DBEdit4.DataSource:=DataModule4.DataSource_filltext;
 // DBEdit5.DataSource:=DataModule4.DataSource_filltext;
//  DBEdit6.DataSource:=DataModule4.DataSource_filltext ;
 // DBRadioGroup1.DataSource:=DataModule4.DataSource_judge ;

   case button of
   nbDelete:
   begin
   
if Treeview1.Focused=false then
begin
DBNavigator2.BtnClick(nbCancel);
showmessage('请选择一个章节点') ;
  DBNavigator2.BtnClick(nbCancel);
  DBNavigator2.Enabled:=false;
end
else
  

query2.close;
query2.sql.clear;
query2.sql.text:='delete ti_readpro where tno='''+inttostr(mainform.updateno)+''' ';
query2.ExecSQL;

query2.close;
query2.sql.clear;
query2.sql.text:='update ti_readpro set tno=tno-1 where tno>'''+inttostr(mainform.updateno)+''' and tno like '''+inttostr(mainform.updateno div 10)+'%''';
query2.ExecSQL;
DBNavigator2.DataSource:=DataModule4.DataSource_readpro;
  showmessage(inttostr(DataModule4.Table_readpro.FieldValues['tno']));
   end;
   end;


case button of
nbInsert:
begin
addreadpro:=true;
if Treeview1.Focused=false then
begin
showmessage('请选择一个章节点') ;
  DBNavigator2.BtnClick(nbCancel);
   DBNavigator2.Enabled:=false;
end
else
if treeview1.Focused=true then
begin
 DBNavigator2.Enabled:=false;
if (temp mod 10)=0 then
begin
showmessage('本章知识点已满!');
DBNavigator2.BtnClick(nbCancel);
end
else
begin
DBEdit1.text:=inttostr(temp);
end;
end;
end;
end;

 case button of
nbPost:
begin
DataModule4.Table_readpro.Close;
DataModule4.Table_readpro.Open;

end;
end;
end;

procedure Treadproform.FormActivate(Sender: TObject);
begin
DBNavigator1.DataSource:=DataModule4.DataSource_readpro;
DBNavigator2.Enabled:=false;
end;

procedure Treadproform.TabSheet4Show(Sender: TObject);
begin
     DBNavigator2.Enabled:=true;
DBNavigator2.DataSource:=DataModule4.DataSource_readpro;
end;

procedure Treadproform.TabSheet5Show(Sender: TObject);
begin
DBNavigator2.Enabled:=false;
 DBNavigator1.DataSource:=DataModule4.DataSource_readpro;
end;

procedure Treadproform.TreeView1Click(Sender: TObject);
begin

{
if TreeView1.Selected.text='C语言' then    //总节点
   begin
  query1.Active:=false;
  query1.Active:=true;
if(query1.Active=true)then
begin
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select * from ti_choose');
query1.Open;
 end;
 end;           }
                   {
 if TreeView1.Selected.text='第一章 C语言基础知识' then   //第一章
   begin

  query1.Active:=false;
  query1.Active:=true;


if(query1.Active=true)then
begin
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select * from ti_choose where tno like ''1%%%''');
query1.Open;
 end;
 end;

                       }
                       {
     if TreeView1.Selected.text='第一节' then         //第一章第一节
   begin
  query1.Active:=false;
  query1.Active:=true;


if(query1.Active=true)then
begin
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select * from ti_choose where tno like ''11%%''');
query1.Open;
 end;
 end;
                        }

 if TreeView1.Selected.text='第一知识点 C语言的特点' then  //第一章第一节第一知识点
   begin
  query1.Active:=false;
  query1.Active:=true;
if(query1.Active=true)then
begin
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select * from ti_readpro where tno like ''111%'' order by tno');
query1.Open;
begin
  if query1.RecordCount<>0 then
  begin
  query1.Last;
  temp:=query1.FieldValues['tno']+1;
  end
  else if query1.RecordCount=0 then
  begin
     temp:=1111;
  end;
end;

 end;
 end;

                          {
 if TreeView1.Selected.text='第二节' then      //第一章第二节
   begin

  query1.Active:=false;
  query1.Active:=true;


if(query1.Active=true)then
begin
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select * from ti_choose where tno like ''12%%''');
query1.Open;
 end;
 end;

                              }
 if TreeView1.Selected.text='第一知识点 C语言的标识符和保留字' then  //第一章第二节第一知识点
   begin
  query1.Active:=false;
  query1.Active:=true;
if(query1.Active=true)then
begin
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select * from ti_readpro where tno like ''121%'' order by tno');
query1.Open;
begin
  if query1.RecordCount<>0 then
  begin
  query1.Last;
  temp:=query1.FieldValues['tno']+1;
  end
  else if query1.RecordCount=0 then
  begin
     temp:=1211;
  end;
end;

 end;
 end;
 {
 
     if TreeView1.Selected.text='第三节' then    //第一章第三节
   begin

  query1.Active:=false;
  query1.Active:=true;


if(query1.Active=true)then
begin
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select * from ti_readpro where tno like ''13%%''');
query1.Open;
 end;
 end;
                           }
if TreeView1.Selected.text='第一知识点 C程序的结构' then      //第一章第三节第一知识点
   begin

  query1.Active:=false;
  query1.Active:=true;


if(query1.Active=true)then
begin
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select * from ti_readpro where tno like ''131%'' order by tno');
query1.Open;
begin
  if query1.RecordCount<>0 then
  begin
  query1.Last;
  temp:=query1.FieldValues['tno']+1;
  end
  else if query1.RecordCount=0 then
  begin
     temp:=1311;
  end;
end;

 end;
 end;
                        {
 if TreeView1.Selected.text='第四节' then             //第一章第四节
   begin

  query1.Active:=false;
  query1.Active:=true;


if(query1.Active=true)then
begin
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select * from ti_choose where tno like ''14%%''');
query1.Open;
 end;
 end;
                            }


if TreeView1.Selected.text='第一知识点 C程序的开发过程' then     //第一章第四节第一知识点
   begin
  query1.Active:=false;
  query1.Active:=true;
if(query1.Active=true)then
begin
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select * from ti_readpro where tno like ''141%'' order by tno');
query1.Open;
begin
  if query1.RecordCount<>0 then
  begin
  query1.Last;
  temp:=query1.FieldValues['tno']+1;
  end
  else if query1.RecordCount=0 then
  begin
     temp:=1411;
  end;
end;

 end;
 end;

 //-----------------------------------------------------------------
 {
 if TreeView1.Selected.text='第二章 数据类型、运算符与表达式' then
   begin
  query1.Active:=false;
  query1.Active:=true;
if(query1.Active=true)then
begin
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select * from ti_choose where tno like ''2%%%''');
query1.Open;
 end;
 end;

                     }
                     {
if TreeView1.Selected.text='第一节' then
   begin
  query1.Active:=false;
  query1.Active:=true;
if(query1.Active=true)then
begin
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select * from ti_choose where tno like ''21%%''');
query1.Open;
 end;
 end;

                             }

if TreeView1.Selected.text='第一知识点 C语言数据类型' then   //第二章第一节第一知识点
   begin
  query1.Active:=false;
  query1.Active:=true;
if(query1.Active=true)then
begin
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select * from ti_readpro where tno like ''211%'' order by tno');
query1.Open;
begin
  if query1.RecordCount<>0 then
  begin
  query1.Last;
  temp:=query1.FieldValues['tno']+1;
  end
  else if query1.RecordCount=0 then
  begin
     temp:=2111;
  end;
end;

 end;
 end;

if TreeView1.Selected.text='第二知识点 整型数据' then
   begin
  query1.Active:=false;
  query1.Active:=true;
if(query1.Active=true)then
begin
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select * from ti_readpro where tno like ''212%'' order by tno');
query1.Open;
begin
  if query1.RecordCount<>0 then
  begin
  query1.Last;
  temp:=query1.FieldValues['tno']+1;
  end
  else if query1.RecordCount=0 then
  begin
     temp:=2121;
  end;
end;

 end;
 end;


if TreeView1.Selected.text='第三知识点 实型数据' then
   begin
  query1.Active:=false;
  query1.Active:=true;
if(query1.Active=true)then
begin
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select * from ti_readpro where tno like ''213%'' order by tno');
query1.Open;
begin
  if query1.RecordCount<>0 then
  begin
  query1.Last;
  temp:=query1.FieldValues['tno']+1;
  end
  else if query1.RecordCount=0 then
  begin
     temp:=2131;
  end;
end;

 end;
 end;
if TreeView1.Selected.text='第四知识点 字符型数据' then
   begin
  query1.Active:=false;
  query1.Active:=true;
if(query1.Active=true)then
begin
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select * from ti_readpro where tno like ''214%'' order by tno');
query1.Open;
begin
  if query1.RecordCount<>0 then
  begin
  query1.Last;
  temp:=query1.FieldValues['tno']+1;
  end
  else if query1.RecordCount=0 then
  begin
     temp:=2141;
  end;
end;