public static List <T> ConvertToProcedure <T>(string sql, string[,] para)
{
dotNETConnection c = new dotNETConnection();
using (SqlCommand command = con.CreateCommand())
{
command.CommandType = CommandType.StoredProcedure;
command.CommandText = sql;
for (int i = 0; i <= para.GetUpperBound(0); i++)
{
command.Parameters.AddWithValue(para[0, i], para[1, i]);
}
using (SqlDataAdapter da = new SqlDataAdapter(command))
{
using (DataTable dt = new DataTable())
{
// da.Fill(dt);
List <T> data = new List <T>();
foreach (DataRow row in dt.Rows)
{
T item = GetItems <T>(row);
data.Add(item);
}
return(data);
}
}
}
}
public static List <T> ConvertSqlToList <T>(string sql)
{
dotNETConnection c = new dotNETConnection();
using (SqlDataAdapter da = new SqlDataAdapter(sql, con))
{
using (DataTable dt = new DataTable())
{
da.Fill(dt);
List <T> data = new List <T>();
foreach (DataRow row in dt.Rows)
{
T item = GetItems <T>(row);
data.Add(item);
}
return(data);
}
}
}
