public string ConvertTo(object obj)
{
if (obj == null)
{
return("");
}
string rtn = "";
UnitDataCollection udc = null;
if (obj is UnitDataCollection)
{
udc = (UnitDataCollection)obj;
}
else
{
throw new Exception("QueryByPage2Json无法转化" + obj.GetType().FullName + "类型数据!");
}
if (udc.QueryTable != null)
{
JsonObjectCollection jsonrtn = new JsonObjectCollection();
//jsonrtn.Add(new JsonStringValue("Count_Of_OnePage", udc.Count_Of_OnePage + ""));
jsonrtn.Add(new JsonStringValue("page", udc.CurrentPage + ""));
//jsonrtn.Add(new JsonStringValue("total", udc.TotalPage + ""));
jsonrtn.Add(new JsonStringValue("total", udc.TotalRow + ""));
DataTableStd dts = udc.QueryTable;
JsonArrayCollection jsonobj = new JsonArrayCollection("rows");
for (int j = 0; j < dts.RowLength; j++)
{
JsonObjectCollection jac = new JsonObjectCollection();
foreach (string colname in dts.ColumnNames)
{
if (dts.ColumnDateType(colname).FullName == typeof(DateTime).FullName)
{
DateTimeStd dtime = DateTimeStd.ParseStd(dts[j, colname]);
jac.Add(new JsonStringValue(colname, dtime != null ? dtime.Value.ToString("yyyy/MM/dd HH:mm:ss") : ""));
}
else
{
jac.Add(new JsonStringValue(colname, ComFunc.nvl(dts[j, colname])));
}
}
jsonobj.Add(jac);
}
jsonrtn.Add(jsonobj);
rtn = jsonrtn.ToString();
}
return(rtn);
}
public string ConvertTo(object obj)
{
string rtn = "";
if (obj == null)
{
return("");
}
DataSet ds = null;
if (obj is DataSet)
{
ds = (DataSetStd)obj;
}
else
{
throw new Exception("DataSet2Json无法转化" + obj.GetType().FullName + "类型数据!");
}
JsonObjectCollection jsonrtn = new JsonObjectCollection();
for (int i = 0; i < ds.Tables.Count; i++)
{
DataTableStd dts = DataTableStd.ParseStd(ds.Tables[i]);
JsonArrayCollection jsonobj = new JsonArrayCollection("TableData" + i);
for (int j = 0; j < dts.RowLength; j++)
{
JsonObjectCollection jac = new JsonObjectCollection();
foreach (string colname in dts.ColumnNames)
{
if (dts.ColumnDateType(colname).FullName == typeof(DateTime).FullName)
{
DateTimeStd dtime = DateTimeStd.ParseStd(dts[j, colname]);
jac.Add(new JsonStringValue(colname, dtime != null ? dtime.Value.ToString("yyyy/MM/dd HH:mm:ss") : ""));
}
else
{
jac.Add(new JsonStringValue(colname, ComFunc.nvl(dts[j, colname])));
}
}
jsonobj.Add(jac);
}
jsonrtn.Add(jsonobj);
}
rtn = "{" + jsonrtn.ToString() + "}";
return(rtn);
}
public JsonCollection ConvertTo(object obj)
{
if (obj == null)
{
return(new JsonObjectCollection());
}
DataTableStd dtt = null;
if (obj is DataTable)
{
dtt = DataTableStd.ParseStd(obj);
}
else if (obj is DataTableStd)
{
dtt = (DataTableStd)obj;
}
else
{
throw new Exception("DataTable2Json无法转化" + obj.GetType().FullName + "类型数据!");
}
JsonArrayCollection jsonobj = new JsonArrayCollection("rows");
for (int i = 0; i < dtt.RowLength; i++)
{
JsonObjectCollection jac = new JsonObjectCollection();
foreach (string colname in dtt.ColumnNames)
{
if (dtt.ColumnDateType(colname).FullName == typeof(DateTime).FullName)
{
DateTimeStd dtime = DateTimeStd.ParseStd(dtt[i, colname]);
jac.Add(new JsonStringValue(colname, dtime != null ? dtime.Value.ToString("yyyy/MM/dd HH:mm:ss") : ""));
}
else
{
jac.Add(new JsonStringValue(colname, ComFunc.nvl(dtt[i, colname])));
}
}
jsonobj.Add(jac);
}
return(jsonobj);
}