package task;
|
import java.util.Iterator;
|
import java.util.List;
|
import java.util.Vector;
|
import DataBase.DatabaseManagement;
|
import PbuliClass.ShowMessage;
|
import home.Open_soft_dialog;
|
/**´¦ÀíÈÎÎñµÄ·½·¨*/
|
public class Dell_task {
|
static Vector<tb_task> task_vc=new Vector<tb_task>();
|
@SuppressWarnings("rawtypes")
|
public static void chushihua_tb_task_data() {
|
Open_soft_dialog.addara("¼ÓÔØtb_task");
|
Iterator iterator = DatabaseManagement.table_AandD("tb_task","DESC").iterator();
|
while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ
|
List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËØ¸øµ½info¼¯ºÏ
|
tb_task newtask=new tb_task();
|
String id=(String) info.get(0);
|
String name=(String) info.get(1);
|
String phone=(String) info.get(2);
|
String fences=(String) info.get(3);
|
String bumen=(String) info.get(4);
|
String tagids=(String) info.get(5);
|
String addtime=(String) info.get(6);
|
String startup=(String) info.get(7);
|
String baoliu1=(String) info.get(8);
|
String baoliu2=(String) info.get(9);
|
String baoliu3=(String) info.get(10);
|
String baoliu4=(String) info.get(11);
|
String baoliu5=(String) info.get(12);
|
String baoliu6=(String) info.get(13);
|
String baoliu7=(String) info.get(14);
|
String baoliu8=(String) info.get(15);
|
String baoliu9=(String) info.get(16);
|
String baoliu10=(String) info.get(17);
|
newtask.setId(id);
|
newtask.setName(name);
|
newtask.setPhone(phone);
|
newtask.setFences(fences);
|
newtask.setBumen(bumen);
|
newtask.setTagids(tagids);
|
newtask.setAddtime(addtime);
|
newtask.setStartup(startup);
|
newtask.setBaoliu1(baoliu1);
|
newtask.setBaoliu2(baoliu2);
|
newtask.setBaoliu3(baoliu3);
|
newtask.setBaoliu4(baoliu4);
|
newtask.setBaoliu5(baoliu5);
|
newtask.setBaoliu6(baoliu6);
|
newtask.setBaoliu7(baoliu7);
|
newtask.setBaoliu8(baoliu8);
|
newtask.setBaoliu9(baoliu9);
|
newtask.setBaoliu10(baoliu10);
|
task_vc.add(newtask);
|
}
|
}
|
|
/**Ôö¼ÓÒ»¸öÈÎÎñ*/
|
public static int add(String name, String phone, String fences,String bumen,String tagids,String startup) {
|
int a=0;
|
if(serch(name)==null) {
|
tb_task ts=new tb_task();
|
ts.setName(name);
|
ts.setPhone(phone);
|
ts.setFences(fences);
|
ts.setBumen(bumen);
|
ts.setTagids(tagids);
|
ts.setStartup(startup);
|
ShowMessage.zidingyi("ÐÂÔöÒ»¸öÈÎÎñ³É¹¦£º"+name);
|
a=1;
|
}
|
return a;
|
}
|
|
/**ɾ³ýÒ»¸öÈÎÎñ*/
|
public static int delete(String name) {
|
int a=0;
|
if(serch(name) !=null) {
|
task_vc.removeElement(serch(name));
|
ShowMessage.zidingyi("ɾ³ýÒ»¸öÈÎÎñ³É¹¦£º"+name);
|
a=1;
|
}else {
|
ShowMessage.zidingyi("ɾ³ýµÄÈÎÎñ²»´æÔÚ£º"+name);
|
}
|
|
return a;
|
}
|
/**ÐÞ¸ÄÒ»¸öÈÎÎñ*/
|
public static int alert(String name, String phone, String fences,String bumen,String tagids) {
|
int a=0;
|
tb_task ts=serch(name);
|
if( ts !=null) {
|
ts.setName(name);
|
ts.setPhone(phone);
|
ts.setFences(fences);
|
ts.setBumen(bumen);
|
ts.setTagids(tagids);
|
ShowMessage.zidingyi("ÐÞ¸ÄÒ»¸öÈÎÎñ³É¹¦£º"+name);
|
a=1;
|
}else {
|
ShowMessage.zidingyi("Ð޸ĵÄÈÎÎñ²»´æÔÚ£º"+name);
|
}
|
return a;
|
}
|
|
/**²éÕÒÒ»¸öÈÎÎñ*/
|
public static tb_task serch(String name) {
|
tb_task a=null;
|
int size=task_vc.size();
|
if(size !=0) {
|
for(int i=0;i<size;i++) {
|
tb_task b=task_vc.get(i);
|
String name1=b.getName();
|
if(name.equals(name1)) {
|
a=b;
|
break;
|
}
|
}
|
}
|
return a;
|
}
|
|
|
/**ɾ³ýËùÓÐÈÎÎñ*/
|
public static int deleteall() {
|
int a=0;
|
int size=task_vc.size();
|
if(size !=0) {
|
task_vc.removeAllElements();
|
ShowMessage.zidingyi("ɾ³ýËùÓÐÈÎÎñ³É¹¦");
|
a=1;
|
}
|
return a;
|
}
|
|
/**ÐÞ¸ÄÈÎÎñ״̬*/
|
public static int alertstate(String name,String state) {
|
int a=0;
|
tb_task ts=serch(name);
|
if(ts !=null) {
|
ts.setStartup(state);
|
ShowMessage.zidingyi("ÐÞ¸ÄÈÎÎñ״̬³É¹¦"+name+","+state);
|
a=1;
|
}
|
|
return a;
|
}
|
|
/**¸ù¾Ý²¿ÃÅÃû³ÆÕÒ²¿ÃÅ*/
|
public static tb_task bumen(String bumen) {
|
tb_task a=null;
|
int size=task_vc.size();
|
if(size !=0) {
|
for(int i=0;i<size;i++) {
|
tb_task b=task_vc.get(i);
|
String name1=b.getBumen();
|
if(bumen.equals(name1)) {
|
a=b;
|
break;
|
}
|
}
|
}
|
return a;
|
}
|
|
/**´ÓÈÎÎñÖÐѰÕÒij¸ö±êÇ©ÊÇ·ñ´æÔÚ*/
|
public static boolean isintask(String tagid,tb_task task) {
|
boolean a=false;
|
String tagids=task.getTagids();
|
String[] mes=tagids.split(";");
|
int size=mes.length;
|
for(int i=0;i<size;i++) {
|
String tagid0=mes[i];
|
if(tagid.equals(tagid0)) {
|
a=true;
|
break;
|
}
|
}
|
return a;
|
}
|
|
public static Vector<tb_task> getTask_vc() {
|
return task_vc;
|
}
|
|
public static void setTask_vc(Vector<tb_task> task_vc) {
|
Dell_task.task_vc = task_vc;
|
}
|
|
}
|