对比两个excel 内容
[-] type Content is record
[ ] STRING sEn
[ ] STRING sLocal
[-] public LIST OF ANYTYPE getItem(STRING DNS)
[ ] HDATABASE hdbc
[ ] HSQL hstmt
[ ] Content tool
[ ] LIST OF ANYTYPE ls={}
[ ] STRING s
[-] do
[ ] hdbc=DB_Connect("DSN={DNS}")
[ ] hstmt=DB_ExecuteSql(hdbc,"SELECT * FROM [Sheet1$]")
[-] while (DB_FetchNext(hstmt,tool))
[ ] ListAppend(ls,tool)
[ ] DB_Disconnect(hdbc)
[ ] return ls
[-] except
[ ] return ls
[ ] ExceptLog()
[-] public LIST OF ANYTYPE Compare(STRING sTarget,STRING sTemplate)
[ ] LIST OF ANYTYPE ls_sTarget={}
[ ] LIST OF ANYTYPE ls_sTemplate={}
[ ] LIST OF ANYTYPE ls_res={}
[ ] ls_sTarget=getItem(sTarget)
[ ] ls_sTemplate=getItem(sTemplate)
[ ] int i=1
[ ] int j=1
[-] for (i=1;i<=ListCount(ls_sTarget);i++)
[-] for(j=1;j<=ListCount(ls_sTemplate);j++)
[-] if ls_sTarget.sEn==ls_sTemplate[j].sEn&&ls_sTarget.sLocal!=ls_sTemplate[j].sLocal
[ ] ListAppend(ls_res,ls_sTarget)
[ ] ListAppend(ls_res,ls_sTemplate[j])
[ ] return ls_res