Example #1
0
        public static void ChangeTopicStstus(int sysNo, AppEnum.TopicStatus st)
        {
            SqlParameter[] parms = new SqlParameter[]
            {
                new SqlParameter("@Status", SqlDbType.Int),
                new SqlParameter("@SysNo", SqlDbType.Int)
            };
            parms[0].Value = (int)st;
            parms[1].Value = sysNo;

            SqlCommand cmd = new SqlCommand(SQL_CHANGE_TOPIC_STATUS);

            cmd.Parameters.AddRange(parms);
            cmd.CommandTimeout = 180;
            SqlHelper.ExecuteNonQuery(cmd);
        }
Example #2
0
        public static void AddTopicReplyBySysUser(TopicReplyInfo reply, AppEnum.TopicStatus ts)
        {
            TopicReplyDac.InsertTopicReply(reply);

            TopicDac.ChangeTopicStstus(reply.TopicSysNo, AppEnum.TopicStatus.Replyed);
        }