本文共 3764 字,大约阅读时间需要 12 分钟。
#region datatable转换json /ToJsonList(DataTable dt) ////// datatable转换json /// /// ///public static string ToJsonList(DataTable dt) { StringBuilder jsonString = new StringBuilder(); jsonString.Append("["); DataRowCollection drc = dt.Rows; for (int i = 0; i < drc.Count; i++) { jsonString.Append("{"); jsonString.Append("\"xh\":"); jsonString.Append((i + 1).ToString() + ","); for (int j = 0; j < dt.Columns.Count; j++) { string strKey = dt.Columns[j].ColumnName; string strValue = drc[i][j].ToString(); Type type = dt.Columns[j].DataType; jsonString.Append("\"" + strKey + "\":"); strValue = StringFormat(strValue, type); if (j < dt.Columns.Count - 1) { jsonString.Append(strValue + ","); } else { jsonString.Append(strValue); } } jsonString.Append("},"); } if (jsonString.Length > 1) { jsonString.Remove(jsonString.Length - 1, 1); } jsonString.Append("]"); string str = jsonString.ToString(); return jsonString.ToString(); } #endregion #region 格式化字符型、日期型、布尔型 /StringFormat(string str, Type type) /// /// 格式化字符型、日期型、布尔型 /// /// /// ///private static string StringFormat(string str, Type type) { if (type == typeof(string)) { str = String2Json(str); str = "\"" + str + "\""; } else if (type == typeof(DateTime)) { //str = "\"" + str + "\""; if (string.IsNullOrEmpty(str.Trim())) { str = "\"" + str + "\""; } else { str = "\"" + DateTime.Parse(str.Trim()).ToString("yyyy-MM-dd HH:mm:ss") + "\""; } } else if (type == typeof(bool)) { str = str.ToLower(); } else if (type != typeof(string) && string.IsNullOrEmpty(str)) { str = "\"" + str + "\""; } return str; } #endregion #region 过滤特殊字符 /String2Json(String s) /// /// 过滤特殊字符 /// /// 字符串 ///json字符串 private static string String2Json(String s) { StringBuilder sb = new StringBuilder(); for (int i = 0; i < s.Length; i++) { char c = s.ToCharArray()[i]; switch (c) { case '\"': sb.Append("\\\""); break; case '\\': sb.Append("\\\\"); break; case '/': sb.Append("\\/"); break; case '\b': sb.Append("\\b"); break; case '\f': sb.Append("\\f"); break; case '\n': sb.Append("\\n"); break; case '\r': sb.Append("\\r"); break; case '\t': sb.Append("\\t"); break; default: sb.Append(c); break; } } return sb.ToString(); } #endregion
转载地址:http://jthbb.baihongyu.com/