/// <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); }