ukhxx_ed.pas

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

unit UKHXX_ED;

interface

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

type
  TKHXX_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;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    Label13: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    Edit7: TEdit;
    Edit8: TEdit;
    Edit9: TEdit;
    Edit10: TEdit;
    Edit11: TEdit;
    Edit12: TEdit;
    Edit13: TEdit;
    GroupBox2: TGroupBox;
    Label16: TLabel;
    Label17: TLabel;
    Label18: TLabel;
    Label19: TLabel;
    Label20: TLabel;
    Label21: TLabel;
    Label15: TLabel;
    Label24: TLabel;
    Label23: TLabel;
    Label22: TLabel;
    Label25: TLabel;
    Edit14: TEdit;
    Edit15: TEdit;
    Edit17: TEdit;
    Edit18: TEdit;
    Edit19: TEdit;
    Edit20: TEdit;
    Edit21: TEdit;
    Edit22: TEdit;
    Edit23: TEdit;
    Edit24: TEdit;
    GroupBox3: TGroupBox;
    Label27: TLabel;
    Label28: TLabel;
    Label29: TLabel;
    Label30: TLabel;
    Label31: TLabel;
    Label32: TLabel;
    Edit25: TEdit;
    Edit26: TEdit;
    Edit27: TEdit;
    Edit28: TEdit;
    Edit29: TEdit;
    Edit30: TEdit;
    DBImage1: TDBImage;
    DBImage2: TDBImage;
    SpeedButton7: TSpeedButton;
    Label33: TLabel;
    Memo1: TMemo;
    ComboBox1: TComboBox;
    ComboBox2: TComboBox;
    OpenPictureDialog1: TOpenPictureDialog;
    OpenPictureDialog2: TOpenPictureDialog;
    ComboBox3: TComboBox;
    SpeedButton6: TSpeedButton;
    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 SpeedButton6Click(Sender: TObject);
    procedure SpeedButton7Click(Sender: TObject);
    procedure Edit2KeyPress(Sender: TObject; var Key: Char);
    procedure Edit4KeyPress(Sender: TObject; var Key: Char);
    procedure Edit5KeyPress(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 Edit12KeyPress(Sender: TObject; var Key: Char);
    procedure Edit15KeyPress(Sender: TObject; var Key: Char);
    procedure Edit14KeyPress(Sender: TObject; var Key: Char);
    procedure Edit17KeyPress(Sender: TObject; var Key: Char);
    procedure Edit18KeyPress(Sender: TObject; var Key: Char);
    procedure Edit19KeyPress(Sender: TObject; var Key: Char);
    procedure Edit20KeyPress(Sender: TObject; var Key: Char);
    procedure Edit21KeyPress(Sender: TObject; var Key: Char);
    procedure Edit22KeyPress(Sender: TObject; var Key: Char);
    procedure Edit25KeyPress(Sender: TObject; var Key: Char);
    procedure Edit26KeyPress(Sender: TObject; var Key: Char);
    procedure Edit2Change(Sender: TObject);
    procedure Edit6Change(Sender: TObject);
    procedure Edit5Change(Sender: TObject);
    procedure Edit4Change(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 Edit19Change(Sender: TObject);
    procedure Edit18Change(Sender: TObject);
    procedure Edit17Change(Sender: TObject);
    procedure Edit20Change(Sender: TObject);
    procedure Edit21Change(Sender: TObject);
    procedure Edit22Change(Sender: TObject);
    procedure Edit24Change(Sender: TObject);
    procedure Edit23Change(Sender: TObject);
    procedure Edit25Change(Sender: TObject);
    procedure Edit26Change(Sender: TObject);
    procedure Edit27Change(Sender: TObject);
    procedure Edit28Change(Sender: TObject);
    procedure Edit29Change(Sender: TObject);
    procedure Edit30Change(Sender: TObject);
    procedure Memo1Change(Sender: TObject);
    procedure Edit6KeyPress(Sender: TObject; var Key: Char);
    procedure Edit7KeyPress(Sender: TObject; var Key: Char);
    procedure Edit11KeyPress(Sender: TObject; var Key: Char);
    procedure Edit13KeyPress(Sender: TObject; var Key: Char);
    procedure Edit23KeyPress(Sender: TObject; var Key: Char);
    procedure Edit24KeyPress(Sender: TObject; var Key: Char);
    procedure Edit27KeyPress(Sender: TObject; var Key: Char);
    procedure Edit28KeyPress(Sender: TObject; var Key: Char);
    procedure Edit29KeyPress(Sender: TObject; var Key: Char);
    procedure Edit30KeyPress(Sender: TObject; var Key: Char);
    procedure ComboBox1KeyPress(Sender: TObject; var Key: Char);
    procedure ComboBox3KeyPress(Sender: TObject; var Key: Char);
    procedure ComboBox2KeyPress(Sender: TObject; var Key: Char);
    procedure ComboBox1DropDown(Sender: TObject);
    procedure ComboBox3DropDown(Sender: TObject);
    procedure ComboBox2DropDown(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
  KHXX_ED: TKHXX_ED;

implementation

uses UMain, UDM, UKHXX;

{$R *.dfm}
procedure TKHXX_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 TKHXX_ED.BH;
var
  s,m:string;
begin
  with DM.QKHXX do
  begin
    Close;
    SQL.Clear;
    SQL.Add('Select max(k_bh) as 客户编号 From KHXX');
    Open;
  end;
  if dm.ADODSKHXX.FieldByName('k_bh').Value=null then
    s:=s+'1'
  else
  begin
    dm.ADODSKHXX.Last;
    m:=Trim(DM.ADODSKHXX.Fieldbyname('k_bh').Value);
    s:=inttostr(strtoint(m)+1);
  end;
  edit1.Text:=s;
end;

function TKHXX_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 (ComboBox1.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 (Edit8.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;
end;
procedure TKHXX_ED.GetAll;
begin
    Edit1.Text:=DM.ADODSKHXX.FieldByName('k_bh').AsString;
    Edit2.Text:=DM.ADODSKHXX.FieldByName('k_khxm').AsString;
    ComboBox1.Text:=DM.ADODSKHXX.FieldByName('k_khxb').AsString;
    Edit4.Text:=DM.ADODSKHXX.FieldByName('k_zjm').AsString;
    Edit5.Text:=DM.ADODSKHXX.fieldByName('k_zjh').AsString;
    ComboBox3.Text:=DM.ADODSKHXX.FieldByName('k_khdj').AsString;
    Edit7.Text:=DM.ADODSKHXX.FieldByName('k_yddh').AsString;
    Edit8.Text:=DM.ADODSKHXX.FieldByName('k_gddh').AsString;
    Edit9.Text:=DM.ADODSKHXX.FieldByName('k_cz').AsString;
    Edit10.Text:=DM.ADODSKHXX.FieldByName('k_yb').AsString;
    Edit11.Text:=DM.ADODSKHXX.FieldByName('k_dzyj').AsString;
    Edit12.Text:=DM.ADODSKHXX.FieldByName('k_jszh').AsString;
    Edit13.Text:=DM.ADODSKHXX.FieldByName('k_jtzz').AsString;

    Edit14.Text:=DM.ADODSKHXX.FieldByName('d_bh').AsString;
    Edit15.Text:=DM.ADODSKHXX.FieldByName('d_xm').AsString;
    ComboBox2.Text:=DM.ADODSKHXX.FieldByName('d_xb').AsString;
    Edit17.Text:=DM.ADODSKHXX.FieldByName('d_yb').AsString;
    Edit18.Text:=DM.ADODSKHXX.FieldByName('d_zjm').AsString;
    Edit19.Text:=DM.ADODSKHXX.FieldByName('d_zjh').AsString;
    Edit20.Text:=DM.ADODSKHXX.FieldByName('d_yddh').AsString;
    Edit21.Text:=DM.ADODSKHXX.FieldByName('d_gddh').AsString;
    Edit22.Text:=DM.ADODSKHXX.FieldByName('d_cz').AsString;
    Edit23.Text:=DM.ADODSKHXX.FieldByName('d_dzyj').AsString;
    Edit24.Text:=DM.ADODSKHXX.FieldByName('d_jtdz').AsString;

    Edit25.Text:=DM.ADODSKHXX.FieldByName('q_qymc').AsString;
    Edit26.Text:=DM.ADODSKHXX.FieldByName('q_frdb').AsString;
    Edit27.Text:=DM.ADODSKHXX.FieldByName('q_zczj').AsString;
    Edit28.Text:=DM.ADODSKHXX.FieldByName('q_qyzch').AsString;
    Edit29.Text:=DM.ADODSKHXX.FieldByName('q_zzjgdm').AsString;
    Edit30.Text:=DM.ADODSKHXX.FieldByName('q_qydz').AsString;
    Memo1.Text:=DM.ADODSKHXX.FieldByName('bz').AsString;
end;


procedure TKHXX_ED.Posting;
begin
  if ActionCD='N' then
  BEGIN
  with DM.QKHXX do
  begin
    Close;
    SQL.Clear;
    SQL.Add('INSERT INTO KHXX(k_khxm,k_khxb,');
    SQL.Add('k_zjm,k_zjh,k_khdj,k_yddh,k_gddh,');
    SQL.Add('k_cz,k_yb,k_dzyj,k_jszh,k_jtzz,d_bh,');
    SQL.Add('d_xm,d_xb,d_yb,d_zjm,d_zjh,d_yddh,d_gddh,');
    SQL.Add('d_cz,d_dzyj,d_jtdz,q_qymc,q_frdb,q_zczj,');
    SQL.Add('q_qyzch,q_zzjgdm,q_qydz,bz,k_bh)');
    SQL.Add('Values(:客户姓名,:客户性别,:证件名,:证件号,');
    SQL.Add(':客户等级,:移动电话,:固定电话,:传真,:邮编,');
    SQL.Add(':电子邮件,:驾驶证号,:家庭住址,:编号,:姓名,');
    SQL.Add(':性别,:邮编1,:证件名1,:证件号1,:移动电话1,');
    SQL.Add(':固定电话1,:传真1,:电子邮件1,:家庭地址1,');
    SQL.Add(':企业名称,:法人代表,:注册资金,:企业注册号,');
    SQL.Add(':组织机构代码,:企业地址,:备注,:客户编号)');
    Parameters.Items[0].Value:=Edit2.Text;
    Parameters.Items[1].Value:=ComboBox1.Text;
    Parameters.Items[2].Value:=Edit4.Text;
    Parameters.Items[3].Value:=Edit5.Text;
    Parameters.Items[4].Value:=ComboBox3.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:=Edit12.Text;
    Parameters.Items[11].Value:=Edit13.Text;
    Parameters.Items[12].Value:=Edit14.Text;
    Parameters.Items[13].Value:=Edit15.Text;
    Parameters.Items[14].Value:=ComboBox2.Text;
    Parameters.Items[15].Value:=Edit17.Text;
    Parameters.Items[16].Value:=Edit18.Text;
    Parameters.Items[17].Value:=Edit19.Text;
    Parameters.Items[18].Value:=Edit20.Text;
    Parameters.Items[19].Value:=Edit21.Text;
    Parameters.Items[20].Value:=Edit22.Text;
    Parameters.Items[21].Value:=Edit23.Text;
    Parameters.Items[22].Value:=Edit24.Text;
    Parameters.Items[23].Value:=Edit25.Text;
    Parameters.Items[24].Value:=Edit26.Text;
    Parameters.Items[25].Value:=Edit27.Text;
    Parameters.Items[26].Value:=Edit28.Text;
    Parameters.Items[27].Value:=Edit29.Text;
    Parameters.Items[28].Value:=Edit30.Text;
    Parameters.Items[29].Value:=Memo1.Text;
    Parameters.Items[30].Value:=Edit1.Text;
    Prepared:=True;
    ExecSQL;
  end;
  END else
  if ActionCD='M' then
  begin
    With DM.QKHXX DO
    begin
      Close;
      SQL.Clear;
      SQL.Add('update KHXX Set k_khxm=:客户姓名,');
      SQL.Add('k_khxb=:客户性别,k_zjm=:证件名,k_zjh=:证件号,k_khdj=:客户等级,');   //bh=:,   id
      SQL.Add('k_yddh=:移动电话,k_gddh=:固定电话,k_cz=:传真,k_yb=:邮编,');
      SQL.Add('k_dzyj=:电子邮件,k_jszh=:驾驶证号,k_jtzz=:家庭住址,d_bh=:编号,');
      SQL.Add('d_xm=:姓名,d_xb=:性别,d_yb=:邮编1,d_zjm=:证件名1,');
      SQL.Add('d_zjh=:证件号1,d_yddh=:移动电话1,d_gddh=:固定电话1,');
      SQL.Add('d_cz=:传真1,d_dzyj=:电子邮件1,d_jtdz=:家庭地址1,q_qymc=:企业名称,');
      SQL.Add('q_frdb=:法人代表,q_zczj=:注册资金,q_qyzch=:企业注册号,q_zzjgdm=:组织机构代码,');
      SQL.Add('q_qydz=:企业地址,bz=:备注 Where k_bh=:客户编号');
      Parameters.Items[0].Value:=Edit2.Text;
      Parameters.Items[1].Value:=ComboBox1.Text;
      Parameters.Items[2].Value:=Edit4.Text;
      Parameters.Items[3].Value:=Edit5.Text;
      Parameters.Items[4].Value:=ComboBox3.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:=Edit12.Text;
      Parameters.Items[11].Value:=Edit13.Text;
      Parameters.Items[12].Value:=Edit14.Text;
      Parameters.Items[13].Value:=Edit15.Text;
      Parameters.Items[14].Value:=ComboBox2.Text;
      Parameters.Items[15].Value:=Edit17.Text;
      Parameters.Items[16].Value:=Edit18.Text;
      Parameters.Items[17].Value:=Edit19.Text;
      Parameters.Items[18].Value:=Edit20.Text;
      Parameters.Items[19].Value:=Edit21.Text;
      Parameters.Items[20].Value:=Edit22.Text;
      Parameters.Items[21].Value:=Edit23.Text;
      Parameters.Items[22].Value:=Edit24.Text;
      Parameters.Items[23].Value:=Edit25.Text;
      Parameters.Items[24].Value:=Edit26.Text;
      Parameters.Items[25].Value:=Edit27.Text;
      Parameters.Items[26].Value:=Edit28.Text;
      Parameters.Items[27].Value:=Edit29.Text;
      Parameters.Items[28].Value:=Edit30.Text;
      Parameters.Items[29].Value:=Memo1.Text;
      Parameters.Items[30].Value:=DM.ADODSKHXX.FieldByName('k_bh').AsString;
      Prepared:=true;
      ExecSQL;
    end;
  end;
end;
procedure TKHXX_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;
  ComboBox1.Color:=clWindow;
  ComboBox1.Enabled:=True;
  ComboBox2.Color:=clWindow;
  ComboBox2.Enabled:=True;
  ComboBox3.Color:=clWindow;
  ComboBox3.Enabled:=True;
  DBImage1.Color:=clWindow;
  DBImage1.ReadOnly:=True;
  DBImage2.Color:=clWindow;
  DBImage2.ReadOnly:=True;
  Memo1.Color := clWindow;
  Memo1.ReadOnly := False;
  SpeedButton1.Enabled:=False;
  SpeedButton2.Enabled:=False;
  SpeedButton3.Enabled:=True;
  SpeedButton4.Enabled:=True;
  Panel1.Enabled:=True;
end;
procedure TKHXX_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;
  ComboBox1.Color:= $00D8D8D8;
  ComboBox1.Enabled:=False;
  ComboBox2.Color:=$00D8D8D8;
  ComboBox2.Enabled:=False;
  ComboBox3.Color:=$00D8D8D8;
  ComboBox3.Enabled:=False;
  DBImage1.Color:=$00D8D8D8;
  DBImage1.ReadOnly:=False;
  DBImage2.Color:=$00D8D8D8;
  DBImage2.ReadOnly:=False;
  Memo1.Color := $00D8D8D8;
  Memo1.ReadOnly := true;
  SpeedButton1.Enabled:=True;
  SpeedButton2.Enabled:=True;
  SpeedButton3.Enabled:=False;
  SpeedButton4.Enabled:=False;
  Panel1.Enabled:=False;
end;
procedure TKHXX_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;
procedure TKHXX_ED.SpeedButton5Click(Sender: TObject);
begin
  DIS;
  ActionCD:='';
  Close;
end;

procedure TKHXX_ED.FormCreate(Sender: TObject);
begin
  with DM.QKHXX do
  begin
    Close;
    SQL.Clear;
    SQL.Add('select * from KHXX');
    Open;
  end;