pdf_viewer_wrapper.js

pdf_viewer_wrapper.js

 

@echo off
start "" "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe" -S . -U sa -P pwd -d dbname

SELECT 
componenttype,
componenttypename,
componenttypename='[componenttypename:'+componenttypename+']',
combine=ISNULL(entityname+'-','')+
        ISNULL(entityattributename+'-','')+
        ISNULL(attributename+'-','')+
        ISNULL(entityrelationshipname+'-','')+
        ISNULL(optionsetname+'-','')+
        ISNULL(viewname+'-','')+
        ISNULL(formname+'-','')+
        ISNULL(reportname+'-','')+
        ISNULL(workflowname+'-','')+
        ISNULL(pluginassemblyname+'-','')+
        ISNULL(sdkmessageprocessingstepname,'')+
        ISNULL(webresourcename+'-',''),
createdby,
createdbyfullname,
createdon,
modifiedby,
modifiedbyfullname,
modifiedon
FROM (
SELECT TOP 10000
uniquename=S.uniquename,
componenttype=C.componenttype,
componenttypename=C.componenttypename,
entityLogicalname=ISNULL(E.logicalname,'')+ISNULL(EA.logicalname,''),
attributeLogicalname=ATT.logicalname,
OptionsetLogicalname=OP.name,
entityformId=F.formid,
entityname='[entity:'+E.logicalname+']',
entityattributename='[entity:'+EA.logicalname+']',
attributename='[attribute:'+ATT.logicalname+']',
optionsetname='[optionset:'+OP.name+']',
webresourcename='[webresource:'+W.name+']',
formname='[form:'+F.name+']',
viewname='[view:'+V.name+']',
entityrelationshipname='[entityrelationship:'+R.schemaname+']',
reportname='[report:'+RP.name+']',
workflowname='[workflow:'+WF.name+']',
sdkmessageprocessingstepname='[sdkmessageprocessingstep:'+SP.name+']',
pluginassemblyname='[pluginassembly:'+PI.name+']',
createdby=UC.systemuserid,
createdbyfullname=UC.fullname,
createdon=C.createdon,
modifiedby=UM.systemuserid,
modifiedbyfullname=UM.fullname,
modifiedon=C.modifiedon
FROM solution S 
LEFT JOIN solutioncomponent C ON S.solutionid = C.solutionid 
LEFT JOIN entity E ON C.objectid=E.entityid                       --Entity
LEFT JOIN systemuser UM ON C.modifiedby = UM.systemuserid
LEFT JOIN systemuser UC ON C.createdby = UC.systemuserid
LEFT JOIN solutioncomponent CSUB ON C.rootsolutioncomponentid=CSUB.solutioncomponentid
LEFT JOIN entity EA ON CSUB.objectid=EA.entityid                  --Entity
LEFT JOIN attribute ATT ON C.objectid=ATT.attributeid             --Attribute
LEFT JOIN optionset OP ON C.objectid=OP.optionsetid               --Optionset
LEFT JOIN systemform F ON C.objectid=F.formid                     --Form
LEFT JOIN savedquery V ON C.objectid=V.savedqueryid               --VIEW
LEFT JOIN webresource W on C.objectid=W.webresourceid             --Webresource
LEFT JOIN entityrelationship R on C.objectid=R.entityrelationshipid           --Entityrelationship
LEFT JOIN report RP on C.objectid=RP.reportid                       --Report
LEFT JOIN workflow WF on C.objectid=WF.workflowid                   --Workflow
LEFT JOIN sdkmessageprocessingstep SP on C.objectid=SP.sdkmessageprocessingstepid   --sdkmessageprocessingstep
LEFT JOIN pluginassembly PI on C.objectid=PI.pluginassemblyid       --Pluginassembly
WHERE 1=1
AND S.uniquename='XXXX'
ORDER BY 
componenttype asc,
entityLogicalname asc,
attributeLogicalname asc,
optionsetname asc,
formname asc,
viewname asc,
reportname asc,
entityrelationshipname asc,
sdkmessageprocessingstepname asc,
webresourcename asc
) AS Temp 


 IIS Config
 https://stackoverflow.com/questions/6915094/what-type-of-password-i-have-to-give-to-set-the-custom-account-for-application-p

 

https://files.cnblogs.com/files/Arice/%E5%AE%8F%E8%88%9F%E6%95%B0%E6%8D%AE%E5%BA%93%E7%BB%93%E6%9E%84%E6%96%87%E6%A1%A3(%E6%95%B0%E6%8D%AE%E5%BA%93%E5%B7%A5%E5%85%B72004).zip?t=1749523838&download=true