?? htlx.pas
字號:
unit htlx;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, DB, Grids, DBGrids, StdCtrls, ExtCtrls, Buttons, ComCtrls,
ToolWin;
type
Thtlxfrm = class(TForm)
CoolBar1: TCoolBar;
ToolBar1: TToolBar;
SpeedButton1: TSpeedButton;
SpeedButton2: TSpeedButton;
SpeedButton3: TSpeedButton;
SpeedButton4: TSpeedButton;
SpeedButton5: TSpeedButton;
Panel1: TPanel;
GroupBox1: TGroupBox;
Label1: TLabel;
Edit1: TEdit;
DBGrid1: TDBGrid;
DataSource1: TDataSource;
procedure FormShow(Sender: TObject);
procedure DBGrid1CellClick(Column: TColumn);
procedure SpeedButton1Click(Sender: TObject);
procedure SpeedButton2Click(Sender: TObject);
procedure SpeedButton3Click(Sender: TObject);
procedure SpeedButton4Click(Sender: TObject);
procedure SpeedButton5Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
m:integer;
end;
const
m=0;
var
htlxfrm: Thtlxfrm;
implementation
{$R *.dfm}
uses dbdata;
procedure Thtlxfrm.FormShow(Sender: TObject);
begin
with data.ADOQYhtlx do
begin
close;
sql.Clear;
sql.Add('select * from 合同類型表');
open;
end;
data.ADOQYhtlx.Active:=true;
if data.ADOQYhtlx.FieldByName('合同類型').Value=null then
application.MessageBox('數據庫中沒有數據,請添加數據!','提示',64);
end;
procedure Thtlxfrm.DBGrid1CellClick(Column: TColumn);
begin
If DBGrid1.DataSource.DataSet<> Nil then
if DBGrid1.DataSource.DataSet.RecordCount>0 then
edit1.Text:=data.ADOQYhtlx.FieldByName('合同類型').Value
end;
procedure Thtlxfrm.SpeedButton1Click(Sender: TObject);
begin
if trim(edit1.Text)<>'' then
begin
with data.ADOpublic do
begin
close;
sql.Clear;
sql.Add('select * from 合同類型表 where 合同類型=:a');
parameters.ParamByName('a').Value:=trim(edit1.Text);
open;
end;
if data.ADOpublic.RecordCount>0 then
begin
application.MessageBox('信息不能重復','提示',64);
edit1.Clear;
edit1.SetFocus;
end
else
begin
with data.ADOQYhtlx do
begin
edit;
fieldbyname('合同類型').Value:=trim(edit1.Text);
post
end;
application.MessageBox('修改成功','提示',64);
edit1.Clear;
end;
end
else
application.MessageBox('信息不能為空','提示',64);
end;
procedure Thtlxfrm.SpeedButton2Click(Sender: TObject);
begin
with data.ADOQYhtgl do
begin
close;
sql.Clear;
sql.Add('select 合同類型 from 合同表 where 合同類型 = :a');
parameters.ParamByName('a').Value:=trim(edit1.Text);
open;
end;
if data.ADOQYhtgl.RecordCount>0 then
application.MessageBox('此信息已經使用,不能刪除!','警告',64)
else
if messagebox(self.Handle,'真的要刪除嗎?','提示',mb_yesno+mb_iconquestion)=idyes then
begin
data.ADOQYhtlx.Delete;
edit1.Clear;
end;
end;
procedure Thtlxfrm.SpeedButton3Click(Sender: TObject);
begin
if trim(edit1.Text)<>'' then
try
with data.ADOQYhtlx do
begin
close;
sql.Clear;
sql.Add('insert 合同類型表 values (:a)');
parameters.ParamByName('a').Value:=trim(edit1.Text);
execsql;
end;
edit1.Clear;
self.OnShow(sender);
application.MessageBox('添加成功','提示',64);
except
application.MessageBox('系統出錯!','提示',64);
end
else
application.MessageBox('請輸入合同類型','提示',64);
end;
procedure Thtlxfrm.SpeedButton4Click(Sender: TObject);
begin
edit1.Clear
end;
procedure Thtlxfrm.SpeedButton5Click(Sender: TObject);
begin
close;
end;
end.
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -