You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
115 lines
2.6 KiB
Plaintext
115 lines
2.6 KiB
Plaintext
unit u_info_tell_query;
|
|
|
|
interface
|
|
|
|
uses
|
|
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
|
|
Dialogs, BusinessSkinForm, wwdbdatetimepicker, wwdblook, StdCtrls,
|
|
bsSkinCtrls, Mask, wwdbedit, Wwdotdot, Wwdbcomb;
|
|
|
|
type
|
|
Tfrm_info_tell_query = class(TForm)
|
|
Label1: TLabel;
|
|
Label3: TLabel;
|
|
Label4: TLabel;
|
|
Label5: TLabel;
|
|
bsSkinButton10: TbsSkinButton;
|
|
bsSkinButton5: TbsSkinButton;
|
|
Edit1: TEdit;
|
|
d1: TwwDBDateTimePicker;
|
|
d2: TwwDBDateTimePicker;
|
|
bsBusinessSkinForm1: TbsBusinessSkinForm;
|
|
Label2: TLabel;
|
|
wwDBComboBox1: TwwDBComboBox;
|
|
wwDBComboBox2: TwwDBComboBox;
|
|
procedure bsSkinButton5Click(Sender: TObject);
|
|
procedure bsSkinButton10Click(Sender: TObject);
|
|
procedure Edit1KeyPress(Sender: TObject; var Key: Char);
|
|
private
|
|
{ Private declarations }
|
|
public
|
|
{ Public declarations }
|
|
end;
|
|
|
|
var
|
|
frm_info_tell_query: Tfrm_info_tell_query;
|
|
|
|
implementation
|
|
|
|
uses u_info_tell_manage, my_sys_function, u_main;
|
|
|
|
{$R *.dfm}
|
|
|
|
procedure Tfrm_info_tell_query.bsSkinButton5Click(Sender: TObject);
|
|
begin
|
|
close;
|
|
end;
|
|
|
|
procedure Tfrm_info_tell_query.bsSkinButton10Click(Sender: TObject);
|
|
var
|
|
str:widestring;
|
|
begin
|
|
str:=' where 录入人='+''''+employee+'''';
|
|
if Edit1.text<>''then
|
|
begin
|
|
if str='' then
|
|
str:=' where 提醒事件 like '+''''+'%'+edit1.text+'%'+''''
|
|
else
|
|
str:=str+' and 提醒事件 like '+''''+'%'+edit1.text+'%'+'''';
|
|
end;
|
|
|
|
if d1.text<>''then
|
|
begin
|
|
if str='' then
|
|
str:=' where 提醒时间>='+''''+d1.text+''''
|
|
else
|
|
str:=str+' and 提醒时间>='+''''+d1.text+'''';
|
|
end;
|
|
if d2.text<>''then
|
|
begin
|
|
if str='' then
|
|
str:=' where 提醒时间<='+''''+d2.text+''''
|
|
else
|
|
str:=str+' and 提醒时间<='+''''+d2.text+'''';
|
|
end;
|
|
|
|
if wwDBComboBox2.text<>''then
|
|
begin
|
|
if str='' then
|
|
str:=' where 提醒类型='+''''+wwDBComboBox2.text+''''
|
|
else
|
|
str:=str+' and 提醒类型='+''''+wwDBComboBox2.text+'''';
|
|
end;
|
|
|
|
if wwDBComboBox1.text<>''then
|
|
begin
|
|
if str='' then
|
|
str:=' where 是否知道='+inttostr(wwDBComboBox1.ItemIndex)
|
|
else
|
|
str:=str+' and 是否知道='+inttostr(wwDBComboBox1.ItemIndex);
|
|
end;
|
|
|
|
|
|
str:='select * from t_info_tell'+str+' order by 提醒时间';
|
|
|
|
table_query(frm_info_tell_manage.t_info_tell,str);
|
|
if frm_info_tell_manage.t_info_tell.IsEmpty then
|
|
begin
|
|
showmessage('没有检索出信息！！');
|
|
exit;
|
|
end;
|
|
close;
|
|
end;
|
|
|
|
procedure Tfrm_info_tell_query.Edit1KeyPress(Sender: TObject;
|
|
var Key: Char);
|
|
begin
|
|
if key=#13 then
|
|
begin
|
|
key:=#0;
|
|
frm_info_tell_query.bsSkinButton10Click(Sender);
|
|
end;
|
|
end;
|
|
|
|
end.
|