#region EF SQL 语句返回 dataTable
/// <summary>
/// EF SQL 语句返回 dataTable
/// </summary>
/// <param name="db"></param>
/// <param name="sql"></param>
/// <param name="parameters"></param>
/// <returns></returns>
public DataTable SqlQueryForDataTatable(string sql, SqlParameter[] parameters)
{
DataTable table = new DataTable();
//创建连接字符串
using (SqlConnection conn = new SqlConnection(commdb.Database.Connection.ConnectionString))
{
try
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
//创建执行命令
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.CommandType = CommandType.StoredProcedure;
//遍历参数
if (parameters.Length > 0)
{
foreach (var item in parameters)
{
cmd.Parameters.Add(item);
}
}
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(table);
}
catch (Exception)
{
table = new DataTable();
}
finally
{
conn.Close();
}
}
return table;
}
#endregion