/// <summary>
/// 下拉列表显示信息类型
/// </summary>
public void showType()
{
TbTypeService service = new TbTypeService();
ArrayList list = service.GetTbTypeList();
TbType tb = new TbType();
tb.Id = 0;
tb.TypeIntro = "全部";
list.Insert(0, tb);
DropDownList1.DataSource = list;
DropDownList1.DataTextField = "TypeIntro";
// infoType.DataTextField = "Id";
DropDownList1.DataValueField = "Id";
DropDownList1.DataBind();
}
/// <summary>
/// 返回信息类型
/// </summary>
/// <returns></returns>
public ArrayList GetTbTypeList()
{
ArrayList list = new ArrayList();
string sql = "select * from tb_type";
DataTable dt = DBHelper.GetDataTable(sql);
try
{
foreach (DataRow dr in dt.Rows)
{
TbType tb = new TbType();
tb.Id = Convert.ToInt32(dr["id"]);
tb.TypeIntro = dr["type_intro"].ToString();
list.Add(tb);
}
}
catch (Exception e) {
Console.WriteLine(e.Message);
}
return list;
}
