Example #1
0
        /// <summary>
        /// 按targetGuid查询数量
        /// </summary>
        /// <param name="targetGuid">目标GUID</param>
        /// <param name="enable">是否启用</param>
        /// <returns></returns>
        public int GetListCountByTarget(string targetGuid, bool enable = true)
        {
            string            sqlstring  = "SELECT count(1) FROM t_consumer_collection where target_guid=@target_guid and enable=1";
            DynamicParameters parameters = new DynamicParameters();

            parameters.Add("target_guid", targetGuid, System.Data.DbType.String);
            using (MySql.Data.MySqlClient.MySqlConnection conn = MySqlHelper.GetConnection())
            {
                return(conn.QuerySingle <int?>(sqlstring, parameters) ?? 0);
            }
        }