/// <summary>
/// 执行存储过程返回json
/// </summary>
/// <param name="proc">存储过程</param>
/// <returns>返回json</returns>
public string Json(Proc proc)
{
string s = string.Empty;
using (DbDataReader dr = ExecuteReader(proc))
{
s = ToJson.DataReaderToJson(dr);
}
Close();
return(s);
}
/// <summary>
/// 执行sql返回json
/// </summary>
/// <param name="sql">执行的sql语句</param>
/// <param name="type">执行类型</param>
/// <returns>返回json</returns>
public string Json(string sql, CommandType type)
{
string s = string.Empty;
using (DbDataReader dr = ExecuteReader(sql, type))
{
s = ToJson.DataReaderToJson(dr);
}
Close();
return(s);
}
