android自定义创建sql,GreenDao-自定义SQL查询-AndroidStudio

/**

* 功能：员工查询

* 方法参数：

* strEmpIdOrEmpName：员工ID 或者 员工名称

* strQueryType：员工查询类型 "0": "员工编号"; "1": "员工名称"

* strOrgId:当前所在组织

* strQualifType:资格条件

* strTicketType:票型

*/

public static List getEmployeeInfo(String strEmpIdOrEmpName, String strEmployeeQueryType,

String strOrgId, String strQualifyType, String strTicketType) {

List lResutEmployeeTableBeanLt = new ArrayList();

//拼接sql

String queryString = "SELECT DISTINCT * FROM " + EmployeeTableBeanDao.TABLENAME + " where 1==1 AND "+

EmployeeTableBeanDao.Properties.ORG_ID.columnName + " = ? AND " +

EmployeeTableBeanDao.Properties.QUALIF_TYPE.columnName + " = ? AND " +

EmployeeTableBeanDao.Properties.TICKET_TYPE.columnName