Beispiel #1
0
        private void button21_Click(object sender, EventArgs e)
        {
            var redis = new RedisClient(ConfigRedis.Host, ConfigRedis.Port);
            var keys = redis.SearchKeys(string.Format(RedisKey.CeoKey, "*"));
            var sql = new SqlDb();
            sql.OpenDb();
            var dt = sql.GetAllCeos();
            var i = 0;
            foreach(var key in keys)
            {
                //ceo:ceocode:{0}:Object
                var t = key.Replace("ceo:ceocode:", "").Replace(":Object","");
                if (dt.Select("CeoCode = '" + t + "'").Length==0)
                {
                    redis.Remove(key);
                    i++;
                }
            }
            sql.CloseDb();

            MessageBox.Show(i.ToString("#,##0"));
        }