uimp.~pas

青年文明号管理系统

unit Uimp;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Buttons, Grids, DBGridEh, ExtCtrls, XPMenu;

type
  Timp = class(TForm)
    DBGridEh1: TDBGridEh;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    Panel1: TPanel;
    Panel2: TPanel;
    Panel3: TPanel;
    DBGridEh2: TDBGridEh;
    Panel4: TPanel;
    BitBtn3: TBitBtn;
    OpenDialog1: TOpenDialog;
    XPMenu1: TXPMenu;
    procedure BitBtn3Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure BitBtn4Click(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  imp: Timp;

implementation

uses Udm, u_vardef;

{$R *.dfm}

procedure Timp.BitBtn3Click(Sender: TObject);
begin
  OpenDialog1.Filter:='文明号导入文件(exp.wmh)|exp.wmh';{从对话窗选择文件}
  if OpenDialog1.Execute then begin
       vopenpath:=OpenDialog1.FileName;
       vopenpath:=copy(vopenpath,1,length(vopenpath)-8);//取得路径
       dm.t_sbb_in.LoadFromFile(vopenpath+'\'+'exp.wmh');
       dm.jtqk_exp.LoadFromFile(vopenpath+'\'+'exp_jtqk.wmh');
  end;
end;

procedure Timp.BitBtn2Click(Sender: TObject);
begin
close;
end;

procedure Timp.BitBtn4Click(Sender: TObject);
begin
showmsg(DBGridEh2.Fields[0].asstring);
end;

procedure Timp.BitBtn1Click(Sender: TObject);
var
vdwbh:string;
i,i1,i2:integer;
d:string;
begin

//判断库中是否有导入的编号，如果有则提示
i:=DBGridEh1.DataSource.DataSet.RecordCount;
if  i=0 then begin
    showmsg('无单位可导入');
    exit;
end;
DBGridEh1.DataSource.DataSet.First;
for i1:=1 to i do begin
  vdwbh:=DBGridEh1.Fields[0].AsString;
  dm.tmp.SQL.Text:='select count(*) from t_sbb where dwbh='''+vdwbh+'''';
  dm.tmp.Open;
  i2:=dm.tmp.Fields[0].AsInteger;
  if i2>0 then
     begin
       showmsg('单位编号为：'+vdwbh+'已存在，请确认！');
       exit;
     end;
end;

if  (Application.MessageBox(Pchar('确定导入？'),'提示',MB_YESNO+MB_ICONQUESTION))=ID_Yes then

try
gridtotable(DBGridEh1,dm.t_sbb);
gridtotable(DBGridEh2,dm.t_jtqk);
d:=gdir+'\doc';
copyA(vopenpath,d,'65');
showmsg('导入成功');
except
showmsg('导入失败，请咨询开发商');
end;
end;

procedure Timp.FormClose(Sender: TObject; var Action: TCloseAction);
begin
dm.t_sbb_in.Close;
dm.jtqk_exp.Close;
end;

procedure Timp.FormCreate(Sender: TObject);
begin
dm.t_sbb_in.Close;
dm.jtqk_exp.Close;
end;

end.