| | |
|---|
| | | } else if (item.type === 'range') { |
|---|
| | | let val = item.value.split(',') |
|---|
| | | |
|---|
| | | newsearches[item.key] = val[0] || -999999 |
|---|
| | | newsearches[item.key + '1'] = val[1] || 999999 |
|---|
| | | newsearches[item.key] = val[0] || -999999999 |
|---|
| | | newsearches[item.key + '1'] = val[1] || 999999999 |
|---|
| | | } else if (item.type === 'dateweek') { |
|---|
| | | let _startval = '' |
|---|
| | | let _endval = '' |
|---|
| | |
|---|
| | | } else if (item.type === 'range') { |
|---|
| | | let val = item.value.split(',') |
|---|
| | | |
|---|
| | | searchText.push('(' + item.key + ' >= ' + (val[0] || -999999) + ' AND ' + item.key + ' < ' + (val[1] || 999999) + ')') |
|---|
| | | searchText.push('(' + item.key + ' >= ' + (val[0] || -999999999) + ' AND ' + item.key + ' <= ' + (val[1] || 999999999) + ')') |
|---|
| | | } else { |
|---|
| | | searchText.push('(' + item.key + ' ' + item.match + ' \'' + item.value + '\')') |
|---|
| | | } |
|---|
| | |
|---|
| | | |
|---|
| | | let copy = JSON.parse(JSON.stringify(item)) |
|---|
| | | copy.key = copy.key + '1' |
|---|
| | | copy.value = val[1] || 999999 |
|---|
| | | copy.value = val[1] || 999999999 |
|---|
| | | |
|---|
| | | item.value = val[0] || -999999 |
|---|
| | | item.value = val[0] || -999999999 |
|---|
| | | |
|---|
| | | options.push(item) |
|---|
| | | options.push(copy) |
|---|
| | |
|---|
| | | _sql = `/* 系统生成 */ |
|---|
| | | Declare @tbid nvarchar(50),@ErrorCode nvarchar(50),@retmsg nvarchar(4000),@BillCode nvarchar(50),@BVoucher nvarchar(50),@FIBVoucherDate nvarchar(50), @FiYear nvarchar(50),@ModularDetailCode nvarchar(50), @UserName nvarchar(50),@FullName nvarchar(50),@RoleID nvarchar(512),@mk_departmentcode nvarchar(512),@mk_organization nvarchar(512),@mk_user_type nvarchar(20),@mk_nation nvarchar(50),@mk_province nvarchar(50),@mk_city nvarchar(50),@mk_district nvarchar(50),@mk_address nvarchar(100),@mk_deleted int,@bid nvarchar(50)${_declarefields} |
|---|
| | | ` |
|---|
| | | |
|---|
| | | if (btn.$process && verify.workFlow === 'true' && window.GLOB.UserCacheMap.has(btn.$flowId)) { |
|---|
| | | _sql += ` |
|---|
| | | /* 工作流变量定义与赋值 */ |
|---|
| | | Declare @works_flow_code nvarchar(50),@works_flow_name nvarchar(50),@works_flow_param nvarchar(4000),@works_flow_detail_id nvarchar(50),@status int,@statusname nvarchar(50), @work_group nvarchar(50),@work_grade int, @start_type nvarchar(50),@check_type nvarchar(50),@notice_type nvarchar(50),@check_userids nvarchar(512),@notice_userids nvarchar(512) |
|---|
| | | select @works_flow_code=@works_flow_code@,@works_flow_name=@works_flow_name@,@works_flow_param=@works_flow_param@,@works_flow_detail_id=@works_flow_detail_id@,@status=@status@,@statusname=@statusname@,@work_group=@work_group@,@work_grade=@work_grade@, @start_type=@start_type@,@check_type=@check_type@,@notice_type=@notice_type@,@check_userids=@check_userids@,@notice_userids=@notice_userids@ |
|---|
| | | ` |
|---|
| | | } |
|---|
| | | |
|---|
| | | let userName = sessionStorage.getItem('User_Name') || '' |
|---|
| | | let fullName = sessionStorage.getItem('Full_Name') || '' |
|---|
