|
怎样在自己的进销存里导入速达、管家婆和用友的数据(9) sField2 := 'Mode,UserCode,ShortName,Name,AreaName,LinkMan,Phone,PhoneFax,PostalCode,Address,Memo,Banking,Accounts,Receive'; sConst := intToStr(BASE_CLIENT); InputGrASP(sSql1, sSql2, sField1, sField2, sConst); //供应商 sSql1 := 'SELECT A.FullName AS AreaName, B.* FROM btype B LEFT OUTER JOIN AreaType A' + ' ON B.AreaTypeID = A.TypeID WHERE B.TypeID<>''00000'''; sSql2 := 'SELECT * FROM Unit'; sField1 := '!CONST,UserCode,Name,FullName,AreaName,PERSON,TELANDADDRESS,FAX,POSTCODE,AREA,Comment,BANKANDACOUNT,BANKANDACOUNT,APTotal'; sField2 := 'Mode,UserCode,ShortName,Name,AreaName,LinkMan,Phone,PhoneFax,PostalCode,Address,Memo,Banking,Accounts,Payable'; sConst := intToStr(BASE_PROVIDE); InputGrASP(sSql1, sSql2, sField1, sField2, sConst); ShowMsg('导入数据成功!'); Screen.Cursor := crDefault; end; procedure TfrmUpdateSD3000.InputGrASP(sSql1, sSql2, sField1, sField2, sConst: string); begin if OpenDataSetEx(SQLADOConnet, SQLDataSet, sSql1) and OpenDataSet(AdoDataSet, sSql2) then DataSetInput(SQLDataSet, AdoDataSet, sField1, sField2, sConst); end; procedure TfrmUpdateSD3000.InputSD3000(sSql1, sSql2, sField1, sField2, sConst: string); begin if OpenIBDataSet(sSql1) and OpenDataSet(AdoDataSet, sSql2) then DataSetInput(IBDataSet1, AdoDataSet, sField1, sField2, sConst); end; procedure TfrmUpdateSD3000.edtYYDataButtonClick(Sender: TObject; AbsoluteIndex: Integer); var sFileName: string;
|