public List<tbBilldetail> tbBilldetail_GetById(string Id)
{
List<Data.tbBilldetail> list = new List<Data.tbBilldetail>();
using (SqlCommand dbCmd = new SqlCommand("sp_tbBilldetail_GetById", GetConnection()))
{
Data.tbBilldetail obj = new Data.tbBilldetail();
dbCmd.CommandType = CommandType.StoredProcedure;
dbCmd.Parameters.Add(new SqlParameter("@id", Id));
SqlDataReader dr = dbCmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
list.Add(obj.tbBilldetailIDataReader(dr));
}
dr.Close();
//conn.Close();
}
else
{
dr.Close();
}
}
return list;
}
