找到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]