XinYu_LG2MES/ClientSolution/output/Report/.svn/text-base/temp.doc.svn-base

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