public override DataTable ExecuteQuery(string cmdText, DBHelperParmCollection parameters) { DataTable dtRet = new DataTable(); OdbcCommand _OdbcCommand = (OdbcCommand)CreateCommand(cmdText, CommandType.Text); _OdbcCommand.Parameters.Clear(); if (parameters != null) { foreach (DBHelperParm para in parameters) { _OdbcCommand.Parameters.Add(new OdbcParameter("?" + para.Key, para.Value)); } } OdbcDataAdapter _OdbcDataAdapter = new OdbcDataAdapter(_OdbcCommand); try { _OdbcDataAdapter.Fill(dtRet); } catch (Exception ex) { throw ex; } return(dtRet); }
/// <summary> /// 执行存储过程,返回结果数据 /// </summary> /// <param name="procedureName">过程名</param> public override DataTable ExecuteProcedureQuery(string procedureName, DBHelperParmCollection parameters) { try { DataTable dtbRtn = new DataTable(); string realProcedureName = string.Format("{{CALL {0} (", procedureName); for (int i = 0; i < parameters.Count; i++) { realProcedureName += "?,"; } realProcedureName = realProcedureName.Substring(0, realProcedureName.Length - 1); realProcedureName += ")}"; OdbcCommand _OdbcCommand = (OdbcCommand)CreateCommand(realProcedureName, CommandType.StoredProcedure); if (parameters != null) { foreach (DBHelperParm para in parameters) { _IDbCommand.Parameters.Add(new OdbcParameter("?" + para.Key, para.Value)); } } OdbcDataAdapter _OdbcDataAdapter = new OdbcDataAdapter(_OdbcCommand); _OdbcDataAdapter.Fill(dtbRtn); return(dtbRtn); } catch (Exception ex) { throw ex; } }
public override DataTable ExecuteQuery(string cmdText, DBHelperParmCollection parameters) { DataTable dtRet = new DataTable(); AseCommand _AseCommand = (AseCommand)CreateCommand(cmdText, CommandType.Text); _AseCommand.Parameters.Clear(); if (parameters != null) { foreach (DBHelperParm para in parameters) { _AseCommand.Parameters.Add(new AseParameter(para.Key, EncodingHelper.Default2DB(para.Value, _DBEncodeing))); } } AseDataAdapter _OdbcDataAdapter = new AseDataAdapter(_AseCommand); try { ProcessDataTable(dtRet); _OdbcDataAdapter.Fill(dtRet); } catch (Exception ex) { throw ex; } return(dtRet); }
public void Save() { DBHelperParmCollection param = new DBHelperParmCollection(); param.Add(new DBHelperParm("@UserName", "UserName")); param.Add(new DBHelperParm("@Password", "Password")); StringBuilder sbSql = new StringBuilder(""); try { sbSql.Append("INSERT INTO AMP_TEST (UserName,Password) "); sbSql.Append("VALUES (?,?)"); DBHelper.ExecuteNoQuery(sbSql.ToString(), param); } catch (Exception ex) { throw ex; } }
/// <summary> /// 非查询操作 /// </summary> /// <param name="sql">sql字符串</param> /// <param name="parameters">参数集合</param> /// <returns></returns> public static int ExecuteNoQuery(string sql, DBHelperParmCollection parameters) { DBHelperBase _DBHelper = null; try { _DBHelper = CreateHelper(); return(_DBHelper.ExecuteNoQuery(sql, parameters)); } catch (Exception ex) { throw ex; } finally { if (_DBHelper != null) { _DBHelper.Close(); } } }
/// <summary> /// 执行存储过程 /// </summary> /// <param name="procedureName">过程名</param> /// <returns>返回执行正确的行数</returns> public override int ExecuteProcedureNoQuery(string procedureName, DBHelperParmCollection parameters) { int iRtn = -1; try { string realProcedureName = string.Format("{{CALL {0} (", procedureName); for (int i = 0; i < parameters.Count; i++) { realProcedureName += "?,"; } realProcedureName = realProcedureName.Substring(0, realProcedureName.Length - 1); realProcedureName += ")}"; OdbcCommand _OdbcCommand = (OdbcCommand)CreateCommand(realProcedureName, CommandType.StoredProcedure); if (parameters != null) { foreach (DBHelperParm para in parameters) { _OdbcCommand.Parameters.Add(new OdbcParameter("?" + para.Key, para.Value)); } } iRtn = _OdbcCommand.ExecuteNonQuery(); // 设置异常问题 if (iRtn == -1) { _ErrorMsg = "查无记录!"; } } catch (Exception ex) { _ErrorMsg = ex.Message; } return(iRtn); }
/// <summary> /// 返回爱影响的行数 /// </summary> /// <param name="cmdText"></param> /// <param name="parameters"></param> /// <returns></returns> public override int ExecuteNoQuery(string cmdText, DBHelperParmCollection parameters) { int effectNum; OdbcCommand _OdbcCommand = (OdbcCommand)CreateCommand(cmdText, CommandType.Text); _OdbcCommand.Parameters.Clear(); if (parameters != null) { foreach (DBHelperParm para in parameters) { _OdbcCommand.Parameters.Add(new OdbcParameter("?" + para.Key, para.Value)); } } try { effectNum = _OdbcCommand.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } return(effectNum); }
public override int ExecuteNoQuery(string cmdText, DBHelperParmCollection parameters) { int effectNum; AseCommand _AseCommand = (AseCommand)CreateCommand(cmdText, CommandType.Text); _AseCommand.Parameters.Clear(); if (parameters != null) { foreach (DBHelperParm para in parameters) { _AseCommand.Parameters.Add(new AseParameter(para.Key, EncodingHelper.Default2DB(para.Value, _DBEncodeing))); } } try { effectNum = _AseCommand.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } _AseCommand.Parameters.Clear(); return(effectNum); }
public override DataTable ExecuteQuery(string cmdText, DBHelperParmCollection parameters) { DataTable dtRet = new DataTable(); SqlCommand _SqlCommand = (SqlCommand)CreateCommand(cmdText, CommandType.Text); _SqlCommand.Parameters.Clear(); if (parameters != null) { foreach (DBHelperParm para in parameters) { _SqlCommand.Parameters.Add(new SqlParameter("@" + para.Key, para.Value)); } } SqlDataAdapter _SqlDataAdapter = new SqlDataAdapter(_SqlCommand); try { _SqlDataAdapter.Fill(dtRet); } catch (Exception ex) { throw ex; } return dtRet; }
public override int ExecuteNoQuery(string cmdText, DBHelperParmCollection parameters) { int effectNum; SqlCommand _SqlCommand = (SqlCommand)CreateCommand(cmdText, CommandType.Text); _SqlCommand.Parameters.Clear(); if (parameters != null) { foreach (DBHelperParm para in parameters) { _SqlCommand.Parameters.Add(new SqlParameter("@" + para.Key, para.Value)); } } try { effectNum = _SqlCommand.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } return effectNum; }
public virtual DataTable ExecuteQuery(string cmdText, DBHelperParmCollection parameters) { throw new Exception("The method or operation is not implemented."); }
public override DataTable ExecuteProcedureQuery(string procedureName, DBHelperParmCollection parameters) { throw new Exception("The method or operation is not implemented."); }
public override int ExecuteNoQuery(string cmdText, DBHelperParmCollection parameters) { int effectNum; AseCommand _AseCommand = (AseCommand)CreateCommand(cmdText, CommandType.Text); _AseCommand.Parameters.Clear(); if (parameters != null) { foreach (DBHelperParm para in parameters) { _AseCommand.Parameters.Add(new AseParameter(para.Key, EncodingHelper.Default2DB(para.Value, _DBEncodeing))); } } try { effectNum = _AseCommand.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } _AseCommand.Parameters.Clear(); return effectNum; }
public virtual int ExecuteProcedureNoQuery(string procedureName, DBHelperParmCollection parameters) { throw new Exception("The method or operation is not implemented."); }
public override DataTable ExecuteQuery(string cmdText, DBHelperParmCollection parameters) { DataTable dtRet = new DataTable(); AseCommand _AseCommand = (AseCommand)CreateCommand(cmdText, CommandType.Text); _AseCommand.Parameters.Clear(); if (parameters != null) { foreach (DBHelperParm para in parameters) { _AseCommand.Parameters.Add(new AseParameter(para.Key, EncodingHelper.Default2DB(para.Value, _DBEncodeing))); } } AseDataAdapter _OdbcDataAdapter = new AseDataAdapter(_AseCommand); try { ProcessDataTable(dtRet); _OdbcDataAdapter.Fill(dtRet); } catch (Exception ex) { throw ex; } return dtRet; }
/// <summary> /// 执行存储过程,返回结果数据 /// </summary> /// <param name="procedureName">过程名</param> public override DataTable ExecuteProcedureQuery(string procedureName, DBHelperParmCollection parameters) { try { DataTable dtbRtn = new DataTable(); string realProcedureName = string.Format("{{CALL {0} (", procedureName); for (int i = 0; i < parameters.Count; i++) { realProcedureName += "?,"; } realProcedureName = realProcedureName.Substring(0, realProcedureName.Length - 1); realProcedureName += ")}"; OdbcCommand _OdbcCommand = (OdbcCommand)CreateCommand(realProcedureName, CommandType.StoredProcedure); if (parameters != null) { foreach (DBHelperParm para in parameters) { _IDbCommand.Parameters.Add(new OdbcParameter("?" + para.Key, para.Value)); } } OdbcDataAdapter _OdbcDataAdapter = new OdbcDataAdapter(_OdbcCommand); _OdbcDataAdapter.Fill(dtbRtn); return dtbRtn; } catch (Exception ex) { throw ex; } }
public static int ExecuteProcedureNoQuery(string procedureName, DBHelperParmCollection parameters) { throw new Exception("The method or operation is not implemented."); }
/// <summary> /// 非查询操作 /// </summary> /// <param name="sql">sql字符串</param> /// <param name="parameters">参数集合</param> /// <returns></returns> public static int ExecuteNoQuery(string sql, DBHelperParmCollection parameters) { DBHelperBase _DBHelper = null; try { _DBHelper = CreateHelper(); return _DBHelper.ExecuteNoQuery(sql, parameters); } catch (Exception ex) { throw ex; } finally { if (_DBHelper != null) _DBHelper.Close(); } }
public static DataTable ExecuteProcedureQuery(string procedureName, DBHelperParmCollection parameters) { throw new Exception("The method or operation is not implemented."); }
/// <summary> /// 执行存储过程 /// </summary> /// <param name="procedureName">过程名</param> /// <returns>返回执行正确的行数</returns> public override int ExecuteProcedureNoQuery(string procedureName, DBHelperParmCollection parameters) { int iRtn = -1; try { string realProcedureName = string.Format("{{CALL {0} (", procedureName); for (int i = 0; i < parameters.Count; i++) { realProcedureName += "?,"; } realProcedureName = realProcedureName.Substring(0, realProcedureName.Length - 1); realProcedureName += ")}"; OdbcCommand _OdbcCommand = (OdbcCommand)CreateCommand(realProcedureName, CommandType.StoredProcedure); if (parameters != null) { foreach (DBHelperParm para in parameters) { _OdbcCommand.Parameters.Add(new OdbcParameter("?" + para.Key, para.Value)); } } iRtn = _OdbcCommand.ExecuteNonQuery(); // 设置异常问题 if (iRtn == -1) _ErrorMsg = "查无记录!"; } catch (Exception ex) { _ErrorMsg = ex.Message; } return iRtn; }