usjjbxx.pas

明日科技的《Delphi数据库开发案例精选》中的资源管理系统源代码。界面美观

unit USJJBXX;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, ExtCtrls, Buttons, ToolWin, ComCtrls, Grids, DBGrids;

type
  TFRM_SJJBXX = class(TForm)
    ToolBar1: TToolBar;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    SpeedButton3: TSpeedButton;
    SpeedButton4: TSpeedButton;
    SpeedButton5: TSpeedButton;
    SpeedButton6: TSpeedButton;
    Panel1: TPanel;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    Label13: TLabel;
    Label14: TLabel;
    Label15: TLabel;
    Label16: TLabel;
    Label17: TLabel;
    Label18: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    ComboBox1: TComboBox;
    DateTimePicker1: TDateTimePicker;
    Edit3: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    Edit6: TEdit;
    Edit7: TEdit;
    DateTimePicker2: TDateTimePicker;
    Edit8: TEdit;
    Edit9: TEdit;
    Edit10: TEdit;
    Edit11: TEdit;
    Edit12: TEdit;
    Edit13: TEdit;
    Edit14: TEdit;
    Edit15: TEdit;
    Panel2: TPanel;
    DBGrid1: TDBGrid;
    procedure SpeedButton6Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure SpeedButton3Click(Sender: TObject);
    procedure SpeedButton4Click(Sender: TObject);
    procedure SpeedButton5Click(Sender: TObject);
    procedure Edit1KeyPress(Sender: TObject; var Key: Char);
    procedure Edit2Change(Sender: TObject);
    procedure Edit3Change(Sender: TObject);
    procedure Edit4Change(Sender: TObject);
    procedure Edit5Change(Sender: TObject);
    procedure Edit6Change(Sender: TObject);
    procedure Edit7Change(Sender: TObject);
    procedure Edit8Change(Sender: TObject);
    procedure Edit9Change(Sender: TObject);
    procedure Edit10Change(Sender: TObject);
    procedure Edit11Change(Sender: TObject);
    procedure Edit12Change(Sender: TObject);
    procedure Edit13Change(Sender: TObject);
    procedure Edit14Change(Sender: TObject);
    procedure Edit15Change(Sender: TObject);
    procedure Edit2KeyPress(Sender: TObject; var Key: Char);
    procedure ComboBox1KeyPress(Sender: TObject; var Key: Char);
    procedure DateTimePicker1KeyPress(Sender: TObject; var Key: Char);
    procedure Edit3KeyPress(Sender: TObject; var Key: Char);
    procedure Edit4KeyPress(Sender: TObject; var Key: Char);
    procedure Edit5KeyPress(Sender: TObject; var Key: Char);
    procedure Edit6KeyPress(Sender: TObject; var Key: Char);
    procedure Edit7KeyPress(Sender: TObject; var Key: Char);
    procedure Edit8KeyPress(Sender: TObject; var Key: Char);
    procedure Edit9KeyPress(Sender: TObject; var Key: Char);
    procedure Edit10KeyPress(Sender: TObject; var Key: Char);
    procedure Edit11KeyPress(Sender: TObject; var Key: Char);
    procedure Edit12KeyPress(Sender: TObject; var Key: Char);
    procedure Edit13KeyPress(Sender: TObject; var Key: Char);
    procedure Edit14KeyPress(Sender: TObject; var Key: Char);
    procedure DateTimePicker2KeyPress(Sender: TObject; var Key: Char);
    procedure DBGrid1CellClick(Column: TColumn);
    procedure DBGrid1DrawColumnCell(Sender: TObject; const Rect: TRect;
      DataCol: Integer; Column: TColumn; State: TGridDrawState);
    procedure ComboBox1KeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
  private
    { Private declarations }
  public
    procedure tr;       //去除空字符
    procedure bh;        //自动编号
    Procedure GetAll;    //获得所有数据
    Procedure Posting;   //提交数据
    Procedure CLS;       //清除控件中内容
    Procedure DIS;       //控件不可用
    Procedure ENA;       //控件可用
    Function CanSave:Boolean;   //判断是否保存
    { Public declarations }
  end;

var
  FRM_SJJBXX: TFRM_SJJBXX;

implementation

uses UDM, UMAIN, UKHJBXX;

{$R *.dfm}
procedure TFRM_SJJBXX.tr;
var
i:integer;
begin
  for i:=ComponentCount - 1 downto 0 do
    if(Components[i] is TEdit) then
    TEdit(Components[i]).Text:=trim(TEdit(Components[i]).Text);
end;
Function TFRM_SJJBXX.CanSave: Boolean;
begin
  if (Edit1.Text='') then
  begin
   Result:=False;
   Application.MessageBox('司机编号不能为空！','提示信息',0+MB_ICONINFORMATION);
   exit;
  end;
  if (Edit2.Text='') then
  begin
    Result:=False;
    Application.MessageBox('司机姓名不能为空！','提示信息',0+MB_ICONINFORMATION);
    exit;
  end;
  if (ComboBox1.Text='') then
  begin
    Result:=False;
    Application.MessageBox('司机性别不能为空！','提示信息',0+MB_ICONINFORMATION);
    exit;
  end;
  if (Edit3.Text='') then
  begin
    Result:=False;
    Application.MessageBox('学历不能为空！','提示信息',0+MB_ICONINFORMATION);
    exit;
  end;
  if (Edit4.Text='') then
  begin
    Result:=False;
    Application.MessageBox('驾证类型不能为空！','提示信息',0+MB_ICONINFORMATION);
    exit;
  end;
  if (Edit5.Text='') then
  begin
    Result:=False;
    Application.MessageBox('驾照号码不能为空！','提示信息',0+MB_ICONINFORMATION);
    exit;
  end;
  if (Edit6.Text='') then
  begin
    Result:=False;
    Application.MessageBox('身份证号不能为空！','提示信息',0+MB_ICONINFORMATION);
    exit;
  end;
  if (Edit7.Text='') then
  begin
    Result:=False;
    Application.MessageBox('经营路线不能为空！','提示信息',0+MB_ICONINFORMATION);
    exit;
  end;
  if (Edit8.Text='') then
  begin
    Result:=False;
    Application.MessageBox('收费情况不能为空！','提示信息',0+MB_ICONINFORMATION);
    exit;
  end;
  if (Edit9.Text='') then
  begin
    Result:=False;
    Application.MessageBox('车辆号码不能为空！','提示信息',0+MB_ICONINFORMATION);
    exit;
  end;
  if (Edit10.Text='') then
  begin
    Result:=False;
    Application.MessageBox('联系电话不能为空！','提示信息',0+MB_ICONINFORMATION);
    exit;
  end;
  if (Edit11.Text='') then
  begin
    Result:=False;
    Application.MessageBox('电子邮件不能为空！','提示信息',0+MB_ICONINFORMATION);
    exit;
  end;
  if (Edit12.Text='') then
  begin
    Result:=False;
    Application.MessageBox('手机号码不能为空！','提示信息',0+MB_ICONINFORMATION);
    exit;
  end;
  if (Edit13.Text='') then
  begin
    Result:=False;
    Application.MessageBox('信誉情况不能为空！','提示信息',0+MB_ICONINFORMATION);
    exit;
  end;
  if (Edit14.Text='') then
  begin
    Result:=False;
    Application.MessageBox('司机地址不能为空！','提示信息',0+MB_ICONINFORMATION);
    exit;
  end;
end;

procedure TFRM_SJJBXX.bh;
var
i:integer;
s,m:string;
begin
  s:= 'SJ'+ FormatDateTime('yyyymmdd',Now());
  With DM.QSJJBXX do
  begin
    Close;
    SQL.Clear;
    SQL.Add('select max(司机编号) as ss From 司机信息表');
    Open;
  end;
  If DM.QSJJBXX.FieldByName('ss').Value=null then
    s := s + '001'
  else
  begin
    m:= Trim(DM.QSJJBXX.FieldByName('ss').Value) ;
    i:= StrToInt(Trim(Copy(m,11,8))) ;
    s:= s +Formatfloat('000',i+1);
  end;
  Edit1.Text := s;
end;

procedure TFRM_SJJBXX.GetAll;
begin
  Edit1.Text:=DM.DSOSJJBXX.FieldByName('司机编号').AsString;
  Edit2.Text:=DM.DSOSJJBXX.FieldByName('司机姓名').AsString;
  ComboBox1.Text:=DM.DSOSJJBXX.FieldByName('司机性别').AsString;
  DateTimePicker1.Date:=DM.DSOSJJBXX.FieldByName('出生日期').AsDateTime;
  Edit3.Text:=DM.DSOSJJBXX.FieldByName('学历').AsString;
  Edit4.Text:=DM.DSOSJJBXX.FieldByName('驾证类型').AsString;
  Edit5.Text:=DM.DSOSJJBXX.FieldByName('驾照号码').AsString;
  Edit6.Text:=DM.DSOSJJBXX.FieldByName('身份证号').AsString;
  Edit7.Text:=DM.DSOSJJBXX.FieldByName('经营路线').AsString;
  DateTimePicker2.Date:=DM.DSOSJJBXX.FieldByName('合作日期').AsDateTime;
  Edit8.Text:=DM.DSOSJJBXX.FieldByName('收费情况').AsString;
  Edit9.Text:=DM.DSOSJJBXX.FieldByName('车牌号码').AsString;
  Edit10.Text:=DM.DSOSJJBXX.FieldByName('联系电话').AsString;
  Edit11.Text:=DM.DSOSJJBXX.FieldByName('电子邮件').AsString;
  Edit12.Text:=DM.DSOSJJBXX.FieldByName('手机号码').AsString;
  Edit13.Text:=DM.DSOSJJBXX.FieldByName('信誉情况').AsString;
  Edit14.Text:=DM.DSOSJJBXX.FieldByName('司机地址').AsString;
  Edit15.Text:=DM.DSOSJJBXX.FieldByName('备注').AsString;
