将DataSet（DataTable)转换成JSON格式（生成JS文件存储）

        public static string CreateJsonParameters(DataTable dt)
        {
          /**/
          /**/
          /**/
          /* /****************************************************************************
          * Without goingin to the depth of the functioning of this Method, i will try to give an overview
          * As soon as this method gets a DataTable it starts to convert it into JSON String,
          * it takes each row and in each row it grabs the cell name and its data.
          * This kind of JSON is very usefull when developer have to have Column name of the .
          * Values Can be Access on clien in this way. OBJ.HEAD[0].<ColumnName>
          * NOTE: One negative point. by this method user will not be able to call any cell by its index.
         * *************************************************************************/
            StringBuilder JsonString = new StringBuilder();
            //Exception Handling        
            if (dt != null && dt.Rows.Count > 0)
            {
                JsonString.Append("{ ");
                JsonString.Append(""Table":[ ");
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    JsonString.Append("{ ");
                    for (int j = 0; j < dt.Columns.Count; j++)
                    {
                        if (j < dt.Columns.Count - 1)
                        {
                            JsonString.Append(""" + dt.Columns[j].ColumnName.ToString() + "":" + """ + dt.Rows[i][j].ToString() + "",");
                        }
                        else if (j == dt.Columns.Count - 1)
                        {
                            JsonString.Append(""" + dt.Columns[j].ColumnName.ToString() + "":" + """ + dt.Rows[i][j].ToString() + """);
                        }
                    }
                    /**/
                    /**/
                    /**/
                    /*end Of String*/
                    if (i == dt.Rows.Count - 1)
                    {
                        JsonString.Append("} ");
                    }
                    else
                    {
                        JsonString.Append("}, ");
                    }
                }
                JsonString.Append("]}");
                return JsonString.ToString();
            }
            else
            {
                return null;
            }
        }

效果图如下：

{"Table":
  [
   {"id":"14","title":"长沙地铁通了","addtime":"2008-08-08"},
   {"id":"15","title":"长沙","addtime":"2008-09-12"},
   {"id":"17","title":"长沙","addtime":"2008-09-19"},
   {"id":"21","title":"长沙","addtime":"2008-09-25"}
  ]
}

 #region dataTable转换成Json格式
        /// <summary>      
        /// dataTable转换成Json格式      
        /// </summary>      
        /// <param name="dt"></param>      
        /// <returns></returns>      
        public static string ToJson(ArrayList aliJson)
        {
            StringBuilder sbuBuilder = new StringBuilder();
            sbuBuilder.Append("{"Value":[");
            for (int i = 0; i < aliJson.Count; i++)
            {
                sbuBuilder.Append(""");
                sbuBuilder.Append(aliJson[i].ToString().Replace(""", "\""));
                sbuBuilder.Append("",");
            }
            if (aliJson.Count > 0)
            {
                sbuBuilder.Remove(sbuBuilder.Length - 1, 1);
            }
            sbuBuilder.Append("]}");
            string strJson = sbuBuilder.ToString();
            strJson = strJson.Replace("
", "<br />");
            strJson = strJson.Replace("
", "<br />");
            return strJson;//sbuBuilder.ToString();
        }
        public static string ToJson(DataTable dtaJson)
        {
            StringBuilder sbuBuilder = new StringBuilder();
            sbuBuilder.Append("{"Rows":[");
            for (int i = 0; i < dtaJson.Rows.Count; i++)
            {
                sbuBuilder.Append("[");
                for (int j = 0; j < dtaJson.Columns.Count; j++)
                {
                    sbuBuilder.Append(""");
                    sbuBuilder.Append(dtaJson.Rows[i][j].ToString().Replace(""", "\"").Replace("
", "<br>"));
                    sbuBuilder.Append("",");
                }
                sbuBuilder.Remove(sbuBuilder.Length - 1, 1);
                sbuBuilder.Append("],");
            }
            if (dtaJson.Rows.Count > 0)
            {
                sbuBuilder.Remove(sbuBuilder.Length - 1, 1);
            }
            sbuBuilder.Append("]}");

            string strJson = sbuBuilder.ToString();
            strJson = strJson.Replace("
", "<br />");
            strJson = strJson.Replace("
", "<br />");

            return strJson;//sbuBuilder.ToString();
        }

        #endregion dataTable转换成Json格式

        #region DataSet转换成Json格式
        /// <summary>      
        /// DataSet转换成Json格式      
        /// </summary>      
        /// <param name="ds">DataSet</param>      
        /// <returns></returns>      
        public static string ToJson(DataSet dseJson)
        {
            StringBuilder sbuBuilder = new StringBuilder();
            sbuBuilder.Append("{"Tables":[");
            foreach (DataTable dtJson in dseJson.Tables)
            {
                sbuBuilder.Append(ToJson(dtJson) + ",");
            }
            sbuBuilder.Remove(sbuBuilder.Length - 1, 1);
            sbuBuilder.Append("]}");

            string strJson = sbuBuilder.ToString();
            strJson = strJson.Replace("
", "<br />");
            strJson = strJson.Replace("
", "<br />");
            return strJson;//sbuBuilder.ToString();
        }
        #endregion



        /// <summary>
        /// 带表头的
        /// </summary>
        /// <param name="dtaJson"></param>
        /// <param name="b"></param>
        /// <returns></returns>
        public static string ToJson(DataTable dtaJson, bool b)
        {
            StringBuilder sbuBuilder = new StringBuilder();
            sbuBuilder.Append("{"Rows":[");
            for (int i = 0; i < dtaJson.Rows.Count; i++)
            {
                sbuBuilder.Append("{");
                for (int j = 0; j < dtaJson.Columns.Count; j++)
                {

                    sbuBuilder.Append(""" + dtaJson.Columns[j].ColumnName + "":");
                    sbuBuilder.Append(""");
                    sbuBuilder.Append(dtaJson.Rows[i][j].ToString().Replace(""", "\"").Replace("
", "<br>"));
                    sbuBuilder.Append("",");
                }
                sbuBuilder.Remove(sbuBuilder.Length - 1, 1);
                sbuBuilder.Append("},");
            }
            if (dtaJson.Rows.Count > 0)
            {
                sbuBuilder.Remove(sbuBuilder.Length - 1, 1);
            }
            sbuBuilder.Append("]}");

            string strJson = sbuBuilder.ToString();
            strJson = strJson.Replace("
", "<br />");
            strJson = strJson.Replace("
", "<br />");

            return strJson;//sbuBuilder.ToString();
        }

        /// <summary>
        /// 带表头的
        /// </summary>
        /// <param name="dseJson"></param>
        /// <returns></returns>
        public static string ToJson(DataSet dseJson, bool b)
        {
            StringBuilder sbuBuilder = new StringBuilder();
            sbuBuilder.Append("{"Tables":[");
            foreach (DataTable dtJson in dseJson.Tables)
            {
                sbuBuilder.Append(ToJson(dtJson, true) + ",");
            }
            sbuBuilder.Remove(sbuBuilder.Length - 1, 1);
            sbuBuilder.Append("]}");


            string strJson = sbuBuilder.ToString();
            strJson = strJson.Replace("
", "<br />");
            strJson = strJson.Replace("
", "<br />");
            return strJson;//sbuBuilder.ToString();
        }

前台需转换：var result=eval("("+ajax(url)+")");

将DataSet（DataTable)转换成JSON格式并存储

  /// <summary>
        /// 临时方法 把【字典表】生成js文件 职位等
        /// </summary>
        public static string funTemp(string total)
        {
            DataSet ds = hrSystem.DAL.commd.dalcomd.P_Sys_getTableCoum("职位表", "dictNO,parentNO, Explainss ", "intType", total);
            DataTable dt = ds.Tables[0];
            DataTable CurrDt = dt;
            StringBuilder sbuBuilder = new StringBuilder();
            sbuBuilder.Append("{"Item":[");
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (dt.Rows[i]["parentNO"] == DBNull.Value)
                {

                    DataRow[] drTemp1 = dt.Select(" parentNO='" + dt.Rows[i]["dictNO"].ToString() + "'");

                    sbuBuilder.Append("[");
                    for (int j = 0; j < dt.Columns.Count; j++)
                    {
                        sbuBuilder.Append(""");
                        sbuBuilder.Append(dt.Rows[i][j].ToString().Replace(""", "\"").Replace("
", "<br>"));
                        sbuBuilder.Append("",");
                    }
                    if (dt.Rows[i]["parentNO"] == DBNull.Value)
                    {

                        DataTable dtTemp2 = new DataTable();
                        for (int j = 0; j < dt.Columns.Count; j++)
                        {
                            dtTemp2.Columns.Add("");
                        }
                        foreach (DataRow drTemp in dt.Select(" parentNO='" + dt.Rows[i]["dictNO"].ToString() + "'"))
                        {
                            string[] dtAppend = new string[drTemp.ItemArray.Length];
                            for (int k = 0; k < drTemp.ItemArray.Length; k++)
                            {
                                dtAppend[k] = drTemp.ItemArray[k].ToString();
                            }
                            dtTemp2.Rows.Add(dtAppend);
                        }

                        sbuBuilder.Append(ToJson(dtTemp2) + "}");
                        dtTemp2.Clear();
                    }

                    sbuBuilder.Remove(sbuBuilder.Length - 1, 1);
                    sbuBuilder.Append("],,");

                    if (dt.Rows.Count > 0)
                    {
                        sbuBuilder.Remove(sbuBuilder.Length - 1, 1);
                    }


                }

            }
            sbuBuilder.Remove(sbuBuilder.Length - 1, 1);
            sbuBuilder.Append("]}");
            return sbuBuilder.ToString();
        }


        /// <summary>
        /// 临时方法 把字典表生成js文件 城市
        /// </summary>
        public static string funTemp1()
        {
            DataSet ds = hrSystem.DAL.commd.dalcomd.P_Sys_getTableCoum("城市表", "intCrtyCode,intParentCrtyCode,strName,intType,strSpell ", "1", "1");
            DataTable dt = ds.Tables[0];
            DataTable CurrDt = dt;
            StringBuilder sbuBuilder = new StringBuilder();
            sbuBuilder.Append("{"Item":[");
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (dt.Rows[i]["intParentCrtyCode"].ToString() == "-1")
                {

                    DataRow[] drTemp1 = dt.Select(" intParentCrtyCode='" + dt.Rows[i]["intCrtyCode"].ToString() + "'");

                    sbuBuilder.Append("[");
                    for (int j = 0; j < dt.Columns.Count; j++)
                    {
                        sbuBuilder.Append(""");
                        sbuBuilder.Append(dt.Rows[i][j].ToString().Replace(""", "\"").Replace("
", "<br>"));
                        sbuBuilder.Append("",");
                    }
                    if (dt.Rows[i]["intParentCrtyCode"].ToString() == "-1")
                    {

                        DataTable dtTemp2 = new DataTable();
                        for (int j = 0; j < dt.Columns.Count; j++)
                        {
                            dtTemp2.Columns.Add("");
                        }
                        foreach (DataRow drTemp in dt.Select(" intParentCrtyCode='" + dt.Rows[i]["intCrtyCode"].ToString() + "'"))
                        {
                            string[] dtAppend = new string[drTemp.ItemArray.Length];
                            for (int k = 0; k < drTemp.ItemArray.Length; k++)
                            {
                                dtAppend[k] = drTemp.ItemArray[k].ToString();
                            }
                            dtTemp2.Rows.Add(dtAppend);
                        }

                        sbuBuilder.Append(ToJson(dtTemp2) + "}");
                        dtTemp2.Clear();
                    }

                    sbuBuilder.Remove(sbuBuilder.Length - 1, 1);
                    sbuBuilder.Append("],");
                }
            }
            sbuBuilder.Remove(sbuBuilder.Length - 1, 1);
            sbuBuilder.Append("]}");
            return sbuBuilder.ToString();
        }


        /// <summary>
        /// 临时方法 把字典表生成js文件 类别
        /// </summary>
        public static string funTemp2()
        {
            DataSet ds = hrSystem.DAL.commd.dalcomd.P_Sys_getTableCoum("类别表", "strNumberKey,strParent,strName,strGotoUri,intOrder", "intisShow", "1");
            DataTable dt = ds.Tables[0];
            DataTable CurrDt = dt;
            StringBuilder sbuBuilder = new StringBuilder();
            sbuBuilder.Append("{"Item":[");
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (dt.Rows[i]["strParent"].ToString() == "")
                {
                    sbuBuilder.Append("[");
                    for (int j = 0; j < dt.Columns.Count; j++)
                    {
                        sbuBuilder.Append(""");
                        sbuBuilder.Append(dt.Rows[i][j].ToString().Replace(""", "\"").Replace("
", "<br>"));
                        sbuBuilder.Append("",");
                    }
                    if (dt.Rows[i]["strParent"].ToString() == "")
                    {

                        DataTable dtTemp2 = new DataTable();
                        for (int j = 0; j < dt.Columns.Count; j++)
                        {
                            dtTemp2.Columns.Add("");
                        }
                        foreach (DataRow drTemp in dt.Select(" strParent='" + dt.Rows[i]["strNumberKey"].ToString() + "'", "intOrder desc"))
                        {
                            string[] dtAppend = new string[drTemp.ItemArray.Length];
                            for (int k = 0; k < drTemp.ItemArray.Length; k++)
                            {
                                dtAppend[k] = drTemp.ItemArray[k].ToString();
                            }
                            dtTemp2.Rows.Add(dtAppend);
                        }

                        sbuBuilder.Append(ToJson(dtTemp2) + "}");
                        dtTemp2.Clear();
                    }

                    sbuBuilder.Remove(sbuBuilder.Length - 1, 1);
                    sbuBuilder.Append("],");
                }
            }
            sbuBuilder.Remove(sbuBuilder.Length - 1, 1);
            sbuBuilder.Append("]}");
            return sbuBuilder.ToString();
        }





/// <summary>
        /// 临时方法 生成js文件  hy
        /// </summary>
        public static void OutJsToJson_Mall()
        {
            string tempJs = ReadFile(System.Web.HttpContext.Current.Server.MapPath("~/Temp/Temp_FileMallJS.shtml"));
            //类别
            string shopsType = hrSystem.BLL.commd.ToJosn.funTemp2();
            tempJs = tempJs.Replace("{&data_shopsType&}", shopsType);

            WriteFile(System.Web.HttpContext.Current.Server.MapPath("~/Mall/js"), "globalMallJson.js", tempJs);//前台
           // WriteFile(System.Web.HttpContext.Current.Server.MapPath("~/Sys//js/Mall"), "globalMallJson.js", tempJs);//后台
        }




 /// <summary>
        /// 读取
        /// </summary>
        /// <param name="FileName">完整路径</param>
        /// <returns></returns>
        public static string ReadFile(string FileName)
        {
            using (StreamReader srFile = new StreamReader(FileName, System.Text.Encoding.UTF8))
            {
                string strResult = srFile.ReadToEnd();
                return strResult;
            }
        }


        /// <summary>
        /// 写入
        /// </summary>
        /// <param name="FilePath">完整路劲</param>
        /// <param name="FileName">文件名包括后缀</param>
        /// <param name="content">内容</param>
        public static void WriteFile(string FilePath, string FileName, string content)
        {
            string strFilePath = FilePath + "//" + FileName;
            if (!Directory.Exists(FilePath))
            {
                Directory.CreateDirectory(FilePath);
            }

            StreamWriter write = new StreamWriter(strFilePath, false, System.Text.Encoding.UTF8);
            write.Write(content);
            write.Close();
        }


        /// <summary>
        /// 删除文件
        /// </summary>
        public static void deleteFile(string path)
        {
            try
            {
                FileInfo file = new FileInfo(path);
                file.Delete();
            }
            catch (Exception ex)
            {
                //写入日志
                string msg = "删除文件【BLL.commd.deleteEntInfo】:
 地址：" + path + "
 时间:" + DateTime.Now.ToString("yyyyMMdd-hhmmss");
                dalcomd.wLog(LogLevel.Error, msg, ex);
            }
        }

        //去除html标签
        public static string ParseTags(string HTMLStr)
        {
            HTMLStr = HTMLStr.Replace("&nbsp;", "");
            HTMLStr = System.Text.RegularExpressions.Regex.Replace(HTMLStr, "<[^>]*>", "");

            HTMLStr = HTMLStr.Replace("
", "");

            // HTMLStr = System.Text.RegularExpressions.Regex.Replace(HTMLStr, "
", "");
            return HTMLStr;
        }