资源描述：
《用友批量修改权.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,
2、cAuthType,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)select002,2013,cUser_Id,cAuth_
3、Id,iIsUser,csub_id,cAuthType,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)select002,2
4、014,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType,cRepellent,cRepellentModule,cNotRepellentfromua_holdauthwherecuser_id='all'andcacc_id=001andiyear=2011insertintoua_holdauth(cAcc_Id,iYear,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType,cRepellent,cRepellentModule,cNotRe
5、pellent)select003,2012,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType,cRepellent,cRepellentModule,cNotRepellentfromua_holdauthwherecuser_id='all'andcacc_id=001andiyear=2011insertintoua_holdauth(cAcc_Id,iYear,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType,cRepellent,cRep
6、ellentModule,cNotRepellent)select003,2013,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType,cRepellent,cRepellentModule,cNotRepellentfromua_holdauthwherecuser_id='all'andcacc_id=001andiyear=2011insertintoua_holdauth(cAcc_Id,iYear,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthT
7、ype,cRepellent,cRepellentModule,cNotRepellent)select003,2014,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType,cRepellent,cRepellentModule,cNotRepellentfromua_holdauthwherecuser_id='all'andcacc_id=001andiyear=2011insertintoua_holdauth(cAcc_Id,iYear,cUser_Id,cAuth_Id,iIs
8、User,csub_id,cAuthType,cRepellent,cRepellentModule,cNotRepellent)select101,2006,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType,cRepellent,cRepellentModule,