end;
procedure TFRM_SJJBXX.Posting;
begin
  if ActionCD='N' then
  BEGIN
    with DM.QSJJBXX do
    begin
      Close;
      SQL.Clear;
      SQL.Add('INSERT INTO 司机信息表(司机编号,司机姓名,司机性别,出生日期,学历,驾证类型,');
      SQL.Add('驾照号码,身份证号,经营路线,合作日期,收费情况,车牌号码,联系电话,电子邮件,手机号码,');
      SQL.Add('信誉情况,司机地址,备注)');
      SQL.Add('Values(:司机编号,:司机姓名,:司机性别,:出生日期,:学历,:驾证类型,');
      SQL.Add(':驾照号码,:身份证号,:经营路线,:合作日期,:收费情况,:车牌号码,:联系电话,:电子邮件,:手机号码,');
      SQL.Add(':信誉情况,:司机地址,:备注)');
      Parameters.Items[0].Value:=Edit1.Text;
      Parameters.Items[1].Value:=Edit2.Text;
      Parameters.Items[2].Value:=ComboBox1.Text;
      DateTimePicker1.Date:=Date();
      Parameters.Items[3].Value:=FormatDateTime('yyyy-mm-dd',DateTimePicker1.Date);
      Parameters.Items[4].Value:=Edit3.Text;
      Parameters.Items[5].Value:=Edit4.Text;
      Parameters.Items[6].Value:=Edit5.Text;
      Parameters.Items[7].Value:=Edit6.Text;
      Parameters.Items[8].Value:=Edit7.Text;
      DateTimePicker2.Date:=Date();
      Parameters.Items[9].Value:=FormatDateTime('yyyy-mm-dd',DateTimePicker2.Date);
      Parameters.Items[10].Value:=Edit8.Text;
      Parameters.Items[11].Value:=Edit9.Text;
      Parameters.Items[12].Value:=Edit10.Text;
      Parameters.Items[13].Value:=Edit11.Text;
      Parameters.Items[14].Value:=Edit12.Text;
      Parameters.Items[15].Value:=Edit13.Text;
      Parameters.Items[16].Value:=Edit14.Text;
      Parameters.Items[17].Value:=Edit15.Text;
      Prepared:=True;
      ExecSQL;
    end;
  END else
  if ActionCD='M' then
  begin
    With DM.QSJJBXX DO
    begin
      Close;
      SQL.Clear;
      SQL.Add('update 司机信息表 Set 司机姓名=:司机姓名1,司机性别=:司机性别1,出生日期=:出生日期1,');
      SQL.Add('学历=:学历1,驾证类型=:驾证类型1,驾照号码=:驾照号码1,身份证号=:身份证号1,');
      SQL.Add('经营路线=:经营路线1,合作日期=:合作日期1,收费情况=:收费情况1,车牌号码=:车牌号码1,');
      SQL.Add('联系电话=:联系电话1,电子邮件=:电子邮件1,手机号码=:手机号码1,信誉情况=:信誉情况1,');
      SQL.Add('司机地址=:司机地址1,备注=:备注1 where 司机编号=:司机编号1');
      Parameters.Items[0].Value:=Edit2.Text;
      Parameters.Items[1].Value:=ComboBox1.Text;
      DateTimePicker1.Date:=Date();
      Parameters.Items[2].Value:=FormatDateTime('yyyy-mm-dd',DateTimePicker1.Date);
      Parameters.Items[3].Value:=Edit3.Text;
      Parameters.Items[4].Value:=Edit4.Text;
      Parameters.Items[5].Value:=Edit5.Text;
      Parameters.Items[6].Value:=Edit6.Text;
      Parameters.Items[7].Value:=Edit7.Text;
      DateTimePicker2.Date:=Date();
      Parameters.Items[8].Value:=FormatDateTime('yyyy-mm-dd',DateTimePicker2.Date);
      Parameters.Items[9].Value:=Edit8.Text;
      Parameters.Items[10].Value:=Edit9.Text;
      Parameters.Items[11].Value:=Edit10.Text;
      Parameters.Items[12].Value:=Edit11.Text;
      Parameters.Items[13].Value:=Edit12.Text;
      Parameters.Items[14].Value:=Edit13.Text;
      Parameters.Items[15].Value:=Edit14.Text;
      Parameters.Items[16].Value:=Edit15.Text;
      Parameters.Items[17].Value:=DM.DSOSJJBXX.FieldByName('司机编号').AsString;
      Prepared:=true;
      ExecSQL;
    end;
  end;
end;
procedure TFRM_SJJBXX.ENA;
var
  i:integer;
begin
  for i:=ComponentCount-1 downto 0 do