unit Modify;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, jpeg, ExtCtrls, StdCtrls, ComCtrls, Grids, DBGrids, ImgList,
  ToolWin, DBCtrls, Mask, XPMenu;

type
  TModifyForm = class(TForm)
    GroupBox: TGroupBox;
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    TabSheet3: TTabSheet;
    TabSheet4: TTabSheet;
    TabSheet5: TTabSheet;
    TabSheet6: TTabSheet;
    GroupBox2: TGroupBox;
    GroupBox3: TGroupBox;
    GroupBox4: TGroupBox;
    GroupBox5: TGroupBox;
    GroupBox6: TGroupBox;
    GroupBox7: TGroupBox;
    ImageList1: TImageList;
    DBGrid1: TDBGrid;
    ToolBar1: TToolBar;
    tbfirst: TToolButton;
    TBprior: TToolButton;
    TBNext: TToolButton;
    TBLast: TToolButton;
    TBQuery: TToolButton;
    TBModify: TToolButton;
    Tbcancel: TToolButton;
    DBGrid2: TDBGrid;
    DBGrid3: TDBGrid;
    DBGrid4: TDBGrid;
    DBGrid5: TDBGrid;
    DBGrid6: TDBGrid;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit5: TDBEdit;
    DBEdit7: TDBEdit;
    DBEdit8: TDBEdit;
    DBEdit9: TDBEdit;
    DBEdit10: TDBEdit;
    DBEdit11: TDBEdit;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    DBComboBox1: TDBComboBox;
    DBComboBox2: TDBComboBox;
    DBComboBox3: TDBComboBox;
    Label12: TLabel;
    DBEdit3: TDBEdit;
    Label13: TLabel;
    Label14: TLabel;
    Label15: TLabel;
    Label16: TLabel;
    Label17: TLabel;
    Label18: TLabel;
    Label19: TLabel;
    Label20: TLabel;
    Label21: TLabel;
    Label22: TLabel;
    Label23: TLabel;
    Label24: TLabel;
    DBEdit4: TDBEdit;
    DBEdit6: TDBEdit;
    DBEdit12: TDBEdit;
    DBEdit13: TDBEdit;
    DBEdit14: TDBEdit;
    DBEdit15: TDBEdit;
    DBEdit16: TDBEdit;
    DBEdit17: TDBEdit;
    DBEdit18: TDBEdit;
    DBEdit19: TDBEdit;
    DBEdit20: TDBEdit;
    DBMemo1: TDBMemo;
    Label25: TLabel;
    Label26: TLabel;
    Label27: TLabel;
    Label28: TLabel;
    Label29: TLabel;
    Label30: TLabel;
    Label31: TLabel;
    DBEdit21: TDBEdit;
    DBEdit22: TDBEdit;
    DBEdit23: TDBEdit;
    DBEdit24: TDBEdit;
    DBEdit25: TDBEdit;
    DBEdit26: TDBEdit;
    DBEdit27: TDBEdit;
    Label32: TLabel;
    DBMemo2: TDBMemo;
    Label33: TLabel;
    Label34: TLabel;
    Label35: TLabel;
    Label36: TLabel;
    Label37: TLabel;
    Label38: TLabel;
    Label39: TLabel;
    Label40: TLabel;
    DBEdit28: TDBEdit;
    DBEdit29: TDBEdit;
    DBEdit30: TDBEdit;
    DBEdit31: TDBEdit;
    DBEdit32: TDBEdit;
    DBEdit33: TDBEdit;
    DBEdit34: TDBEdit;
    DBMemo3: TDBMemo;
    Label41: TLabel;
    Label42: TLabel;
    Label43: TLabel;
    Label44: TLabel;
    Label45: TLabel;
    Label46: TLabel;
    Label47: TLabel;
    Label48: TLabel;
    Label49: TLabel;
    Label50: TLabel;
    DBEdit35: TDBEdit;
    DBEdit36: TDBEdit;
    DBEdit37: TDBEdit;
    DBEdit38: TDBEdit;
    DBEdit39: TDBEdit;
    DBEdit40: TDBEdit;
    DBEdit41: TDBEdit;
    DBEdit42: TDBEdit;
    DBEdit43: TDBEdit;
    DBEdit44: TDBEdit;
    Label51: TLabel;
    DBMemo4: TDBMemo;
    Label52: TLabel;
    Label53: TLabel;
    Label54: TLabel;
    Label55: TLabel;
    Label56: TLabel;
    Label57: TLabel;
    Label58: TLabel;
    Label59: TLabel;
    Label60: TLabel;
    DBEdit45: TDBEdit;
    DBEdit46: TDBEdit;
    DBEdit47: TDBEdit;
    DBEdit48: TDBEdit;
    DBEdit49: TDBEdit;
    DBEdit50: TDBEdit;
    DBEdit51: TDBEdit;
    DBEdit52: TDBEdit;
    DBMemo5: TDBMemo;
    XPMenu1: TXPMenu;
    procedure DBGrid2Enter(Sender: TObject);
    procedure tbfirstClick(Sender: TObject);
    procedure TBpriorClick(Sender: TObject);
    procedure TBNextClick(Sender: TObject);
    procedure TBLastClick(Sender: TObject);
    procedure TBModifyClick(Sender: TObject);
    procedure TbcancelClick(Sender: TObject);
    procedure TBQueryClick(Sender: TObject);
  private
    { Private declarations }
  public
  username:string;
  flags:boolean;
    { Public declarations }
  end;

var
  ModifyForm: TModifyForm;

implementation
uses md,subquery;

{$R *.dfm}


