onmessa.pas

直接可以编译运行

unit onmessa;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Mask, DBCtrls, DB, Grids, DBGrids, ADODB, Menus,
  ComCtrls;

type
  Tonmessa1 = class(TForm)
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    TabSheet3: TTabSheet;
    ADOTable1: TADOTable;
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    DBGrid3: TDBGrid;
    DBGrid2: TDBGrid;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    DBEdit5: TDBEdit;
    DBEdit6: TDBEdit;
    DBEdit7: TDBEdit;
    DBEdit8: TDBEdit;
    Label1: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label2: TLabel;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    DBText1: TDBText;
    Label10: TLabel;
    DBMemo1: TDBMemo;
    Button4: TButton;
    Button5: TButton;
    Label12: TLabel;
    Label13: TLabel;
    Label14: TLabel;
    Label15: TLabel;
    Label16: TLabel;
    Label17: TLabel;
    Label18: TLabel;
    Label19: TLabel;
    Label20: TLabel;
    Label21: TLabel;
    Label11: TLabel;
    DBText2: TDBText;
    DBEdit1: TDBEdit;
    DBEdit10: TDBEdit;
    DBEdit11: TDBEdit;
    DBEdit12: TDBEdit;
    DBEdit13: TDBEdit;
    DBEdit14: TDBEdit;
    DBEdit15: TDBEdit;
    DBEdit16: TDBEdit;
    DBEdit17: TDBEdit;
    DBMemo2: TDBMemo;
    Button6: TButton;
    Button7: TButton;
    Button8: TButton;
    Button9: TButton;
    Label22: TLabel;
    ADOQuery1: TADOQuery;
    DataSource2: TDataSource;
    DBLookupComboBox1: TDBLookupComboBox;
    Label23: TLabel;
    Label24: TLabel;
    Label25: TLabel;
    Label26: TLabel;
    Label27: TLabel;
    Label28: TLabel;
    Label29: TLabel;
    Label30: TLabel;
    Label31: TLabel;
    Label32: TLabel;
    Label33: TLabel;
    Label34: TLabel;
    DBText3: TDBText;
    DBEdit9: TDBEdit;
    DBEdit18: TDBEdit;
    DBEdit19: TDBEdit;
    DBEdit20: TDBEdit;
    DBEdit21: TDBEdit;
    DBEdit22: TDBEdit;
    DBMemo3: TDBMemo;
    Button10: TButton;
    Button11: TButton;
    Button12: TButton;
    Button13: TButton;
    DBEdit24: TDBEdit;
    DBEdit25: TDBEdit;
    DBEdit23: TDBEdit;
    DBEdit26: TDBEdit;
    DBEdit27: TDBEdit;
    Button14: TButton;
    procedure Button1Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
    procedure Button7Click(Sender: TObject);
    procedure Button8Click(Sender: TObject);
    procedure Button9Click(Sender: TObject);
    procedure Button11Click(Sender: TObject);
    procedure Button12Click(Sender: TObject);
    procedure Button13Click(Sender: TObject);
    procedure Button10Click(Sender: TObject);
    procedure Button14Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  onmessa1: Tonmessa1;

implementation

{$R *.dfm}

procedure Tonmessa1.Button1Click(Sender: TObject);
begin
ADOTable1.Open;
ADOTable1.Append;
DBEdit2.SetFocus;


end;

procedure Tonmessa1.Button3Click(Sender: TObject);
begin
if (DBEdit2.Text='') or (DBEdit3.Text='') or
 (DBEdit4.Text='') or (DBEdit7.Text='') then
ShowMessage('绿色项不能为空!')
else
begin
ADOTable1.Open;
ADOTable1.FieldByName('yonghu').AsString:=DBEdit2.Text;
ADOTable1.FieldByName('quhao').AsString:=DBEdit3.Text;
ADOTable1.FieldByName('dianhua').AsString:=DBEdit4.Text;
ADOTable1.FieldByName('dizhi').AsString:=DBEdit5.Text;
ADOTable1.FieldByName('weixiuwu').AsString:=DBEdit7.Text;
if DBEdit8.Text='' then
ADOTable1.FieldByName('chulixinxi').AsString:='等待中';
ADOTable1.FieldByName('name').AsString:=DBLookupComboBox1.Text;
ADOTable1.FieldByName('beizhu').AsString:=DBMemo1.Text;
ADOTable1.Post;

end;
DBEdit2.SetFocus;
end;

procedure Tonmessa1.Button2Click(Sender: TObject);
begin
ADOTable1.Open;
ADOTable1.Edit;
DBEdit2.SetFocus;
end;

procedure Tonmessa1.Button4Click(Sender: TObject);
begin
ADOTable1.Next;
end;

procedure Tonmessa1.Button5Click(Sender: TObject);
begin
ADOTable1.Prior;
end;

procedure Tonmessa1.Button6Click(Sender: TObject);
begin
ADOTable1.Open;
ADOTable1.Edit;
ADOTable1.FieldByName('chulixinxi').AsString:='维修中';
ADOTable1.FieldByName('name').AsString:=DBEdit23.Text;
ADOTable1.FieldByName('beizhu').AsString:=DBMemo2.Text;
ADOTable1.Post;

end;

procedure Tonmessa1.Button7Click(Sender: TObject);
var
num1:Integer;
begin
ADOTable1.Open;
ADOTable1.Edit;
ADOTable1.FieldByName('chulixinxi').AsString:='已完成';
ADOTable1.FieldByName('name').AsString:=DBEdit16.Text;
ADOTable1.FieldByName('endtime').AsString:=DateTimeToStr(now);
ADOTable1.FieldByName('beizhu').AsString:=DBMemo2.Text;
ADOTable1.FieldByName('money').AsString:=DBEdit17.Text;
ADOTable1.Post;

end;

procedure Tonmessa1.Button8Click(Sender: TObject);
begin
ADOTable1.Next;
end;

procedure Tonmessa1.Button9Click(Sender: TObject);
begin
ADOTable1.Prior;
end;

procedure Tonmessa1.Button11Click(Sender: TObject);
begin
ADOTable1.Delete;
end;

procedure Tonmessa1.Button12Click(Sender: TObject);
begin
ADOTable1.Next;
end;

procedure Tonmessa1.Button13Click(Sender: TObject);
begin
ADOTable1.Prior;
end;

procedure Tonmessa1.Button10Click(Sender: TObject);
begin
ADOTable1.Open;
ADOTable1.Edit;
ADOTable1.FieldByName('yonghu').AsString:=DBEdit9.Text;
ADOTable1.FieldByName('quhao').AsString:=DBEdit18.Text;
ADOTable1.FieldByName('dianhua').AsString:=DBEdit19.Text;
ADOTable1.FieldByName('dizhi').AsString:=DBEdit20.Text;
ADOTable1.FieldByName('time').AsString:=DBEdit21.Text;
ADOTable1.FieldByName('weixiuwu').AsString:=DBEdit22.Text;
ADOTable1.FieldByName('chulixinxi').AsString:=DBEdit24.Text;
ADOTable1.FieldByName('name').AsString:=DBEdit25.Text;
ADOTable1.FieldByName('endtime').AsString:=DBEdit26.Text;
ADOTable1.FieldByName('money').AsString:=DBEdit27.Text;
ADOTable1.FieldByName('beizhu').AsString:=DBMemo3.Text;
ADOTable1.Post;

end;

procedure Tonmessa1.Button14Click(Sender: TObject);
begin
ADOTable1.Open;
ADOTable1.Edit;
ADOTable1.FieldByName('chulixinxi').AsString:='已出库';
ADOTable1.Post;
end;

end.