📄 ucxlxr.pas
字号:
unit ucxlxr;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, StdCtrls, ExtCtrls, DB, DBTables, Buttons, Grids, DBGrids, ADODB;
type
Tfrmcxlxr = class(TForm)
Shape1: TShape;
Label4: TLabel;
Shape2: TShape;
Label1: TLabel;
Label2: TLabel;
Edit1: TEdit;
Edit2: TEdit;
Label3: TLabel;
SpeedButton1: TSpeedButton;
DBGrid1: TDBGrid;
Shape3: TShape;
DataSource1: TDataSource;
SpeedButton2: TSpeedButton;
Qcxlxr: TADOQuery;
procedure SpeedButton1Click(Sender: TObject);
procedure SpeedButton2Click(Sender: TObject);
procedure Shape1MouseDown(Sender: TObject; Button: TMouseButton;
Shift: TShiftState; X, Y: Integer);
procedure DBGrid1DblClick(Sender: TObject);
procedure FormCreate(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;
var
frmcxlxr: Tfrmcxlxr;
implementation
uses udb,udxxj;
{$R *.dfm}
procedure Tfrmcxlxr.SpeedButton1Click(Sender: TObject);
var
sqlstr:string;
begin
//首先分析用来查询的条件否为空;
sqlstr:='';
sqlstr:=' ((name like ''%'+edit1.text+'%'') and( telsj like ''%'+edit2.text+'%''))';
sqlstr:='select * from txl,fz where (txl.fzid=fz.fzid) and'+sqlstr;
runsql(qcxlxr,sqlstr);
end;
procedure Tfrmcxlxr.SpeedButton2Click(Sender: TObject);
begin
close;
end;
procedure Tfrmcxlxr.Shape1MouseDown(Sender: TObject; Button: TMouseButton;
Shift: TShiftState; X, Y: Integer);
begin
if button=mbleft then
begin
releasecapture;
perform(wm_syscommand,$f012,0);
end;
end;
procedure Tfrmcxlxr.DBGrid1DblClick(Sender: TObject);
//把当前双击的选中的列的手机号的内容赋值给“新建短信的窗口”
begin
if ((qcxlxr.RecordCount >0) and (dbgrid1.selectedindex=0)) then
begin
//开始组短信新建窗口写收信人的手机号
frmdxxj:=Tfrmdxxj.Create(nil);
frmdxxj.Edit2.Text:=qcxlxr.fieldbyname('name').AsString;
frmcxlxr.Close;
frmdxxj.Show;
//结束写手机号;
end;
end;
procedure Tfrmcxlxr.FormCreate(Sender: TObject);
begin
SpeedButton1.Click;
end;
end.
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -