首页 > 其他 > 详细

使用BaseDao新建服务

时间：2015-10-22 20:49:42      阅读：226      评论：0      收藏：0      [点我收藏+] 
  1. if (myMapListprocessor == null) {
  2. 			myMapListprocessor = new MapListProcessor();
  3. 		} 
  4. String sql="";
  5. 		 try {
  6. 		 new BaseDAO().executeQuery(sql, myMapListprocessor);
  7. 		 } catch (DAOException e) {
  8. 		// TODO 自动生成的 catch 块
  9. 		 e.printStackTrace();
  10. 		 }
  11. 		 out.write(edit.toString());
示例
  1. package nc.saleorder.services;
  3. import java.util.ArrayList;
  4. import java.util.Date;
  5. import java.util.HashMap;
  6. import java.util.List;
  7. import java.util.Map;
  8. import org.json.JSONArray;
  9. import org.json.JSONObject;
  10. import nc.bs.ca.capub.mobile.common.MobileCommon;
  11. import nc.bs.dao.BaseDAO;
  12. import nc.bs.framework.common.NCLocator;
  13. import nc.itf.bd.material.baseinfo.IMaterialBaseInfoQueryService;
  14. import nc.itf.uap.IUAPQueryBS;
  15. import nc.jdbc.framework.processor.ArrayProcessor;
  16. import nc.jdbc.framework.processor.BeanListProcessor;
  17. import nc.jdbc.framework.processor.ColumnListProcessor;
  18. import nc.jdbc.framework.processor.MapListProcessor;
  19. import nc.saleorder.itf.ISaleOrderMobileService;
  20. import nc.saleorder.itf.PageController;
  21. import nc.uap.lfw.core.log.LfwLogger;
  22. import nc.ui.bill.depend.PageInfo;
  23. import nc.vo.bd.material.MaterialVO;
  24. import nc.vo.pub.lang.UFDate;
  25. import nc.vo.pub.lang.UFDateTime;
  26. import nc.vo.pub.lang.UFDouble;
  27. import nc.vo.pubapp.AppContext;
  28. import nc.vo.webts.webts_saleorder.Saleorder;
  29. import nc.vo.webts.webts_saleorder.SaleorderB;
  30. import nc.yanghe.saleorder.constant.ISaleOrderConst;
  32. public class SaleOrderMobileService implements ISaleOrderMobileService {
  34. 	private BaseDAO dao;
  36. 	private BaseDAO getDAO() {
  37. 		if (dao == null)
  38. 			this.dao = new BaseDAO();
  39. 		return dao;
  40. 	}
  42. 	// @SuppressWarnings("unused")
  43. 	// private String transNulltoString(Object tempStr)
  44. 	// {
  45. 	// return tempStr== null ? ""
  46. 	// : tempStr.toString();
  47. 	// }
  48. 	private MapListProcessor myMapListprocessor;
  50. 	private MapListProcessor getMapListProcessor() {
  51. 		if (myMapListprocessor == null)
  52. 			myMapListprocessor = new MapListProcessor();
  53. 		return myMapListprocessor;
  54. 	}
  56. 	// 获取渠道节点
  57. 	/**
  58. 	 * @description 获取渠道网点
  59. 	 * @author wangchunhui
  60. 	 */
  61. 	public ArrayList<Map<String, Object>> GetChnls(String groupid,
  62. 			String usrid, String search_text, String visit_type, String ts,
  63. 			String pageNum, String pagerows) {
  64. 		try {
  66. 			if (LfwLogger.isErrorEnabled()) {
  67. 				LfwLogger.error(MobileCommon.getRequestDebugInfo(
  68. 						"SaleOrderMobileService.GetChnls", new String[] {
  69. 								"groupid", "usrid", "search_text",
  70. 								"visit_type", "ts", "pageNum", "pagerows" },
  71. 						new Object[] { groupid, usrid, search_text, visit_type,
  72. 								ts, pageNum, pagerows }));
  73. 			}
  74. 			// StringBuffer strbuf = new StringBuffer("select * from (select ");
  75. 			StringBuffer strbuf = new StringBuffer(
  76. 					"select * from (select A.*,rownum rn from (select ");
  77. 			strbuf.append("  t.pk_channelnode as pk_channelnode");
  78. 			strbuf.append(" ,t.vname as vname");
  79. 			strbuf.append(" ,t1.detailinfo as addrname");
  80. 			strbuf.append(" ,t2.name as chnlname");
  81. 			strbuf.append(" ,t.vlinkman as vlinkman");
  82. 			strbuf.append(" ,t.vmobilephone as vmobilephone");
  84. 			StringBuffer subbuf = new StringBuffer(
  85. 					" from  dcm_chnlnode  t " 
  86. 							+ " left join bd_address t1 on t1.pk_address=t.clinkaddrid"
  87. 							+ " left join bd_channeltype t2 on t2.pk_type=t.cchanltypeid"
  88. 							+ " where t.dr=0 ");
  89. 			// app端
  90. 			if (visit_type != null && visit_type.equals("app")) {
  91. 				if (groupid != null && !groupid.equals("")) {
  92. 					subbuf.append(" and t.pk_group=‘" + groupid + "‘");
  93. 				}
  94. 				if (search_text != null && !search_text.equals("")) {
  95. 					subbuf.append(" and (t.vlinkman like ‘%" + search_text
  96. 							+ "%‘ or t.vname like ‘%" + search_text
  97. 							+ "%‘ or t.vmobilephone like ‘%" + search_text
  98. 							+ "%‘ or t1.detailinfo like ‘%" + search_text
  99. 							+ "%‘)");
  100. 				}
  101. 				if (usrid != null && !usrid.equals("")) {
  102. 					subbuf.append(" and t.pk_channelnode in(select u.chnlnode "
  103. 							+ "from cv_visitline_nodeb u " + " where u.dr = 0 "
  104. 							+ " and u.pk_visitline in "
  105. 							+ " (select pk_visitline " + " from cv_visitline "
  106. 							+ " where dr=0 " + " and enablestate=2 "
  107. 							+ " and pk_visitline in "
  108. 							+ " (select s.pk_visitline "
  109. 							+ "from cv_visitline_userb s " + " where s.dr = 0 "
  110. 							+ " and  s.bvalidstatus=‘Y‘ " + " and  s.userid =‘"
  111. 							+ usrid + "‘ )))");
  113. 				}
  114. 			}
  115. 			// 店长微信
  116. 			// else{
  117. 			//
  118. 			// }
  119. 			PageController pageController = new PageController(
  120. 					Integer.parseInt(pagerows), Integer.parseInt(pageNum),
  121. 					subbuf.toString());
  122. 			PageInfo pageinfo = new PageInfo();
  123. 			pageinfo = pageController.getPageinfo();
  124. 			int beginIndex = pageinfo.getM_iStartRow();
  125. 			int endIndex = pageinfo.getM_iEndRow();
  126. 			strbuf.append(subbuf).toString();
  127. 			// strbuf.append(" and rownum <=" + endIndex +
  128. 			// "  order by t.vname ) where rn>="
  129. 			strbuf.append(" order by t.vname ) A where rownum <=" + endIndex
  130. 					+ " )  where rn>=" + beginIndex + "");
  131. 			UFDateTime currenttime = new UFDateTime(System.currentTimeMillis());
  132. 			@SuppressWarnings("unchecked")
  133. 			ArrayList<HashMap<String, Object>> lists = (ArrayList<HashMap<String, Object>>) getDAO()
  134. 					.executeQuery(strbuf.toString(), getMapListProcessor());
  135. 			if (LfwLogger.isErrorEnabled()) {
  136. 				LfwLogger.error("***************" + strbuf.toString()
  137. 						+ "***************");
  138. 			}
  139. 			// CacheManager.setObject("123", lists);
  140. 			// ArrayList<HashMap<String, Object>>
  141. 			// lists2=(ArrayList<HashMap<String,
  142. 			// Object>>)CacheManager.getObject("123");
  143. 			Map<String, Object> map = new HashMap<String, Object>();
  144. 			ArrayList<Map<String, Object>> arrFinal = new ArrayList<Map<String, Object>>();
  145. 			if (lists == null || lists.size() <= 0) {
  146. 				map.put("flag", 0);
  147. 				map.put("des", "没有符合条件的数据");
  148. 				arrFinal.add(map);
  149. 				return arrFinal;
  150. 			} else {
  151. 				map.put("flag", "0");
  152. 				map.put("des", null);
  153. 				map.put("ts", currenttime.toString());
  154. 				map.put("resultList", lists);
  155. 				ArrayList<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
  156. 				list.add(map);
  157. 				return list;
  158. 			}
  159. 		} catch (Exception e) {
  160. 			// TODO: handle exception
  161. 			LfwLogger.error(e.getMessage(), e);
  162. 			ArrayList<Map<String, Object>> resList = new ArrayList<Map<String, Object>>();
  163. 			Map<String, Object> resMap = new HashMap<String, Object>();
  164. 			resMap.put("flag", "1");
  165. 			resMap.put("des", e.getMessage());
  166. 			resList.add(resMap);
  167. 			return resList;
  168. 		}
  169. 	}
  171. 	// 获取物料分类
  172. 	/**
  173. 	 * @description 获取物料分类
  174. 	 * @author wangchunhui
  175. 	 */
  176. 	public ArrayList<Map<String, Object>> GetMaterielCategorys(String groupid,
  177. 			String usrid, String visit_type, String parentid, String ts,
  178. 			String pageNum, String pagerows) {
  179. 		// ArrayList<Map<String, Object>> arr = new ArrayList<Map<String,
  180. 		// Object>>();
  181. 		// return arr;
  182. 		try {
  183. 			if (LfwLogger.isErrorEnabled()) {
  184. 				LfwLogger.error(MobileCommon.getRequestDebugInfo(
  185. 						"SaleOrderMobileService.GetMaterielCategorys",
  186. 						new String[] { "groupid", "usrid", "visit_type",
  187. 								"parentid", "ts", "pageNum", "pagerows" },
  188. 						new Object[] { groupid, usrid, visit_type, parentid,
  189. 								ts, pageNum, pagerows }));
  190. 			}
  191. 			StringBuffer strbuf = new StringBuffer(
  192. 					"select * from (select A.*,rownum rn from (select ");
  193. 			strbuf.append("  t.pk_marbasclass as pk_marbasclass");
  194. 			strbuf.append(" ,t.code as materialclasscode");
  195. 			strbuf.append(" ,t.name as materialclassname");
  196. 			// strbuf.append(" ,to_char((select count(*) from   t1 where t1.pk_parent =t.pk_marbasclass))  ishavechild");
  197. 			StringBuffer subbuf = new StringBuffer(
  198. 					" from  bd_marbasclass  t where t.dr=0");
  199. 			// app端
  200. 			if (!visit_type.isEmpty() && visit_type.equals("app")) {
  201. 				if (!groupid.isEmpty()) {
  202. 					subbuf.append(" and t.pk_group=‘" + groupid + "‘");
  203. 				}
  204. 				// if (!parentid.isEmpty() ) {
  205. 				// subbuf.append(" and t.pk_marbasclass=‘" + parentid + "‘");
  206. 				// }
  207. 				if (!usrid.isEmpty()) {
  208. 					subbuf.append(" and t.pk_marbasclass in  (select t1.pk_marbasclass from bd_material t1 where exists (select t2.pk_material from bd_marorg t2 where t2.pk_org="
  209. 							+ " (select pk_org from cp_user where cuserid=‘"
  210. 							+ usrid
  211. 							+ "‘)  and t2.pk_material=t1.pk_material and t2.enablestate=2))");
  212. 				}
  214. 			}
  215. 			// 微信端
  216. 			// else{
  217. 			//
  218. 			// }
  219. 			PageController pageController = new PageController(
  220. 					Integer.parseInt(pagerows), Integer.parseInt(pageNum),
  221. 					subbuf.toString());
  222. 			PageInfo pageinfo = new PageInfo();
  223. 			pageinfo = pageController.getPageinfo();
  224. 			int beginIndex = pageinfo.getM_iStartRow();
  225. 			int endIndex = pageinfo.getM_iEndRow();
  226. 			strbuf.append(subbuf).toString();
  227. 			// strbuf.append(" and rownum <=" + endIndex +
  228. 			// " order by rownum) where rn>="
  229. 			strbuf.append(" order by t.name ) A where rownum <=" + endIndex
  230. 					+ " )  where rn>=" + beginIndex + "");
  231. 			UFDateTime currenttime = new UFDateTime(System.currentTimeMillis());
  232. 			@SuppressWarnings("unchecked")
  233. 			ArrayList<HashMap<String, Object>> lists = (ArrayList<HashMap<String, Object>>) getDAO()
  234. 					.executeQuery(strbuf.toString(), getMapListProcessor());
  235. 			if (LfwLogger.isErrorEnabled()) {
  236. 				LfwLogger.error("***************" + strbuf.toString()
  237. 						+ "***************");
  238. 			}
  239. 			Map<String, Object> map = new HashMap<String, Object>();
  240. 			ArrayList<Map<String, Object>> arrFinal = new ArrayList<Map<String, Object>>();
  241. 			if (lists == null || lists.size() <= 0) {
  242. 				map.put("flag", 0);
  243. 				map.put("des", "没有符合条件的数据");
  244. 				arrFinal.add(map);
  245. 				return arrFinal;
  246. 			} else {
  247. 				map.put("flag", "0");
  248. 				map.put("des", "查询成功");
  249. 				map.put("ts", currenttime.toString());
  250. 				map.put("resultList", lists);
  251. 				ArrayList<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
  252. 				list.add(map);
  253. 				return list;
  254. 			}
  255. 		} catch (Exception e) {
  256. 			// TODO: handle exception
  257. 			LfwLogger.error(e.getMessage(), e);
  258. 			ArrayList<Map<String, Object>> resList = new ArrayList<Map<String, Object>>();
  259. 			Map<String, Object> resMap = new HashMap<String, Object>();
  260. 			resMap.put("flag", "1");
  261. 			resMap.put("des", e.getMessage());
  262. 			resList.add(resMap);
  263. 			return resList;
  265. 		}
  266. 	}
  268. 	// 获取物料
  269. 	/**
  270. 	 * @description 获取物料
  271. 	 * @author wangchunhui
  272. 	 */
  273. 	public ArrayList<Map<String, Object>> GetMateriels(String groupid,
  274. 			String usrid, String search_text, String pk_marbasclass,
  275. 			String visit_type, String ts, String pageNum, String pagerows) {
  276. 		try {
  277. 			if (LfwLogger.isErrorEnabled()) {
  278. 				LfwLogger.error(MobileCommon.getRequestDebugInfo(
  279. 						"SaleOrderMobileService.GetMateriels", new String[] {
  280. 								"groupid", "usrid", "search_text",
  281. 								"pk_marbasclass", "visit_type", "ts",
  282. 								"pageNum", "pagerows" }, new Object[] {
  283. 								groupid, usrid, search_text, pk_marbasclass,
  284. 								visit_type, ts, pageNum, pagerows }));
  285. 			}
  286. 			StringBuffer strbuf = new StringBuffer(
  287. 					"select * from (select A.*,rownum rn from (select ");
  288. 			strbuf.append("  t.pk_material as pk_material");
  289. 			strbuf.append(" ,t.name as name");
  290. 			// strbuf.append(" ,s.name as unit");
  291. 			strbuf.append(" ,t.materialspec as materialspec");
  293. 			StringBuffer subbuf = new StringBuffer(
  294. 					" from (select * from BD_MATERIAL order by name) t "
  295. 					// + "  left join bd_measdoc s on s.pk_measdoc=t.pk_measdoc"
  296. 							+ " where t.dr=0 ");
  297. 			// app端
  298. 			if (!visit_type.isEmpty() && visit_type.equals("app")) {
  299. 				if (!groupid.isEmpty()) {
  300. 					subbuf.append(" and t.pk_group=‘" + groupid + "‘");
  301. 				}
  302. 				if (!search_text.isEmpty()) {
  303. 					subbuf.append(" and (t.code like ‘%" + search_text
  304. 							+ "%‘ or t.name like ‘%" + search_text + "%‘)");
  305. 				}
  306. 				if (!usrid.isEmpty()) {
  308. 					subbuf.append(" and t.pk_material in"
  309. 							+ "(select distinct u.pk_material from BD_MARORG u where u.enablestate=2 and u.pk_org="
  310. 							+ "(select pk_org from cp_user where cuserid=‘"
  311. 							+ usrid + "‘))");
  313. 				}
  314. 			}
  315. 			if (!pk_marbasclass.isEmpty()) {
  316. 				// String sql =
  317. 				// "select * from bd_marbasclass where dr=0 and pk_marbasclass=‘"
  318. 				// + pk_marbasclass + "‘";
  319. 				// BaseDAO dao = new BaseDAO();
  320. 				// @SuppressWarnings("unchecked")
  321. 				// List<MarBasClassVO> lists = (List<MarBasClassVO>) dao
  322. 				// .executeQuery(sql, new BeanListProcessor(
  323. 				// MarBasClassVO.class));
  324. 				// if (lists.size() > 0) {
  325. 				// if (lists.get(0).getCode().length() == 13) {
  326. 				// subbuf.append(" and t.pk_marbasclass=‘"
  327. 				// + pk_marbasclass + "‘");
  328. 				// } else if (lists.get(0).getCode().length() == 10) {
  329. 				// subbuf.append(" and (t.pk_marbasclass=‘"
  330. 				// + pk_marbasclass
  331. 				// + "‘ or t.pk_marbasclass in"
  332. 				// +
  333. 				// "(select  pk_marbasclass from bd_marbasclass where pk_parent=‘"
  334. 				// + pk_marbasclass + "‘))");
  335. 				// } else if (lists.get(0).getCode().length() == 7) {
  336. 				// subbuf.append(" and (t.pk_marbasclass in"
  337. 				// +
  338. 				// "(select  pk_marbasclass from bd_marbasclass where pk_parent=‘"
  339. 				// + pk_marbasclass
  340. 				// + "‘)  or "
  341. 				// +
  342. 				// "  t.pk_marbasclass in(select pk_marbasclass from bd_marbasclass where pk_parent in"
  343. 				// +
  344. 				// "(select  pk_marbasclass from bd_marbasclass where pk_parent=‘"
  345. 				// + pk_marbasclass + "‘)))");
  346. 				// }
  348. 				// }
  349. 				subbuf.append(" and t.pk_marbasclass=‘" + pk_marbasclass + "‘");
  351. 			}
  352. 			// 微信端
  353. 			// else{
  354. 			//
  355. 			// }
  356. 			PageController pageController = new PageController(
  357. 					Integer.parseInt(pagerows), Integer.parseInt(pageNum),
  358. 					subbuf.toString());
  359. 			PageInfo pageinfo = new PageInfo();
  360. 			pageinfo = pageController.getPageinfo();
  361. 			int beginIndex = pageinfo.getM_iStartRow();
  362. 			int endIndex = pageinfo.getM_iEndRow();
  363. 			strbuf.append(subbuf).toString();
  364. 			strbuf.append(" order by t.name ) A where rownum <=" + endIndex
  365. 					+ " )  where rn>=" + beginIndex + "");
  366. 			UFDateTime currenttime = new UFDateTime(System.currentTimeMillis());
  367. 			@SuppressWarnings("unchecked")
  368. 			ArrayList<HashMap<String, Object>> lists = (ArrayList<HashMap<String, Object>>) getDAO()
  369. 					.executeQuery(strbuf.toString(), getMapListProcessor());
  370. 			for (int i = 0; i < lists.size(); i++) {
  371. 				lists.get(i).put("unit", "箱");
  372. 			}
  373. 			if (LfwLogger.isErrorEnabled()) {
  374. 				LfwLogger.error("***************" + strbuf.toString()
  375. 						+ "***************");
  376. 			}
  377. 			Map<String, Object> map = new HashMap<String, Object>();
  378. 			ArrayList<Map<String, Object>> arrFinal = new ArrayList<Map<String, Object>>();
  379. 			if (lists == null || lists.size() <= 0) {
  380. 				map.put("flag", 0);
  381. 				map.put("des", "没有符合条件的数据");
  382. 				arrFinal.add(map);
  383. 				return arrFinal;
  384. 			} else {
  385. 				map.put("flag", "0");
  386. 				map.put("des", "查询成功");
  387. 				map.put("ts", currenttime.toString());
  388. 				map.put("resultList", lists);
  389. 				ArrayList<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
  390. 				list.add(map);
  391. 				return list;
  392. 			}
  393. 		} catch (Exception e) {
  394. 			// TODO: handle exception
  395. 			LfwLogger.error(e.getMessage(), e);
  396. 			ArrayList<Map<String, Object>> resList = new ArrayList<Map<String, Object>>();
  397. 			Map<String, Object> resMap = new HashMap<String, Object>();
  398. 			resMap.put("flag", "1");
  399. 			resMap.put("des", e.getMessage());
  400. 			resList.add(resMap);
  401. 			return resList;
  402. 		}
  403. 	}
  405. 	/**
  406. 	 * @description 获取订单列表
  407. 	 * @author wangchunhui
  408. 	 */
  409. 	@Override
  410. 	public ArrayList<Map<String, Object>> GetOrderlist(String groupid,
  411. 			String usrid, String search_text, String orderstate,
  412. 			String visit_type, String ts, String pageNum, String pagerows) {
  413. 		// TODO 自动生成的方法存根
  414. 		try {
  415. 			if (LfwLogger.isErrorEnabled()) {
  416. 				LfwLogger.error(MobileCommon.getRequestDebugInfo(
  417. 						"SaleOrderMobileService.GetOrderlist", new String[] {
  418. 								"groupid", "usrid", "search_text",
  419. 								"orderstate", "visit_type", "ts", "pageNum",
  420. 								"pagerows" }, new Object[] { groupid, usrid,
  421. 								search_text, orderstate, visit_type, ts,
  422. 								pageNum, pagerows }));
  423. 			}
  424. 			StringBuffer strbuf = new StringBuffer(
  425. 					"select * from (select A.*,rownum rn from (select ");
  426. 			strbuf.append("  t.pk_saleorder as id");
  427. 			strbuf.append(" ,t.vbillno as vbillno");
  428. 			strbuf.append(" ,s.channelname as channelname");
  429. 			strbuf.append(" ,s.channelnodeid as channelnodeid");
  430. 			strbuf.append(" ,s.contact_phone as contact_phone");
  431. 			strbuf.append(" ,s.contact_name as contact_name");
  432. 			strbuf.append(" ,s.addrname as addrname");
  433. 			strbuf.append(" ,s.chnltype as chnltype");
  434. 			// strbuf.append(" ,nvl(to_char(t.ibillstatus),‘3‘) as orderstate");
  435. 			strbuf.append(" ,to_char(t.ibillstatus) as orderstate");
  436. 			// strbuf.append(" ,to_char((to_date(t.creationtime,‘yyyy-mm-dd,hh24:mi:ss‘)-to_date(‘1970-01-01‘,‘yyyy-mm-dd‘))*24*60*60*1000) as orderTime");
  437. 			strbuf.append(" ,t.creationtime as orderTime");
  439. 			StringBuffer subbuf = new StringBuffer(
  440. 					" from    webts_Saleorder   t "
  441. 							// +
  442. 							// " left join dcm_chnlnode s on s.pk_channelnode=t.pk_channel "
  443. 							+ " left join (select   t1.vname as vname,t1.pk_channelnode as channelnodeid,t1.vname as channelname,t1.vmobilephone as contact_phone,t1.vlinkman as contact_name,t2.detailinfo as addrname,t3.name as chnltype  "
  444. 							+ " from dcm_chnlnode t1 left join bd_address t2 on t2.pk_address=t1.clinkaddrid  "
  445. 							+ " left join bd_channeltype t3 on t3.pk_type=t1.cchanltypeid where t1.dr=0) s on t.pk_channel=s.channelnodeid"
  446. 							+ " where t.dr=0 ");
  448. 			if (!visit_type.isEmpty() && visit_type.equals("app")) {
  449. 				if (!groupid.isEmpty()) {
  450. 					subbuf.append(" and t.pk_group=‘" + groupid + "‘ ");
  451. 				}
  452. 				if (!usrid.isEmpty()) {
  453. 					subbuf.append(" and t.creator=‘" + usrid + "‘ ");
  454. 				}
  455. 				if (!search_text.isEmpty()) {
  456. 					subbuf.append(" and (t.vbillno like ‘%" + search_text
  457. 							+ "%‘ or s.vname like ‘%" + search_text + "%‘)");
  458. 				}
  459. 				if (!orderstate.isEmpty()) {
  460. 					subbuf.append(" and t.ibillstatus="
  461. 							+ Integer.parseInt(orderstate) + "");
  462. 				}
  464. 			}
  465. 			subbuf.append("   and t.vsource=‘" + ISaleOrderConst.SOURCE_APP
  466. 					+ "‘");
  468. 			// 微信端
  469. 			// else
  470. 			// {
  471. 			//
  472. 			// }
  473. 			PageController pageController = new PageController(
  474. 					Integer.parseInt(pagerows), Integer.parseInt(pageNum),
  475. 					subbuf.toString());
  476. 			PageInfo pageinfo = new PageInfo();
  477. 			pageinfo = pageController.getPageinfo();
  478. 			int beginIndex = pageinfo.getM_iStartRow();
  479. 			int endIndex = pageinfo.getM_iEndRow();
  480. 			strbuf.append(subbuf).toString();
  481. 			strbuf.append(" order by t.creationtime desc) A where rownum <="
  482. 					+ endIndex + " )  where rn>=" + beginIndex + "");
  483. 			UFDateTime currenttime = new UFDateTime(System.currentTimeMillis());
  484. 			@SuppressWarnings("unchecked")
  485. 			ArrayList<HashMap<String, Object>> lists = (ArrayList<HashMap<String, Object>>) getDAO()
  486. 					.executeQuery(strbuf.toString(), getMapListProcessor());
  487. 			for (int i = 0; i < lists.size(); i++) {
  488. 				JSONObject jsonObject = new JSONObject();
  489. 				jsonObject.put("channelnodeid",
  490. 						lists.get(i).get("channelnodeid") == null ? "" : lists
  491. 								.get(i).get("channelnodeid").toString());
  492. 				jsonObject.put("channelname",
  493. 						lists.get(i).get("channelname") == null ? "" : lists
  494. 								.get(i).get("channelname").toString());
  495. 				jsonObject.put("contact_name",
  496. 						lists.get(i).get("contact_name") == null ? "" : lists
  497. 								.get(i).get("contact_name").toString());
  498. 				jsonObject.put("contact_phone",
  499. 						lists.get(i).get("contact_phone") == null ? "" : lists
  500. 								.get(i).get("contact_phone").toString());
  501. 				jsonObject.put("addrname",
  502. 						lists.get(i).get("addrname") == null ? "" : lists
  503. 								.get(i).get("addrname").toString());
  504. 				jsonObject.put("chnltype",
  505. 						lists.get(i).get("chnltype") == null ? "" : lists
  506. 								.get(i).get("chnltype").toString());
  507. 				lists.get(i).remove("channelnodeid");
  508. 				lists.get(i).remove("contact_name");
  509. 				lists.get(i).remove("contact_phone");
  510. 				lists.get(i).remove("addrname");
  511. 				lists.get(i).remove("chnltype");
  512. 				lists.get(i).put("website", jsonObject.toString());
  513. 			}
  515. 			if (LfwLogger.isErrorEnabled()) {
  516. 				LfwLogger.error("***************" + strbuf.toString()
  517. 						+ "***************");
  518. 			}
  519. 			Map<String, Object> map = new HashMap<String, Object>();
  520. 			ArrayList<Map<String, Object>> arrFinal = new ArrayList<Map<String, Object>>();
  521. 			if (lists == null || lists.size() <= 0) {
  522. 				map.put("flag", 0);
  523. 				map.put("des", "没有符合条件的数据");
  524. 				arrFinal.add(map);
  525. 				return arrFinal;
  526. 			} else {
  527. 				map.put("flag", "0");
  528. 				map.put("des", "查询成功");
  529. 				map.put("ts", currenttime.toString());
  530. 				map.put("resultList", lists);
  531. 				ArrayList<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
  532. 				list.add(map);
  533. 				return list;
  534. 			}
  535. 		} catch (Exception e) {
  536. 			// TODO: handle exception
  537. 			LfwLogger.error(e.getMessage(), e);
  538. 			ArrayList<Map<String, Object>> resList = new ArrayList<Map<String, Object>>();
  539. 			Map<String, Object> resMap = new HashMap<String, Object>();
  540. 			resMap.put("flag", "1");
  541. 			resMap.put("des", e.getMessage());
  542. 			resList.add(resMap);
  543. 			return resList;
  544. 		}
  546. 	}
  548. 	/**
  549. 	 * @description 订单保存
  550. 	 * @author wangchunhui
  551. 	 */
  552. 	@Override
  553. 	public ArrayList<Map<String, Object>> SaveOrders(String groupid,
  554. 			String usrid, String visit_type, String channelnodeid,
  555. 			String contact_name, String contact_phone, String sendDate,
  556. 			String productlist, String ts) {
  557. 		// LfwLogger.error("***********"+groupid+""+usrid+""+visit_type+""+channelnodeid+""+contact_name+""+contact_phone+productlist);
  558. 		// TODO 自动生成的方法存根
  559. 		try {
  560. 			if (LfwLogger.isErrorEnabled()) {
  561. 				LfwLogger.error(MobileCommon.getRequestDebugInfo(
  562. 						"SaleOrderMobileService.SaveOrders", new String[] {
  563. 								"groupid", "usrid", "visit_type",
  564. 								"channelnodeid", "contact_name",
  565. 								"contact_phone", "productlist", "ts" },
  566. 						new Object[] { groupid, usrid, visit_type,
  567. 								channelnodeid, contact_name, contact_phone,
  568. 								productlist, ts }));
  569. 			}
  570. 			IUAPQueryBS qry = NCLocator.getInstance().lookup(IUAPQueryBS.class);
  571. 			// app端
  572. 			if (visit_type != null && visit_type.equals("app")) {
  573. 				// 保存
  574. 				Saleorder saleorder = new Saleorder();
  575. 				saleorder.setPk_psndoc(usrid);
  576. 				saleorder.setCreator(usrid);
  577. 				saleorder.setCreationtime(new UFDateTime(System
  578. 						.currentTimeMillis()));
  579. 				// TODO 用户关联的公司
  580. 				@SuppressWarnings("unchecked")
  581. 				ArrayList<String> clist = (ArrayList<String>) qry.executeQuery(
  582. 						"select t.pk_org from cp_user t where t.cuserid=‘"
  583. 								+ usrid + "‘", new ColumnListProcessor());
  584. 				if (clist.size() > 0) {
  585. 					saleorder.setPk_org(clist.get(0));
  586. 				}
  587. 				saleorder.setVbillno("SO" + new Date().getTime());
  588. 				saleorder.setPk_group(groupid); // 所属集团
  589. 				saleorder.setPk_channel(channelnodeid);// 渠道网点
  590. 				saleorder.setVname(contact_name);// 联系人
  591. 				saleorder.setVphoneno(contact_phone);// 联系电话
  592. 				saleorder.setVdef1(new UFDate(sendDate).toString());
  593. 				/**
  594. 				 * TODO 1.根据网点带出对应的省市县,nc.yangh.webts.SaleOrder.SaleOrder.
  595. 				 * SaleOrderCardWinMainViewCtrl
  596. 				 * .onAfterDataChange(DatasetCellEvent)
  597. 				 * 
  598. 				 */
  599. 				IUAPQueryBS chnesrv = NCLocator.getInstance().lookup(
  600. 						IUAPQueryBS.class);
  601. 				Object[] chnldata = (Object[]) chnesrv
  602. 						.executeQuery(
  603. 								"select addr.province,addr.city,addr.vsection,addr.detailinfo,addr.postcode from dcm_chnlnode node  join bd_address addr on node.clinkaddrid=addr.pk_address where pk_channelnode=‘"
  604. 										+ channelnodeid + "‘",
  605. 								new ArrayProcessor());
  606. 				if (chnldata != null && chnldata.length > 0) {
  607. 					saleorder.setPk_province(chnldata[0] == null ? ""
  608. 							: chnldata[0].toString());
  609. 					saleorder.setPk_city(chnldata[1] == null ? "" : chnldata[1]
  610. 							.toString());
  611. 					saleorder.setPk_region(chnldata[2] == null ? ""
  612. 							: chnldata[2].toString());
  613. 					saleorder.setVaddress(chnldata[3] == null ? ""
  614. 							: chnldata[3].toString());
  615. 					saleorder.setVzipcode(chnldata[4] == null ? ""
  616. 							: chnldata[4].toString());
  617. 				}
  618. 				saleorder.setVsource(ISaleOrderConst.SOURCE_APP);// 订单来源
  619. 				saleorder.setIbillstatus(ISaleOrderConst.COMMIT);// 提交态
  620. 				saleorder.setDbilldate(AppContext.getInstance().getBusiDate());// 业务日期
  621. 				String parentpk = getDAO().insertVO(saleorder);
  622. 				// 解析json字符串
  623. 				JSONArray jsonarray = new JSONArray(productlist);
  624. 				List<SaleorderB> list = new ArrayList<SaleorderB>();
  626. 				for (int i = 0; i < jsonarray.length(); i++) {
  627. 					org.json.JSONObject jo = jsonarray.getJSONObject(i);
  628. 					String pk_material = jo.get("productid").toString();
  629. 					UFDouble nnum = new UFDouble(jo.get("num").toString());
  630. 					String materialname = jo.get("materialname").toString();
  631. 					String materialspec = jo.get("materialspec").toString();
  632. 					SaleorderB saleb = new SaleorderB();
  633. 					saleb.setPk_saleorder(parentpk);
  634. 					saleb.setPk_material(pk_material);
  635. 					saleb.setInvname(materialname);
  636. 					saleb.setInvspec(materialspec);
  637. 					saleb.setNnum(nnum);
  638. 					saleb.setCrowno("" + (i + 1) * 10);
  639. 					saleb.setPk_unit("0001Z0100000000000XU");// 计量单位：箱
  640. 					saleb.setDsenddate(new UFDate(sendDate));
  641. 					// saleb.setStatus(ISaleOrderConst.APPROVE_B);//已审核
  642. 					/**
  643. 					 * TODO 2.带出表体对应的经销商nc.yangh.webts.SaleOrder.SaleOrder.
  644. 					 * SaleOrderCardWinMainViewCtrl.afterEdit(CellEvent)
  645. 					 */
  646. 					IMaterialBaseInfoQueryService materialQry = NCLocator
  647. 							.getInstance().lookup(
  648. 									IMaterialBaseInfoQueryService.class);
  649. 					if (pk_material != null && pk_material.trim().length() > 0) {
  650. 						MaterialVO materialvo = materialQry
  651. 								.queryDataByPks(new String[] { pk_material })[0];
  652. 						saleb.setSubclass(materialvo.getPk_marbasclass());
  654. 						@SuppressWarnings("unchecked")
  655. 						ArrayList<String> jxs = (ArrayList<String>) qry
  656. 								.executeQuery(
  657. 										"select code from webts_goodsrelation_h where"
  658. 												+ " pk_relation in (select distinct(b.pk_relation) from webts_goodsrelation_order a "
  659. 												+ " full join webts_goodsrelation_person b on a.pk_relation=b.pk_relation where nvl(a.dr,0)=0 and nvl(b.dr,0)=0 "
  660. 												+ " and pk_psndoc=‘" + usrid
  661. 												+ "‘ and a.pk_material=‘"
  662. 												+ pk_material
  663. 												+ "‘ ) and nvl(dr,0)=0",
  664. 										new ColumnListProcessor());
  665. 						if (jxs.size() == 1) {
  666. 							saleb.setPk_dealer(jxs.get(0));
  667. 						}
  668. 					}
  669. 					list.add(saleb);
  670. 				}
  671. 				SaleorderB[] salebs = list.toArray(new SaleorderB[0]);
  672. 				getDAO().insertVOArray(salebs);
  674. 			}
  675. 			// 微信端
  676. 			// else
  677. 			// {
  678. 			//
  679. 			// }
  680. 			UFDateTime currenttime = new UFDateTime(System.currentTimeMillis());
  681. 			ArrayList<Map<String, Object>> resList = new ArrayList<Map<String, Object>>();
  682. 			Map<String, Object> resMap = new HashMap<String, Object>();
  683. 			resMap.put("flag", "0");
  684. 			resMap.put("status", "1");
  685. 			resMap.put("des", "保存成功");
  686. 			resMap.put("ts", currenttime.toString());
  687. 			resList.add(resMap);
  688. 			return resList;
  690. 		} catch (Exception e) {
  691. 			LfwLogger.error(e.getMessage(), e);
  692. 			ArrayList<Map<String, Object>> resList = new ArrayList<Map<String, Object>>();
  693. 			Map<String, Object> resMap = new HashMap<String, Object>();
  694. 			resMap.put("flag", "1");
  695. 			resMap.put("status", "2");
  696. 			resMap.put("des", e.getMessage());
  697. 			resList.add(resMap);
  698. 			return resList;
  699. 		}
  700. 	}
  702. 	// 修改订单
  703. 	@Override
  704. 	public ArrayList<Map<String, Object>> UpdateOrders(String visit_type,
  705. 			String usrid, String orderid, String sendDate, String productlist,
  706. 			String contact_name, String contact_phone, String ts) {
  707. 		// TODO 自动生成的方法存根
  708. 		try {
  709. 			if (LfwLogger.isErrorEnabled()) {
  710. 				LfwLogger.error(MobileCommon.getRequestDebugInfo(
  711. 						"SaleOrderMobileService.UpdateOrders", new String[] {
  712. 								"visit_type", "orderid", "sendDate",
  713. 								"productlist", "ts" },
  714. 						new Object[] { visit_type, orderid, sendDate,
  715. 								productlist, ts }));
  716. 			}
  717. 			IUAPQueryBS qry = NCLocator.getInstance().lookup(IUAPQueryBS.class);
  718. 			// app端
  719. 			if (visit_type != null && visit_type.equals("app")) {
  720. 				String wherestr = " dr=0 and pk_saleorder=‘" + orderid + "‘";
  721. 				getDAO().deleteByClause(SaleorderB.class, wherestr);
  722. 				String sql = " select * from webts_Saleorder where dr=0 and pk_saleorder=‘"
  723. 						+ orderid + "‘";
  724. 				@SuppressWarnings("unchecked")
  725. 				List<Saleorder> lists = (List<Saleorder>) dao.executeQuery(sql,
  726. 						new BeanListProcessor(Saleorder.class));
  728. 				if (lists.size() > 0) {
  729. 					Saleorder sorder = lists.get(0);
  730. 					sorder.setVname(contact_name);
  731. 					sorder.setVphoneno(contact_phone);
  732. 					sorder.setVdef1(new UFDate(sendDate).toString());
  733. 					getDAO().updateVO(sorder);
  734. 				}
  736. 				// 解析json字符串
  737. 				JSONArray jsonarray = new JSONArray(productlist);
  738. 				List<SaleorderB> list = new ArrayList<SaleorderB>();
  740. 				for (int i = 0; i < jsonarray.length(); i++) {
  741. 					org.json.JSONObject jo = jsonarray.getJSONObject(i);
  742. 					String pk_material = jo.get("productid").toString();
  743. 					UFDouble nnum = new UFDouble(jo.get("num").toString());
  744. 					String materialname = jo.get("materialname").toString();
  745. 					String materialspec = jo.get("materialspec").toString();
  746. 					SaleorderB saleb = new SaleorderB();
  747. 					saleb.setPk_saleorder(orderid);
  748. 					saleb.setPk_material(pk_material);
  749. 					saleb.setNnum(nnum);
  750. 					saleb.setCrowno("" + (i + 1) * 10);
  751. 					saleb.setPk_unit("0001Z0100000000000XU");// 计量单位：箱
  752. 					saleb.setInvname(materialname);
  753. 					saleb.setInvspec(materialspec);
  754. 					saleb.setDsenddate(new UFDate(sendDate));
  755. 					// saleb.setStatus(ISaleOrderConst.APPROVE_B);//已审核
  756. 					/**
  757. 					 * TODO 2.带出表体对应的经销商nc.yangh.webts.SaleOrder.SaleOrder.
  758. 					 * SaleOrderCardWinMainViewCtrl.afterEdit(CellEvent)
  759. 					 */
  760. 					IMaterialBaseInfoQueryService materialQry = NCLocator
  761. 							.getInstance().lookup(
  762. 									IMaterialBaseInfoQueryService.class);
  763. 					if (pk_material != null && pk_material.trim().length() > 0) {
  764. 						MaterialVO materialvo = materialQry
  765. 								.queryDataByPks(new String[] { pk_material })[0];
  766. 						saleb.setSubclass(materialvo.getPk_marbasclass());
  768. 						@SuppressWarnings("unchecked")
  769. 						ArrayList<String> jxs = (ArrayList<String>) qry
  770. 								.executeQuery(
  771. 										"select code from webts_goodsrelation_h where"
  772. 												+ " pk_relation in (select distinct(b.pk_relation) from webts_goodsrelation_order a "
  773. 												+ " full join webts_goodsrelation_person b on a.pk_relation=b.pk_relation where nvl(a.dr,0)=0 and nvl(b.dr,0)=0 "
  774. 												+ " and pk_psndoc=‘" + usrid
  775. 												+ "‘ and a.pk_material=‘"
  776. 												+ pk_material
  777. 												+ "‘ ) and nvl(dr,0)=0",
  778. 										new ColumnListProcessor());
  779. 						if (jxs.size() == 1) {
  780. 							saleb.setPk_dealer(jxs.get(0));
  781. 						}
  782. 					}
  783. 					list.add(saleb);
  784. 				}
  785. 				SaleorderB[] salebs = list.toArray(new SaleorderB[0]);
  786. 				getDAO().insertVOArray(salebs);
  788. 			}
  789. 			// 微信端
  790. 			// else
  791. 			// {
  792. 			//
  793. 			// }
  794. 			UFDateTime currenttime = new UFDateTime(System.currentTimeMillis());
  795. 			ArrayList<Map<String, Object>> resList = new ArrayList<Map<String, Object>>();
  796. 			Map<String, Object> resMap = new HashMap<String, Object>();
  797. 			resMap.put("flag", "0");
  798. 			resMap.put("des", "更新成功");
  799. 			resMap.put("ts", currenttime.toString());
  800. 			resList.add(resMap);
  801. 			return resList;
  803. 		} catch (Exception e) {
  804. 			// TODO: handle exception
  805. 			LfwLogger.error(e.getMessage(), e);
  806. 			ArrayList<Map<String, Object>> resList = new ArrayList<Map<String, Object>>();
  807. 			Map<String, Object> resMap = new HashMap<String, Object>();
  808. 			resMap.put("flag", "1");
  809. 			resMap.put("des", e.getMessage());
  810. 			resList.add(resMap);
  811. 			return resList;
  812. 		}
  813. 	}
  815. 	/**
  816. 	 * @description 获取订单子表详情
  817. 	 * @author wangchunhui
  818. 	 */
  819. 	@SuppressWarnings("unused")
  820. 	@Override
  821. 	public ArrayList<Map<String, Object>> GetOrderBlist(String visit_type,
  822. 			String usrid, String orderid, String ts) {
  823. 		// TODO 自动生成的方法存根
  824. 		try {
  825. 			if (LfwLogger.isErrorEnabled()) {
  826. 				LfwLogger.error(MobileCommon.getRequestDebugInfo(
  827. 						"SaleOrderMobileService.GetOrderBlist", new String[] {
  828. 								"visit_type", "usrid", "ts" }, new Object[] {
  829. 								visit_type, usrid, visit_type, ts, }));
  830. 			}
  831. 			// StringBuffer strbuf = new StringBuffer("select * from (select ");
  832. 			StringBuffer strbuf = new StringBuffer(
  833. 					"select * from (select A.*,rownum rn from (select ");
  834. 			strbuf.append(" t.pk_saleorder as orderid");
  835. 			// strbuf.append(" ,to_char((to_date(t.dsenddate,‘yyyy-mm-dd,hh24:mi:ss‘)-to_date(‘1970-01-01‘,‘yyyy-mm-dd‘))*24*60*60*1000) as sendDate");
  836. 			// strbuf.append(" ,to_char(to_date(t.dsenddate,‘yyyy-mm-dd‘)) as sendDate");
  837. 			strbuf.append(" , substr(t.dsenddate,0,10) as senddate");
  838. 			strbuf.append(" ,t.pk_material as productid");
  839. 			strbuf.append(" ,t1.vname as contact_name");
  840. 			strbuf.append(" ,t1.vphoneno as contact_phone");
  841. 			strbuf.append(" ,t.nnum as num");
  842. 			strbuf.append(" ,t.invname as name");
  843. 			strbuf.append(" ,t.invspec as materialspec");
  845. 			StringBuffer subbuf = new StringBuffer(
  846. 					" from  webts_SaleorderB  t "
  847. 							+ " left join webts_Saleorder t1 on t1.pk_saleorder=t.pk_saleorder"
  848. 							// +
  849. 							// " left join (select t2.pk_channelnode,t2.vname,t2.vlinkman,t2.vmobilephone from webts_Saleorder t1 join dcm_chnlnode t2 on t2.pk_channelnode=t.pk_channel where t1.dr=0 and t1.pk_saleorder=‘"+orderid+"‘) s on  "
  850. 							+ " where t.dr=0 and t.pk_saleorder=‘" + orderid
  851. 							+ "‘");
  852. 			// app端
  853. 			if (visit_type != null && visit_type.equals("app")) {
  854. 			}
  855. 			// 微信端
  856. 			// else
  857. 			// {
  858. 			//
  859. 			// }
  860. 			PageController pageController = new PageController(50, 1,
  861. 					subbuf.toString());
  862. 			PageInfo pageinfo = new PageInfo();
  863. 			pageinfo = pageController.getPageinfo();
  864. 			int beginIndex = pageinfo.getM_iStartRow();
  865. 			int endIndex = pageinfo.getM_iEndRow();
  866. 			strbuf.append(subbuf).toString();
  867. 			// strbuf.append(" and rownum <=" + endIndex +
  868. 			// "  order by invname)  where rn>="
  869. 			strbuf.append(" order by t.invname ) A where rownum <=" + endIndex
  870. 					+ " )  where rn>=" + beginIndex + "");
  871. 			UFDateTime currenttime = new UFDateTime(System.currentTimeMillis());
  872. 			@SuppressWarnings("unchecked")
  873. 			ArrayList<HashMap<String, Object>> lists = (ArrayList<HashMap<String, Object>>) getDAO()
  874. 					.executeQuery(strbuf.toString(), getMapListProcessor());
  875. 			JSONArray jsonArray = new JSONArray();
  876. 			String senddate = null;
  877. 			String contact_name = null;
  878. 			String contact_phone = null;
  879. 			if (lists.size() > 0) {
  880. 				senddate = lists.get(0).get("senddate") == null ? "" : lists
  881. 						.get(0).get("senddate").toString();
  882. 				contact_name = lists.get(0).get("contact_name") == null ? ""
  883. 						: lists.get(0).get("contact_name").toString();
  884. 				contact_phone = lists.get(0).get("contact_phone") == null ? ""
  885. 						: lists.get(0).get("contact_phone").toString();
  886. 			}
  887. 			for (int i = 0; i < lists.size(); i++) {
  888. 				JSONObject jsonObject = new JSONObject();
  889. 				jsonObject.put(
  890. 						"productid",
  891. 						lists.get(i).get("productid") == null ? "" : lists
  892. 								.get(i).get("productid").toString());
  893. 				jsonObject.put("num", lists.get(i).get("num") == null ? ""
  894. 						: lists.get(i).get("num").toString());
  895. 				jsonObject.put("name", lists.get(i).get("name") == null ? ""
  896. 						: lists.get(i).get("name").toString());
  897. 				jsonObject.put("materialspec",
  898. 						lists.get(i).get("materialspec") == null ? "" : lists
  899. 								.get(i).get("materialspec").toString());
  900. 				jsonObject.put("unit", "箱");
  901. 				jsonArray.put(jsonObject);
  903. 			}
  904. 			lists.clear();
  905. 			Map<String, Object> tempMap = new HashMap<String, Object>();
  906. 			tempMap.put("orderid", orderid);
  907. 			tempMap.put("senddate", senddate);
  908. 			tempMap.put("contact_name", contact_name);
  909. 			tempMap.put("contact_phone", contact_phone);
  910. 			tempMap.put("productlist", jsonArray.toString());
  911. 			lists.add((HashMap<String, Object>) tempMap);
  912. 			Map<String, Object> map = new HashMap<String, Object>();
  913. 			ArrayList<Map<String, Object>> arrFinal = new ArrayList<Map<String, Object>>();
  914. 			if (lists == null || lists.size() <= 0) {
  915. 				map.put("flag", 0);
  916. 				map.put("des", "没有符合条件的数据");
  917. 				arrFinal.add(map);
  918. 				return arrFinal;
  919. 			} else {
  920. 				map.put("flag", "0");
  921. 				map.put("des", "查询成功");
  922. 				map.put("ts", currenttime.toString());
  923. 				map.put("resultList", lists);
  924. 				ArrayList<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
  925. 				list.add(map);
  926. 				return list;
  927. 			}
  929. 		} catch (Exception e) {
  930. 			// TODO: handle exception
  931. 			LfwLogger.error(e.getMessage(), e);
  932. 			ArrayList<Map<String, Object>> resList = new ArrayList<Map<String, Object>>();
  933. 			Map<String, Object> resMap = new HashMap<String, Object>();
  934. 			resMap.put("flag", "1");
  935. 			resMap.put("des", e.getMessage());
  936. 			resList.add(resMap);
  937. 			return resList;
  938. 		}
  939. 	}
  941. 	/**
  942. 	 * 待收获列表
  943. 	 * 
  944. 	 * @author heyang
  945. 	 * 
  946. 	 */
  947. 	@Override
  948. 	public ArrayList<Map<String, Object>> GetOrderconfirmlist(
  949. 			String visit_type, String usrid, String search_text, String istatus,String ts,
  950. 			String pageNum, String pagerows) {
  951. 		// TODO 自动生成的方法存根
  952. 		try {
  953. 			if (LfwLogger.isErrorEnabled()) {
  954. 				LfwLogger.error(MobileCommon.getRequestDebugInfo(
  955. 						"SaleOrderMobileService.GetOrderconfirmlist",
  956. 						new String[] { "visit_type", "usrid", "search_text","istatus",
  957. 								"ts", "pageNum", "pagerows" }, new Object[] {
  958. 								visit_type, usrid, search_text,istatus, ts, pageNum,
  959. 								pagerows }));
  960. 			}
  961. 			StringBuffer strbuf = new StringBuffer(
  962. 					"select * from (select A.*,rownum rn from (select ");
  963. 			// strbuf.append("  t.pk_accounts as pk_accounts");
  964. 			// strbuf.append(" ,t.nsendnum as sendcount");
  965. 			strbuf.append(" distinct  s.channelnodeid as pk_channelnode");
  966. 			if ("0".equals(istatus)) {
  967. 				strbuf.append("  ,t.dsenddate as senddate");}
  968. 			else{
  969. 				strbuf.append("  ,t.dreceivedate as receivedate");
  970. 			}
  971. 			strbuf.append(" ,s.channelname as vname");
  973. 			strbuf.append(" ,s.contact_phone as vmobilephone");
  974. 			strbuf.append(" ,s.contact_name as vlinkman");
  975. 			strbuf.append(" ,s.addrname as addrname");
  976. 			strbuf.append(" ,s.chnltype as chnlname");
  977. 			// strbuf.append(" ,nvl(to_char(t.ibillstatus),‘3‘) as orderstate");
  978. 			// strbuf.append(" ,to_char(t.ibillstatus) as orderstate");
  979. 			// strbuf.append(" ,to_char((to_date(t.creationtime,‘yyyy-mm-dd,hh24:mi:ss‘)-to_date(‘1970-01-01‘,‘yyyy-mm-dd‘))*24*60*60*1000) as orderTime");
  980. 			// strbuf.append(" ,t.creationtime as orderTime");
  982. 			StringBuffer subbuf = new StringBuffer(
  983. 					" from    webts_goodaccounts   t "
  984. 							// +
  985. 							// " left join dcm_chnlnode s on s.pk_channelnode=t.pk_channel "
  986. 							+ " left join (select   t1.vname as vname,t1.pk_channelnode as channelnodeid,t1.vname as channelname,t1.vmobilephone as contact_phone,t1.vlinkman as contact_name,t2.detailinfo as addrname,t3.name as chnltype  "
  987. 							+ " from dcm_chnlnode t1 left join bd_address t2 on t2.pk_address=t1.clinkaddrid  "
  988. 							+ " left join bd_channeltype t3 on t3.pk_type=t1.cchanltypeid where t1.dr=0) s on t.pk_channel=s.channelnodeid"
  989. 							+ " where t.dr=0 and nvl(t.istatus,0) = "+istatus);
  990. 			
  992. 			if (!visit_type.isEmpty() && visit_type.equals("app")) {
  993. 				// if (!groupid.isEmpty()) {
  994. 				// subbuf.append(" and t.pk_group=‘" + groupid + "‘ ");
  995. 				// }
  996. 				if (!usrid.isEmpty()) {
  997. 					subbuf.append(" and t.pk_psndoc=‘" + usrid + "‘ ");
  998. 				}
  999. 				if (!search_text.isEmpty()) {
  1000. 					subbuf.append(" and (s.channelname like ‘%" + search_text
  1001. 							+ "%‘ or s.addrname like ‘%" + search_text + "%‘)");
  1002. 				}
  1003. 				// if (!orderstate.isEmpty()) {
  1004. 				// subbuf.append(" and t.ibillstatus="
  1005. 				// + Integer.parseInt(orderstate) + "");
  1006. 				// }
  1008. 			}
  1010. 			// 微信端
  1011. 			// else
  1012. 			// {
  1013. 			//
  1014. 			// }
  1015. 			PageController pageController = new PageController(
  1016. 					Integer.parseInt(pagerows), Integer.parseInt(pageNum),
  1017. 					subbuf.toString());
  1018. 			PageInfo pageinfo = new PageInfo();
  1019. 			pageinfo = pageController.getPageinfo();
  1020. 			int beginIndex = pageinfo.getM_iStartRow();
  1021. 			int endIndex = pageinfo.getM_iEndRow();
  1022. 			strbuf.append(subbuf).toString();
  1023. 			strbuf.append(" and  (t.dsenddate is null or t.dsenddate = (select max(t4.dsenddate) from webts_goodaccounts t4 where t4.pk_channel=s.channelnodeid)) ");
  1024. 			strbuf.append(" and (t.dreceivedate is  null or t.dreceivedate = (select max(t4.dreceivedate) from webts_goodaccounts t4 where t4.pk_channel=s.channelnodeid)) ");
  1026. 			if ("0".equals(istatus)) {
  1027. 				strbuf.append(" order by t.dsenddate desc ");
  1028. 			}else {
  1029. 				strbuf.append(" order by t.dreceivedate desc ");
  1030. 			}
  1031. 			strbuf.append(") A where rownum <="
  1032. 					+ endIndex + " )  where rn>=" + beginIndex + "");
  1033. 			UFDateTime currenttime = new UFDateTime(System.currentTimeMillis());
  1034. 			@SuppressWarnings("unchecked")
  1035. 			ArrayList<HashMap<String, Object>> lists = (ArrayList<HashMap<String, Object>>) getDAO()
  1036. 					.executeQuery(strbuf.toString(), getMapListProcessor());
  1038. 			if (LfwLogger.isErrorEnabled()) {
  1039. 				LfwLogger.error("***************" + strbuf.toString()
  1040. 						+ "***************");
  1041. 			}
  1042. 			Map<String, Object> map = new HashMap<String, Object>();
  1043. 			ArrayList<Map<String, Object>> arrFinal = new ArrayList<Map<String, Object>>();
  1044. 			if (lists == null || lists.size() <= 0) {
  1045. 				map.put("flag", 0);
  1046. 				map.put("des", "没有符合条件的数据");
  1047. 				arrFinal.add(map);
  1048. 				return arrFinal;
  1049. 			} else {
  1050. 				map.put("flag", "0");
  1051. 				map.put("des", "查询成功");
  1052. 				map.put("ts", currenttime.toString());
  1053. 				map.put("resultList", lists);
  1054. 				ArrayList<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
  1055. 				list.add(map);
  1056. 				return list;
  1057. 			}
  1058. 		} catch (Exception e) {
  1059. 			// TODO: 操作异常
  1060. 			LfwLogger.error(e.getMessage(), e);
  1061. 			ArrayList<Map<String, Object>> resList = new ArrayList<Map<String, Object>>();
  1062. 			Map<String, Object> resMap = new HashMap<String, Object>();
  1063. 			resMap.put("flag", "1");
  1064. 			resMap.put("des", e.getMessage());
  1065. 			resList.add(resMap);
  1066. 			return resList;
  1067. 		}
  1068. 	}
  1070. 	/**
  1071. 	 * 待收货网点明细
  1072. 	 */
  1073. 	@Override
  1074. 	public ArrayList<Map<String, Object>> GetOrderBconfirmlist(
  1075. 			String channelnodeid, String usrid, String visit_type,String istatus,
  1076. 			String pageNum, String pagerows, String ts) {
  1077. 		// TODO 自动生成的方法存根
  1078. 		try {
  1079. 			if (LfwLogger.isErrorEnabled()) {
  1080. 				LfwLogger.error(MobileCommon.getRequestDebugInfo(
  1081. 						"SaleOrderMobileService.GetOrderBconfirmlist",
  1082. 						new String[] { "channelnodeid", "usrid", "visit_type",
  1083. 								"istatus","pageNum", "pagerows", "ts" }, new Object[] {
  1084. 								channelnodeid, usrid, ts, visit_type,istatus, pageNum,
  1085. 								pagerows, ts }));
  1086. 			}
  1087. 			StringBuffer strbuf = new StringBuffer(
  1088. 					"select * from (select A.*,rownum rn from (select ");
  1089. 			strbuf.append("  t.pk_accounts as id");// 台帐主键
  1090. 			strbuf.append(" ,to_char(t.nnum) as num");// 要货数量
  1091. 			strbuf.append(" ,t.pk_material as productid"); // 产品pk
  1092. 			strbuf.append(" ,m.name as name"); // 产品名称
  1093. 			strbuf.append(" ,t.unit as unit"); // 产品单位
  1094. 			strbuf.append(" ,t.invspec as materialspec"); // 产品规格
  1096. 			strbuf.append(" ,to_char(t.nsendnum) as sendnum");// 发货数量
  1097. 			strbuf.append(" ,to_char(t.nfinishnum) as finishnum");// 累计发货数量
  1098. 			strbuf.append(" ,t.sendman as sendman");// 发货人
  1100. 			strbuf.append(" ,s.addrname as addrname");// 地址
  1101. 			strbuf.append(" ,substr(t.dsenddate,0,16) as dsenddate");// 发货日期
  1102. 			// strbuf.append(" ,to_char(t.ntotalrevnum) as ntotalrevnum");//
  1103. 			// 累计收获数量
  1104. 			// strbuf.append(" ,nvl(to_char(t.ibillstatus),‘3‘) as orderstate");
  1105. 			// strbuf.append(" ,to_char(t.ibillstatus) as orderstate");
  1106. 			// strbuf.append(" ,to_char((to_date(t.creationtime,‘yyyy-mm-dd,hh24:mi:ss‘)-to_date(‘1970-01-01‘,‘yyyy-mm-dd‘))*24*60*60*1000) as orderTime");
  1107. 			// strbuf.append(" ,t.creationtime as orderTime");
  1109. 			StringBuffer subbuf = new StringBuffer(
  1110. 					" from    webts_goodaccounts   t "
  1111. 							+ " left join bd_material m on m.pk_material=t.pk_material "
  1112. 							+ " left join (select   t1.vname as vname,t1.pk_channelnode as channelnodeid,t1.vname as channelname,t1.vmobilephone as contact_phone,t1.vlinkman as contact_name,t2.detailinfo as addrname,t3.name as chnltype  "
  1113. 							+ " from dcm_chnlnode t1 left join bd_address t2 on t2.pk_address=t1.clinkaddrid  "
  1114. 							+ " left join bd_channeltype t3 on t3.pk_type=t1.cchanltypeid where t1.dr=0) s on t.pk_channel=s.channelnodeid"
  1115. 							+ " where t.dr=0 and nvl(t.istatus,0) ="+istatus+" and t.pk_channel=‘"
  1116. 							+ channelnodeid + "‘");
  1118. 			if (!visit_type.isEmpty() && visit_type.equals("app")) {
  1119. 				// if (!groupid.isEmpty()) {
  1120. 				// subbuf.append(" and t.pk_group=‘" + groupid + "‘ ");
  1121. 				// }
  1123. 			}
  1125. 			// 微信端
  1126. 			// else
  1127. 			// {
  1128. 			//
  1129. 			// }
  1130. 			PageController pageController = new PageController(
  1131. 					Integer.parseInt(pagerows), Integer.parseInt(pageNum),
  1132. 					subbuf.toString());
  1133. 			PageInfo pageinfo = new PageInfo();
  1134. 			pageinfo = pageController.getPageinfo();
  1135. 			int beginIndex = pageinfo.getM_iStartRow();
  1136. 			int endIndex = pageinfo.getM_iEndRow();
  1137. 			strbuf.append(subbuf).toString();
  1138. 			strbuf.append(" order by t.dsenddate ) A where rownum <="
  1139. 					+ endIndex + " )  where rn>=" + beginIndex + "");
  1140. 			UFDateTime currenttime = new UFDateTime(System.currentTimeMillis());
  1141. 			@SuppressWarnings("unchecked")
  1142. 			ArrayList<HashMap<String, Object>> lists = (ArrayList<HashMap<String, Object>>) getDAO()
  1143. 					.executeQuery(strbuf.toString(), getMapListProcessor());
  1144. 			for (int i = 0; i < lists.size(); i++) {
  1145. 				String productid = (String) lists.get(i).get("productid");
  1146. 				// 累计收获数量的计算。查询台帐里的相同产品的收货数量+加上本次确认的是就是本次累计收货数量
  1147. 				String querysql = "select sum(nvl(nreveivenum,0)) as beforerecievenum from  webts_goodaccounts where  pk_material=‘"
  1148. 						+ productid + "‘ and nvl(dr,0)=0 and nvl(istatus,0)="+istatus;
  1149. 				IUAPQueryBS queryBS = (IUAPQueryBS) NCLocator.getInstance()
  1150. 						.lookup(IUAPQueryBS.class.getName());
  1151. 				ArrayList<HashMap<String, Object>> list1 = (ArrayList<HashMap<String, Object>>) queryBS
  1152. 						.executeQuery(querysql, new MapListProcessor());
  1153. 				UFDouble beforerecievenum = new UFDouble(String.valueOf(list1
  1154. 						.get(0).get("beforerecievenum") == null ? "0" : list1
  1155. 						.get(0).get("beforerecievenum")));
  1156. 				lists.get(i).put("totalrevnum", beforerecievenum.toString());
  1157. 			}
  1158. 			if (LfwLogger.isErrorEnabled()) {
  1159. 				LfwLogger.error("***************" + strbuf.toString()
  1160. 						+ "***************");
  1161. 			}
  1162. 			Map<String, Object> map = new HashMap<String, Object>();
  1163. 			ArrayList<Map<String, Object>> arrFinal = new ArrayList<Map<String, Object>>();
  1164. 			if (lists == null || lists.size() <= 0) {
  1165. 				map.put("flag", 0);
  1166. 				map.put("des", "没有符合条件的数据");
  1167. 				arrFinal.add(map);
  1168. 				return arrFinal;
  1169. 			} else {
  1170. 				map.put("flag", "0");
  1171. 				map.put("des", "查询成功");
  1172. 				map.put("ts", currenttime.toString());
  1173. 				map.put("resultList", lists);
  1174. 				ArrayList<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
  1175. 				list.add(map);
  1176. 				return list;
  1177. 			}
  1178. 		} catch (Exception e) {
  1179. 			// TODO: 操作异常
  1180. 			LfwLogger.error(e.getMessage(), e);
  1181. 			ArrayList<Map<String, Object>> resList = new ArrayList<Map<String, Object>>();
  1182. 			Map<String, Object> resMap = new HashMap<String, Object>();
  1183. 			resMap.put("flag", "1");
  1184. 			resMap.put("des", e.getMessage());
  1185. 			resList.add(resMap);
  1186. 			return resList;
  1187. 		}
  1188. 	}
  1190. 	/**
  1191. 	 * 
  1192. 	 * 收获确认
  1193. 	 * 
  1194. 	 * @param id
  1195. 	 * @param reveivenum
  1196. 	 * @param ts
  1197. 	 * @return
  1198. 	 */
  1199. 	@Override
  1200. 	public ArrayList<Map<String, Object>> UpdateGoodsaccounts(
  1201. 			String reveiveinfo, String ts) {
  1202. 		// TODO 自动生成的方法存根
  1203. 		try {
  1204. 			if (LfwLogger.isErrorEnabled()) {
  1205. 				LfwLogger.error(MobileCommon.getRequestDebugInfo(
  1206. 						"SaleOrderMobileService.UpdateOrders", new String[] {
  1207. 								"reveiveinfo", "ts" }, new Object[] {
  1208. 								reveiveinfo, ts }));
  1209. 			}
  1210. 			// 解析字符串
  1212. 			// 解析
  1213. 			org.json.JSONArray jsonarray = new JSONArray(reveiveinfo);
  1214. 			// 遍历
  1215. 			for (int i = 0; i < jsonarray.length(); i++) {
  1216. 				org.json.JSONObject jo = jsonarray.getJSONObject(i);
  1217. 				String id = (String) jo.get("id");// 台帐id
  1218. 				String pk_material = (String) jo.get("productid");
  1219. 				String reveivenum = (String) jo.get("reveivenum");// 本次收货数量
  1220. 				String userid  = (String) jo.get("userid");
  1221. 				UFDouble receivenum = new UFDouble(reveivenum);
  1222. 				// 累计收获数量的计算。查询台帐里的相同产品的收货数量+加上本次确认的是就是本次累计收货数量
  1223. 				String querysql = "select sum(nvl(nreveivenum,0)) as beforerecievenum from  webts_goodaccounts where  pk_material=‘"
  1224. 						+ pk_material
  1225. 						+ "‘ and nvl(dr,0)=0 and nvl(istatus,0)=1";
  1226. 				IUAPQueryBS queryBS = (IUAPQueryBS) NCLocator.getInstance()
  1227. 						.lookup(IUAPQueryBS.class.getName());
  1228. 				ArrayList<HashMap<String, Object>> lists = (ArrayList<HashMap<String, Object>>) queryBS
  1229. 						.executeQuery(querysql, new MapListProcessor());
  1230. 				UFDouble beforerecievenum = new UFDouble(String.valueOf(lists
  1231. 						.get(0).get("beforerecievenum") == null ? "0" : lists
  1232. 						.get(0).get("beforerecievenum")));
  1233. 				UFDouble totalreceivenum = beforerecievenum.add(receivenum);// 累计收货数量
  1234. 				String sql = "update webts_goodaccounts set nreveivenum="
  1235. 						+ receivenum + ",istatus=1,ntotalrevnum="
  1236. 						+ totalreceivenum +", dreceiveman=\‘"+userid+"\‘,dreceivedate=\‘"+new UFDateTime().toStdString() + "\‘ where pk_accounts=‘" + id
  1237. 						+ "‘ and nvl(dr,0)=0";
  1238. 				getDAO().executeUpdate(sql);
  1239. 			}
  1241. 			UFDateTime currenttime = new UFDateTime(System.currentTimeMillis());
  1242. 			ArrayList<Map<String, Object>> resList = new ArrayList<Map<String, Object>>();
  1243. 			Map<String, Object> resMap = new HashMap<String, Object>();
  1244. 			resMap.put("flag", "0");
  1245. 			resMap.put("des", "更新成功");
  1246. 			resMap.put("ts", currenttime.toString());
  1247. 			resList.add(resMap);
  1248. 			return resList;
  1250. 		} catch (Exception e) {
  1251. 			// TODO: handle exception
  1252. 			LfwLogger.error(e.getMessage(), e);
  1253. 			ArrayList<Map<String, Object>> resList = new ArrayList<Map<String, Object>>();
  1254. 			Map<String, Object> resMap = new HashMap<String, Object>();
  1255. 			resMap.put("flag", "1");
  1256. 			resMap.put("des", e.getMessage());
  1257. 			resList.add(resMap);
  1258. 			return resList;
  1259. 		}
  1260. 	}
  1261. 	/**
  1262. 	 * 待收获列表
  1263. 	 * 
  1264. 	 * @author heyang
  1265. 	 * 
  1266. 	 */
  1267. 	@Override
  1268. 	public ArrayList<Map<String, Object>> GetOrdercounts(
  1269. 			String visit_type, String usrid, String ts
  1270. 			) {
  1271. 		// TODO 自动生成的方法存根
  1272. 		try {
  1273. 			if (LfwLogger.isErrorEnabled()) {
  1274. 				LfwLogger.error(MobileCommon.getRequestDebugInfo(
  1275. 						"SaleOrderMobileService.GetOrdercounts",
  1276. 						new String[] { "visit_type", "usrid",
  1277. 								"ts"}, new Object[] {
  1278. 								visit_type, usrid,  ts}));
  1279. 			}
  1280. 			StringBuffer strbuf = new StringBuffer(
  1281. 					"select to_char(count(*)) AS num from (select A.*,rownum rn from (select ");
  1282. 			// strbuf.append("  t.pk_accounts as pk_accounts");
  1283. 			// strbuf.append(" ,t.nsendnum as sendcount");
  1284. 			strbuf.append(" distinct  s.channelnodeid as pk_channelnode");
  1285. 			strbuf.append(" ,s.channelname as vname");
  1287. 			strbuf.append(" ,s.contact_phone as vmobilephone");
  1288. 			strbuf.append(" ,s.contact_name as vlinkman");
  1289. 			strbuf.append(" ,s.addrname as addrname");
  1290. 			strbuf.append(" ,s.chnltype as chnlname");
  1291. 			// strbuf.append(" ,nvl(to_char(t.ibillstatus),‘3‘) as orderstate");
  1292. 			// strbuf.append(" ,to_char(t.ibillstatus) as orderstate");
  1293. 			// strbuf.append(" ,to_char((to_date(t.creationtime,‘yyyy-mm-dd,hh24:mi:ss‘)-to_date(‘1970-01-01‘,‘yyyy-mm-dd‘))*24*60*60*1000) as orderTime");
  1294. 			// strbuf.append(" ,t.creationtime as orderTime");
  1296. 			StringBuffer subbuf = new StringBuffer(
  1297. 					" from    webts_goodaccounts   t "
  1298. 							// +
  1299. 							// " left join dcm_chnlnode s on s.pk_channelnode=t.pk_channel "
  1300. 							+ " left join (select   t1.vname as vname,t1.pk_channelnode as channelnodeid,t1.vname as channelname,t1.vmobilephone as contact_phone,t1.vlinkman as contact_name,t2.detailinfo as addrname,t3.name as chnltype  "
  1301. 							+ " from dcm_chnlnode t1 left join bd_address t2 on t2.pk_address=t1.clinkaddrid  "
  1302. 							+ " left join bd_channeltype t3 on t3.pk_type=t1.cchanltypeid where t1.dr=0) s on t.pk_channel=s.channelnodeid"
  1303. 							+ " where t.dr=0 and nvl(t.istatus,0) !=1");
  1305. 			if (!visit_type.isEmpty() && visit_type.equals("app")) {
  1306. 				// if (!groupid.isEmpty()) {
  1307. 				// subbuf.append(" and t.pk_group=‘" + groupid + "‘ ");
  1308. 				// }
  1309. 				if (!usrid.isEmpty()) {
  1310. 					subbuf.append(" and t.pk_psndoc=‘" + usrid + "‘ ");
  1311. 				}
  1312. 				
  1313. 				
  1314. 			}
  1316. 			// 微信端
  1317. 			// else
  1318. 			// {
  1319. 			//
  1320. 			// }
  1321. 		
  1322. 		
  1323. 			
  1324. 			strbuf.append(subbuf).toString();
  1325. 			strbuf.append(" order by s.channelname ) A )");
  1326. 			UFDateTime currenttime = new UFDateTime(System.currentTimeMillis());
  1327. 			@SuppressWarnings("unchecked")
  1328. 			ArrayList<HashMap<String, Object>> lists = (ArrayList<HashMap<String, Object>>) getDAO()
  1329. 					.executeQuery(strbuf.toString(), getMapListProcessor());
  1331. 			if (LfwLogger.isErrorEnabled()) {
  1332. 				LfwLogger.error("***************" + strbuf.toString()
  1333. 						+ "***************");
  1334. 			}
  1335. 			Map<String, Object> map = new HashMap<String, Object>();
  1336. 			ArrayList<Map<String, Object>> arrFinal = new ArrayList<Map<String, Object>>();
  1337. 			if (lists == null || lists.size() <= 0) {
  1338. 				map.put("flag", 0);
  1339. 				map.put("des", "没有符合条件的数据");
  1340. 				arrFinal.add(map);
  1341. 				return arrFinal;
  1342. 			} else {
  1343. 				map.put("flag", "0");
  1344. 				map.put("des", "查询成功");
  1345. 				map.put("ts", currenttime.toString());
  1346. 				map.put("resultList", lists);
  1347. 				ArrayList<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
  1348. 				list.add(map);
  1349. 				return list;
  1350. 			}
  1351. 		} catch (Exception e) {
  1352. 			// TODO: 操作异常
  1353. 			LfwLogger.error(e.getMessage(), e);
  1354. 			ArrayList<Map<String, Object>> resList = new ArrayList<Map<String, Object>>();
  1355. 			Map<String, Object> resMap = new HashMap<String, Object>();
  1356. 			resMap.put("flag", "1");
  1357. 			resMap.put("des", e.getMessage());
  1358. 			resList.add(resMap);
  1359. 			return resList;
  1360. 		}
  1361. 	}
  1362. }





使用BaseDao新建服务

原文：http://www.cnblogs.com/lanzhiming/p/4902414.html
踩
(0)
赞
(0)
   
举报
评论 一句话评论（0）
分享档案
更多>
2021年09月23日 (328)
2021年09月24日 (313)
2021年09月17日 (191)
2021年09月15日 (369)
2021年09月16日 (411)
2021年09月13日 (439)
2021年09月11日 (398)
2021年09月12日 (393)
2021年09月10日 (160)
2021年09月08日 (222)
最新文章
更多>
教程昨日排行
更多>
友情链接
汇智网   PHP教程   插件网  
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣，分享程序人生！