@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;
}