/// <summary> /// 执行数据库操作返回受影响的行数 /// </summary> /// <param name="cmdType">执行类型</param> /// <param name="cmdText">sql语句</param> /// <param name="dbParameter">参数集合</param> /// <returns>受影响的行数</returns> protected int ExecuteNonQuery(CommandType cmdType, string cmdText, SqlParameterCollection dbParameter) { this.DataContext.SqlCommand.Parameters.Clear(); if (dbParameter != null) { this.DataContext.SqlCommand.Parameters.AddRange(dbParameter.ToArray()); } this.DataContext.SqlCommand.CommandText = cmdText; this.DataContext.SqlCommand.CommandType = cmdType; return(this.DataContext.SqlCommand.ExecuteNonQuery()); }
/// <summary> /// 执行数据库操作返回结果集 /// </summary> /// <param name="cmdType">执行类型</param> /// <param name="cmdText">sql语句</param> /// <param name="dbParameter">参数集合</param> /// <returns>受影响的行数</returns> protected SqlDataReader ExecuteReader(CommandType cmdType, string cmdText, SqlParameterCollection dbParameter) { this.DataContext.SqlCommand.Parameters.Clear(); if (dbParameter != null) { this.DataContext.SqlCommand.Parameters.AddRange(dbParameter.ToArray()); } this.DataContext.SqlCommand.CommandText = cmdText; this.DataContext.SqlCommand.CommandType = cmdType; SqlDataReader dr = this.DataContext.SqlCommand.ExecuteReader(); return(dr); }
/// <summary> /// 执行查询,并返回查询所返回的结果集中第一行的第一列。忽略其他列或行。 /// </summary> /// <param name="cmdType">执行类型</param> /// <param name="cmdText">sql语句</param> /// <param name="dbParameter">参数集合</param> /// <returns>受影响的行数</returns> protected object ExecuteScalar(CommandType cmdType, string cmdText, SqlParameterCollection dbParameter) { this.DataContext.SqlCommand.Parameters.Clear(); if (dbParameter != null) { this.DataContext.SqlCommand.Parameters.AddRange(dbParameter.ToArray()); } this.DataContext.SqlCommand.CommandType = cmdType; this.DataContext.SqlCommand.CommandText = cmdText; object val = this.DataContext.SqlCommand.ExecuteScalar(); return(val); }
/// <summary> /// 执行数据库操作返回DataSet /// </summary> /// <param name="cmdType">执行类型</param> /// <param name="cmdText">sql语句</param> /// <param name="dbParameter">参数集合</param> /// <returns>DataSet</returns> protected DataSet ExecuteDataSet(CommandType cmdType, string cmdText, SqlParameterCollection dbParameter) { this.DataContext.SqlCommand.Parameters.Clear(); if (dbParameter != null) { this.DataContext.SqlCommand.Parameters.AddRange(dbParameter.ToArray()); } DataSet dt = new DataSet(); this.DataContext.SqlCommand.CommandType = cmdType; this.DataContext.SqlCommand.CommandText = cmdText; this.DataContext.SqlDataAdapter.Fill(dt); return(dt); }