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();
解决后的SQL写法
最新推荐文章于 2023-06-09 16:02:37 发布