public static string Dt2Json(string jsonName, DataTable dt) { try { StringBuilder Json = new StringBuilder(); if (jsonName != "") { Json.Append("{\"" + jsonName + "\":["); } else { Json.Append("{["); } if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { Json.Append("{"); for (int j = 0; j < dt.Columns.Count; j++) { Json.Append("\"" + dt.Columns[j].ColumnName.ToString() + "\":\"" + dt.Rows[i][j].ToString() + "\""); if (j < dt.Columns.Count - 1) { Json.Append(","); } } Json.Append("}"); if (i < dt.Rows.Count - 1) { Json.Append(","); } } } Json.Append("]}"); return(Json.ToString()); } catch (Exception ex) { GLog.LogError(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + " 方法名:GFun:Dt2Json 异常:" + ex.Message); return(""); } }
/// <summary> /// 执行 非查询 sql语句(插入,删除,修改等) /// </summary> /// <param name="strSql">sql语句</param> /// <returns>返回命令影响行数 返回-1时命令出错</returns> public static int ExecuteNonQuery(String strSql, SqlConnection cnn) { SqlCommand cmd = new SqlCommand(strSql, cnn); int nReturn = -1; try { cnn.Open(); nReturn = cmd.ExecuteNonQuery(); } catch (SqlException e) { GLog.LogError("ExecuteNonQuery", e); } finally { cnn.Close(); cnn = null; } return(nReturn); }
/// <summary> /// 执行 非查询 sql语句(插入,删除,修改等) /// </summary> /// <param name="strSql">sql语句</param> /// <param name="cmdType">命令字符串类型,如text,StoredProcedure</param> /// <param name="cmdParms">命令执行参数</param> /// <returns>返回命令影响行数 返回-1时命令出错</returns> public static int ExecuteNonQuery(String strSql, CommandType cmdType, SqlParameter[] cmdParms, SqlConnection cnn) { SqlCommand cmd = PrepareCommand(cnn, null, cmdType, strSql, cmdParms); int nReturn = -1; try { cnn.Open(); nReturn = cmd.ExecuteNonQuery(); } catch (SqlException e) { GLog.LogError("ExecuteNonQuery", e); } finally { cnn.Close(); cnn = null; } return(nReturn); }
/// <summary> /// 执行返回查询第一行第一列内容命令 /// </summary> /// <param name="strSql">sql语句</param> /// <param name="cmdType">命令字符串类型,如text,StoredProcedure</param> /// <param name="cmdParms">命令执行参数</param> /// <returns>返回查询结果中的第一行第一列</returns> public static object ExecuteScalar(String strSql, CommandType cmdType, SqlParameter[] cmdParms, SqlConnection cnn) { SqlCommand cmd = PrepareCommand(cnn, null, cmdType, strSql, cmdParms); object oReturn = null; try { cnn.Open(); oReturn = cmd.ExecuteScalar(); } catch (SqlException e) { GLog.LogError("ExecuteScalar", e); } finally { cnn.Close(); cnn = null; } return(oReturn); }
/// <summary> /// 执行返回查询第一行第一列内容命令 /// </summary> /// <param name="strSql">sql语句</param> /// <returns>返回查询结果中的第一行第一列</returns> public static object ExecuteScalar(String strSql, SqlConnection cnn) { SqlCommand cmd = new SqlCommand(strSql, cnn); object oReturn = null; try { cnn.Open(); oReturn = cmd.ExecuteScalar(); } catch (SqlException e) { GLog.LogError("ExecuteScalar", e); } finally { cnn.Close(); cnn = null; } return(oReturn); }
/// <summary> /// 执行查询命令,尽量不要使用此函数 /// </summary> /// <param name="strSql">sql语句</param> /// <returns>返回SqlDataReader</returns> public static SqlDataReader ExecuteReader(String strSql, SqlConnection cnn) { SqlCommand cmd = new SqlCommand(strSql, cnn); SqlDataReader oReader = null; try { cnn.Open(); oReader = cmd.ExecuteReader(CommandBehavior.CloseConnection | CommandBehavior.SequentialAccess); } catch (SqlException e) { GLog.LogError("ExecuteReader", e); } catch (Exception e) { GLog.LogError("ExecuteReader", e); } finally { } return(oReader); }