MySQL读取不重复的数据

来源：互联网发布：手机数据开了不能用编辑：程序博客网时间：2024/05/21 22:44

MySQL读取不重复的数据，读取之前可以判断一下IsRead是0，0表示可以读取，1表示不可读取，读取失败需要释放掉改为0，方便第二次读取

       /// <summary>        /// 获取并更新IsRed        /// </summary>        /// <param name="SceneCode"></param>        /// <param name="IsRead"></param>        /// <returns></returns>        public McAutoscenetask GetByIsRedModel(string SceneCode, int IsRed)        {            var dic = new StatementParameterCollection();            StringBuilder sbSql = new StringBuilder();            sbSql.Append("start transaction;select * from mc_autoscenetask            where SceneCode=@SceneCode for update;update mc_autoscenetask set IsRead=@IsRead            where SceneCode=@SceneCode;commit;");            dic.AddInParameter("@SceneCode", DbType.String, SceneCode);            dic.AddInParameter("@IsRead", DbType.Int32, IsRed);            return baseDao.SelectFirst<McAutoscenetask>(sbSql.ToString(), dic);        }

0 0