GreenDao-自定义SQL查询-拼接多个查询条件-AndroidStudio-Android

//获取本地Pad（离线工作票列表）publicstaticListgetPadWTList(Stringtoken,StringuserId,Stringorg,Stringdept,StringstrClass,StringticketNo,Stringtype,Stringstatus,StringisEvaluated,StringexceedTimeLimit,Stringerror,StringworkLeader,Stringsignatory,Stringcontent,StringcreateTimeLimit,Stringyear,StringworkLeaderOpenTime,//工作负责人签字时间从StringworkLeaderCloseTime,//工作负责人签字时间到StringallowEndOpenTime,StringallowEndCloseTime,Stringpage_number,Stringeach_page){ListlWTDetailTableBeanLt=newArrayList();//请求参数ArrayListstrParamLt=newArrayList();StringqueryString="SELECTDISTINCT*FROM"WTDetailTableBeanDao.TABLENAME"where1==1";//组织if(!CommonUtil.isNull(org)){queryString=queryString"and"WTDetailTableBeanDao.Properties.ORG_ID.columnName"=?";strParamLt.add(org);}//部门if(!CommonUtil.isNull(dept)){queryString=queryString"and"WTDetailTableBeanDao.Properties.UNIT_ID.columnName"=?";strParamLt.add(dept);}//班组if(!CommonUtil.isNull(strClass)){queryString=queryString"and"WTDetailTableBeanDao.Properties.CLASS_ID.columnName"=?";strParamLt.add(strClass);}//票号if(!CommonUtil.isNull(ticketNo)){queryString=queryString"and"WTDetailTableBeanDao.Properties.TICKET_NO.columnName"like'%"ticketNo"%'";}//状态if(!CommonUtil.isNull(status)){queryString=queryString"and"WTDetailTableBeanDao.Properties.STATUS.columnName"=?";strParamLt.add(status);}//工作负责人if(!CommonUtil.isNull(workLeader)){queryString=queryString"and"WTDetailTableBeanDao.Properties.WORK_RESPONSOR_NAME.columnName"like'%"workLeader"%'";}//签字人if(!CommonUtil.isNull(signatory)){queryString=queryString"and"WTDetailTableBeanDao.Properties.WORK_SIGN_FIRST_NAME.columnName"like'%"signatory"%'";queryString=queryString"or"WTDetailTableBeanDao.Properties.WORK_SIGN_SECOND_NAME.columnName"like'%"signatory"%'";}//工作内容if(!CommonUtil.isNull(content)){queryString=queryString"and"WTDetailTableBeanDao.Properties.WORK_RESPONSOR_JOB.columnName"like'%"content"%'";}//工作负责人签字时间从和工作负责人签字时间到都不为空if(!CommonUtil.isNull(workLeaderOpenTime)&&!CommonUtil.isNull(workLeaderCloseTime)){queryString=queryString"and"WTDetailTableBeanDao.Properties.WORK_SIGN_THRID_DATE.columnName"BETWEEN'"workLeaderOpenTime"'AND'"workLeaderCloseTime"'";//工作负责人签字时间从不为空和工作负责人签字时间到为空}elseif(!CommonUtil.isNull(workLeaderOpenTime)&&CommonUtil.isNull(workLeaderCloseTime)){queryString=queryString"and"WTDetailTableBeanDao.Properties.WORK_SIGN_THRID_DATE.columnName"BETWEEN'"workLeaderOpenTime"'AND'"CommonUtil.getCurrentTime()"'";//工作负责人签字时间从为空和工作负责人签字时间到不为空}elseif(!CommonUtil.isNull(workLeaderOpenTime)&&CommonUtil.isNull(workLeaderCloseTime)){queryString=queryString"and"WTDetailTableBeanDao.Properties.WORK_SIGN_THRID_DATE.columnName"BETWEEN'2000-01-0100:00:00'AND'"workLeaderCloseTime"'";}Object[]objs=strParamLt.toArray();String[]strs=newString[objs.length];for(inti=0;i

页面结果：

redis八种淘汰策略是什么1、然后在选到的key中选择.volatile-r...

云虚拟主机和云服务器有什么区别?云安全怎么保障?虚拟主机现已全部位于云技术平台...

一、铺垫：基于socket发送http请求1、需求一：向百度发送请求搜索关键字...

下面的这些代码呢是在oc工程里里使用的其实和在swift中使用没什么大的差别...

java多人聊天一般都是怎么搭建的?1、建立服务器：在云服务商或自己的服务器上...

IP云是一个程序开发,程序设计,ip代理,程序员学习技术站,专注分享知识、经验、观念。在这里,所有程序员都能找到答案、参与讨论。

//获取本地Pad（离线工作票列表）publicstaticListgetPadWTList(Stringtoken,StringuserId,Stringorg,Stringdept,StringstrClass,StringticketNo,Stringtype,Stringstatus,StringisEvaluated,StringexceedTimeLimit,Stringerror,StringworkLeader,Stringsignatory,Stringcontent,StringcreateTimeLimit,Stringyear,StringworkLeaderOpenTime,//工作负责人签字时间从StringworkLeaderCloseTime,//工作负责人签字时间到StringallowEndOpenTime,StringallowEndCloseTime,Stringpage_number,Stringeach_page){ListlWTDetailTableBeanLt=newArrayList();//请求参数ArrayListstrParamLt=newArrayList();StringqueryString="SELECTDISTINCT*FROM"WTDetailTableBeanDao.TABLENAME"where1==1";//组织if(!CommonUtil.isNull(org)){queryString=queryString"and"WTDetailTableBeanDao.Properties.ORG_ID.columnName"=?";strParamLt.add(org);}//部门if(!CommonUtil.isNull(dept)){queryString=queryString"and"WTDetailTableBeanDao.Properties.UNIT_ID.columnName"=?";strParamLt.add(dept);}//班组if(!CommonUtil.isNull(strClass)){queryString=queryString"and"WTDetailTableBeanDao.Properties.CLASS_ID.columnName"=?";strParamLt.add(strClass);}//票号if(!CommonUtil.isNull(ticketNo)){queryString=queryString"and"WTDetailTableBeanDao.Properties.TICKET_NO.columnName"like'%"ticketNo"%'";}//状态if(!CommonUtil.isNull(status)){queryString=queryString"and"WTDetailTableBeanDao.Properties.STATUS.columnName"=?";strParamLt.add(status);}//工作负责人if(!CommonUtil.isNull(workLeader)){queryString=queryString"and"WTDetailTableBeanDao.Properties.WORK_RESPONSOR_NAME.columnName"like'%"workLeader"%'";}//签字人if(!CommonUtil.isNull(signatory)){queryString=queryString"and"WTDetailTableBeanDao.Properties.WORK_SIGN_FIRST_NAME.columnName"like'%"signatory"%'";queryString=queryString"or"WTDetailTableBeanDao.Properties.WORK_SIGN_SECOND_NAME.columnName"like'%"signatory"%'";}//工作内容if(!CommonUtil.isNull(content)){queryString=queryString"and"WTDetailTableBeanDao.Properties.WORK_RESPONSOR_JOB.columnName"like'%"content"%'";}//工作负责人签字时间从和工作负责人签字时间到都不为空if(!CommonUtil.isNull(workLeaderOpenTime)&&!CommonUtil.isNull(workLeaderCloseTime)){queryString=queryString"and"WTDetailTableBeanDao.Properties.WORK_SIGN_THRID_DATE.columnName"BETWEEN'"workLeaderOpenTime"'AND'"workLeaderCloseTime"'";//工作负责人签字时间从不为空和工作负责人签字时间到为空}elseif(!CommonUtil.isNull(workLeaderOpenTime)&&CommonUtil.isNull(workLeaderCloseTime)){queryString=queryString"and"WTDetailTableBeanDao.Properties.WORK_SIGN_THRID_DATE.columnName"BETWEEN'"workLeaderOpenTime"'AND'"CommonUtil.getCurrentTime()"'";//工作负责人签字时间从为空和工作负责人签字时间到不为空}elseif(!CommonUtil.isNull(workLeaderOpenTime)&&CommonUtil.isNull(workLeaderCloseTime)){queryString=queryString"and"WTDetailTableBeanDao.Properties.WORK_SIGN_THRID_DATE.columnName"BETWEEN'2000-01-0100:00:00'AND'"workLeaderCloseTime"'";}Object[]objs=strParamLt.toArray();String[]strs=newString[objs.length];for(inti=0;i

上一篇：涉县中医院视频号怎么挂号涉县中医院投诉电

下一篇：给香港服务器加cdn香港服务器搭建vps香港服