public override void CreateDenouncing(int userID, int targetID, int targetUserID, DenouncingType type, string content, string createIP)
{
using (SqlQuery query = new SqlQuery())
{
query.CommandText = "bx_Denouncing_Create";
query.CommandType = CommandType.StoredProcedure;
query.CreateParameter<int>("@UserID", userID, SqlDbType.Int);
query.CreateParameter<int>("@TargetID", targetID, SqlDbType.Int);
query.CreateParameter<int>("@TargetUserID", targetUserID, SqlDbType.Int);
query.CreateParameter<DenouncingType>("@Type", type, SqlDbType.TinyInt);
query.CreateParameter<string>("@Content", content, SqlDbType.NVarChar, 50);
query.CreateParameter<string>("@CreateIP", createIP, SqlDbType.VarChar, 50);
query.ExecuteNonQuery();
}
}
public bool CreateDenouncing(int operatorID, int targetID, int targetUserID, DenouncingType type, string content, string createIP)
{
if (targetID <= 0)
{
ThrowError(new InvalidParamError("targetID"));
return false;
}
if (StringUtil.GetByteCount("content") > Consts.Report_Length)
{
Context.ThrowError(new InvalidReportLengthError("content", content, Consts.Report_Length));
return false;
}
DenouncingDao.Instance.CreateDenouncing(operatorID, targetID, targetUserID, type, content, createIP);
CacheUtil.Remove("Denouncing/Count");
return true;
}
public override CheckDenouncingStateResult CheckDenouncingState(int operatorID, int targetID, DenouncingType targetType)
{
using (SqlQuery query = new SqlQuery())
{
query.CommandText = "bx_Denouncing_CheckState";
query.CommandType = CommandType.StoredProcedure;
query.CreateParameter<int>("@UserID", operatorID, SqlDbType.Int);
query.CreateParameter<int>("@TargetID", targetID, SqlDbType.Int);
query.CreateParameter<DenouncingType>("@TargetType", targetType, SqlDbType.TinyInt);
SqlParameter result = query.CreateParameter<int>("@Result", SqlDbType.Int, ParameterDirection.ReturnValue);
query.ExecuteNonQuery();
switch ((int)result.Value)
{
case 2:
return CheckDenouncingStateResult.WasIgnoreByAdmin;
case 3:
return CheckDenouncingStateResult.WasDenounced;
default:
return CheckDenouncingStateResult.CanDenouncing;
}
}
}
public abstract CheckDenouncingStateResult CheckDenouncingState(int operatorID, int targetID, DenouncingType targetType);
public abstract void CreateDenouncing(int userID, int targetID, int targetUserID, DenouncingType type, string content, string createIP);
public override void CreateDenouncing(int userID, int targetID, int targetUserID, DenouncingType type, string content, string createIP)
{
using (SqlQuery query = new SqlQuery())
{
query.CommandText = "bx_Denouncing_Create";
query.CommandType = CommandType.StoredProcedure;
query.CreateParameter <int>("@UserID", userID, SqlDbType.Int);
query.CreateParameter <int>("@TargetID", targetID, SqlDbType.Int);
query.CreateParameter <int>("@TargetUserID", targetUserID, SqlDbType.Int);
query.CreateParameter <DenouncingType>("@Type", type, SqlDbType.TinyInt);
query.CreateParameter <string>("@Content", content, SqlDbType.NVarChar, 50);
query.CreateParameter <string>("@CreateIP", createIP, SqlDbType.VarChar, 50);
query.ExecuteNonQuery();
}
}
public override CheckDenouncingStateResult CheckDenouncingState(int operatorID, int targetID, DenouncingType targetType)
{
using (SqlQuery query = new SqlQuery())
{
query.CommandText = "bx_Denouncing_CheckState";
query.CommandType = CommandType.StoredProcedure;
query.CreateParameter <int>("@UserID", operatorID, SqlDbType.Int);
query.CreateParameter <int>("@TargetID", targetID, SqlDbType.Int);
query.CreateParameter <DenouncingType>("@TargetType", targetType, SqlDbType.TinyInt);
SqlParameter result = query.CreateParameter <int>("@Result", SqlDbType.Int, ParameterDirection.ReturnValue);
query.ExecuteNonQuery();
switch ((int)result.Value)
{
case 2:
return(CheckDenouncingStateResult.WasIgnoreByAdmin);
case 3:
return(CheckDenouncingStateResult.WasDenounced);
default:
return(CheckDenouncingStateResult.CanDenouncing);
}
}
}
public CheckDenouncingStateResult CheckDenouncingState(int operatorID, int targetID, DenouncingType targetType)
{
return DenouncingDao.Instance.CheckDenouncingState(operatorID, targetID, targetType);
}
