package com.jqyd.manager; import java.io.File; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Date; import java.util.HashMap; import java.util.UUID; import org.json.JSONException; import org.json.JSONObject; import android.app.Activity; import android.app.AlertDialog; import android.app.Dialog; import android.app.ProgressDialog; import android.content.DialogInterface; import android.os.Bundle; import android.os.Handler; import android.os.Looper; import android.os.Message; import android.util.Log; import android.view.View; import android.view.View.OnClickListener; import android.widget.AdapterView; import android.widget.Button; import android.widget.ListView; import android.widget.AdapterView.OnItemClickListener; import android.widget.Toast; import com.jqyd.adapter.MyAdapter; import com.jqyd.app.MyApp; import com.jqyd.app.UpMyFile; import com.jqyd.model.GroupsModule; import com.jqyd.model.MyLogModule; import com.jqyd.model.RecordModel; import com.jqyd.newprocess.InfoSure; import com.jqyd.shareInterface.Optdb_interfce; import com.jqyd.shareInterface.Optsharepre_interface; import com.jqyd.shareInterface.UpdataToServer; import com.jqyd.son.Ddxq; import com.jqyd.son.Rzsb; import com.jqyd.son.VisCust; public class Sjcc extends Activity implements OnClickListener { private Button reup; private Button del; private ListView listView; private Optdb_interfce db = null; private ArrayList<HashMap<String,String>> dataList = null; private ArrayList<RecordModel> recordList = null; private MyAdapter adapter; private MyApp myApp; private Optsharepre_interface shareFile = null; private ArrayList<RecordModel> qdqtList = null; private ArrayList<RecordModel> xxfkList = null; private ArrayList<RecordModel> wzsbList = null; private ArrayList<RecordModel> khzfAndhfList = null; private ArrayList<RecordModel> khcjAndbfList = null; private ArrayList<RecordModel> scjcList = null; private ArrayList<String> idList = null; @Override protected void onCreate(Bundle savedInstanceState) { // TODO Auto-generated method stub super.onCreate(savedInstanceState); setContentView(R.layout.plcc); reup = (Button) this.findViewById(R.id.reup); del = (Button) this.findViewById(R.id.del); listView = (ListView) this.findViewById(R.id.recordlist); reup.setOnClickListener(this); del.setOnClickListener(this); myApp = (MyApp) this.getApplication(); loadData(); } /** * 初始化数据 */ public void loadData(){ dataList = new ArrayList<HashMap<String,String>>(); recordList = new ArrayList<RecordModel>(); qdqtList = new ArrayList<RecordModel>(); xxfkList = new ArrayList<RecordModel>(); wzsbList = new ArrayList<RecordModel>(); khzfAndhfList = new ArrayList<RecordModel>(); khcjAndbfList = new ArrayList<RecordModel>(); scjcList = new ArrayList<RecordModel>(); idList = new ArrayList<String>(); db = new Optdb_interfce(Sjcc.this); ArrayList<Object> list = db.getRecordInfo(-1); db.close_SqlDb(); HashMap<String,String> map = null; SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); if(list != null && list.size()>0){ for(int i=0;i<list.size();i++){ map = new HashMap<String, String>(); RecordModel record = (RecordModel) list.get(i); int brand = 0; String title = ""; String optime = ""; try { brand = Integer.parseInt(record.getGid()); title = ""; optime = dateFormat.format(new Date(Long.parseLong(record.getAdd_time()))); } catch (NumberFormatException e) { // TODO Auto-generated catch block e.printStackTrace(); System.out.println("数据格式转化出现异常"); } switch(brand){ case 1: title = "签到"; qdqtList.add(record); break; case 2: title = "签退"; qdqtList.add(record); break; case 3: title = "信息反馈"; xxfkList.add(record); Log.e("xxfkList.size", xxfkList.size()+""); break; case 4: title = "客户走访"; khzfAndhfList.add(record); break; case 5: title = "陌生拜访"; khcjAndbfList.add(record); break; case 6: title = "二次回访"; khzfAndhfList.add(record); break; case 7: title = "市场检查"; scjcList.add(record); break; case 8: title = "客户采集"; khcjAndbfList.add(record); break; case 9: title = "位置上报"; wzsbList.add(record); break; } map.put("textView1", title); map.put("textView2", optime); dataList.add(map); Log.e("datelist.size", dataList.size()+""); recordList.add(record); idList.add(record.getId()); } } showData(); } //设置界面显示 public void showData(){ adapter=new MyAdapter(dataList, this); listView.setAdapter(adapter); listView.setOnItemClickListener(new OnItemClickListener() { @Override public void onItemClick(AdapterView<?> parent, View view, int position, long id) { // TODO Auto-generated method stub } }); } @Override public void onClick(View v) { // TODO Auto-generated method stub if(reup == v){ if(dataList != null && dataList.size()>0){ new DataUploadThread().start(); }else{ warnTell("没有需要上传的数据!"); } }else if(del == v){ if(idList != null && idList.size()>0){ String ids = ""; for(int i=0;i<idList.size();i++){ ids += idList.get(i) + ","; } if(!ids.equals("")){ ids = ids.substring(0,ids.length()-1); } db = new Optdb_interfce(Sjcc.this); db.delRecordByIds(ids); db.close_SqlDb(); //Toast.makeText(Sjcc.this, "删除成功", Toast.LENGTH_LONG).show(); showToast("删除成功"); loadData(); }else{ warnTell("没有需要删除的数据!"); } } } /** * 数据上传线程 * @author Administrator * */ class DataUploadThread extends Thread { @Override public void run() { // TODO Auto-generated method stub super.run(); Looper.prepare(); Message message = new Message(); message.what = 1; myHander.sendMessage(message); Message message2 = new Message(); message2.what = 2; Bundle bundle = new Bundle(); String result = ""; String qdqt = "-1",xxfk = "-1",khzfAndhf = "-1",khcjAndbf = "-1",scjc = "-1",wzsb = "-1"; // 请求服务器 if(qdqtList.size()>0){ qdqt = upLoadkqxx(); } if(xxfkList.size()>0){ xxfk = upLoadfkxx(); } if(khzfAndhfList.size()>0){ khzfAndhf = upLoadzfxx(); } if(khcjAndbfList.size()>0){ khcjAndbf = upLoadcjxx(); } if(scjcList.size()>0){ scjc = upLoadjcxx(); } if(wzsbList.size()>0){ wzsb = upLoadwzxx(); } if(qdqt.equals("0") || xxfk.equals("0") || khzfAndhf.equals("0") || khcjAndbf.equals("0") || scjc.equals("0") || wzsb.equals("0")){ result = "0"; } if (result != null && result.equals("0")) { bundle.putString("msg", "数据上传成功!"); }else{ bundle.putString("msg", "上报失败,请稍后重试!"); } message2.setData(bundle); myHander.sendMessage(message2); Looper.loop(); } } //上传上班签到/签退信息 public String upLoadkqxx(){ String result = ""; JSONObject object = new JSONObject(); Optsharepre_interface shareFile = new Optsharepre_interface(Sjcc.this); db = new Optdb_interfce(Sjcc.this); //获得所属分组和分组id等信息 ArrayList<Object> group_list = db.searchGroups(shareFile.getDataFromPres("GID"), 2); GroupsModule group = (GroupsModule) group_list.get(0); String groupName = group.getGname(); UpdataToServer server = null; for(int i=0;i<qdqtList.size();i++){ RecordModel record = qdqtList.get(i); try { object.put("cosim", shareFile.getDataFromPres("COSIM")); object.put("regsim", shareFile.getDataFromPres("REGSIM")); object.put("gguid", shareFile.getDataFromPres("GGUID")); object.put("zguid", shareFile.getDataFromPres("GUID")); object.put("custid", record.getCustid()); object.put("time", Long.parseLong(record.getAdd_time())); object.put("lon", Double.parseDouble(record.getLon())); object.put("lat", Double.parseDouble(record.getLat())); object.put("cell_id", record.getCid()); object.put("lac_code", record.getLac()); object.put("country_code", record.getCcode()); object.put("ncode", record.getNcode()); object.put("signal_strength", record.getXhqd()); object.put("loc_method", record.getWzbs()); object.put("radius", record.getRaduis()); object.put("yys", record.getJclb()); object.put("type", Integer.parseInt(record.getGid())); object.put("result", Integer.parseInt(record.getResult())); object.put("kqflag", shareFile.getDataFromPres("KQFLAG")); object.put("isnormal", record.getRemark1()); object.put("kqaddr", record.getContent()); object.put("bz", record.getBz()); object.put("gid", shareFile.getDataFromPres("GID")); object.put("group_name", groupName); object.put("khmc", record.getRemark2()); object.put("tag", 0);//0表示后台非实时上传 System.out.println("考勤---------"+object.toString()); // 请求服务器 server = new UpdataToServer(Sjcc.this); result = server.dataToServer("KQSB", object); if(result != null && !result.equals("-1") && !result.equals("500")){ JSONObject obj = new JSONObject(result); String res = obj.getString("result"); if(res.equals("0")){//成功,删除终端数据库表中当条数据 if(db == null || !db.isOpen()){ db = new Optdb_interfce(Sjcc.this); } db.delRecordByIds(record.getId()); result = "0"; } } } catch (NumberFormatException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (JSONException e) { // TODO Auto-generated catch block e.printStackTrace(); } } db.close_SqlDb(); return result; } //上传反馈信息 public String upLoadfkxx(){ String result = ""; JSONObject object = new JSONObject(); Optsharepre_interface shareFile = new Optsharepre_interface(Sjcc.this); UpdataToServer server = new UpdataToServer(Sjcc.this); Bundle bundle = new Bundle(); System.out.println("信息反馈同类型数据优先上传----------"+xxfkList.size()); for(int i=0;i<xxfkList.size()&&i<5;i++){ System.out.println("信息反馈测试标示------------"+i); RecordModel record = xxfkList.get(i); System.out.println("图片信息*******************"+record.getPic_url()+","+record.getPic_detail()); if(record.getPic_url() != null && !record.getPic_url().equals("")){//带有图片信息的数据上传 UpMyFile file = new UpMyFile(Sjcc.this); bundle.putString("gguid", shareFile.getDataFromPres("GGUID")); bundle.putString("zguid", shareFile.getDataFromPres("GUID")); bundle.putString("cosim", shareFile.getDataFromPres("COSIM")); bundle.putString("regsim", shareFile.getDataFromPres("REGSIM")); bundle.putString("xxbt", record.getRemark2()); bundle.putString("xxnr", record.getContent()); bundle.putString("xxcjlb", record.getXxcjlb()); bundle.putString("pic_detail", record.getPic_detail()); //bundle.putString("imagePath", record.getPic_url()); bundle.putString("time", record.getAdd_time()); bundle.putString("guid", shareFile.getDataFromPres("GUID")); bundle.putString("zdmc", shareFile.getDataFromPres("username")); bundle.putString("country_code", record.getCcode()); bundle.putString("cell_id", record.getCid()); bundle.putString("lac_code", record.getLac()); bundle.putString("time", String.valueOf(record.getAdd_time())); bundle.putString("ncode", record.getNcode()); if(record.getXhqd().trim().equals("")){ bundle.putString("signal_strength", "0"); }else{ bundle.putString("signal_strength", record.getXhqd()); } bundle.putString("yys", record.getBz()); bundle.putString("lon",record.getLon()); bundle.putString("lat", record.getLat()); bundle.putString("radius", record.getRaduis()); bundle.putString("loc_method", record.getWzbs()); String relationid = UUID.randomUUID().toString(); bundle.putString("relationid", relationid); String[] paths = record.getRemark5().split(";"); Log.e("imgs", paths.toString()); for(int n=1 ; n<paths.length;n++){ File uploadFile = new File(paths[n]); UpMyFile upfile = new UpMyFile(Sjcc.this); bundle.putString("imagePath", paths[n]); result = upfile.upToServer(bundle,"xxfk"); // 上传成功 if (result != null && result.equals("0")) { result="0"; } else { result="1"; break; } } //result = file.upToServer(bundle, "xxfk"); if(result.equals("0")){//成功,删除终端数据库表中当条数据 if(db == null || !db.isOpen()){ db = new Optdb_interfce(Sjcc.this); } db.delRecordByIds(record.getId()); result = "0"; } }else{//纯文字信息的数据上传 try { object.put("guid", shareFile.getDataFromPres("GUID")); object.put("zdmc", shareFile.getDataFromPres("username")); object.put("cosim", shareFile.getDataFromPres("COSIM")); object.put("regsim", shareFile.getDataFromPres("REGSIM")); object.put("zguid", shareFile.getDataFromPres("GUID")); object.put("gguid", shareFile.getDataFromPres("GGUID")); object.put("xxcjlb", record.getXxcjlb()); object.put("xxbt", record.getRemark2()); object.put("xxnr", record.getContent()); object.put("time", Long.parseLong(record.getAdd_time()) ); object.put("cell_id", record.getCid()); object.put("lac_code", record.getLac()); object.put("country_code", record.getCcode()); object.put("ncode", record.getNcode()); object.put("signal_strength", record.getXhqd()); object.put("yys", record.getBz()); object.put("lon",Double.parseDouble(record.getLon()) ); object.put("lat", Double.parseDouble(record.getLat())); object.put("radius", record.getRaduis()); object.put("loc_method", Integer.parseInt(record.getWzbs()) ); System.out.println("信息反馈---------"+object.toString()); // 请求服务器 result = server.dataToServer("XXFK", object); if(result != null && !result.equals("-1") && !result.equals("500")){ JSONObject obj = new JSONObject(result); String res = obj.getString("result"); if(res.equals("0")){//成功,删除终端数据库表中当条数据 if(db == null || !db.isOpen()){ db = new Optdb_interfce(Sjcc.this); } db.delRecordByIds(record.getId()); result = "0"; } } } catch (NumberFormatException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (JSONException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } return result; } //上传客户采集及陌生拜访信息 public String upLoadcjxx(){ String result = ""; JSONObject object = new JSONObject(); Optsharepre_interface shareFile = new Optsharepre_interface(Sjcc.this); UpdataToServer server = null; Bundle bundle = new Bundle(); for(int i=0;i<khcjAndbfList.size();i++){ RecordModel record = khcjAndbfList.get(i); if(record.getPic_url() != null && !record.getPic_url().equals("")){//带有图片信息的数据上传 UpMyFile file = new UpMyFile(Sjcc.this); bundle.putString("gguid", shareFile.getDataFromPres("GGUID")); bundle.putString("guid", shareFile.getDataFromPres("GUID")); bundle.putString("cosim", shareFile.getDataFromPres("COSIM")); bundle.putString("regsim", shareFile.getDataFromPres("REGSIM")); bundle.putString("pic_detail", record.getPic_detail()); bundle.putString("imagePath", record.getPic_url()); bundle.putString("cid", record.getCustid()); bundle.putString("time", record.getAdd_time()); bundle.putString("lon", record.getLon()); bundle.putString("lat", record.getLat()); bundle.putString("cell_id", record.getCid()); bundle.putString("lac_code", record.getLac()); bundle.putString("country_code", record.getCcode()); bundle.putString("ncode", record.getNcode()); bundle.putString("signal_strength", record.getXhqd()); bundle.putString("radius", record.getRaduis()); bundle.putString("yys", record.getJclb()); bundle.putString("cname", record.getRemark1()); bundle.putString("sjhm", record.getRemark3()); bundle.putString("linkman", record.getRemark2()); bundle.putString("link_sim", record.getRemark4()); bundle.putString("address", record.getContent()); if(record.getGid().equals("8")){ bundle.putString("bz", record.getBz()); bundle.putString("kh_belong", "1"); result = file.upToServer(bundle, "khcj"); }else{ bundle.putString("content", record.getBz()); bundle.putString("kh_belong", "2"); bundle.putString("jhid", record.getXxcjlb()); result = file.upToServer(bundle, "msbf"); } if(result.equals("0")){//成功,删除终端数据库表中当条数据 if(db == null || !db.isOpen()){ db = new Optdb_interfce(Sjcc.this); } db.delRecordByIds(record.getId()); result = "0"; } }else{//纯文字信息的数据上传 try { object.put("gguid", shareFile.getDataFromPres("GGUID")); object.put("guid", shareFile.getDataFromPres("GUID")); object.put("cosim", shareFile.getDataFromPres("COSIM")); object.put("regsim", shareFile.getDataFromPres("REGSIM")); object.put("cname", record.getRemark1()); object.put("sjhm", record.getRemark3()); object.put("linkman", record.getRemark2()); object.put("link_sim", record.getRemark4()); object.put("address", record.getContent()); object.put("cid", record.getCustid()); object.put("time", Long.parseLong(record.getAdd_time())); object.put("lon", Double.parseDouble(record.getLon())); object.put("lat", Double.parseDouble(record.getLat())); object.put("cell_id", record.getCid()); object.put("lac_code", record.getLac()); object.put("country_code", record.getCcode()); object.put("ncode", record.getNcode()); object.put("signal_strength", record.getXhqd()); object.put("yys", record.getJclb()); object.put("radius", record.getRaduis()); object.put("jhid", record.getXxcjlb()); System.out.println("客户采集/陌生拜访---------"+object.toString()); // 请求服务器 server = new UpdataToServer(Sjcc.this); if(record.getGid().equals("8")){ try { object.put("bz", record.getBz()); object.put("kh_belong", "1"); } catch (JSONException e) { // TODO Auto-generated catch block e.printStackTrace(); } result = server.dataToServer("KHCJ", object); }else{ try { object.put("content", record.getBz()); object.put("kh_belong", "2"); } catch (JSONException e) { // TODO Auto-generated catch block e.printStackTrace(); } result = server.dataToServer("MSBF", object); } if(result != null && !result.equals("-1") && !result.equals("500")){ JSONObject obj = new JSONObject(result); String res = obj.getString("result"); if(res.equals("0")){//成功,删除终端数据库表中当条数据 if(db == null || !db.isOpen()){ db = new Optdb_interfce(Sjcc.this); } db.delRecordByIds(record.getId()); result = "0"; } } } catch (NumberFormatException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (JSONException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } return result; } //上传客户走访及二次回访信息 public String upLoadzfxx(){ String result = ""; JSONObject object = new JSONObject(); Optsharepre_interface shareFile = new Optsharepre_interface(Sjcc.this); UpdataToServer server = null; db = new Optdb_interfce(Sjcc.this); //获得登录者姓名 String userName = db.searchEmpName(shareFile.getDataFromPres("GUID")); Bundle bundle = new Bundle(); for(int i=0;i<khzfAndhfList.size();i++){ RecordModel record = khzfAndhfList.get(i); if(record.getPic_url() != null && !record.getPic_url().equals("")){//带有图片信息的数据上传 UpMyFile file = new UpMyFile(Sjcc.this); bundle.putString("gguid", shareFile.getDataFromPres("GGUID")); bundle.putString("guid", shareFile.getDataFromPres("GUID")); bundle.putString("cosim", shareFile.getDataFromPres("COSIM")); bundle.putString("regsim", shareFile.getDataFromPres("REGSIM")); bundle.putString("pic_detail", record.getPic_detail()); bundle.putString("imagePath", record.getPic_url()); bundle.putString("cid", record.getCustid()); bundle.putString("time", record.getAdd_time()); bundle.putString("lon", record.getLon()); bundle.putString("lat", record.getLat()); bundle.putString("cell_id", record.getCid()); bundle.putString("lac_code", record.getLac()); bundle.putString("country_code", record.getCcode()); bundle.putString("ncode", record.getNcode()); bundle.putString("signal_strength", record.getXhqd()); bundle.putString("radius", record.getRaduis()); bundle.putString("yys", record.getJclb()); bundle.putString("loc_method", record.getWzbs()); bundle.putString("cname", record.getRemark2()); bundle.putString("zdmc", userName); bundle.putString("isfirst", record.getResult()); bundle.putString("content", record.getContent()); bundle.putString("jhid", record.getXxcjlb()); if(record.getGid().equals("5")){ bundle.putString("type", "1"); }else{ bundle.putString("type", "2"); } result = file.upToServer(bundle, "khbf"); if(result.equals("0")){//成功,删除终端数据库表中当条数据 if(db == null || !db.isOpen()){ db = new Optdb_interfce(Sjcc.this); } db.delRecordByIds(record.getId()); //判断是初次拜访还是结束拜访 if(record.getResult().equals("1")){//开始拜访 db.updateBfRecord("add",record.getCustid(),record.getContent()); }else if(record.getResult().equals("2")){//结束拜访 db.updateBfRecord("delete",record.getCustid(),""); } result = "0"; } }else{//纯文字信息的数据上传 try { object.put("cosim", shareFile.getDataFromPres("COSIM")); object.put("regsim", shareFile.getDataFromPres("REGSIM")); object.put("gguid", shareFile.getDataFromPres("GGUID")); object.put("guid", shareFile.getDataFromPres("GUID")); object.put("cid", record.getCustid()); object.put("time", Long.parseLong(record.getAdd_time())); object.put("lon", Double.parseDouble(record.getLon())); object.put("lat", record.getLat()); object.put("cell_id", record.getCid()); object.put("lac_code", record.getLac()); object.put("country_code", record.getCcode()); object.put("ncode", record.getNcode()); object.put("signal_strength", record.getXhqd()); object.put("loc_method", record.getWzbs()); object.put("radius", record.getRaduis()); object.put("yys", record.getJclb()); object.put("isfirst", record.getResult()); object.put("content", record.getContent()); object.put("cname", record.getRemark2()); object.put("zdmc", userName); object.put("jhid", record.getXxcjlb()); if(record.getGid().equals("5")){ object.put("type", "1"); }else{ object.put("type", "2"); } System.out.println("客户走访/二次回访---------"+object.toString()); // 请求服务器 server = new UpdataToServer(Sjcc.this); result = server.dataToServer("KHZF", object);; if(result != null && !result.equals("-1") && !result.equals("500")){ JSONObject obj = new JSONObject(result); String res = obj.getString("result"); if(res.equals("0")){//成功,删除终端数据库表中当条数据 if(db == null || !db.isOpen()){ db = new Optdb_interfce(Sjcc.this); } db.delRecordByIds(record.getId()); result = "0"; } } } catch (NumberFormatException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (JSONException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } db.close_SqlDb(); return result; } //上传市场检查信息 public String upLoadjcxx(){ String result = ""; JSONObject object = new JSONObject(); Optsharepre_interface shareFile = new Optsharepre_interface(Sjcc.this); UpdataToServer server = null; db = new Optdb_interfce(Sjcc.this); //获得登录者姓名 String userName = db.searchEmpName(shareFile.getDataFromPres("GUID")); Bundle bundle = new Bundle(); for(int i=0;i<scjcList.size();i++){ RecordModel record = scjcList.get(i); if(record.getPic_url() != null && !record.getPic_url().equals("")){//带有图片信息的数据上传 UpMyFile file = new UpMyFile(Sjcc.this); bundle.putString("gguid", shareFile.getDataFromPres("GGUID")); bundle.putString("guid", shareFile.getDataFromPres("GUID")); bundle.putString("cosim", shareFile.getDataFromPres("COSIM")); bundle.putString("regsim", shareFile.getDataFromPres("REGSIM")); bundle.putString("pic_detail", record.getPic_detail()); bundle.putString("imagePath", record.getPic_url()); bundle.putString("cid", record.getCustid()); bundle.putString("time", record.getAdd_time()); bundle.putString("lon", record.getLon()); bundle.putString("lat", record.getLat()); bundle.putString("cell_id", record.getCid()); bundle.putString("lac_code", record.getLac()); bundle.putString("country_code", record.getCcode()); bundle.putString("ncode", record.getNcode()); bundle.putString("signal_strength", record.getXhqd()); bundle.putString("radius", record.getRaduis()); bundle.putString("yys", record.getRemark3()); bundle.putString("loc_method", record.getWzbs()); bundle.putString("cname", record.getRemark2()); bundle.putString("zdmc", userName); bundle.putString("zfpf", record.getRemark1()); bundle.putString("content", record.getContent()); bundle.putString("jhid", record.getXxcjlb()); bundle.putString("jclb", record.getJclb()); bundle.putString("imagecode", record.getRemark4()); result = file.upToServer(bundle, "scjc"); if(result.equals("0")){//成功,删除终端数据库表中当条数据 if(db == null || !db.isOpen()){ db = new Optdb_interfce(Sjcc.this); } db.delRecordByIds(record.getId()); result = "0"; } }else{//纯文字信息的数据上传 try { object.put("cosim", shareFile.getDataFromPres("COSIM")); object.put("regsim", shareFile.getDataFromPres("REGSIM")); object.put("gguid", shareFile.getDataFromPres("GGUID")); object.put("guid", shareFile.getDataFromPres("GUID")); object.put("cid", record.getCustid()); object.put("time", Long.parseLong(record.getAdd_time())); object.put("lon", Double.parseDouble(record.getLon())); object.put("lat", record.getLat()); object.put("cell_id", record.getCid()); object.put("lac_code", record.getLac()); object.put("country_code", record.getCcode()); object.put("ncode", record.getNcode()); object.put("signal_strength", record.getXhqd()); object.put("loc_method", record.getWzbs()); object.put("radius", record.getRaduis()); object.put("yys", record.getResult()); object.put("cname", record.getRemark2()); object.put("zdmc", userName); object.put("content", record.getContent()); object.put("zhpf", record.getRemark1()); object.put("jclb", record.getJclb()); object.put("jhid", record.getXxcjlb()); System.out.println("市场检查---------"+object.toString()); // 请求服务器 server = new UpdataToServer(Sjcc.this); result = server.dataToServer("SCJC", object);; if(result != null && !result.equals("-1") && !result.equals("500")){ JSONObject obj = new JSONObject(result); String res = obj.getString("result"); if(res.equals("0")){//成功,删除终端数据库表中当条数据 if(db == null || !db.isOpen()){ db = new Optdb_interfce(Sjcc.this); } db.delRecordByIds(record.getId()); result = "0"; } } } catch (NumberFormatException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (JSONException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } db.close_SqlDb(); return result; } //上传位置上报信息 public String upLoadwzxx(){ String result = ""; JSONObject object = new JSONObject(); Optsharepre_interface shareFile = new Optsharepre_interface(Sjcc.this); UpdataToServer server = null; db = new Optdb_interfce(Sjcc.this); //获得登录者姓名 String userName = db.searchEmpName(shareFile.getDataFromPres("GUID")); for(int i=0;i<wzsbList.size();i++){ RecordModel record = wzsbList.get(i); try { object.put("cosim", shareFile.getDataFromPres("COSIM")); object.put("regsim", shareFile.getDataFromPres("REGSIM")); object.put("gguid", shareFile.getDataFromPres("GGUID")); object.put("guid", shareFile.getDataFromPres("GUID")); object.put("time", Long.parseLong(record.getAdd_time())); object.put("lon", Double.parseDouble(record.getLon())); object.put("lat", record.getLat()); object.put("cell_id", record.getCid()); object.put("lac_code", record.getLac()); object.put("country_code", record.getCcode()); object.put("ncode", record.getNcode()); object.put("signal_strength", record.getXhqd()); object.put("loc_method", record.getWzbs()); object.put("radius", record.getRaduis()); object.put("zdmc", userName); object.put("yys", record.getJclb()); System.out.println("位置上报---------"+object.toString()); // 请求服务器 server = new UpdataToServer(Sjcc.this); result = server.dataToServer("WZSB", object);; if(result != null && !result.equals("-1") && !result.equals("500")){ JSONObject obj = new JSONObject(result); String res = obj.getString("result"); if(res.equals("0")){//成功,删除终端数据库表中当条数据 if(db == null || !db.isOpen()){ db = new Optdb_interfce(Sjcc.this); } db.delRecordByIds(record.getId()); result = "0"; } } } catch (NumberFormatException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (JSONException e) { // TODO Auto-generated catch block e.printStackTrace(); } } db.close_SqlDb(); return result; } Handler myHander = new Handler() { @Override public void handleMessage(Message msg) { // TODO Auto-generated method stub super.handleMessage(msg); switch (msg.what) { case 1: showDialog(1); break; case 2: removeDialog(1); Bundle data = msg.getData(); String message = data.getString("msg"); showToast(message); loadData(); break; } } }; /** * 警告提示 */ public void warnTell(final String message){ new AlertDialog.Builder(Sjcc.this).setTitle("警告").setMessage(message) .setPositiveButton("确定", null).show(); } /** * 结果显示 * * @param message */ public void showToast(final String message) { new AlertDialog.Builder(Sjcc.this).setTitle("提示").setMessage(message) .setPositiveButton("确定", new DialogInterface.OnClickListener() { public void onClick(DialogInterface dialog, int which) { } }).show(); } @Override protected Dialog onCreateDialog(int id) { // TODO Auto-generated method stub ProgressDialog dialog = new ProgressDialog(Sjcc.this); dialog.setIndeterminate(true); dialog.setCancelable(false); switch (id) { case 1: dialog.setMessage("正在批量上传,请稍候……"); break; } return dialog; } }