能不能将这些过程减缩成一个过程,它的功能,其实就是在ComBobox中显示出查找的内容而已。
procedure TCarderQueryForm.ShowCarderType;
begin
with DM.QueCarderQuery do
begin
Close;
SQL.Clear;
SQL.Add('select ztypename from zidlookup where ztypeid>103700 and ztypeid<103800 Order by ztypeid Asc');
Open;
end; if Not IsEmpty then
begin
First;
TempList:=TStrings.Create;
TempList.Clear;
while Not Eof do
begin
TempList.Add(Fields[0].AsString);
Next;
end;
ComBobox1.Items:=TempList;
end;
end;procedure TCarderQueryForm.ShowCarderNation;
begin
with DM.QueCarderQuery do
begin
Close;
SQL.Clear;
SQL.Add('select ztypename from zidlookup where ztypeid>100100 and ztypeid<100200 Order by ztypeid Asc');
Open;
end; if Not IsEmpty then
begin
First;
TempList:=TStrings.Create;
TempList.Clear;
while Not Eof do
begin
TempList.Add(Fields[0].AsString);
Next;
end;
ComBobox2.Items:=TempList;
end;
end;procedure TCarderQueryForm.ShowCarderProvince;
begin
with DM.QueCarderQuery do
begin
Close;
SQL.Clear;
SQL.Add('select ztypename from zidlookup where ztypeid>100200 and ztypeid<100300 Order by ztypeid Asc');
Open;
end; if Not IsEmpty then
begin
First;
TempList:=TStrings.Create;
TempList.Clear;
while Not Eof do
begin
TempList.Add(Fields[0].AsString);
Next;
end;
ComBobox3.Items:=TempList;
end;
end;procedure TCarderQueryForm.ShowCarderCounty;
begin
with DM.QueCarderQuery do
begin
Close;
SQL.Clear;
SQL.Add('select ztypename from zidlookup where ztypeid<100400 and ztypeid>100300 Order by ztypeid Asc');
Open;
end;
if Not IsEmpty then
begin
First;
TempList:=TStrings.Create;
TempList.Clear;
while Not Eof do
begin
TempList.Add(Fields[0].AsString);
Next;
end;
ComBobox4.Items:=TempList;
end;
end;
procedure TCarderQueryForm.ShowCarderType;
begin
with DM.QueCarderQuery do
begin
Close;
SQL.Clear;
SQL.Add('select ztypename from zidlookup where ztypeid>103700 and ztypeid<103800 Order by ztypeid Asc');
Open;
end; if Not IsEmpty then
begin
First;
TempList:=TStrings.Create;
TempList.Clear;
while Not Eof do
begin
TempList.Add(Fields[0].AsString);
Next;
end;
ComBobox1.Items:=TempList;
end;
end;procedure TCarderQueryForm.ShowCarderNation;
begin
with DM.QueCarderQuery do
begin
Close;
SQL.Clear;
SQL.Add('select ztypename from zidlookup where ztypeid>100100 and ztypeid<100200 Order by ztypeid Asc');
Open;
end; if Not IsEmpty then
begin
First;
TempList:=TStrings.Create;
TempList.Clear;
while Not Eof do
begin
TempList.Add(Fields[0].AsString);
Next;
end;
ComBobox2.Items:=TempList;
end;
end;procedure TCarderQueryForm.ShowCarderProvince;
begin
with DM.QueCarderQuery do
begin
Close;
SQL.Clear;
SQL.Add('select ztypename from zidlookup where ztypeid>100200 and ztypeid<100300 Order by ztypeid Asc');
Open;
end; if Not IsEmpty then
begin
First;
TempList:=TStrings.Create;
TempList.Clear;
while Not Eof do
begin
TempList.Add(Fields[0].AsString);
Next;
end;
ComBobox3.Items:=TempList;
end;
end;procedure TCarderQueryForm.ShowCarderCounty;
begin
with DM.QueCarderQuery do
begin
Close;
SQL.Clear;
SQL.Add('select ztypename from zidlookup where ztypeid<100400 and ztypeid>100300 Order by ztypeid Asc');
Open;
end;
if Not IsEmpty then
begin
First;
TempList:=TStrings.Create;
TempList.Clear;
while Not Eof do
begin
TempList.Add(Fields[0].AsString);
Next;
end;
ComBobox4.Items:=TempList;
end;
end;
解决方案 »
- 如何像百度这样,输入字符,显示相关内容
- delphi 中的cxDBDateEdit能否设置成显示yyyy-mm的形式
- 客户端要给数据库服务器上保存照片,有什么合适的方法?
- 如何让TEdit支持不同的颜色显示?
- 如何把菜单做到Coolbar中
- batchmove不copy索引文件,但是索引文件也不能直接copy给已经改了名的dbf文件,请问有何简单解决方法?
- delphi的程序运行时任务栏为'Proj',可以改成'电脑管理系统'吗?
- TDataBase怎么连接SQL Server服务器?
- 请问如何在active form 上加入程序菜单?
- 这段代码到底错在那里?
- 如何将这些函数减缩成一个函数?(高手请救)
- 新手问题:
begin
with DM.QueCarderQuery do
begin
Close;
SQL.Clear;
SQL.Add('select ztypename from zidlookup '+SQLCondition);
Open;
end; if Not IsEmpty then
begin
First;
TempList:=TStrings.Create;
TempList.Clear;
while Not Eof do
begin
TempList.Add(Fields[0].AsString);
Next;
end;
ComBobox.Items:=TempList;
TempList.fRee;
end;