public static void fn黑名單刪除(CBlackList blackList)
{
string sql = $"EXEC 黑名單刪除 ";
sql += $"@{CBlackListKey.fBannedId}";
//sql += $"@{CBlackListKey.fMemberId}";
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter(CBlackListKey.fBannedId, blackList.fBannedId)
//new SqlParameter(CBlackListKey.fMemberId, member.fMemberId)
};
CDbManager.executeSql(sql, paras);
}
public static void fn黑名單更新(CBlackList BlackList)
{
string sql = $"EXEC 黑名單更新 ";
sql += $"@{CBlackListKey.fBannedId},";
sql += $"@{CBlackListKey.fReason},";
sql += $"@{CBlackListKey.fLockDateTime}";
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter(CBlackListKey.fBannedId, BlackList.fMemberId),
new SqlParameter(CBlackListKey.fReason, BlackList.fReason),
new SqlParameter(CBlackListKey.fLockDateTime, BlackList.fLockDateTime)
};
CDbManager.executeSql(sql, paras);
}