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