private static List <HealthItemList> GetAllHealthItemListBySql(string strsql)
{
DataTable dt = DBHelper.GetTable(strsql);
List <HealthItemList> AllHealthItemList = new List <HealthItemList>();
foreach (DataRow row in dt.Rows)
{
HealthItemList hl = new HealthItemList();
hl.ItemListld = Convert.ToInt32(row["ItemListld"]);
hl.ItemListName = row["ItemListName"].ToString();
hl.ItemTypeld = Convert.ToInt32(row["ItemListld"]);
string iss = row["IsGood"].ToString();
if (iss == "True")
{
hl.IsGood = "是";
}
else
{
hl.IsGood = "否";
}
hl.Price = Convert.ToDouble(row["Price"]);
hl.Standard = row["Standard"].ToString();
hl.Info = row["Info"].ToString();
hl.Heath = HealthTypeItemService.GetHealthTypeItemByID(Convert.ToInt32(row["ItemTypeld"]));
AllHealthItemList.Add(hl);
}
return(AllHealthItemList);
}
//根据id查询
public static HealthTypeItem GetHealthTypeItemByID(int ItemTypeld)
{
string strsql = "select * from HealthTypeItem where ItemTypeld=" + ItemTypeld;
return(HealthTypeItemService.GetHealthTypeItemBySql(strsql)[0]);
}