lyxxlr.~pas

地理资源的录入程序运用了api的一些知识

unit lyxxlr;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DBCtrls, StdCtrls,PublicFunction, Buttons, Grids, DBGrids,
  ComCtrls, ExtCtrls,ADODB,DB,extdlgs ,DataM,ToolWin,mask,comobj;

type
 TCustomDBGridCracker=class(TCustomDBGrid);
  Tlyzylrfrm = class(TForm)
    Panel1: TPanel;
    Label2: TLabel;
    Label10: TLabel;
    Label8: TLabel;
    Label5: TLabel;
    Label23: TLabel;
    Label3: TLabel;
    Label18: TLabel;
    Label21: TLabel;
    Label22: TLabel;
    Label20: TLabel;
    Label14: TLabel;
    Label12: TLabel;
    Label11: TLabel;
    ZYPTBH: TEdit;
    qw: TEdit;
    GM: TEdit;
    zl: TComboBox;
    jjnd: TEdit;
    SYQ: TEdit;
    bhzk: TEdit;
    qtd: TMemo;
    mxjz: TMemo;
    kxjz: TMemo;
    jj: TMemo;
    jdzhqk: TMemo;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    BitBtn3: TBitBtn;
    BitBtn4: TBitBtn;
    BitBtn5: TBitBtn;
    BitBtn6: TBitBtn;
    DBNavigator1: TDBNavigator;
    Panel4: TPanel;
    DBGrid1: TDBGrid;
    zybm: TComboBox;
    Label6: TLabel;
    yl: TComboBox;
    Label7: TLabel;
    jblx: TEdit;
    Label4: TLabel;
    MC: TEdit;
    Label9: TLabel;
    jb: TEdit;
    Label13: TLabel;
    ZMD: TComboBox;
    Label16: TLabel;
    SJ: TEdit;
    Label17: TLabel;
    DD: TEdit;
    Label15: TLabel;
    CYZ: TEdit;
    Label19: TLabel;
    rwnh: TMemo;
    Label1: TLabel;
    Label24: TLabel;
    Panel2: TPanel;
    ts1: TEdit;
    ts2: TEdit;
    Panel3: TPanel;
    imgi1: TImage;
    Panel5: TPanel;
    imgi2: TImage;
    odimg: TOpenDialog;
    odimg1: TOpenDialog;
    btnok: TBitBtn;
    Panel6: TPanel;
    t3: TBitBtn;
    t2: TButton;
    t4: TBitBtn;
    t5: TButton;
    Panel7: TPanel;
    BitBtn8: TBitBtn;
    BitBtn9: TBitBtn;
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure BitBtn4Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
    procedure BitBtn5Click(Sender: TObject);
    procedure DBGrid1DblClick(Sender: TObject);
    procedure DBGrid1DrawColumnCell(Sender: TObject; const Rect: TRect;
      DataCol: Integer; Column: TColumn; State: TGridDrawState);
    procedure BitBtn6Click(Sender: TObject);
    procedure DBNavigator1Click(Sender: TObject; Button: TNavigateBtn);
    procedure zlDropDown(Sender: TObject);
    procedure zlSelect(Sender: TObject);
    procedure zybmDropDown(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure MCKeyPress(Sender: TObject; var Key: Char);
    procedure ylSelect(Sender: TObject);
    procedure jblxKeyPress(Sender: TObject; var Key: Char);
    procedure GMKeyPress(Sender: TObject; var Key: Char);
    procedure jbKeyPress(Sender: TObject; var Key: Char);
    procedure jjndKeyPress(Sender: TObject; var Key: Char);
    procedure t1Click(Sender: TObject);
    procedure t2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure t5Click(Sender: TObject);
    procedure t3Click(Sender: TObject);
    procedure t4Click(Sender: TObject);
    procedure qwKeyPress(Sender: TObject; var Key: Char);
    procedure ZMDSelect(Sender: TObject);
    procedure CYZKeyPress(Sender: TObject; var Key: Char);
    procedure DDKeyPress(Sender: TObject; var Key: Char);
    procedure SJKeyPress(Sender: TObject; var Key: Char);
    procedure SYQKeyPress(Sender: TObject; var Key: Char);
    procedure btnokClick(Sender: TObject);
     procedure ENA; // 新增记录的时候使所有的控件可用
    procedure DIS; // 保存记录后使所有的控件不可用
    procedure automaticno;
    procedure CLS; //  清除控件中的所有的内容
    procedure GetAll;
    procedure BitBtn8Click(Sender: TObject);
    procedure BitBtn9Click(Sender: TObject);
    procedure zlKeyPress(Sender: TObject; var Key: Char);
    procedure ylKeyPress(Sender: TObject; var Key: Char);  //取得所有的数据
  private
   
    { Private declarations }
  public
    { Public declarations }
  end;

var
  lyzylrfrm: Tlyzylrfrm;
  ActionCD,hebpth,tpsc: string;
  year, month, day: word;
implementation

uses ly_Unit,main, loc_Unit;

{$R *.dfm}
procedure Tlyzylrfrm.automaticno;
var m:String;
     i:integer;
    queryc:TADOQuery;
begin
   i:=0;
  hebpth:='';
  queryc:=TADOQuery.Create(self);
  queryc.Connection:=DataM.dm.conn;
  queryc.SQL.Text := 'select max(Z_PTZYBH) as p  from T_Geo_tour' ;
  queryc.open;
  queryc.Close;
  queryc:=TADOQuery.Create(self);
  queryc.Connection:=DataM.dm.conn;
  queryc.SQL.Text := 'select *  from T_Geo_tour' ;
  queryc.open;
  if  queryc.Eof then
    hebpth:='4101C00070'+'00000001'
  else
  begin
  DataM.DM.lyxx.Last;
  m:=DataM.DM.lyxx.FieldValues['Z_PTZYBH'];
  i:=StrToInt(Trim(copy(m,11,8)));
  if i< 9 then
  hebpth:='4101C00070'+'0000000'+IntToStr(i+1)
  else if i<99 then
  hebpth:='4101C00070'+'000000'+IntToStr(i+1)
  else if i<999 then
  hebpth:='4101C00070'+'00000'+IntToStr(i+1)
  else if i<9999 then
  hebpth:='4101C00070'+'0000'+IntToStr(i+1)
  else if i<99999 then
  hebpth:='4101C00070'+'000'+IntToStr(i+1)
  else if i<999999 then
  hebpth:='4101C00070'+'00'+IntToStr(i+1)
  else if i<9999999 then
  hebpth:='4101C00070'+'0'+IntToStr(i+1)
  else
  hebpth:='4101C00070'+IntToStr(i+1);
  end;
  queryc.Close;
end;
procedure Tlyzylrfrm.ENA; // 新增记录的时候使所有的控件可用
var
  i: Integer;
begin


     for i := ComponentCount - 1 downto 0 do
  begin
    if (components[i] is TEdit) then
    begin // 使所有的TEdit控件可用
      TEdit(components[i]).Color := clwindow;
      TEdit(components[i]).ReadOnly := false;
    end; //   使所有的Tcombobox控件可用
    if (components[i] is Tcombobox) then
      begin
      Tcombobox(components[i]).Color := clwindow;
      Tcombobox(components[i]).Enabled :=true;
      end;
      if (components[i] is TMemo) then
       begin
      Tmemo(components[i]).Color := clwindow;
      Tmemo(components[i]).ReadOnly :=false;
      end;
  end;    
  zyptbh.Enabled := False;
  BitBtn2.Enabled := False; //  '编辑'不可用
  BitBtn3.Enabled := True; //  '储存'可用
  BitBtn4.Enabled := True; //  '取消'可用
  BitBtn6.Enabled := False; //   '关闭'不可用
end;


procedure Tlyzylrfrm.DIS; // 新增记录的时候使所有的控件不可用
var
  i: Integer;
begin
  for i := ComponentCount - 1 downto 0 do
  begin // 使所有的TEdit控件不可用
    if (components[i] is TEdit) then
    begin //  改变TEdit控件的颜色
      TEdit(components[i]).Color := $00D8D8D8;
      TEdit(components[i]).ReadOnly := true;
    end; //   使所有的Tcombobox控件不可用
    if (components[i] is Tcombobox) then
      begin
      //  改变Tcombobox控件的颜色
      Tcombobox(components[i]).Color := $00D8D8D8;
      Tcombobox(components[i]).Enabled :=false;
      end;
     if (components[i] is TMemo ) then
       begin
       tmemo(components[i]).color := $00D8D8D8;
       Tmemo(components[i]).ReadOnly  :=true;
       end;
  end;
  zyptbh.Enabled := True;
  bitbtn2.Enabled := True; //  '编辑'可用
  bitbtn3.Enabled := False; //  '储存'不可用
  bitbtn4.Enabled := False; //  '取消'不可用
  BitBtn6.Enabled := True; //   '关闭'可用
  zyptbh.Color := clwindow;
  zyptbh.ReadOnly := true;
end;


procedure Tlyzylrfrm.CLS;
var
  i: Integer;
begin
  for i := ComponentCount - 1 downto 0 do
  begin // 清除所有的TEdit控件的内容
    if (Components[i] is TEDIT) then
      TEDIT(components[i]).Clear;
       if (components[i] is TMemo )then
        tmemo(components[i]).clear;
        if (components[i] is Tcombobox) then
         Tcombobox(components[i]).Text :='';
  end;
end;

procedure Tlyzylrfrm.GetAll;
var hebpthimg1 ,hebpthimg2:string;
   zlstr:string;
   ylstr:string;
   get_Q:TADOQuery;
   a,c:Integer;
begin
ena;
  ZYPTBH.Text := DM.lyxx.Fieldbyname('Z_PTZYbh').AsString;
  zybm.Text := DM.lyxx.Fieldbyname('Z_zybm').AsString;
  mc.Text := DM.lyxx.Fieldbyname('Z_mc').AsString;
  zlstr := DM.lyxx.Fieldbyname('Z_zl').AsString;

       begin
        get_Q:=TADOQuery.Create(self);
        get_Q.Connection:=dm.conn;
        a:=StrToInt(zlstr);
        get_Q.SQL.add('select * from t_dmb where z_dmbm=b and t_dmb.z_dmlxbm=3');
        get_q.Parameters.ParamByName('b').Value:=a;
        get_Q.open;
        zl.Text:=trim(get_Q.FieldValues['z_dmmc']);
        get_Q.Close;
      end;


  if DM.lyxx.Fieldbyname('Z_zl').AsString='1' then
  begin
       ylstr:= DM.lyxx.Fieldbyname('Z_yl').AsString;
        get_Q:=TADOQuery.Create(self);
        get_Q.Connection:=dm.conn;
        c:=strtoint(ylstr);

        get_Q.SQL.Text := 'select z_dmmc from t_dmb where t_dmb.z_dmbm=g and t_dmb.z_dmlxbm=4';
        get_q.Parameters.ParamByName('g').Value:=c;
        get_Q.open;
        yl.Text:=trim(get_Q.FieldValues['z_dmmc']);
        get_Q.Close;
  end
  else
     if DM.lyxx.Fieldbyname('Z_zl').AsString='2' then
  begin
       ylstr:= DM.lyxx.Fieldbyname('Z_yl').AsString;
        get_Q:=TADOQuery.Create(self);
        get_Q.Connection:=dm.conn;
        c:=strtoint(ylstr);

        get_Q.SQL.Text := 'select z_dmmc from t_dmb where t_dmb.z_dmbm=g and t_dmb.z_dmlxbm=5';
        get_q.Parameters.ParamByName('g').Value:=c;
        get_Q.open;
        yl.Text:=trim(get_Q.FieldValues['z_dmmc']);
        get_Q.Close;
  end
  else
    if DM.lyxx.Fieldbyname('Z_zl').AsString='3' then
  begin
       ylstr:= DM.lyxx.Fieldbyname('Z_yl').AsString;
        get_Q:=TADOQuery.Create(self);
        get_Q.Connection:=dm.conn;
        c:=strtoint(ylstr);

        get_Q.SQL.Text := 'select z_dmmc from t_dmb where t_dmb.z_dmbm=g and t_dmb.z_dmlxbm=6';
        get_q.Parameters.ParamByName('g').Value:=c;
        get_Q.open;
        yl.Text:=trim(get_Q.FieldValues['z_dmmc']);
        get_Q.Close;
  end
  else
    if DM.lyxx.Fieldbyname('Z_zl').AsString='4' then
  begin
       ylstr:= DM.lyxx.Fieldbyname('Z_yl').AsString;
        get_Q:=TADOQuery.Create(self);
        get_Q.Connection:=dm.conn;
        c:=strtoint(ylstr);

        get_Q.SQL.Text := 'select z_dmmc from t_dmb where t_dmb.z_dmbm=g and t_dmb.z_dmlxbm=7';
        get_q.Parameters.ParamByName('g').Value:=c;
        get_Q.open;
        yl.Text:=trim(get_Q.FieldValues['z_dmmc']);
        get_Q.Close;
  end
  else
    if DM.lyxx.Fieldbyname('Z_zl').AsString='5' then
  begin
       ylstr:= DM.lyxx.Fieldbyname('Z_yl').AsString;
        get_Q:=TADOQuery.Create(self);
        get_Q.Connection:=dm.conn;
        c:=strtoint(ylstr);

        get_Q.SQL.Text := 'select z_dmmc from t_dmb where t_dmb.z_dmbm=g and t_dmb.z_dmlxbm=8';
        get_q.Parameters.ParamByName('g').Value:=c;
        get_Q.open;
        yl.Text:=trim(get_Q.FieldValues['z_dmmc']);