/// <summary> /// 功能: ExcuteTransaction /// 作者:wangguan /// 创建日期:2008-10-10 /// 最后修改日期: /// Review:********* /// </summary> /// <param name="p_parameters">ParameterCollection</param> /// <param name="p_transactionName">TransactionName</param> /// <param name="strError">Error Discription</param> /// <returns>Success or fail</returns> public bool ExcuteByTransaction(CParameters p_parameters, string p_transactionName, out string strError) { bool result = false; strError = string.Empty; #region check strConnection if (null == m_strConnection || 0 == m_strConnection.Length) { strError = "construct's parameter can not be emply"; return(result); } if (null == p_transactionName || 0 == p_transactionName.Length) { strError = "parameter p_transactionName can not be emply"; return(result); } #endregion result = true; #region connect try { con = new SqlConnection(m_strConnection); cmd = new SqlCommand(); cmd.CommandTimeout = 60000; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = p_transactionName; cmd.Connection = con; foreach (SqlParameter para in p_parameters) { cmd.Parameters.Add(para); } con.Open(); cmd.ExecuteNonQuery(); } catch (Exception ex) { strError = ex.Message; result = false; } finally { if (con != null && con.State == System.Data.ConnectionState.Open) { if (cmd != null) { cmd.Dispose(); } con.Close(); } } #endregion return(result); }
/// <summary> /// 功能: Excute Sql /// 作者:wangguan /// 创建日期:2009-02-06 /// 最后修改日期: /// Review:********* /// </summary> /// <param name="sqlString">Sql string</param> /// <param name="strError">Error Discription</param> /// <returns>Success or Fail</returns> public bool ExcuteBySql(string p_sqlString, CParameters p_paramters, out string strError) { bool result = false; strError = string.Empty; #region check strConnection if (null == m_strConnection || 0 == m_strConnection.Length) { strError = "construct's parameter can not be emply"; return(result); } if (null == p_sqlString || 0 == p_sqlString.Length) { strError = "parameter sqlString can not be emply"; return(result); } #endregion #region connect result = true; try { con = new SqlConnection(m_strConnection); con.Open(); cmd = con.CreateCommand(); foreach (SqlParameter para in p_paramters) { cmd.Parameters.Add(para); } cmd.CommandText = p_sqlString; cmd.ExecuteNonQuery(); } catch (Exception ex) { strError = ex.Message; result = false; } finally { if (con != null && con.State == System.Data.ConnectionState.Open) { if (cmd != null) { cmd.Dispose(); } con.Close(); } } #endregion return(result); }
/// <summary> /// 功能: ExcuteTransaction return DataSet & PageParas /// 作者: LD /// 创建日期:2008-11-9 /// 最后修改日期: /// Review:********* /// </summary> /// <param name="p_paramters">ParameterCollection</param> /// <param name="strError">Error Discription</param> /// <returns></returns> public bool ExcuteByTransaction(CParameters p_paramters, string p_transactionName, out decimal minPrice, out decimal maxPrice, out DataSet ds, out string strError) { maxPrice = 0; minPrice = 0; bool result = false; strError = string.Empty; ds = new DataSet(); #region check strConnection if (null == m_strConnection || 0 == m_strConnection.Length) { strError = "construct's parameter can not be emply"; return(result); } if (null == p_transactionName || 0 == p_transactionName.Length) { strError = "parameter p_transactionName can not be emply"; return(result); } #endregion result = true; #region connect try { con = new SqlConnection(m_strConnection); cmd = new SqlCommand(); cmd.CommandTimeout = 60000; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = p_transactionName; cmd.Connection = con; foreach (SqlParameter para in p_paramters) { cmd.Parameters.Add(para); } SqlParameter paraMinPrice = new SqlParameter("@minPrice", SqlDbType.Decimal); paraMinPrice.Direction = ParameterDirection.Output; cmd.Parameters.Add(paraMinPrice); SqlParameter paraMaxPrice = new SqlParameter("@maxPrice", SqlDbType.Decimal); paraMaxPrice.Direction = ParameterDirection.Output; cmd.Parameters.Add(paraMaxPrice); SqlParameter paraReturnvalue = new SqlParameter("@O_RETURN", SqlDbType.Int); paraReturnvalue.Direction = ParameterDirection.Output; cmd.Parameters.Add(paraReturnvalue); adapter = new SqlDataAdapter(); adapter.SelectCommand = cmd; con.Open(); adapter.Fill(ds); minPrice = (decimal)paraMinPrice.Value; maxPrice = (decimal)paraMaxPrice.Value; } catch (Exception ex) { strError = ex.Message; result = false; } finally { if (con != null && con.State == System.Data.ConnectionState.Open) { if (adapter != null) { adapter.Dispose(); } if (cmd != null) { cmd.Dispose(); } con.Close(); } } #endregion return(result); }
/// <summary> /// 功能: ExcuteTransaction return DataSet & PageParas /// 作者: LD /// 创建日期:2008-11-9 /// 最后修改日期: /// Review:********* /// </summary> /// <param name="p_paramters">ParameterCollection</param> /// <param name="strError">Error Discription</param> /// <returns></returns> public bool ExcuteByTransaction(CParameters p_paramters, string p_transactionName, out int iRecordCount, out int iPageCount, out DataSet ds, out string strError) { iRecordCount = 0; iPageCount = 0; bool result = false; strError = string.Empty; ds = new DataSet(); #region check strConnection if (null == m_strConnection || 0 == m_strConnection.Length) { strError = "construct's parameter can not be emply"; return(result); } if (null == p_transactionName || 0 == p_transactionName.Length) { strError = "parameter p_transactionName can not be emply"; return(result); } #endregion result = true; #region connect try { con = new SqlConnection(m_strConnection); cmd = new SqlCommand(); cmd.CommandTimeout = 60000; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = p_transactionName; cmd.Connection = con; foreach (SqlParameter para in p_paramters) { cmd.Parameters.Add(para); } SqlParameter RecordCount = new SqlParameter("@RecordCount", SqlDbType.Int);//总记录数 RecordCount.Direction = ParameterDirection.Output; cmd.Parameters.Add(RecordCount); SqlParameter PageCount = new SqlParameter("@PageCount", SqlDbType.Int);//总页数 PageCount.Direction = ParameterDirection.Output; cmd.Parameters.Add(PageCount); adapter = new SqlDataAdapter(); adapter.SelectCommand = cmd; con.Open(); adapter.Fill(ds); iRecordCount = (int)RecordCount.Value; iPageCount = (int)PageCount.Value; } catch (Exception ex) { strError = ex.Message; result = false; } finally { if (con != null && con.State == System.Data.ConnectionState.Open) { if (adapter != null) { adapter.Dispose(); } if (cmd != null) { cmd.Dispose(); } con.Close(); } } #endregion return(result); }
/// <summary> /// 功能: Get DataSet /// 作者:wangguan /// 创建日期:2008-10-10 /// 最后修改日期: /// </summary> /// <param name="p_sqlString">Sql String</param> /// <param name="ds">DataSet</param> /// <param name="error">Error Discription</param> /// <returns>Success or Fail</returns> public bool ExcuteByDataAdapter(string p_sqlString, CParameters p_paramters, out DataSet ds, out string strError) { bool result = false; strError = string.Empty; ds = new DataSet(); #region check strConnection if (null == m_strConnection || 0 == m_strConnection.Length) { strError = "construct's parameter can not be emply"; return(result); } if (null == p_sqlString || 0 == p_sqlString.Length) { strError = "parameter sqlString can not be emply"; return(result); } #endregion #region connect result = true; try { con = new SqlConnection(m_strConnection); cmd = con.CreateCommand(); foreach (SqlParameter para in p_paramters) { cmd.Parameters.Add(para); } cmd.CommandText = p_sqlString; cmd.CommandTimeout = 60000; adapter = new SqlDataAdapter(); adapter.SelectCommand = cmd; con.Open(); adapter.Fill(ds); if (null == ds) { return(false); } } catch (Exception ex) { strError = ex.Message; result = false; } finally { if (con != null && con.State == System.Data.ConnectionState.Open) { if (adapter != null) { adapter.Dispose(); } con.Close(); } } #endregion return(result); }