/// <summary>
/// 更新主表中的 TotalComplainCount, 使得保持一致
/// </summary>
/// <param name="info"></param>
private static void UpdateTopicRemarkCount(TopicComplainInfo info)
{
string sql = @"UPDATE Topic_Master
SET TotalComplainCount = TotalComplainCount+1 WHERE SysNo = " + info.TopicSysNo;
SqlHelper.ExecuteScalar(sql);
}
// 投诉评论
public static int SetComplain(TopicComplainInfo info)
{
if (TopicComplainDac.IsExistComplain(info))
{
return(-1); //已存在当前用户的投诉
}
else
{
TopicComplainDac.InsertTopicComplain(info);
return(0); //投诉成功
}
}
protected static TopicComplainInfo Map(DataRow row)
{
TopicComplainInfo info = new TopicComplainInfo();
info.SysNo = Convert.ToInt32(row["SysNo"]);
info.TopicSysNo = Convert.ToInt32(row["TopicSysNo"]);
info.Memo = row["Memo"].ToString();
info.CreateUserType = (AppEnum.CreateUserType)Convert.ToInt32(row["CreateUserType"]);
info.CreateUserSysNo = Convert.ToInt32(row["CreateUserSysNo"]);
info.CreateDate = Convert.ToDateTime(row["CreateDate"]);
return(info);
}
/// <summary>
/// 检查是否已经存在当前用户得Complain
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public static bool IsExistComplain(TopicComplainInfo info)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@TopicSysNo", SqlDbType.Int),
new SqlParameter("@CreateUserType", SqlDbType.Int),
new SqlParameter("@CreateUserSysNo", SqlDbType.Int)
};
parms[0].Value = info.TopicSysNo;
parms[1].Value = (int)info.CreateUserType;
parms[2].Value = info.CreateUserSysNo;
SqlCommand cmd = new SqlCommand(SQL_CHECK_EXITCOMPLAIN);
cmd.Parameters.AddRange(parms);
cmd.CommandTimeout = 180;
return(Convert.ToInt32(SqlHelper.ExecuteScalar(cmd)) > 0);
}
public static int InsertTopicComplain(TopicComplainInfo info)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@TopicSysNo", SqlDbType.Int),
new SqlParameter("@Memo", SqlDbType.NVarChar),
new SqlParameter("@CreateUserType", SqlDbType.Int),
new SqlParameter("@CreateUserSysNo", SqlDbType.Int)
};
parms[0].Value = info.TopicSysNo;
parms[1].Value = info.Memo;
parms[2].Value = info.CreateUserType;
parms[3].Value = info.CreateUserSysNo;
UpdateTopicRemarkCount(info);
SqlCommand cmd = new SqlCommand(SQL_INSERT_TOPICCOMPLAIN);
cmd.Parameters.AddRange(parms);
cmd.CommandTimeout = 180;
return(Convert.ToInt32(SqlHelper.ExecuteScalar(cmd)));
}
public static void ComplainTopic(TopicComplainInfo complain)
{
TopicComplainDac.InsertTopicComplain(complain);
}