资源描述：
《用友批量修改权限.doc》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。
1、批量修改权限问题现象客户需要给全部帐套固定的权限如果给全部权限的话还不行如果从前台增加的话那么一个一个点太慢了解决思路前台点太慢是不是可以从某个表直接插入，尝试以后决定从后台增加解决办法insertintoua_holdauth(cAcc_Id,iYear,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType,cRepellent,cRepellentModule,cNotRepellent)select001,2012,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType,cRepel
2、lent,cRepellentModule,cNotRepellentfromua_holdauthwherecuser_id='all'andcacc_id=001andiyear=2011insertintoua_holdauth(cAcc_Id,iYear,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType,cRepellent,cRepellentModule,cNotRepellent)select002,2013,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType,cRe
3、pellent,cRepellentModule,cNotRepellentfromua_holdauthwherecuser_id='all'andcacc_id=001andiyear=2011insertintoua_holdauth(cAcc_Id,iYear,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType,cRepellent,cRepellentModule,cNotRepellent)select002,2014,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType,
4、cRepellent,cRepellentModule,cNotRepellentfromua_holdauthwherecuser_id='all'andcacc_id=001andiyear=2011insertintoua_holdauth(cAcc_Id,iYear,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType,cRepellent,cRepellentModule,cNotRepellent)select003,2012,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthTy
5、pe,cRepellent,cRepellentModule,cNotRepellentfromua_holdauthwherecuser_id='all'andcacc_id=001andiyear=2011insertintoua_holdauth(cAcc_Id,iYear,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType,cRepellent,cRepellentModule,cNotRepellent)select003,2013,cUser_Id,cAuth_Id,iIsUser,csub_id,cAut
6、hType,cRepellent,cRepellentModule,cNotRepellentfromua_holdauthwherecuser_id='all'andcacc_id=001andiyear=2011insertintoua_holdauth(cAcc_Id,iYear,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType,cRepellent,cRepellentModule,cNotRepellent)select003,2014,cUser_Id,cAuth_Id,iIsUser,csub_id,c
7、AuthType,cRepellent,cRepellentModule,cNotRepellentfromua_holdauthwherecuser_id='all'andcacc_id=001andiyear=2011insertintoua_holdauth(cAcc_Id,iYear,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType,cRepellent,cRepellentModule,cNotRepellent)select101,2006,cUser_Id,cAuth_Id,iIsUser,csub_i
8、d,cAuthType,cRepellent,cRepellentModule,
