package com.bawei.lian2;
import java.util.ArrayList; import java.util.List;
import com.bawei.vo.Info; import com.lidroid.xutils.BitmapUtils;
import android.content.Context; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.view.View; import android.view.ViewGroup; import android.widget.BaseExpandableListAdapter; import android.widget.ImageView; import android.widget.TextView;
public class Shipei extends BaseExpandableListAdapter{ Context context; List<String> list; private SQLiteDatabase db; public Shipei(Context context, List<String> list) { // TODO Auto-generated constructor stub this.context=context; this.list=list; MySqliteHelper helper=new MySqliteHelper(context,"ss",null,1); db = helper.getWritableDatabase(); }
@Override public Object getChild(int groupPosition, int childPosition) { // TODO Auto-generated method stub return null; }
@Override public long getChildId(int groupPosition, int childPosition) { // TODO Auto-generated method stub return 0; }
@Override public View getChildView(int groupPosition, int childPosition, boolean isLastChild, View convertView, ViewGroup parent) { // TODO Auto-generated method stub String name = list.get(groupPosition); Cursor c = db.rawQuery("select * from good where ctitle=?", new String[]{name}); List<Info> li=new ArrayList<Info>(); while(c.moveToNext()){ String cid=c.getString(c.getColumnIndex("cid")); String ctime=c.getString(c.getColumnIndex("ctime")); String ctitle=c.getString(c.getColumnIndex("ctitle")); String descript=c.getString(c.getColumnIndex("descript")); String id=c.getString(c.getColumnIndex("id")); String picurl=c.getString(c.getColumnIndex("picurl")); String title=c.getString(c.getColumnIndex("title")); String type=c.getString(c.getColumnIndex("type")); li.add(new Info(cid, ctime, ctitle, descript, id, picurl, title, type)); } View view=View.inflate(context, R.layout.bu, null); ImageView img=(ImageView) view.findViewById(R.id.img); TextView tv_title=(TextView) view.findViewById(R.id.tv_title); TextView tv_desc=(TextView) view.findViewById(R.id.tv_desc); TextView tv_time=(TextView) view.findViewById(R.id.tv_time); Info in = li.get(childPosition); tv_title.setText(in.getTitle()); tv_desc.setText(in.getDescript()); tv_time.setText(in.getCtitle()); BitmapUtils bit=new BitmapUtils(context); bit.display(img,in.getPicurl());
return view; }
@Override public int getChildrenCount(int groupPosition) { // TODO Auto-generated method stub String name = list.get(groupPosition); Cursor c = db.rawQuery("select * from good where ctitle=?", new String[]{name}); return c.getCount(); }
@Override public Object getGroup(int groupPosition) { // TODO Auto-generated method stub return null; }
@Override public int getGroupCount() { // TODO Auto-generated method stub Cursor c = db.rawQuery("select * from user ", new String[]{}); return c.getCount(); }
@Override public long getGroupId(int groupPosition) { // TODO Auto-generated method stub return 0; }
@Override public View getGroupView(int groupPosition, boolean isExpanded, View convertView, ViewGroup parent) { // TODO Auto-generated method stub Cursor c = db.rawQuery("select * from user ", new String[]{}); List<String> l=new ArrayList<String>(); while(c.moveToNext()){ String st = c.getString(c.getColumnIndex("ctitle")); l.add(st); } View view=View.inflate(context, android.R.layout.simple_expandable_list_item_1, null); TextView textView=(TextView) view.findViewById(android.R.id.text1); textView.setText(l.get(groupPosition)); return view; }
@Override public boolean hasStableIds() { // TODO Auto-generated method stub return false; }
@Override public boolean isChildSelectable(int groupPosition, int childPosition) { // TODO Auto-generated method stub return true; }
}
|