tdly.pas

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

unit tdly;

interface

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

type
  TCustomDBGridCracker=class(TCustomDBGrid);
  Ttdlyxxfrm = class(TForm)
    Panel2: TPanel;
    Panel3: TPanel;
    Label50: TLabel;
    Label51: TLabel;
    Label30: TLabel;
    Label37: TLabel;
    Label44: TLabel;
    Label29: TLabel;
    Label36: TLabel;
    Label31: TLabel;
    Label46: TLabel;
    Label34: TLabel;
    Label45: TLabel;
    Label32: TLabel;
    Label33: TLabel;
    Label43: TLabel;
    Label35: TLabel;
    Label48: TLabel;
    Label39: TLabel;
    Label42: TLabel;
    Label49: TLabel;
    Label38: TLabel;
    Label40: TLabel;
    lable2: TLabel;
    Label9: TLabel;
    Label8: TLabel;
    Label7: TLabel;
    Label6: TLabel;
    Label5: TLabel;
    Label47: TLabel;
    Label4: TLabel;
    Label3: TLabel;
    Label28: TLabel;
    Label27: TLabel;
    Label26: TLabel;
    Label25: TLabel;
    Label24: TLabel;
    Label23: TLabel;
    Label20: TLabel;
    Label2: TLabel;
    Label19: TLabel;
    Label18: TLabel;
    Label17: TLabel;
    Label16: TLabel;
    Label15: TLabel;
    Label14: TLabel;
    Label13: TLabel;
    Label12: TLabel;
    Label11: TLabel;
    Label10: TLabel;
    Label1: TLabel;
    tk: TEdit;
    qt: TEdit;
    gl: TEdit;
    ncdl: TEdit;
    myjc: TEdit;
    gkmt: TEdit;
    sksm: TEdit;
    hbsm: TEdit;
    hlsm: TEdit;
    shy: TEdit;
    ktsm: TEdit;
    wd: TEdit;
    tt: TEdit;
    gq: TEdit;
    yjd: TEdit;
    hcd: TEdit;
    wlytd: TEdit;
    sgjzw: TEdit;
    zzd: TEdit;
    sd: TEdit;
    ltd: TEdit;
    LYSLD: TEdit;
    ZYPTBH: TEdit;
    yld: TEdit;
    yd: TEdit;
    wtt: TEdit;
    wclzld: TEdit;
    tsyd: TEdit;
    trcd: TEdit;
    tl: TEdit;
    sy: TEdit;
    sml: TEdit;
    sjd: TEdit;
    qtyd: TEdit;
    mp: TEdit;
    mcd: TEdit;
    ld: TEdit;
    jtyd: TEdit;
    jd: TEdit;
    hj: TEdit;
    hd: TEdit;
    gy: TEdit;
    gml: TEdit;
    glcd: TEdit;
    ggst: TEdit;
    gd: TEdit;
    cd: TEdit;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    BitBtn3: TBitBtn;
    BitBtn4: TBitBtn;
    BitBtn5: TBitBtn;
    BitBtn6: TBitBtn;
    DBNavigator1: TDBNavigator;
    Panel1: TPanel;
    DBGrid1: TDBGrid;
    Panel4: TPanel;
    Panel5: TPanel;
    Panel6: TPanel;
    Panel7: TPanel;
    Panel8: TPanel;
    Panel9: TPanel;
    Panel10: TPanel;
    bitbtn7: TBitBtn;
    BitBtn8: TBitBtn;
    ComboBox1: TComboBox;
    BitBtn9: TBitBtn;
    dwmc: TEdit;
    zybm: TMemo;
    Label21: TLabel;
    xzqhdm: TEdit;
    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 FormShow(Sender: TObject);
    procedure hjKeyPress(Sender: TObject; var Key: Char);
    procedure gdKeyPress(Sender: TObject; var Key: Char);
    procedure ggstKeyPress(Sender: TObject; var Key: Char);
    procedure wttKeyPress(Sender: TObject; var Key: Char);
    procedure hdKeyPress(Sender: TObject; var Key: Char);
    procedure cdKeyPress(Sender: TObject; var Key: Char);
    procedure sjdKeyPress(Sender: TObject; var Key: Char);
    procedure gyKeyPress(Sender: TObject; var Key: Char);
    procedure ydKeyPress(Sender: TObject; var Key: Char);
    procedure syKeyPress(Sender: TObject; var Key: Char);
    procedure qtydKeyPress(Sender: TObject; var Key: Char);
    procedure ldKeyPress(Sender: TObject; var Key: Char);
    procedure yldKeyPress(Sender: TObject; var Key: Char);
    procedure gmlKeyPress(Sender: TObject; var Key: Char);
    procedure smlKeyPress(Sender: TObject; var Key: Char);
    procedure wclzldKeyPress(Sender: TObject; var Key: Char);
    procedure jdKeyPress(Sender: TObject; var Key: Char);
    procedure mpKeyPress(Sender: TObject; var Key: Char);
    procedure mcdKeyPress(Sender: TObject; var Key: Char);
    procedure trcdKeyPress(Sender: TObject; var Key: Char);
    procedure glcdKeyPress(Sender: TObject; var Key: Char);
    procedure tsydKeyPress(Sender: TObject; var Key: Char);
    procedure jtydKeyPress(Sender: TObject; var Key: Char);
    procedure tlKeyPress(Sender: TObject; var Key: Char);
    procedure glKeyPress(Sender: TObject; var Key: Char);
    procedure ncdlKeyPress(Sender: TObject; var Key: Char);
    procedure myjcKeyPress(Sender: TObject; var Key: Char);
    procedure gkmtKeyPress(Sender: TObject; var Key: Char);
    procedure shyKeyPress(Sender: TObject; var Key: Char);
    procedure hlsmKeyPress(Sender: TObject; var Key: Char);
    procedure hbsmKeyPress(Sender: TObject; var Key: Char);
    procedure sksmKeyPress(Sender: TObject; var Key: Char);
    procedure ktsmKeyPress(Sender: TObject; var Key: Char);
    procedure wdKeyPress(Sender: TObject; var Key: Char);
    procedure ttKeyPress(Sender: TObject; var Key: Char);
    procedure gqKeyPress(Sender: TObject; var Key: Char);
    procedure sgjzwKeyPress(Sender: TObject; var Key: Char);
    procedure hcdKeyPress(Sender: TObject; var Key: Char);
    procedure wlytdKeyPress(Sender: TObject; var Key: Char);
    procedure yjdKeyPress(Sender: TObject; var Key: Char);
    procedure zzdKeyPress(Sender: TObject; var Key: Char);
    procedure sdKeyPress(Sender: TObject; var Key: Char);
    procedure ltdKeyPress(Sender: TObject; var Key: Char);
    procedure LYSLDKeyPress(Sender: TObject; var Key: Char);
    procedure tkKeyPress(Sender: TObject; var Key: Char);
    procedure qtKeyPress(Sender: TObject; var Key: Char);
    procedure BitBtn7Click(Sender: TObject);
     procedure ENA(); // 新增记录的时候使所有的控件可用
    procedure DIS(); // 保存记录后使所有的控件不可用
    procedure CLS(); //  清除控件中的所有的内容
    procedure GetAll();
    procedure automaticno;
    procedure BitBtn8Click(Sender: TObject);
    procedure xzqhdmChange(Sender: TObject);
    procedure hjExit(Sender: TObject);
    procedure gdExit(Sender: TObject);
    procedure ggstExit(Sender: TObject);
    procedure wttExit(Sender: TObject);
    procedure hdExit(Sender: TObject);
    procedure cdExit(Sender: TObject);
    procedure ydExit(Sender: TObject);
    procedure syExit(Sender: TObject);
    procedure qtydExit(Sender: TObject);
    procedure ldExit(Sender: TObject);
    procedure yldExit(Sender: TObject);
    procedure gmlExit(Sender: TObject);
    procedure wclzldExit(Sender: TObject);
    procedure jdExit(Sender: TObject);
    procedure mpExit(Sender: TObject);
    procedure mcdExit(Sender: TObject);
    procedure trcdExit(Sender: TObject);
    procedure glcdExit(Sender: TObject);
    procedure jtydExit(Sender: TObject);
    procedure tlExit(Sender: TObject);
    procedure glExit(Sender: TObject);
    procedure myjcExit(Sender: TObject);
    procedure gkmtExit(Sender: TObject);
    procedure shyExit(Sender: TObject);
    procedure hlsmExit(Sender: TObject);
    procedure hbsmExit(Sender: TObject);
    procedure ktsmExit(Sender: TObject);
    procedure wdExit(Sender: TObject);
    procedure ttExit(Sender: TObject);
    procedure wlytdExit(Sender: TObject);
    procedure hcdExit(Sender: TObject);
    procedure yjdExit(Sender: TObject);
    procedure zzdExit(Sender: TObject);
    procedure sdExit(Sender: TObject);
    procedure ltdExit(Sender: TObject);
    procedure LYSLDExit(Sender: TObject);
    procedure tkExit(Sender: TObject);
    procedure qtExit(Sender: TObject);
    procedure gqExit(Sender: TObject);
    procedure sksmExit(Sender: TObject);
    procedure ncdlExit(Sender: TObject);
    procedure tsydExit(Sender: TObject);
    procedure smlExit(Sender: TObject);
    procedure gyExit(Sender: TObject);
    procedure sjdExit(Sender: TObject);
    procedure sgjzwExit(Sender: TObject);
    procedure BitBtn9Click(Sender: TObject);
    procedure xzqhdmKeyPress(Sender: TObject; var Key: Char);
    procedure dwmcKeyPress(Sender: TObject; var Key: Char);
  private

    { Private declarations }
  public
    { Public declarations }
  end;

