关于Win7、Win2008后台js报错的解决方法

时间:2011-11-18 阅读:
找到dtHelp.cs文件修改 public static string DT2JSON如下
 
                     public static string DT2JSON(DataTable dt, int fromCount, string totalCountStr, string tbname, bool formatData)
                     {
             

找到dtHelp.cs文件修改 public static string DT2JSON如下

 

        public static string DT2JSON(DataTable dt, int fromCount, string totalCountStr, string tbname, bool formatData)
        {
            StringBuilder jsonBuilder = new StringBuilder();
            jsonBuilder.Append(totalCountStr + ":" + dt.Rows.Count + "," + tbname + ": [");
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (i > 0)
                    jsonBuilder.Append(",");
                jsonBuilder.Append("{");
                jsonBuilder.Append("no:" + (fromCount + i + 1) + ",");
                for (int j = 0; j < dt.Columns.Count; j++)
                {
                    if (j > 0)
                        jsonBuilder.Append(",");
                    if (dt.Columns[j].DataType.Equals(typeof(DateTime)))
                        jsonBuilder.Append(dt.Columns[j].ColumnName.ToLower() + ": '" + Convert.ToDateTime(dt.Rows[i][j].ToString()).ToString("yyyy-MM-dd hh:mm:ss") + "'");
                    else if (dt.Columns[j].DataType.Equals(typeof(String)))
                        jsonBuilder.Append(dt.Columns[j].ColumnName.ToLower() + ": '" + dt.Rows[i][j].ToString().Replace("\\", "\\\\").Replace("\'", "\\\'").Replace("\t", " ").Replace("\r", " ").Replace("\n", "<br/>") + "'");
                    else
                        jsonBuilder.Append(dt.Columns[j].ColumnName.ToLower() + ": '" + dt.Rows[i][j].ToString() + "'");
                }
                jsonBuilder.Append("}");
            }
            jsonBuilder.Append("]");
            return jsonBuilder.ToString();

        }

 

[责任编辑:jumbot]

[发表评论] [收藏本页]