/// <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 int SetComplain(TopicComplainInfo info) { if (TopicComplainDac.IsExistComplain(info)) return -1; //�Ѵ��ڵ�ǰ�û���Ͷ�� else { TopicComplainDac.InsertTopicComplain(info); return 0; //Ͷ�߳ɹ� } }
public static void ComplainTopic(TopicComplainInfo complain) { TopicComplainDac.InsertTopicComplain(complain); }
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> /// ���������е� 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); }