-
cs_ApplicationConfigurationSettings_CreateUpdate///cs_ApplicationConfigurationSettings_Get//cs_Audit_Post
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
ALTER PROCEDURE [dbo].cs_ApplicationConfigurationSettings_CreateUpdate --11, 36, 0, 1, 0
( ----------应用程序配置设置
@SettingsID int,
@ApplicationType smallint,
@Settings NText = null
)
![](/Images/OutliningIndicators/None.gif)
as
![](/Images/OutliningIndicators/None.gif)
if exists(Select SettingsID FROM cs_ApplicationConfigurationSettings where SettingsID = @SettingsID and ApplicationType = @ApplicationType)
Begin ---如果存在此条配置,则更新数据
Update cs_ApplicationConfigurationSettings
Set Settings = @Settings
where SettingsID = @SettingsID and ApplicationType = @ApplicationType
End
Else
Begin-----如果不存在,则插入数据
Insert cs_ApplicationConfigurationSettings (SettingsID, ApplicationType, Settings)
Values(@SettingsID, @ApplicationType, @Settings)
End
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/None.gif)
ALTER PROCEDURE [dbo].cs_ApplicationConfigurationSettings_Get --11, 36, 0, 1, 0
(
@SettingsID int,
@ApplicationType smallint
)
as
----查询此条配置的详细配置信息
Select Settings FROM cs_ApplicationConfigurationSettings where SettingsID = @SettingsID and ApplicationType = @ApplicationType
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
GO
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
ALTER proc [dbo].cs_Audit_Post
(
@PostID int,
@SettingsID int
)
AS
SET Transaction Isolation Level Read UNCOMMITTED
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
/**//*设置事务隔离级别,Read UNCOMMITTED 执行脏读或 0 级隔离锁定,这表示不发出共享锁,
也不接受排它锁。当设置该选项时,可以对数据执行未提交读或脏读;在事务结束前可以更
改数据内的数值,行也可以出现在数据集中或从数据集消失。该选项的作用与在事务内所有
语句中的所有表上设置 NOLOCK 相同。这是四个隔离级别中限制最小的级别。*/
![](/Images/OutliningIndicators/None.gif)
-- Get the Post
--获取帖子基本信息,此存储过程有用视图,看前要先看下视图
exec cs_forums_Post @PostID, null, 0, @SettingsID
![](/Images/OutliningIndicators/None.gif)
SELECT
B.Description,
U.UserName,
A.*
FROM
cs_ModerationAudit A,
cs_ModerationAction B,
cs_vw_Users_FullUser U
WHERE
A.ModerationAction = B.ModerationAction AND
A.SettingsID = B.SettingsID AND
U.cs_UserID = A.ModeratorID AND
A.PostID = @PostID AND
A.SettingsID = @SettingsID
ORDER BY
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
/**//*都是关于操作的记录,越往后面数据字段越不理解了 -_-!!!*/
ModeratedOn
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
GO
-
相关阅读:
Android 数据库
HarmonyOS三方件开发指南(12)——cropper图片裁剪
从微信小程序到鸿蒙js开发【15】——JS调用Java
鸿蒙的js开发部模式16:鸿蒙布局Grid网格布局的应用一
从微信小程序到鸿蒙js开发【14】——自定义组件
鸿蒙js开发7 鸿蒙分组列表和弹出menu菜单
HarmonyOS三方件开发指南(11)——Updownfile
鸿蒙Java开发模式11:鸿蒙图片裁剪功能的实现
从微信小程序到鸿蒙js开发【13】——list加载更多&回到顶部
从微信小程序到鸿蒙js开发【12】——storage缓存&自动登录
-
原文地址:https://www.cnblogs.com/ruanbl/p/494143.html
Copyright © 2020-2023
润新知