var
  tdlyxxfrm: Ttdlyxxfrm;
  ActionCD,hebpth: string;
  year, month, day: word;
implementation
uses DataM, tdlycxUnit,main;
procedure Ttdlyxxfrm.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_landuse' ;
  queryc.open;
  queryc.Close;
   queryc:=TADOQuery.Create(self);
  queryc.Connection:=DataM.dm.conn;
  queryc.SQL.Text := 'select *  from T_geo_landuse' ;
  queryc.open;
  if  queryc.Eof then
    hebpth:='4101C00071'+'00000001'
  else
  begin
  DataM.DM.tdlyxx.Last;
  m:=DataM.DM.tdlyxx.FieldValues['Z_PTZYBH'];
  i:=StrToInt(Trim(copy(m,11,8)));
  if i< 9 then
  hebpth:='4101C00071'+'0000000'+IntToStr(i+1)
  else if i<99 then
  hebpth:='4101C00071'+'000000'+IntToStr(i+1)
  else if i<999 then
  hebpth:='4101C00071'+'00000'+IntToStr(i+1)
  else if i<9999 then
  hebpth:='4101C00071'+'0000'+IntToStr(i+1)
  else if i<99999 then
  hebpth:='4101C00071'+'000'+IntToStr(i+1)
  else if i<999999 then
  hebpth:='4101C00071'+'00'+IntToStr(i+1)
  else if i<9999999 then
  hebpth:='4101C00071'+'0'+IntToStr(i+1)
  else
  hebpth:='4101C00071'+IntToStr(i+1);
  end;
  queryc.Close;
end;

procedure Ttdlyxxfrm.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
      Tcombobox(components[i]).Color := clwindow;
      if (components[i] is TMemo) then
      Tcombobox(components[i]).Color := clwindow;
  end;
  zyptbh.Enabled := False;
  BitBtn2.Enabled := False; //  '编辑'不可用
  BitBtn3.Enabled := True; //  '储存'可用
  BitBtn4.Enabled := True; //  '取消'可用
  BitBtn6.Enabled := False; //   '关闭'不可用
end;
procedure Ttdlyxxfrm.DIS; // 新增记录的时候使所有的控件不可用
var
  i: Integer;
begin
  for i := ComponentCount - 1 downto 0 do