| | |
| | | * |
| | | */ |
| | | @ApiModelProperty(value = "") |
| | | private String onlinepaymentbtnexpression; |
| | | /** |
| | | * |
| | | */ |
| | | @ApiModelProperty(value = "") |
| | | private Integer isshowonlinerefundbutton; |
| | | /** |
| | | * |
| | | */ |
| | | @ApiModelProperty(value = "") |
| | | private String onlinerefundbtneditstatus; |
| | | /** |
| | | * |
| | | */ |
| | | @ApiModelProperty(value = "") |
| | | private String onlinerefundbtnexpression; |
| | | /** |
| | | * |
| | | */ |
| | | @ApiModelProperty(value = "") |
| | | private Integer isShowGridStyleForApp; |
| | | //默认取主表表名 |
| | | boolean isGetHeadTabe=true; |
| | |
| | | //没设置则按钮不显示 |
| | | sb.append(",0 as [RevokeBtn_Visible]"); |
| | | } |
| | | //----在线收款按钮 |
| | | if (gformEntity.getIsshowonlinepaymentbutton()!=null&&gformEntity.getIsshowonlinepaymentbutton()==1) { |
| | | sb.append(",case when (1=1 "); |
| | | if (StringUtils.isNotBlank(gformEntity.getOnlinepaymentbtneditstatus())) { |
| | | sb.append("and docstatus in(select list from getinstr('" + gformEntity.getOnlinepaymentbtneditstatus() + "') as b)\n"); |
| | | } |
| | | if (StringUtils.isNotBlank(gformEntity.getOnlinepaymentbtnexpression())) { |
| | | sb.append("and (" + gformEntity.getOnlinepaymentbtnexpression() + ")\n"); |
| | | } |
| | | sb.append(") then 1 else 0 end as [onlinePaymentBtn_Visible]"); |
| | | } else { |
| | | //没设置则按钮不显示 |
| | | sb.append(",0 as [onlinePaymentBtn_Visible]"); |
| | | } |
| | | //----在线退款按钮 |
| | | if (gformEntity.getIsshowonlinerefundbutton()!=null&&gformEntity.getIsshowonlinerefundbutton()==1) { |
| | | sb.append(",case when (1=1 "); |
| | | if (StringUtils.isNotBlank(gformEntity.getOnlinerefundbtneditstatus())) { |
| | | sb.append("and docstatus in(select list from getinstr('" + gformEntity.getOnlinerefundbtneditstatus() + "') as b)\n"); |
| | | } |
| | | if (StringUtils.isNotBlank(gformEntity.getOnlinerefundbtnexpression())) { |
| | | sb.append("and (" + gformEntity.getOnlinerefundbtnexpression() + ")\n"); |
| | | } |
| | | sb.append(") then 1 else 0 end as [onlineRefundBtn_Visible]"); |
| | | } else { |
| | | //没设置则按钮不显示 |
| | | sb.append(",0 as [onlineRefundBtn_Visible]"); |
| | | } |
| | | } |
| | | return sb.toString(); |
| | | } |
| | |
| | | protected PanelServiceIfc pIfc; |
| | | |
| | | public static String BEAN_INFO = "beaninfo"; |
| | | private static String GFORM_SQL = " isTitle,formname,showdetail,isopenFuncshowpwdedit,isshowpwdedit,optype,HDTable,version,dataformid,formdatafilters,panellabellayout,CancelBtnProcName,CancelBtnExpression,CancelBtnEditStatus,CancelBtnName,RevokeBtnProcName,RevokeBtnExpression,RevokeBtnEditStatus,isShowOnlineMsg,isShowProcessTracking,autoOpen,predocstatus,procgroupaftersavedoc,dealafterdocsave,transgroupcode,dttable,isShowNewDocButton,isshowinserialbtn,inserialbtneditstatus,isshowoutserialbtn ,outserialbtneditstatus,isshowonlinepaymentbutton,onlinepaymentbtneditstatus,isshowgridstyleforapp "; |
| | | private static String GFORM_SQL = " isTitle,formname,showdetail,isopenFuncshowpwdedit,isshowpwdedit,optype,HDTable,version,dataformid,formdatafilters,panellabellayout,CancelBtnProcName,CancelBtnExpression,CancelBtnEditStatus,CancelBtnName,RevokeBtnProcName,RevokeBtnExpression,RevokeBtnEditStatus,isShowOnlineMsg,isShowProcessTracking,autoOpen,predocstatus,procgroupaftersavedoc,dealafterdocsave,transgroupcode,dttable,isShowNewDocButton,isshowinserialbtn,inserialbtneditstatus,isshowoutserialbtn ,outserialbtneditstatus,isshowonlinepaymentbutton,onlinepaymentbtneditstatus,onlinepaymentbtnexpression,isshowonlinerefundbutton,onlinerefundbtneditstatus,onlinerefundbtnexpression,isshowgridstyleforapp "; |
| | | |
| | | protected Map<String, Object> getGformInfo(String formid) { |
| | | return gformIfc.getGformInfo(GFORM_SQL, Integer.parseInt(formid)); |
| | |
| | | public class GridServiceImpl extends BaseService implements GridServiceIfc { |
| | | @Autowired |
| | | Type38Ifc type38Ifc; |
| | | private final String gform = "[formid], [formname],[isused],[formmemo],[optype],[refformid],[hdtable],[dttable],[showdetail],[fetchrecnumber],[queryform],[refreshTime],[refresh_aftersave],[frozencols],[LockGridSort],[rowcopyfields],[rowcopyformids],[rowDelFormids],[index1],[index1primary],[index2],[index2primary],[index3],[index3Primary],[dataformid],[predocstatus],[postdocstatus],[DocStatusName],[transgroupcode],[codelength],[preFixcode],[precodetype],[helpdoc_udl],[checkblncfields],[formalign],[DealAfterDocSave],[AllowEmptyRow],[Busi2fiDataView],[glcodefield],[txtinputfields],[DBCtrlRowCount],[ShowAsDetailMode],[modifytableflag],[applytableflag],[CrossInputType],[MultiTitleType],[datapooled],[glentitycode],[formdatafilters],[ProcGroupafterSavedoc], [TransTypecode],[currencyfld],[chkFormula],[GridFormatFun],[SelectChecker],[ReturnCurChecker],[ReturnCurCheckerName],[FT],[FTFormType],[FK],[SeekGroupID],[sPremissField],[dPremissField],[FKeFilter],[GridRowHeight],[GridHeight], [isShowPwdEdit], [isOpenFuncShowPwdEdit], [isShowOnlineMsg] ,[isShowProcessTracking] ,[PanelLabelLayout],[isTitle], [isTaobao],[cellAlign] ,[pageSize],[version],[reportprompts],[CancelBtnProcName],[CancelBtnExpression],[CancelBtnEditStatus],[isShowCell],[importProcName],[CancelIsSave],[CancelBtnName],[isGantt],[byGroup],[DefaultRowCount],[Expanded], [isFilter], [JNIName],[JNIDataBaseURL], [JNIPort] ,[JNIDataBaseName], [JNIUser], [JNIPwd] ,[JNISql] ,[JNITempTable],[addNewRow],[autopaging],[RevokeBtnProcName],[RevokeBtnExpression],[RevokeBtnEditStatus],[autoOpen],isExchangeDataWithHost,isShowNewDocButton,isShowMemoWhenApprovals,isshowinserialbtn,inserialbtneditstatus,isshowoutserialbtn ,outserialbtneditstatus,isShowOnlinePaymentButton,onlinePaymentBtnEditStatus,isShowGridStyleForApp "; |
| | | private final String gform = "[formid], [formname],[isused],[formmemo],[optype],[refformid],[hdtable],[dttable],[showdetail],[fetchrecnumber],[queryform],[refreshTime],[refresh_aftersave],[frozencols],[LockGridSort],[rowcopyfields],[rowcopyformids],[rowDelFormids],[index1],[index1primary],[index2],[index2primary],[index3],[index3Primary],[dataformid],[predocstatus],[postdocstatus],[DocStatusName],[transgroupcode],[codelength],[preFixcode],[precodetype],[helpdoc_udl],[checkblncfields],[formalign],[DealAfterDocSave],[AllowEmptyRow],[Busi2fiDataView],[glcodefield],[txtinputfields],[DBCtrlRowCount],[ShowAsDetailMode],[modifytableflag],[applytableflag],[CrossInputType],[MultiTitleType],[datapooled],[glentitycode],[formdatafilters],[ProcGroupafterSavedoc], [TransTypecode],[currencyfld],[chkFormula],[GridFormatFun],[SelectChecker],[ReturnCurChecker],[ReturnCurCheckerName],[FT],[FTFormType],[FK],[SeekGroupID],[sPremissField],[dPremissField],[FKeFilter],[GridRowHeight],[GridHeight], [isShowPwdEdit], [isOpenFuncShowPwdEdit], [isShowOnlineMsg] ,[isShowProcessTracking] ,[PanelLabelLayout],[isTitle], [isTaobao],[cellAlign] ,[pageSize],[version],[reportprompts],[CancelBtnProcName],[CancelBtnExpression],[CancelBtnEditStatus],[isShowCell],[importProcName],[CancelIsSave],[CancelBtnName],[isGantt],[byGroup],[DefaultRowCount],[Expanded], [isFilter], [JNIName],[JNIDataBaseURL], [JNIPort] ,[JNIDataBaseName], [JNIUser], [JNIPwd] ,[JNISql] ,[JNITempTable],[addNewRow],[autopaging],[RevokeBtnProcName],[RevokeBtnExpression],[RevokeBtnEditStatus],[autoOpen],isExchangeDataWithHost,isShowNewDocButton,isShowMemoWhenApprovals,isshowinserialbtn,inserialbtneditstatus,isshowoutserialbtn ,outserialbtneditstatus,isShowOnlinePaymentButton,onlinePaymentBtnEditStatus,onlinepaymentbtnexpression,isshowonlinerefundbutton,onlinerefundbtneditstatus,onlinerefundbtnexpression,isShowGridStyleForApp "; |
| | | |
| | | private final String gfield = "[formid],[headflag], [fieldid],[statisid],[Lblcode],[fieldname],[datatype],[displayformat], [showongrid],[gridcaption], [gridcontroltype],[gridlength],[ft],[ftformtype],[emptyrefdata], [fk],[seekgroupid],[spremissfield],[dpremissfield],[efilter],[return_one_record],[numfieldid], [visible], [hidelabel], [controltype],[rowno],[colno],[lengthnum],[heightnum],[detailrowno],[detailcolno],[detaillength],[detailheight],[statisflag] ,[blcheckauth],[indexfld],[readonly],[datalink],[keyinput],[secretfld],[calcufield],[formula],[sumfield],[funclinkname],[activefuns] ,[initvalue] ,[checkauthmode],[PreLike],[EnterToNextRow],[tabsheetname],[passwordchar],[uppercase] ,[LinkFormDisplayFields], [dyfieldview],[copyfromlastrow],[ftlockconditionflag],[datafilterfield], [HelpKeyID] ,[MultiLangYN], [IMEactive] , [memo], [Hints],[editStatus],[isReader] ,[SqlScript],[MasterFieldShowLocation], [isCustomHTMLComponent] , [showFieldValueExpression],[HyperlinkFT],[HyperlinkFTFormType],[HyperlinkSPremissField], [HyperlinkDPremissField],[HyperlinkEFilter],[Hyperlinkmode],[isAutoSaved],[stylecss],[rowSpan] ,[isImport],[isExport],[fieldtype],[cellAlign], [isCopyExclude],[isAutoRefresh],[isLoad],[Audit],[TipsExpression],[SuggestFileds],[RelationField],[onlyOne],AppColNo,AppHeight,AppHideLabel,AppLength,AppRowNo,AppVisible,ScanCodeField,funclinkname,exportTitle,isAPPExcludeField,SqlWhere,afterBlockDividingLine "; |
| | | |