var sql001="delete from t_document where id in (select id from tlk_½û)";     
     var sql002 ="delete from tlk_½û";     
     deleteByDSName("ѵ",sql001);     
     deleteByDSName("ѵ",sql002);     
         	var sql="select id,LOGINNO,NAME,LOGINPWD,TELEPHONE,EMAIL,DEFAULTDEPARTMENT,(select group_concat(roleid separator ';') from t_user_department_role_set where USERID=tuser.id) as roleid from t_user as tuser";         
         	println("sql-------->"+sql);         
         	var datas = queryByDSName("obpm4",sql);         
              
         	var applicationid="ZwxeetnPB0vqZsDLKMW";   //id         
             var domainid="59jaeJLi1AAr7tJMGQs";         //ҵid         
             var process = getDocProcess(applicationid);  //ȡIdŶӦĵ         
             var formProcess = getFormProcess();        //ҵ                                         
             var form = formProcess.doViewByFormName("½û",getApplication());       //  ҵǱ                                
             var webuser = getWebUser();                      
             var doc1 = process.doNew(form,webuser,createParamsTable());//¼           
            var data="";       
       var se = new Packages.cn.myapps.util.Security ();           
        //var mm=se.decryptPassword(data.get("LOGINPWD"));   //     
  
  
                  for(var i = 0; i < datas.size();i++){         
                          data=datas.get(i)				          
                          doc1.setId(data.get("id"));            
                          doc1.findItem("˺").setValue(data.get("LOGINNO"));          
                          doc1.findItem("").setValue(se.decryptPassword(data.get("LOGINPWD")));          
                          doc1.findItem("").setValue(data.get("DEFAULTDEPARTMENT"));          
                          doc1.findItem("ɫ").setValue(data.get("roleid"));          
                          doc1.findItem("").setValue(data.get("EMAIL"));          
                          doc1.findItem("绰").setValue(data.get("TELEPHONE"));				          
                          doc1.setDomainid(domainid);         
                          doc1.findItem("û").setValue(data.get("NAME"));         
                          process.doCreate(doc1);            
             }