|
怎样在自己的进销存里导入速达、管家婆和用友的数据(7) sSql2 := 'SELECT * FROM Unit'; sField2 := 'Mode,UserCode,ShortName,Name,AreaName,LinkMan,Phone,PhoneMove,PhoneFax,PostalCode,' + 'Address,Memo,Banking,Accounts,WWW,EMail,Payable'; sField1 := '!CONST,VENDORID,ShortName,Name,AreaName,CONTATOR,Phone,MOBILEPHONE,Fax,zip,' + 'Address,memo,bank,bankID,URL,EMail,BALANCE'; sConst := IntToStr(BASE_PROVIDE); InputSD3000(sSql1, sSql2, sField1, sField2, sConst); ShowMsg('导入数据成功!'); Screen.Cursor := crDefault; end; procedure TfrmUpdateSD3000.InputAllGrASPData; var sSqlData: string; sSql1, sSql2, sField1, sField2, sConst: string; begin sSql1 := ''; sSql2 := ''; sField1 := ''; sField2 := ''; sConst := ''; if cbxSQLDB.ItemIndex < 0 then Exit; sSqlData := cbxSQLDB.Items.Strings[cbxSQLDB.ItemIndex]; if sSQLData = '' then begin ShowMsg('请先连接SQLServer数据库!'); Exit; end; if not ConectGrASP(sSqlData) then begin ShowMsg('连接SQLServer数据库出错,请重新输入服务器名、用户名、密码!'); Exit; end; Screen.Cursor := crHourglass; //仓库 sSql1 := 'SELECT * FROM STOCK WHERE TYPEID<>''00000'''; sSql2 := 'SELECT * FROM Depot'; sField1 := 'USERCODE,FULLNAME,COMMENT'; sField2 := 'UserCode,Name,Memo'; InputGrASP(sSql1, sSql2, sField1, sField2, sConst); //商品 sSql1 := 'SELECT * FROM ptype WHERE TYPEID<>''00000''';
|