Example #1
0
  @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;
  }
Example #2
0
  @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;
  }