procedure TModifyForm.DBGrid2Enter(Sender: TObject);
begin
DBgrid2.DataSource:=datamd.DSorder;
end;
//判斷當(dāng)前所有選擇的活動(dòng)頁(yè),記錄移到第一條
procedure TModifyForm.tbfirstClick(Sender: TObject);
begin
case pagecontrol1.ActivePageIndex of
     0:datamd.ADOOrder.First;  //學(xué)生基本情況
     1:datamd.ADOWorth.First;
     2:datamd.ADOEnrol.First;
     3:datamd.ADOVisit.First;
     4:datamd.ADORegiste.First;
     5:datamd.ADOEmpleer.First;
end;
end;
//判斷當(dāng)前所有選擇的活動(dòng)頁(yè),記錄移到前一條
procedure TModifyForm.TBpriorClick(Sender: TObject);
begin
case pagecontrol1.ActivePageIndex of
     0:datamd.ADOOrder.Prior;
     1:datamd.ADOWorth.prior;
     2:datamd.ADOEnrol.prior;
     3:datamd.ADOVisit.prior;
     4:datamd.ADORegiste.prior;
     5:datamd.ADOEmpleer.prior;
end;
end;
//判斷當(dāng)前所有選擇的活動(dòng)頁(yè),記錄移到后一條
procedure TModifyForm.TBNextClick(Sender: TObject);
begin
case pagecontrol1.ActivePageIndex of
     0:datamd.ADOOrder.next;
     1:datamd.ADOWorth.next;
     2:datamd.ADOEnrol.next;
     3:datamd.ADOVisit.next;
     4:datamd.ADORegiste.next;
     5:datamd.ADOEmpleer.next;
end;
end;
//判斷當(dāng)前所有選擇的活動(dòng)頁(yè),記錄移到最后一條
procedure TModifyForm.TBLastClick(Sender: TObject);
begin
case pagecontrol1.ActivePageIndex of
     0:datamd.ADOOrder.last;
     1:datamd.ADOWorth.last;
     2:datamd.ADOEnrol.last;
     3:datamd.ADOVisit.last;
     4:datamd.ADORegiste.last;
     5:datamd.ADOEmpleer.last;
end;
end;
//判斷當(dāng)前所有選擇的活動(dòng)頁(yè),修改當(dāng)前的記錄
procedure TModifyForm.TBModifyClick(Sender: TObject);
begin
case pagecontrol1.ActivePageIndex of
     0:
     begin  //學(xué)生基本資料表
     datamd.ADOOrder.Edit;
     datamd.ADOOrder.post;
     end;
     1:
     begin //個(gè)人財(cái)物表
     datamd.ADOWorth.edit;
     datamd.ADOWorth.post;
     end;
     2:
     begin //出樓登記表
     datamd.ADOEnrol.edit;
     datamd.ADOEnrol.post;
     end;
     3:
     begin //親人來(lái)訪表
     datamd.ADOVisit.edit;
     datamd.ADOVisit.post;
     end;
     4:
     begin //學(xué)生注冊(cè)表
     datamd.ADORegiste.edit;
     datamd.ADORegiste.post;
     end;
     5:
     begin //員工資料表
     datamd.ADOEmpleer.edit;
     datamd.ADOEmpleer.post;
     end;
end;
end;
///判斷當(dāng)前所有選擇的活動(dòng)頁(yè),取消發(fā)前記錄的修改
procedure TModifyForm.TbcancelClick(Sender: TObject);
begin
case pagecontrol1.ActivePageIndex of
     0:datamd.ADOOrder.cancel;  //學(xué)生基本情況表
     1:datamd.ADOWorth.cancel;  //學(xué)生財(cái)物表
     2:datamd.ADOEnrol.cancel;  //學(xué)生出樓貨物登記表
     3:datamd.ADOVisit.cancel;  //親人來(lái)訪登記表
     4:datamd.ADORegiste.cancel; //學(xué)生注冊(cè)表
     5:datamd.ADOEmpleer.cancel; //員工資料表
end;
end;
//判斷當(dāng)前所有選擇的活動(dòng)頁(yè),查詢(xún)相應(yīng)的數(shù)據(jù)表記錄
procedure TModifyForm.TBQueryClick(Sender: TObject);
begin
application.CreateForm(TsubQform,subqform);
subqform.ShowModal;
subqform.Free;
if  flags then
begin
case modifyform.PageControl1.ActivePageIndex of
     0:
     begin
     with datamd.ADOOrder do //學(xué)生基本情況表
       begin
       close;
       sql.Clear;
       sql.Add('select * from tborder where 姓名='''+username+'''');
       open;
       update;
       end;
     end;
     1:
     begin
     with datamd.ADOWorth do //個(gè)人財(cái)物表
       begin
       close;
       sql.Clear;
       sql.Add('select * from worth where 姓名='''+username+'''');
       open;
       update;
       end;
     end;
     2:
     begin
     with datamd.ADOEnrol do //出樓登記表
       begin
       close;
       sql.Clear;
       sql.Add('select * from tbEnrol where 姓名='''+username+'''');
       open;
       update;
       end;
     end;
     3:
     begin
     with datamd.ADOVisit do  //來(lái)訪登記表
       begin
       close;
       sql.Clear;
       sql.Add('select * from visit where 姓名='''+username+'''');
       open;
       update;
       end;
     end;
     4:
     begin
     with datamd.ADORegiste do //學(xué)生注冊(cè)表
       begin
       close;
       sql.Clear;
       sql.Add('select * from registe where 姓名='''+username+'''');
       open;
       update;
       end;
     end;
     5:
     begin
     with datamd.ADOEmpleer do //員工資料表
       begin
       close;
       sql.Clear;
       sql.Add('select * from empleer where 姓名='''+username+'''');
       open;
       update;
       end;
     end;
 end;
end;
end;

end.