package controller;
import view.activity.R;
import model.dbHelper;
import android.content.Context;
import android.database.Cursor;
import android.util.Log;
import android.widget.CursorAdapter;
import android.widget.Gallery;
import android.widget.ImageView;
import android.widget.SimpleCursorAdapter;
import android.widget.TextView;
public class MainController {
private dbHelper dh;
private Integer[] _id = new Integer[7];
private String[] todoS = new String[7];
private Integer[] priI = new Integer[7];
private String[] listS = new String[7];
public MainController(Context context) {
dh = new dbHelper(context, dbHelper.DB_NAME, null, 1);
boolean flag = dh.insertToDo("qinjian", null, null, null, null, 0, 0, null);
if (flag == false) {
this.errmsg(1, "insertToDo", "FAIL TO INSERT ");
} else {
this.errmsg(3, "insertToDo", "DONE");
}
}
private Integer GetTodo() {
Cursor c = dh.selectToDo(null, null);
Integer count;
this.errmsg(3, "selectToDo", "DONE");
count = c.getCount();
todoS = new String[count];
Integer i;
if (c.moveToFirst() == false) {
todoS = new String[] { "" };
return 0;
}
for (i = 0; i < count; ++i) {
_id[i] = c.getInt(c.getColumnIndexOrThrow(dbHelper.ID));
todoS[i] = c.getString(c.getColumnIndexOrThrow(dbHelper.content));
priI[i] = c.getInt(c.getColumnIndexOrThrow(dbHelper.priority));
listS[i] = c.getString(c.getColumnIndexOrThrow(dbHelper.listID));
c.moveToNext();
}
return count;
}
private void ClearView(TextView[] id, TextView[] todo, TextView[] pri,
TextView[] list, Integer count, ImageView[] img) {
Integer i;
for (i = count; i < 7; ++i) {
id[i].setVisibility(8);// GONE == 8,check the SDK
todo[i].setVisibility(8);
pri[i].setVisibility(8);
list[i].setVisibility(8);
img[i].setVisibility(8);
}
if (count == 0) {
// TODO
todo[0].setVisibility(0);
//todo[0].setTextColor(991122);
}
}
// @@@debug
private void errmsg(Integer pri, String s, String msg) {
if (pri == 1) {
Log.v("[DEBUG]", "ERROR :: " + s + "@MainController :: " + msg);
}
if (pri == 2) {
Log.v("[DEBUG]", "WARN :: " + s + "@MainController :: " + msg);
}
if (pri == 3) {
Log.v("[DEBUG]", "Info :: " + s + "@MainController :: " + msg);
}
}
public Integer BindTodo(TextView[] id, TextView[] todo, TextView[] pri,
TextView[] list, ImageView[] img) {
// TODO
Integer count = GetTodo();
Integer i;
if (count != 0) {
for (i = 0; i < count; ++i) {
id[i].setText(_id[i].toString());
todo[i].setText(todoS[i].toString());
pri[i].setText(priI[i].toString());
list[i].setText(listS[i].toString());
}
} else {
todo[0].setText(todoS[0]);
}
if (count < 7) {
ClearView(id, todo, pri, list, count, img);
}
return count;
}
public Integer BindList(Context context,Gallery glr){
Cursor c = dh.selectList(null, 7);
Integer count = c.getCount();
CursorAdapter adapterGallery = new SimpleCursorAdapter(context,
R.layout.gallery_item, c, new String[] { dbHelper.ID,
dbHelper.listname },
new int[] { R.id.gallery_id,
R.id.listname });
// Set the adapter to our custom adapter (below)
glr.setAdapter(adapterGallery);
return count;
}
}
|