?? ucljbxx.~pas

?? 完整的物流管理系統(tǒng)源碼,包含數(shù)據(jù)庫,適合初學(xué)者參考
?? ~PAS
字號:
unit UCLJBXX;

interface

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

type
  TFRM_CLJBXX = class(TForm)
    ToolBar1: TToolBar;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    SpeedButton3: TSpeedButton;
    SpeedButton4: TSpeedButton;
    SpeedButton5: TSpeedButton;
    SpeedButton6: TSpeedButton;
    Panel1: TPanel;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    Edit6: TEdit;
    Edit7: TEdit;
    Edit8: TEdit;
    Edit9: TEdit;
    Edit10: TEdit;
    Panel2: TPanel;
    DBGrid1: TDBGrid;
    procedure SpeedButton6Click(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 SpeedButton5Click(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 Edit1KeyPress(Sender: TObject; var Key: Char);
    procedure Edit2KeyPress(Sender: TObject; var Key: Char);
    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 Edit7KeyPress(Sender: TObject; var Key: Char);
    procedure Edit8KeyPress(Sender: TObject; var Key: Char);
    procedure Edit9KeyPress(Sender: TObject; var Key: Char);
    procedure DBGrid1CellClick(Column: TColumn);
    procedure DBGrid1DrawColumnCell(Sender: TObject; const Rect: TRect;
      DataCol: Integer; Column: TColumn; State: TGridDrawState);
  private
    { Private declarations }
  public
    procedure tr;       //去除空字符
    procedure bh;        //自動編號
    Procedure GetAll;    //獲得所有數(shù)據(jù)
    Procedure Posting;   //提交數(shù)據(jù)
    Procedure CLS;       //清除控件中內(nèi)容
    Procedure DIS;       //控件不可用
    Procedure ENA;       //控件可用
    Function CanSave:Boolean;   //判斷是否保存
    { Public declarations }
  end;

var
  FRM_CLJBXX: TFRM_CLJBXX;

implementation

uses UDM, UMAIN, UYGJBXX;

{$R *.dfm}
procedure TFRM_CLJBXX.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;
Function TFRM_CLJBXX.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 (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;
end;

procedure TFRM_CLJBXX.bh;
var
i:integer;
s,m:string;
begin
  s:= 'CL'+ FormatDateTime('yyyymmdd',Now());
  With DM.QCLJBXX do
  begin
    Close;
    SQL.Clear;
    SQL.Add('select max(車輛編號) as ss From 車輛信息表');
    Open;
  end;
  If DM.QCLJBXX.FieldByName('ss').Value=null then
    s := s + '001'
  else
  begin
    m:= Trim(DM.QCLJBXX.FieldByName('ss').Value) ;
    i:= StrToInt(Trim(Copy(m,11,8))) ;
    if i<9 then
      s:= s + '00'+ InttoStr(i +1)
    else if i<99 then
      s:= s + '0'+ InttoStr(i +1)
    else
      s:= s +InttoStr(i +1);
  end;
  Edit1.Text := s;
end;

procedure TFRM_CLJBXX.GetAll;
begin
  Edit1.Text:=DM.DSOCLJBXX.FieldByName('車輛編號').AsString;
  Edit2.Text:=DM.DSOCLJBXX.FieldByName('車牌號碼').AsString;
  Edit3.Text:=DM.DSOCLJBXX.FieldByName('車輛類型').AsString;
  Edit4.Text:=DM.DSOCLJBXX.FieldByName('車主姓名').AsString;
  Edit5.Text:=DM.DSOCLJBXX.FieldByName('車主電話').AsString;
  Edit6.Text:=DM.DSOCLJBXX.FieldByName('車主手機(jī)').AsString;
  Edit7.Text:=DM.DSOCLJBXX.FieldByName('身份證號').AsString;
  Edit8.Text:=DM.DSOCLJBXX.FieldByName('電子郵件').AsString;
  Edit9.Text:=DM.DSOCLJBXX.FieldByName('車主地址').AsString;
  Edit10.Text:=DM.DSOCLJBXX.FieldByName('備注').AsString;
end;
procedure TFRM_CLJBXX.Posting;
begin
  if ActionCD='N' then
  BEGIN
    with DM.QCLJBXX do
    begin
      Close;
      SQL.Clear;
      SQL.Add('INSERT INTO 車輛信息表(車輛編號,車牌號碼,車輛類型,車主姓名,車主電話,車主手機(jī),');
      SQL.Add('身份證號,電子郵件,車主地址,備注)');
      SQL.Add('Values(:車輛編號,:車牌號碼,:車輛類型,:車主姓名,:車主電話,:車主手機(jī),');
      SQL.Add(':身份證號,:電子郵件,:車主地址,:備注)');
      Parameters.Items[0].Value:=Edit1.Text;
      Parameters.Items[1].Value:=Edit2.Text;
      Parameters.Items[2].Value:=Edit3.Text;
      Parameters.Items[3].Value:=Edit4.Text;
      Parameters.Items[4].Value:=Edit5.Text;
      Parameters.Items[5].Value:=Edit6.Text;
      Parameters.Items[6].Value:=Edit7.Text;
      Parameters.Items[7].Value:=Edit8.Text;
      Parameters.Items[8].Value:=Edit9.Text;
      Parameters.Items[9].Value:=Edit10.Text;
      Prepared:=True;
      ExecSQL;
    end;
  END else
  if ActionCD='M' then
  begin
    With DM.QCLJBXX DO
    begin
      Close;
      SQL.Clear;
      SQL.Add('update 車輛信息表 Set 車牌號碼=:車牌號碼1,車輛類型=:車輛類型1,車主姓名=:車主姓名1,車主電話=:車主電話1,車主手機(jī)=:車主手機(jī)1,');
      SQL.Add('身份證號=:身份證號1,電子郵件=:電子郵件1,車主地址=:車主地址,備注=:備注1 where 車輛編號=:車輛編號1');
      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:=Edit8.Text;
      Parameters.Items[7].Value:=Edit9.Text;
      Parameters.Items[8].Value:=Edit10.Text;
      Parameters.Items[9].Value:=DM.DSOCLJBXX.FieldByName('車輛編號').AsString;
      Prepared:=true;
      ExecSQL;
    end;
  end;
end;
procedure TFRM_CLJBXX.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;
  SpeedButton1.Enabled:=False;
  SpeedButton2.Enabled:=False;
  SpeedButton3.Enabled:=True;
  SpeedButton4.Enabled:=False;
  Panel1.Enabled:=True;
end;
procedure TFRM_CLJBXX.DIS;
var
  i:integer;
begin
  for i:=ComponentCount-1 downto 0 do
  begin
    if (Components[i] is Tedit) then
    begin
      TEdit(Components[i]).Color:=$00EFEFEF;
      TEdit(Components[i]).ReadOnly:=true;
    end;
  end;
  SpeedButton1.Enabled:=True;
  SpeedButton2.Enabled:=True;
  SpeedButton3.Enabled:=False;
  SpeedButton4.Enabled:=False;
  Panel1.Enabled:=False;
end;
procedure TFRM_CLJBXX.CLS;
var
  i:integer;
begin
  for i:=ComponentCount-1 downto 0 do
  begin
    if(Components[i] is TEdit) then
      TEdit(Components[i]).Clear;
  end;
end;
////////////////////////////////////////////////////////////
procedure TFRM_CLJBXX.SpeedButton6Click(Sender: TObject);
begin
  ACtionCD:='';
  Close;
end;

procedure TFRM_CLJBXX.FormCreate(Sender: TObject);
begin
  with DM.QCLJBXX do
  begin
    Close;
    SQL.Clear;
    SQL.Add('Select * from 車輛信息表');
    Open;
  end;
  DM.DSOCLJBXX.Open;
end;

procedure TFRM_CLJBXX.FormShow(Sender: TObject);
begin
  DIS;
  if ActionCD = 'M' then
    GetAll
  else if ActionCD = 'N' then
  begin
    CLS;
    ENA;
  end;
end;

procedure TFRM_CLJBXX.SpeedButton1Click(Sender: TObject);
begin
  CLS;
  ENA;
  ActionCD := 'N';
  bh;
  Edit2.SetFocus;
end;

procedure TFRM_CLJBXX.SpeedButton2Click(Sender: TObject);
begin
  ENA;
  SpeedButton4.Enabled:=True;
  ACtionCD := 'M';
end;

procedure TFRM_CLJBXX.SpeedButton3Click(Sender: TObject);
begin
  if (cansave) then
  begin
    Posting;
    DIS;
    DM.DSOCLJBXX.Close;
    DM.DSOCLJBXX.Open;
    Application.MessageBox('保存成功!','提示!',64);
    actioncd:='';
    self.Close;
  end;
end;

procedure TFRM_CLJBXX.SpeedButton4Click(Sender: TObject);
begin
  if DM.DSOCLJBXX.RecordCount=0 then
  begin
    Application.MessageBox('沒有記錄可以刪除!','提示',0+MB_ICONINFORMATION);
    Exit;
  end;
  if DM.DSOCLJBXX.IsEmpty then
    Exit;
  if ID_YES=application.MessageBox('確實要刪除這條記錄嗎？','提示',MB_YESNO) then
  begin
    DM.DSOCLJBXX.Delete;
    self.OnShow(Sender);
  end;
end;

procedure TFRM_CLJBXX.SpeedButton5Click(Sender: TObject);
begin
  DIS;
  SpeedButton4.Enabled:=False;
  FRM_CLJBXX.GetAll;
  ActionCD:='';
end;

procedure TFRM_CLJBXX.Edit2Change(Sender: TObject);
begin
tr
end;

procedure TFRM_CLJBXX.Edit3Change(Sender: TObject);
begin
tr
end;

procedure TFRM_CLJBXX.Edit4Change(Sender: TObject);
begin
tr
end;

procedure TFRM_CLJBXX.Edit5Change(Sender: TObject);
begin
tr
end;

procedure TFRM_CLJBXX.Edit6Change(Sender: TObject);
begin
tr
end;

procedure TFRM_CLJBXX.Edit7Change(Sender: TObject);
begin
tr
end;

procedure TFRM_CLJBXX.Edit8Change(Sender: TObject);
begin
tr
end;

procedure TFRM_CLJBXX.Edit9Change(Sender: TObject);
begin
tr
end;

procedure TFRM_CLJBXX.Edit10Change(Sender: TObject);
begin
tr
end;

procedure TFRM_CLJBXX.Edit1KeyPress(Sender: TObject; var Key: Char);
begin
  key:=#0;
end;

procedure TFRM_CLJBXX.Edit2KeyPress(Sender: TObject; var Key: Char);
begin
  if key in['a'..'z'] then
    key:=#0;
  if key=#13 then
    Edit3.SetFocus;
end;

procedure TFRM_CLJBXX.Edit3KeyPress(Sender: TObject; var Key: Char);
begin
  if key in['a'..'z','A'..'Z','0'..'9'] then
    key:=#0;
  if key=#13 then
    Edit4.SetFocus;
end;

procedure TFRM_CLJBXX.Edit4KeyPress(Sender: TObject; var Key: Char);
begin
  if key in['a'..'z','A'..'Z','0'..'9'] then
    key:=#0;
  if key=#13 then
    Edit5.SetFocus;
end;

procedure TFRM_CLJBXX.Edit5KeyPress(Sender: TObject; var Key: Char);
begin
  if not (key in['0'..'9','-',#13,#8]) then
    key:=#0;
  if key=#13 then
    Edit6.SetFocus;
end;

procedure TFRM_CLJBXX.Edit6KeyPress(Sender: TObject; var Key: Char);
begin
  if not (key in['0'..'9','-',#13,#8]) then
    key:=#0;
  if key=#13 then
    Edit7.SetFocus;
end;

procedure TFRM_CLJBXX.Edit7KeyPress(Sender: TObject; var Key: Char);
begin
  if not (key in['0'..'9',#13,#8]) then
    key:=#0;
  if key=#13 then
    Edit8.SetFocus;
end;

procedure TFRM_CLJBXX.Edit8KeyPress(Sender: TObject; var Key: Char);
begin
  if key=#13 then
    Edit9.SetFocus;
end;

procedure TFRM_CLJBXX.Edit9KeyPress(Sender: TObject; var Key: Char);
begin
  if key=#13 then
    Edit10.SetFocus;
end;

procedure TFRM_CLJBXX.DBGrid1CellClick(Column: TColumn);
begin
  GetAll;
end;

procedure TFRM_CLJBXX.DBGrid1DrawColumnCell(Sender: TObject;
  const Rect: TRect; DataCol: Integer; Column: TColumn;
  State: TGridDrawState);
begin
  FRM_MAIN.SetDBGird(Sender as TDBGrid,DM.QCLJBXX ,Rect,DataCol,Column,State);
end;

end.
?? 文件大小 3071 K
?? 上傳用戶 hahuhuhuhu
?? 所屬分類企業(yè)管理
??? 相關(guān)標(biāo)簽

#物流管理系統(tǒng) #源碼 #數(shù)據(jù)庫 #初學(xué)者
?? 快捷鍵說明

復(fù)制代碼 Ctrl + C
搜索代碼 Ctrl + F
全屏模式 F11
切換主題 Ctrl + Shift + D
顯示快捷鍵 ?
增大字號 Ctrl + =
減小字號 Ctrl + -
亚洲欧美第一页_禁久久精品乱码_粉嫩av一区二区三区免费野_久草精品视频

?? ucljbxx.~pas

?? 快捷鍵說明
