Check from the front-end interface, go to the *. ascx file to the. CS file, go to the Controller \ info file, and go to the data provider, and perform layer-by-layer query through "go to definition.
In sqldataprovider in provider, view the method of the inherited interface class in dataprovider ----> stored procedure in database.
Eventually
Create procedure {databaseowner} {objectqualifier} hvc_suggestion_getmsginfomanagermodules
(
@ Portalid int
)
As
Select M .*,
DM .*
From {databaseowner} {objectqualifier} modules M
Inner join {databaseowner} {objectqualifier} moduledefinitions MD on M. moduledefid = md. moduledefid
Inner join {databaseowner} {objectqualifier} partition topmodules DM on MD. Partition topmoduleid = DM. Partition topmoduleid
Where M. portalid = @ portalid and DM. modulename = 'hivence-suggestion 'and M. isdeleted = 0
Order by M. moduleid
Return
Go
Create procedure {databaseowner} {objectqualifier} hvc_suggestion_getmsginfo
(
@ Msginfoid int
)
As
In, modulename = 'hivence-suggestion 'is different from the module name defined in *. dnn.
* <Modulename> hivence-suggestion </modulename> In dnn
Must be consistent before and after, and there must be no difference