- // 物品编码唯一性校验
- IMarketingItem marketingItem = MarketingItemFactory.getRemoteInstance();
- StringBuffer sql = new StringBuffer();
- sql.append("select number where number='");
- sql.append(txtNumber.getText().trim());
- sql.append("'");
- sql.append(" and ");
- sql.append("dept = '");
- sql.append(this.editData.getDept().getId().toString());
- sql.append("'");
- if (this.oprtState.equals(OprtState.EDIT)) {
- sql.append(" and id != '");
- sql.append(this.editData.getId().toString());
- sql.append("'");
- }
- boolean exists = marketingItem.exists(sql.toString());
- if (exists) {
- MsgBox.showWarning("该物品编码已经存在!");
- txtNumber.requestFocusInWindow();
- SysUtil.abort();
- }
转载于:https://blog.51cto.com/huqianhao/956215