uwxxx_ed.pas

来自「很好的汽车管理系统 很实用的 谢谢合作」· PAS 代码 · 共 713 行 · 第 1/2 页

unit UWXXX_ED;

interface

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

type
  TWXXX_ED = class(TForm)
    Panel1: TPanel;
    Panel2: TPanel;
    GroupBox3: TGroupBox;
    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;
    Label19: TLabel;
    Edit1: TEdit;
    Edit3: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    Edit6: TEdit;
    Edit7: TEdit;
    Edit8: TEdit;
    Edit10: TEdit;
    Edit11: TEdit;
    Edit13: TEdit;
    Memo1: TMemo;
    DateTimePicker1: TDateTimePicker;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    SpeedButton3: TSpeedButton;
    SpeedButton4: TSpeedButton;
    SpeedButton5: TSpeedButton;
    Edit9: TEdit;
    DateTimePicker2: TDateTimePicker;
    ComboBox1: TComboBox;
    ComboBox2: TComboBox;
    procedure SpeedButton5Click(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 Edit4Change(Sender: TObject);
    procedure Edit5Change(Sender: TObject);
    procedure Edit6Change(Sender: TObject);
    procedure Edit7Change(Sender: TObject);
    procedure Edit10Change(Sender: TObject);
    procedure Edit11Change(Sender: TObject);
    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 Edit10KeyPress(Sender: TObject; var Key: Char);
    procedure Edit11KeyPress(Sender: TObject; var Key: Char);
    procedure DateTimePicker1KeyPress(Sender: TObject; var Key: Char);
    procedure DateTimePicker2KeyPress(Sender: TObject; var Key: Char);
    procedure Edit5Exit(Sender: TObject);
    procedure Edit6Exit(Sender: TObject);
    procedure Edit4Exit(Sender: TObject);
    procedure ComboBox1DropDown(Sender: TObject);
    procedure ComboBox1Change(Sender: TObject);
    procedure DateTimePicker1Change(Sender: TObject);
    procedure DateTimePicker2Change(Sender: TObject);
    procedure ComboBox1KeyPress(Sender: TObject; var Key: Char);
    procedure ComboBox2DropDown(Sender: TObject);
    procedure ComboBox2KeyPress(Sender: TObject; var Key: Char);
    procedure ComboBox2Change(Sender: TObject);
  private
    { Private declarations }
  public
    procedure BH;
    function cansave:boolean;
    procedure GetAll;
    procedure Posting;
    procedure ENA;
    procedure DIS;
    procedure CLS;
    procedure tr;
    { Public declarations }
  end;

var
  WXXX_ED: TWXXX_ED;

implementation

uses UMain, UDM, UWXXX;

{$R *.dfm}

procedure TWXXX_ED.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;
procedure TWXXX_ED.BH;
var
  s,m:string;
begin
  with DM.QWXXX do
  begin
    Close;
    SQL.Clear;
    SQL.Add('Select max(bh) as 编号 From WXXX');
    Open;
  end;
  if DM.ADODSWXXX.FieldByName('bh').Value=null then
    s:=s+'1'
  else
  begin
    DM.ADODSWXXX.Last;
    m:=Trim(DM.ADODSWXXX.Fieldbyname('bh').Value);
    s:=inttostr(strtoint(m)+1);
  end;
  edit1.Text:=s;
end;

function TWXXX_ED.CanSave: Boolean;
begin
  if (Edit1.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 (ComboBox2.Text='') then
  begin
    Result:=False;
    Application.MessageBox('修配厂不能为空！','提示信息',0+MB_ICONINFORMATION);
    exit;
  end;
end;

procedure TWXXX_ED.GetAll;
begin
    Edit1.Text:=DM.ADODSWXXX.FieldByName('bh').AsString;
    ComboBox1.Text:=DM.ADODSWXXX.FieldByName('cph').AsString;
    Edit3.Text:=DM.ADODSWXXX.FieldByName('clmc').AsString;
    Edit4.Text:=DM.ADODSWXXX.FieldByName('clf').AsString;
    Edit5.Text:=DM.ADODSWXXX.fieldByName('rgf').AsString;
    Edit6.Text:=DM.ADODSWXXX.FieldByName('qtfy').AsString;
    Edit7.Text:=DM.ADODSWXXX.FieldByName('zfy').AsString;
    Edit8.Text:=DM.ADODSWXXX.FieldByName('wxrq').AsString;
    Edit9.Text:=DM.ADODSWXXX.FieldByName('djsj').AsString;
    Edit10.Text:=DM.ADODSWXXX.FieldByName('jsr').AsString;
    Edit11.Text:=DM.ADODSWXXX.FieldByName('wxnr').AsString;
    ComboBox2.Text:=DM.ADODSWXXX.FieldByName('xpc').AsString;
    Edit13.Text:=DM.ADODSWXXX.FieldByName('dz').AsString;
    Memo1.Text:=DM.ADODSWXXX.FieldByName('bz').AsString;
end;

procedure TWXXX_ED.Posting;
begin
  if ActionCD='N' then
  BEGIN
  with DM.QWXXX do
  begin
    Close;
    SQL.Clear;
    SQL.Add('INSERT INTO WXXX(cph,clmc,clf,rgf,qtfy,zfy,wxrq,djsj,jsr,wxnr,xpc,dz,bz,bh)');
    SQL.Add('Values(:车牌号,:车辆名称,:材料费,:人工费,:其它费用,:总费用,:维修日期,:登记日期,:经手人,:维修内容,:修配厂,:地址,:备注,:编号)');
    Parameters.Items[0].Value:=ComboBox1.Text;
    Parameters.Items[1].Value:=Edit3.Text;
    Parameters.Items[2].Value:=Edit4.Text;
    Parameters.Items[3].Value:=Edit5.Text;
    Parameters.Items[4].Value:=Edit6.Text;
    Parameters.Items[5].Value:=Edit7.Text;
    Parameters.Items[6].Value:=Edit8.Text;
    Parameters.Items[7].Value:=Edit9.Text;
    Parameters.Items[8].Value:=Edit10.Text;
    Parameters.Items[9].Value:=Edit11.Text;
    Parameters.Items[10].Value:=ComboBox2.Text;
    Parameters.Items[11].Value:=Edit13.Text;
    Parameters.Items[12].Value:=Memo1.Text;
    Parameters.Items[13].Value:=Edit1.Text;
    Prepared:=True;
    ExecSQL;
  end;
  END else
  if ActionCD='M' then
  begin
    With DM.QWXXX DO
    begin
      Close;
      SQL.Clear;
      SQL.Add('update WXXX Set cph=:车牌号,');
      SQL.Add('clmc=:车辆名称,clf=:材料费,rgf=:人工费,qtfy=:其它费用,');   //bh=:,   id
      SQL.Add('zfy=:总费用,wxrq=:维修日期,djsj=:登记时间,jsr=:经手人,');
      SQL.Add('wxnr=:维修内容,xpc=:修配厂,dz=:地址,');
      SQL.Add('bz=:备注 Where bh=:编号');
      Parameters.Items[0].Value:=ComboBox1.Text;
      Parameters.Items[1].Value:=Edit3.Text;
      Parameters.Items[2].Value:=Edit4.Text;
      Parameters.Items[3].Value:=Edit5.Text;
      Parameters.Items[4].Value:=Edit6.Text;
      Parameters.Items[5].Value:=Edit7.Text;
      Parameters.Items[6].Value:=Edit8.Text;
      Parameters.Items[7].Value:=Edit8.Text;
      Parameters.Items[8].Value:=Edit10.Text;
      Parameters.Items[9].Value:=Edit11.Text;
      Parameters.Items[10].Value:=ComboBox2.Text;
      Parameters.Items[11].Value:=Edit13.Text;
      Parameters.Items[12].Value:=Memo1.Text;
      Parameters.Items[13].Value:=DM.ADODSWXXX.FieldByName('bh').AsString;
      Prepared:=true;
      ExecSQL;
    end;
  end;
end;

procedure TWXXX_ED.ENA;
var
  i:integer;
begin
  for i:=ComponentCount-1 downto 0 do
  begin
    if (Components[i] is TEdit) then
    begin
      TEdit(Components[i]).Color:=clWindow;
      TEdit(Components[i]).ReadOnly:=False;
    end;
  end;
  DateTimePicker1.Color:=clWindow;
  DateTimePicker1.Enabled:=true;
  DateTimePicker2.Color:=clWindow;
  DateTimePicker2.Enabled:=True;
  ComboBox1.Color:=clWindow;
  ComboBox1.Enabled:=true;
  ComboBox2.Color:=clWindow;
  ComboBox2.Enabled:=true;
  Memo1.Color := clWindow;
  Memo1.ReadOnly := False;
  SpeedButton1.Enabled:=False;
  SpeedButton2.Enabled:=False;
  SpeedButton3.Enabled:=True;
  SpeedButton4.Enabled:=True;
  Panel1.Enabled:=True;
end;

procedure TWXXX_ED.DIS;
var
  i:integer;
begin
  for i:=ComponentCount-1 downto 0 do
  begin
    if (Components[i] is Tedit) then
    begin
      TEdit(Components[i]).Color:=$00d8d8d8;
      TEdit(Components[i]).ReadOnly:=true;
    end;
  end;
  DateTimePicker1.Color:=$00d8d8d8;
  DateTimePicker1.Enabled:=False;
  DateTimePicker2.Color:=$00d8d8d8;
  DateTimePicker2.Enabled:=False;
  ComboBox1.Color:=$00d8d8d8;
  ComboBox1.Enabled:=false;
  ComboBox2.Color:=$00d8d8d8;
  ComboBox2.Enabled:=false;
  Memo1.Color := $00D8D8D8;
  Memo1.ReadOnly := true;
  SpeedButton1.Enabled:=True;
  SpeedButton2.Enabled:=True;
  SpeedButton3.Enabled:=False;
  SpeedButton4.Enabled:=False;
  Panel1.Enabled:=False;
end;

procedure TWXXX_ED.CLS;
var
  i:integer;
begin
  for i:=ComponentCount-1 downto 0 do
  begin
    if(Components[i] is tedit) then
      TEdit(Components[i]).Clear;
  end;
  Memo1.Clear;
end;