示例#1
0
        /// <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;
        }
示例#2
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));
        }
示例#3
0
文件: TopicManager.cs 项目: ue96/ue96
 // Ͷ������
 public static int SetComplain(TopicComplainInfo info)
 {
     if (TopicComplainDac.IsExistComplain(info))
         return -1; //�Ѵ��ڵ�ǰ�û���Ͷ��
     else
     {
         TopicComplainDac.InsertTopicComplain(info);
         return 0;  //Ͷ�߳ɹ�
     }
 }
示例#4
0
文件: TopicManager.cs 项目: ue96/ue96
 public static void ComplainTopic(TopicComplainInfo complain)
 {
     TopicComplainDac.InsertTopicComplain(complain);
 }
示例#5
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;
        }
示例#6
0
        /// <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);
        }