DataTable转Json（兼容easyUI特殊json分页）

       private static readonly System.Web.Script.Serialization.JavaScriptSerializer Serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
       /// <summary>
       /// DataTabel转标准json（兼用easyui的json标准）
       /// </summary>
       /// <param name="dt">DataTable数据源</param>
       /// <param name="total">可选：转普通json传>0的值或忽略此参数；如果针对easyui的json一定要把total参数分页的总行数传进来</param>
       /// <returns>标准json</returns>
       public static string DtToJson(this DataTable dt, int total)
       {
           Serializer.MaxJsonLength = Int32.MaxValue; //取得最大数值
           System.Collections.ArrayList arrayList = new System.Collections.ArrayList();
           foreach (DataRow dataRow in dt.Rows)
           {
               try
               {
                   Dictionary<string, object> dictionary = new Dictionary<string, object>();  //实例化一个参数集合
                   foreach (DataColumn dataColumn in dt.Columns)
                   {
                       dictionary.Add(dataColumn.ColumnName, dataRow[dataColumn.ColumnName].ToString());
                   }
                   arrayList.Add(dictionary); //ArrayList集合中添加键值
               }
               catch (Exception ex)
               {
               }
           }
           if (total > 0)//easyUI专用,分页的总行数
           {
               var dictionary = new Dictionary<string, object>();
               dictionary.Add("total", total);//此参数是easyUI专用
               dictionary.Add("rows", arrayList);//此参数是easyUI专用
               return Serializer.Serialize(dictionary);
           }
           else
           {
               return Serializer.Serialize(arrayList);
           }
           //返回一个json字符串
       }