using
System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace OTC.Utility
{
public sealed class JSONHelper
{
/// 获取JSON字符串
/// 值
/// 数据表名
public static string GetJSON(SqlDataReader drValue, string strTableName)
{
StringBuilder sb = new StringBuilder();
sb.AppendLine( " { " );
sb.AppendLine( " " + strTableName + " :{ " );
sb.AppendLine( " records:[ " );
try
{
while (drValue.Read())
{
sb.Append( " { " );
for ( int i = 0 ; i < drValue.FieldCount; i ++ )
{
sb.AppendFormat( "" { 0 } " : " { 1 } " , " , drValue.GetName(i), drValue.GetValue(i));
}
sb.Remove(sb.ToString().LastIndexOf(’,’), 1 );
sb.AppendLine( " }, " );
}
sb.Remove(sb.ToString().LastIndexOf(’,’), 1 );
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
drValue.Close();
}
sb.AppendLine( " ] " );
sb.AppendLine( " } " );
sb.AppendLine( " }; " );
return sb.ToString();
}
}
}
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace OTC.Utility
{
public sealed class JSONHelper
{
/// 获取JSON字符串
/// 值
/// 数据表名
public static string GetJSON(SqlDataReader drValue, string strTableName)
{
StringBuilder sb = new StringBuilder();
sb.AppendLine( " { " );
sb.AppendLine( " " + strTableName + " :{ " );
sb.AppendLine( " records:[ " );
try
{
while (drValue.Read())
{
sb.Append( " { " );
for ( int i = 0 ; i < drValue.FieldCount; i ++ )
{
sb.AppendFormat( "" { 0 } " : " { 1 } " , " , drValue.GetName(i), drValue.GetValue(i));
}
sb.Remove(sb.ToString().LastIndexOf(’,’), 1 );
sb.AppendLine( " }, " );
}
sb.Remove(sb.ToString().LastIndexOf(’,’), 1 );
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
drValue.Close();
}
sb.AppendLine( " ] " );
sb.AppendLine( " } " );
sb.AppendLine( " }; " );
return sb.ToString();
}
}
}