NHibernate+Spring.Net

 

1、在NHibernate+Spring.net中执行存储过程，返回IList

/// <summary>
/// 执行存储过程
/// </summary>
/// <param name="procName">存储过程名</param>
/// <param name="dict">参数键值对</param>
/// <returns></returns>
public virtual IList executeProcQuery(string procName, Dictionary<string, object> dict)
{
IList result = new ArrayList();
IDbCommand cmd = SessionFactory.OpenSession().Connection.CreateCommand();
cmd.CommandText = procName;
cmd.CommandType = CommandType.StoredProcedure;
if (dict != null && dict.Count > 0)
{
foreach (KeyValuePair<string, object> kvp in dict)
{
IDbDataParameter parameter = cmd.CreateParameter();
parameter.ParameterName = kvp.Key;
parameter.Value = kvp.Value;
cmd.Parameters.Add(parameter);
}
}
try
{
IDataReader rs = cmd.ExecuteReader();

while (rs.Read())
{
int fieldCount = rs.FieldCount;
object[] values = new Object[fieldCount];
for (int i = 0; i < fieldCount; i++)
values[i] = rs.GetValue(i);
result.Add(values);
}
}
catch (Exception ex)
{
throw ex;
}

return result;
}

2、在NHibernate+Spring.net中执行sql语句，返回DataSet

/// <summary>
/// 填充DataSet
/// </summary>
/// <param name="sql">原生sql语句</param>
/// <returns></returns>
public DataSet ExecuteDataset(string sql)
{
DataSet ds = new DataSet();
try
{
IDbCommand command = Session.Connection.CreateCommand();
command.CommandText = sql;

IDataReader reader = command.ExecuteReader();
DataTable result = new DataTable();
result.Load(reader);
ds.Tables.Add(result);
}
catch (Exception ex)
{

}
finally
{

}
return ds;
}