public SimpleShowPageList SimpleShowPageButton(string equipmentId) { SimpleShowPageList simpleShowPageItem = new SimpleShowPageList(); StringBuilder stringBuilder = new StringBuilder(); stringBuilder.AppendFormat(ShowPageDaoSqls.SELECT_T_BUSS_SHOW_PAGE_BUTTON, equipmentId); string select = stringBuilder.ToString(); DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(select, "T").Tables[0]; if (dt.Rows.Count > 0) { simpleShowPageItem.name = dt.Rows[0]["NAME"].ToString(); simpleShowPageItem.url = dt.Rows[0]["url"].ToString(); simpleShowPageItem.img = dt.Rows[0]["img"].ToString(); } return(simpleShowPageItem); }
public List <SimpleShowPageList> SimpleShowPageMenu(string equipmentId) { List <SimpleShowPageList> list = new List <SimpleShowPageList>(); StringBuilder stringBuilder = new StringBuilder(); stringBuilder.AppendFormat(ShowPageDaoSqls.SELECT_T_BUSS_SHOW_PAGE_MENU, equipmentId); string select = stringBuilder.ToString(); DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(select, "T").Tables[0]; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { SimpleShowPageList simpleShowPageItem = new SimpleShowPageList(); simpleShowPageItem.name = dt.Rows[i]["NAME"].ToString(); simpleShowPageItem.url = dt.Rows[i]["url"].ToString(); simpleShowPageItem.img = dt.Rows[i]["img"].ToString(); list.Add(simpleShowPageItem); } } return(list); }