11-1405-2131 112014050100 PCG-11-1405-1010 112014050626 select t.ASKPLAN_ID,t.TRANS_CAR_NO,t.SND_DTIME,t.SND_REMARK,s2.DEPARTNAME AS TRANS_DEPT_NAME, s2.DEPARTID as TRANS_DEPT, CASE t.TRANS_DEPT_TPE WHEN '0' THEN '驻外公司' WHEN '1' THEN '码头' END AS TRANS_DEPT_TPE, t.PRD_ID,t.SLAB_NO,t.PRD_ROLL_DTIME, CASE t.PRD_TYPE WHEN '0' THEN '直销' WHEN '1' THEN '自销' WHEN '2' THEN '自用' END as PRD_TYPE, t.BUYERCODE,NVL((SELECT BUYERNAME FROM SEL_BUYERBASEINFO WHERE BUYERCODE = t.BUYERCODE AND ISACTIVATED = '1'),t.BUYERCODE) AS BUYERNAME, t.ORD_NO,t.ORD_SEQ,t.ORD_THK,t.ORD_WTH,t.ORD_LEN,t.ORD_INDIA,t.ORD_OUTDIA, t.ORD_WGT,t.PRD_THK,t.PRD_WTH,t.PRD_LEN,t.PRD_INDIA,t.PRD_OUTDIA,t.CAL_WGT,t.ACT_WGT, t.CATEGORY,NVL((select name_ from SCM_BASE_INFO where t.CATEGORY = id_),t.CATEGORY) as CATEGORYNAME, t.STEELCODE,t.SPEC_ABBSYM, t.FIXSIZE,NVL((select name_ from SCM_BASE_INFO where t.FIXSIZE = id_),t.FIXSIZE) as FIXSIZE_NM, t.CUTSIDESTATE,NVL((select name_ from SCM_BASE_INFO where t.CUTSIDESTATE = id_),t.CUTSIDESTATE) as CUTSIDESTATE_NM, t.DTMR_GRD,NVL((select name_ from SCM_BASE_INFO where t.DTMR_GRD = id_),t.DTMR_GRD) as DTMR_GRD_NM, t.DTMR_RSLT,NVL((select name_ from SCM_BASE_INFO where t.DTMR_RSLT = id_),t.DTMR_RSLT) as DTMR_RSLT_NM, t.RCL_STATE,t.SND_STATUS,t.EXTSHAPE_DEC_GRD, CASE t.APRC_DEC_RSLT WHEN '0' THEN '不合格' WHEN '1' THEN '合格' END AS APRC_DEC_RSLT, t.CRK_CD1,t.CRK_CD2,t.CRK_CD3, CASE t.TOT_DEC_RSLT WHEN '0' THEN '不合格' WHEN '1' THEN '合格' END AS TOT_DEC_RSLT, t.CHK_ORG,NVL((select name_ from SCM_BASE_INFO where t.CHK_ORG = id_),t.CHK_ORG) as CHK_ORG_NM, case t.PACKAGE_FL when '0' then '未包装' WHEN '1' THEN '已包装' END AS PACKAGE_FL, CASE t.PACKAGE_LEVEL WHEN '1' THEN '不包' WHEN '2' THEN '简包' WHEN '3' THEN '普包' WHEN '4' THEN '精包' END AS PACKAGE_LEVEL, t.XG_CRET_NO,t.SAL_PRC,t.TRS_MNY, CASE t.ACP_STAT WHEN '0' THEN '待接收' WHEN '1' THEN '已接收' END AS ACP_STAT, s1.DEPARTNAME as FORECORPNAME,s1.DEPARTID as FORECORPCODE, (SELECT M.INCEPTCORPNAME FROM SEL_INCEPTCORPINFO M WHERE M.INCEPTCORPCODE=t.ORDCUST_CD)RECEIVE_DEPT, (SELECT E.LOADDOCK||'→'||E.UNLOADDOCK FROM SEL_STATIONINFO E WHERE E.STATIONCODE=T.DEPARTURE_CD)ARRIVAL_CD from OVS_TRAST_COMM t, core_app_department s1 , core_app_department s2 where t.PRD_ID like '%'||?||'%' and t.TRANS_CAR_NO like '%'||?||'%' and t.ORD_NO like '%'||?||'%' and t.askplan_id like '%'||?||'%' and t.ACP_DEPT like ? and t.PRD_ROLL_DTIME between ? and ? and (t.SND_DTIME between ? and ? or t.SND_DTIME is null) and t.ACP_DEPT = s1.DEPARTID and t.TRANS_DEPT = s2.DEPARTID and t.ACP_STAT = '0' 6297865 刘 LS140604001 W112013080633 W112013080539 上海大中物流 5708.16 20110329S089 6290070 6292342 孙 and INVOICEDATE between to_date('2014-05-01', 'yyyy-MM-dd') and to_date('2014-05-29','yyyy-MM-dd')+1 and BCFLAG = '1' and BALANCESTATUS IN('2','3') and a.PRODUCTLINE = '4001HB1' AND ((A.BCFLAG ='1' and A.CLEARFLAG = '0') or (A.BCFLAG = '0' and A.CLEARFLAG = '1') or (a.bcflag='0' and a.clearflag='0') ) and a.ISOUT = '0' 6293871 1120140546 6297013 销售报表--- 结算日报 --- 结算查询 J47-04981A 070 J48-03837A 010 020 030 201405140020 201405140034 J48-04118A ftp://172.16.0.11 6292166 201404240401 装车实绩，发运明细登记 电话:6292361 熊 发运号:201404200456 装车实绩 点击明细撤销无法撤销 发运明细登记中删除明细无法删除 6292150 6293718 13879005567 18674455264 宾洪斌 360013317000192901 劳务费:155 重量:147.59 J49-02624A030 J37-11541A J32-08927A 13879007879 何工 转炉办公室 张主任:13979045559 J41-01826A JBA572 360013317000204567 发票号重复 0790-6226077 201403050664 6297006 13879024953 6293495 6290481 \\172.16.0.108\C$ \\172.16.0.108\e$ 8731205 J49-02663A 13979093328 杜 629 13979093328 杜工 6292125 一钢退回坯管理 6290062 厚板厂，曹，夏微 J48-01163A j41-01334A with t as ( select * from stl_ccm_optinfo a union all select * from j#stl_ccm_optinfo b) select * from t where t.heatno in (select a.CHARGE_NO from tbg02_charge_comm@xg3q a where a.CAST_NO = '012659') order by t.optdate 软吹时间： PLC1 M2.0 1号， M2.1 2号 运行点 6290467 6290504 cp0501 Q345 6292367 13979015380 顾工 CoreFS.CA06.FrmBase fr = new FrmBase(); fr.ob = ob; CoreClientParam CCP_Query = new CoreClientParam(); DataTable dt = new DataTable(); // CCP_Query.ServerName = "Core.LgMes.Server.Common.ComDBQuery"; // CCP_Query.MethodName = "doQuery"; CCP_Query.ServerName = "Core.LgMes.Server.Common.ComDBExecute"; // 考虑原来返回数据形式性能太低，修改为前端传sql，服务端直接执行模式 2013.11.18 CCP_Query.MethodName = "doSimpleQuery"; CCP_Query.ServerParams = new object[] { this.getSqlOfJobAdditiveData(strTableName, strHNo, strSCode, strDTime) }; CCP_Query.SourceDataTable = dt; fr.ExecuteQueryToDataTable(CCP_Query, CoreInvokeType.Internal); ds.Tables.Add(dt); select distinct a.HEATNO, v.aim_grade_code PLANSTEEL, a.SHIFTCODE, v.CAST_ID || '-' || v.cast_seq CAST_ID, a.POTWRAPSTATE, a.POTNO, decode(substr(a.shiftcode, 1, 1), '1', '白', '2', '中', '3', '晚') BC, decode(substr(a.shiftcode, 2, 1), '1', '甲', '2', '乙', '3', '丙', '4', '丁') BB, to_char(a.LEAVETIME, 'hh24:mi') ZZTIME, to_char(a.ARRIVETIME, 'HH24:mi') ARRIVETIME, to_char(a.OPTDATE, 'yyyy-MM-dd hh24:mi') OPTDATE, to_char(a.BLOWARSTARTTIME, 'HH24:mi') BLOWARSTARTTIME, to_char(a.BLOWARENDTIME, 'HH24:mi') BLOWARENDTIME, to_char(a.CASSTARTTIME, 'HH24:mi') CASSTARTTIME, to_char(a.CASENDTIME, 'HH24:mi') CASENDTIME, a.ARITEMPT, a.ARFTEMPT, a.ARBTEMPT, a.ARRIVEO2, a.LEAVEO2, a.TWSTEELWGT, a.MANTLENUM, a.RESIDUETHICKNESS, a.BLOWARPRESS, a.ARFLUX, a.STATIONCODE, a.DISPOSALTIME, v.PLAN_LINES, nvl(t.PFBALEWGT,0)-nvl(t.BALELEAVEWGT,0) MOLSTLWGT, max(case when a.HEATNO = t4.HEATNO and t4.xh = t4.cnt then t4.C end) over(partition by a.HEATNO) C, max(case when a.HEATNO = t4.HEATNO and t4.xh = t4.cnt then t4.MN end) over(partition by a.HEATNO) Mn, max(case when a.HEATNO = t4.HEATNO and t4.xh = t4.cnt then t4.S end) over(partition by a.HEATNO) S, max(case when a.HEATNO = t4.HEATNO and t4.xh = t4.cnt then t4.P end) over(partition by a.HEATNO) P, max(case when a.HEATNO = t4.HEATNO and t4.xh = t4.cnt then t4.SI end) over(partition by a.HEATNO) Si, max(case when a.HEATNO = t4.HEATNO and t4.xh = t4.cnt then t4.ALS end) over(partition by a.HEATNO) AIS, max(case when a.HEATNO = t4.HEATNO and t4.xh = t4.cnt then t4.ALt end) over(partition by a.HEATNO) AIt, max(case when a.HEATNO = t4.HEATNO and t4.xh = t4.cnt then T4.CA end) over(partition by a.HEATNO) Ca from (select * from STL_CAS_OPTINFO where to_char(OPTDATE, 'yyyy-MM-dd hh24:mi:ss') between ? and ? and substr(STATIONCODE, 2, 1) = decode(?, null, substr(STATIONCODE, 2, 1), ?) and UPPER(nvl(PLANSTEEL, 'null')) in (decode(?, null, UPPER(nvl(PLANSTEEL, 'null')), ?)) and substr(SHIFTCODE, 1, 1) = decode(?, null, substr(SHIFTCODE, 1, 1), ?) and substr(SHIFTCODE, 2, 1) = decode(?, null, substr(SHIFTCODE, 2, 1), ?) union select * from J#STL_CAS_OPTINFO where to_char(OPTDATE, 'yyyy-MM-dd hh24:mi:ss') between ? and ? and substr(STATIONCODE, 2, 1) = decode(?, null, substr(STATIONCODE, 2, 1), ?) and UPPER(nvl(PLANSTEEL, 'null')) in (decode(?, null, UPPER(nvl(PLANSTEEL, 'null')), ?)) and substr(SHIFTCODE, 1, 1) = decode(?, null, substr(SHIFTCODE, 1, 1), ?) and substr(SHIFTCODE, 2, 1) = decode(?, null, substr(SHIFTCODE, 2, 1), ?)) a, (select * from ppc_steel_heat union select * from J#ppc_steel_heat) v, (select * from STL_CCM_OPTINFO where to_char(OPTDATE, 'yyyy-MM-dd') between ? and ? union select * from J#STL_CCM_OPTINFO where to_char(OPTDATE, 'yyyy-MM-dd') between ? and ?) t, (select * from STL_LFS_OPTINFO where to_char(OPTDATE, 'yyyy-MM-dd') between ? and ? union select * from J#STL_LFS_OPTINFO where to_char(OPTDATE, 'yyyy-MM-dd') between ? and ?) w, (select y.* from (select x.*, count(1) over(partition by x.HEATNO) cnt, row_number() over(partition by x.HEATNO order by x.ASSAYTYPECODE desc) xh from (select * from stl_CHEMELEMENT where upper(SUBSTR(CHECKNO, 12, 2)) = 'DQ' and upper(SUBSTR(CHECKNO, -1)) = 'S' union select t.* from j#stl_CHEMELEMENT t where upper(SUBSTR(CHECKNO, 12, 2)) = 'DQ' and upper(SUBSTR(CHECKNO, -1)) = 'S' ) x) y where y.xh = y.cnt) t4 where a.HEATNO = v.heatNo(+) and a.HEATNO = t.HEATNO(+) and a.heatno = w.heatno(+) and a.heatno = t4.heatno(+) order by OPTDATE 转炉操作记录，出钢温度，2号炉没有 6290824 6290467 J32-01046A J32-09809A jsk06 324521 J48-00516A 102014010607 合同打印 打不出来 20131231S211 20140108S223 6292682 112013100068 中板线 6294610 J47-01252A050 J47-01223A020 6.84 6291281 95,70 J28-07782A 2钢脱硫：铁水温度，‘脱硫前’ 温度为选铁水来源的温度 脱硫实绩中加入测温时间 总貌图 显示拉宽 发运明细报表 中 热送 ，冷松信息有问题？？？可以参考 生产计划执行表 中的热送冷松 冷送，有下线原因 2钢 <<炼钢技术经济指标汇总统计>> 正确 61695.89 3qjc205 9461 6292367 zhb 123 201401010065 201401010066 生产预排及交货期确认 J42-00002A 改 J42-00502A J42-00001A 改 J42-00501A 排成干特图 dds01 dds01 http://localhost:8080/WebProject/Register?username=林&password=111 201312180892 1203 单价：5343.86 面积：87.57 打折：467962 6292133 J39-11837A 15170905846 脱硫站 MES温度进不去 J31-09327A 6292452 大全 20131215S063 201312080066 9.978, 67 201312090347 44.605 45.0 6292150 1炼钢厂，1号连铸机，台下2操台 2. 13879066469 李 虚拟发运提交不了 6293405 6290070 肖强， 6293405 二线，综合判定 E3-06784 jcxc02 1111111 J37-11155A 65,389.84 24000 12000 where to_char(OPTDATE,'yyyy-MM-dd') between '2013-12-16' and '2013-12-16' and CVTPOS = '1' and substr(CLASS,1,1) = '1' and substr(CLASS,2,1) = '1' and LADLEID = '11' 0731-84430526 转 0 李 去湘域中英拿离职的 带东南融通公司离职证明， 去方理胜再开证明 公积金提取 ：单位离职证明，个人身份证，提取材料（可在网上下载）， 如果亲戚代办，除上面的外，还需带代办人身份证，结婚证件等 带身份证原件，户口本原件，到 你们公司拿证明材料 湘域中央2栋1120 再找公积金部分提取,公积金提取在周1到周四 2钢连铸付工: 1.点啦表 拉速改给定拉速 2.新作报表，加班次，岗位，断面分开来 3.CCM1，CCM2,CCM3 13879028123 郭 CoreClientParam CCP_Query = new CoreClientParam(); DataTable dt = new DataTable(); // CCP_Query.ServerName = "Core.LgMes.Server.Common.ComDBQuery"; // CCP_Query.MethodName = "doQuery"; CCP_Query.ServerName = "Core.LgMes.Server.Common.ComDBExecute"; // 考虑原来返回数据形式性能太低，修改为前端传sql，服务端直接执行模式 2013.11.18 CCP_Query.MethodName = "doSimpleQuery"; CCP_Query.ServerParams = new object[] { this.getSqlOfJobAdditiveData(strTableName, strHNo, strSCode, strDTime) }; CCP_Query.SourceDataTable = dt; fr.ExecuteQueryToDataTable(CCP_Query, CoreInvokeType.Internal); ds.Tables.Add(dt); 201311260244 201311300064 厚板在库判定 -- 按入库时间不能查询 -- 15979887588 韵达1700075080261 2钢板坯称重理论重量和实际重量，需要个差值 修改描述 作者 修改日期 次数 班别 6292350 刘工 13979085094 切割板坯查询与记录 201311110276 201311110283 201311110274 44.54 43.872 201311100150 43.492 40.92 明细和实物不符合 6292247 田承兰 SLM_PRICE.TESTMAIN('H3-35555.1.5',sysdate - 9,'902601','SEL_BALANCEDETAIL_ALL','','D','','','','') declare v_pricic number; v1 varchar2(20); v2 varchar2(20); begin SLM_PRICE.COUNTPIRCE('H3-35555.1.5', '', '626125', 'SEL_BALANCEDETAIL_ALL', '', v_pricic, v1, v2); dbms_output.put_line(v2); end; 唯美鲜花网 订单:2013121076507