repairout.pas

信息管理系统

unit repairout;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DB, ADODB, StdCtrls, Grids, DBGrids,repairinfo_unit, ComCtrls,
  ExtCtrls, DBClient;

type
  Trepairoutfrm = class(TForm)
    Button1: TButton;
    DBGrid1: TDBGrid;
    DataSource1: TDataSource;
    ClientDataSet1: TClientDataSet;
    Panel1: TPanel;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label10: TLabel;
    Edit5: TEdit;
    Edit4: TEdit;
    Edit6: TEdit;
    Edit7: TEdit;
    Panel2: TPanel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    DateTimePicker1: TDateTimePicker;
    Edit3: TEdit;
    DateTimePicker2: TDateTimePicker;
    Memo1: TMemo;
    Button3: TButton;
    procedure Button3Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure DBGrid1CellClick(Column: TColumn);
  private
   repair_info:Trepair_info       ;
    { Private declarations }
  public
    { Public declarations }
  end;

var
  repairoutfrm: Trepairoutfrm;

implementation
 uses accidentout, repair;
{$R *.dfm}

procedure Trepairoutfrm.Button3Click(Sender: TObject);
begin
//实例化类
  repair_info:=Trepair_info.create ;
  if repair_info.CheckRec(edit4.text)=false  then      //如果找不到对应的记录,提示用户出错
  begin
   showmessage('对不起，该车辆维修记录不存在！');
   exit;
  end;
edit1.Text :=repair_info.GetRepairType(edit4.Text);
edit5.Text :=repair_info.GetVehicleId(edit4.Text);
edit2.Text :=repair_info.GetRepairFactory(edit4.Text);
edit3.Text :=repair_info.GetPart(edit4.Text) ;
edit6.Text :=repair_info.GetDRIVERID(edit4.Text) ;
edit7.Text :=repair_info.GetVEHICLENO(edit4.Text) ;
datetimepicker1.DateTime:=strtodate(repair_info.GetEntryTime(edit4.Text) ) ;
datetimepicker1.DateTime:=strtodate(repair_info.GetEntryTime(edit4.Text) ) ;
memo1.Text:=repair_info.GetRepairContent(edit4.Text);
//释放类的实例
repair_info.Free;
end;

procedure Trepairoutfrm.Button1Click(Sender: TObject);
var sql:string;
begin
//实例化类
  repair_info:=Trepair_info.create ;
  //赋值查询语句
  sql:='select	VEHICLE_NO	车辆编号,'
+'ARCHIVES_ID	档案编号, '
+'VEHICLE_ID	车牌号 ,'
+'DRIVER_ID		司机编号 ,'
+'REPAIR_TYPE		维修类别,'
+'REPAIR_FACTORY		修理厂 ,'
+'PART		更换零部件    ,'
+'REPAIR_CONTENT		修理内容,'
+'ENTRY_TIME		进场日期  ,'
+'EXIT_TIME		出场日期      FROM repair_info';
//执行查询方法并用列表显示出来
clientdataset1.data:=repair_info.AllRec(sql);
//释放实例
repair_info.Free;
end;

procedure Trepairoutfrm.DBGrid1CellClick(Column: TColumn);
begin
//实例化类
  repair_info:=Trepair_info.create ;
  edit4.text:=DBGrid1.Fields[1].AsString ;
  if repair_info.CheckRec(edit4.text)  then      //如果找不到对应的记录,提示用户出错
  begin
   showmessage('对不起，该车辆维修记录不存在！');
   exit;
  end;
edit1.Text :=repair_info.GetRepairType(edit4.Text);
edit5.Text :=repair_info.GetVehicleId(edit4.Text);
edit2.Text :=repair_info.GetRepairFactory(edit4.Text);
edit3.Text :=repair_info.GetPart(edit4.Text) ;
edit6.Text :=repair_info.GetDRIVERID(edit4.Text) ;
edit7.Text :=repair_info.GetVEHICLENO(edit4.Text) ;
datetimepicker1.DateTime:=strtodate(repair_info.GetEntryTime(edit4.Text) ) ;
datetimepicker1.DateTime:=strtodate(repair_info.GetEntryTime(edit4.Text) ) ;
memo1.Text:=repair_info.GetRepairContent(edit4.Text);
//释放类的实例
repair_info.Free;
end;

end.