ifm/javasrc/business/interface/com/huimv/busi/xt/constant/XtSqlMapConstant.java

package com.huimv.busi.xt.constant;

/**
 * ibatis sql映射文件相关常量
 * @author hongjun.hu
 * @version 1.0
 * @history
 */
public interface XtSqlMapConstant {
	// 获取系统当前时间
	public static final String SQLMAP_GET_DATABASE_DATE = "get.database.date";
	
	/**
	 * 操作用户
	 */
	public static final String SQLMAP_SELECT_CZYH_BY_YHM = "select.czyh.by.yhm";
	public static final String SQLMAP_SELECT_ALL_CZYH = "select.all.czyh";
	public static final String SQLMAP_INSERT_CZYH = "insert.czyh";
	public static final String SQLMAP_UPDATE_CZYH = "update.czyh";
	public static final String SQLMAP_SELECT_CZYH_BY_ID = "select.czyh.by.id";
	public static final String SQLMAP_COUNT_CZYH_BY_PARAM = "count.czyh.by.param";
	public static final String SQLMAP_SELECT_CZYH_BY_PARAM = "select.czyh.by.param";
	public static final String SQLMAP_UPDATE_CZYH_XXW_BY_ID = "update.czyh.xxw.by.id";
	
	/**
	 * 系统参数 
	 */
	public static final String SQLMAP_SELECT_XTCS_BY_CSID = "select.xtcs.by.csid";
	public static final String SQLMAP_COUNT_XTCS_BY_PARAM = "count.xtcs.by.param";
	public static final String SQLMAP_COUNT_XTCS_BY_PARAM_JQCZ = "count.xtcs.by.param.jqcz";
	public static final String SQLMAP_SELECT_XTCS_BY_PARAM_JQCZ = "select.xtcs.by.param.jqcz";
	public static final String SQLMAP_SELECT_XTCS_BY_PARAM = "select.xtcs.by.param";	
	public static final String SQLMAP_INSERT_XTCS = "insert.xtcs";
	public static final String SQLMAP_UPDATE_XTCS = "update.xtcs";
	public static final String SQLMAP_SELECT_DMLB_BY_PARAM = "select.dmlb.by.param";
	public static final String SQLMAP_COUNT_DMLB_BY_PARAM = "count.dmlb.by.param";
	public static final String SQLMAP_SELECT_GYDM_BY_PARAM = "select.gydm.by.param";
	public static final String SQLMAP_COUNT_GYDM_BY_PARAM = "count.gydm.by.param";
	public static final String SQLMAP_SELECT_MAX_GYDM_DMID_BY_LBID = "select.max.gydm.dmid.by.lbid";
	public static final String SQLMAP_SELECT_SBCS_BY_PARAM = "select.sbcs.by.param";
	public static final String SQLMAP_SELECT_SBCS_ID_BY_ZSID = "select.sbcs.id.by.zsid";
	public static final String SQLMAP_COUNT_SELECT_SBCS_BY_PARAM = "select.count.sbcs.by.param";
	public static final String SQLMAP_COUNT_SELECT_FWJL_BY_PARAM = "select.count.fwjl.by.param";
	public static final String SQLMAP_SELECT_DQTZ_FWJL_BY_PARAM = "select.dqtz.fwjl.by.param";
	public static final String SQLMAP_SELECT_FWCS_BY_DWEB = "select.fwcs.by.dweb";
	public static final String SQLMAP_SELECT_MAX_SBCS_ID = "select.max.sbcs.id";
	public static final String SQLMAP_SELECT_LQID_BY_PARAM = "select.lqid.by.param";
	public static final String SQLMAP_SELECT_PJTZ_BY_PARAM = "select.pjtz.by.param";
	public static final String SQLMAP_SELECT_LQDA_BY_PARAM = "select.lqda.by.param";
	public static final String SQLMAP_SELECT_FWSJ_BY_PARAM = "select.maxfwjl.by.param";

	public static final String SQLMAP_SELECT_FLZZD_BY_PARAM = "select.flzzd.by.param";
	public static final String SQLMAP_COUNT_SELECT_FLZZD_BY_PARAM = "select.count.flzzd.by.param";
	
	public static final String SQLMAP_SELECT_CSJLGZJC_BY_PARAM = "select.csjlgzjc.by.param";
	public static final String SQLMAP_COUNT_SELECT_CSJLGZJC_BY_PARAM = "select.count.csjlgzjc.by.param";
	
	//环境报警参数
	public static final String SQLMAP_COUNT_HJBJCS_BY_PARAM = "count.hjbjcs.by.param";
	public static final String SQLMAP_SELECT_HJBJCS_BY_PARAM = "select.hjbjcs.by.param";
	public static final String SQLMAP_SELECT_MAX_SSQTJC_BY_PARAM = "select.max.ssqtjc.by.param";
	public static final String SQLMAP_SELECT_MAXSSHJKZ_BY_PARAM = "select.max.sshjkz.by.param";
	public static final String SQLMAP_SELECT_HJBJCS_BY_DQLQ = "select.hjbjcs.by.dqlq";
	public static final String SQLMAP_SELECT_HJBJCS_CHECK_ZSXX = "select.hjbjcs.check.zsxx";
	
	// 环境报警手机配置
	public static final String SQLMAP_COUNT_HJBJSJPZ_BY_PARAM = "count.hjbjsjpz.by.param";
	public static final String SQLMAP_SELECT_HJBJSJPZ_BY_PARAM = "select.hjbjsjpz.by.param";
	public static final String SQLMAP_SELECT_HJBJSJPZ_CHECK_ZSXX = "select.hjbjsjpz.check.zsxx";
	
	/**
	 * 消息通知
	 */
	public static final String SQLMAP_SELECT_XWFB_BY_PARAM = "select.xwfb.by.param";
	public static final String SQLMAP_COUNT_XWFB_BY_PARAM = "count.xwfb.by.param";
	public static final String SQLMAP_GET_XWFB_MAX_ID = "get.xwfb.max.id";
	public static final String SQLMAP_SELECT_XXTZ_BY_PARAM = "select.xxtz.by.param";
	public static final String SQLMAP_COUNT_XXTZ_BY_PARAM = "count.xxtz.by.param";
	public static final String SQLMAP_GET_XXTZ_MAX_ID = "get.xxtz.max.id";
	public static final String SQLMAP_SELECT_XXTZ_FIT_TIME = "select.xxtz.fit.time";
	

	/**
	 * 微信号
	 */
	public static final String SQLMAP_SELECT_WXH_BY_PARAM = "select.wxh.by.param";
	/**
	 * 公用代码
	 */
	public static final String SQLMAP_SELECT_GYDM_BY_LBMC = "select.gydm.by.lbmc";
	public static final String SQLMAP_SELECT_GYDM_BY_LBMC_NOLIKE = "select.gydm.by.lbmc.nolike";
	
	/**
	 * 版本信息
	 */
	public static final String SQLMAP_SELECT_BBXX_BY_PARAM = "select.bbxx.by.param";
	public static final String SQLMAP_COUNT_BBXX_BY_PARAM = "count.bbxx.by.param";
	public static final String SQLMAP_SELECT_BBXX_BY_MAX_FBSJ = "select.bbxx.by.max.fbsj";
	
	/**
	 * 档案信息
	 */
	public static final String DWS_SELECT_LQWHXX_BY_LQID = "dws.select.lqwhxx.by.lqid";
	public static final String DWS_SELECT_LQWHXX_BY_LQID_FSSJ = "dws.select.lqwhxx.by.lqid.fssj";
	public static final String ID_SELECT_LQWHXX_BY_LQID = "id.select.lqwhxx.by.lqid";
	public static final String ZLS_UPDATE_LQWHXX_BY_ID = "zls.update.lqwhxx.by.id";
	public static final String SQLMAP_COUNT_FWJL_BY_PARAM = "count.fwjl.by.param";
	
	/**
	 * 输入器
	 */
	public static final String SQLMAP_SRQ_SELECT_CZYH_BY_PARAM = "srq.select.czyh.by.param";
	public static final String SQLMAP_SRQ_SELECT_XZQH_BY_PARAM = "srq.select.xzqh.by.param";
	public static final String SQLMAP_SRQ_SELECT_GYDM_BY_PARAM = "srq.select.gydm.by.param";
	
	/**
	 * 统计图
	 */
	public static final String SQLMAP_TJT_CZYH_BY_XB = "tjt.czyh.by.xb";
	
	/**
	 * 牧场数据
	 */
	//群体今天小时采食次数
	public static final String SQLMAP_TJT_QTJTXSCSCS_BY_PARAM = "tjt.qtjtxscscs.by.param";
	public static final String SQLMAP_TJT_SLJTSCSL_BY_PARAM = "tjt.sljtscsl.by.param";
	public static final String SQLMAP_TXTZ_SBCS_BY_LQID = "txtz.sbcs.by.lqid";
	public static final String SQLMAP_SELECT_SUM_RCSSJ_BY_PARAM = "select_sum_rcssj_by_param";
	
	
	/**
	 * 行政区划
	 */
	// 根据行政区划编码获取行政区划信息
	public static final String SQLMAP_SELECT_XZQH_BY_QHBM = "select.xzqh.by.qhbm";
	// 根据上级区划编码获取下级行政区划
	public static final String SQLMAP_SELECT_XZQH_BY_SJQHBM = "select.xzqh.by.sjqhbm";
	// 根据上级区划编码统计是否有下级行政区划
	public static final String SQLMAP_COUNT_XZQH_BY_SJQHBM = "count.xzqh.by.sjqhbm";
	public static final String SQLMAP_XZQH_GET_MAX_QHBM = "xzqh.get.max.qhbm";
	
	/**
	 * 档案SQLMapConstant
	 */
	public static final String SQLMAP_SELECT_MCDA_BY_PARAM = "select.mcda.by.param";
	public static final String SQLMAP_COUNT_MCDA_BY_PARAM = "count.mcda.by.param";
	public static final String SELECT_ZSDA_BY_MCID = "select.zsda.by.mcid";
	public static final String SELECT_LQDA_BY_ZSID = "select.lqda.by.zsid";
	public static final String SELECT_DWDA_BY_LQID = "select.dwda.by.lqid";
	public static final String GET_MAX_DWBH_BY_LQID = "get.max.dwbh.by.lqid";
	public static final String SELECT_DWDADTO_BY_PARAM = "select.dwdaDTO.by.param";
	public static final String COUNT_DWDADTO_BY_PARAM = "count.dwdaDTO.by.param";
	public static final String SQLMAP_COUNT_SLDA_BY_PARAM = "count.slda.by.param";
	public static final String SELECT_DQLQ_BY_PARAM = "select.dqlq.by.param";
	public static final String SQLMAP_SELECT_LQSLWHXX_PARAM = "select.lqslwhxx.by.param";
	public static final String SQLMAP_COUNT_LQSLWHXX_PARAM = "count.lqslwhxx.by.param";
	public static final String SQLMAP_SELECT_SLDA_BY_PARAM = "select.slda.by.param";
	public static final String SQLMAP_COUNT_SLXX_BY_PARAM = "count.slxx.by.param";
	public static final String SQLMAP_SELECT_SLXX_BY_PARAM = "select.slxx.by.param";
	public static final String SQLMAP_SELECT_ZSMCDA_BY_JQID = "select.zsmcda.by.jqid";
	public static final String SQLMAP_SELECT_JQDA_BY_PARAM = "select.jqda.by.param";
	public static final String SQLMAP_UPDATE_XLH_BY_XLH = "update.xlh.by.xlh";
	
	/**
	 * 数据SQLMapConstant
	 */
	public static final String SQLMAP_SELECT_SCSSJ_BY_PARAM = "select.scssj.by.param";
	public static final String SQLMAP_COUNT_SCSSJ_BY_PARAM = "count.scssj.by.param";
	
	// 在select结果中增加了da_zsda.MCMC
	public static final String SQLMAP_SELECT_ZSDA_BY_PARAM = "select.zsda.by.param";
	// 在count结果中增加了da_zsda.MCMC
	public static final String SQLMAP_COUNT_ZSDA_BY_PARAM = "count.zsda.by.param";
	
	public static final String SQLMAP_SELECT_ZSJK_BY_PARAM = "select.zsjk.by.param";
	public static final String SQLMAP_COUNT_ZSJK_BY_PARAM = "count.zsjk.by.param";
	public static final String SQLMAP_SELECT_ZSJK_BY_LQID = "select.zsjk.by.lqid";
	public static final String SQLMAP_COUNT_ZSJK_BY_LQID = "count.zsjk.by.lqid";
	
	public static final String SQLMAP_COUNT_YDJK_BY_PARAM = "count.ydjk.by.param";
	public static final String SQLMAP_SELECT_YDJK_BY_PARAM = "select.ydjk.by.param";

	
	public static final String SQLMAP_SELECT_ZSMCDA_BY_PARAM = "select.zsmcda.by.param";
	
	public static final String SQLMAP_SELECT_DQLQ_LQID = "select.dqlq.lqid";

	/**
	 * WebService 分栏站数据通信
	 */
	public static final String SQLMAP_SELECT_MAX_WFJL_TIME_BY_PARAM = "select.max.fwjl.time.by.param";
	public static final String SQLMAP_SELECT_MAX_SSCSSJ_TIME_BY_PARAM = "select.max.sscssj.time.by.param";
	public static final String SQLMAP_INSERT_FWJL_BY_PARAM = "insert.fwjl.by.param";
	public static final String SQLMAP_INSERT_FWJLTEMP_BY_PARAM = "insert.fwjltemp.by.param";
	public static final String SQLMAP_INSERT_SSCSSJ_BY_PARAM = "insert.sscssj.by.param";
	public static final String SQLMAP_SELECT_MAX_SSHJKZ_BY_PARAM = "select.max.sshjkz.time.by.param";
	public static final String SQLMAP_INSERT_SSHJKZ_BY_PARAM = "insert.sshjkz.by.param";
	public static final String SQLMAP_SELECT_MAX_SSQTJC_TIME_BY_PARAM = "select.max.ssqtjc.time.by.param";
	public static final String SQLMAP_INSERT_SSQTJC_BY_PARAM = "insert.ssqtjc.by.param";
	public static final String SQLMAP_SELECT_DQLQ_FROM_ZSDA_AND_JQDA_BY_JQID="select.dqlq.from.zsda.and.jqda.by.jqid";
	
	/**
	 * 权限管理
	 */
	public static final String SQLMAP_SELECT_QXXX_BY_JSID = "select.qxxx.by.jsid";
	public static final String SQLMAP_SELECT_CZYH_BY_JSID = "select.czyh.by.jsid";
	
	/**
	 * 存储过程
	 */
	public static final String SQLMAP_PRC_MCSJ = "prc.ifm.mcsj";	// 同步用户姓名到临时表
	public static final String SQLMAP_PRC_SNHJ = "prc.ifm.snhj";	// 同步舍内环境
	public static final String SQLMAP_PRC_SLXX = "prc.ifm.slxx";	// 上料信息
	
	public static final String SQLMAP_SELECT_FWJL_BY_PARAM = "select.fwjl.by.param";
	public static final String SQLMAP_SELECT_WDFB_BY_TS = "select.wdfb.by.ts";
	public static final String SQLMAP_SELECT_WDFB_BY_SJ_RI = "select.wdfb.by.sj.ri";
	public static final String SQLMAP_SELECT_WDFB_BY_SJ_QC = "select.wdfb.by.sj.qc";
	public static final String SQLMAP_SELECT_EBFWJL_START = "select.ebfwjl.start";
	public static final String SQLMAP_SELECT_FWJL_BY_WDQJ = "select.fwjl.by.wdqj";
	
	/**
	 * 小米消息推送
	 */
	public static final String SQLMAP_UPDATE_XX_TSXXJL_BY_XXID = "update.tsxxjl.by.xxid";
	
	/**
	 * GRPS
	 */
	public static final String SQLMAP_COUNT_BJQCSSZ_BY_PARAM = "count.bjqcssz.by.param";
	public static final String SQLMAP_SELECT_BJQCSSZ_BY_PARAM = "select.bjqcssz.by.param";
	public static final String SQLMAP_COUNT_BJQTXMX_BY_PARAM = "count.bjqtxmx.by.param";
	public static final String SQLMAP_SELECT_BJQTXMX_BY_PARAM = "select.bjqtxmx.by.param";
	public static final String SQLMAP_SELECT_BJQCSSZ_BY_PARAM2 = "select.bjqcssz.by.param2";
	public static final String SQLMAP_COUNT_BJQWD_BY_PARAM = "count.bjqwd.by.param";
	public static final String SQLMAP_SELECT_BJQWD_BY_PARAM = "select.bjqwd.by.param";
	
	/**
	 * dwda
	 */
	public static final String SQLMAP_SELECT_WFWDW_BY_PARAM = "select.wfwdw.by.parm";
	public static final String SQLMAP_SELECT_COUNT_WFWDW_BY_PARAM = "select.count.wfwdw.by.parm";
	/**
	 * SjLqjl
	 */
	public static final String SQLMAP_COUNT_SELECT_SJLQJL_BY_PARAM = "select.count.sjlqjl.by.param";
	public static final String SQLMAP_SELECT_SJLQJL_BY_PARAM = "select.sjlqjl.by.param"; 
	public static final String SQLMAP_SELECT_SJLQJL_WEBSERVICEXYXX_BY_PARAM = "select.sjlqjl.webservicexyxx.by.param"; 
	public static final String SQLMAP_SCSLXX_SELECT_SJLQJL_BY_PARAM = "select.count.scslxx.by.param";
	public static final String SQLMAP_SELECT_SJLQJL_SCSLXX_BY_PARAM = "select.sjlqjl.scslxx.by.param"; 
	
	public static final String SQLMAP_SCFWJLXX_SELECT_SJLQJL_BY_PARAM = "select.count.scfwjlxx.by.param";
	
	public static final String SQLMAP_SCHJKZXX_SELECT_SJLQJL_BY_PARAM = "select.count.schjkzxx.by.param";
	
	public static final String SQLMAP_SELECT_SJLQJL_SCFWJL_BY_PARAM = "select.sjlqjl.scfwjlxx.by.param"; 
	
	public static final String SQLMAP_SELECT_SJLQJL_SCHJKZ_BY_PARAM = "select.sjlqjl.schjkzxx.by.param";
	
	/**
	 * 统计分析
	 */
	public static final String SQLMAP_GET_HYCDRZZ_BY_PARAM = "get.hycdrzz.by.parm";
	
	/**
	 * 外部环控
	 */
	public static final String SQLMAP_SELECT_WBHJ_MAXTIME_BY_PARAM = "select.wbhj.maxtime.by.param";
	public static final String SQLMAP_INSERT_WBHJLIST_BY_PARAM = "insert.wbhjlist.by.param";
	public static final String SQLMAP_SELECT_WBHJ_WD_BY_PARAM = "select.wbhj.wd.by.param";
	public static final String SQLMAP_SELECT_WBHJ_QCWD_BY_PARAM = "select.wbhj.qcwd.by.param";
	public static final String SQLMAP_SELECT_WBHJ_SD_BY_PARAM = "select.wbhj.sd.by.param";
	public static final String SQLMAP_SELECT_WBHJ_QCSD_BY_PARAM = "select.wbhj.qcsd.by.param";
	public static final String SQLMAP_SELECT_SWWD_BY_PARAM = "select.swwd.by.param";
	public static final String SQLMAP_SELECT_SWSD_BY_PARAM = "select.swsd.by.param";
	public static final String SQLMAP_SELECT_QCSWWD_BY_PARAM = "select.qcswwd.by.param";
	public static final String SQLMAP_SELECT_QCSWSD_BY_PARAM = "select.qcswsd.by.param";
	
	/**
	 * 采食计量运行参数
	 */
	public static final String SQLMAP_SELECT_COUNT_CSJLYXCS_BY_PARAM = "select.count.csjlyxcs.by.param";
	public static final String SQLMAP_SELECT_CSJLYXCS_BY_PARAM = "select.csjlyxcs.by.param";
	public static final String SQLMAP_SELECT_DPCSJLPZ_BY_PARAM = "select.dpcsjlpz.by.param";
	
	// 免疫登记
	public static final String SQLMAP_COUNT_DAMYDJ_BY_PARAM = "count.mydj.by.param";
	public static final String SQLMAP_SELECT_DAMYDJ_BY_PARAM = "select.mydj.by.param";
	
	// 疾病登记
	public static final String SQLMAP_COUNT_DAJBDJ_BY_PARAM = "count.jbdj.by.param";
	public static final String SQLMAP_SELECT_DAJBDJ_BY_PARAM = "select.jbdj.by.param";
	
	// 转群历史
	public static final String SQLMAP_COUNT_DAZQLS_BY_PARAM = "count.zqls.by.param";
	public static final String SQLMAP_SELECT_DAZQLS_BY_PARAM = "select.zqls.by.param";
	
	// 个推
	public static final String SQLMAP_COUNT_GTTS_BY_PARAM = "count.gtts.by.param";
	public static final String SQLMAP_UPDATE_CLICKNUM_BY_XXID = "update.clicknum.by.xxid";
	public static final String SQLMAP_COUNT_GTXXTS_BY_PARAM = "count.gtxxts.by.param";
	public static final String SQLMAP_SELECT_GTXXTS_BY_PARAM = "select.gtxxts.by.param";
	public static final String SQLMAP_SELECT_ZY_BY_PARAM="select.zy.by.param";
	public static final String SQLMAP_SELECT_XXTS_BY_PARAM="select.xxts.by.param";
	public static final String SQLMAP_COUNT_SBXX_BY_PARAM="count.sbxx.by.param";
	
	// haifm
	public static final String SQLMAP_SELECT_MCLIST_BY_PARAM = "select.mclist.by.param";
	public static final String SQLMAP_SELECT_ZSLIST_ZSID_BY_PARAM = "select.zslist.zsid.by.param";
	public static final String SQLMAP_SELECT_ZSLIST_ZSXX_BY_PARAM = "select.zslist.zsxx.by.param";
	public static final String SQLMAP_SELECT_ZSDADTO_BY_XLH = "select.zsdadto.by.xlh";
	public static final String SQLMAP_COUNT_ZSID_FROM_DAZSDA = "count.zsid.from.daZsda";
	public static final String SQLMAP_SELECT_PTZSLIST_ZSID_BY_PARAM = "select.ptzslist.zsid.by.param";
	
	// 环控
	public static final String SQLMAP_SELECT_HKWD_MAXTIME_BY_PARAM = "select.hkwd.maxtime.by.param";
	public static final String SQLMAP_SELECT_HKSD_MAXTIME_BY_PARAM = "select.hksd.maxtime.by.param";
	public static final String SQLMAP_SELECT_QCHKWD_BY_PARAM = "select.qchkwd.by.param";
	public static final String SQLMAP_SELECT_DQHKWD_BY_PARAM = "select.dqhkwd.by.param";
	public static final String SQLMAP_SELECT_HKWD_CGQID_BY_PARAM= "select.hkwd.cgqid.by.param";
	public static final String SQLMAP_SELECT_QCHKSD_BY_PARAM = "select.qchksd.by.param";
	public static final String SQLMAP_SELECT_DQHKSD_BY_PARAM = "select.dqhksd.by.param";
	public static final String SQLMAP_SELECT_HKSD_CGQID_BY_PARAM= "select.hksd.cgqid.by.param";
	public static final String SQLMAP_SELECT_COUNT_HK_YXZT_BY_PARAM = "select.count.hk.yxzt.by.param";
	public static final String SQLMAP_SELECT_HK_YXZT_BY_PARAM = "select.hk.yxzt.by.param";
	public static final String SQLMAP_SELECT_COUNT_HK_YXCS_BY_PARAM = "select.count.hk.yxcs.by.param";
	public static final String SQLMAP_SELECT_HK_YXCS_BY_PARAM = "select.hk.yxcs.by.param";
	public static final String SQLMAP_SELECT_HK_HKWD_ZTGKWD_BY_PARAM = "select.hkwd.ztgkwd.by.param";
	public static final String SQLMAP_SELECT_HK_HKSD_ZTGKSD_BY_PARAM = "select.hksd.ztgksd.by.param";
	public static final String SQLMAP_SELECT_HKBJ_GZXX_BY_PARAM = "select.hkbj.gzxx.by.param";
	public static final String SQLMAP_SELECT_HKBJ_GZXXLIST_BY_PARAM = "select.hkbj.gzxxlist.by.param";
	public static final String SQLMAP_SELECT_HKBJ_GZXXLIST_FROM_MCID_BY_PARAM = "select.hkbj.gzxxlist.from.mcid.by.param";
	public static final String SQLMAP_SELECT_HKBJ_GZXXLISTALL_BY_PARAM = "select.hkbj.gzxxlistAll.by.param";
	public static final String SQLMAP_SELECT_HKAQ_MAXTIME_BY_PARAM = "select.hkaq.maxtime.by.param";
	public static final String SQLMAP_SELECT_QCHKAQ_BY_PARAM = "select.qchkaq.by.param";
	public static final String SQLMAP_SELECT_DQHKAQ_BY_PARAM = "select.dqhkaq.by.param";
	public static final String SQLMAP_SELECT_HKAQ_CGQID_BY_PARAM= "select.hkaq.cgqid.by.param";
	public static final String SQLMAP_SELECT_HKYQ_MAXTIME_BY_PARAM = "select.hkyq.maxtime.by.param";
	public static final String SQLMAP_SELECT_QCHKYQ_BY_PARAM = "select.qchkyq.by.param";
	public static final String SQLMAP_SELECT_DQHKYQ_BY_PARAM = "select.dqhkyq.by.param";
	public static final String SQLMAP_SELECT_HKYQ_CGQID_BY_PARAM= "select.hkyq.cgqid.by.param";
	public static final String SQLMAP_SELECT_HKEYHT_MAXTIME_BY_PARAM = "select.hkeyht.maxtime.by.param";
	public static final String SQLMAP_SELECT_QCHKEYHT_BY_PARAM = "select.qchkeyht.by.param";
	public static final String SQLMAP_SELECT_DQHKEYHT_BY_PARAM = "select.dqhkeyht.by.param";
	public static final String SQLMAP_SELECT_HKEYHT_CGQID_BY_PARAM= "select.hkeyht.cgqid.by.param";
	public static final String SQLMAP_SELECT_HKLHQ_MAXTIME_BY_PARAM = "select.hklhq.maxtime.by.param";
	public static final String SQLMAP_SELECT_QCHKLHQ_BY_PARAM = "select.qchklhq.by.param";
	public static final String SQLMAP_SELECT_DQHKLHQ_BY_PARAM = "select.dqhklhq.by.param";
	public static final String SQLMAP_SELECT_HKLHQ_CGQID_BY_PARAM= "select.hklhq.cgqid.by.param";
	public static final String SQLMAP_SELECT_HKDL_MAXTIME_BY_PARAM = "select.hkdl.maxtime.by.param";
	public static final String SQLMAP_SELECT_QCHKDL_BY_PARAM = "select.qchkdl.by.param";
	public static final String SQLMAP_SELECT_DQHKDL_BY_PARAM = "select.dqhkdl.by.param";
	public static final String SQLMAP_SELECT_HKDL_CGQID_BY_PARAM= "select.hkdl.cgqid.by.param";
	public static final String SQLMAP_SELECT_HKSL_MAXTIME_BY_PARAM = "select.hksl.maxtime.by.param";
	public static final String SQLMAP_SELECT_QCHKSL_BY_PARAM = "select.qchksl.by.param";
	public static final String SQLMAP_SELECT_DQHKSL_BY_PARAM = "select.dqhksl.by.param";
	public static final String SQLMAP_SELECT_HKSL_CGQID_BY_PARAM= "select.hksl.cgqid.by.param";
	public static final String SQLMAP_COUNT_SNHJBUTTON_BY_LQID= "count.snhjButton.by.lqid";
	public static final String SQLMAP_SELECT_QCHKCS_BY_PARAM = "select.qchkcs.by.param";
	public static final String SQLMAP_SELECT_DQHKCS_BY_PARAM = "select.dqhkcs.by.param";
	public static final String SQLMAP_SELECT_HKCS_CGQID_BY_PARAM= "select.hkcs.cgqid.by.param";
	public static final String SQLMAP_SELECT_HKCS_MAXTIME_BY_PARAM = "select.hkcs.maxtime.by.param";
	public static final String SQLMAP_SELECT_HKSL_EVERYHOUR_BY_PARAM = "select.hksl.everyHour.by.param";
	public static final String SQLMAP_SELECT_HKDL_EVERYHOUR_BY_PARAM = "select.hkdl.everyHour.by.param";
	public static final String SQLMAP_SELECT_SL_MAX_MIN_BY_PARAM = "select.sl.max.min.by.param";
	public static final String SQLMAP_SELECT_DL_MAX_MIN_BY_PARAM = "select.dl.max.min.by.param";
	
	public static final String SQLMAP_SELECT_HKPH_MAXTIME_BY_PARAM = "select.hkph.maxtime.by.param";
	public static final String SQLMAP_SELECT_QCHKPH_BY_PARAM = "select.qchkph.by.param";
	public static final String SQLMAP_SELECT_DQHKPH_BY_PARAM = "select.dqhkph.by.param";
	public static final String SQLMAP_SELECT_HKPH_CGQID_BY_PARAM= "select.hkph.cgqid.by.param";
	public static final String SQLMAP_SELECT_HKSYTOF_BY_PARAM = "select.hksytof.by.param";
	
	public static final String SQLMAP_SELECT_HKSY_MAXTIME_BY_PARAM = "select.hksy.maxtime.by.param";
	public static final String SQLMAP_SELECT_QCHKSY_BY_PARAM = "select.qchksy.by.param";
	public static final String SQLMAP_SELECT_DQHKSY_BY_PARAM = "select.dqhksy.by.param";
	public static final String SQLMAP_SELECT_HKSY_CGQID_BY_PARAM= "select.hksy.cgqid.by.param";
	
	public static final String SQLMAP_SELECT_HKDN_MAXTIME_BY_PARAM = "select.hkdn.maxtime.by.param";
	public static final String SQLMAP_SELECT_QCHKDN_BY_PARAM = "select.qchkdn.by.param";
	public static final String SQLMAP_SELECT_DQHKDN_BY_PARAM = "select.dqhkdn.by.param";
	public static final String SQLMAP_SELECT_HKDN_CGQID_BY_PARAM= "select.hkdn.cgqid.by.param";
	
	//计量料槽
	public static final String SQLMAP_SELECT_MAX_JLLCSJ_BY_PARAM = "select.max.jllcsj.time.by.param";
	public static final String SQLMAP_SELECT_JLLCSJ_CSL_BY_PARAM = "select.jllcsj.csl.by.param";
	public static final String SQLMAP_SELECT_JLLCSJ_LCID_BY_PARAM = "select.jllcsj.lcid.by.param";
	public static final String SQLMAP_SELECT_JLLCSJ_LCCSL_BY_PARAM = "select.jllcsj.lccsl.by.param";
	public static final String SQLMAP_SELECT_JLLCSJ_LCID_CSL_BY_PARAM = "select.jllcsj.lcid.csl.by.param";
	public static final String SQLMAP_SELECT_JLLCSJ_HYZS_BY_PARAM = "select.jllcsj.hyzs.by.param";
	public static final String SQLMAP_SELECT_JLLCSJ_SUM_CSL_BY_PARAM = "select.jllcsj.sum.csl.by.param";
	
	//jqda
	public static final String SQKMAP_SELECT_JQDA_MAX_JQID = "select.jqda.max.jqid";
	
	//养殖助手
	public static final String SQLMAP_SELECT_LYPZ_BY_PARAM = "select.lypz.by.param";
	
	//全控
	public static final String SQLMAP_SELECT_MCID_BY_JQID = "select.mcid.by.jqid";
	
	//猪舍区域
	public static final String SQLMAP_SELECT_ZSQYLIST_BY_MCID = "select.zsqyList.by.mcid";
	
	/** 数据录入 **/
	//档案
	public static final String SQLMAP_SELECT_SJLR_GZDA_BY_PARAM = "select.sjlr.gzda.by.param";
	//母猪档案
	public static final String SQLMAP_SELECT_SJLR_MZDA_BY_PARAM = "select.sjlr.mzda.by.param";
	public static final String SQLMAP_SELECT_SJLR_MZDA_BY_PZJL = "select.sjlr.mzda.by.pzjl";
	public static final String SQLMAP_SELECT_SJLR_MZXX_BY_PARAM = "select.sjlr.mzxx.by.param";
	public static final String SQLMAP_SELECT_SJLR_TTMZXX_BY_PARAM = "select.sjlr.ttmzxx.by.param";
	public static final String SQLMAP_SELECT_SJLR_MZDA_BY_ZZDS = "select.sjlr.mzda.by.zzds";
	public static final String SQLMAP_UPDATE_ALL_DWEB_BY_PARAM = "update.all.dweb.by.param";
	
	
	//公猪档案
	public static final String SQLMAP_SELECT_SJLR_GZDAPZJG_BY_PARAM = "select.sjlr.gzdapzjg.by.param";
	//采精
	public static final String SQLMAP_SELECT_SJLR_CJJL_BY_PARAM = "select.sjlr.cjjl.by.param";
	//配种
	public static final String SQLMAP_SELECT_SJLR_PZJL_BY_PARAM = "select.sjlr.pzjl.by.param";
	public static final String SQLMAP_SELECT_SJLR_PZJL_MZLIST_BY_PARAM = "select.sjlr.pzjl.mzlist.by.param";
	public static final String SQLMAP_COUNT_SJLR_PZJL_BY_PARAM = "count.sjlr.pzjl.by.param";
	public static final String SQLMAP_COUNT_SJLR_PZFM_BY_PARAM = "count.sjlr.pzfm.by.param";
	public static final String SQLMAP_COUNT_SJLR_PZTC_BY_PARAM = "count.sjlr.pztc.by.param";
	public static final String SQLMAP_SELECT_SJLR_PZJLADD_BY_PARAM = "select.sjlr.pzjlAdd.by.param";
	//断奶
	public static final String SQLMAP_SELECT_SJLR_DNJL_BY_PARAM = "select.sjlr.dnjl.by.param";
	public static final String SQLMAP_SELECT_SJLR_SEARCHDNJL_BY_PARAM = "select.sjlr.searchdnjl.by.param";
	public static final String SQLMAP_SELECT_SJLR_ADDDNJL_BY_PARAM = "select.sjlr.adddnjl.by.param";
	public static final String SQLMAP_SELECT_SJLR_DNJLTC_BY_PARAM = "select.sjlr.dnjltc.by.param";
	//妊娠
	public static final String SQLMAP_SELECT_SJLR_RSJL_BY_PARAM = "select.sjlr.rsjl.by.param";
	public static final String SQLMAP_SELECT_SJLR_RSJLPZ_BY_PARAM = "select.sjlr.rsjlpz.by.param";
	public static final String SQLMAP_SELECT_SJLR_RSJLID_BY_PARAM = "select.sjlr.rsjlid.by.param";
	//分娩
	public static final String SQLMAP_SELECT_SJLR_FMJL_BY_PARAM = "select.sjlr.fmjl.by.param";
	public static final String SQLMAP_SELECT_SJLR_ADDFMJL_BY_PARAM = "select.sjlr.addfmjl.by.param";
	public static final String SQLMAP_SELECT_SJLR_SEARCHFMJL_BY_PARAM = "select.sjlr.searchfmjl.by.param";
	public static final String SQLMAP_COUNT_SJLR_FMJL_BY_PARAM = "count.sjlr.fmjl.by.param";
	//种猪转群
	public static final String SQLMAP_SELECT_SJLR_ZZZQ_BY_PARAM = "select.sjlr.zzzq.by.param";
	public static final String SQLMAP_SELECT_SJLR_DA_BY_PARAM = "select.sjlr.da.by.param";
	//种猪死亡
	public static final String SQLMAP_SELECT_SJLR_ZZSW_BY_PARAM = "select.sjlr.zzsw.by.param";
	//种猪淘汰
	public static final String SQLMAP_SELECT_SJLR_ZZTT_BY_PARAM = "select.sjlr.zztt.by.param";
	public static final String SQLMAP_SELECT_SJLR_ZZTT_DA_SL_BY_DWEBPARAM = "select.sjlr.zztt.da.sl.param";
	//普通免疫
	public static final String SQLMAP_SELECT_SJLR_PTMY_BY_PARAM = "select.sjlr.ptmy.by.param";
	//种猪免疫
	public static final String SQLMAP_SELECT_SJLR_ZZMY_BY_PARAM = "select.sjlr.zzmy.by.param";
	//肥猪免疫
	public static final String SQLMAP_SELECT_SJLR_FZMY_BY_PARAM = "select.sjlr.fzmy.by.param";
	//种猪免疫档案
	public static final String SQLMAP_SELECT_SJLR_ZZMY_DA_BY_PARAM = "select.sjlr.zzmy.da.by.param";
	
	//种猪销售档案
	public static final String SQLMAP_SELECT_SJLR_ZZXS_DA_BY_PARAM = "select.sjlr.zzxs.da.by.param";
	//种猪销售
	public static final String SQLMAP_SELECT_SJLR_ZZXS_BY_PARAM = "select.sjlr.zzxs.by.param";
	public static final String SQLMAP_SELECT_SJLR_ZZXSlIST_BY_PARAM = "select.sjlr.zzxsList.by.param";
	
	//肥猪销售单据
	public static final String SQLMAP_SELECT_SJLR_FZXS_Dj_BY_PARAM = "select.sjlr.fzxs.dj.by.param";
	//肥猪销售
	public static final String SQLMAP_SELECT_SJLR_FZXS_BY_PARAM = "select.sjlr.fzxs.by.param";
	//舍栏喂料
	public static final String SQLMAP_SELECT_SJLR_SLWL_BY_PARAM = "select.sjlr.slwl.by.param";
	
	//种猪待售档案
	public static final String SQLMAP_SELECT_SJLR_ZZDSTJ_BY_PARAM = "select.sjlr.zzdstj.by.param";
	//种猪待售
	public static final String SQLMAP_SELECT_SJLR_ZZDS_BY_PARAM = "select.sjlr.zzds.by.param";
	//种猪温度
	public static final String SQLMAP_SELECT_SJLR_ZZWD_BY_PARAM = "select.sjlr.zzwd.by.param";
	/** 数据录入 **/

	
	/** 污水 **/
	public static final String SQLMAP_SELECT_WSBOD_CGQID_BY_PARAM = "select.wsbod.cgqid.by.param";
	public static final String SQLMAP_SELECT_WSBOD_BY_PARAM = "select.wsbod.by.param";
	public static final String SQLMAP_SELECT_QCBOD_BY_PARAM = "select.qcbod.by.param";

	public static final String SQLMAP_SELECT_WSCOD_CGQID_BY_PARAM = "select.wscod.cgqid.by.param";
	public static final String SQLMAP_SELECT_WSCOD_BY_PARAM = "select.wscod.by.param";
	public static final String SQLMAP_SELECT_QCCOD_BY_PARAM = "select.qccod.by.param";
	
	public static final String SQLMAP_SELECT_WSSS_CGQID_BY_PARAM = "select.wsss.cgqid.by.param";
	public static final String SQLMAP_SELECT_WSSS_BY_PARAM = "select.wsss.by.param";
	public static final String SQLMAP_SELECT_QCSS_BY_PARAM = "select.qcss.by.param";
	
	public static final String SQLMAP_SELECT_WSNHS_CGQID_BY_PARAM = "select.wsnhs.cgqid.by.param";
	public static final String SQLMAP_SELECT_WSNHS_BY_PARAM = "select.wsnhs.by.param";
	public static final String SQLMAP_SELECT_QCNHS_BY_PARAM = "select.qcnhs.by.param";
	
	/** 无害化 **/
	public static final String SQLMAP_SELECT_WHH_SH_MAIN_BY_PARAM = "select.whh.shMain.by.param";
	public static final String SQLMAP_UPDATE_SHBZ_BY_PCPARAM = "update.shbz.by.pcParam";
	public static final String SQLMAP_UPDATE_CLBZ_BY_PCPARAM = "update.clbz.by.pcParam";
	public static final String SQLMAP_COUNT_WHH_SHMAINPC_BY_PARAN = "count.whh.shMainPc.by.param";
	
	/*大屏*/
	public static final String SQLMAP_SELECT_COUNT_ALL_SBBJ_BY_MCIDLIST = "select.count.all.sbbj.by.mcidlist";
	public static final String SQLMAP_SELECT_COUNT_ALL_BY_MCIDLIST = "select.count.all.by.mcidlist";
	public static final String SQLMAP_SELECT_CLIENT_HKBJ_BY_PARAM = "select.client.hkbj.by.param";
	public static final String SQLMAP_SELECT_DSXX_BY_DGDS = "select.dsxx.by.dgds";
	public static final String SQLMAP_SELECT_DSXX_BY_LXDS = "select.dsxx.by.lxds";
	
	/*lierda*/
	public static final String SQLMAP_SELECT_LIERDALIST_BY_PARAM = "select.lierdalist.by.param";
	public static final String SQLMAP_SELECT_DYDALIST_BY_PARAM = "select.dydaList.by.param";
	public static final String SQLMAP_COUNT_ZZSL_BY_DYID ="count.zzsl.by.dyid";
	public static final String SQLMAP_COUNT_LIERDALIST_BY_PARAM = "count.lierdalist.by.param";
	
	/*人脸识别*/
	public static final String SQLMAP_SELECT_FACE_RECO_BY_PARAM = "select.face.reco.by.param";
	
	/**智能耳标**/
	public static final String SQLMAP_SELECT_ZNEBEBDA_BY_PARAM = "select.znebebda.by.param";
	public static final String SQLMAP_COUNT_ZNEBEBDA_BY_PARAM = "count.znebebda.by.param";
	public static final String SQLMAP_SELECT_ZNEBEBSJ_BY_PARAM = "select.znebebsj.by.param";
	public static final String SQLMAP_COUNT_ZNEBEBSJ_BY_PARAM = "count.znebebsj.by.param";
}