📄 monitordm.pas
字号:
unit MonitorDM;
interface
uses
Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
Db, ADODB;
type
TDMMain = class(TDataModule)
tblEvent: TADOTable;
cnnMain: TADOConnection;
tblRecPerson: TADOTable;
tblRecPersonID: TAutoIncField;
tblRecPersonname: TWideStringField;
tblRecPersonphone_no: TWideStringField;
procedure tblRecPersonBeforePost(DataSet: TDataSet);
private
{ Private declarations }
public
{ Public declarations }
end;
var
DMMain: TDMMain;
implementation
{$R *.DFM}
procedure TDMMain.tblRecPersonBeforePost(DataSet: TDataSet);
var
mPhone:string;
begin
if (DataSet.State <> dsEdit)
and (DataSet.State <> dsInsert) then
Exit;
//插入和编辑时检查号码的长度
mPhone := DataSet.FieldByName('phone_no').AsString;
case Length(mPhone) of
9 : mPhone := '+8613' + mPhone;
11: mPhone := '+86' + mPhone;
else raise Exception.Create('电话号码输入错误!');
end;
DataSet.FieldByName('phone_no').AsString := mPhone;
end;
end.
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -