public List <T> GetData <T>(string sql, IDbDataParameter[] para)
{
//using (SqlConnection conn = new SqlConnection(ConnectionString))
//{
// DynamicParameters p = new DynamicParameters();
// foreach (var item in para)
// {
// p.Add(item.ParameterName, item.Value);
// }
// var query = conn.Query<T>(sql, para, null,
// true,
// null, CommandType.Text).ToList();
// return query;
//}
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
SqlCommand cmd = new SqlCommand(sql, conn);
var pa = (SqlParameter[])para;
cmd.Parameters.AddRange(pa);
cmd.CommandType = CommandType.Text;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
conn.Open();
DataSet ds = new DataSet();
sda.Fill(ds);
conn.Close();
return(DataTableToModelHelper.DataTableToList <T>(ds.Tables[0]));
}
}
public List <T> GetData <T>(string sql)
{
//using (SqlConnection conn = new SqlConnection(ConnectionString))
//{
// var query = conn.Query<T>(sql, null, null,
// true,
// null, CommandType.Text).ToList();
// return query;
//}
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
SqlDataAdapter sda = new SqlDataAdapter(sql, conn);
conn.Open();
DataSet ds = new DataSet();
sda.Fill(ds);
conn.Close();
return(DataTableToModelHelper.DataTableToList <T>(ds.Tables[0]));
}
}
