串列寫隊列的MYSQL大文本參數

標籤：des   style   blog   color   io   os   ar   for   資料   

public void AsyncWriteDataBase()        {            var spName = "";            while (true)            {                try                {                var jsonText = RedisHelper.BlockingPopItemFromList("async_write_list");                var o = (JObject)JsonConvert.DeserializeObject(jsonText);                if (o["need_newcache"].ToString() != "0") continue;                spName=o["action"].ToString();                var jObject = o["paras"];                var paras = new MySqlParameter[jObject.Children().Count()];                var count = 0;                foreach (JProperty item in jObject.Children())                {                    if (item.Value.ToString().Length >=1024)                    {                        paras[count] = new MySqlParameter(item.Name, MySqlDbType.MediumText);                        //var bytes = System.Text.Encoding.UTF8.GetBytes(item.Value.ToString());                         //paras[count].Value = bytes;                        //如果下面的代碼不行，試試上面注釋掉的代碼                        paras[count].Value = item.Value.ToString();                    }                    else                    {                        paras[count] = new MySqlParameter(item.Name, MySqlDbType.VarChar, 1024);                        paras[count].Value = item.Value;                        }                                        count++;                }                  SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionString, CommandType.StoredProcedure, spName, paras);                  Program.myFrm.SetTextMessage("成功寫入非同步資料庫記錄，調用的預存程序：" + spName, 3);                }                catch (Exception err)                {                    Program.myFrm.SetTextMessage("寫入非同步資料庫記錄失敗，調用的預存程序：" + spName+"，錯誤原因："+err, 3);                }            }        }

 

串列寫隊列的MYSQL大文本參數