/// <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); }