/** * 编辑提成比例 * * @return */ public String editTcbl() { try { tcblMap = lsdService.getTcbl(); } catch (Exception e) { log.error("编辑提成比例,原因:" + e.getMessage()); e.printStackTrace(); return ERROR; } return "success"; }
/** * 打开选择库存商品列表 * * @return */ public String selKcProc() { int rowsPerPage = 15; String con = " and a.state='正常'"; if (!product_name.equals("")) { product_name = ((product_name.replace(" ", " ")).replace(",", "")).replace(",", " "); String[] arryCon = product_name.split(" "); String tempSql = ""; if (arryCon != null && arryCon.length > 0) { con += " and("; for (int i = 0; i < arryCon.length; i++) { if (tempSql.equals("")) { tempSql = "(a.product_id like '%" + arryCon[i] + "%' or a.product_name like '%" + arryCon[i] + "%' or a.product_xh like '%" + arryCon[i] + "%' or a.sp_txm like '%" + arryCon[i] + "%')"; } else { tempSql = tempSql + " and (a.product_id like '%" + arryCon[i] + "%' or a.product_name like '%" + arryCon[i] + "%' or a.product_xh like '%" + arryCon[i] + "%' or a.sp_txm like '%" + arryCon[i] + "%')"; } } con += tempSql + ")"; } } if (!product_kind.equals("")) { con += " and a.product_kind like '" + product_kind + "%'"; } if (!prop.equals("")) { con += " and prop='" + prop + "'"; } productPage = productKcService.getProductKcList(con, curPage, rowsPerPage); storeList = storeService.getAllStoreList(); kindList = productKindService.getAllProductKindList(); sd = JMath.round(lsdService.getLssd()); // 提成比例 Map tcblMap = lsdService.getTcbl(); if (tcblMap != null) { basic_ratio = JMath.round( tcblMap.get("basic_ratio") == null ? 0 : ((Double) tcblMap.get("basic_ratio")).doubleValue()); out_ratio = JMath.round( tcblMap.get("out_ratio") == null ? 0 : ((Double) tcblMap.get("out_ratio")).doubleValue()); } return "success"; }