1.单表【分布式】案例
效果图
目录结构
1.1.html页面
<!--true boName;TestOrder firstLayoutBoName:-->
<!--
- Author(s):java业务平台代码生成工具
- Date: 2018年07月25日 11点35分25秒
- Copyright Notice:版权声明 厦门吉联科技, 版权所有 违者必究
- @(#)
- Description: businessType:,pageType:manage
- <功能>主对象订单TestOrder(TestOrder)管理页面
- 文件名称: testOrderManage.html
-->
订单TestOrder管理页面
<!-- <link rel="stylesheet" href="/resource/js/lib/bootstrap/css/bootstrap.min.css" /> -->
<script src="/static/app/appconfig.js"></script>
<script>// <![CDATA[
document.write('<script src="/bower_components/requirejs/require.js" data-main="' + $oms.path + '/static/app.js" data-bootstrap-modules="[\'oms/samle/testOrderManage\']"><\/script>');
// ]]></script>
<!-- pageLayout:9e382bb599fd406e85550741394b8bda -cellName:F0 -parentCellName: inTabLoadSupport:false inMainTabPanel:false-->
<div class="module"><!--[0]9e382bb599fd406e85550741394b8bda-->
<!--layoutContainerType:DIV-->
<!-- pageLayout:911a84865d5d4c348e9435a49fc82a9b -cellName:F0-0 -parentCellName:F0 inTabLoadSupport:false inMainTabPanel:false-->
<div class="container-fluid col-md-0 col-xs-0 col-sm-0 col-lg-0"><!--[4]911a84865d5d4c348e9435a49fc82a9b-->
<!--layoutContainerType:DIV-->
<!-- pageLayout:66b007eb0a0a4d44b2f690efe09af92d -cellName:F0-0-0 -parentCellName:F0-0 inTabLoadSupport:false inMainTabPanel:false-->
<!-- FORM 标签-->
<!--F0-0-0--->
<!-- 66b007eb0a0a4d44b2f690efe09af92d isSearch:true--haveValidation:false--><form autocomplete="off" name="Form_F0_0_0"><!--[8]-->
<!-- 66b007eb0a0a4d44b2f690efe09af92d -cellName:F0-0-0-->
<!--layoutContainerType:FORM-->
<!-- pageLayout:f4d95c81377740ca849c40375837782f -cellName:F0-0-0-0 -parentCellName:F0-0-0 inTabLoadSupport:false inMainTabPanel:false-->
<div class="col-md-0 col-xs-0 col-sm-0 col-lg-0"><!--[12]f4d95c81377740ca849c40375837782f-->
<!--layoutContainerType:DIV-->
<!--layoutElementType:ELEMENT-->
<!-- pageLayout:0aba2cfeaa8d49e19bc3f54a9f5796d5 -cellName:F0-0-0-0-0 -parentCellName:F0-0-0-0 inTabLoadSupport:false inMainTabPanel:false-->
<div class="row"><!--[16]0aba2cfeaa8d49e19bc3f54a9f5796d5-->
<!--layoutContainerType:DIV-->
<!-- pageLayout:44e0ef0b7a434d88a352d903ff9ec854 -cellName:F0-0-0-0-0-0 -parentCellName:F0-0-0-0-0 inTabLoadSupport:false inMainTabPanel:false-->
<div class="col-md-3 col-xs-3 col-sm-3 col-lg-3"><!--[20]44e0ef0b7a434d88a352d903ff9ec854-->
<!--layoutContainerType:DIV-->
<!-- realFormType:form-horizontal -->
<!-- [renderFormItems] realPageType:manage inModuleLeft: false F0-0-0-0-0 row Y F0-0-0-0-0-0-->
<!--cellType: form-horizontal layoutContainerType:DIV DIV styleClass:row--><!--[renderFormItems]:modelName: -->
<!--[renderFormItem]01 4 multiIndex:-1 cellType:form-horizontal ngModel:-->
<!--[renderFormItem]fruitOrderSenderName-X-发货人 fruitOrderSenderName-->
<div class="form-group form-group-padding">
发货人：
<!--[renderFormItem]controlWidth:0 cellType:form-horizontal-->
<div class="col-md-8 col-xs-8 col-sm-8 col-lg-8 ">
<input id="search.fruitOrderSenderName" class="input form-control" name="search.fruitOrderSenderName" type="text" />
</div>
</div>
</div>
<!-- 44e0ef0b7a434d88a352d903ff9ec854 a-->
<!-- pageLayout:538b93bd5bed40b4a951a46bac81f9e6 -cellName:F0-0-0-0-0-1 -parentCellName:F0-0-0-0-0 inTabLoadSupport:false inMainTabPanel:false-->
<div class="col-md-3 col-xs-3 col-sm-3 col-lg-3"><!--[20]538b93bd5bed40b4a951a46bac81f9e6-->
<!--layoutContainerType:DIV-->
<!-- realFormType:form-horizontal -->
<!-- [renderFormItems] realPageType:manage inModuleLeft: false F0-0-0-0-0 row Y F0-0-0-0-0-1-->
<!--cellType: form-horizontal layoutContainerType:DIV DIV styleClass:row--><!--[renderFormItems]:modelName: -->
<!--[renderFormItem]06 4 multiIndex:-1 cellType:form-horizontal ngModel:-->
<!--[renderFormItem]fruitOrderStatus-X-订单状态 fruitOrderStatus-->
<div class="form-group form-group-padding">
订单状态：
<!--[renderFormItem]controlWidth:0 cellType:form-horizontal-->
<div class="col-md-8 col-xs-8 col-sm-8 col-lg-8 "></div>
</div>
</div>
<!-- 538b93bd5bed40b4a951a46bac81f9e6 a-->
<!-- pageLayout:a0fc60915f9e4338b5520998f4ec08a4 -cellName:F0-0-0-0-0-2 -parentCellName:F0-0-0-0-0 inTabLoadSupport:false inMainTabPanel:false-->
<div class="col-md-3 col-xs-3 col-sm-3 col-lg-3"><!--[20]a0fc60915f9e4338b5520998f4ec08a4-->
<!--layoutContainerType:DIV-->
<!-- realFormType:form-horizontal -->
<!-- [renderFormItems] realPageType:manage inModuleLeft: false F0-0-0-0-0 row Y F0-0-0-0-0-2-->
<!--cellType: form-horizontal layoutContainerType:DIV DIV styleClass:row--><!--[renderFormItems]:modelName: -->
<!--[renderFormItem]01 4 multiIndex:-1 cellType:form-horizontal ngModel:-->
<!--[renderFormItem]fruitOrderReceiver-X-收货人 fruitOrderReceiver-->
<div class="form-group form-group-padding">
收货人：
<!--[renderFormItem]controlWidth:0 cellType:form-horizontal-->
<div class="col-md-8 col-xs-8 col-sm-8 col-lg-8 ">
<input id="search.fruitOrderReceiver" class="input form-control" name="search.fruitOrderReceiver" type="text" />
</div>
</div>
</div>
<!-- a0fc60915f9e4338b5520998f4ec08a4 a-->
<!-- pageLayout:c74c790ea3e94530afc28b2c52820468 -cellName:F0-0-0-0-0-3 -parentCellName:F0-0-0-0-0 inTabLoadSupport:false inMainTabPanel:false-->
<div class="col-md-3 col-xs-3 col-sm-3 col-lg-3"><!--[20]c74c790ea3e94530afc28b2c52820468-->
<!--layoutContainerType:DIV-->
<!-- realFormType:form-horizontal -->
<!-- [renderFormItems] realPageType:manage inModuleLeft: false F0-0-0-0-0 row Y F0-0-0-0-0-3-->
<!--cellType: form-horizontal layoutContainerType:DIV DIV styleClass:row--><!--[renderFormItems]:modelName: -->
<!--[renderFormItem]01 4 multiIndex:-1 cellType:form-horizontal ngModel:-->
<!--[renderFormItem]fruitGrossWeight-X-毛重 fruitGrossWeight-->
<div class="form-group form-group-padding">
毛重：
<!--[renderFormItem]controlWidth:0 cellType:form-horizontal-->
<div class="col-md-8 col-xs-8 col-sm-8 col-lg-8 ">
<input id="search.fruitGrossWeight" class="input form-control" name="search.fruitGrossWeight" type="text" />
</div>
</div>
</div>
<!-- c74c790ea3e94530afc28b2c52820468 a-->
</div>
<!-- 0aba2cfeaa8d49e19bc3f54a9f5796d5 a-->
</div>
<!-- f4d95c81377740ca849c40375837782f a-->
</form><!-- 66b007eb0a0a4d44b2f690efe09af92d b-->
<!-- pageLayout:5e34f880677e46c49f04034ba79fa1dc -cellName:F0-0-1 -parentCellName:F0-0 inTabLoadSupport:false inMainTabPanel:false-->
<div class="row">
<!--[8]5e34f880677e46c49f04034ba79fa1dc-->
<div class="col-md-12 col-xs-12 col-sm-12 col-lg-12"><!--[8]5e34f880677e46c49f04034ba79fa1dc -cellName:F0-0-112-->
<!--layoutContainerType:DIV-->
<!-- pageLayout:8126c5343c504585b6ba3e5eae071b92 -cellName:F0-0-1-0 -parentCellName:F0-0-1 inTabLoadSupport:false inMainTabPanel:false-->
<div class="col-md-0 col-xs-0 col-sm-0 col-lg-0"><!--[12]8126c5343c504585b6ba3e5eae071b92-->
<!--layoutContainerType:DIV-->
<!--layoutElementType:TOOLBAR-->
<!-- realFormType:form -->
<!--[renderFormItem]01 0 multiIndex:-1 cellType:form ngModel:--><!-- layoutBoName: TestOrder-->
<!--generatorToolBarButton true-->
<!--generatorToolBarButton pageType:manage elementId:a6957d4e61d3460bb2332f1a73953dc7 isHide: methodName:query-->
<!--query-->
<button id="testOrder.queryTestOrder" class="button-blue" type="button"> 查询 </button>
<button id="testOrder.reset" class="button-default" type="button"> 重置 </button>
<!--[renderFormItem]01 0 multiIndex:-1 cellType:form ngModel:-->
<!-- layoutBoName: TestOrder-->
<!--generatorToolBarButton true-->
<!--generatorToolBarButton pageType:manage elementId:a813324a4dc04e1da7d3453dba7e8abf isHide: methodName:add-->
<!--add 02-->
<button id="testOrder.addTestOrder" class="button-primary" type="button"> 新增 </button>
<!--[renderFormItem]01 0 multiIndex:-1 cellType:form ngModel:-->
<!-- layoutBoName: TestOrder-->
<!--generatorToolBarButton true-->
<!--generatorToolBarButton pageType:manage elementId:c085f4a4e0ed4d3a881939d8a97bbfe7 isHide: methodName:deletes-->
<!--deletes-->
<button id="testOrder.deleteTestOrders" class="button-primary" type="button">
批量删除
</button>
<!--[renderFormItem]01 0 multiIndex:-1 cellType:form ngModel:-->
<!-- layoutBoName: TestOrder-->
<!--generatorToolBarButton true-->
<!--generatorToolBarButton pageType:manage elementId:fd313da56e48438da1f0a41a1f2aa8ce isHide: methodName:saveOrUpdates-->
<!--saveOrUpdates-->
<button id="testOrder.saveOrUpdates" class="button-primary" type="button"> 批量保存 </button>
<button id="testOrder.showDeletedTestOrder" class="button-primary" type="button">查看删除</button>
<button id="testOrder.recoveryDeletedTestOrder" class="button-primary" type="button">恢复删除</button>
</div>
<!-- 8126c5343c504585b6ba3e5eae071b92 a-->
</div>
<!-- 5e34f880677e46c49f04034ba79fa1dc 12-->
</div>
<!-- 5e34f880677e46c49f04034ba79fa1dc a-->
<!-- pageLayout:f5a8d7f2529a4e10bf1e59db131291b7 -cellName:F0-0-2 -parentCellName:F0-0 inTabLoadSupport:false inMainTabPanel:false-->
<div class="row">
<!--[8]f5a8d7f2529a4e10bf1e59db131291b7-->
<div class="col-md-12 col-xs-12 col-sm-12 col-lg-12"><!--[8]f5a8d7f2529a4e10bf1e59db131291b7 -cellName:F0-0-212-->
<!--layoutContainerType:DIV-->
<!-- pageLayout:53765034a91240ba859bf582dc22f458 -cellName:F0-0-2-0 -parentCellName:F0-0-2 inTabLoadSupport:false inMainTabPanel:false-->
<div class="col-md-0 col-xs-0 col-sm-0 col-lg-0"><!--[12]53765034a91240ba859bf582dc22f458-->
<!--layoutContainerType:DIV-->
<!--layoutElementType:GRID--><!-- needPaging:X ,gridEditType: G,isEditTableFlag：null, null--->
<!--TODO linjx isOperatoionColumn:true generatorOperation:false-->
<!-- one fruitGrossWeight 01-->
毛重
<input id="testOrder.fruitGrossWeight" class="input form-control" name="testOrder.fruitGrossWeight" type="text" />
<!--TODO linjx isOperatoionColumn:false generatorOperation:true-->
<!-- one fruitBooknum 01-->
箱数
<input id="testOrder.fruitBooknum" class="input form-control" name="testOrder.fruitBooknum" type="text" />
<!--TODO linjx isOperatoionColumn:false generatorOperation:true-->
<!-- one fruitOrderReceiver 01-->
收货人
<input id="testOrder.fruitOrderReceiver" class="input form-control" name="testOrder.fruitOrderReceiver" type="text" />
<!--TODO linjx isOperatoionColumn:false generatorOperation:true-->
<!-- one fruitOrderSenderName 01-->
发货人
<input id="testOrder.fruitOrderSenderName" class="input form-control" name="testOrder.fruitOrderSenderName" type="text" />
<!--TODO linjx isOperatoionColumn:false generatorOperation:true-->
<!-- one fruitOrderStatus 06-->
订单状态
<!--TODO linjx isOperatoionColumn:false generatorOperation:true-->
主键
<input name="testOrder.fruitOrderId" type="text" />
是否删除
<input name="testOrder.isDeleted" type="text" />
</div>
<!-- 53765034a91240ba859bf582dc22f458 a-->
</div>
<!-- f5a8d7f2529a4e10bf1e59db131291b7 12-->
</div>
<!-- f5a8d7f2529a4e10bf1e59db131291b7 a-->
</div>
<!-- 911a84865d5d4c348e9435a49fc82a9b a-->
</div>
<!-- 9e382bb599fd406e85550741394b8bda a-->
<!--[0]-pageLayoutId:9e382bb599fd406e85550741394b8bda-cellName:F0-parentCellName:-isParent:X-seqNo:0-->
<!--[4]-pageLayoutId:911a84865d5d4c348e9435a49fc82a9b-cellName:F0-0-parentCellName:F0-isParent:X-seqNo:0-->
<!--[8]-pageLayoutId:66b007eb0a0a4d44b2f690efe09af92d-cellName:F0-0-0-parentCellName:F0-0-isParent:X-seqNo:0-->
<!--[12]-pageLayoutId:f4d95c81377740ca849c40375837782f-cellName:F0-0-0-0-parentCellName:F0-0-0-isParent:X-seqNo:0-->
<!--[16]-pageLayoutId:0aba2cfeaa8d49e19bc3f54a9f5796d5-cellName:F0-0-0-0-0-parentCellName:F0-0-0-0-isParent:X-seqNo:0-->
<!--[20]-pageLayoutId:44e0ef0b7a434d88a352d903ff9ec854-cellName:F0-0-0-0-0-0-parentCellName:F0-0-0-0-0-isParent:-seqNo:0-->
<!--fruitOrderSenderName-X-发货人-layoutBoName:TestOrder-seqNo:0-->
<!--[20]-pageLayoutId:538b93bd5bed40b4a951a46bac81f9e6-cellName:F0-0-0-0-0-1-parentCellName:F0-0-0-0-0-isParent:-seqNo:1-->
<!--fruitOrderStatus-X-订单状态-layoutBoName:TestOrder-seqNo:0-->
<!--[20]-pageLayoutId:a0fc60915f9e4338b5520998f4ec08a4-cellName:F0-0-0-0-0-2-parentCellName:F0-0-0-0-0-isParent:-seqNo:2-->
<!--fruitOrderReceiver-X-收货人-layoutBoName:TestOrder-seqNo:0-->
<!--[20]-pageLayoutId:c74c790ea3e94530afc28b2c52820468-cellName:F0-0-0-0-0-3-parentCellName:F0-0-0-0-0-isParent:-seqNo:3-->
<!--fruitGrossWeight-X-毛重-layoutBoName:TestOrder-seqNo:0-->
<!--[8]-pageLayoutId:5e34f880677e46c49f04034ba79fa1dc-cellName:F0-0-1-parentCellName:F0-0-isParent:X-seqNo:1-->
<!--[12]-pageLayoutId:8126c5343c504585b6ba3e5eae071b92-cellName:F0-0-1-0-parentCellName:F0-0-1-isParent:X-seqNo:0-->
<!--[8]-pageLayoutId:f5a8d7f2529a4e10bf1e59db131291b7-cellName:F0-0-2-parentCellName:F0-0-isParent:X-seqNo:2-->
<!--[12]-pageLayoutId:53765034a91240ba859bf582dc22f458-cellName:F0-0-2-0-parentCellName:F0-0-2-isParent:X-seqNo:0-->
1.2.入口js
//isNewConfig:true boName;TestOrder firstLayoutBoName:
/**
* Author(s):java业务平台代码生成工具
* Date: 2018年07月25日 11点35分23秒
* Copyright Notice:版权声明 厦门吉联科技, 版权所有 违者必究
* @(#)
* Description: businessType:,pageType:manage
* <功能>主对象订单TestOrder(TestOrder)管理页面JS
* 文件名称: testOrderManage.js
*/
//<!-- 2595724d3f00410abf614d45b5215fd8 haveModuleLeftRight: haveGrid: X haveTabs***: haveFoundTree:-->
define([
'angular',
$config.path+requireBaseUrl+'/oms/samle/testOrderManageCtrl.js', 'layer',
'framework/datasource/DataSourceModule',
'framework/dict/GillionDictModule',
'framework/date/DateModule',
'framework/time/TimeModule',
'framework/associate/GillionAssociateModule',
'framework/dropdown/GillionDropdownModule',
'framework/dropdownbtn/GillionDropDownBtnModule',
'framework/dataGrid/DataGridModule',
'framework/pagination/GillionPaginationModule',
'framework/dynamic/dynamicForm',
'service/RuleService',
'collapsejs',
'framework/msg/GillionMsgModule',
'framework/clickbox/GillionClickBoxModule',
'framework/grid/fixgrid'
], function (angular, testOrderManageCtrl, layer) {
var module = angular.module('testOrderManage', ['DataSourceModule','GillionDictModule','DateModule','TimeModule','GillionAssociateModule','GillionDropdownModule','DataGridModule','GillionPaginationModule','dynamicForm','RuleService','GillionMsgModule','GillionClickBoxModule','GillionDropDownBtnModule'])
.controller('testOrderController', function ($scope,$rootScope,$compile,$q,$filter,$dataSource,$dataSourceManager,$http,$timeout,Params,Arrays,GillionMsgService,RuleService,GillionMsg,AssociatePromiseService) {
var controller = new testOrderManageCtrl({
rootScope: $rootScope,
grid: true,
form:true,
scope: $scope,
config: $config
});
controller.init();
});
getCommonDirective(module).YesOrNo().wrapNoneLeaf().onFinishRender(false,false);
return module;
});
1.3.BsCtrl.js
//true boName;TestOrder firstLayoutBoName:
/**
* ###########【本文件不允许修改,需要二次开发扩展请修改文件****Ctrl.js文件】################
* Author(s):java业务平台代码生成工具
* Date: 2018年07月25日 11点35分24秒
* Copyright Notice:版权声明 厦门吉联科技, 版权所有 违者必究
* @(#)
* Description: businessType:,pageType:manage
* <功能>主对象订单TestOrder(TestOrder)管理页面 base controller JS
* 文件名称: testOrderManageBsCtrl.js
*/
define([
'underscore',
'layer',
'main/BaseController',
'service/utils'
], function ( _, layer, BaseController) {
var Controller = inherit(function (options) {
BaseController.call(this, options);
//<!-- 2595724d3f00410abf614d45b5215fd8 haveModuleLeftRight: haveGrid: X haveTabs: haveFoundTree:-->
var _this = this,
$scope = _this.scope,
$config = _this.config,
injector = angular.element(document).injector(),
Params = injector.get("Params"),
$rootScope = injector.get("$rootScope"),
$dataSourceManager = injector.get("$dataSourceManager"),
$http = injector.get("$http"),
$q = injector.get("$q"),
$timeout = injector.get("$timeout"),
$compile = injector.get("$compile"),
RuleService = injector.get("RuleService"),
AssociatePromiseService = injector.get("AssociatePromiseService"),
GillionMsg = injector.get("GillionMsg"),
GillionMsgService = injector.get("GillionMsgService"),
Arrays = injector.get("Arrays");
$scope.__initDefaultValueFlag = true;
$scope.__initQueryDefaultValueFlag = true;
$scope.__initGridDefaultValueFlag = true;
$scope.formArrays = [];
$scope.gridOptions = {};
$scope.gridArrays = [];
$scope.gridOptions.settings = {scope: "$scope",grid: $scope.gridArrays};
_this.initPageState({ config:$config, pageType:"manage", boInsName:"testOrder", isNewConfig:true, isTabPage:false },[ ]);
/**
* TODO GLPaaS生成
*
*/
$scope.__reloadCurentPage = function(modelName){
if($scope.reset && !modelName){$scope.reset();}
if($scope.getTestOrder && (!modelName || modelName=="TestOrder"))
$scope.getTestOrder($scope.testOrder.fruitOrderId);
var gridVerifyArr = [ { scope:"$scope" ,grid:["testOrder"] ,resetValid:"G" }, ];
_this.gridVerify({boName:"TestOrder",scope:$scope,settings:gridVerifyArr});
};
$scope.isLoading = false; //是否载入中
//manage
$scope.search = {};
$scope.searchMode="0";
$scope.$$oldsearchMode = $scope.searchMode;
//B
//testOrder 13
$scope.testOrder = {
fruitOrderId : Params.fruitOrderId,
};
//pageLayoutJsLib generatorBoBoInstanceWatch
$scope.search = {};
$scope.search.fruitOrderSenderName=null;
$scope.search.fruitOrderStatus=null;
$scope.search.fruitOrderReceiver=null;
$scope.search.fruitGrossWeight=null;
$scope.$$isDeleted_='N';
/**
* TODO GLPaaS生成
* 重置
*/
$scope.reset = function()
{
$scope.search = {};
$scope.search.fruitOrderSenderName=null;
$scope.search.fruitOrderStatus=null;
$scope.search.fruitOrderReceiver=null;
$scope.search.fruitGrossWeight=null;
$scope.$$isDeleted_='N';
//接收参数
if($scope.initQueryDefaultValue && $scope.__initQueryDefaultValueFlag) $scope.initQueryDefaultValue();
$scope.initFocus && $scope.initFocus();
};
/**
* TODO GLPaaS生成
* 根据主键取值
*/
$scope.getTestOrder = function(fruitOrderId){
var param = {};
param.fruitOrderId = fruitOrderId || "";
param.cascade = false;
var tip = layer.load(0, {shade: false});
$http.get($config.ctx
+ '/testOrder/getTestOrder',{params:param}).success(function(data){
layer.close(tip);
if (data.success != undefined && data.success == true) {
$scope.testOrder = data.testOrder;
if($scope.workFlowTaskId) {
$scope.testOrder.workFlowTaskId = $scope.workFlowTaskId;
}
var processState = $scope.testOrder.processState;
if(!processState){
processState = Params.processState;
$scope.testOrder.processState = processState;
}
if(processState && $scope.isEntryProcess==false)
$scope.isSubmited = true ;
$scope.initAcceptParams && $scope.initAcceptParams();
if($scope._pageState) $scope._pageState.resetDataState();
$timeout(function() {
$rootScope.$broadcast('pageRenderFinish');
},1);
}
}).error(function(){
layer.close(tip);
});
};
//<!--ELEMENT-->
//<!--TOOLBAR-->
//TODO LayoutElementType.TOOLBAR
//toolbarJs_pageLayoutId: 8126c5343c504585b6ba3e5eae071b92
//TODO 20171019 linjx FORM START query_TOOLBAR
/**
* TODO GLPaaS生成
* 查询
*/
$scope.queryTestOrder = function()
{
if($scope.Form_F0_0_0 && $scope.Form_F0_0_0.$validator){
$scope.Form_F0_0_0.verify();
}
if($scope.Form_F0_0_0 && !$scope.Form_F0_0_0.$valid){
return;
}
$scope._finishEditGridWrap($scope.testOrderGrid,$scope.testOrders,$scope);
if($scope._pageState._dataState == $config.dataState.MODIFY){
GillionMsg.confirm(null, "是否保存编辑的数据？", function (btn) {
if (btn) {
} else {
$scope.testOrderGrid.$$currentSelKey = undefined;
$scope.testOrders = [];
$scope._pageState._dataState = $config.dataState.NORMAL;
$scope.queryTestOrder();
}
});
return;
}
$scope.$$isDeleted_='N';
if($scope.testOrderGrid.formController){
var $validator = $scope.testOrderGrid.formController.$validator;
$validator.disable();
$validator.reset();
}
$scope._finishEditGridWrap($scope.testOrderGrid,$scope.testOrders,$scope);
if($scope.testOrderGrid.formController){
$validator.enable();
}
$scope.testOrderGrid._reset();
var gridVerifyArr = [ { scope:"$scope" ,grid:["testOrder"] ,resetValid:"G" }, ];
_this.gridVerify({boName:"TestOrder",scope:$scope,settings:gridVerifyArr});
$scope.getTestOrderPages();
$scope.testOrderGrid.$$currentSelKey = undefined;
if($scope._pageState) $scope._pageState.resetDataState();
};
//TODO 20171019 linjx FORM START add_TOOLBAR
$scope.newTestOrderGridId = -9223372036;
/**
* TODO GLPaaS生成
* 新增订单TestOrder
*/
$scope.addTestOrder = function() {
$scope.__testOrderButtonEvent = true;
if($scope.testOrderGrid && $scope.testOrderGrid.formController && $scope.testOrderGrid.formController.verify){
$scope.testOrderGrid.formController.verify();
}
if($scope.testOrderGrid && $scope.testOrderGrid.formController && $scope.testOrderGrid.formController.$valid==false)
return ;
$scope._finishEditGridWrap($scope.testOrderGrid,$scope.testOrders,$scope);
//0 TestOrder
var newRow = {
fruitOrderId : $scope.newTestOrderGridId++,
rowStatus : 4
};
//表格单号规则处理代码
var defaultParams =[];
_this.initGridDefaultValueCommon(_this,$http,"add",defaultParams,function(){
$scope.testOrderDataSource.totalRecord=$scope.testOrderDataSource.totalRecord+1;
});
var addRowIndex = $config.gridAddRowPos === 'bottom' ? $scope.testOrders.length : 0;
if($scope.testOrderGrid.changeDataSourced)
$scope.testOrderGrid.changeDataSourced = false;
$scope.testOrder = newRow;
$scope.testOrderGrid.$$added=true;
if($config.gridAddRowPos === 'bottom'){
$scope.testOrders.push(newRow);
} else {
$scope.testOrders.unshift(newRow);
}
flag = false;
var gridVerifyArr = [ { scope:"$scope" ,grid:["testOrder"] ,resetValid:"G" }, ];
_this.gridVerify({boName:"TestOrder",scope:$scope,settings:gridVerifyArr});
if($scope._pageState && $scope._pageState.setDataStateModify)
$scope._pageState.setDataStateModify();
};
//TODO 20171019 linjx FORM START deletes_TOOLBAR
/**
* TODO GLPaaS生成
* 批量删除订单TestOrder
*/
$scope.deleteTestOrders = function(){
var ids = Arrays.extract($scope.testOrderCheckedRows, 'fruitOrderId').join(',');
if(ids.length == 0){
GillionMsg.alert("提示","请选择要删除的记录!");
return;
}
$scope.logicDelObjs = angular.copy($scope.testOrderCheckedRows);
GillionMsg.confirm(null,'确认删除?',function(btn) {
if (btn) {
if($scope.testOrderGrid.formController){
var $validator = $scope.testOrderGrid.formController.$validator;
$validator.disable();
$validator.reset();
}
if($scope.testOrderGrid.formController){
$validator.enable();
}
$scope._finishEditGridWrap($scope.testOrderGrid,$scope.testOrders,$scope);
$http.post($config.ctx
+ '/testOrder/deletes',{ids : ids,isLogic:true}).success(function(data){
if (data.success != undefined && data.success == true) {
$scope.getTestOrderPages();
if($scope._pageState) $scope._pageState.resetDataState();
var gridVerifyArr = [ { scope:"$scope" ,grid:["testOrder"] ,resetValid:"G" }, ];
_this.gridVerify({boName:"TestOrder",scope:$scope,settings:gridVerifyArr});
GillionMsg.alert("提示", data.msg);
}
});
}
});
};
//TODO 20171019 linjx FORM START saveOrUpdates_TOOLBAR
/**
* TODO GLPaaS生成
* 批量保存 订单TestOrder
*/
$scope.saveOrUpdates = function(){
AssociatePromiseService.callback(function(){
var gridRequiresPromises = [];
if($scope.testOrderGrid && $scope.testOrderGrid.tbody.rows[0]){
var testOrderRequiresPromise = $scope.testOrderGrid.verifySourceRequires();
gridRequiresPromises.push(testOrderRequiresPromise);
}
if(gridRequiresPromises && gridRequiresPromises.length>0) {
$q.all(gridRequiresPromises).then(function() {
callback();
})['catch'](function (result){
console.log("数据经验未通过！");
})['finally'](function(result){
console.log("执行表格非空经验.");
});
} else {
callback();
}
var callback = function(){ //callback
if($scope.testOrderGrid && $scope.testOrderGrid.formController && $scope.testOrderGrid.formController.verify){
$scope.testOrderGrid.formController.verify();
}
if($scope.testOrderGrid && $scope.testOrderGrid.formController && $scope.testOrderGrid.formController.$valid==false)
return ;
$scope._finishEditGridWrap($scope.testOrderGrid,$scope.testOrders,$scope);
var gridVerifyArr = [ { scope:"$scope" ,grid:["testOrder"] ,resetValid:"G" }, ];
_this.gridVerify({boName:"TestOrder",scope:$scope,settings:gridVerifyArr});
var param = $scope.testOrders.concat($scope.testOrderDeleteds);
$http.post($config.ctx
+ '/testOrder/saveOrUpdates',param).success(function(data){
if (data.success != undefined && data.success == true){
$scope.getTestOrderPages();
$scope.testOrders = data.testOrders;
$scope.perTestOrders = data.testOrders;
$scope.testOrderGrid._reset();
$scope.testOrderDeleteds=[];
if($scope._pageState) $scope._pageState.resetDataState();
var gridVerifyArr = [ { scope:"$scope" ,grid:["testOrder"] ,resetValid:"G" }, ];
_this.gridVerify({boName:"TestOrder",scope:$scope,settings:gridVerifyArr});
GillionMsg.alert("提示", data.msg);
}
}).error(function(){
});
} //end callback
});
};
/**
* TODO GLPaaS生成
* 查看删除
*/
$scope.showDeletedTestOrder = function(){
//$scope.reset();
$scope.$$isDeleted_='Y';
$scope.getTestOrderPages();
$scope.searchMode = $scope.$$oldsearchMode;
if($scope.testOrderGrid.formController){
var $validator = $scope.testOrderGrid.formController.$validator;
$validator.disable();
$validator.reset();
}
$scope._finishEditGridWrap($scope.testOrderGrid,$scope.testOrders,$scope);
if($scope.testOrderGrid.formController){
$validator.enable();
}
var gridVerifyArr = [ { scope:"$scope" ,grid:["testOrder"] ,resetValid:"G" }, ];
_this.gridVerify({boName:"TestOrder",scope:$scope,settings:gridVerifyArr});
};
/**
* TODO GLPaaS生成
* 恢复删除
*/
$scope.recoveryDeletedTestOrder = function(){
if($scope.$$isDeleted_!="Y")
{
GillionMsg.alert("提示","请选择要恢复删除的记录或者请先查看删除记录!");
return ;
}
var ids = Arrays.extract($scope.testOrderCheckedRows, 'fruitOrderId').join(',');
if(ids.length == 0){
GillionMsg.alert("提示","请选择要恢复删除的记录!");
return;
}
$scope.recDelObjs = angular.copy($scope.testOrderCheckedRows);
GillionMsg.confirm(null,'确认恢复?',function(btn) {
if (btn) {
$http.post($config.ctx
+ '/testOrder/recoveryDeleted',$scope.testOrderCheckedRows).success(function(data){
if (data.success != undefined && data.success == true) {
$scope.getTestOrderPages();
var gridVerifyArr = [ { scope:"$scope" ,grid:["testOrder"] ,resetValid:"G" }, ];
_this.gridVerify({boName:"TestOrder",scope:$scope,settings:gridVerifyArr});
GillionMsg.alert("提示", data.msg,function(){},{maxHeight:400});
}
});
}
});
};
//<!--GRID-->
$scope.testOrder = {};
$scope.testOrders = [];
$scope.perTestOrders = [];
$scope.testOrderDeleteds = [];
/**
* TODO GLPaaS生成
*
*/
$scope.$on('TestOrderSource',function(context,dataSource){
if(dataSource.records != undefined){
$scope.testOrders = dataSource.records ;
$scope.perTestOrders = angular.copy(dataSource.records) ;
}
//$scope.tableTestOrderEditStatus=false;
});
/**
* TODO GLPaaS生成
* TestOrderSource
*/
$dataSourceManager.getDataSource('TestOrderSource').then(function(dataSource){
$scope.testOrderDataSource = dataSource;
$scope.getTestOrderPages = function () {
var grid = $scope.testOrderGrid;
if(grid) grid._reset();
dataSource.doRequestData(1, null, function() {
},null);
};
if(Params.searchParams){
$scope.search=JSON.parse(Params.searchParams);
$scope.queryTestOrder();
}
});
/**
* TODO GLPaaS生成
*/
$scope.$watchCollection('testOrders', function(){
if($scope.testOrderDataSource){
$scope.testOrderDataSource.records = $scope.testOrders;
$scope.testOrderDataSource.totalRecord = $scope.testOrderDataSource.records.length;
if(!$scope.testOrderDataSource.totalPage)
$scope.testOrderDataSource.totalPage = 1;
var checkRowTempIndex =[];
if($scope.testOrderGrid.scope.checkedRows && $scope.testOrderGrid.scope.checkedRows.length >0){
angular.forEach($scope.testOrderGrid.scope.checkedRows,function(row,index){
var rowIndexTemp = _.findIndex($scope.testOrderDataSource.records,row);
checkRowTempIndex.push(rowIndexTemp);
});
}
$dataSourceManager.$rootScope.$broadcast("TestOrderSource", $scope.testOrderDataSource);
if(checkRowTempIndex && checkRowTempIndex.length > 0){
angular.forEach(checkRowTempIndex,function(dataIndex,index){
var row = $scope.testOrderDataSource.records[dataIndex];
var checked = Arrays.exists($scope.testOrderGrid.scope.checkedRows, row);
if (!checked) {
$scope.testOrderGrid.scope.checkedRows.push(row);
}
});
checkRowIndex=[];
}
}
});
/**
* TODO GLPaaS生成
*
*/
$scope.beforeSelectedTestOrder = function($event, record ,grid){
var $target = angular.element($event.target);
var $row = $target.closest('tr');
var innerRowIndex = $row[0].rowIndex;
$scope.testOrderCurRow = $row.scope();
if($scope.testOrderGrid && $scope.testOrderGrid.formController && $scope.testOrderGrid.formController.$valid==false)
return ;
if(record.rowStatus && record.rowStatus == 2 ){
//record.rowStatus = 16;
}
$scope.testOrder = record;
var gridVerifyArr = [ ];
_this.gridVerify({boName:"TestOrder",scope:$scope,settings:gridVerifyArr});
if($scope.$$isDeleted_=='X')
return true ;
var rowIndex = innerRowIndex || Arrays.indexOf($scope.testOrders, $scope.testOrder);
$scope.testOrder.$$rowIndex = rowIndex ;
var editIndex = grid.__editingRowIndex;
if(editIndex == innerRowIndex)
return true;
$scope._finishEditGridWrap($scope.testOrderGrid,$scope.testOrders,$scope);
if($target[0].parentNode.childNodes.length === 1 || editIndex !== innerRowIndex){
$scope.testOrderPrimaryKey($target, record, grid);
}
grid.startEdit(innerRowIndex);
//table edit cell focus()
var $editor = $target.closest('td').find('[data-role="editor"]');
$input = $editor.find(':input');
var disabled = false;
if ($input.prop('disabled') || $input.prop('readonly')) {
disabled = true;
}
if(!!($editor.length) && !disabled){
if($input.length){
$input[0].focus();
setTimeout(function() {
$input[0].select();
}, 10);
}
}else{
$input = $row.find('[data-role="editor"]').first().find(':input');
if($input.length){
$input[0].focus();
setTimeout(function() {
$input[0].select();
}, 10);
}
}
grid.$$currentSelKey = record.fruitOrderId;
};
/**
* TODO GLPaaS生成
*
*/
$scope.testOrderPrimaryKey = function($target, row, grid){
}
/**
* TODO GLPaaS生成
*
*/
$scope.queryTestOrderParams = function()
{
var searchColumns = [];
if ($scope.searchMode == '0') {
//G-fruitOrderSenderName
//fruitOrderSenderName
if($scope.search.fruitOrderSenderName){
searchColumns.push({
propertyName:'fruitOrderSenderName',
columnName:'FRUIT_ORDER_SENDER_NAME',
dataType:'S',
value:$scope.search.fruitOrderSenderName,
operation:'EQ'
});
};
//G-fruitOrderStatus
//fruitOrderStatus
if($scope.search.fruitOrderStatus){
searchColumns.push({
propertyName:'fruitOrderStatus',
columnName:'FRUIT_ORDER_STATUS',
dataType:'S',
value:$scope.search.fruitOrderStatus,
operation:'EQ'
});
};
//G-fruitOrderReceiver
//fruitOrderReceiver
if($scope.search.fruitOrderReceiver){
searchColumns.push({
propertyName:'fruitOrderReceiver',
columnName:'FRUIT_ORDER_RECEIVER',
dataType:'S',
value:$scope.search.fruitOrderReceiver,
operation:'EQ'
});
};
//G-fruitGrossWeight
//fruitGrossWeight
if($scope.search.fruitGrossWeight){
searchColumns.push({
propertyName:'fruitGrossWeight',
columnName:'FRUIT_GROSS_WEIGHT',
dataType:'N',
value:$scope.search.fruitGrossWeight,
operation:'EQ'
});
};
}
//isDeleted_ a X
if($scope.$$isDeleted_){
searchColumns.push({
propertyName:'isDeleted_',
columnName:'IS_DELETED',
dataType:'B',
booleanValues:{trueValue:'X',falseValue:''},
value:$scope.$$isDeleted_,
operation:'EQ'
});
}
var orderColumns = []
return {"searchColumns":searchColumns,"queryResultType":"page","sum":false , "orderColumns": orderColumns};
}
/**
* TODO GLPaaS生成
* initTestOrderGrid
*/
$scope.initTestOrderGrid = function(grid){
$scope.testOrderGrid = grid;
$scope.testOrderGrid.$$added=false;
if($scope._pageState) $scope._pageState.resetDataState();
};
/**
* TODO GLPaaS生成
*
*/
$scope.loadSuccessTestOrderGrid = function(grid,source){
if($scope.testOrderGrid.$$added==true){
if(source && source.length>0){
$scope._finishEditGridWrap($scope.testOrderGrid,$scope.testOrders,$scope);
//var $$index = (source && source.length>0) ? source.length-1 : 0;
//grid.startEdit($$index);
$timeout(function () {
var selectRowIndex = $config.gridAddRowPos === 'bottom' ? $scope.testOrders.length -1 : 0;
$scope.testOrderSelectedRow = source[selectRowIndex];
grid.startEdit(selectRowIndex);
if(selectRowIndex!==0)
grid.$gridBody.scrollTop($(grid.tbody).height());
});
var $element = grid.element;
var $tr = $element.find('.grid-body').find('tr').eq(0);
var firstInput = $tr.find('[data-role=editor]').find(':input')[0];
firstInput && firstInput.focus();
$scope.testOrderPrimaryKey(angular.element(grid.tbody.rows[0].cells[0]), source[0], grid);
//grid.formController.verify();
if(grid.formController && grid.formController.verify)
$timeout(grid.formController.verify,100);
$scope.testOrderGrid.$$added=false;
}
} else {
var innerRowIndex = 0;
if(grid.tbody.rows[0]){
var record = source[0];
var $target = angular.element(grid.tbody.rows[0].cells[0]);
var $row = $target.closest('tr');
if(record.rowStatus && record.rowStatus == 2){
//record.rowStatus = 16;
}
$scope.testOrder = record;
//当查询成功或手动点下一页时需要把校验初使化
if(grid.formController){
var $validator = grid.formController.$validator;
$validator.reset();
}
var gridVerifyArr = [ { scope:"$scope" ,grid:["testOrder"] ,resetValid:"G" }, ];
_this.gridVerify({boName:"TestOrder",scope:$scope,settings:gridVerifyArr});
if($scope.$$isDeleted_=='X')
return true ;
var rowIndex = innerRowIndex || Arrays.indexOf($scope.testOrders,$scope.testOrder);
$scope.testOrder.$$rowIndex = rowIndex ;
var editIndex = grid.__editingRowIndex;
if(editIndex == innerRowIndex)
return true;
$scope._finishEditGridWrap($scope.testOrderGrid,$scope.testOrders,$scope);
if(grid.formController){
grid.formController.$validator.enable();
}
if($target[0].parentNode.childNodes.length === 1 || editIndex !== innerRowIndex){
$scope.testOrderPrimaryKey($target, record, grid);
}
$scope.$$isAddEvent = $scope.testOrderGrid.$$added;
$timeout(function () {
//$scope.testOrderSelectedRow = record;
//grid.startEdit(innerRowIndex);
var $$currentSelKey = grid.$$currentSelKey;
var $$hasSelectPrimaryKey = false;
if(grid.$$currentSelKey && !$scope.$$isAddEvent){
angular.forEach(source,function(data,index){
if($$currentSelKey == data.fruitOrderId){
$scope.testOrderSelectedRow = data;
$$hasSelectPrimaryKey = true;
}
});
if(!$$hasSelectPrimaryKey){
$scope.testOrderSelectedRow = record;
}
}
else{
$scope.testOrderSelectedRow = record;
}
});
angular.element(grid.tbody.rows[0]).attr("active",true);
}else{
}
}
};
//TODO LayoutElementType.GRID gridEditType:G
//<!-- gridEditType="G"
//renderPageLayoutJs2
//自定义JS方法 boName:TestOrder layoutBoName:TestOrder
//generatorBoExportAndImportJs haveOrGenTabPage: page:manage boName:TestOrder
/**generatorSearchColumnDefaultValueJSNew **/
/**
* TODO GLPaaS生成
* 初使值处理
*/
$scope.initQueryDefaultValue = function(){
var param =[
];
if(param.length > 0){
$http.post($config.ctx + '/defaultValue/getDefaultValue',param).success(function(data){
if (data.success != undefined && data.success == true) {
if(data.defaultValueInfos != undefined && data.defaultValueInfos != null){
}
}
});
}
}
/**
* TODO GLPaaS生成
*
*/
$scope.checkDateRang = function(txt,searchFlag){
RuleService._checkDateRang($scope,txt,searchFlag);
}
$scope.initLeftGridWidth = function(){
$timeout(function(){
});
}
/**generatorFormColumnDefaultValueJS **/
/**
* TODO GLPaaS生成
* initDefaultValue
*/
$scope.initDefaultValue = function(){
var defaultParams = [];
$scope.$$defaultValue = {};
if(defaultParams.length > 0){
$http.post($config.ctx + '/defaultValue/getDefaultValue',defaultParams).success(function(data){
if (data.success != undefined && data.success == true) {
if(data.defaultValueInfos != undefined && data.defaultValueInfos != null){
angular.forEach(defaultParams,function(defaultParam,index){
var fieldProperty = defaultParam.field.charAt(0).toLocaleLowerCase()+defaultParam.field.substring(1);
if(defaultParam.ut == '11') {
$scope.$$defaultValue[fieldProperty] = data.defaultValueInfos[defaultParam.field].split(":")[0];
} else {
$scope.$$defaultValue[fieldProperty] = data.defaultValueInfos[defaultParam.field];
}
});
if($scope._pageState) $scope._pageState.resetDataState();
}
}
});
}
};
$scope.defaultValueCallBack = function(){
};
$scope.$$gridDefaultValue = {};
/**
* TODO GLPaaS生成
* boName:TestOrder
*/
$scope.initGridDefaultValue = function(){
var defaultParams =[];
if(defaultParams.length > 0){
$http.post($config.ctx + '/defaultValue/getDefaultValue',defaultParams).success(function(data){
if (data.success != undefined && data.success == true) {
if(data.defaultValueInfos != undefined && data.defaultValueInfos != null){
angular.forEach(defaultParams,function(defaultParam,index){
var fieldProperty = defaultParam.field.charAt(0).toLocaleLowerCase()+defaultParam.field.substring(1);
if(defaultParam.ut == '11') {
$scope.$$gridDefaultValue[fieldProperty] = data.defaultValueInfos[defaultParam.field].split(":")[0];
} else {
$scope.$$gridDefaultValue[fieldProperty] = data.defaultValueInfos[defaultParam.field];
}
});
if($scope._pageState) $scope._pageState.resetDataState();
}
}
});
}
};
//DefaultValue LayoutElementType TOOLBAR
/**
* TODO GLPaaS生成
* 规则中调用或其它按钮调用刷新父窗口中的表格eg:objectName = LinjxBas,eg:LinjxBas2
*/
$scope.refreshParent = function(objectName){
var indexScope = top.angular.element("body").scope();
var objectNames = objectName.split(",");
angular.forEach(objectNames,function(data){
//2 = 弹出框刷新底层窗口
indexScope.refresh($scope.openType,data);
});
};
/**
* TODO GLPaaS生成
* 规则中调用或其它按钮调用刷新父窗口中的所有表格和form表单内容
*/
$scope.refreshUperLayer = function(){
var indexScope = top.angular.element("body").scope();
indexScope.refreshUperLayer($scope.openType);
}
/**
* TODO GLPaaS生成
*
*/
$scope.refreshCurrentPage = function(modelName){
if($scope.__reloadCurentPage){
$scope.__reloadCurentPage(modelName);
}
};
$scope.onBeforeColumnSortEvent = function(grid,col,sortName,sortDirection){
grid.select(0, col);
}
/**
* TODO GLPaaS生成
*
*/
$scope.initAcceptParams = function(){
}
/**
* TODO GLPaaS生成
*
*/
$scope.initialize = function(){
if($scope.initDefaultValue && $scope.__initDefaultValueFlag) $scope.initDefaultValue();
if($scope.initQueryDefaultValue && $scope.__initQueryDefaultValueFlag) $scope.initQueryDefaultValue();
if($scope.initGridDefaultValue && $scope.__initGridDefaultValueFlag)
$scope.initGridDefaultValue();
$scope.openType = Params.openType;
$scope.pageType = "manage";
$scope.workFlowTaskId = Params.workFlowTaskId;
if($scope.workFlowTaskId)
$scope.isEntryProcess = true ;
$scope.testOrder.workFlowTaskId = $scope.workFlowTaskId;
$scope.initAcceptParams && $scope.initAcceptParams();
if ($scope.customTestOrderInit) {
$scope.customTestOrderInit();
}
if($scope._pageState) $scope._pageState.resetDataState();
};
$scope.initialize();
}, BaseController);
var Proto = Controller.prototype;
return Controller;
});
1.4.Ctrl.js
//true boName;TestOrder firstLayoutBoName:
/**
* ###########【本文件为用户二次开发文件，可在次文件添加修改自定义代码或覆盖BsCtrl.js中默认的方法实现，可修改但不能删除.】################
* Author(s):java业务平台代码生成工具
* Date: 2018年07月25日 11点35分24秒
* Copyright Notice:版权声明 厦门吉联科技, 版权所有 违者必究
* @(#)
* Description: businessType:,pageType:manage
* <功能>主对象订单TestOrder(TestOrder)管理页面 controller JS
* 文件名称: testOrderManageCtrl.js
*/
define([
'angular',
'underscore',
$config.path+requireBaseUrl+'/oms/samle/testOrderManageBsCtrl.js', 'service/utils'
], function (angular, _, testOrderManageBsCtrl) {
var Controller = inherit(function (options) {
testOrderManageBsCtrl.call(this, options);
this.scope.customThree = function () {
alert("请配置方法实现");
};
this.scope.controlOneTestSysStBooking = function (aa, bb, cc) {
alert('dfd');
};
},testOrderManageBsCtrl);
var Proto = Controller.prototype;
return Controller;
});
1.5.校验文件
define({
rules: [{
min: 0,
max: 200,
property: "testOrder.country01",
ruleName: "richLength",
message: "RichLength.testOrder.country01"
}, {
min: 0,
max: 200,
property: "testOrder.country02",
ruleName: "richLength",
message: "RichLength.testOrder.country02"
}, {
min: 0,
max: 200,
property: "testOrder.country03",
ruleName: "richLength",
message: "RichLength.testOrder.country03"
}, {
min: 0,
max: 200,
property: "testOrder.country04",
ruleName: "richLength",
message: "RichLength.testOrder.country04"
}, {
min: 0,
max: 100,
property: "testOrder.fruitOrderCode",
ruleName: "richLength",
message: "RichLength.testOrder.fruitOrderCode"
}, {
min: 0,
max: 200,
property: "testOrder.fruitOrderReceiver",
ruleName: "richLength",
message: "RichLength.testOrder.fruitOrderReceiver"
}, {
min: 0,
max: 400,
property: "testOrder.fruitOrderRemark",
ruleName: "richLength",
message: "RichLength.testOrder.fruitOrderRemark"
}, {
min: 0,
max: 200,
property: "testOrder.fruitOrderSenderId",
ruleName: "richLength",
message: "RichLength.testOrder.fruitOrderSenderId"
}, {
min: 0,
max: 200,
property: "testOrder.fruitOrderSenderName",
ruleName: "richLength",
message: "RichLength.testOrder.fruitOrderSenderName"
}, {
min: 0,
max: 200,
property: "testOrder.fruitOrderStatus",
ruleName: "richLength",
message: "RichLength.testOrder.fruitOrderStatus"
}, {
min: 0,
max: 100,
property: "testOrder.fruitOrderTime",
ruleName: "richLength",
message: "RichLength.testOrder.fruitOrderTime"
}, {
min: 0,
max: 50,
property: "testOrder.processState",
ruleName: "richLength",
message: "RichLength.testOrder.processState"
}]
});
1.6.校验提示信息
define({
"root": {
"RichLength.testOrder.country01": "【地区（一级）】长度必须小于等于200",
"RichLength.testOrder.country02": "【地区（二级）】长度必须小于等于200",
"RichLength.testOrder.country03": "【地区（三级）】长度必须小于等于200",
"RichLength.testOrder.country04": "【地区（动态）】长度必须小于等于200",
"RichLength.testOrder.fruitOrderCode": "【订单编号】长度必须小于等于100",
"RichLength.testOrder.fruitOrderReceiver": "【收货人】长度必须小于等于200",
"RichLength.testOrder.fruitOrderRemark": "【备注】长度必须小于等于400",
"RichLength.testOrder.fruitOrderSenderId": "【发货人ID】长度必须小于等于200",
"RichLength.testOrder.fruitOrderSenderName": "【发货人】长度必须小于等于200",
"RichLength.testOrder.fruitOrderStatus": "【订单状态】长度必须小于等于200",
"RichLength.testOrder.fruitOrderTime": "【订单生效时间】长度必须小于等于100",
"RichLength.testOrder.processState": "【流程状态】长度必须小于等于50"
}
});
1.7.实体类
/*
* @(#)TestOrder.java
* 版权声明 厦门吉联科技, 版权所有 违者必究
*
*修订记录:
*1)更改者：java业务平台代码生成工具
* 时 间：2018年07月25日 11点35分23秒
* 描 述：创建
*/
package com.gillion.oms.samle.domain;
import java.util.Set;
import java.util.Map;
import java.util.List;
import javax.validation.Valid;
import javax.persistence.*;
import com.fasterxml.jackson.annotation.JsonIgnore;
import com.fasterxml.jackson.annotation.JsonIgnoreProperties;
import com.fasterxml.jackson.annotation.JsonManagedReference;
import com.fasterxml.jackson.annotation.JsonBackReference;
import com.gillion.platform.framework.core.domain.BaseObject;
import com.gillion.platform.utils.DateUtils;
import com.gillion.platform.serialize.DateTimeString;
import com.gillion.platform.serialize.DateString;
import com.gillion.platform.bo.domain.BusinessObject;
import com.gillion.platform.bo.service.impl.BusinessObjectService;
import com.gillion.platform.framework.component.rtm.domain.DynamicForm;
import java.math.BigDecimal;
import com.gfa4j.validation.annotation.RichLength;
/**
* <pre>
* 订单TestOrder(TestOrder)实体类
* </pre>
*
* <br>
* JDK版本:1.5
*
* @author java业务平台代码生成工具
* @version 1.0
* @see The author for more details
* @since 1.0
*/
@Entity
@Table(name = "FRUIT_ORDER")
//@org.hibernate.annotations.Entity(dynamicInsert=true,dynamicUpdate=true)
@SuppressWarnings("all")
@JsonIgnoreProperties
public class TestOrder extends BaseObject
{
/** The field serialVersionUID **/
private static final long serialVersionUID = 1L;
/** 地区（一级） */
public final static String COUNTRY01 = "COUNTRY01";
/** 地区（二级） */
public final static String COUNTRY02 = "COUNTRY02";
/** 地区（三级） */
public final static String COUNTRY03 = "COUNTRY03";
/** 地区（动态） */
public final static String COUNTRY04 = "COUNTRY04";
/** 创建人所属组织 */
public final static String CREATEOFFICE = "CREATE_OFFICE";
/** 创建人时区 */
public final static String CREATETIMEZONE = "CREATE_TIME_ZONE";
/** 箱数 */
public final static String FRUITBOOKNUM = "FRUIT_BOOKNUM";
/** 毛重 */
public final static String FRUITGROSSWEIGHT = "FRUIT_GROSS_WEIGHT";
/** 订单编号 */
public final static String FRUITORDERCODE = "FRUIT_ORDER_CODE";
/** 订单ID */
public final static String FRUITORDERID = "FRUIT_ORDER_ID";
/** 收货人 */
public final static String FRUITORDERRECEIVER = "FRUIT_ORDER_RECEIVER";
/** 备注 */
public final static String FRUITORDERREMARK = "FRUIT_ORDER_REMARK";
/** 发货人ID */
public final static String FRUITORDERSENDERID = "FRUIT_ORDER_SENDER_ID";
/** 发货人 */
public final static String FRUITORDERSENDERNAME = "FRUIT_ORDER_SENDER_NAME";
/** 订单状态 */
public final static String FRUITORDERSTATUS = "FRUIT_ORDER_STATUS";
/** 订单生效时间 */
public final static String FRUITORDERTIME = "FRUIT_ORDER_TIME";
/** 是否删除 */
public final static String ISDELETED = "IS_DELETED";
/** 最后修改人所属组织 */
public final static String LASTMODIFYOFFICE = "LAST_MODIFY_OFFICE";
/** 最后修改人时区 */
public final static String LASTMODIFYTIMEZONE = "LAST_MODIFY_TIME_ZONE";
/** 云服务分组代码 */
public final static String PRINCIPALGROUPCODE = "PRINCIPAL_GROUP_CODE";
/** 流程状态 */
public final static String PROCESSSTATE = "PROCESS_STATE";
/** The Class Default 默认分组*/
public interface Default{};
//fields
/** 地区（一级） */
@Column(name="COUNTRY01",nullable = true,length=200)
@RichLength(max=200,min=0,groups={Default.class})
private String country01;
/** 地区（二级） */
@Column(name="COUNTRY02",nullable = true,length=200)
@RichLength(max=200,min=0,groups={Default.class})
private String country02;
/** 地区（三级） */
@Column(name="COUNTRY03",nullable = true,length=200)
@RichLength(max=200,min=0,groups={Default.class})
private String country03;
/** 地区（动态） */
@Column(name="COUNTRY04",nullable = true,length=200)
@RichLength(max=200,min=0,groups={Default.class})
private String country04;
/** 箱数 */
@Column(name="FRUIT_BOOKNUM",nullable = true,precision=12,scale=2,length=12)
private BigDecimal fruitBooknum;
/** 毛重 */
@Column(name="FRUIT_GROSS_WEIGHT",nullable = true,precision=16,scale=2,length=16)
private BigDecimal fruitGrossWeight;
/** 订单编号 */
@Column(name="FRUIT_ORDER_CODE",nullable = true,length=100)
@RichLength(max=100,min=0,groups={Default.class})
private String fruitOrderCode;
/** 订单ID */
@Id
@GeneratedValue(generator = "idGenerator")
@Column(name="FRUIT_ORDER_ID",nullable = false,length=100)
private String fruitOrderId;
/** 收货人 */
@Column(name="FRUIT_ORDER_RECEIVER",nullable = true,length=200)
@RichLength(max=200,min=0,groups={Default.class})
private String fruitOrderReceiver;
/** 备注 */
@Column(name="FRUIT_ORDER_REMARK",nullable = true,length=400)
@RichLength(max=400,min=0,groups={Default.class})
private String fruitOrderRemark;
/** 发货人ID */
@Column(name="FRUIT_ORDER_SENDER_ID",nullable = true,length=200)
@RichLength(max=200,min=0,groups={Default.class})
private String fruitOrderSenderId;
/** 发货人 */
@Column(name="FRUIT_ORDER_SENDER_NAME",nullable = true,length=200)
@RichLength(max=200,min=0,groups={Default.class})
private String fruitOrderSenderName;
/** 订单状态 */
@Column(name="FRUIT_ORDER_STATUS",nullable = true,length=200)
@RichLength(max=200,min=0,groups={Default.class})
private String fruitOrderStatus;
/** 订单生效时间 */
@Column(name="FRUIT_ORDER_TIME",nullable = true,length=100)
@RichLength(max=100,min=0,groups={Default.class})
private String fruitOrderTime;
/** 是否删除 */
@Column(name="IS_DELETED",nullable = true,length=1)
private String isDeleted;
/** 流程状态 */
@Column(name="PROCESS_STATE",nullable = true,length=50)
@RichLength(max=50,min=0,groups={Default.class})
private String processState;
/**
* 功能描述:
* 获得地区（一级）
* @return 地区（一级） : String
*/
public String getCountry01()
{
return this.country01;
}
/**
* 功能描述:
* 设置地区（一级）
* @param country01 : String
*/
public void setCountry01(String country01)
{
this.country01 = country01;
}
/**
* 功能描述:
* 获得地区（二级）
* @return 地区（二级） : String
*/
public String getCountry02()
{
return this.country02;
}
/**
* 功能描述:
* 设置地区（二级）
* @param country02 : String
*/
public void setCountry02(String country02)
{
this.country02 = country02;
}
/**
* 功能描述:
* 获得地区（三级）
* @return 地区（三级） : String
*/
public String getCountry03()
{
return this.country03;
}
/**
* 功能描述:
* 设置地区（三级）
* @param country03 : String
*/
public void setCountry03(String country03)
{
this.country03 = country03;
}
/**
* 功能描述:
* 获得地区（动态）
* @return 地区（动态） : String
*/
public String getCountry04()
{
return this.country04;
}
/**
* 功能描述:
* 设置地区（动态）
* @param country04 : String
*/
public void setCountry04(String country04)
{
this.country04 = country04;
}
/**
* 功能描述:
* 获得箱数
* @return 箱数 : BigDecimal
*/
public BigDecimal getFruitBooknum()
{
return this.fruitBooknum;
}
/**
* 功能描述:
* 设置箱数
* @param fruitBooknum : BigDecimal
*/
public void setFruitBooknum(BigDecimal fruitBooknum)
{
this.fruitBooknum = fruitBooknum;
}
/**
* 功能描述:
* 获得毛重
* @return 毛重 : BigDecimal
*/
public BigDecimal getFruitGrossWeight()
{
return this.fruitGrossWeight;
}
/**
* 功能描述:
* 设置毛重
* @param fruitGrossWeight : BigDecimal
*/
public void setFruitGrossWeight(BigDecimal fruitGrossWeight)
{
this.fruitGrossWeight = fruitGrossWeight;
}
/**
* 功能描述:
* 获得订单编号
* @return 订单编号 : String
*/
public String getFruitOrderCode()
{
return this.fruitOrderCode;
}
/**
* 功能描述:
* 设置订单编号
* @param fruitOrderCode : String
*/
public void setFruitOrderCode(String fruitOrderCode)
{
this.fruitOrderCode = fruitOrderCode;
}
/**
* 功能描述:
* 获得订单ID
* @return 订单ID : String
*/
public String getFruitOrderId()
{
return this.fruitOrderId;
}
/**
* 功能描述:
* 设置订单ID
* @param fruitOrderId : String
*/
public void setFruitOrderId(String fruitOrderId)
{
this.fruitOrderId = fruitOrderId;
}
/**
* 功能描述:
* 获得收货人
* @return 收货人 : String
*/
public String getFruitOrderReceiver()
{
return this.fruitOrderReceiver;
}
/**
* 功能描述:
* 设置收货人
* @param fruitOrderReceiver : String
*/
public void setFruitOrderReceiver(String fruitOrderReceiver)
{
this.fruitOrderReceiver = fruitOrderReceiver;
}
/**
* 功能描述:
* 获得备注
* @return 备注 : String
*/
public String getFruitOrderRemark()
{
return this.fruitOrderRemark;
}
/**
* 功能描述:
* 设置备注
* @param fruitOrderRemark : String
*/
public void setFruitOrderRemark(String fruitOrderRemark)
{
this.fruitOrderRemark = fruitOrderRemark;
}
/**
* 功能描述:
* 获得发货人ID
* @return 发货人ID : String
*/
public String getFruitOrderSenderId()
{
return this.fruitOrderSenderId;
}
/**
* 功能描述:
* 设置发货人ID
* @param fruitOrderSenderId : String
*/
public void setFruitOrderSenderId(String fruitOrderSenderId)
{
this.fruitOrderSenderId = fruitOrderSenderId;
}
/**
* 功能描述:
* 获得发货人
* @return 发货人 : String
*/
public String getFruitOrderSenderName()
{
return this.fruitOrderSenderName;
}
/**
* 功能描述:
* 设置发货人
* @param fruitOrderSenderName : String
*/
public void setFruitOrderSenderName(String fruitOrderSenderName)
{
this.fruitOrderSenderName = fruitOrderSenderName;
}
/**
* 功能描述:
* 获得订单状态
* @return 订单状态 : String
*/
public String getFruitOrderStatus()
{
return this.fruitOrderStatus;
}
/**
* 功能描述:
* 设置订单状态
* @param fruitOrderStatus : String
*/
public void setFruitOrderStatus(String fruitOrderStatus)
{
this.fruitOrderStatus = fruitOrderStatus;
}
/**
* 功能描述:
* 获得订单生效时间
* @return 订单生效时间 : String
*/
public String getFruitOrderTime()
{
return this.fruitOrderTime;
}
/**
* 功能描述:
* 设置订单生效时间
* @param fruitOrderTime : String
*/
public void setFruitOrderTime(String fruitOrderTime)
{
this.fruitOrderTime = fruitOrderTime;
}
/**
* 功能描述:
* 获得是否删除
* @return 是否删除 : String
*/
public String getIsDeleted()
{
return this.isDeleted;
}
/**
* 功能描述:
* 设置是否删除
* @param isDeleted : String
*/
public void setIsDeleted(String isDeleted)
{
this.isDeleted = isDeleted;
}
/**
* 功能描述:
* 获得流程状态
* @return 流程状态 : String
*/
public String getProcessState()
{
return this.processState;
}
/**
* 功能描述:
* 设置流程状态
* @param processState : String
*/
public void setProcessState(String processState)
{
this.processState = processState;
}
}
1.8.Example类
/*
* @(#)TestOrderExample.java
* 版权声明 厦门吉联科技, 版权所有 违者必究
*
*修订记录:
*1)更改者：java业务平台代码生成工具
* 时 间：2018年07月25日 11点35分23秒
* 描 述：创建
*/
package com.gillion.oms.samle.domain;
import com.gillion.platform.framework.core.query.BaseCriteria;
import com.gillion.platform.framework.core.query.BaseExample;
import com.gillion.platform.framework.core.query.SearchColumn;
import com.gillion.platform.framework.core.query.Operation;
import java.util.List;
import java.util.Map;
import java.math.BigDecimal;
import java.util.Date;
/**
* <pre>
* 订单TestOrder(TestOrder)Example类
* </pre>
*
* <br>
* JDK版本:1.6
*
* @author java业务平台代码生成工具
* @version 1.0
* @see The author for more details
*/
public class TestOrderExample extends BaseExample<TestOrderExample.Criteria>
{
public TestOrderExample()
{
super();
}
/**
* @param criteria
*/
public void or(Criteria criteria)
{
oredCriteria.add(criteria);
}
/**
* @return
*/
protected Criteria createCriteriaInternal()
{
return new Criteria(mapColumns);
}
/**
* create new instance TestOrderExample
* @return
*/
public static TestOrderExample create()
{
return new TestOrderExample();
}
/**
* create new instance IpfCcmBoExample
* @param searchColumns
* @return IpfCcmBoExample
*/
public static TestOrderExample create(List<SearchColumn> searchColumns)
{
TestOrderExample example = TestOrderExample.create();
example.init(searchColumns);
return example;
}
/**
* <pre>
* The Class GeneratedCriteria
* </pre>
*
* <br>
* JDK版本:1.6
*
* @author 林进旭
* @version 1.0
* @see The author for more details
* @since 1.0
*/
public static class Criteria extends BaseCriteria
{
protected Criteria()
{
super();
}
protected Criteria(Map<String,String> columnMaps)
{
super(columnMaps);
}
/**
* FRUIT_ORDER_STATUS is null
* @return
*/
public Criteria andFruitOrderStatusIsNull()
{
addCriterion("FRUIT_ORDER_STATUS",false,Operation.ISNULL,new Object[] {});
return (Criteria) this;
}
/**
* FRUIT_ORDER_STATUS is not null
* @return
*/
public Criteria andFruitOrderStatusIsNotNull()
{
addCriterion("FRUIT_ORDER_STATUS",false,Operation.ISNOTNULL,new Object[] {});
return (Criteria) this;
}
/**
* FRUIT_ORDER_STATUS =
* @return
*/
public Criteria andFruitOrderStatusEqualTo(String value)
{
addCriterion("FRUIT_ORDER_STATUS",false,Operation.EQ,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_STATUS <>
* @return
*/
public Criteria andFruitOrderStatusNotEqualTo(String value)
{
addCriterion("FRUIT_ORDER_STATUS",false,Operation.NOTEQ,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_STATUS >
* @return
*/
public Criteria andFruitOrderStatusGreaterThan(String value)
{
addCriterion("FRUIT_ORDER_STATUS",false,Operation.GT,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_STATUS >=
* @return
*/
public Criteria andFruitOrderStatusGreaterThanOrEqualTo(String value)
{
addCriterion("FRUIT_ORDER_STATUS",false,Operation.GE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_STATUS <
* @return
*/
public Criteria andFruitOrderStatusLessThan(String value)
{
addCriterion("FRUIT_ORDER_STATUS",false,Operation.LT,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_STATUS <=
* @return
*/
public Criteria andFruitOrderStatusLessThanOrEqualTo(String value)
{
addCriterion("FRUIT_ORDER_STATUS",false,Operation.LE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_STATUS like
* @return
*/
public Criteria andFruitOrderStatusLike(String value)
{
addCriterion("FRUIT_ORDER_STATUS",false,Operation.LIKE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_STATUS not like
* @return
*/
public Criteria andFruitOrderStatusNotLike(String value)
{
addCriterion("FRUIT_ORDER_STATUS",false,Operation.NOTLIKE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_STATUS in
* @return
*/
public Criteria andFruitOrderStatusIn(List<String> values)
{
addCriterion("FRUIT_ORDER_STATUS",false,Operation.IN,values);
return (Criteria) this;
}
/**
* FRUIT_ORDER_STATUS not in
* @return
*/
public Criteria andFruitOrderStatusNotIn(List<String> values)
{
addCriterion("FRUIT_ORDER_STATUS",false,Operation.NOTIN,values);
return (Criteria) this;
}
/**
* FRUIT_ORDER_STATUS between
* @return
*/
public Criteria andFruitOrderStatusBetween(String value1, String value2)
{
addCriterion("FRUIT_ORDER_STATUS",false,Operation.BETWEEN,value1,value2);
return (Criteria) this;
}
/**
* FRUIT_ORDER_STATUS not between
* @return
*/
public Criteria andFruitOrderStatusNotBetween(String value1, String value2)
{
addCriterion("FRUIT_ORDER_STATUS",false,Operation.NOTBETWEEN,value1,value2);
return (Criteria) this;
}
/**
* upper(FRUIT_ORDER_STATUS) like '%value.toUpperCase()%'
* @return
*/
public Criteria andFruitOrderStatusLikeInsensitive(String value)
{
addCriterion("FRUIT_ORDER_STATUS",false,Operation.LIKEIC,new Object[] {value});
return (Criteria) this;
}
/**
* CREATE_TIME_ZONE is null
* @return
*/
public Criteria andCreateTimeZoneIsNull()
{
addCriterion("CREATE_TIME_ZONE",false,Operation.ISNULL,new Object[] {});
return (Criteria) this;
}
/**
* CREATE_TIME_ZONE is not null
* @return
*/
public Criteria andCreateTimeZoneIsNotNull()
{
addCriterion("CREATE_TIME_ZONE",false,Operation.ISNOTNULL,new Object[] {});
return (Criteria) this;
}
/**
* CREATE_TIME_ZONE =
* @return
*/
public Criteria andCreateTimeZoneEqualTo(String value)
{
addCriterion("CREATE_TIME_ZONE",false,Operation.EQ,new Object[] {value});
return (Criteria) this;
}
/**
* CREATE_TIME_ZONE <>
* @return
*/
public Criteria andCreateTimeZoneNotEqualTo(String value)
{
addCriterion("CREATE_TIME_ZONE",false,Operation.NOTEQ,new Object[] {value});
return (Criteria) this;
}
/**
* CREATE_TIME_ZONE >
* @return
*/
public Criteria andCreateTimeZoneGreaterThan(String value)
{
addCriterion("CREATE_TIME_ZONE",false,Operation.GT,new Object[] {value});
return (Criteria) this;
}
/**
* CREATE_TIME_ZONE >=
* @return
*/
public Criteria andCreateTimeZoneGreaterThanOrEqualTo(String value)
{
addCriterion("CREATE_TIME_ZONE",false,Operation.GE,new Object[] {value});
return (Criteria) this;
}
/**
* CREATE_TIME_ZONE <
* @return
*/
public Criteria andCreateTimeZoneLessThan(String value)
{
addCriterion("CREATE_TIME_ZONE",false,Operation.LT,new Object[] {value});
return (Criteria) this;
}
/**
* CREATE_TIME_ZONE <=
* @return
*/
public Criteria andCreateTimeZoneLessThanOrEqualTo(String value)
{
addCriterion("CREATE_TIME_ZONE",false,Operation.LE,new Object[] {value});
return (Criteria) this;
}
/**
* CREATE_TIME_ZONE like
* @return
*/
public Criteria andCreateTimeZoneLike(String value)
{
addCriterion("CREATE_TIME_ZONE",false,Operation.LIKE,new Object[] {value});
return (Criteria) this;
}
/**
* CREATE_TIME_ZONE not like
* @return
*/
public Criteria andCreateTimeZoneNotLike(String value)
{
addCriterion("CREATE_TIME_ZONE",false,Operation.NOTLIKE,new Object[] {value});
return (Criteria) this;
}
/**
* CREATE_TIME_ZONE in
* @return
*/
public Criteria andCreateTimeZoneIn(List<String> values)
{
addCriterion("CREATE_TIME_ZONE",false,Operation.IN,values);
return (Criteria) this;
}
/**
* CREATE_TIME_ZONE not in
* @return
*/
public Criteria andCreateTimeZoneNotIn(List<String> values)
{
addCriterion("CREATE_TIME_ZONE",false,Operation.NOTIN,values);
return (Criteria) this;
}
/**
* CREATE_TIME_ZONE between
* @return
*/
public Criteria andCreateTimeZoneBetween(String value1, String value2)
{
addCriterion("CREATE_TIME_ZONE",false,Operation.BETWEEN,value1,value2);
return (Criteria) this;
}
/**
* CREATE_TIME_ZONE not between
* @return
*/
public Criteria andCreateTimeZoneNotBetween(String value1, String value2)
{
addCriterion("CREATE_TIME_ZONE",false,Operation.NOTBETWEEN,value1,value2);
return (Criteria) this;
}
/**
* upper(CREATE_TIME_ZONE) like '%value.toUpperCase()%'
* @return
*/
public Criteria andCreateTimeZoneLikeInsensitive(String value)
{
addCriterion("CREATE_TIME_ZONE",false,Operation.LIKEIC,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFY_TIME_ZONE is null
* @return
*/
public Criteria andLastModifyTimeZoneIsNull()
{
addCriterion("LAST_MODIFY_TIME_ZONE",false,Operation.ISNULL,new Object[] {});
return (Criteria) this;
}
/**
* LAST_MODIFY_TIME_ZONE is not null
* @return
*/
public Criteria andLastModifyTimeZoneIsNotNull()
{
addCriterion("LAST_MODIFY_TIME_ZONE",false,Operation.ISNOTNULL,new Object[] {});
return (Criteria) this;
}
/**
* LAST_MODIFY_TIME_ZONE =
* @return
*/
public Criteria andLastModifyTimeZoneEqualTo(String value)
{
addCriterion("LAST_MODIFY_TIME_ZONE",false,Operation.EQ,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFY_TIME_ZONE <>
* @return
*/
public Criteria andLastModifyTimeZoneNotEqualTo(String value)
{
addCriterion("LAST_MODIFY_TIME_ZONE",false,Operation.NOTEQ,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFY_TIME_ZONE >
* @return
*/
public Criteria andLastModifyTimeZoneGreaterThan(String value)
{
addCriterion("LAST_MODIFY_TIME_ZONE",false,Operation.GT,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFY_TIME_ZONE >=
* @return
*/
public Criteria andLastModifyTimeZoneGreaterThanOrEqualTo(String value)
{
addCriterion("LAST_MODIFY_TIME_ZONE",false,Operation.GE,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFY_TIME_ZONE <
* @return
*/
public Criteria andLastModifyTimeZoneLessThan(String value)
{
addCriterion("LAST_MODIFY_TIME_ZONE",false,Operation.LT,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFY_TIME_ZONE <=
* @return
*/
public Criteria andLastModifyTimeZoneLessThanOrEqualTo(String value)
{
addCriterion("LAST_MODIFY_TIME_ZONE",false,Operation.LE,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFY_TIME_ZONE like
* @return
*/
public Criteria andLastModifyTimeZoneLike(String value)
{
addCriterion("LAST_MODIFY_TIME_ZONE",false,Operation.LIKE,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFY_TIME_ZONE not like
* @return
*/
public Criteria andLastModifyTimeZoneNotLike(String value)
{
addCriterion("LAST_MODIFY_TIME_ZONE",false,Operation.NOTLIKE,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFY_TIME_ZONE in
* @return
*/
public Criteria andLastModifyTimeZoneIn(List<String> values)
{
addCriterion("LAST_MODIFY_TIME_ZONE",false,Operation.IN,values);
return (Criteria) this;
}
/**
* LAST_MODIFY_TIME_ZONE not in
* @return
*/
public Criteria andLastModifyTimeZoneNotIn(List<String> values)
{
addCriterion("LAST_MODIFY_TIME_ZONE",false,Operation.NOTIN,values);
return (Criteria) this;
}
/**
* LAST_MODIFY_TIME_ZONE between
* @return
*/
public Criteria andLastModifyTimeZoneBetween(String value1, String value2)
{
addCriterion("LAST_MODIFY_TIME_ZONE",false,Operation.BETWEEN,value1,value2);
return (Criteria) this;
}
/**
* LAST_MODIFY_TIME_ZONE not between
* @return
*/
public Criteria andLastModifyTimeZoneNotBetween(String value1, String value2)
{
addCriterion("LAST_MODIFY_TIME_ZONE",false,Operation.NOTBETWEEN,value1,value2);
return (Criteria) this;
}
/**
* upper(LAST_MODIFY_TIME_ZONE) like '%value.toUpperCase()%'
* @return
*/
public Criteria andLastModifyTimeZoneLikeInsensitive(String value)
{
addCriterion("LAST_MODIFY_TIME_ZONE",false,Operation.LIKEIC,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY01 is null
* @return
*/
public Criteria andCountry01IsNull()
{
addCriterion("COUNTRY01",false,Operation.ISNULL,new Object[] {});
return (Criteria) this;
}
/**
* COUNTRY01 is not null
* @return
*/
public Criteria andCountry01IsNotNull()
{
addCriterion("COUNTRY01",false,Operation.ISNOTNULL,new Object[] {});
return (Criteria) this;
}
/**
* COUNTRY01 =
* @return
*/
public Criteria andCountry01EqualTo(String value)
{
addCriterion("COUNTRY01",false,Operation.EQ,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY01 <>
* @return
*/
public Criteria andCountry01NotEqualTo(String value)
{
addCriterion("COUNTRY01",false,Operation.NOTEQ,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY01 >
* @return
*/
public Criteria andCountry01GreaterThan(String value)
{
addCriterion("COUNTRY01",false,Operation.GT,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY01 >=
* @return
*/
public Criteria andCountry01GreaterThanOrEqualTo(String value)
{
addCriterion("COUNTRY01",false,Operation.GE,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY01 <
* @return
*/
public Criteria andCountry01LessThan(String value)
{
addCriterion("COUNTRY01",false,Operation.LT,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY01 <=
* @return
*/
public Criteria andCountry01LessThanOrEqualTo(String value)
{
addCriterion("COUNTRY01",false,Operation.LE,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY01 like
* @return
*/
public Criteria andCountry01Like(String value)
{
addCriterion("COUNTRY01",false,Operation.LIKE,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY01 not like
* @return
*/
public Criteria andCountry01NotLike(String value)
{
addCriterion("COUNTRY01",false,Operation.NOTLIKE,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY01 in
* @return
*/
public Criteria andCountry01In(List<String> values)
{
addCriterion("COUNTRY01",false,Operation.IN,values);
return (Criteria) this;
}
/**
* COUNTRY01 not in
* @return
*/
public Criteria andCountry01NotIn(List<String> values)
{
addCriterion("COUNTRY01",false,Operation.NOTIN,values);
return (Criteria) this;
}
/**
* COUNTRY01 between
* @return
*/
public Criteria andCountry01Between(String value1, String value2)
{
addCriterion("COUNTRY01",false,Operation.BETWEEN,value1,value2);
return (Criteria) this;
}
/**
* COUNTRY01 not between
* @return
*/
public Criteria andCountry01NotBetween(String value1, String value2)
{
addCriterion("COUNTRY01",false,Operation.NOTBETWEEN,value1,value2);
return (Criteria) this;
}
/**
* upper(COUNTRY01) like '%value.toUpperCase()%'
* @return
*/
public Criteria andCountry01LikeInsensitive(String value)
{
addCriterion("COUNTRY01",false,Operation.LIKEIC,new Object[] {value});
return (Criteria) this;
}
/**
* IS_DELETED is null
* @return
*/
public Criteria andIsDeletedIsNull()
{
addCriterion("IS_DELETED",false,Operation.ISNULL,new Object[] {});
return (Criteria) this;
}
/**
* IS_DELETED is not null
* @return
*/
public Criteria andIsDeletedIsNotNull()
{
addCriterion("IS_DELETED",false,Operation.ISNOTNULL,new Object[] {});
return (Criteria) this;
}
/**
* IS_DELETED =
* @return
*/
public Criteria andIsDeletedEqualTo(String value)
{
addCriterion("IS_DELETED",false,Operation.EQ,new Object[] {value});
return (Criteria) this;
}
/**
* IS_DELETED <>
* @return
*/
public Criteria andIsDeletedNotEqualTo(String value)
{
addCriterion("IS_DELETED",false,Operation.NOTEQ,new Object[] {value});
return (Criteria) this;
}
/**
* IS_DELETED >
* @return
*/
public Criteria andIsDeletedGreaterThan(String value)
{
addCriterion("IS_DELETED",false,Operation.GT,new Object[] {value});
return (Criteria) this;
}
/**
* IS_DELETED >=
* @return
*/
public Criteria andIsDeletedGreaterThanOrEqualTo(String value)
{
addCriterion("IS_DELETED",false,Operation.GE,new Object[] {value});
return (Criteria) this;
}
/**
* IS_DELETED <
* @return
*/
public Criteria andIsDeletedLessThan(String value)
{
addCriterion("IS_DELETED",false,Operation.LT,new Object[] {value});
return (Criteria) this;
}
/**
* IS_DELETED <=
* @return
*/
public Criteria andIsDeletedLessThanOrEqualTo(String value)
{
addCriterion("IS_DELETED",false,Operation.LE,new Object[] {value});
return (Criteria) this;
}
/**
* IS_DELETED like
* @return
*/
public Criteria andIsDeletedLike(String value)
{
addCriterion("IS_DELETED",false,Operation.LIKE,new Object[] {value});
return (Criteria) this;
}
/**
* IS_DELETED not like
* @return
*/
public Criteria andIsDeletedNotLike(String value)
{
addCriterion("IS_DELETED",false,Operation.NOTLIKE,new Object[] {value});
return (Criteria) this;
}
/**
* IS_DELETED in
* @return
*/
public Criteria andIsDeletedIn(List<String> values)
{
addCriterion("IS_DELETED",false,Operation.IN,values);
return (Criteria) this;
}
/**
* IS_DELETED not in
* @return
*/
public Criteria andIsDeletedNotIn(List<String> values)
{
addCriterion("IS_DELETED",false,Operation.NOTIN,values);
return (Criteria) this;
}
/**
* IS_DELETED between
* @return
*/
public Criteria andIsDeletedBetween(String value1, String value2)
{
addCriterion("IS_DELETED",false,Operation.BETWEEN,value1,value2);
return (Criteria) this;
}
/**
* IS_DELETED not between
* @return
*/
public Criteria andIsDeletedNotBetween(String value1, String value2)
{
addCriterion("IS_DELETED",false,Operation.NOTBETWEEN,value1,value2);
return (Criteria) this;
}
/**
* upper(IS_DELETED) like '%value.toUpperCase()%'
* @return
*/
public Criteria andIsDeletedLikeInsensitive(String value)
{
addCriterion("IS_DELETED",false,Operation.LIKEIC,new Object[] {value});
return (Criteria) this;
}
/**
* CREATE_OFFICE is null
* @return
*/
public Criteria andCreateOfficeIsNull()
{
addCriterion("CREATE_OFFICE",false,Operation.ISNULL,new Object[] {});
return (Criteria) this;
}
/**
* CREATE_OFFICE is not null
* @return
*/
public Criteria andCreateOfficeIsNotNull()
{
addCriterion("CREATE_OFFICE",false,Operation.ISNOTNULL,new Object[] {});
return (Criteria) this;
}
/**
* CREATE_OFFICE =
* @return
*/
public Criteria andCreateOfficeEqualTo(String value)
{
addCriterion("CREATE_OFFICE",false,Operation.EQ,new Object[] {value});
return (Criteria) this;
}
/**
* CREATE_OFFICE <>
* @return
*/
public Criteria andCreateOfficeNotEqualTo(String value)
{
addCriterion("CREATE_OFFICE",false,Operation.NOTEQ,new Object[] {value});
return (Criteria) this;
}
/**
* CREATE_OFFICE >
* @return
*/
public Criteria andCreateOfficeGreaterThan(String value)
{
addCriterion("CREATE_OFFICE",false,Operation.GT,new Object[] {value});
return (Criteria) this;
}
/**
* CREATE_OFFICE >=
* @return
*/
public Criteria andCreateOfficeGreaterThanOrEqualTo(String value)
{
addCriterion("CREATE_OFFICE",false,Operation.GE,new Object[] {value});
return (Criteria) this;
}
/**
* CREATE_OFFICE <
* @return
*/
public Criteria andCreateOfficeLessThan(String value)
{
addCriterion("CREATE_OFFICE",false,Operation.LT,new Object[] {value});
return (Criteria) this;
}
/**
* CREATE_OFFICE <=
* @return
*/
public Criteria andCreateOfficeLessThanOrEqualTo(String value)
{
addCriterion("CREATE_OFFICE",false,Operation.LE,new Object[] {value});
return (Criteria) this;
}
/**
* CREATE_OFFICE like
* @return
*/
public Criteria andCreateOfficeLike(String value)
{
addCriterion("CREATE_OFFICE",false,Operation.LIKE,new Object[] {value});
return (Criteria) this;
}
/**
* CREATE_OFFICE not like
* @return
*/
public Criteria andCreateOfficeNotLike(String value)
{
addCriterion("CREATE_OFFICE",false,Operation.NOTLIKE,new Object[] {value});
return (Criteria) this;
}
/**
* CREATE_OFFICE in
* @return
*/
public Criteria andCreateOfficeIn(List<String> values)
{
addCriterion("CREATE_OFFICE",false,Operation.IN,values);
return (Criteria) this;
}
/**
* CREATE_OFFICE not in
* @return
*/
public Criteria andCreateOfficeNotIn(List<String> values)
{
addCriterion("CREATE_OFFICE",false,Operation.NOTIN,values);
return (Criteria) this;
}
/**
* CREATE_OFFICE between
* @return
*/
public Criteria andCreateOfficeBetween(String value1, String value2)
{
addCriterion("CREATE_OFFICE",false,Operation.BETWEEN,value1,value2);
return (Criteria) this;
}
/**
* CREATE_OFFICE not between
* @return
*/
public Criteria andCreateOfficeNotBetween(String value1, String value2)
{
addCriterion("CREATE_OFFICE",false,Operation.NOTBETWEEN,value1,value2);
return (Criteria) this;
}
/**
* upper(CREATE_OFFICE) like '%value.toUpperCase()%'
* @return
*/
public Criteria andCreateOfficeLikeInsensitive(String value)
{
addCriterion("CREATE_OFFICE",false,Operation.LIKEIC,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFY_TIME is null
* @return
*/
public Criteria andLastModifyTimeIsNull()
{
addCriterion("LAST_MODIFY_TIME",false,Operation.ISNULL,new Object[] {});
return (Criteria) this;
}
/**
* LAST_MODIFY_TIME is not null
* @return
*/
public Criteria andLastModifyTimeIsNotNull()
{
addCriterion("LAST_MODIFY_TIME",false,Operation.ISNOTNULL,new Object[] {});
return (Criteria) this;
}
/**
* LAST_MODIFY_TIME =
* @return
*/
public Criteria andLastModifyTimeEqualTo(String value)
{
addCriterion("LAST_MODIFY_TIME",false,Operation.EQ,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFY_TIME <>
* @return
*/
public Criteria andLastModifyTimeNotEqualTo(String value)
{
addCriterion("LAST_MODIFY_TIME",false,Operation.NOTEQ,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFY_TIME >
* @return
*/
public Criteria andLastModifyTimeGreaterThan(String value)
{
addCriterion("LAST_MODIFY_TIME",false,Operation.GT,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFY_TIME >=
* @return
*/
public Criteria andLastModifyTimeGreaterThanOrEqualTo(String value)
{
addCriterion("LAST_MODIFY_TIME",false,Operation.GE,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFY_TIME <
* @return
*/
public Criteria andLastModifyTimeLessThan(String value)
{
addCriterion("LAST_MODIFY_TIME",false,Operation.LT,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFY_TIME <=
* @return
*/
public Criteria andLastModifyTimeLessThanOrEqualTo(String value)
{
addCriterion("LAST_MODIFY_TIME",false,Operation.LE,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFY_TIME like
* @return
*/
public Criteria andLastModifyTimeLike(String value)
{
addCriterion("LAST_MODIFY_TIME",false,Operation.LIKE,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFY_TIME not like
* @return
*/
public Criteria andLastModifyTimeNotLike(String value)
{
addCriterion("LAST_MODIFY_TIME",false,Operation.NOTLIKE,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFY_TIME in
* @return
*/
public Criteria andLastModifyTimeIn(List<String> values)
{
addCriterion("LAST_MODIFY_TIME",false,Operation.IN,values);
return (Criteria) this;
}
/**
* LAST_MODIFY_TIME not in
* @return
*/
public Criteria andLastModifyTimeNotIn(List<String> values)
{
addCriterion("LAST_MODIFY_TIME",false,Operation.NOTIN,values);
return (Criteria) this;
}
/**
* LAST_MODIFY_TIME between
* @return
*/
public Criteria andLastModifyTimeBetween(String value1, String value2)
{
addCriterion("LAST_MODIFY_TIME",false,Operation.BETWEEN,value1,value2);
return (Criteria) this;
}
/**
* LAST_MODIFY_TIME not between
* @return
*/
public Criteria andLastModifyTimeNotBetween(String value1, String value2)
{
addCriterion("LAST_MODIFY_TIME",false,Operation.NOTBETWEEN,value1,value2);
return (Criteria) this;
}
/**
* upper(LAST_MODIFY_TIME) like '%value.toUpperCase()%'
* @return
*/
public Criteria andLastModifyTimeLikeInsensitive(String value)
{
addCriterion("LAST_MODIFY_TIME",false,Operation.LIKEIC,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFY_OFFICE is null
* @return
*/
public Criteria andLastModifyOfficeIsNull()
{
addCriterion("LAST_MODIFY_OFFICE",false,Operation.ISNULL,new Object[] {});
return (Criteria) this;
}
/**
* LAST_MODIFY_OFFICE is not null
* @return
*/
public Criteria andLastModifyOfficeIsNotNull()
{
addCriterion("LAST_MODIFY_OFFICE",false,Operation.ISNOTNULL,new Object[] {});
return (Criteria) this;
}
/**
* LAST_MODIFY_OFFICE =
* @return
*/
public Criteria andLastModifyOfficeEqualTo(String value)
{
addCriterion("LAST_MODIFY_OFFICE",false,Operation.EQ,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFY_OFFICE <>
* @return
*/
public Criteria andLastModifyOfficeNotEqualTo(String value)
{
addCriterion("LAST_MODIFY_OFFICE",false,Operation.NOTEQ,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFY_OFFICE >
* @return
*/
public Criteria andLastModifyOfficeGreaterThan(String value)
{
addCriterion("LAST_MODIFY_OFFICE",false,Operation.GT,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFY_OFFICE >=
* @return
*/
public Criteria andLastModifyOfficeGreaterThanOrEqualTo(String value)
{
addCriterion("LAST_MODIFY_OFFICE",false,Operation.GE,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFY_OFFICE <
* @return
*/
public Criteria andLastModifyOfficeLessThan(String value)
{
addCriterion("LAST_MODIFY_OFFICE",false,Operation.LT,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFY_OFFICE <=
* @return
*/
public Criteria andLastModifyOfficeLessThanOrEqualTo(String value)
{
addCriterion("LAST_MODIFY_OFFICE",false,Operation.LE,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFY_OFFICE like
* @return
*/
public Criteria andLastModifyOfficeLike(String value)
{
addCriterion("LAST_MODIFY_OFFICE",false,Operation.LIKE,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFY_OFFICE not like
* @return
*/
public Criteria andLastModifyOfficeNotLike(String value)
{
addCriterion("LAST_MODIFY_OFFICE",false,Operation.NOTLIKE,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFY_OFFICE in
* @return
*/
public Criteria andLastModifyOfficeIn(List<String> values)
{
addCriterion("LAST_MODIFY_OFFICE",false,Operation.IN,values);
return (Criteria) this;
}
/**
* LAST_MODIFY_OFFICE not in
* @return
*/
public Criteria andLastModifyOfficeNotIn(List<String> values)
{
addCriterion("LAST_MODIFY_OFFICE",false,Operation.NOTIN,values);
return (Criteria) this;
}
/**
* LAST_MODIFY_OFFICE between
* @return
*/
public Criteria andLastModifyOfficeBetween(String value1, String value2)
{
addCriterion("LAST_MODIFY_OFFICE",false,Operation.BETWEEN,value1,value2);
return (Criteria) this;
}
/**
* LAST_MODIFY_OFFICE not between
* @return
*/
public Criteria andLastModifyOfficeNotBetween(String value1, String value2)
{
addCriterion("LAST_MODIFY_OFFICE",false,Operation.NOTBETWEEN,value1,value2);
return (Criteria) this;
}
/**
* upper(LAST_MODIFY_OFFICE) like '%value.toUpperCase()%'
* @return
*/
public Criteria andLastModifyOfficeLikeInsensitive(String value)
{
addCriterion("LAST_MODIFY_OFFICE",false,Operation.LIKEIC,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFYOR is null
* @return
*/
public Criteria andLastModifyorIsNull()
{
addCriterion("LAST_MODIFYOR",false,Operation.ISNULL,new Object[] {});
return (Criteria) this;
}
/**
* LAST_MODIFYOR is not null
* @return
*/
public Criteria andLastModifyorIsNotNull()
{
addCriterion("LAST_MODIFYOR",false,Operation.ISNOTNULL,new Object[] {});
return (Criteria) this;
}
/**
* LAST_MODIFYOR =
* @return
*/
public Criteria andLastModifyorEqualTo(String value)
{
addCriterion("LAST_MODIFYOR",false,Operation.EQ,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFYOR <>
* @return
*/
public Criteria andLastModifyorNotEqualTo(String value)
{
addCriterion("LAST_MODIFYOR",false,Operation.NOTEQ,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFYOR >
* @return
*/
public Criteria andLastModifyorGreaterThan(String value)
{
addCriterion("LAST_MODIFYOR",false,Operation.GT,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFYOR >=
* @return
*/
public Criteria andLastModifyorGreaterThanOrEqualTo(String value)
{
addCriterion("LAST_MODIFYOR",false,Operation.GE,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFYOR <
* @return
*/
public Criteria andLastModifyorLessThan(String value)
{
addCriterion("LAST_MODIFYOR",false,Operation.LT,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFYOR <=
* @return
*/
public Criteria andLastModifyorLessThanOrEqualTo(String value)
{
addCriterion("LAST_MODIFYOR",false,Operation.LE,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFYOR like
* @return
*/
public Criteria andLastModifyorLike(String value)
{
addCriterion("LAST_MODIFYOR",false,Operation.LIKE,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFYOR not like
* @return
*/
public Criteria andLastModifyorNotLike(String value)
{
addCriterion("LAST_MODIFYOR",false,Operation.NOTLIKE,new Object[] {value});
return (Criteria) this;
}
/**
* LAST_MODIFYOR in
* @return
*/
public Criteria andLastModifyorIn(List<String> values)
{
addCriterion("LAST_MODIFYOR",false,Operation.IN,values);
return (Criteria) this;
}
/**
* LAST_MODIFYOR not in
* @return
*/
public Criteria andLastModifyorNotIn(List<String> values)
{
addCriterion("LAST_MODIFYOR",false,Operation.NOTIN,values);
return (Criteria) this;
}
/**
* LAST_MODIFYOR between
* @return
*/
public Criteria andLastModifyorBetween(String value1, String value2)
{
addCriterion("LAST_MODIFYOR",false,Operation.BETWEEN,value1,value2);
return (Criteria) this;
}
/**
* LAST_MODIFYOR not between
* @return
*/
public Criteria andLastModifyorNotBetween(String value1, String value2)
{
addCriterion("LAST_MODIFYOR",false,Operation.NOTBETWEEN,value1,value2);
return (Criteria) this;
}
/**
* upper(LAST_MODIFYOR) like '%value.toUpperCase()%'
* @return
*/
public Criteria andLastModifyorLikeInsensitive(String value)
{
addCriterion("LAST_MODIFYOR",false,Operation.LIKEIC,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_SENDER_ID is null
* @return
*/
public Criteria andFruitOrderSenderIdIsNull()
{
addCriterion("FRUIT_ORDER_SENDER_ID",false,Operation.ISNULL,new Object[] {});
return (Criteria) this;
}
/**
* FRUIT_ORDER_SENDER_ID is not null
* @return
*/
public Criteria andFruitOrderSenderIdIsNotNull()
{
addCriterion("FRUIT_ORDER_SENDER_ID",false,Operation.ISNOTNULL,new Object[] {});
return (Criteria) this;
}
/**
* FRUIT_ORDER_SENDER_ID =
* @return
*/
public Criteria andFruitOrderSenderIdEqualTo(String value)
{
addCriterion("FRUIT_ORDER_SENDER_ID",false,Operation.EQ,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_SENDER_ID <>
* @return
*/
public Criteria andFruitOrderSenderIdNotEqualTo(String value)
{
addCriterion("FRUIT_ORDER_SENDER_ID",false,Operation.NOTEQ,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_SENDER_ID >
* @return
*/
public Criteria andFruitOrderSenderIdGreaterThan(String value)
{
addCriterion("FRUIT_ORDER_SENDER_ID",false,Operation.GT,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_SENDER_ID >=
* @return
*/
public Criteria andFruitOrderSenderIdGreaterThanOrEqualTo(String value)
{
addCriterion("FRUIT_ORDER_SENDER_ID",false,Operation.GE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_SENDER_ID <
* @return
*/
public Criteria andFruitOrderSenderIdLessThan(String value)
{
addCriterion("FRUIT_ORDER_SENDER_ID",false,Operation.LT,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_SENDER_ID <=
* @return
*/
public Criteria andFruitOrderSenderIdLessThanOrEqualTo(String value)
{
addCriterion("FRUIT_ORDER_SENDER_ID",false,Operation.LE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_SENDER_ID like
* @return
*/
public Criteria andFruitOrderSenderIdLike(String value)
{
addCriterion("FRUIT_ORDER_SENDER_ID",false,Operation.LIKE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_SENDER_ID not like
* @return
*/
public Criteria andFruitOrderSenderIdNotLike(String value)
{
addCriterion("FRUIT_ORDER_SENDER_ID",false,Operation.NOTLIKE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_SENDER_ID in
* @return
*/
public Criteria andFruitOrderSenderIdIn(List<String> values)
{
addCriterion("FRUIT_ORDER_SENDER_ID",false,Operation.IN,values);
return (Criteria) this;
}
/**
* FRUIT_ORDER_SENDER_ID not in
* @return
*/
public Criteria andFruitOrderSenderIdNotIn(List<String> values)
{
addCriterion("FRUIT_ORDER_SENDER_ID",false,Operation.NOTIN,values);
return (Criteria) this;
}
/**
* FRUIT_ORDER_SENDER_ID between
* @return
*/
public Criteria andFruitOrderSenderIdBetween(String value1, String value2)
{
addCriterion("FRUIT_ORDER_SENDER_ID",false,Operation.BETWEEN,value1,value2);
return (Criteria) this;
}
/**
* FRUIT_ORDER_SENDER_ID not between
* @return
*/
public Criteria andFruitOrderSenderIdNotBetween(String value1, String value2)
{
addCriterion("FRUIT_ORDER_SENDER_ID",false,Operation.NOTBETWEEN,value1,value2);
return (Criteria) this;
}
/**
* upper(FRUIT_ORDER_SENDER_ID) like '%value.toUpperCase()%'
* @return
*/
public Criteria andFruitOrderSenderIdLikeInsensitive(String value)
{
addCriterion("FRUIT_ORDER_SENDER_ID",false,Operation.LIKEIC,new Object[] {value});
return (Criteria) this;
}
/**
* CREATE_TIME is null
* @return
*/
public Criteria andCreateTimeIsNull()
{
addCriterion("CREATE_TIME",false,Operation.ISNULL,new Object[] {});
return (Criteria) this;
}
/**
* CREATE_TIME is not null
* @return
*/
public Criteria andCreateTimeIsNotNull()
{
addCriterion("CREATE_TIME",false,Operation.ISNOTNULL,new Object[] {});
return (Criteria) this;
}
/**
* CREATE_TIME =
* @return
*/
public Criteria andCreateTimeEqualTo(String value)
{
addCriterion("CREATE_TIME",false,Operation.EQ,new Object[] {value});
return (Criteria) this;
}
/**
* CREATE_TIME <>
* @return
*/
public Criteria andCreateTimeNotEqualTo(String value)
{
addCriterion("CREATE_TIME",false,Operation.NOTEQ,new Object[] {value});
return (Criteria) this;
}
/**
* CREATE_TIME >
* @return
*/
public Criteria andCreateTimeGreaterThan(String value)
{
addCriterion("CREATE_TIME",false,Operation.GT,new Object[] {value});
return (Criteria) this;
}
/**
* CREATE_TIME >=
* @return
*/
public Criteria andCreateTimeGreaterThanOrEqualTo(String value)
{
addCriterion("CREATE_TIME",false,Operation.GE,new Object[] {value});
return (Criteria) this;
}
/**
* CREATE_TIME <
* @return
*/
public Criteria andCreateTimeLessThan(String value)
{
addCriterion("CREATE_TIME",false,Operation.LT,new Object[] {value});
return (Criteria) this;
}
/**
* CREATE_TIME <=
* @return
*/
public Criteria andCreateTimeLessThanOrEqualTo(String value)
{
addCriterion("CREATE_TIME",false,Operation.LE,new Object[] {value});
return (Criteria) this;
}
/**
* CREATE_TIME like
* @return
*/
public Criteria andCreateTimeLike(String value)
{
addCriterion("CREATE_TIME",false,Operation.LIKE,new Object[] {value});
return (Criteria) this;
}
/**
* CREATE_TIME not like
* @return
*/
public Criteria andCreateTimeNotLike(String value)
{
addCriterion("CREATE_TIME",false,Operation.NOTLIKE,new Object[] {value});
return (Criteria) this;
}
/**
* CREATE_TIME in
* @return
*/
public Criteria andCreateTimeIn(List<String> values)
{
addCriterion("CREATE_TIME",false,Operation.IN,values);
return (Criteria) this;
}
/**
* CREATE_TIME not in
* @return
*/
public Criteria andCreateTimeNotIn(List<String> values)
{
addCriterion("CREATE_TIME",false,Operation.NOTIN,values);
return (Criteria) this;
}
/**
* CREATE_TIME between
* @return
*/
public Criteria andCreateTimeBetween(String value1, String value2)
{
addCriterion("CREATE_TIME",false,Operation.BETWEEN,value1,value2);
return (Criteria) this;
}
/**
* CREATE_TIME not between
* @return
*/
public Criteria andCreateTimeNotBetween(String value1, String value2)
{
addCriterion("CREATE_TIME",false,Operation.NOTBETWEEN,value1,value2);
return (Criteria) this;
}
/**
* upper(CREATE_TIME) like '%value.toUpperCase()%'
* @return
*/
public Criteria andCreateTimeLikeInsensitive(String value)
{
addCriterion("CREATE_TIME",false,Operation.LIKEIC,new Object[] {value});
return (Criteria) this;
}
/**
* CREATOR is null
* @return
*/
public Criteria andCreatorIsNull()
{
addCriterion("CREATOR",false,Operation.ISNULL,new Object[] {});
return (Criteria) this;
}
/**
* CREATOR is not null
* @return
*/
public Criteria andCreatorIsNotNull()
{
addCriterion("CREATOR",false,Operation.ISNOTNULL,new Object[] {});
return (Criteria) this;
}
/**
* CREATOR =
* @return
*/
public Criteria andCreatorEqualTo(String value)
{
addCriterion("CREATOR",false,Operation.EQ,new Object[] {value});
return (Criteria) this;
}
/**
* CREATOR <>
* @return
*/
public Criteria andCreatorNotEqualTo(String value)
{
addCriterion("CREATOR",false,Operation.NOTEQ,new Object[] {value});
return (Criteria) this;
}
/**
* CREATOR >
* @return
*/
public Criteria andCreatorGreaterThan(String value)
{
addCriterion("CREATOR",false,Operation.GT,new Object[] {value});
return (Criteria) this;
}
/**
* CREATOR >=
* @return
*/
public Criteria andCreatorGreaterThanOrEqualTo(String value)
{
addCriterion("CREATOR",false,Operation.GE,new Object[] {value});
return (Criteria) this;
}
/**
* CREATOR <
* @return
*/
public Criteria andCreatorLessThan(String value)
{
addCriterion("CREATOR",false,Operation.LT,new Object[] {value});
return (Criteria) this;
}
/**
* CREATOR <=
* @return
*/
public Criteria andCreatorLessThanOrEqualTo(String value)
{
addCriterion("CREATOR",false,Operation.LE,new Object[] {value});
return (Criteria) this;
}
/**
* CREATOR like
* @return
*/
public Criteria andCreatorLike(String value)
{
addCriterion("CREATOR",false,Operation.LIKE,new Object[] {value});
return (Criteria) this;
}
/**
* CREATOR not like
* @return
*/
public Criteria andCreatorNotLike(String value)
{
addCriterion("CREATOR",false,Operation.NOTLIKE,new Object[] {value});
return (Criteria) this;
}
/**
* CREATOR in
* @return
*/
public Criteria andCreatorIn(List<String> values)
{
addCriterion("CREATOR",false,Operation.IN,values);
return (Criteria) this;
}
/**
* CREATOR not in
* @return
*/
public Criteria andCreatorNotIn(List<String> values)
{
addCriterion("CREATOR",false,Operation.NOTIN,values);
return (Criteria) this;
}
/**
* CREATOR between
* @return
*/
public Criteria andCreatorBetween(String value1, String value2)
{
addCriterion("CREATOR",false,Operation.BETWEEN,value1,value2);
return (Criteria) this;
}
/**
* CREATOR not between
* @return
*/
public Criteria andCreatorNotBetween(String value1, String value2)
{
addCriterion("CREATOR",false,Operation.NOTBETWEEN,value1,value2);
return (Criteria) this;
}
/**
* upper(CREATOR) like '%value.toUpperCase()%'
* @return
*/
public Criteria andCreatorLikeInsensitive(String value)
{
addCriterion("CREATOR",false,Operation.LIKEIC,new Object[] {value});
return (Criteria) this;
}
/**
* RECORD_VERSION is null
* @return
*/
public Criteria andRecordVersionIsNull()
{
addCriterion("RECORD_VERSION",false,Operation.ISNULL,new Object[] {});
return (Criteria) this;
}
/**
* RECORD_VERSION is not null
* @return
*/
public Criteria andRecordVersionIsNotNull()
{
addCriterion("RECORD_VERSION",false,Operation.ISNOTNULL,new Object[] {});
return (Criteria) this;
}
/**
* RECORD_VERSION =
* @return
*/
public Criteria andRecordVersionEqualTo(BigDecimal value)
{
addCriterion("RECORD_VERSION",false,Operation.EQ,new Object[] {value});
return (Criteria) this;
}
/**
* RECORD_VERSION <>
* @return
*/
public Criteria andRecordVersionNotEqualTo(BigDecimal value)
{
addCriterion("RECORD_VERSION",false,Operation.NOTEQ,new Object[] {value});
return (Criteria) this;
}
/**
* RECORD_VERSION >
* @return
*/
public Criteria andRecordVersionGreaterThan(BigDecimal value)
{
addCriterion("RECORD_VERSION",false,Operation.GT,new Object[] {value});
return (Criteria) this;
}
/**
* RECORD_VERSION >=
* @return
*/
public Criteria andRecordVersionGreaterThanOrEqualTo(BigDecimal value)
{
addCriterion("RECORD_VERSION",false,Operation.GE,new Object[] {value});
return (Criteria) this;
}
/**
* RECORD_VERSION <
* @return
*/
public Criteria andRecordVersionLessThan(BigDecimal value)
{
addCriterion("RECORD_VERSION",false,Operation.LT,new Object[] {value});
return (Criteria) this;
}
/**
* RECORD_VERSION <=
* @return
*/
public Criteria andRecordVersionLessThanOrEqualTo(BigDecimal value)
{
addCriterion("RECORD_VERSION",false,Operation.LE,new Object[] {value});
return (Criteria) this;
}
/**
* RECORD_VERSION like
* @return
*/
public Criteria andRecordVersionLike(BigDecimal value)
{
addCriterion("RECORD_VERSION",false,Operation.LIKE,new Object[] {value});
return (Criteria) this;
}
/**
* RECORD_VERSION not like
* @return
*/
public Criteria andRecordVersionNotLike(BigDecimal value)
{
addCriterion("RECORD_VERSION",false,Operation.NOTLIKE,new Object[] {value});
return (Criteria) this;
}
/**
* RECORD_VERSION in
* @return
*/
public Criteria andRecordVersionIn(List<BigDecimal> values)
{
addCriterion("RECORD_VERSION",false,Operation.IN,values);
return (Criteria) this;
}
/**
* RECORD_VERSION not in
* @return
*/
public Criteria andRecordVersionNotIn(List<BigDecimal> values)
{
addCriterion("RECORD_VERSION",false,Operation.NOTIN,values);
return (Criteria) this;
}
/**
* RECORD_VERSION between
* @return
*/
public Criteria andRecordVersionBetween(BigDecimal value1, BigDecimal value2)
{
addCriterion("RECORD_VERSION",false,Operation.BETWEEN,value1,value2);
return (Criteria) this;
}
/**
* RECORD_VERSION not between
* @return
*/
public Criteria andRecordVersionNotBetween(BigDecimal value1, BigDecimal value2)
{
addCriterion("RECORD_VERSION",false,Operation.NOTBETWEEN,value1,value2);
return (Criteria) this;
}
/**
* upper(RECORD_VERSION) like '%value.toUpperCase()%'
* @return
*/
public Criteria andRecordVersionLikeInsensitive(BigDecimal value)
{
addCriterion("RECORD_VERSION",false,Operation.LIKEIC,new Object[] {value});
return (Criteria) this;
}
/**
* PROCESS_STATE is null
* @return
*/
public Criteria andProcessStateIsNull()
{
addCriterion("PROCESS_STATE",false,Operation.ISNULL,new Object[] {});
return (Criteria) this;
}
/**
* PROCESS_STATE is not null
* @return
*/
public Criteria andProcessStateIsNotNull()
{
addCriterion("PROCESS_STATE",false,Operation.ISNOTNULL,new Object[] {});
return (Criteria) this;
}
/**
* PROCESS_STATE =
* @return
*/
public Criteria andProcessStateEqualTo(String value)
{
addCriterion("PROCESS_STATE",false,Operation.EQ,new Object[] {value});
return (Criteria) this;
}
/**
* PROCESS_STATE <>
* @return
*/
public Criteria andProcessStateNotEqualTo(String value)
{
addCriterion("PROCESS_STATE",false,Operation.NOTEQ,new Object[] {value});
return (Criteria) this;
}
/**
* PROCESS_STATE >
* @return
*/
public Criteria andProcessStateGreaterThan(String value)
{
addCriterion("PROCESS_STATE",false,Operation.GT,new Object[] {value});
return (Criteria) this;
}
/**
* PROCESS_STATE >=
* @return
*/
public Criteria andProcessStateGreaterThanOrEqualTo(String value)
{
addCriterion("PROCESS_STATE",false,Operation.GE,new Object[] {value});
return (Criteria) this;
}
/**
* PROCESS_STATE <
* @return
*/
public Criteria andProcessStateLessThan(String value)
{
addCriterion("PROCESS_STATE",false,Operation.LT,new Object[] {value});
return (Criteria) this;
}
/**
* PROCESS_STATE <=
* @return
*/
public Criteria andProcessStateLessThanOrEqualTo(String value)
{
addCriterion("PROCESS_STATE",false,Operation.LE,new Object[] {value});
return (Criteria) this;
}
/**
* PROCESS_STATE like
* @return
*/
public Criteria andProcessStateLike(String value)
{
addCriterion("PROCESS_STATE",false,Operation.LIKE,new Object[] {value});
return (Criteria) this;
}
/**
* PROCESS_STATE not like
* @return
*/
public Criteria andProcessStateNotLike(String value)
{
addCriterion("PROCESS_STATE",false,Operation.NOTLIKE,new Object[] {value});
return (Criteria) this;
}
/**
* PROCESS_STATE in
* @return
*/
public Criteria andProcessStateIn(List<String> values)
{
addCriterion("PROCESS_STATE",false,Operation.IN,values);
return (Criteria) this;
}
/**
* PROCESS_STATE not in
* @return
*/
public Criteria andProcessStateNotIn(List<String> values)
{
addCriterion("PROCESS_STATE",false,Operation.NOTIN,values);
return (Criteria) this;
}
/**
* PROCESS_STATE between
* @return
*/
public Criteria andProcessStateBetween(String value1, String value2)
{
addCriterion("PROCESS_STATE",false,Operation.BETWEEN,value1,value2);
return (Criteria) this;
}
/**
* PROCESS_STATE not between
* @return
*/
public Criteria andProcessStateNotBetween(String value1, String value2)
{
addCriterion("PROCESS_STATE",false,Operation.NOTBETWEEN,value1,value2);
return (Criteria) this;
}
/**
* upper(PROCESS_STATE) like '%value.toUpperCase()%'
* @return
*/
public Criteria andProcessStateLikeInsensitive(String value)
{
addCriterion("PROCESS_STATE",false,Operation.LIKEIC,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_RECEIVER is null
* @return
*/
public Criteria andFruitOrderReceiverIsNull()
{
addCriterion("FRUIT_ORDER_RECEIVER",false,Operation.ISNULL,new Object[] {});
return (Criteria) this;
}
/**
* FRUIT_ORDER_RECEIVER is not null
* @return
*/
public Criteria andFruitOrderReceiverIsNotNull()
{
addCriterion("FRUIT_ORDER_RECEIVER",false,Operation.ISNOTNULL,new Object[] {});
return (Criteria) this;
}
/**
* FRUIT_ORDER_RECEIVER =
* @return
*/
public Criteria andFruitOrderReceiverEqualTo(String value)
{
addCriterion("FRUIT_ORDER_RECEIVER",false,Operation.EQ,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_RECEIVER <>
* @return
*/
public Criteria andFruitOrderReceiverNotEqualTo(String value)
{
addCriterion("FRUIT_ORDER_RECEIVER",false,Operation.NOTEQ,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_RECEIVER >
* @return
*/
public Criteria andFruitOrderReceiverGreaterThan(String value)
{
addCriterion("FRUIT_ORDER_RECEIVER",false,Operation.GT,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_RECEIVER >=
* @return
*/
public Criteria andFruitOrderReceiverGreaterThanOrEqualTo(String value)
{
addCriterion("FRUIT_ORDER_RECEIVER",false,Operation.GE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_RECEIVER <
* @return
*/
public Criteria andFruitOrderReceiverLessThan(String value)
{
addCriterion("FRUIT_ORDER_RECEIVER",false,Operation.LT,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_RECEIVER <=
* @return
*/
public Criteria andFruitOrderReceiverLessThanOrEqualTo(String value)
{
addCriterion("FRUIT_ORDER_RECEIVER",false,Operation.LE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_RECEIVER like
* @return
*/
public Criteria andFruitOrderReceiverLike(String value)
{
addCriterion("FRUIT_ORDER_RECEIVER",false,Operation.LIKE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_RECEIVER not like
* @return
*/
public Criteria andFruitOrderReceiverNotLike(String value)
{
addCriterion("FRUIT_ORDER_RECEIVER",false,Operation.NOTLIKE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_RECEIVER in
* @return
*/
public Criteria andFruitOrderReceiverIn(List<String> values)
{
addCriterion("FRUIT_ORDER_RECEIVER",false,Operation.IN,values);
return (Criteria) this;
}
/**
* FRUIT_ORDER_RECEIVER not in
* @return
*/
public Criteria andFruitOrderReceiverNotIn(List<String> values)
{
addCriterion("FRUIT_ORDER_RECEIVER",false,Operation.NOTIN,values);
return (Criteria) this;
}
/**
* FRUIT_ORDER_RECEIVER between
* @return
*/
public Criteria andFruitOrderReceiverBetween(String value1, String value2)
{
addCriterion("FRUIT_ORDER_RECEIVER",false,Operation.BETWEEN,value1,value2);
return (Criteria) this;
}
/**
* FRUIT_ORDER_RECEIVER not between
* @return
*/
public Criteria andFruitOrderReceiverNotBetween(String value1, String value2)
{
addCriterion("FRUIT_ORDER_RECEIVER",false,Operation.NOTBETWEEN,value1,value2);
return (Criteria) this;
}
/**
* upper(FRUIT_ORDER_RECEIVER) like '%value.toUpperCase()%'
* @return
*/
public Criteria andFruitOrderReceiverLikeInsensitive(String value)
{
addCriterion("FRUIT_ORDER_RECEIVER",false,Operation.LIKEIC,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_REMARK is null
* @return
*/
public Criteria andFruitOrderRemarkIsNull()
{
addCriterion("FRUIT_ORDER_REMARK",false,Operation.ISNULL,new Object[] {});
return (Criteria) this;
}
/**
* FRUIT_ORDER_REMARK is not null
* @return
*/
public Criteria andFruitOrderRemarkIsNotNull()
{
addCriterion("FRUIT_ORDER_REMARK",false,Operation.ISNOTNULL,new Object[] {});
return (Criteria) this;
}
/**
* FRUIT_ORDER_REMARK =
* @return
*/
public Criteria andFruitOrderRemarkEqualTo(String value)
{
addCriterion("FRUIT_ORDER_REMARK",false,Operation.EQ,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_REMARK <>
* @return
*/
public Criteria andFruitOrderRemarkNotEqualTo(String value)
{
addCriterion("FRUIT_ORDER_REMARK",false,Operation.NOTEQ,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_REMARK >
* @return
*/
public Criteria andFruitOrderRemarkGreaterThan(String value)
{
addCriterion("FRUIT_ORDER_REMARK",false,Operation.GT,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_REMARK >=
* @return
*/
public Criteria andFruitOrderRemarkGreaterThanOrEqualTo(String value)
{
addCriterion("FRUIT_ORDER_REMARK",false,Operation.GE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_REMARK <
* @return
*/
public Criteria andFruitOrderRemarkLessThan(String value)
{
addCriterion("FRUIT_ORDER_REMARK",false,Operation.LT,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_REMARK <=
* @return
*/
public Criteria andFruitOrderRemarkLessThanOrEqualTo(String value)
{
addCriterion("FRUIT_ORDER_REMARK",false,Operation.LE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_REMARK like
* @return
*/
public Criteria andFruitOrderRemarkLike(String value)
{
addCriterion("FRUIT_ORDER_REMARK",false,Operation.LIKE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_REMARK not like
* @return
*/
public Criteria andFruitOrderRemarkNotLike(String value)
{
addCriterion("FRUIT_ORDER_REMARK",false,Operation.NOTLIKE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_REMARK in
* @return
*/
public Criteria andFruitOrderRemarkIn(List<String> values)
{
addCriterion("FRUIT_ORDER_REMARK",false,Operation.IN,values);
return (Criteria) this;
}
/**
* FRUIT_ORDER_REMARK not in
* @return
*/
public Criteria andFruitOrderRemarkNotIn(List<String> values)
{
addCriterion("FRUIT_ORDER_REMARK",false,Operation.NOTIN,values);
return (Criteria) this;
}
/**
* FRUIT_ORDER_REMARK between
* @return
*/
public Criteria andFruitOrderRemarkBetween(String value1, String value2)
{
addCriterion("FRUIT_ORDER_REMARK",false,Operation.BETWEEN,value1,value2);
return (Criteria) this;
}
/**
* FRUIT_ORDER_REMARK not between
* @return
*/
public Criteria andFruitOrderRemarkNotBetween(String value1, String value2)
{
addCriterion("FRUIT_ORDER_REMARK",false,Operation.NOTBETWEEN,value1,value2);
return (Criteria) this;
}
/**
* upper(FRUIT_ORDER_REMARK) like '%value.toUpperCase()%'
* @return
*/
public Criteria andFruitOrderRemarkLikeInsensitive(String value)
{
addCriterion("FRUIT_ORDER_REMARK",false,Operation.LIKEIC,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_ID is null
* @return
*/
public Criteria andFruitOrderIdIsNull()
{
addCriterion("FRUIT_ORDER_ID",false,Operation.ISNULL,new Object[] {});
return (Criteria) this;
}
/**
* FRUIT_ORDER_ID is not null
* @return
*/
public Criteria andFruitOrderIdIsNotNull()
{
addCriterion("FRUIT_ORDER_ID",false,Operation.ISNOTNULL,new Object[] {});
return (Criteria) this;
}
/**
* FRUIT_ORDER_ID =
* @return
*/
public Criteria andFruitOrderIdEqualTo(String value)
{
addCriterion("FRUIT_ORDER_ID",false,Operation.EQ,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_ID <>
* @return
*/
public Criteria andFruitOrderIdNotEqualTo(String value)
{
addCriterion("FRUIT_ORDER_ID",false,Operation.NOTEQ,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_ID >
* @return
*/
public Criteria andFruitOrderIdGreaterThan(String value)
{
addCriterion("FRUIT_ORDER_ID",false,Operation.GT,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_ID >=
* @return
*/
public Criteria andFruitOrderIdGreaterThanOrEqualTo(String value)
{
addCriterion("FRUIT_ORDER_ID",false,Operation.GE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_ID <
* @return
*/
public Criteria andFruitOrderIdLessThan(String value)
{
addCriterion("FRUIT_ORDER_ID",false,Operation.LT,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_ID <=
* @return
*/
public Criteria andFruitOrderIdLessThanOrEqualTo(String value)
{
addCriterion("FRUIT_ORDER_ID",false,Operation.LE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_ID like
* @return
*/
public Criteria andFruitOrderIdLike(String value)
{
addCriterion("FRUIT_ORDER_ID",false,Operation.LIKE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_ID not like
* @return
*/
public Criteria andFruitOrderIdNotLike(String value)
{
addCriterion("FRUIT_ORDER_ID",false,Operation.NOTLIKE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_ID in
* @return
*/
public Criteria andFruitOrderIdIn(List<String> values)
{
addCriterion("FRUIT_ORDER_ID",false,Operation.IN,values);
return (Criteria) this;
}
/**
* FRUIT_ORDER_ID not in
* @return
*/
public Criteria andFruitOrderIdNotIn(List<String> values)
{
addCriterion("FRUIT_ORDER_ID",false,Operation.NOTIN,values);
return (Criteria) this;
}
/**
* FRUIT_ORDER_ID between
* @return
*/
public Criteria andFruitOrderIdBetween(String value1, String value2)
{
addCriterion("FRUIT_ORDER_ID",false,Operation.BETWEEN,value1,value2);
return (Criteria) this;
}
/**
* FRUIT_ORDER_ID not between
* @return
*/
public Criteria andFruitOrderIdNotBetween(String value1, String value2)
{
addCriterion("FRUIT_ORDER_ID",false,Operation.NOTBETWEEN,value1,value2);
return (Criteria) this;
}
/**
* upper(FRUIT_ORDER_ID) like '%value.toUpperCase()%'
* @return
*/
public Criteria andFruitOrderIdLikeInsensitive(String value)
{
addCriterion("FRUIT_ORDER_ID",false,Operation.LIKEIC,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY02 is null
* @return
*/
public Criteria andCountry02IsNull()
{
addCriterion("COUNTRY02",false,Operation.ISNULL,new Object[] {});
return (Criteria) this;
}
/**
* COUNTRY02 is not null
* @return
*/
public Criteria andCountry02IsNotNull()
{
addCriterion("COUNTRY02",false,Operation.ISNOTNULL,new Object[] {});
return (Criteria) this;
}
/**
* COUNTRY02 =
* @return
*/
public Criteria andCountry02EqualTo(String value)
{
addCriterion("COUNTRY02",false,Operation.EQ,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY02 <>
* @return
*/
public Criteria andCountry02NotEqualTo(String value)
{
addCriterion("COUNTRY02",false,Operation.NOTEQ,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY02 >
* @return
*/
public Criteria andCountry02GreaterThan(String value)
{
addCriterion("COUNTRY02",false,Operation.GT,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY02 >=
* @return
*/
public Criteria andCountry02GreaterThanOrEqualTo(String value)
{
addCriterion("COUNTRY02",false,Operation.GE,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY02 <
* @return
*/
public Criteria andCountry02LessThan(String value)
{
addCriterion("COUNTRY02",false,Operation.LT,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY02 <=
* @return
*/
public Criteria andCountry02LessThanOrEqualTo(String value)
{
addCriterion("COUNTRY02",false,Operation.LE,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY02 like
* @return
*/
public Criteria andCountry02Like(String value)
{
addCriterion("COUNTRY02",false,Operation.LIKE,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY02 not like
* @return
*/
public Criteria andCountry02NotLike(String value)
{
addCriterion("COUNTRY02",false,Operation.NOTLIKE,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY02 in
* @return
*/
public Criteria andCountry02In(List<String> values)
{
addCriterion("COUNTRY02",false,Operation.IN,values);
return (Criteria) this;
}
/**
* COUNTRY02 not in
* @return
*/
public Criteria andCountry02NotIn(List<String> values)
{
addCriterion("COUNTRY02",false,Operation.NOTIN,values);
return (Criteria) this;
}
/**
* COUNTRY02 between
* @return
*/
public Criteria andCountry02Between(String value1, String value2)
{
addCriterion("COUNTRY02",false,Operation.BETWEEN,value1,value2);
return (Criteria) this;
}
/**
* COUNTRY02 not between
* @return
*/
public Criteria andCountry02NotBetween(String value1, String value2)
{
addCriterion("COUNTRY02",false,Operation.NOTBETWEEN,value1,value2);
return (Criteria) this;
}
/**
* upper(COUNTRY02) like '%value.toUpperCase()%'
* @return
*/
public Criteria andCountry02LikeInsensitive(String value)
{
addCriterion("COUNTRY02",false,Operation.LIKEIC,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_TIME is null
* @return
*/
public Criteria andFruitOrderTimeIsNull()
{
addCriterion("FRUIT_ORDER_TIME",false,Operation.ISNULL,new Object[] {});
return (Criteria) this;
}
/**
* FRUIT_ORDER_TIME is not null
* @return
*/
public Criteria andFruitOrderTimeIsNotNull()
{
addCriterion("FRUIT_ORDER_TIME",false,Operation.ISNOTNULL,new Object[] {});
return (Criteria) this;
}
/**
* FRUIT_ORDER_TIME =
* @return
*/
public Criteria andFruitOrderTimeEqualTo(String value)
{
addCriterion("FRUIT_ORDER_TIME",false,Operation.EQ,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_TIME <>
* @return
*/
public Criteria andFruitOrderTimeNotEqualTo(String value)
{
addCriterion("FRUIT_ORDER_TIME",false,Operation.NOTEQ,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_TIME >
* @return
*/
public Criteria andFruitOrderTimeGreaterThan(String value)
{
addCriterion("FRUIT_ORDER_TIME",false,Operation.GT,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_TIME >=
* @return
*/
public Criteria andFruitOrderTimeGreaterThanOrEqualTo(String value)
{
addCriterion("FRUIT_ORDER_TIME",false,Operation.GE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_TIME <
* @return
*/
public Criteria andFruitOrderTimeLessThan(String value)
{
addCriterion("FRUIT_ORDER_TIME",false,Operation.LT,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_TIME <=
* @return
*/
public Criteria andFruitOrderTimeLessThanOrEqualTo(String value)
{
addCriterion("FRUIT_ORDER_TIME",false,Operation.LE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_TIME like
* @return
*/
public Criteria andFruitOrderTimeLike(String value)
{
addCriterion("FRUIT_ORDER_TIME",false,Operation.LIKE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_TIME not like
* @return
*/
public Criteria andFruitOrderTimeNotLike(String value)
{
addCriterion("FRUIT_ORDER_TIME",false,Operation.NOTLIKE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_TIME in
* @return
*/
public Criteria andFruitOrderTimeIn(List<String> values)
{
addCriterion("FRUIT_ORDER_TIME",false,Operation.IN,values);
return (Criteria) this;
}
/**
* FRUIT_ORDER_TIME not in
* @return
*/
public Criteria andFruitOrderTimeNotIn(List<String> values)
{
addCriterion("FRUIT_ORDER_TIME",false,Operation.NOTIN,values);
return (Criteria) this;
}
/**
* FRUIT_ORDER_TIME between
* @return
*/
public Criteria andFruitOrderTimeBetween(String value1, String value2)
{
addCriterion("FRUIT_ORDER_TIME",false,Operation.BETWEEN,value1,value2);
return (Criteria) this;
}
/**
* FRUIT_ORDER_TIME not between
* @return
*/
public Criteria andFruitOrderTimeNotBetween(String value1, String value2)
{
addCriterion("FRUIT_ORDER_TIME",false,Operation.NOTBETWEEN,value1,value2);
return (Criteria) this;
}
/**
* upper(FRUIT_ORDER_TIME) like '%value.toUpperCase()%'
* @return
*/
public Criteria andFruitOrderTimeLikeInsensitive(String value)
{
addCriterion("FRUIT_ORDER_TIME",false,Operation.LIKEIC,new Object[] {value});
return (Criteria) this;
}
/**
* PRINCIPAL_GROUP_CODE is null
* @return
*/
public Criteria andPrincipalGroupCodeIsNull()
{
addCriterion("PRINCIPAL_GROUP_CODE",false,Operation.ISNULL,new Object[] {});
return (Criteria) this;
}
/**
* PRINCIPAL_GROUP_CODE is not null
* @return
*/
public Criteria andPrincipalGroupCodeIsNotNull()
{
addCriterion("PRINCIPAL_GROUP_CODE",false,Operation.ISNOTNULL,new Object[] {});
return (Criteria) this;
}
/**
* PRINCIPAL_GROUP_CODE =
* @return
*/
public Criteria andPrincipalGroupCodeEqualTo(String value)
{
addCriterion("PRINCIPAL_GROUP_CODE",false,Operation.EQ,new Object[] {value});
return (Criteria) this;
}
/**
* PRINCIPAL_GROUP_CODE <>
* @return
*/
public Criteria andPrincipalGroupCodeNotEqualTo(String value)
{
addCriterion("PRINCIPAL_GROUP_CODE",false,Operation.NOTEQ,new Object[] {value});
return (Criteria) this;
}
/**
* PRINCIPAL_GROUP_CODE >
* @return
*/
public Criteria andPrincipalGroupCodeGreaterThan(String value)
{
addCriterion("PRINCIPAL_GROUP_CODE",false,Operation.GT,new Object[] {value});
return (Criteria) this;
}
/**
* PRINCIPAL_GROUP_CODE >=
* @return
*/
public Criteria andPrincipalGroupCodeGreaterThanOrEqualTo(String value)
{
addCriterion("PRINCIPAL_GROUP_CODE",false,Operation.GE,new Object[] {value});
return (Criteria) this;
}
/**
* PRINCIPAL_GROUP_CODE <
* @return
*/
public Criteria andPrincipalGroupCodeLessThan(String value)
{
addCriterion("PRINCIPAL_GROUP_CODE",false,Operation.LT,new Object[] {value});
return (Criteria) this;
}
/**
* PRINCIPAL_GROUP_CODE <=
* @return
*/
public Criteria andPrincipalGroupCodeLessThanOrEqualTo(String value)
{
addCriterion("PRINCIPAL_GROUP_CODE",false,Operation.LE,new Object[] {value});
return (Criteria) this;
}
/**
* PRINCIPAL_GROUP_CODE like
* @return
*/
public Criteria andPrincipalGroupCodeLike(String value)
{
addCriterion("PRINCIPAL_GROUP_CODE",false,Operation.LIKE,new Object[] {value});
return (Criteria) this;
}
/**
* PRINCIPAL_GROUP_CODE not like
* @return
*/
public Criteria andPrincipalGroupCodeNotLike(String value)
{
addCriterion("PRINCIPAL_GROUP_CODE",false,Operation.NOTLIKE,new Object[] {value});
return (Criteria) this;
}
/**
* PRINCIPAL_GROUP_CODE in
* @return
*/
public Criteria andPrincipalGroupCodeIn(List<String> values)
{
addCriterion("PRINCIPAL_GROUP_CODE",false,Operation.IN,values);
return (Criteria) this;
}
/**
* PRINCIPAL_GROUP_CODE not in
* @return
*/
public Criteria andPrincipalGroupCodeNotIn(List<String> values)
{
addCriterion("PRINCIPAL_GROUP_CODE",false,Operation.NOTIN,values);
return (Criteria) this;
}
/**
* PRINCIPAL_GROUP_CODE between
* @return
*/
public Criteria andPrincipalGroupCodeBetween(String value1, String value2)
{
addCriterion("PRINCIPAL_GROUP_CODE",false,Operation.BETWEEN,value1,value2);
return (Criteria) this;
}
/**
* PRINCIPAL_GROUP_CODE not between
* @return
*/
public Criteria andPrincipalGroupCodeNotBetween(String value1, String value2)
{
addCriterion("PRINCIPAL_GROUP_CODE",false,Operation.NOTBETWEEN,value1,value2);
return (Criteria) this;
}
/**
* upper(PRINCIPAL_GROUP_CODE) like '%value.toUpperCase()%'
* @return
*/
public Criteria andPrincipalGroupCodeLikeInsensitive(String value)
{
addCriterion("PRINCIPAL_GROUP_CODE",false,Operation.LIKEIC,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_SENDER_NAME is null
* @return
*/
public Criteria andFruitOrderSenderNameIsNull()
{
addCriterion("FRUIT_ORDER_SENDER_NAME",false,Operation.ISNULL,new Object[] {});
return (Criteria) this;
}
/**
* FRUIT_ORDER_SENDER_NAME is not null
* @return
*/
public Criteria andFruitOrderSenderNameIsNotNull()
{
addCriterion("FRUIT_ORDER_SENDER_NAME",false,Operation.ISNOTNULL,new Object[] {});
return (Criteria) this;
}
/**
* FRUIT_ORDER_SENDER_NAME =
* @return
*/
public Criteria andFruitOrderSenderNameEqualTo(String value)
{
addCriterion("FRUIT_ORDER_SENDER_NAME",false,Operation.EQ,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_SENDER_NAME <>
* @return
*/
public Criteria andFruitOrderSenderNameNotEqualTo(String value)
{
addCriterion("FRUIT_ORDER_SENDER_NAME",false,Operation.NOTEQ,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_SENDER_NAME >
* @return
*/
public Criteria andFruitOrderSenderNameGreaterThan(String value)
{
addCriterion("FRUIT_ORDER_SENDER_NAME",false,Operation.GT,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_SENDER_NAME >=
* @return
*/
public Criteria andFruitOrderSenderNameGreaterThanOrEqualTo(String value)
{
addCriterion("FRUIT_ORDER_SENDER_NAME",false,Operation.GE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_SENDER_NAME <
* @return
*/
public Criteria andFruitOrderSenderNameLessThan(String value)
{
addCriterion("FRUIT_ORDER_SENDER_NAME",false,Operation.LT,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_SENDER_NAME <=
* @return
*/
public Criteria andFruitOrderSenderNameLessThanOrEqualTo(String value)
{
addCriterion("FRUIT_ORDER_SENDER_NAME",false,Operation.LE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_SENDER_NAME like
* @return
*/
public Criteria andFruitOrderSenderNameLike(String value)
{
addCriterion("FRUIT_ORDER_SENDER_NAME",false,Operation.LIKE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_SENDER_NAME not like
* @return
*/
public Criteria andFruitOrderSenderNameNotLike(String value)
{
addCriterion("FRUIT_ORDER_SENDER_NAME",false,Operation.NOTLIKE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_SENDER_NAME in
* @return
*/
public Criteria andFruitOrderSenderNameIn(List<String> values)
{
addCriterion("FRUIT_ORDER_SENDER_NAME",false,Operation.IN,values);
return (Criteria) this;
}
/**
* FRUIT_ORDER_SENDER_NAME not in
* @return
*/
public Criteria andFruitOrderSenderNameNotIn(List<String> values)
{
addCriterion("FRUIT_ORDER_SENDER_NAME",false,Operation.NOTIN,values);
return (Criteria) this;
}
/**
* FRUIT_ORDER_SENDER_NAME between
* @return
*/
public Criteria andFruitOrderSenderNameBetween(String value1, String value2)
{
addCriterion("FRUIT_ORDER_SENDER_NAME",false,Operation.BETWEEN,value1,value2);
return (Criteria) this;
}
/**
* FRUIT_ORDER_SENDER_NAME not between
* @return
*/
public Criteria andFruitOrderSenderNameNotBetween(String value1, String value2)
{
addCriterion("FRUIT_ORDER_SENDER_NAME",false,Operation.NOTBETWEEN,value1,value2);
return (Criteria) this;
}
/**
* upper(FRUIT_ORDER_SENDER_NAME) like '%value.toUpperCase()%'
* @return
*/
public Criteria andFruitOrderSenderNameLikeInsensitive(String value)
{
addCriterion("FRUIT_ORDER_SENDER_NAME",false,Operation.LIKEIC,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_GROSS_WEIGHT is null
* @return
*/
public Criteria andFruitGrossWeightIsNull()
{
addCriterion("FRUIT_GROSS_WEIGHT",false,Operation.ISNULL,new Object[] {});
return (Criteria) this;
}
/**
* FRUIT_GROSS_WEIGHT is not null
* @return
*/
public Criteria andFruitGrossWeightIsNotNull()
{
addCriterion("FRUIT_GROSS_WEIGHT",false,Operation.ISNOTNULL,new Object[] {});
return (Criteria) this;
}
/**
* FRUIT_GROSS_WEIGHT =
* @return
*/
public Criteria andFruitGrossWeightEqualTo(BigDecimal value)
{
addCriterion("FRUIT_GROSS_WEIGHT",false,Operation.EQ,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_GROSS_WEIGHT <>
* @return
*/
public Criteria andFruitGrossWeightNotEqualTo(BigDecimal value)
{
addCriterion("FRUIT_GROSS_WEIGHT",false,Operation.NOTEQ,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_GROSS_WEIGHT >
* @return
*/
public Criteria andFruitGrossWeightGreaterThan(BigDecimal value)
{
addCriterion("FRUIT_GROSS_WEIGHT",false,Operation.GT,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_GROSS_WEIGHT >=
* @return
*/
public Criteria andFruitGrossWeightGreaterThanOrEqualTo(BigDecimal value)
{
addCriterion("FRUIT_GROSS_WEIGHT",false,Operation.GE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_GROSS_WEIGHT <
* @return
*/
public Criteria andFruitGrossWeightLessThan(BigDecimal value)
{
addCriterion("FRUIT_GROSS_WEIGHT",false,Operation.LT,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_GROSS_WEIGHT <=
* @return
*/
public Criteria andFruitGrossWeightLessThanOrEqualTo(BigDecimal value)
{
addCriterion("FRUIT_GROSS_WEIGHT",false,Operation.LE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_GROSS_WEIGHT like
* @return
*/
public Criteria andFruitGrossWeightLike(BigDecimal value)
{
addCriterion("FRUIT_GROSS_WEIGHT",false,Operation.LIKE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_GROSS_WEIGHT not like
* @return
*/
public Criteria andFruitGrossWeightNotLike(BigDecimal value)
{
addCriterion("FRUIT_GROSS_WEIGHT",false,Operation.NOTLIKE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_GROSS_WEIGHT in
* @return
*/
public Criteria andFruitGrossWeightIn(List<BigDecimal> values)
{
addCriterion("FRUIT_GROSS_WEIGHT",false,Operation.IN,values);
return (Criteria) this;
}
/**
* FRUIT_GROSS_WEIGHT not in
* @return
*/
public Criteria andFruitGrossWeightNotIn(List<BigDecimal> values)
{
addCriterion("FRUIT_GROSS_WEIGHT",false,Operation.NOTIN,values);
return (Criteria) this;
}
/**
* FRUIT_GROSS_WEIGHT between
* @return
*/
public Criteria andFruitGrossWeightBetween(BigDecimal value1, BigDecimal value2)
{
addCriterion("FRUIT_GROSS_WEIGHT",false,Operation.BETWEEN,value1,value2);
return (Criteria) this;
}
/**
* FRUIT_GROSS_WEIGHT not between
* @return
*/
public Criteria andFruitGrossWeightNotBetween(BigDecimal value1, BigDecimal value2)
{
addCriterion("FRUIT_GROSS_WEIGHT",false,Operation.NOTBETWEEN,value1,value2);
return (Criteria) this;
}
/**
* upper(FRUIT_GROSS_WEIGHT) like '%value.toUpperCase()%'
* @return
*/
public Criteria andFruitGrossWeightLikeInsensitive(BigDecimal value)
{
addCriterion("FRUIT_GROSS_WEIGHT",false,Operation.LIKEIC,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY04 is null
* @return
*/
public Criteria andCountry04IsNull()
{
addCriterion("COUNTRY04",false,Operation.ISNULL,new Object[] {});
return (Criteria) this;
}
/**
* COUNTRY04 is not null
* @return
*/
public Criteria andCountry04IsNotNull()
{
addCriterion("COUNTRY04",false,Operation.ISNOTNULL,new Object[] {});
return (Criteria) this;
}
/**
* COUNTRY04 =
* @return
*/
public Criteria andCountry04EqualTo(String value)
{
addCriterion("COUNTRY04",false,Operation.EQ,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY04 <>
* @return
*/
public Criteria andCountry04NotEqualTo(String value)
{
addCriterion("COUNTRY04",false,Operation.NOTEQ,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY04 >
* @return
*/
public Criteria andCountry04GreaterThan(String value)
{
addCriterion("COUNTRY04",false,Operation.GT,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY04 >=
* @return
*/
public Criteria andCountry04GreaterThanOrEqualTo(String value)
{
addCriterion("COUNTRY04",false,Operation.GE,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY04 <
* @return
*/
public Criteria andCountry04LessThan(String value)
{
addCriterion("COUNTRY04",false,Operation.LT,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY04 <=
* @return
*/
public Criteria andCountry04LessThanOrEqualTo(String value)
{
addCriterion("COUNTRY04",false,Operation.LE,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY04 like
* @return
*/
public Criteria andCountry04Like(String value)
{
addCriterion("COUNTRY04",false,Operation.LIKE,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY04 not like
* @return
*/
public Criteria andCountry04NotLike(String value)
{
addCriterion("COUNTRY04",false,Operation.NOTLIKE,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY04 in
* @return
*/
public Criteria andCountry04In(List<String> values)
{
addCriterion("COUNTRY04",false,Operation.IN,values);
return (Criteria) this;
}
/**
* COUNTRY04 not in
* @return
*/
public Criteria andCountry04NotIn(List<String> values)
{
addCriterion("COUNTRY04",false,Operation.NOTIN,values);
return (Criteria) this;
}
/**
* COUNTRY04 between
* @return
*/
public Criteria andCountry04Between(String value1, String value2)
{
addCriterion("COUNTRY04",false,Operation.BETWEEN,value1,value2);
return (Criteria) this;
}
/**
* COUNTRY04 not between
* @return
*/
public Criteria andCountry04NotBetween(String value1, String value2)
{
addCriterion("COUNTRY04",false,Operation.NOTBETWEEN,value1,value2);
return (Criteria) this;
}
/**
* upper(COUNTRY04) like '%value.toUpperCase()%'
* @return
*/
public Criteria andCountry04LikeInsensitive(String value)
{
addCriterion("COUNTRY04",false,Operation.LIKEIC,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_CODE is null
* @return
*/
public Criteria andFruitOrderCodeIsNull()
{
addCriterion("FRUIT_ORDER_CODE",false,Operation.ISNULL,new Object[] {});
return (Criteria) this;
}
/**
* FRUIT_ORDER_CODE is not null
* @return
*/
public Criteria andFruitOrderCodeIsNotNull()
{
addCriterion("FRUIT_ORDER_CODE",false,Operation.ISNOTNULL,new Object[] {});
return (Criteria) this;
}
/**
* FRUIT_ORDER_CODE =
* @return
*/
public Criteria andFruitOrderCodeEqualTo(String value)
{
addCriterion("FRUIT_ORDER_CODE",false,Operation.EQ,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_CODE <>
* @return
*/
public Criteria andFruitOrderCodeNotEqualTo(String value)
{
addCriterion("FRUIT_ORDER_CODE",false,Operation.NOTEQ,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_CODE >
* @return
*/
public Criteria andFruitOrderCodeGreaterThan(String value)
{
addCriterion("FRUIT_ORDER_CODE",false,Operation.GT,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_CODE >=
* @return
*/
public Criteria andFruitOrderCodeGreaterThanOrEqualTo(String value)
{
addCriterion("FRUIT_ORDER_CODE",false,Operation.GE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_CODE <
* @return
*/
public Criteria andFruitOrderCodeLessThan(String value)
{
addCriterion("FRUIT_ORDER_CODE",false,Operation.LT,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_CODE <=
* @return
*/
public Criteria andFruitOrderCodeLessThanOrEqualTo(String value)
{
addCriterion("FRUIT_ORDER_CODE",false,Operation.LE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_CODE like
* @return
*/
public Criteria andFruitOrderCodeLike(String value)
{
addCriterion("FRUIT_ORDER_CODE",false,Operation.LIKE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_CODE not like
* @return
*/
public Criteria andFruitOrderCodeNotLike(String value)
{
addCriterion("FRUIT_ORDER_CODE",false,Operation.NOTLIKE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_ORDER_CODE in
* @return
*/
public Criteria andFruitOrderCodeIn(List<String> values)
{
addCriterion("FRUIT_ORDER_CODE",false,Operation.IN,values);
return (Criteria) this;
}
/**
* FRUIT_ORDER_CODE not in
* @return
*/
public Criteria andFruitOrderCodeNotIn(List<String> values)
{
addCriterion("FRUIT_ORDER_CODE",false,Operation.NOTIN,values);
return (Criteria) this;
}
/**
* FRUIT_ORDER_CODE between
* @return
*/
public Criteria andFruitOrderCodeBetween(String value1, String value2)
{
addCriterion("FRUIT_ORDER_CODE",false,Operation.BETWEEN,value1,value2);
return (Criteria) this;
}
/**
* FRUIT_ORDER_CODE not between
* @return
*/
public Criteria andFruitOrderCodeNotBetween(String value1, String value2)
{
addCriterion("FRUIT_ORDER_CODE",false,Operation.NOTBETWEEN,value1,value2);
return (Criteria) this;
}
/**
* upper(FRUIT_ORDER_CODE) like '%value.toUpperCase()%'
* @return
*/
public Criteria andFruitOrderCodeLikeInsensitive(String value)
{
addCriterion("FRUIT_ORDER_CODE",false,Operation.LIKEIC,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY03 is null
* @return
*/
public Criteria andCountry03IsNull()
{
addCriterion("COUNTRY03",false,Operation.ISNULL,new Object[] {});
return (Criteria) this;
}
/**
* COUNTRY03 is not null
* @return
*/
public Criteria andCountry03IsNotNull()
{
addCriterion("COUNTRY03",false,Operation.ISNOTNULL,new Object[] {});
return (Criteria) this;
}
/**
* COUNTRY03 =
* @return
*/
public Criteria andCountry03EqualTo(String value)
{
addCriterion("COUNTRY03",false,Operation.EQ,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY03 <>
* @return
*/
public Criteria andCountry03NotEqualTo(String value)
{
addCriterion("COUNTRY03",false,Operation.NOTEQ,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY03 >
* @return
*/
public Criteria andCountry03GreaterThan(String value)
{
addCriterion("COUNTRY03",false,Operation.GT,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY03 >=
* @return
*/
public Criteria andCountry03GreaterThanOrEqualTo(String value)
{
addCriterion("COUNTRY03",false,Operation.GE,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY03 <
* @return
*/
public Criteria andCountry03LessThan(String value)
{
addCriterion("COUNTRY03",false,Operation.LT,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY03 <=
* @return
*/
public Criteria andCountry03LessThanOrEqualTo(String value)
{
addCriterion("COUNTRY03",false,Operation.LE,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY03 like
* @return
*/
public Criteria andCountry03Like(String value)
{
addCriterion("COUNTRY03",false,Operation.LIKE,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY03 not like
* @return
*/
public Criteria andCountry03NotLike(String value)
{
addCriterion("COUNTRY03",false,Operation.NOTLIKE,new Object[] {value});
return (Criteria) this;
}
/**
* COUNTRY03 in
* @return
*/
public Criteria andCountry03In(List<String> values)
{
addCriterion("COUNTRY03",false,Operation.IN,values);
return (Criteria) this;
}
/**
* COUNTRY03 not in
* @return
*/
public Criteria andCountry03NotIn(List<String> values)
{
addCriterion("COUNTRY03",false,Operation.NOTIN,values);
return (Criteria) this;
}
/**
* COUNTRY03 between
* @return
*/
public Criteria andCountry03Between(String value1, String value2)
{
addCriterion("COUNTRY03",false,Operation.BETWEEN,value1,value2);
return (Criteria) this;
}
/**
* COUNTRY03 not between
* @return
*/
public Criteria andCountry03NotBetween(String value1, String value2)
{
addCriterion("COUNTRY03",false,Operation.NOTBETWEEN,value1,value2);
return (Criteria) this;
}
/**
* upper(COUNTRY03) like '%value.toUpperCase()%'
* @return
*/
public Criteria andCountry03LikeInsensitive(String value)
{
addCriterion("COUNTRY03",false,Operation.LIKEIC,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_BOOKNUM is null
* @return
*/
public Criteria andFruitBooknumIsNull()
{
addCriterion("FRUIT_BOOKNUM",false,Operation.ISNULL,new Object[] {});
return (Criteria) this;
}
/**
* FRUIT_BOOKNUM is not null
* @return
*/
public Criteria andFruitBooknumIsNotNull()
{
addCriterion("FRUIT_BOOKNUM",false,Operation.ISNOTNULL,new Object[] {});
return (Criteria) this;
}
/**
* FRUIT_BOOKNUM =
* @return
*/
public Criteria andFruitBooknumEqualTo(BigDecimal value)
{
addCriterion("FRUIT_BOOKNUM",false,Operation.EQ,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_BOOKNUM <>
* @return
*/
public Criteria andFruitBooknumNotEqualTo(BigDecimal value)
{
addCriterion("FRUIT_BOOKNUM",false,Operation.NOTEQ,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_BOOKNUM >
* @return
*/
public Criteria andFruitBooknumGreaterThan(BigDecimal value)
{
addCriterion("FRUIT_BOOKNUM",false,Operation.GT,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_BOOKNUM >=
* @return
*/
public Criteria andFruitBooknumGreaterThanOrEqualTo(BigDecimal value)
{
addCriterion("FRUIT_BOOKNUM",false,Operation.GE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_BOOKNUM <
* @return
*/
public Criteria andFruitBooknumLessThan(BigDecimal value)
{
addCriterion("FRUIT_BOOKNUM",false,Operation.LT,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_BOOKNUM <=
* @return
*/
public Criteria andFruitBooknumLessThanOrEqualTo(BigDecimal value)
{
addCriterion("FRUIT_BOOKNUM",false,Operation.LE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_BOOKNUM like
* @return
*/
public Criteria andFruitBooknumLike(BigDecimal value)
{
addCriterion("FRUIT_BOOKNUM",false,Operation.LIKE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_BOOKNUM not like
* @return
*/
public Criteria andFruitBooknumNotLike(BigDecimal value)
{
addCriterion("FRUIT_BOOKNUM",false,Operation.NOTLIKE,new Object[] {value});
return (Criteria) this;
}
/**
* FRUIT_BOOKNUM in
* @return
*/
public Criteria andFruitBooknumIn(List<BigDecimal> values)
{
addCriterion("FRUIT_BOOKNUM",false,Operation.IN,values);
return (Criteria) this;
}
/**
* FRUIT_BOOKNUM not in
* @return
*/
public Criteria andFruitBooknumNotIn(List<BigDecimal> values)
{
addCriterion("FRUIT_BOOKNUM",false,Operation.NOTIN,values);
return (Criteria) this;
}
/**
* FRUIT_BOOKNUM between
* @return
*/
public Criteria andFruitBooknumBetween(BigDecimal value1, BigDecimal value2)
{
addCriterion("FRUIT_BOOKNUM",false,Operation.BETWEEN,value1,value2);
return (Criteria) this;
}
/**
* FRUIT_BOOKNUM not between
* @return
*/
public Criteria andFruitBooknumNotBetween(BigDecimal value1, BigDecimal value2)
{
addCriterion("FRUIT_BOOKNUM",false,Operation.NOTBETWEEN,value1,value2);
return (Criteria) this;
}
/**
* upper(FRUIT_BOOKNUM) like '%value.toUpperCase()%'
* @return
*/
public Criteria andFruitBooknumLikeInsensitive(BigDecimal value)
{
addCriterion("FRUIT_BOOKNUM",false,Operation.LIKEIC,new Object[] {value});
return (Criteria) this;
}
}
}
1.9.服务接口
/*
* @(#)TestOrderService.java
* 版权声明 厦门吉联科技, 版权所有 违者必究
*
*修订记录:
*1)更改者：java业务平台代码生成工具
* 时 间：2018年07月25日 11点35分23秒
* 描 述：创建
*/
package com.gillion.oms.samle.service;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.io.Serializable;
import com.gillion.platform.framework.core.service.IBaseService;
import com.gillion.platform.bo.domain.BusinessObject;
import com.gillion.oms.samle.domain.TestOrder;
import com.gillion.oms.samle.domain.TestOrderExample;
import com.gillion.platform.framework.core.query.Page;
import com.gillion.platform.framework.core.query.PageRequest;
import com.gillion.eds.core.annotations.Consumer;
import com.gillion.eds.core.annotations.Version;
/**
* <pre>
* 订单TestOrder(TestOrder)服务类接口
* </pre>
*
* <br>
* JDK版本:1.5
*
* @author java业务平台代码生成工具
* @version 1.0
* @see The author for more details
* @since 1.0
*/
@Consumer
@Version("1.0.0")
@SuppressWarnings("all")
public interface TestOrderService extends IBaseService<String,TestOrder,TestOrderExample>
{
/**
* TODO GLPaaS生成
* 根据主键值删除订单TestOrder
*
* @param id
*/
public void delete(String id);
/**
* TODO GLPaaS生成
* 根据主键列表，删除订单TestOrder
*
* @param id
*/
public void delete(String id,boolean isLogic);
/**
* 保存并提交 订单TestOrder
*
* @param ids
* @return
* @
*/
public void submitProcess(TestOrder testOrder);
/**
* TODO GLPaaS生成
* 批量修改保存订单TestOrder
*
* @param testOrders
* @return
* @
*/
public List<TestOrder> saveOrUpdates(List<TestOrder> testOrders);
/**
* TODO GLPaaS生成
* 新增保存订单TestOrder
*
* @param testOrder
* @return
* @
*/
public int save(TestOrder testOrder);
/**
* TODO GLPaaS生成
* 保存订单TestOrder
*
* @param ids
* @return
* @
*/
public int saveOrUpdate(TestOrder testOrder);
/**
* TODO GLPaaS生成
* 修改保存订单TestOrder
*
* @param testOrder
* @return
* @
*/
public int update(TestOrder testOrder);
public List<TestOrder> find(TestOrderExample example);
public Page<TestOrder> find(PageRequest pageRequest, TestOrderExample example);
/**
* TODO GLPaaS生成
* 保存并提交 订单TestOrder
*
* @param ids
* @return
* @
*/
public void saveAndSubmitProcess(TestOrder testOrder);
/**
* TODO GLPaaS生成
* 根据主键获取订单TestOrder
*
* @param testOrders
* @return
* @
*/
public TestOrder get(String fruitOrderId);
/**
* TODO GLPaaS生成
* 根据主键列表，批量删除订单TestOrder
*
* @param ids
*/
public void deletes(String[] ids);
/**
* TODO GLPaaS生成
* 根据主键列表，批量删除订单TestOrder
*
* @param classz
* @param ids
*/
public void deletes(String[] ids,boolean isLogic);
/**
* TODO GLPaaS生成
* 批量恢复 订单TestOrder
*
* @param ids
*/
public void recoveryDeleted(List<TestOrder> testOrders);
}
1.10.Mapper.java
/*
* @(#)TestOrderMapperMapper.java
* 版权声明 厦门吉联科技, 版权所有 违者必究
*
*修订记录:
*1)更改者：java业务平台代码生成工具
* 时 间：2018年07月25日 11点35分23秒
* 描 述：创建
*/
package com.gillion.oms.samle.mapper;
import com.gfa4j.mybatis.mapper.BaseMapper;
import com.gillion.oms.samle.domain.TestOrder;
import com.gillion.oms.samle.domain.TestOrderExample;
import java.util.List;
import java.util.Map;
/**
* <pre>
* 订单TestOrder(TestOrder)Mapper类
* </pre>
*
* <br>
* JDK版本:1.6
*
* @author java业务平台代码生成工具
* @version 1.0
* @see The author for more details
*/
public interface TestOrderMapper extends BaseMapper<String, TestOrder, TestOrderExample>
{
}
1.11.Mapper.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.gillion.oms.samle.mapper.TestOrderMapper" >
<resultMap id="BaseResultMap" type="com.gillion.oms.samle.domain.TestOrder" >
<id column="FRUIT_ORDER_ID" property="fruitOrderId" jdbcType="VARCHAR" />
<result column="FRUIT_ORDER_STATUS" property="fruitOrderStatus" jdbcType="VARCHAR"/>
<result column="CREATE_TIME_ZONE" property="createTimeZone" jdbcType="VARCHAR"/>
<result column="LAST_MODIFY_TIME_ZONE" property="lastModifyTimeZone" jdbcType="VARCHAR"/>
<result column="COUNTRY01" property="country01" jdbcType="VARCHAR"/>
<result column="IS_DELETED" property="isDeleted" jdbcType="VARCHAR"/>
<result column="CREATE_OFFICE" property="createOffice" jdbcType="VARCHAR"/>
<result column="LAST_MODIFY_TIME" property="lastModifyTime" jdbcType="VARCHAR"/>
<result column="LAST_MODIFY_OFFICE" property="lastModifyOffice" jdbcType="VARCHAR"/>
<result column="LAST_MODIFYOR" property="lastModifyor" jdbcType="VARCHAR"/>
<result column="FRUIT_ORDER_SENDER_ID" property="fruitOrderSenderId" jdbcType="VARCHAR"/>
<result column="CREATE_TIME" property="createTime" jdbcType="VARCHAR"/>
<result column="CREATOR" property="creator" jdbcType="VARCHAR"/>
<result column="RECORD_VERSION" property="recordVersion" jdbcType="NUMERIC"/>
<result column="PROCESS_STATE" property="processState" jdbcType="VARCHAR"/>
<result column="FRUIT_ORDER_RECEIVER" property="fruitOrderReceiver" jdbcType="VARCHAR"/>
<result column="FRUIT_ORDER_REMARK" property="fruitOrderRemark" jdbcType="VARCHAR"/>
<result column="COUNTRY02" property="country02" jdbcType="VARCHAR"/>
<result column="FRUIT_ORDER_TIME" property="fruitOrderTime" jdbcType="VARCHAR"/>
<result column="PRINCIPAL_GROUP_CODE" property="principalGroupCode" jdbcType="VARCHAR"/>
<result column="FRUIT_ORDER_SENDER_NAME" property="fruitOrderSenderName" jdbcType="VARCHAR"/>
<result column="FRUIT_GROSS_WEIGHT" property="fruitGrossWeight" jdbcType="NUMERIC"/>
<result column="COUNTRY04" property="country04" jdbcType="VARCHAR"/>
<result column="FRUIT_ORDER_CODE" property="fruitOrderCode" jdbcType="VARCHAR"/>
<result column="COUNTRY03" property="country03" jdbcType="VARCHAR"/>
<result column="FRUIT_BOOKNUM" property="fruitBooknum" jdbcType="NUMERIC"/>
</resultMap>
<sql id="Example_Where_Clause" >
<where>
<foreach collection="oredCriteria" item="criteria">
<if test="criteria.valid" >
${criteria.op}
<trim prefix="(" suffix=")" prefixOverrides="and|or" >
<foreach collection="criteria.criteria" item="criterion" >
<choose >
<when test="criterion.complex" >
${criteria.nop} ${criterion.condition}
</when>
<when test="criterion.noValue" >
${criteria.nop} ${criterion.condition}
</when>
<when test="criterion.singleValue" >
${criteria.nop} ${criterion.condition} ${criterion.valueExpression}
</when>
<when test="criterion.rangeValue" >
${criteria.nop} (
<if test="criterion.value" >
${criterion.condition} ><if test="criterion.operation == 'GELE'">=</if> ${criterion.valueExpression}
</if>
<if test="criterion.secondValue" >
<if test="criterion.value"> and </if>${criterion.condition} <<if test="criterion.operation == 'GELE'">=</if> ${criterion.secondValueExpression}
</if>)
</when>
<when test="criterion.betweenValue" >
${criteria.nop} ${criterion.condition} ${criterion.valueExpression} and ${criterion.secondValueExpression}
</when>
<when test="criterion.listValue" >
${criteria.nop} ${criterion.condition}
<foreach collection="criterion.value" item="listItem" open="(" close=")" separator="," >
${criterion.listValueExpression}
</foreach>
</when>
</choose>
</foreach>
</trim>
</if>
</foreach>
<if test="junctionSql != null" >
${junctionSql.parserSql}
</if>
</where>
</sql>
<sql id="Update_By_Example_Where_Clause" >
<where >
<foreach collection="example.oredCriteria" item="criteria">
<if test="criteria.valid" >
${criteria.op}
<trim prefix="(" suffix=")" prefixOverrides="and|or" >
<foreach collection="criteria.criteria" item="criterion" >
<choose >
<when test="criterion.complex" >
${criteria.nop} ${criterion.condition}
</when>
<when test="criterion.noValue" >
${criteria.nop} ${criterion.condition}
</when>
<when test="criterion.singleValue" >
${criteria.nop} ${criterion.condition} ${criterion.valueExpression}
</when>
<when test="criterion.rangeValue" >
${criteria.nop} (
<if test="criterion.value" >
${criterion.condition} ><if test="criterion.operation == 'GELE'">=</if> ${criterion.valueExpression}
</if>
<if test="criterion.secondValue" >
<if test="criterion.value"> and </if>${criterion.condition} <<if test="criterion.operation == 'GELE'">=</if> ${criterion.secondValueExpression}
</if>)
</when>
<when test="criterion.betweenValue" >
${criteria.nop} ${criterion.condition} ${criterion.valueExpression} and ${criterion.secondValueExpression}
</when>
<when test="criterion.listValue" >
${criteria.nop} ${criterion.condition}
<foreach collection="criterion.value" item="listItem" open="(" close=")" separator="," >
${criterion.listValueExpression}
</foreach>
</when>
</choose>
</foreach>
</trim>
</if>
</foreach>
<if test="example.junctionSql != null" >
${example.junctionSql.parserSql}
</if>
</where>
</sql>
<sql id="Base_Column_List" >
FRUIT_ORDER_STATUS,
CREATE_TIME_ZONE,
LAST_MODIFY_TIME_ZONE,
COUNTRY01,
IS_DELETED,
CREATE_OFFICE,
LAST_MODIFY_TIME,
LAST_MODIFY_OFFICE,
LAST_MODIFYOR,
FRUIT_ORDER_SENDER_ID,
CREATE_TIME,
CREATOR,
RECORD_VERSION,
PROCESS_STATE,
FRUIT_ORDER_RECEIVER,
FRUIT_ORDER_REMARK,
FRUIT_ORDER_ID,
COUNTRY02,
FRUIT_ORDER_TIME,
PRINCIPAL_GROUP_CODE,
FRUIT_ORDER_SENDER_NAME,
FRUIT_GROSS_WEIGHT,
COUNTRY04,
FRUIT_ORDER_CODE,
COUNTRY03,
FRUIT_BOOKNUM
</sql>
<select id="selectByExample" resultMap="BaseResultMap" parameterType="com.gillion.oms.samle.domain.TestOrderExample" >
<include refid="OraclePaginationPrefix" />
select
<if test="distinct" >
distinct
</if>
<include refid="Base_Column_List" />
from FRUIT_ORDER
<if test="_parameter != null" >
<include refid="Example_Where_Clause" />
</if>
<if test="orderByClause != null and orderByClause != ''" >
order by ${orderByClause}
</if>
<include refid="OraclePaginationSuffix" />
</select>
<select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.String" >
select
<include refid="Base_Column_List" />
from FRUIT_ORDER
where FRUIT_ORDER_ID = #{fruitOrderId,jdbcType=VARCHAR}
</select>
<delete id="deleteByPrimaryKey" parameterType="java.lang.String" >
delete from FRUIT_ORDER
where FRUIT_ORDER_ID = #{fruitOrderId,jdbcType=VARCHAR}
</delete>
<delete id="deleteByExample" parameterType="com.gillion.oms.samle.domain.TestOrderExample" >
delete from FRUIT_ORDER
<if test="_parameter != null" >
<include refid="Example_Where_Clause" />
</if>
</delete>
<insert id="insert" parameterType="com.gillion.oms.samle.domain.TestOrder" >
insert into FRUIT_ORDER (
COUNTRY01,
COUNTRY02,
COUNTRY03,
COUNTRY04,
CREATE_OFFICE,
CREATE_TIME,
CREATE_TIME_ZONE,
CREATOR,
FRUIT_BOOKNUM,
FRUIT_GROSS_WEIGHT,
FRUIT_ORDER_CODE,
FRUIT_ORDER_ID,
FRUIT_ORDER_RECEIVER,
FRUIT_ORDER_REMARK,
FRUIT_ORDER_SENDER_ID,
FRUIT_ORDER_SENDER_NAME,
FRUIT_ORDER_STATUS,
FRUIT_ORDER_TIME,
IS_DELETED,
LAST_MODIFY_OFFICE,
LAST_MODIFYOR,
LAST_MODIFY_TIME,
LAST_MODIFY_TIME_ZONE,
PRINCIPAL_GROUP_CODE,
PROCESS_STATE,
RECORD_VERSION
)
values (
#{country01,jdbcType=VARCHAR},
#{country02,jdbcType=VARCHAR},
#{country03,jdbcType=VARCHAR},
#{country04,jdbcType=VARCHAR},
#{createOffice,jdbcType=VARCHAR},
#{createTime,jdbcType=VARCHAR},
#{createTimeZone,jdbcType=VARCHAR},
#{creator,jdbcType=VARCHAR},
#{fruitBooknum,jdbcType=NUMERIC},
#{fruitGrossWeight,jdbcType=NUMERIC},
#{fruitOrderCode,jdbcType=VARCHAR},
#{fruitOrderId,jdbcType=VARCHAR},
#{fruitOrderReceiver,jdbcType=VARCHAR},
#{fruitOrderRemark,jdbcType=VARCHAR},
#{fruitOrderSenderId,jdbcType=VARCHAR},
#{fruitOrderSenderName,jdbcType=VARCHAR},
#{fruitOrderStatus,jdbcType=VARCHAR},
#{fruitOrderTime,jdbcType=VARCHAR},
#{isDeleted,jdbcType=VARCHAR},
#{lastModifyOffice,jdbcType=VARCHAR},
#{lastModifyor,jdbcType=VARCHAR},
#{lastModifyTime,jdbcType=VARCHAR},
#{lastModifyTimeZone,jdbcType=VARCHAR},
#{principalGroupCode,jdbcType=VARCHAR},
#{processState,jdbcType=VARCHAR},
#{recordVersion,jdbcType=NUMERIC}
)
</insert>
<insert id="insertSelective" parameterType="com.gillion.oms.samle.domain.TestOrder" >
insert into FRUIT_ORDER
<trim prefix="(" suffix=")" suffixOverrides="," >
<if test="country01 != null" >
COUNTRY01,
</if>
<if test="country02 != null" >
COUNTRY02,
</if>
<if test="country03 != null" >
COUNTRY03,
</if>
<if test="country04 != null" >
COUNTRY04,
</if>
<if test="createOffice != null" >
CREATE_OFFICE,
</if>
<if test="createTime != null" >
CREATE_TIME,
</if>
<if test="createTimeZone != null" >
CREATE_TIME_ZONE,
</if>
<if test="creator != null" >
CREATOR,
</if>
<if test="fruitBooknum != null" >
FRUIT_BOOKNUM,
</if>
<if test="fruitGrossWeight != null" >
FRUIT_GROSS_WEIGHT,
</if>
<if test="fruitOrderCode != null" >
FRUIT_ORDER_CODE,
</if>
<if test="fruitOrderId != null" >
FRUIT_ORDER_ID,
</if>
<if test="fruitOrderReceiver != null" >
FRUIT_ORDER_RECEIVER,
</if>
<if test="fruitOrderRemark != null" >
FRUIT_ORDER_REMARK,
</if>
<if test="fruitOrderSenderId != null" >
FRUIT_ORDER_SENDER_ID,
</if>
<if test="fruitOrderSenderName != null" >
FRUIT_ORDER_SENDER_NAME,
</if>
<if test="fruitOrderStatus != null" >
FRUIT_ORDER_STATUS,
</if>
<if test="fruitOrderTime != null" >
FRUIT_ORDER_TIME,
</if>
<if test="isDeleted != null" >
IS_DELETED,
</if>
<if test="lastModifyOffice != null" >
LAST_MODIFY_OFFICE,
</if>
<if test="lastModifyor != null" >
LAST_MODIFYOR,
</if>
<if test="lastModifyTime != null" >
LAST_MODIFY_TIME,
</if>
<if test="lastModifyTimeZone != null" >
LAST_MODIFY_TIME_ZONE,
</if>
<if test="principalGroupCode != null" >
PRINCIPAL_GROUP_CODE,
</if>
<if test="processState != null" >
PROCESS_STATE,
</if>
<if test="recordVersion != null" >
RECORD_VERSION,
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides="," >
<if test="country01 != null" >
#{country01,jdbcType=VARCHAR},
</if>
<if test="country02 != null" >
#{country02,jdbcType=VARCHAR},
</if>
<if test="country03 != null" >
#{country03,jdbcType=VARCHAR},
</if>
<if test="country04 != null" >
#{country04,jdbcType=VARCHAR},
</if>
<if test="createOffice != null" >
#{createOffice,jdbcType=VARCHAR},
</if>
<if test="createTime != null" >
#{createTime,jdbcType=VARCHAR},
</if>
<if test="createTimeZone != null" >
#{createTimeZone,jdbcType=VARCHAR},
</if>
<if test="creator != null" >
#{creator,jdbcType=VARCHAR},
</if>
<if test="fruitBooknum != null" >
#{fruitBooknum,jdbcType=NUMERIC},
</if>
<if test="fruitGrossWeight != null" >
#{fruitGrossWeight,jdbcType=NUMERIC},
</if>
<if test="fruitOrderCode != null" >
#{fruitOrderCode,jdbcType=VARCHAR},
</if>
<if test="fruitOrderId != null" >
#{fruitOrderId,jdbcType=VARCHAR},
</if>
<if test="fruitOrderReceiver != null" >
#{fruitOrderReceiver,jdbcType=VARCHAR},
</if>
<if test="fruitOrderRemark != null" >
#{fruitOrderRemark,jdbcType=VARCHAR},
</if>
<if test="fruitOrderSenderId != null" >
#{fruitOrderSenderId,jdbcType=VARCHAR},
</if>
<if test="fruitOrderSenderName != null" >
#{fruitOrderSenderName,jdbcType=VARCHAR},
</if>
<if test="fruitOrderStatus != null" >
#{fruitOrderStatus,jdbcType=VARCHAR},
</if>
<if test="fruitOrderTime != null" >
#{fruitOrderTime,jdbcType=VARCHAR},
</if>
<if test="isDeleted != null" >
#{isDeleted,jdbcType=VARCHAR},
</if>
<if test="lastModifyOffice != null" >
#{lastModifyOffice,jdbcType=VARCHAR},
</if>
<if test="lastModifyor != null" >
#{lastModifyor,jdbcType=VARCHAR},
</if>
<if test="lastModifyTime != null" >
#{lastModifyTime,jdbcType=VARCHAR},
</if>
<if test="lastModifyTimeZone != null" >
#{lastModifyTimeZone,jdbcType=VARCHAR},
</if>
<if test="principalGroupCode != null" >
#{principalGroupCode,jdbcType=VARCHAR},
</if>
<if test="processState != null" >
#{processState,jdbcType=VARCHAR},
</if>
<if test="recordVersion != null" >
#{recordVersion,jdbcType=NUMERIC},
</if>
</trim>
</insert>
<select id="countByExample" parameterType="com.gillion.oms.samle.domain.TestOrderExample" resultType="java.lang.Integer" >
select count(*) from FRUIT_ORDER
<if test="_parameter != null" >
<include refid="Example_Where_Clause" />
</if>
</select>
<update id="updateByExampleSelective" parameterType="map" >
update FRUIT_ORDER
<set >
<if test="record.country01 != null" >
COUNTRY01 = #{record.country01,jdbcType=VARCHAR},
</if>
<if test="record.country02 != null" >
COUNTRY02 = #{record.country02,jdbcType=VARCHAR},
</if>
<if test="record.country03 != null" >
COUNTRY03 = #{record.country03,jdbcType=VARCHAR},
</if>
<if test="record.country04 != null" >
COUNTRY04 = #{record.country04,jdbcType=VARCHAR},
</if>
<if test="record.createOffice != null" >
CREATE_OFFICE = #{record.createOffice,jdbcType=VARCHAR},
</if>
<if test="record.createTime != null" >
CREATE_TIME = #{record.createTime,jdbcType=VARCHAR},
</if>
<if test="record.createTimeZone != null" >
CREATE_TIME_ZONE = #{record.createTimeZone,jdbcType=VARCHAR},
</if>
<if test="record.creator != null" >
CREATOR = #{record.creator,jdbcType=VARCHAR},
</if>
<if test="record.fruitBooknum != null" >
FRUIT_BOOKNUM = #{record.fruitBooknum,jdbcType=NUMERIC},
</if>
<if test="record.fruitGrossWeight != null" >
FRUIT_GROSS_WEIGHT = #{record.fruitGrossWeight,jdbcType=NUMERIC},
</if>
<if test="record.fruitOrderCode != null" >
FRUIT_ORDER_CODE = #{record.fruitOrderCode,jdbcType=VARCHAR},
</if>
<if test="record.fruitOrderReceiver != null" >
FRUIT_ORDER_RECEIVER = #{record.fruitOrderReceiver,jdbcType=VARCHAR},
</if>
<if test="record.fruitOrderRemark != null" >
FRUIT_ORDER_REMARK = #{record.fruitOrderRemark,jdbcType=VARCHAR},
</if>
<if test="record.fruitOrderSenderId != null" >
FRUIT_ORDER_SENDER_ID = #{record.fruitOrderSenderId,jdbcType=VARCHAR},
</if>
<if test="record.fruitOrderSenderName != null" >
FRUIT_ORDER_SENDER_NAME = #{record.fruitOrderSenderName,jdbcType=VARCHAR},
</if>
<if test="record.fruitOrderStatus != null" >
FRUIT_ORDER_STATUS = #{record.fruitOrderStatus,jdbcType=VARCHAR},
</if>
<if test="record.fruitOrderTime != null" >
FRUIT_ORDER_TIME = #{record.fruitOrderTime,jdbcType=VARCHAR},
</if>
<if test="record.isDeleted != null" >
IS_DELETED = #{record.isDeleted,jdbcType=VARCHAR},
</if>
<if test="record.lastModifyOffice != null" >
LAST_MODIFY_OFFICE = #{record.lastModifyOffice,jdbcType=VARCHAR},
</if>
<if test="record.lastModifyor != null" >
LAST_MODIFYOR = #{record.lastModifyor,jdbcType=VARCHAR},
</if>
<if test="record.lastModifyTime != null" >
LAST_MODIFY_TIME = #{record.lastModifyTime,jdbcType=VARCHAR},
</if>
<if test="record.lastModifyTimeZone != null" >
LAST_MODIFY_TIME_ZONE = #{record.lastModifyTimeZone,jdbcType=VARCHAR},
</if>
<if test="record.principalGroupCode != null" >
PRINCIPAL_GROUP_CODE = #{record.principalGroupCode,jdbcType=VARCHAR},
</if>
<if test="record.processState != null" >
PROCESS_STATE = #{record.processState,jdbcType=VARCHAR},
</if>
<if test="record.recordVersion != null" >
RECORD_VERSION = #{record.recordVersion,jdbcType=NUMERIC},
</if>
<if test="record.recordVersion == null" >
RECORD_VERSION = RECORD_VERSION + 1,
</if>
</set>
<if test="_parameter != null" >
<include refid="Update_By_Example_Where_Clause" />
</if>
</update>
<update id="updateByExample" parameterType="map" >
update FRUIT_ORDER set
COUNTRY01 = #{record.country01,jdbcType=VARCHAR},
COUNTRY02 = #{record.country02,jdbcType=VARCHAR},
COUNTRY03 = #{record.country03,jdbcType=VARCHAR},
COUNTRY04 = #{record.country04,jdbcType=VARCHAR},
CREATE_OFFICE = #{record.createOffice,jdbcType=VARCHAR},
CREATE_TIME = #{record.createTime,jdbcType=VARCHAR},
CREATE_TIME_ZONE = #{record.createTimeZone,jdbcType=VARCHAR},
CREATOR = #{record.creator,jdbcType=VARCHAR},
FRUIT_BOOKNUM = #{record.fruitBooknum,jdbcType=NUMERIC},
FRUIT_GROSS_WEIGHT = #{record.fruitGrossWeight,jdbcType=NUMERIC},
FRUIT_ORDER_CODE = #{record.fruitOrderCode,jdbcType=VARCHAR},
FRUIT_ORDER_RECEIVER = #{record.fruitOrderReceiver,jdbcType=VARCHAR},
FRUIT_ORDER_REMARK = #{record.fruitOrderRemark,jdbcType=VARCHAR},
FRUIT_ORDER_SENDER_ID = #{record.fruitOrderSenderId,jdbcType=VARCHAR},
FRUIT_ORDER_SENDER_NAME = #{record.fruitOrderSenderName,jdbcType=VARCHAR},
FRUIT_ORDER_STATUS = #{record.fruitOrderStatus,jdbcType=VARCHAR},
FRUIT_ORDER_TIME = #{record.fruitOrderTime,jdbcType=VARCHAR},
IS_DELETED = #{record.isDeleted,jdbcType=VARCHAR},
LAST_MODIFY_OFFICE = #{record.lastModifyOffice,jdbcType=VARCHAR},
LAST_MODIFYOR = #{record.lastModifyor,jdbcType=VARCHAR},
LAST_MODIFY_TIME = #{record.lastModifyTime,jdbcType=VARCHAR},
LAST_MODIFY_TIME_ZONE = #{record.lastModifyTimeZone,jdbcType=VARCHAR},
PRINCIPAL_GROUP_CODE = #{record.principalGroupCode,jdbcType=VARCHAR},
PROCESS_STATE = #{record.processState,jdbcType=VARCHAR},
RECORD_VERSION = #{record.recordVersion,jdbcType=NUMERIC}
<if test="_parameter != null" >
<include refid="Update_By_Example_Where_Clause" />
</if>
</update>
<update id="updateByPrimaryKeySelective" parameterType="com.gillion.oms.samle.domain.TestOrder" >
update FRUIT_ORDER
<set>
<if test="country01 != null" >
COUNTRY01 = #{country01,jdbcType=VARCHAR},
</if>
<if test="country02 != null" >
COUNTRY02 = #{country02,jdbcType=VARCHAR},
</if>
<if test="country03 != null" >
COUNTRY03 = #{country03,jdbcType=VARCHAR},
</if>
<if test="country04 != null" >
COUNTRY04 = #{country04,jdbcType=VARCHAR},
</if>
<if test="createOffice != null" >
CREATE_OFFICE = #{createOffice,jdbcType=VARCHAR},
</if>
<if test="createTime != null" >
CREATE_TIME = #{createTime,jdbcType=VARCHAR},
</if>
<if test="createTimeZone != null" >
CREATE_TIME_ZONE = #{createTimeZone,jdbcType=VARCHAR},
</if>
<if test="creator != null" >
CREATOR = #{creator,jdbcType=VARCHAR},
</if>
<if test="fruitBooknum != null" >
FRUIT_BOOKNUM = #{fruitBooknum,jdbcType=NUMERIC},
</if>
<if test="fruitGrossWeight != null" >
FRUIT_GROSS_WEIGHT = #{fruitGrossWeight,jdbcType=NUMERIC},
</if>
<if test="fruitOrderCode != null" >
FRUIT_ORDER_CODE = #{fruitOrderCode,jdbcType=VARCHAR},
</if>
<if test="fruitOrderReceiver != null" >
FRUIT_ORDER_RECEIVER = #{fruitOrderReceiver,jdbcType=VARCHAR},
</if>
<if test="fruitOrderRemark != null" >
FRUIT_ORDER_REMARK = #{fruitOrderRemark,jdbcType=VARCHAR},
</if>
<if test="fruitOrderSenderId != null" >
FRUIT_ORDER_SENDER_ID = #{fruitOrderSenderId,jdbcType=VARCHAR},
</if>
<if test="fruitOrderSenderName != null" >
FRUIT_ORDER_SENDER_NAME = #{fruitOrderSenderName,jdbcType=VARCHAR},
</if>
<if test="fruitOrderStatus != null" >
FRUIT_ORDER_STATUS = #{fruitOrderStatus,jdbcType=VARCHAR},
</if>
<if test="fruitOrderTime != null" >
FRUIT_ORDER_TIME = #{fruitOrderTime,jdbcType=VARCHAR},
</if>
<if test="isDeleted != null" >
IS_DELETED = #{isDeleted,jdbcType=VARCHAR},
</if>
<if test="lastModifyOffice != null" >
LAST_MODIFY_OFFICE = #{lastModifyOffice,jdbcType=VARCHAR},
</if>
<if test="lastModifyor != null" >
LAST_MODIFYOR = #{lastModifyor,jdbcType=VARCHAR},
</if>
<if test="lastModifyTime != null" >
LAST_MODIFY_TIME = #{lastModifyTime,jdbcType=VARCHAR},
</if>
<if test="lastModifyTimeZone != null" >
LAST_MODIFY_TIME_ZONE = #{lastModifyTimeZone,jdbcType=VARCHAR},
</if>
<if test="principalGroupCode != null" >
PRINCIPAL_GROUP_CODE = #{principalGroupCode,jdbcType=VARCHAR},
</if>
<if test="processState != null" >
PROCESS_STATE = #{processState,jdbcType=VARCHAR},
</if>
<if test="recordVersion != null" >
RECORD_VERSION = #{recordVersion,jdbcType=NUMERIC},
</if>
</set>
where FRUIT_ORDER_ID = #{fruitOrderId,jdbcType=VARCHAR}
</update>
<update id="updateByPrimaryKey" parameterType="com.gillion.oms.samle.domain.TestOrder" >
update FRUIT_ORDER set
COUNTRY01 = #{country01,jdbcType=VARCHAR},
COUNTRY02 = #{country02,jdbcType=VARCHAR},
COUNTRY03 = #{country03,jdbcType=VARCHAR},
COUNTRY04 = #{country04,jdbcType=VARCHAR},
CREATE_OFFICE = #{createOffice,jdbcType=VARCHAR},
CREATE_TIME = #{createTime,jdbcType=VARCHAR},
CREATE_TIME_ZONE = #{createTimeZone,jdbcType=VARCHAR},
CREATOR = #{creator,jdbcType=VARCHAR},
FRUIT_BOOKNUM = #{fruitBooknum,jdbcType=NUMERIC},
FRUIT_GROSS_WEIGHT = #{fruitGrossWeight,jdbcType=NUMERIC},
FRUIT_ORDER_CODE = #{fruitOrderCode,jdbcType=VARCHAR},
FRUIT_ORDER_RECEIVER = #{fruitOrderReceiver,jdbcType=VARCHAR},
FRUIT_ORDER_REMARK = #{fruitOrderRemark,jdbcType=VARCHAR},
FRUIT_ORDER_SENDER_ID = #{fruitOrderSenderId,jdbcType=VARCHAR},
FRUIT_ORDER_SENDER_NAME = #{fruitOrderSenderName,jdbcType=VARCHAR},
FRUIT_ORDER_STATUS = #{fruitOrderStatus,jdbcType=VARCHAR},
FRUIT_ORDER_TIME = #{fruitOrderTime,jdbcType=VARCHAR},
IS_DELETED = #{isDeleted,jdbcType=VARCHAR},
LAST_MODIFY_OFFICE = #{lastModifyOffice,jdbcType=VARCHAR},
LAST_MODIFYOR = #{lastModifyor,jdbcType=VARCHAR},
LAST_MODIFY_TIME = #{lastModifyTime,jdbcType=VARCHAR},
LAST_MODIFY_TIME_ZONE = #{lastModifyTimeZone,jdbcType=VARCHAR},
PRINCIPAL_GROUP_CODE = #{principalGroupCode,jdbcType=VARCHAR},
PROCESS_STATE = #{processState,jdbcType=VARCHAR},
RECORD_VERSION = #{recordVersion,jdbcType=NUMERIC}
where FRUIT_ORDER_ID = #{fruitOrderId,jdbcType=VARCHAR}
</update>
<sql id="OraclePaginationPrefix" >
<if test="page != null" >
select * from ( select row_.*, rownum rownum_ from (
</if>
</sql>
<sql id="OraclePaginationSuffix" >
<if test="page != null" >
<![CDATA[ ) row_ ) where rownum_ >= #{page.recordStart} and rownum_ <= #{page.recordEnd} ]]>
</if>
</sql>
</mapper>
1.12.服务实现类
/*
* @(#)TestOrderServiceImpl.java
* 版权声明 厦门吉联科技, 版权所有 违者必究
*
*修订记录:
*1)更改者：java业务平台代码生成工具
* 时 间：2018年07月25日 11点35分23秒
* 描 述：创建
*/
package com.gillion.oms.samle.service;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Arrays;
import java.util.Map;
import java.util.HashSet;
import java.util.Set;
import java.util.Collection;
import java.io.Serializable;
import org.springframework.stereotype.Service;
import org.springframework.util.*;
import com.fasterxml.jackson.databind.JavaType;
import com.gillion.platform.utils.BaseViewUtils;
import com.gillion.platform.utils.json.JsonMapper;
import com.gillion.platform.utils.StringUtils;
import com.gillion.platform.utils.SpringContextHolder;
import com.gillion.platform.bo.domain.BusinessObject;
import com.gillion.platform.bo.service.impl.BusinessObjectService;
import com.gillion.platform.bizrule.core.domain.InvokeTime;
import com.gillion.platform.bizrule.core.domain.RuleInfo;
import com.gillion.platform.bizrule.core.util.DroolsUtils;
import com.gillion.platform.framework.core.service.BaseServiceImplExt;
import com.gillion.platform.framework.core.BusinessException;
import com.gillion.platform.framework.core.domain.BaseObject;
import com.gillion.platform.framework.core.query.Page;
import com.gillion.platform.framework.core.query.PageRequest;
import com.gillion.platform.framework.core.query.Operation;
import com.gillion.platform.framework.core.query.Criteria;
import com.gillion.platform.framework.core.query.OrderColumn;
import com.gillion.oms.samle.domain.TestOrder;
import com.gillion.oms.samle.service.TestOrderService;
import com.gillion.oms.samle.domain.TestOrderExample;
import com.gillion.oms.samle.mapper.TestOrderMapper;
import com.google.common.collect.*;
import com.google.common.base.Function;
import com.gillion.platform.bizrule.core.service.RuleService;
import net.sf.json.JSONObject;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import java.math.BigDecimal;
import com.gillion.eds.core.annotations.Provider;
import com.gillion.eds.core.annotations.Version;
/**
* <pre>
* 订单TestOrder(TestOrder)服务类
* </pre>
*
* <br>
* JDK版本:1.5
*
* @author java业务平台代码生成工具
* @version 1.0
* @see The author for more details
* @since 1.0
*/
@Provider(TestOrderService.class)
@Version("1.0.0")
@SuppressWarnings("all")
public class TestOrderServiceImpl extends BaseServiceImplExt<String,TestOrder,TestOrderExample> implements TestOrderService
{
protected static final String boName = "TestOrder";
public String getBoName()
{
return boName;
}
/**
* TODO GLPaaS生成
* 批量删除订单TestOrder
*
* @param ids
* @return
* @
*/
public void deletes(String[] ids)
{
List<String> fruitOrderIds = Lists.newArrayList(ids);
TestOrderExample testOrderExample = TestOrderExample.create();
testOrderExample.and().andCreateCondition(TestOrder.FRUITORDERID,"fruitOrderId",Operation.IN,Arrays.asList(ids));
this.deleteByExample(testOrderExample);
}
/**
* TODO GLPaaS生成
* 根据主键列表，批量删除订单TestOrder
*
* @param ids
*/
public void deletes(String[] ids,boolean isLogic)
{
if (isLogic)
{
List<String> fruitOrderIds = Lists.newArrayList(ids);
TestOrderExample testOrderExample = TestOrderExample.create();
testOrderExample.and().andCreateCondition(TestOrder.FRUITORDERID,"fruitOrderId",Operation.IN,fruitOrderIds);
TestOrder testOrder = new TestOrder();
testOrder.setIsDeleted("X");
testOrder.setRecordVersion(null);
this.updateByExampleSelective(testOrder,testOrderExample);
}
else
this.deletes(ids);
}
/**
* TODO GLPaaS生成
* 保存并提交 订单TestOrder
*
* @param ids
* @return
* @
*/
public void submitProcess(TestOrder testOrder)
{
super.submitProcess(testOrder);
}
/**
* TODO GLPaaS生成
* 修改保存订单TestOrder
*
* @param testOrder
* @return
* @
*/
public List<TestOrder> saveOrUpdates(List<TestOrder> testOrders)
{
List<TestOrder> result = Lists.newArrayList();
super.saveOrUpdates(testOrders);
return testOrders;
}
/**
* TODO GLPaaS生成
* 保存订单TestOrder
*
* @param testOrder
* @return
* @
*/
@Override
public int save(TestOrder testOrder)
{
int result = -1 ;
if(testOrder.getRowStatus()==BaseObject.ROWSTATUS_ADDED)
result = super.save(testOrder);
return result;
}
/**
* TODO GLPaaS生成
* 保存订单TestOrder
*
* @param testOrder
* @return
* @
*/
@Override
public int saveOrUpdate(TestOrder testOrder)
{
int result = 0;
if(testOrder.getRowStatus() == BaseObject.ROWSTATUS_DELETED)
{
this.delete(testOrder.getFruitOrderId(),true);
result =1 ;
}
else
{
if(testOrder.getRowStatus() == BaseObject.ROWSTATUS_ADDED || testOrder.getRowStatus() == BaseObject.ROWSTATUS_MODIFIED)
{
result = super.saveOrUpdate(testOrder);
}
}
return result;
}
/**
* TODO GLPaaS生成
* 保存订单TestOrder
*
* @param testOrder
* @return
* @
*/
public int update(TestOrder testOrder)
{
int result = -1 ;
if(testOrder.getRowStatus()==BaseObject.ROWSTATUS_MODIFIED)
result = super.updateByPrimaryKey(testOrder);
return result;
}
public List<TestOrder> find(TestOrderExample example) {
List<TestOrder> testOrders = super.find(example);
return testOrders;
}
/**
* TODO GLPaaS生成
* 根据Example查询分页
* @return Page<T>
*/
public Page<TestOrder> find(PageRequest pageRequest, TestOrderExample example) {
Page<TestOrder> page = super.find(pageRequest, example);
return page;
}
/**
* TODO GLPaaS生成
* 保存并提交 订单TestOrder
*
* @param ids
* @return
* @
*/
public void saveAndSubmitProcess(TestOrder testOrder)
{
super.saveAndSubmitProcess(testOrder);
}
/**
* TODO GLPaaS生成
* 根据主键获取订单TestOrder
*
* @param testOrders
* @return
* @
*/
public TestOrder get(String fruitOrderId)
{
TestOrder testOrder = super.get(fruitOrderId);
return testOrder;
}
/**
* TODO GLPaaS生成
* 删除订单TestOrder
*
* @param id
* @return
* @
*/
public void delete(String id)
{
// 级联删除子对象
super.delete(id);
}
/**
* TODO GLPaaS生成
* 根据主键列表，删除订单TestOrder
*
* @param id
*/
public void delete(String id,boolean isLogic)
{
if (isLogic)
{
TestOrder testOrder = new TestOrder();
testOrder.setFruitOrderId(id);
testOrder.setFruitOrderId(id);
TestOrderExample testOrderExample = TestOrderExample.create();
testOrderExample.and().andCreateCondition(TestOrder.FRUITORDERID,"fruitOrderId",Operation.EQ,id);
testOrder.setIsDeleted("X");
testOrder.setRecordVersion(null);
this.updateByExampleSelective(testOrder,testOrderExample);
}
else
{
this.delete(id);
}
}
/**
* TODO GLPaaS生成
* 批量恢复 订单TestOrder
*
* @param ids
*/
public void recoveryDeleted(List<TestOrder> testOrders)
{
List<String> fruitOrderIds = Lists.transform(testOrders, new Function<TestOrder,String>(){
@Override
public String apply(TestOrder testOrder)
{
return testOrder.getFruitOrderId();
}
});
TestOrderExample testOrderExample = TestOrderExample.create();
testOrderExample.and().andCreateCondition(TestOrder.FRUITORDERID,"fruitOrderId",Operation.IN,fruitOrderIds);
TestOrder testOrder = new TestOrder();
testOrder.setIsDeleted("");
testOrder.setRecordVersion(null);
this.updateByExampleSelective(testOrder,testOrderExample);
/**
for (int i = 0; i < ids.length; i++)
{
this.getJdbcTemplate().update("update FRUIT_ORDER set IS_DELETED='' where FRUIT_ORDER_ID = ? ", ids[i]);
}
**/
}
}
1.3.控制类
/*
* @(#)TestOrderController.java
* 版权声明 厦门吉联科技, 版权所有 违者必究
*
*修订记录:
*1)更改者：java业务平台代码生成工具
* 时 间：2018年07月25日 11点35分23秒
* 描 述：创建
*/
package com.gillion.oms.samle.web;
import java.io.IOException;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;
import java.util.HashMap;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.Collection;
import javax.persistence.ManyToOne;
import javax.persistence.OneToMany;
import javax.persistence.OneToOne;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.gillion.platform.utils.*;
import net.sf.json.JSONObject;
import com.google.common.collect.Maps;
import com.google.common.base.Function;
import com.google.common.collect.Lists;
import com.gillion.platform.framework.core.domain.BaseObject;
import org.apache.commons.lang.builder.ToStringBuilder;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.stereotype.Controller;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.validation.annotation.Validated;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.servlet.ModelAndView;
import com.gillion.platform.bo.BoConstants;
import com.gillion.platform.bo.domain.BusinessObject;
import com.gillion.platform.bo.service.impl.BusinessObjectService;
import com.gillion.platform.framework.core.Constants;
import com.gillion.platform.framework.core.dao.BeanPropertyRowMapper;
import com.gillion.platform.framework.core.query.ConditionResult;
import com.gillion.platform.framework.core.query.Operation;
import com.gillion.platform.framework.core.query.Page;
import com.gillion.platform.framework.core.query.Criteria;
import com.gillion.platform.framework.core.query.PageRequest;
import com.gillion.platform.framework.core.query.SearchColumn;
import com.gillion.platform.framework.core.query.OrderColumn;
import com.gillion.platform.framework.component.search.QueryResultType;
import com.fasterxml.jackson.databind.JsonNode;
import com.gillion.platform.utils.json.JsonMapper;
import com.gillion.platform.utils.JsonUtils;
import com.gillion.platform.utils.StringUtils;
import com.gillion.platform.utils.DateUtils;
import com.gillion.platform.utils.ResponseUtils;
import java.math.BigDecimal;
import com.gillion.platform.framework.core.BusinessException;
import com.gillion.oms.samle.domain.TestOrder;
import com.gillion.oms.samle.domain.TestOrderExample;
import com.gillion.oms.samle.service.TestOrderService;
import com.gillion.platform.bo.domain.BusinessObject;
import com.gillion.platform.framework.core.web.BaseAbstractController;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.support.RequestContextUtils;
import com.gillion.platform.framework.core.web.BaseMultiActionController;
import java.lang.reflect.InvocationTargetException;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.springframework.web.multipart.MultipartFile;
import java.io.InputStream;
import java.util.Set;
import org.springframework.beans.BeanUtils;
import org.springframework.validation.beanvalidation.LocalValidatorFactoryBean;
import javax.validation.ConstraintViolation;
/**
* <pre>
* 订单TestOrder(TestOrder)控制器类
* </pre>
*
* <br>
* JDK版本:1.5
*
* @author java业务平台代码生成工具
* @version 1.0
* @see The author for more details
* @since 1.0
*/
@Controller
@SuppressWarnings("all")
public class TestOrderController extends BaseAbstractController
{
protected static final String boName = "TestOrder";
/* (non-Javadoc)
* @see com.gillion.framework.core.web.BaseAbstractController#getBoName()
*/
@Override
public String getBoName()
{
return boName;
}
@Autowired
private LocalValidatorFactoryBean validator;
@Autowired
protected TestOrderService testOrderService;
public void setTestOrderService(TestOrderService testOrderService)
{
this.testOrderService = testOrderService;
}
@RequestMapping("testOrder/entryProcess")
public ModelAndView entryProcess(HttpServletRequest request, HttpServletResponse response)
{
return super.entryProcess(request, response);
}
/**
* TODO GLPaaS生成
* 批量删除订单TestOrder
*
* @param idStr
* @return
* @throws Exception
* @
*/
@RequestMapping(value="testOrder/deletes")
public void deletes(@RequestBody String params, HttpServletResponse response) throws Exception
{
Map<String,String> parmMaps = JsonMapper.MAPPER.fromJson(params,Map.class);
String idStr = parmMaps.get("ids");
String[] ids = idStr.split(",");
String isLogic = String.valueOf(parmMaps.get("isLogic"));
boolean isLogicDelete = false ;
if(StringUtils.isNotNullBlank(isLogic) && "true".equalsIgnoreCase(isLogic))
{
isLogicDelete = true;
}
testOrderService.deletes(ids,isLogicDelete);
ResponseUtils.flushSuccess(response, "删除成功！");
}
/**
* TODO GLPaaS生成
* 保存并新增 订单TestOrder
*
* @RequestBody String data
* @param request
* @param response
* @throws IOException
*/
@RequestMapping(value="testOrder/saveAndAddNew")
public void saveAndAddNew(@RequestBody TestOrder testOrder, HttpServletRequest request, HttpServletResponse response) throws IOException
{
//TestOrder testOrder = (TestOrder) JsonMapper.MAPPER.fromJson(data, TestOrder.class);
//testOrderService.save(testOrder);
if(testOrder.getRowStatus() == BaseObject.ROWSTATUS_ADDED )
{
testOrderService.save(testOrder);
} else
{
testOrderService.update(testOrder);
}
ResponseUtils.flushSuccess(response, "保存成功！", "testOrder", testOrder);
}
/**
* TODO GLPaaS生成
* 订单TestOrder提交工作流审批
*
* @param purchaseOrderId
* @return
* @throws IOException
*/
@RequestMapping(value = "testOrder/submitProcess")
public void submitProcess(@RequestParam(value = "fruitOrderId")
String fruitOrderId,@RequestParam(value = "workFlowTaskId",required=false) String workFlowTaskId , HttpServletRequest request, HttpServletResponse response) throws IOException
{
TestOrder testOrder = testOrderService.get(fruitOrderId);
testOrder.setWorkFlowTaskId(workFlowTaskId);
testOrderService.submitProcess(testOrder);
testOrder = testOrderService.get(fruitOrderId);
ResponseUtils.flushSuccess(response, "提交成功！", "testOrder", testOrder);
}
/**
* TODO GLPaaS生成
* 批量保存
* @param idStr
* @return
* @throws Exception
* @
*/
@RequestMapping(value="testOrder/bacthSaveTestOrderData")
public void bacthSaveTestOrderData(@RequestBody List<TestOrder> testOrders, HttpServletRequest request, HttpServletResponse response) throws IOException
{
List<TestOrder> result = testOrderService.saveOrUpdates(testOrders);
ResponseUtils.flushSuccess(response, "批量保存成功！", "testOrders", result);
}
/**
* TODO GLPaaS生成
* 批量保存
* @param idStr
* @return
* @throws Exception
* @
*/
@RequestMapping(value="testOrder/saveOrUpdates")
public void saveOrUpdates(@RequestBody List<TestOrder> testOrders, HttpServletRequest request, HttpServletResponse response) throws IOException
{
List<TestOrder> result = testOrderService.saveOrUpdates(testOrders);
ResponseUtils.flushSuccess(response, "批量保存成功！", "testOrders", result);
}
/**
* TODO GLPaaS生成
* 保存 订单TestOrder
*
* @RequestBody String data
* @param request
* @param response
* @throws IOException
*/
@RequestMapping(value="testOrder/save")
public void save(@RequestBody TestOrder testOrder, HttpServletRequest request, HttpServletResponse response) throws IOException
{
//TestOrder testOrder = (TestOrder) JsonMapper.MAPPER.fromJson(data, TestOrder.class);
testOrderService.save(testOrder);
//刷新缓存
ResponseUtils.flushSuccess(response, "保存成功！", "testOrder", testOrder);
}
/**
* TODO GLPaaS生成
* 保存 订单TestOrder
*
* @RequestBody String data
* @param request
* @param response
* @throws IOException
*/
@RequestMapping(value="testOrder/saveOrUpdate")
public void saveOrUpdate(@RequestBody TestOrder testOrder, HttpServletRequest request, HttpServletResponse response) throws IOException
{
//TestOrder testOrder = (TestOrder) JsonMapper.MAPPER.fromJson(data, TestOrder.class);
testOrderService.saveOrUpdate(testOrder);
ResponseUtils.flushSuccess(response, "保存成功！", "testOrder", testOrder);
}
/**
* TODO GLPaaS生成
* 保存 订单TestOrder
*
* @RequestBody String data
* @param request
* @param response
* @throws IOException
*/
@RequestMapping(value="testOrder/update")
public void update(@RequestBody TestOrder testOrder, HttpServletRequest request, HttpServletResponse response) throws IOException
{
//TestOrder testOrder = (TestOrder) JsonMapper.MAPPER.fromJson(data, TestOrder.class);
testOrderService.update(testOrder);
ResponseUtils.flushSuccess(response, "修改成功！", "testOrder", testOrder);
}
/**
* TODO GLPaaS生成
* queryByJdbc
* @param request
* @param result
* @param searchColumns
* @param orderColumns
* @param pageRequest
*/
protected void queryByJdbc(HttpServletRequest request, Map<String, Object> result, List<SearchColumn> searchColumns,List<OrderColumn> orderColumns, PageRequest pageRequest,String gridKey)
{
Page page = new Page();
page.setPageSize(pageRequest.getPageSize());
page.setCurrentPage(pageRequest.getCurrentPage());
TestOrderExample example = TestOrderExample.create(searchColumns);
example.addOrderByClause(TestOrder.class, orderColumns);
JdbcTemplate jdbcTemplate = this.testOrderService.getJdbcTemplate();
List allValues = Lists.newArrayList();
StringBuffer realStrSql = new StringBuffer();
realStrSql.append("select ");
realStrSql.append("FRUIT_ORDER_STATUS,COUNTRY01,IS_DELETED,FRUIT_ORDER_SENDER_ID,RECORD_VERSION,PROCESS_STATE,FRUIT_ORDER_RECEIVER,FRUIT_ORDER_REMARK,FRUIT_ORDER_ID,COUNTRY02,FRUIT_ORDER_TIME,");
realStrSql.append("FRUIT_ORDER_SENDER_NAME,FRUIT_GROSS_WEIGHT,COUNTRY04,FRUIT_ORDER_CODE,COUNTRY03,FRUIT_BOOKNUM,LAST_MODIFY_OFFICE,CREATOR,PRINCIPAL_GROUP_CODE,LAST_MODIFY_TIME_ZONE,CREATE_OFFICE,");
realStrSql.append("CREATE_TIME,LAST_MODIFYOR,LAST_MODIFY_TIME,CREATE_TIME_ZONE,");
realStrSql.append(" from FRUIT_ORDER" );
realStrSql.append(" where 1=1 ");
ConditionResult conditionResult = example.generatorSqlConditions();//generatorSqlConditions(example);
realStrSql.append(conditionResult.getStrSql());
String orderByClase = example.getOrderByClause();
if(StringUtils.isNotNullBlank(orderByClase)) {
realStrSql.append("t order by ").append(orderByClase);
}
Object[] sqlCountParam = allValues.toArray();
//page.getCurrentPage() * page.getPageSize(), (page.getCurrentPage() - 1) * page.getPageSize()
allValues.add((page.getCurrentPage() - 1) * page.getPageSize());
allValues.add(page.getCurrentPage() * page.getPageSize());
Object[] sqlPageParam = allValues.toArray();
log.debug("sqlCountParam:" + JsonMapper.MAPPER.toJson(sqlCountParam));
log.debug("sqlPageParam:" + JsonMapper.MAPPER.toJson(sqlPageParam));
StringBuffer sqlCount = new StringBuffer();
sqlCount.append("select count(1) from (" + realStrSql.toString() + ") TT");
long start1 = System.currentTimeMillis();
// 查询总记录条数
int count = jdbcTemplate.queryForInt(sqlCount.toString(), sqlCountParam);
log.debug("count:" + (System.currentTimeMillis()-start1) + " ms");
StringBuffer sqlPage = new StringBuffer();
sqlPage.append("SELECT * FROM ");
if(DataBaseTypeUtils.getDbType().equals("MySql")){
sqlPage.append(" (" + realStrSql.toString() + ") y");
sqlPage.append(" limit ?,?");
}else{
sqlPage.append(" (SELECT rownum AS rownum_,row_.* FROM ");
sqlPage.append(" (" + realStrSql.toString() + ") row_ ) ");
sqlPage.append(" WHERE rownum_> ? and rownum_ <= ?");
}
long start = System.currentTimeMillis();
// 查询分页记录
List<TestOrder> testOrders = jdbcTemplate.query(sqlPage.toString(), BeanPropertyRowMapper.newInstance(TestOrder.class), sqlPageParam);
// 0 ---TestOrder
log.debug("query:" + (System.currentTimeMillis()-start) + " ms");
page.setTotalRecord(count);
page.setRecords(testOrders);
result.put(Constants.TOTAL, count);
result.put("testOrders", testOrders);
}
/**
* TODO GLPaaS生成
* queryByMyBatis
* @param request
* @param result
* @param searchColumns
* @param orderColumns
* @param pageRequest
*/
protected void queryByMyBatis(HttpServletRequest request, Map<String, Object> result, List<SearchColumn> searchColumns,List<OrderColumn> orderColumns, PageRequest pageRequest,String gridKey)
{
TestOrderExample example = TestOrderExample.create(searchColumns);
example.addOrderByClause(TestOrder.class, orderColumns);
List<TestOrder> testOrders = new ArrayList<TestOrder>();
if(pageRequest.isQueryPage())
{
Page<TestOrder> page = testOrderService.find(pageRequest, example);
testOrders = page.getRecords();
result.put(Constants.TOTAL, page.getTotalRecord());
}
else
{
testOrders = testOrderService.find(example);
result.put(Constants.TOTAL, testOrders.size());
}
// 0 ---TestOrder
result.put("testOrders", testOrders);
}
/**
* TODO GLPaaS生成
* 订单TestOrder分页信息查询
*
* @param
* @return
* @throws Exception
*/
@RequestMapping(value = "testOrder/query")
public void query(HttpServletRequest request, HttpServletResponse response) throws Exception
{
Map<String,Object> result = new HashMap<String, Object>();
String gridKey = request.getParameter("gridKey");
boolean useMyBatisQuery = Boolean.TRUE;
List<SearchColumn> searchColumns = getSearchColumns(request);
PageRequest pageRequest = getPageRequest(request);
if (searchColumns != null) {
removeSearchColumn(searchColumns, "baseViewId");
}
List<OrderColumn> orderColumns = getOrderColumns(request);
if(useMyBatisQuery)
queryByMyBatis(request, result, searchColumns,orderColumns, pageRequest,gridKey);
else
queryByJdbc(request, result, searchColumns,orderColumns, pageRequest,gridKey);
ResponseUtils.flushSuccess(response, result);
}
/**
* TODO GLPaaS生成
* 订单TestOrder保存并提交工作流审批
*
* @param data
* @return
* @throws IOException
*/
@RequestMapping(value = "testOrder/saveAndSubmitProcess")
public void saveAndSubmitProcess(@RequestBody String data,HttpServletRequest request, HttpServletResponse response) throws IOException
{
TestOrder testOrder = (TestOrder) JsonMapper.MAPPER.fromJson(data, TestOrder.class);
testOrderService.saveAndSubmitProcess(testOrder);
ResponseUtils.flushSuccess(response, "提交成功！", "testOrder", testOrder);
}
/**
* TODO GLPaaS生成
* 根据主键获取订单TestOrder
*
* @param shopId
* @return
* @
*/
@RequestMapping(value = "testOrder/getTestOrder")
public void getTestOrder(@RequestParam(value="fruitOrderId") String fruitOrderId,
HttpServletResponse response) throws Exception
{
TestOrder testOrder = null ;
if(StringUtils.isNotNullBlank(fruitOrderId)) {
testOrder = testOrderService.get(fruitOrderId);
}
else
{
String msg = "参数fruitOrderId";
msg += "不能为空.";
throw new BusinessException(msg);
}
if(null==testOrder){
testOrder = new TestOrder();
testOrder.setRowStatus(BaseObject.ROWSTATUS_ADDED);
}
ResponseUtils.flushSuccess(response, "请求成功！", "testOrder", testOrder);
}
/**
* TODO GLPaaS生成
* 根据 主键 删除 订单TestOrder
*
* @param shopId
* @return
* @throws Exception
*/
@RequestMapping(value="testOrder/delete")
public void delete(@RequestParam(value="fruitOrderId") String fruitOrderId, @RequestParam(value="isLogic") String isLogic, HttpServletResponse response) throws Exception
{
boolean isLogicDelete = false ;
if(StringUtils.isNotNullBlank(isLogic) && "true".equalsIgnoreCase(isLogic))
{
isLogicDelete = true;
}
testOrderService.delete(fruitOrderId,isLogicDelete);
ResponseUtils.flushSuccess(response, "删除成功！");
}
/**
* TODO GLPaaS生成
* 批量恢复
*
* @param idStr
* @return
* @throws Exception
* @
*/
@RequestMapping(value="testOrder/recoveryDeleted")
public void recoveryDeleted(@RequestBody List<TestOrder> testOrders, HttpServletResponse response) throws Exception
{
testOrderService.recoveryDeleted(testOrders);
ResponseUtils.flushSuccess(response, "恢复成功！");
}
public static Map<String,Map<String,String>> gridColumnUiTypes = null;
}