dByName('shuxian').AsString := getpet(yearof(edtbirth.EditValue));
end;
// cmbxingzuo.text:=getxingzuo(edtbirth.EditValue);
// cmbsx.text:=getpet(yearof(edtbirth.EditValue));
end
else
begin
cmbxingzuo.text := '';
cmbsx.text := '';
end;
end;
procedure Tfrmregister.cmbszqyPropertiesChange(Sender: TObject);
var
bm: string;
begin
Dm1.adoqry1.Close;
Dm1.adoqry1.sql.Clear;
Dm1.adoqry1.sql.Text := 'select * from city where city=''' + cmbszqy.Text + '''';
dm1.adoqry1.Open;
bm := IntToStr(dm1.adoqry1.fieldbyname('bm').asinteger);
Dm1.adoqry1.Close;
cmbcity.Text := '';
if bm = '' then
begin
cmbcity.Properties.Items.Clear;
Exit;
end;
Dm1.adoqry1.sql.Clear;
Dm1.adoqry1.sql.Text := 'select * from city where pbm=' + bm;
dm1.adoqry1.Open;
Dm1.adoqry1.first;
cmbcity.Properties.Items.Clear;
while not dm1.adoqry1.Eof do
begin
cmbcity.Properties.Items.Append(Dm1.adoqry1.fieldbyname('city').asstring);
Dm1.adoqry1.Next;
end;
Dm1.adoqry1.Close;
end;
procedure Tfrmregister.Panel1Click(Sender: TObject);
begin
type
Tfrmmemo = class(TForm)
Label1: TLabel;
cxButton1: TcxButton;
memo1: TcxDBMemo;
cxButton2: TcxButton;
procedure cxButton1Click(Sender: TObject);
procedure cxButton2Click(Sender: TObject);
procedure FormClose(Sender: TObject; var Action: TCloseAction);
private
{ Private declarations }
public
{ Public declarations }
end;
var
frmmemo: Tfrmmemo;
implementation
uses md;
{$R *.dfm}
procedure Tfrmmemo.cxButton1Click(Sender: TObject);
begin
if dm1.qrymemo.State in [dsInsert, dsEdit] then
Dm1.qrymemo.Post;
dm1.qrymemo.close;
close;
end;
procedure Tfrmmemo.cxButton2Click(Sender: TObject);
begin
if dm1.qrymemo.State in [dsInsert, dsEdit] then
begin
Dm1.qrymemo.Post;
end;
Dm1.qrymemo.Edit;
end;
procedure Tfrmmemo.FormClose(Sender: TObject; var Action: TCloseAction);
begin
Action := caFree;
end;