@Override public void initField() throws Exception { List<DbField> dbFields = new ArrayList<DbField>(); DbField field = new DbField("ID", "INVENTORY_DIFF_BILL_ID", GaConstant.DT_LONG); field.setQueryParamFormSource(GaConstant.INPUT_ROWOBJ, "INVENTORY_DIFF_BILL_ID"); field.setColumnDisplay(false, 0, true); dbFields.add(field); field = new DbField("盘点批次", "INVENTORY_BATCH_NUM", GaConstant.DT_STRING); field.setQueryOpera(GaConstant.QUERY_LIKE, 1, true); field.setInputCustomStyle("width:80px;"); dbFields.add(field); field = new DbField("差异流水账号", "BILL_NUM", GaConstant.DT_STRING); field.setQueryOpera(GaConstant.QUERY_EQUALS, 2, true); field.setInputCustomStyle("width:80px;"); dbFields.add(field); field = new DbField("库存数量", "STOCK_CNT", GaConstant.DT_MONEY); dbFields.add(field); field = new DbField("实盘数量", "INVENTORY_CNT", GaConstant.DT_INT); dbFields.add(field); field = new DbField("库存金额", "STOCK_AMOUNT", GaConstant.DT_INT); dbFields.add(field); field = new DbField("实盘金额", "INVENTORY_AMOUNT", GaConstant.DT_INT); dbFields.add(field); field = new DbField("盈亏数", "DIFF_CNT", GaConstant.DT_INT); field.setQueryOpera(GaConstant.QUERY_GREATER_THAN, 4, true); dbFields.add(field); field = new DbField("盈亏金额", "DIFF_AMOUNT", GaConstant.DT_MONEY); field.setQueryOpera(GaConstant.QUERY_BETWEEN, GaConstant.INPUT_MONEY, 5, false); dbFields.add(field); field = new DbField("处理人", "TRUENAME", GaConstant.DT_STRING); dbFields.add(field); field = new DbField("处理时间", "CREATE_TIME", GaConstant.DT_DATETIME); dbFields.add(field); field = new DbField("状态", "STATE", GaConstant.DT_INT); field.setAliasCode("id"); field.setQueryOpera(GaConstant.QUERY_EQUALS, GaConstant.INPUT_SELECT, 6, true); field.setLookupData(SystemUtil.getStatusMap()); dbFields.add(field); this.fieldList = dbFields; }
@Override public void initField() throws Exception { List<DbField> dbFields = new ArrayList<DbField>(); DbField field = new DbField("ID", "SHOP_ID", GaConstant.DT_LONG); field.setQueryParamFormSource(GaConstant.INPUT_ROWOBJ, "SHOP_ID"); field.setColumnDisplay(false, 0, true); dbFields.add(field); field = new DbField("商家名称", "SHOP_NAME", GaConstant.DT_STRING); field.setQueryOpera(GaConstant.QUERY_LIKE, 0, false); dbFields.add(field); field = new DbField("会员帐号", "USERNAME", GaConstant.DT_STRING); field.setQueryOpera(GaConstant.QUERY_LIKE, 1, false); dbFields.add(field); field = new DbField("类型", "TYPE", GaConstant.DT_INT); field.setQueryOpera(GaConstant.QUERY_EQUALS, GaConstant.INPUT_SELECT, 2, true); Map<String, Object> option = new LinkedHashMap<String, Object>(); option.put("1", "个体商家"); option.put("2", "企业商家"); field.setLookupData(new LookupDataSet(option)); dbFields.add(field); field = new DbField("店铺类型", "SHOP_TYPE", GaConstant.DT_INT); field.setQueryOpera(GaConstant.QUERY_EQUALS, GaConstant.INPUT_SELECT, 3, true); option = new LinkedHashMap<String, Object>(); option.put("3", "整车厂"); field.setLookupData(new LookupDataSet(option)); dbFields.add(field); field = new DbField("法人代表", "LEGAL", GaConstant.DT_STRING); dbFields.add(field); field = new DbField("联系电话", "TEL", GaConstant.DT_STRING); dbFields.add(field); field = new DbField("是否推荐", "IS_RECOMMEND", GaConstant.DT_INT); field.setQueryOpera(GaConstant.QUERY_EQUALS, GaConstant.INPUT_SELECT, 4, true); field.setLookupData(SystemUtil.getYesNoMap()); dbFields.add(field); field = new DbField("是否认证", "IS_CHECK", GaConstant.DT_INT); field.setInput(GaConstant.INPUT_SELECT); field.setLookupData(SystemUtil.getYesNoMap()); dbFields.add(field); field = new DbField("是否开启个人店铺", "IS_OPEN_PERSONAL", GaConstant.DT_INT); field.setInput(GaConstant.INPUT_SELECT); field.setLookupData(SystemUtil.getYesNoMap()); dbFields.add(field); field = new DbField("创建时间", "CREATE_TIME", GaConstant.DT_DATETIME); field.setFormat(new CustomFormat(GaConstant.DT_DATETIME, "yyyy-MM-dd HH:mm:ss", false)); dbFields.add(field); field = new DbField("状态", "STATE", GaConstant.DT_INT); field.setAliasCode("s"); field.setQueryOpera(GaConstant.QUERY_EQUALS, GaConstant.INPUT_SELECT, 5, true); field.setLookupData(SystemUtil.getStatusMap()); field.setColumnDisplay(true, 50, false); dbFields.add(field); this.fieldList = dbFields; }