uclxx_ed.pas

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

PAS
940
字号
unit UCLXX_ED;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, ExtCtrls, DBCtrls, Buttons, ComCtrls, TabNotBk,
  ExtDlgs;
type
  TCLXX_ED = class(TForm)
    Panel1: TPanel;
    Panel2: TPanel;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    SpeedButton3: TSpeedButton;
    SpeedButton4: TSpeedButton;
    SpeedButton5: TSpeedButton;
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label14: TLabel;
    Label13: TLabel;
    Label23: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    Label15: TLabel;
    Label16: TLabel;
    Label17: TLabel;
    Label18: TLabel;
    Label19: TLabel;
    Label22: TLabel;
    Label20: TLabel;
    Label24: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    Edit6: TEdit;
    Edit7: TEdit;
    Edit8: TEdit;
    Edit9: TEdit;
    Edit10: TEdit;
    Edit11: TEdit;
    Edit13: TEdit;
    Edit14: TEdit;
    Edit16: TEdit;
    Edit17: TEdit;
    Edit19: TEdit;
    Edit20: TEdit;
    ComboBox1: TComboBox;
    Memo1: TMemo;
    Edit18: TEdit;
    DateTimePicker1: TDateTimePicker;
    DateTimePicker2: TDateTimePicker;
    DateTimePicker3: TDateTimePicker;
    DateTimePicker4: TDateTimePicker;
    DateTimePicker5: TDateTimePicker;
    DateTimePicker6: TDateTimePicker;
    Edit21: TEdit;
    Label21: TLabel;
    SpeedButton6: TSpeedButton;
    OpenPictureDialog1: TOpenPictureDialog;
    DBImage1: TDBImage;
    ComboBox2: TComboBox;
    ComboBox3: TComboBox;
    procedure SpeedButton5Click(Sender: TObject);
    procedure DateTimePicker1Change(Sender: TObject);
    procedure DateTimePicker4Change(Sender: TObject);
    procedure DateTimePicker3Change(Sender: TObject);
    procedure DateTimePicker2Change(Sender: TObject);
    procedure DateTimePicker5Change(Sender: TObject);
    procedure DateTimePicker6Change(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 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 Edit15Change(Sender: TObject);
    procedure Edit21Change(Sender: TObject);
    procedure Edit16Change(Sender: TObject);
    procedure Edit3KeyPress(Sender: TObject; var Key: Char);
    procedure Edit5KeyPress(Sender: TObject; var Key: Char);
    procedure Edit15KeyPress(Sender: TObject; var Key: Char);
    procedure Edit16KeyPress(Sender: TObject; var Key: Char);
    procedure SpeedButton6Click(Sender: TObject);
    procedure Edit2KeyPress(Sender: TObject; var Key: Char);
    procedure Edit6KeyPress(Sender: TObject; var Key: Char);
    procedure Edit4KeyPress(Sender: TObject; var Key: Char);
    procedure Edit7KeyPress(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 Edit21KeyPress(Sender: TObject; var Key: Char);
    procedure ComboBox1KeyPress(Sender: TObject; var Key: Char);
    procedure DateTimePicker1KeyPress(Sender: TObject; var Key: Char);
    procedure DateTimePicker2KeyPress(Sender: TObject; var Key: Char);
    procedure DateTimePicker4KeyPress(Sender: TObject; var Key: Char);
    procedure DateTimePicker5KeyPress(Sender: TObject; var Key: Char);
    procedure DateTimePicker3KeyPress(Sender: TObject; var Key: Char);
    procedure DateTimePicker6KeyPress(Sender: TObject; var Key: Char);
    procedure ComboBox2DropDown(Sender: TObject);
    procedure ComboBox3DropDown(Sender: TObject);
    procedure Edit8KeyPress(Sender: TObject; var Key: Char);
    procedure ComboBox3KeyPress(Sender: TObject; var Key: Char);
    procedure ComboBox2KeyPress(Sender: TObject; var Key: Char);
    procedure ComboBox1DropDown(Sender: TObject);
    procedure ComboBox3Change(Sender: TObject);
  private
    { Private declarations }
  public
    nu:string;
    procedure BH;
    function cansave:boolean;
    procedure GetAll;
    procedure Posting;
    procedure ENA;
    procedure DIS;
    procedure CLS;
    procedure tr;

    { Public declarations }
  end;

var
  CLXX_ED: TCLXX_ED;
implementation

uses UDM, UMain, UCLXX;

{$R *.dfm}
procedure TCLXX_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 TCLXX_ED.BH;
var
  s,m:string;
begin
  with dm.QCLXX do
  begin
    Close;
    SQL.Clear;
    SQL.Add('Select max(clbh) as 编号 From CLXX');
    Open;
  end;
  if dm.ADODSCLXX.FieldByName('clbh').Value=null then
    s:=s+'1'
  else
  begin
    dm.ADODSCLXX.Last;
    m:=Trim(DM.ADODSCLXX.Fieldbyname('clbh').Value);
    s:=inttostr(strtoint(m)+1);
  end;
  edit1.Text:=s;
end;
function TCLXX_ED.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 (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 (ComboBox3.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;
  if (ComboBox2.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 (Edit8.Text='') then
  begin
    Result:=False;
    Application.MessageBox('燃油类型不能为空!','提示信息',0+MB_ICONINFORMATION);
    exit;
  end;
  if (Edit16.Text='') then
  begin
    Result:=False;
    Application.MessageBox('汽车厂家不能为空!','提示信息',0+MB_ICONINFORMATION);
    exit;
  end;
  if (Edit17.Text='') then
  begin
    Result:=False;
    Application.MessageBox('请选择购买日期!','提示信息',0+MB_ICONINFORMATION);
    exit;
  end;
  if (Edit18.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 (Edit19.Text='') then
  begin
    Result:=False;
    Application.MessageBox('请选择维护日期!','提示信息',0+MB_ICONINFORMATION);
    exit;
  end;
  if (Edit20.Text='') then
  begin
    Result:=False;
    Application.MessageBox('请选择二次维护日期!','提示信息',0+MB_ICONINFORMATION);
    exit;
  end;
  if (Edit21.Text='') then
  begin
    Result:=False;
    Application.MessageBox('排放量不能为空!','提示信息',0+MB_ICONINFORMATION);
    exit;
  end;
end;
procedure TCLXX_ED.GetAll;
begin
    Edit1.Text:=DM.ADODSCLXX.FieldByName('clbh').AsString;
    Edit2.Text:=DM.ADODSCLXX.FieldByName('clmc').AsString;
    Edit3.Text:=DM.ADODSCLXX.FieldByName('cllx').AsString;
    Edit4.Text:=DM.ADODSCLXX.FieldByName('cph').AsString;
    Edit5.Text:=DM.ADODSCLXX.fieldByName('clys').AsString;
    Edit6.Text:=DM.ADODSCLXX.FieldByName('fdjh').AsString;
    Edit7.Text:=DM.ADODSCLXX.FieldByName('dpbh').AsString;
    Edit11.Text:=DM.ADODSCLXX.FieldByName('bxdh').AsString;
    ComboBox3.Text:=DM.ADODSCLXX.FieldByName('bxlx').AsString;
    Edit13.Text:=DM.ADODSCLXX.FieldByName('bxgmrq').AsString;
    Edit14.Text:=DM.ADODSCLXX.FieldByName('bxjzrq').AsString;
    ComboBox2.Text:=DM.ADODSCLXX.FieldByName('bxgs').AsString;
    Edit9.Text:=DM.ADODSCLXX.FieldByName('yyzh').AsString;
    Edit8.Text:=DM.ADODSCLXX.FieldByName('rylx').AsString;
    Edit16.Text:=DM.ADODSCLXX.FieldByName('qccj').AsString;
    Edit17.Text:=DM.ADODSCLXX.FieldByName('gmrq').AsString;
    Edit18.Text:=DM.ADODSCLXX.FieldByName('bfrq').AsString;
    Edit19.Text:=DM.ADODSCLXX.FieldByName('whsj').AsString;
    Edit20.Text:=DM.ADODSCLXX.FieldByName('ecwhsj').AsString;
    Edit10.Text:=DM.ADODSCLXX.FieldByName('fjfh').AsString;
    Edit21.Text:=DM.ADODSCLXX.FieldByName('pfl').AsString;
    ComboBox1.Text:=DM.ADODSCLXX.FieldByName('clzt').AsString;
    Memo1.Text:=DM.ADODSCLXX.FieldByName('bz').AsString;
end;

procedure TCLXX_ED.Posting;
begin
  if ActionCD='N' then
  BEGIN
  with DM.QCLXX do
  begin
    Close;
    SQL.Clear;
    SQL.Add('INSERT INTO CLXX(clmc,cllx,cph,clys,fdjh,dpbh,bxdh,bxlx,bxgmrq,bxjzrq,bxgs,yyzh,rylx,qccj,gmrq,bfrq,whsj,ecwhsj,fjfh,pfl,clzt,bz,clbh)');
    SQL.Add('Values(:车辆名称,:车辆类型,:车牌号,:车辆颜色,:发动机号,:底盘编号,:保险单号,:保险类型,:保险购买日期,:保险截止日期,:保险公司,:营运证号,:燃油类型,:汽车厂家,:购买日期,:报废日期,:维护时间,:二次维护时间,:附加费号,:排放量,:车辆状态,:备注,:车辆编号)');
    Parameters.Items[0].Value:=Edit2.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:=Edit11.Text;
    Parameters.Items[7].Value:=ComboBox3.Text;
    Parameters.Items[8].Value:=Edit13.Text;
    Parameters.Items[9].Value:=Edit14.Text;
    Parameters.Items[10].Value:=ComboBox2.Text;
    Parameters.Items[11].Value:=Edit9.Text;
    Parameters.Items[12].Value:=Edit8.Text;
    Parameters.Items[13].Value:=Edit16.Text;
    Parameters.Items[14].Value:=Edit17.Text;
    Parameters.Items[15].Value:=Edit18.Text;
    Parameters.Items[16].Value:=Edit19.Text;
    Parameters.Items[17].Value:=Edit20.Text;
    Parameters.Items[18].Value:=Edit10.Text;
    Parameters.Items[19].Value:=Edit21.Text;
    Parameters.Items[20].Value:=ComboBox1.Text;
    Parameters.Items[21].Value:=Memo1.Text;
    Parameters.Items[22].Value:=Edit1.Text;
    Prepared:=True;
    ExecSQL;
  end;
  END else
  if ActionCD='M' then
  begin
    With DM.QCLXX DO
    begin
      Close;
      SQL.Clear;
      SQL.Add('update CLXX Set clmc=:车辆名称,');
      SQL.Add('cllx=:车辆类型,cph=:车牌号,clys=:车辆颜色,fdjh=:发动机号,');
      SQL.Add('dpbh=:底盘编号,bxdh=:保险单号,bxlx=:保险类型,bxgmrq=:保险购买日期,');
      SQL.Add('bxjzrq=:保险截止日期,bxgs=:保险公司,yyzh=:营运证号,rylx=:燃油类型,');
      SQL.Add('qccj=:汽车厂家,gmrq=:购买日期,bfrq=:报废日期,whsj=:维护时间,');
      SQL.Add('ecwhsj=:二次维护时间,fjfh=:附加费号,pfl=:排放量,clzt=:车辆状态,');
      SQL.Add('bz=:备注 Where clbh=:车辆编号');
      Parameters.Items[0].Value:=Edit2.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:=Edit11.Text;
      Parameters.Items[7].Value:=ComboBox3.Text;
      Parameters.Items[8].Value:=Edit13.Text;
      Parameters.Items[9].Value:=Edit14.Text;
      Parameters.Items[10].Value:=ComboBox2.Text;
      Parameters.Items[11].Value:=Edit9.Text;
      Parameters.Items[12].Value:=Edit8.Text;
      Parameters.Items[13].Value:=Edit16.Text;
      Parameters.Items[14].Value:=Edit17.Text;
      Parameters.Items[15].Value:=Edit18.Text;
      Parameters.Items[16].Value:=Edit19.Text;
      Parameters.Items[17].Value:=Edit20.Text;
      Parameters.Items[18].Value:=Edit10.Text;
      Parameters.Items[19].Value:=Edit21.Text;
      Parameters.Items[20].Value:=ComboBox1.Text;
      Parameters.Items[21].Value:=Memo1.Text;
      Parameters.Items[22].Value:=DM.ADODSCLXX.FieldByName('clbh').AsString;
      Prepared:=true;
      ExecSQL;
    end;
  end;
end;
procedure TCLXX_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;
  DateTimePicker3.Color:=clWindow;
  DateTimePicker3.Enabled:=True;
  DateTimePicker4.Color:=clWindow;
  DateTimePicker4.Enabled:=True;
  DateTimePicker5.Color:=clWindow;
  DateTimePicker5.Enabled:=True;
  DateTimePicker6.Color:=clWindow;
  DateTimePicker6.Enabled:=True;
  ComboBox1.Color:=clWindow;
  ComboBox1.Enabled:=True;
  ComboBox2.Color:=clWindow;
  ComboBox2.Enabled:=True;
  ComboBox3.Color:=clWindow;
  ComboBox3.Enabled:=True;
  DBImage1.Color:=clWindow;
  DBImage1.ReadOnly:=False;
  Memo1.Color := clWindow;
  Memo1.ReadOnly := False;
  SpeedButton1.Enabled:=False;
  SpeedButton2.Enabled:=False;
  SpeedButton3.Enabled:=True;
  SpeedButton4.Enabled:=True;
  Panel1.Enabled:=True;
end;
procedure TCLXX_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;
    if (Components[i] is TDateTimePicker)then
    begin
      TDateTimePicker(Components[i]).Color:=$00d8d8d8;
      TDateTimePicker(Components[i]).Enabled:=false;
    end;
  end;
  DateTimePicker1.Color:=$00d8d8d8;
  DateTimePicker1.Enabled:=False;
  DateTimePicker2.Color:=$00d8d8d8;
  DateTimePicker2.Enabled:=False;
  DateTimePicker3.Color:=$00d8d8d8;

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?