/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="strWhere"></param>
/// <returns></returns>
public List <TableEnity> GetList()
{
List <TableEnity> list = new List <TableEnity>();
string sql = "select table_id,status from dbo.[table] t inner join dbo.Table_status ts on t.table_status =ts.Status_ID ";
SqlDataReader sdr = SQLHelper.ExecuteReader(sql);
while (sdr.Read())
{
TableEnity m = new TableEnity(sdr["table_id"].ToString(), sdr[1].ToString());
list.Add(m);
}
return(list);
}
/// <summary>
/// 加载table
/// </summary>
/// <param name="person"></param>
/// <returns></returns>
public IList <TableEnity> GetAllTable(int person)
{
List <TableEnity> table = new List <TableEnity>();
SqlParameter[] parameters =
{
new SqlParameter("@person", person)
};
SqlDataReader dr = SQLHelper.RunProcedure("GetAllTable", parameters);
while (dr.Read())
{
TableEnity obj = new TableEnity(dr[0].ToString(), Convert.ToInt32(dr[1]));
table.Add(obj);
}
return(table);
}
