📄 uhwsqxx.pas
字号:
unit UHWSQXX;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, ExtCtrls, Buttons, ToolWin, ComCtrls, StdCtrls, Grids, DBGrids;
type
TFRM_HWSQXX = class(TForm)
ToolBar1: TToolBar;
SpeedButton1: TSpeedButton;
SpeedButton2: TSpeedButton;
SpeedButton3: TSpeedButton;
SpeedButton4: TSpeedButton;
SpeedButton5: TSpeedButton;
SpeedButton6: TSpeedButton;
Panel1: TPanel;
Panel2: TPanel;
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;
Label14: TLabel;
Label15: TLabel;
Label16: TLabel;
Label17: TLabel;
Label18: TLabel;
Label19: TLabel;
Label20: TLabel;
Label21: TLabel;
Label22: TLabel;
Label23: TLabel;
Label24: TLabel;
Edit1: TEdit;
ComboBox1: TComboBox;
Edit2: TEdit;
Edit3: TEdit;
Edit4: TEdit;
Edit5: TEdit;
DateTimePicker1: TDateTimePicker;
ComboBox2: TComboBox;
Edit6: TEdit;
Edit7: TEdit;
Edit8: TEdit;
DateTimePicker2: TDateTimePicker;
Edit9: TEdit;
Edit10: TEdit;
Edit11: TEdit;
Edit12: TEdit;
Edit13: TEdit;
Edit14: TEdit;
Edit15: TEdit;
Edit16: TEdit;
Edit17: TEdit;
Edit18: TEdit;
ComboBox3: TComboBox;
DBGrid1: TDBGrid;
Edit19: TEdit;
Label25: TLabel;
Edit20: TEdit;
Edit21: TEdit;
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 ComboBox1DropDown(Sender: TObject);
procedure ComboBox2DropDown(Sender: TObject);
procedure ComboBox3DropDown(Sender: TObject);
procedure ComboBox1Change(Sender: TObject);
procedure ComboBox2Change(Sender: TObject);
procedure Edit2KeyPress(Sender: TObject; var Key: Char);
procedure Edit6KeyPress(Sender: TObject; var Key: Char);
procedure Edit1KeyPress(Sender: TObject; var Key: Char);
procedure ComboBox1KeyPress(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 DateTimePicker1KeyPress(Sender: TObject; var Key: Char);
procedure ComboBox2KeyPress(Sender: TObject; var Key: Char);
procedure Edit7KeyPress(Sender: TObject; var Key: Char);
procedure Edit8KeyPress(Sender: TObject; var Key: Char);
procedure DateTimePicker2KeyPress(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 Edit12KeyPress(Sender: TObject; var Key: Char);
procedure Edit13KeyPress(Sender: TObject; var Key: Char);
procedure Edit14KeyPress(Sender: TObject; var Key: Char);
procedure Edit15KeyPress(Sender: TObject; var Key: Char);
procedure Edit16KeyPress(Sender: TObject; var Key: Char);
procedure Edit17KeyPress(Sender: TObject; var Key: Char);
procedure ComboBox3KeyPress(Sender: TObject; var Key: Char);
procedure DBGrid1CellClick(Column: TColumn);
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 Edit16Change(Sender: TObject);
procedure Edit17Change(Sender: TObject);
procedure Edit19Change(Sender: TObject);
procedure Edit16Exit(Sender: TObject);
procedure Edit17Exit(Sender: TObject);
procedure DBGrid1DrawColumnCell(Sender: TObject; const Rect: TRect;
DataCol: Integer; Column: TColumn; State: TGridDrawState);
private
{ Private declarations }
public
procedure tr; //去除空字符
procedure bh; //自动编号
procedure bh1;
procedure bh2;
procedure bh3;
Procedure GetAll; //获得所有数据
Procedure Posting; //提交数据
Procedure CLS; //清除控件中内容
Procedure DIS; //控件不可用
Procedure ENA; //控件可用
Function CanSave:Boolean; //判断是否保存
{ Public declarations }
end;
var
FRM_HWSQXX: TFRM_HWSQXX;
implementation
uses UMAIN, UDM;
{$R *.dfm}
procedure TFRM_HWSQXX.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_HWSQXX.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 (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 (Edit20.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 (ComboBox2.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 (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;
if (Edit14.Text='') then
begin
Result:=False;
Application.MessageBox('吨位不能为空！','提示信息',0+MB_ICONINFORMATION);
exit;
end;
if (Edit15.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 (ComboBox3.Text='') then
begin
Result:=False;
Application.MessageBox('所属部门不能为空！','提示信息',0+MB_ICONINFORMATION);
exit;
end;
end;
procedure TFRM_HWSQXX.bh;
var
i:integer;
s,m:string;
begin
s:= 'SQ'+ FormatDateTime('yyyymmdd',Now());
With DM.QHWSQXX do
begin
Close;
SQL.Clear;
SQL.Add('select max(申请编号) as ss From 货物申请信息表');
Open;
end;
If DM.QHWSQXX.FieldByName('ss').Value=null then
s := s + '001'
else
begin
m:= Trim(DM.QHWSQXX.FieldByName('ss').Value) ;
i:= StrToInt(Trim(Copy(m,11,8))) ;
s:= s +Formatfloat('000',i+1);
end;
Edit1.Text := s;
end; /////////////////////////////
procedure TFRM_HWSQXX.bh1;
var
i:integer;
s,m:string;
begin
s:= 'DD'+ FormatDateTime('yyyymmdd',Now());
With DM.QHWSQXX do
begin
Close;
SQL.Clear;
SQL.Add('select max(订单编号) as ss From 货物申请信息表');
Open;
end;
If DM.QHWSQXX.FieldByName('ss').Value=null then
s := s + '001'
else
begin
m:= Trim(DM.QHWSQXX.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;
Edit3.Text := s;
end; //////////////////////////////////////////////
procedure TFRM_HWSQXX.bh2;
var
i:integer;
s,m:string;
begin
s:= 'HT'+ FormatDateTime('yyyymmdd',Now());
With DM.QHWSQXX do
begin
Close;
SQL.Clear;
SQL.Add('select max(合同编号) as ss From 货物申请信息表');
Open;
end;
If DM.QHWSQXX.FieldByName('ss').Value=null then
s := s + '001'
else
begin
m:= Trim(DM.QHWSQXX.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;
Edit4.Text := s;
end;/////////////////////////
procedure TFRM_HWSQXX.bh3;
var
i:integer;
s,m:string;
begin
s:= 'FP'+ FormatDateTime('yyyymmdd',Now());
With DM.QHWSQXX do
begin
Close;
SQL.Clear;
SQL.Add('select max(发票号码) as ss From 货物申请信息表');
Open;
end;
If DM.QHWSQXX.FieldByName('ss').Value=null then
s := s + '001'
else
begin
m:= Trim(DM.QHWSQXX.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;
Edit5.Text := s;
end;/////////////////////////
procedure TFRM_HWSQXX.GetAll;
begin
Edit1.Text:=DM.DSOHWSQXX.FieldByName('申请编号').AsString;
ComboBox1.Text:=DM.DSOHWSQXX.FieldByName('客户编号').AsString;
Edit2.Text:=DM.DSOHWSQXX.FieldByName('客户名称').AsString;
Edit3.Text:=DM.DSOHWSQXX.FieldByName('订单编号').AsString;
Edit4.Text:=DM.DSOHWSQXX.FieldByName('合同编号').AsString;
Edit5.Text:=DM.DSOHWSQXX.FieldByName('发票号码').AsString;
DateTimePicker1.Date:=DM.DSOHWSQXX.FieldByName('开票日期').AsDateTime;
ComboBox2.Text:=DM.DSOHWSQXX.FieldByName('车辆编号').AsString;
Edit6.Text:=DM.DSOHWSQXX.FieldByName('车牌号码').AsString;
Edit7.Text:=DM.DSOHWSQXX.FieldByName('出发地点').AsString;
Edit8.Text:=DM.DSOHWSQXX.FieldByName('目的地点').AsString;
DateTimePicker2.Date:=DM.DSOHWSQXX.FieldByName('出货日期').AsDateTime;
Edit9.Text:=DM.DSOHWSQXX.FieldByName('主件名称').AsString;
Edit10.Text:=DM.DSOHWSQXX.FieldByName('主件数量').AsString;
Edit11.Text:=DM.DSOHWSQXX.FieldByName('体积').AsString;
Edit12.Text:=DM.DSOHWSQXX.FieldByName('附件数量').AsString;
Edit13.Text:=DM.DSOHWSQXX.FieldByName('附件名称').AsString;
Edit14.Text:=DM.DSOHWSQXX.FieldByName('吨位').AsString;
Edit15.Text:=DM.DSOHWSQXX.FieldByName('距离').AsString;
Edit16.Text:=DM.DSOHWSQXX.FieldByName('运费').AsString;
Edit17.Text:=DM.DSOHWSQXX.FieldByName('分送费用').AsString;
Edit18.Text:=DM.DSOHWSQXX.FieldByName('合计金额').AsString;
ComboBox3.Text:=DM.DSOHWSQXX.FieldByName('所属部门').AsString;
Edit19.Text:=DM.DSOHWSQXX.FieldByName('备注').AsString;
Edit20.Text:=DM.DSOHWSQXX.FieldByName('客户电话').AsString;
Edit21.Text:=DM.DSOHWSQXX.FieldByName('联系人').AsString;
end;
procedure TFRM_HWSQXX.Posting;
begin
if ActionCD='N' then
BEGIN
with DM.QHWSQXX do
begin
Close;
SQL.Clear;
SQL.Add('INSERT INTO 货物申请信息表(申请编号,客户编号,客户名称,订单编号,合同编号,发票号码,');
SQL.Add('开票日期,车辆编号,车牌号码,出发地点,目的地点,出货日期,主件名称,主件数量,体积,附件数量,');
SQL.Add('附件名称,吨位,距离,运费,分送费用,合计金额,所属部门,备注,客户电话,联系人)');
SQL.Add('Values(:申请编号,:客户编号,:客户名称,:订单编号,:合同编号,:发票号码,');
SQL.Add(':开票日期,:车辆编号,:车牌号码,:出发地点,:目的地点,:出货日期,:主件名称,:主件数量,:体积,:附件数量,');
SQL.Add(':附件名称,:吨位,:距离,:运费,:分送费用,:合计金额,:所属部门,:备注,:客户电话,:联系人)');
Parameters.Items[0].Value:=Edit1.Text;
Parameters.Items[1].Value:=ComboBox1.Text;
Parameters.Items[2].Value:=Edit2.Text;
Parameters.Items[3].Value:=Edit3.Text;
Parameters.Items[4].Value:=Edit4.Text;
Parameters.Items[5].Value:=Edit5.Text;
DateTimePicker1.Date:=Date();
Parameters.Items[6].Value:=FormatDateTime('yyyy-mm-dd',DateTimePicker1.Date);
Parameters.Items[7].Value:=ComboBOx2.Text;
Parameters.Items[8].Value:=Edit6.Text;
Parameters.Items[9].Value:=Edit7.Text;
Parameters.Items[10].Value:=Edit8.Text;
DateTimePicker2.Date:=Date();
Parameters.Items[11].Value:=FormatDateTime('yyyy-mm-dd',DateTimePicker2.Date);
Parameters.Items[12].Value:=Edit9.Text;
Parameters.Items[13].Value:=Edit10.Text;
Parameters.Items[14].Value:=Edit11.Text;
Parameters.Items[15].Value:=Edit12.Text;
Parameters.Items[16].Value:=Edit13.Text;
Parameters.Items[17].Value:=Edit14.Text;
Parameters.Items[18].Value:=Edit15.Text;
Parameters.Items[19].Value:=Edit16.Text;
Parameters.Items[20].Value:=Edit17.Text;
Parameters.Items[21].Value:=Edit18.Text;
Parameters.Items[22].Value:=ComboBox3.Text;
Parameters.Items[23].Value:=Edit19.Text;
Parameters.Items[24].Value:=Edit20.Text;
Parameters.Items[25].Value:=Edit21.Text;
Prepared:=True;
ExecSQL;
end;
END else
if ActionCD='M' then
begin
With DM.QHWSQXX DO
begin
Close;
SQL.Clear;
SQL.Add('update 货物申请信息表 Set 客户编号=:客户编号1,客户名称=:客户名称1,');
SQL.Add('订单编号=:订单编号1,合同编号=:合同编号1,发票号码=:发票号码1,开票日期=:开票日期1,');
SQL.Add('车辆编号=:车辆编号1,车牌号码=:车牌号码1,出发地点=:出发地点1,目的地点=:目的地点1,');
SQL.Add('出货日期=:出货日期1,主件名称=:主件名称1,主件数量=:主件数量1,体积=:体积1,');
SQL.Add('附件数量=:附件数量1,附件名称=:附件名称1,吨位=:吨位1,距离=:距离1,');
SQL.Add('运费=:运费1,分送费用=:分送费用1,合计金额=:合计金额1,所属部门=:所属部门1,');
SQL.Add('备注=:备注1,客户电话=:客户电话1,联系人=:联系人1 where 申请编号=:申请编号1');
Parameters.Items[0].Value:=ComboBox1.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;
DateTimePicker1.Date:=Date();
Parameters.Items[5].Value:=FormatDateTime('yyyy-mm-dd',DateTimePicker1.Date);
Parameters.Items[6].Value:=ComboBox2.Text;
Parameters.Items[7].Value:=Edit6.Text;
Parameters.Items[8].Value:=Edit7.Text;
Parameters.Items[9].Value:=Edit8.Text;
DateTimePicker2.Date:=Date();
Parameters.Items[10].Value:=FormatDateTime('yyyy-mm-dd',DateTimePicker2.Date);
Parameters.Items[11].Value:=Edit9.Text;
Parameters.Items[12].Value:=Edit10.Text;
Parameters.Items[13].Value:=Edit11.Text;
Parameters.Items[14].Value:=Edit12.Text;
Parameters.Items[15].Value:=Edit13.Text;
Parameters.Items[16].Value:=Edit14.Text;
Parameters.Items[17].Value:=Edit15.Text;
Parameters.Items[18].Value:=Edit16.Text;
Parameters.Items[19].Value:=Edit17.Text;
Parameters.Items[20].Value:=Edit18.Text;
Parameters.Items[21].Value:=ComboBox3.Text;
Parameters.Items[22].Value:=Edit19.Text;
Parameters.Items[23].Value:=Edit20.Text;
Parameters.Items[24].Value:=Edit21.Text;
Parameters.Items[25].Value:=DM.DSOHWSQXX.FieldByName('申请编号').AsString;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -