解决后的SQL写法

var sql = "select  result.obj_id as OBJ_ID,result.qxdbh as QXDBH,result.sbmc as SBMC,result.djdw as DJDW,result.qxflmc as QXFLMC,"
			+" result.qxfl as QXFL,result.qxdjr as QXDJR,result.user_name as USER_NAME,result.tbrq as TBRQ,result.ssdy as SSDY,result.sblx as SBLX ,"
			+" result.sfcq as SFCQ,result.qxyy as QXYY,result.xqjg as XQJG,result.sb_obj_id as SB_OBJ_ID,result.ssdy_obj_id as SSDY_OBJ_ID, "
			+" result.lchj as LCHJ "
			+" from (select qx.obj_id as OBJ_ID,qx.QXDBH,qx.QXMS,om.obj_caption as sbmc, deps.mc as djdw,dm1.dmmc as qxflmc," 
			+" qx.QXFL,qx.QXDJR,info.mc as user_name,qx.TBRQ,obj.obj_caption as ssdy ,sblx.sblx as SBLX , "
			//将发现日期和时限相加，然后减去消缺日期或当前时间，消缺日期或当前时间是根据消缺日期是否为空来判断的
			+" decode(sign(round(to_number(qx.fxrq+to_number(cq.d)-decode(qx.xqrq,null,sysdate,qx.xqrq)))), -1, '已超期', '未超期'  ) as SFCQ,"
			+" qxyy.dmmc as QXYY,xqjg.dmmc as XQJG,om.obj_id as SB_OBJ_ID,obj.obj_id as SSDY_OBJ_ID, "
			+" qx.lchj as LCHJ "
			+" from "
			+" mw_app.MWT_UD_PD_YX_QXGL qx ,"
			+" mw_sys.mwt_pd_deps deps,"
			+" (select dm1.dm,dm1.dmmc from mw_app.mwt_ud_gg_dm dm1 where dm1.dmlb = '381' order by dm1.dm) xqjg,"
			+" (select dm1.dm,dm1.dmmc from mw_app.mwt_ud_gg_dm dm1 where dm1.dmlb = '383' order by dm1.dm) qxyy,"
			+" (select sx.sx as d,sx.qxxz from mw_app.MWT_UD_PDYX_QXXQSX sx where  sx.ssds='"+ssds_obj_id+"' ) cq,"
			+" mw_sys.mwt_pd_emps info,"
			+" mw_app.mwt_ud_pd_pz_sblx sblx, "
			+" mw_app.mwt_ud_gg_dm dm1,"
			+" mw_sys.MWT_OM_OBJ om ,"
			+" mw_sys.MWT_OM_OBJ obj "
			+" where "
			+" qx.QXDJRDW=deps.obj_id(+) and "
			+" qx.qxfl=cq.qxxz and "
			+" qx.sblx = sblx.obj_id(+) and "
			+" qx.qxyy = qxyy.dm(+) and "
			+" qx.xqjg = xqjg.dm(+) and "
			+" qx.QXDJR=info.obj_id(+) and "
			+" qx.fxrq is not null  "
			+querysql
    		+" and qx.qxfl=dm1.dm(+)  and "
    		+" qx.QXSB_OBJ_ID=om.obj_id(+) and "
    		+" qx.SSDY = obj.OBJ_ID(+) and qx.qxsb_obj_id is not null "
    		+" order by qx.TBRQ desc ) result where result.SFCQ ='"+sfycq.value+"'";
qxDateGrid.setCommandText(sql);
	qxDateGrid.dataAccessAgent = mw.data.DataAccessAgent;
	qxDateGrid.columns["SBMC"].renderCell = _queryQXDevRenderDetailCell;
	qxDateGrid.columns["SSDY"].renderCell = _querySSDYDevRenderDetailCell;
	qxDateGrid.columns["SFCQ"].renderCell = _renderSFCQCell;
	qxDateGrid.dataBind();