unit1.~pas

飞思科技的书不错

unit Unit1;

interface

uses
  Unit2, Unit3, Unit4,Unit5,Unit6,Unit7,Unit8,DB,
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ComCtrls, ExtCtrls, Menus, ToolWin, ImgList, StdCtrls, DBCtrls,
  Mask, Grids, DBGrids, Buttons, TeEngine, Series, TeeProcs, Chart, DbChart;

type
  TForm1 = class(TForm)
    CoolBar1: TCoolBar;
    ToolBar1: TToolBar;
    ToolButton1: TToolButton;
    ToolButton2: TToolButton;
    ToolButton3: TToolButton;
    ToolButton4: TToolButton;
    ToolButton5: TToolButton;
    ToolButton6: TToolButton;
    ToolButton7: TToolButton;
    Panel1: TPanel;
    Panel2: TPanel;
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    TabSheet3: TTabSheet;
    TabSheet4: TTabSheet;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    DBEdit_No: TDBEdit;
    DBEdit_Name: TDBEdit;
    DBEdit_PName: TDBEdit;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    DBEdit_Birth: TDBEdit;
    ImageList1: TImageList;
    Label11: TLabel;
    Label12: TLabel;
    Label13: TLabel;
    Label15: TLabel;
    Label16: TLabel;
    Label17: TLabel;
    Label18: TLabel;
    Label19: TLabel;
    Label20: TLabel;
    Label21: TLabel;
    Label22: TLabel;
    Label23: TLabel;
    Label24: TLabel;
    Label25: TLabel;
    DBEdit_Sex: TDBEdit;
    DBEdit_Home: TDBEdit;
    DBEdit_Race: TDBEdit;
    DBEdit_Helth: TDBEdit;
    DBEdit_Marrage: TDBEdit;
    DBEdit_Add: TDBEdit;
    DBEdit_Party: TDBEdit;
    DBEdit_PartyTime: TDBEdit;
    DBEdit_Policy: TDBEdit;
    DBEdit_Degree: TDBEdit;
    DBEdit_Dept: TDBEdit;
    DBEdit_WorkShop: TDBEdit;
    DBEdit_Class: TDBEdit;
    DBEdit_Work: TDBEdit;
    DBEdit_Level: TDBEdit;
    DBEdit_Major: TDBEdit;
    DBEdit_WorkTime: TDBEdit;
    DBEdit_SumWorkAge: TDBEdit;
    DBEdit_EnterTime: TDBEdit;
    DBEdit_LocalAge: TDBEdit;
    Panel3: TPanel;
    DBGrid1: TDBGrid;
    Label14: TLabel;
    DBText1: TDBText;
    Panel4: TPanel;
    DBGrid2: TDBGrid;
    Label26: TLabel;
    DBText2: TDBText;
    Panel5: TPanel;
    DBGrid3: TDBGrid;
    Panel6: TPanel;
    DBGrid4: TDBGrid;
    Label27: TLabel;
    Label28: TLabel;
    DBText3: TDBText;
    DBText4: TDBText;
    Chart1: TChart;
    Series1: TPieSeries;
    BitBtn1: TBitBtn;
    BitBtn_sub: TBitBtn;
    BitBtn_exit: TBitBtn;
    Button_exp_add: TButton;
    Button_car_add: TButton;
    Button_relation_add: TButton;
    Button2: TButton;
    DBChart1: TDBChart;
    Series2: TBarSeries;
    Button_M_exp: TButton;
    Button_M_car: TButton;
    Button_M_relation: TButton;
    Button_M_salary: TButton;
    MainMenu1: TMainMenu;
    N1: TMenuItem;
    N2: TMenuItem;
    N3: TMenuItem;
    N4: TMenuItem;
    N5: TMenuItem;
    N6: TMenuItem;
    N7: TMenuItem;
    N8: TMenuItem;
    N9: TMenuItem;
    N10: TMenuItem;
    N11: TMenuItem;
    N12: TMenuItem;
    Button_D_exp: TButton;
    Button_D_car: TButton;
    Button_D_relation: TButton;
    Button_D_salary: TButton;
    procedure FormCreate(Sender: TObject);
    procedure ToolButton1Click(Sender: TObject);
    procedure ToolButton2Click(Sender: TObject);
    procedure ToolButton3Click(Sender: TObject);
    procedure ToolButton4Click(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure ToolButton5Click(Sender: TObject);
    procedure DBEdit_SexClick(Sender: TObject);
    procedure DBEdit_BirthClick(Sender: TObject);
    procedure BitBtn_subClick(Sender: TObject);
    procedure BitBtn_exitClick(Sender: TObject);
    Procedure Set_ReadOnly;
    Procedure Set_NotReadOnly;
    procedure Button_exp_addClick(Sender: TObject);
    procedure Button_car_addClick(Sender: TObject);
    procedure Button_relation_addClick(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure ToolButton6Click(Sender: TObject);
    procedure Button_M_expClick(Sender: TObject);
    procedure Button_M_carClick(Sender: TObject);
    procedure Button_M_relationClick(Sender: TObject);
    procedure Button_M_salaryClick(Sender: TObject);
    procedure Button_D_expClick(Sender: TObject);
    procedure Button_D_carClick(Sender: TObject);
    procedure Button_D_relationClick(Sender: TObject);
    procedure Button_D_salaryClick(Sender: TObject);
    procedure ToolButton7Click(Sender: TObject);

    { Private declarations }
  public
   ModifyRecord:boolean;
   Modify_exp,Modify_car,Modify_relation,Modify_salary:boolean;

   //exp_pos:integer;
    { Public declarations }
  end;

var
  Form1: TForm1;
  NewRecord:boolean;
  count_exp:integer;
implementation

{$R *.dfm}

procedure TForm1.FormCreate(Sender: TObject);
begin
    Form1.WindowState:=wsMaximized;
    NewRecord:=False;
    ModifyRecord:=False;
    BitBtn_sub.Enabled:=False;
    BitBtn_exit.Enabled:=False;
    Button_exp_add.Enabled:=True;
    Modify_exp:=False;
    Modify_car:=False;
    Modify_relation:=False;
    Modify_salary:=False;
end;

Procedure TForm1.Set_ReadOnly;
begin
      DBEdit_No.ReadOnly:=True;
        DBEdit_Name.ReadOnly:=True;
        DBEdit_PName.ReadOnly:=True;
        DBEdit_Add.ReadOnly:=True;
        DBEdit_CLass.ReadOnly:=True;
        DBEdit_Degree.ReadOnly:=True;
        DBEdit_Dept.ReadOnly:=True;
        DBEdit_Helth.ReadOnly:=True;
        DBEdit_Home.ReadOnly:=True;
        DBEdit_LOcalAge.ReadOnly:=True;
        DBEdit_Marrage.ReadOnly:=True;
        DBEdit_No.ReadOnly:=True;
        DBEdit_Party.ReadOnly:=True;
        DBEdit_Policy.ReadOnly:=True;
        DBEdit_Race.ReadOnly:=True;
        DBEdit_WorkShop.ReadOnly:=True;
        DBEdit_Level.ReadOnly:=True;
        DBEdit_SumWorkAge.ReadOnly:=True;
        DBEdit_Work.ReadOnly:=True;
        DBEdit_Major.ReadOnly:=True;
end;

procedure TForm1.Set_NotReadOnly;
begin
       DBEdit_No.ReadOnly:=False;
        DBEdit_Name.ReadOnly:=False;
        DBEdit_PName.ReadOnly:=False;
        DBEdit_Add.ReadOnly:=False;
        DBEdit_CLass.ReadOnly:=False;
        DBEdit_Degree.ReadOnly:=False;
        DBEdit_Dept.ReadOnly:=False;
        DBEdit_Helth.ReadOnly:=False;
        DBEdit_Home.ReadOnly:=False;
        DBEdit_LOcalAge.ReadOnly:=False;
        DBEdit_Marrage.ReadOnly:=False;
        DBEdit_No.ReadOnly:=False;
        DBEdit_Party.ReadOnly:=False;
        DBEdit_Policy.ReadOnly:=False;
        DBEdit_Race.ReadOnly:=False;
        DBEdit_WorkShop.ReadOnly:=False;
        DBEdit_Level.ReadOnly:=False;
        DBEdit_SumWorkAge.ReadOnly:=False;
        DBEdit_Work.ReadOnly:=False;
        DBEdit_Major.ReadOnly:=False;
end;

procedure TForm1.ToolButton1Click(Sender: TObject);
begin
    with DM do
    begin
        if not Table_basic.Bof then
        begin
            Table_basic.Prior;
        end;
    end;
    Chart1.Series[0].Clear;
end;

procedure TForm1.ToolButton2Click(Sender: TObject);
begin
   with DM do
    begin
        if not Table_basic.Eof then
        begin
            Table_basic.Next;
        end;
    end;
    Chart1.Series[0].Clear;
end;

procedure TForm1.ToolButton3Click(Sender: TObject);
begin
    with DM do
    begin
    Table_basic.First;
    end;
    Chart1.Series[0].Clear;
end;

procedure TForm1.ToolButton4Click(Sender: TObject);
begin
     with DM do
    begin
    Table_basic.Last;
    end;
     Chart1.Series[0].Clear;
end;

procedure TForm1.BitBtn1Click(Sender: TObject);
var
str:string;
begin
    with DM do
    begin
        str:=Table_basic.FieldValues['职工号'];
        Table_salary2.Active:=True;
        if  not Table_salary2.Locate('职工号',str,[loCaseInsensitive]) then
        begin
        ShowMessage('没有数据可被图示！');
        exit;
        end;
    end;

    with Chart1 do
        begin
        with DM do
            begin
            Series1.Clear ;
	        Series1.Add(Trunc(Table_salary.FieldValues['基本工资']),'基本工资',clBlue );
            Series1.Add(Trunc(Table_salary.FieldValues['药费']),'药费',clRed );
            Series1.Add(Trunc(Table_salary.FieldValues['特殊津贴']),'特殊津贴',clYellow );
            Series1.Add(Trunc(Table_salary.FieldValues['奖金']),'奖金',clGreen );
            end;
        end;

end;

procedure TForm1.ToolButton5Click(Sender: TObject);
begin
    NewRecord:=True;
    BitBtn_sub.Enabled:=True;
    BitBtn_exit.Enabled:=True;
    with DM do
    begin
        Table_basic.Append;
    end;
    Set_NotReadOnly;

end;

procedure TForm1.DBEdit_SexClick(Sender: TObject);
begin
    if NewRecord then
    begin
        Form_sex.Show;
    end;
    if ModifyRecord then
    begin
        if DBEdit_Sex.EditText='男' then Form_sex.RadioGroup1.ItemIndex:=0
        else Form_sex.RadioGroup1.ItemIndex:=1;
        Form_sex.Show;
    end;
end;

procedure TForm1.DBEdit_BirthClick(Sender: TObject);
begin
    if NewRecord then
    begin
        Form_Date.Show;
    end;
    if ModifyRecord then
    begin
        with DM do
        begin
        Form_Date.MC_birth.Date:=Table_basic.FieldValues['出生日期'];
        Form_Date.MC_party.Date:=Table_basic.FieldValues['参加党派时间'];
        Form_Date.MC_work.Date:=Table_basic.FieldValues['参加工作时间'];
        Form_Date.MC_Enter.Date:=Table_basic.FieldValues['进入本单位的日期'];
        end;
        Form_Date.Show;
    end;
end;


procedure TForm1.BitBtn_subClick(Sender: TObject);
begin
    if DBEdit_No.Text='' then
    begin
    ShowMessage('输入非法');
    exit;
    end;
    if DBEdit_Name.Text='' then
    begin
    ShowMessage('输入非法');
    exit;
    end;

    DBEdit_birth.Field.AsDateTime:=Form_Date.MC_birth.Date;
    DBEdit_PartyTime.Field.AsDateTime:=Form_Date.MC_Party.Date;
    DBEdit_EnterTime.Field.AsDateTime:=Form_Date.MC_Enter.Date;
    DBEdit_WorkTime.Field.AsDateTime:=Form_Date.MC_Work.Date;

    if Form_sex.RadioGroup1.ItemIndex=0 then
    DBEdit_sex.Field.AsString:='男'
    else
    DBEdit_sex.Field.AsString:='女';

    Set_ReadOnly;

    DM.Table_basic.Post;
    NewRecord:=False;
    ModifyRecord:=False;
    BitBtn_sub.Enabled:=False;
    BitBtn_exit.Enabled:=False;
end;

procedure TForm1.BitBtn_exitClick(Sender: TObject);
begin
    with DM do
    begin
        Table_basic.Cancel;
        Table_basic.First;
    end;

    Set_ReadOnly;

    NewRecord:=False;
    ModifyRecord:=False;
    BitBtn_sub.Enabled:=False;
    BitBtn_exit.Enabled:=False;
end;

procedure TForm1.Button_exp_addClick(Sender: TObject);
begin
   Form_exp.Edit_co.Text:='';
   Form_exp.Edit_dept.Text:='';
   Form_exp.Edit_res.Text:='';
   Form_exp.Edit_lev.Text:='';
   Form_exp.Edit_work.Text:='';
   Form_exp.Edit_job.Text:='';
   Form_exp.Show;
end;


procedure TForm1.Button_car_addClick(Sender: TObject);
begin
    Form_car.Edit_Major.Text:='';
    Form_car.Edit_School.Text:='';
    Form_car.ListBox_d.ItemIndex:=0;
    Form_car.ListBox_c.ItemIndex:=0;
    Form_car.ListBox_r.ItemIndex:=0;
    Form_car.Show;
end;

procedure TForm1.Button_relation_addClick(Sender: TObject);
begin
    Form_relation.Edit_Name.Text:='';
    Form_relation.Edit_Call.Text:='';