JSON格式互转集合 (2)
public class JSON
{
public static string DateTimeFormat = "yyyy'-'MM'-'dd'T'HH':'mm':'ss";
public static string Encode(object o)
{
if (o == null || o.ToString() == "null") return null;
if (o != null && (o.GetType() == typeof(String) || o.GetType() == typeof(string)))
{
return o.ToString();
}
IsoDateTimeConverter dt = new IsoDateTimeConverter();
dt.DateTimeFormat = DateTimeFormat;
return JsonConvert.SerializeObject(o, dt);
}
public static object Decode(string json)
{
if (String.IsNullOrEmpty(json)) return "";
object o = JsonConvert.DeserializeObject(json);
if (o.GetType() == typeof(String) || o.GetType() == typeof(string))
{
o = JsonConvert.DeserializeObject(o.ToString());
}
object v = toObject(o);
return v;
}
public static object Decode(string json, Type type)
{
return JsonConvert.DeserializeObject(json, type);
}
private static object toObject(object o)
{
if (o == null) return null;
if (o.GetType() == typeof(string))
{
//判断是否符合2010-09-02T10:00:00的格式
string s = o.ToString();
if (s.Length == 19 && s[10] == 'T' && s[4] == '-' && s[13] == ':')
{
o = System.Convert.ToDateTime(o);
}
} else if (o is JObject)
{
JObject jo = o as JObject;
Hashtable h = new Hashtable();
foreach (KeyValuePair<string, JToken> entry in jo)
{
h[entry.Key] = toObject(entry.Value);
}
o = h;
} else if (o is IList)
{
ArrayList list = new ArrayList();
list.AddRange((o as IList));
int i = 0, l = list.Count;
for (; i < l; i++)
{
list[i] = toObject(list[i]);
}
o = list;
} else if (typeof(JValue) == o.GetType())
{
JValue v = (JValue)o;
o = toObject(v.Value);
}else {
}
return o;
}
public static ArrayList DataTable2ArrayList(DataTable data)
{
ArrayList array = new ArrayList();
for (int i = 0; i < data.Rows.Count; i++)
{
DataRow row = data.Rows[i];
Hashtable record = new Hashtable();
for (int j = 0; j < data.Columns.Count; j++)
{
object cellValue = row[j];
if (cellValue.GetType() == typeof(DBNull))
{
cellValue = null;
}
record[data.Columns[j].ColumnName] = cellValue;
}
array.Add(record);
}
return array;
}
/// <summary>
/// 将一个DataTable 转为一个JSON
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public static string DataTable2Json(DataTable dt)
{
if (dt == null)
{
return "";
}
ArrayList dataAll = DataTable2ArrayList(dt);
ArrayList data = new ArrayList();
for (int i = 0, l = dataAll.Count; i < l; i++)
{
Hashtable record = (Hashtable)dataAll[i];
if (record == null) continue;
data.Add("'" + record + "'");
}
Hashtable result = new Hashtable();
result["data"] = data;
result["total"] = dataAll.Count;
return JSON.Encode(dt);
}
/// <summary>
/// 通过一个datatable 返回一个json字符串
/// </summary>
/// <param name="dt">按条件的datatable(分页内的列表)</param>
/// <param name="AllCount">datatable的总条数(分页时的总记录)</param>
/// <returns></returns>
public static string DataTable2Json(DataTable dt, int AllCount)
{
if (dt == null)
{
return "";
}
ArrayList dataAll = DataTable2ArrayList(dt);
//实现一个内存分页(实际应该使用SQL分页)
ArrayList data = new ArrayList();
for (int i = 0, l = dataAll.Count; i < l; i++)
{
Hashtable record = (Hashtable)dataAll[i];
if (record == null) continue;
data.Add(record);
}
Hashtable result = new Hashtable();
result["data"] = data;
result["total"] = AllCount;
return JSON.Encode(result);
}
/// <summary>
/// 通过一个datatable 返回一个json字符串
/// </summary>
/// <param name="dt">按条件的datatable(分页内的列表)</param>
/// <param name="AllCount">datatable的总条数(分页时的总记录)</param>
/// <returns></returns>
public static string DataTable2Json(DataTable dt, int AllCount, Hashtable hashtable)
{
if (dt == null)
{
return "";
}
ArrayList dataAll = DataTable2ArrayList(dt);
//实现一个内存分页(实际应该使用SQL分页)
ArrayList data = new ArrayList();
for (int i = 0, l = dataAll.Count; i < l; i++)
{
Hashtable record = (Hashtable)dataAll[i];
if (record == null) continue;
data.Add(record);
}
Hashtable result = new Hashtable();
result = hashtable;
result["data"] = data;
result["total"] = AllCount;
return JSON.Encode(result);
}
/// <summary>
/// 分页
/// </summary>
/// <param name="data">表dt</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="pageSize">每页的数目</param>
/// <param name="pageCount">总数目</param>
/// <returns></returns>
public static DataTable dt2newdt(DataTable data, int pageIndex, int pageSize, int pageCount)
{
DataView dv = data.DefaultView;
DataTable dt = dv.Table.Clone();
for (int i = pageIndex * pageSize; i < (pageIndex + 1) * pageSize; i++)
{
if (i == pageCount)
{
break;
}
dt.ImportRow(dv[i].Row);
}
return dt;
}
}
最新文章
- C#ListBox对Item进行重绘,包括颜色
- centos6 一个vlan配置多ip地址
- backbone &; django csrf_token的问题
- ACM: NBUT 1646 Internet of Lights and Switches - 二进制+map+vector
- R语言--数据预处理
- 基于 IdentityServer3 实现 OAuth 2.0 授权服务数据持久化
- RN学习1——前奏,app插件化和热更新的探索
- AMH4.2 虚拟主机面板Tengine版本
- Nginx 实现MySQL的负载均衡
- linux下查看机器的硬件信息:
- windows下ipython的tab补全,只需安装pyreadline即可.
- BringWindowToTop(), SetForegroundWindow(), SetActiveWindow()
- Median of Two Sorted 求两个有序数组的中位数
- C#如何判断线程池中所有的线程是否已经完成之Demo
- Redhat 安装ftp服务
- 51nod_1831: 小C的游戏(Bash博弈 找规律)
- Hibernate 实体关联关系映射----总结
- ReactNative 基础学习
- z-index使用及一定要加backgroun
- Java新建Web应用与配置Tomcat流程
热门文章
- /proc/sys/net/ipv4/ip_conntrack_max
- LevelListDrawable
- AnimationDrawable
- openpose关节图
- 思科常见的防病毒ACL
- 关于adb命令获取安卓手机uuid时,demon 显示启动成功,但又获取不到uuid的解决办法:现象如下所示
- spring mvc 返回JSON数据
- 移动应用端的支付宝支付php开发流程
- html5 商品分类页面效果zepto
- Python3 Selenium自动化web测试 ==>;FAQ:日期格式和日期字符串格式相互转换