tpssmabw02

//Log::Trace("", __FUNCTION__, "*******更新LOT表tpssmmabw02开始*******");
                //tpssmmabw02.Reset();
                //tpssmmabw02.REC_CREATOR = userid;    //记录创建责任者
                //tpssmmabw02.REC_CREATE_TIME = systime;   //记录创建时刻
                //tpssmmabw02.REC_REVISOR = "";        //记录修改责任者
                //tpssmmabw02.REC_REVISE_TIME = systime;   //记录修改时刻
                ////tpssmmabw02.ARCHIVE_FLAG;   //归档标记

                //tpssmmabw02.FACTORY_DIV = tpmommabw01.FACTORY_DIV;   //主工序代码
                //Log::Trace("", __FUNCTION__, "FACTORY_DIV=[{0}]", tpmommabw01.FACTORY_DIV);
                //tpssmmabw02.CAST_LOT_NO = tpmommabw01.CAST_LOT_NO;   //浇铸批号
                //Log::Trace("", __FUNCTION__, "CAST_LOT_NO=[{0}]", tpmommabw01.CAST_LOT_NO);
                //tpssmmabw02.ST_NO = tpmommabw01.ST_NO;   //出钢记号
                //Log::Trace("", __FUNCTION__, "CAST_LOT_NO=[{0}]", tpmommabw01.CAST_LOT_NO);
                //tpssmmabw02.SG_SIGN = tpmommabw01.SG_SIGN;   //牌号(钢级)
                //Log::Trace("", __FUNCTION__, "CAST_LOT_NO=[{0}]", tpmommabw01.CAST_LOT_NO);
                //tpssmmabw02.LOT_STATUS = 0;   //LOT状态[数字类型]
                //Log::Trace("", __FUNCTION__, "LOT_STATUS=[{0}]", tpssmmabw02.LOT_STATUS);
                //tpssmmabw02.CAST_LOT_SUM = tpmommabw01.CC_NUM;   //CAST_LOT内炉数
                //Log::Trace("", __FUNCTION__, "CAST_LOT_SUM=[{0}]", tpmommabw01.CC_NUM);
                //tpssmmabw02.CC_TYPE = tpmommabw01.CC_TYPE;   //连铸机类型
                //Log::Trace("", __FUNCTION__, "CC_TYPE=[{0}]", tpmommabw01.CC_TYPE);

                ////设置连铸计划模式,若板坯赋值方式为命令板坯,计划模式为 2-非浮动板坯计划,板坯赋值方式为预定板坯,计划模式为1-浮动板坯计划
                //tpssmmabw02.CC_PLAN_MODE = "2";   //连铸计划模式
                //Log::Trace("", __FUNCTION__, "CC_PLAN_MODE=[{0}]", tpssmmabw02.CC_PLAN_MODE);
                ////tpssmmabw02.URGENCY_ORDER_MARK ;   //紧急合同标志
                //tpssmmabw02.APP_TYPE = tpmommabw01.APP_TYPE;   //材料申请类型
                //Log::Trace("", __FUNCTION__, "APP_TYPE=[{0}]", tpmommabw01.APP_TYPE);
                //tpssmmabw02.BILLET_TYPE = tpmommabw01.BILLET_TYPE;   //钢坯类型
                //Log::Trace("", __FUNCTION__, "BILLET_TYPE=[{0}]", tpmommabw01.CAST_LOT_NO);
                //if (tpssmmabw02.BILLET_TYPE.Trim() == "")
                //{//应小何 要求,若铸坯类型为空,则默认= 1 ,ON 2014-2-8 14:22:28
                //    tpssmmabw02.BILLET_TYPE = "1"; //钢坯类型= 1=板坯
                //}
                //tpssmmabw02.SLAB_GROUP_SUM = 0;   //板坯组数
                //Log::Trace("", __FUNCTION__, "BILLET_TYPE=[{0}]", tpssmmabw02.SLAB_GROUP_SUM);
                //tpssmmabw02.SLAB_THICK = tpmommabw01.NOM_SLAB_THICK;   //板坯厚度
                //Log::Trace("", __FUNCTION__, "SLAB_THICK=[{0}]", tpmommabw01.CAST_LOT_NO);
                ////tpssmmabw02.SLAB_NUM;   //板坯块数
                ////tpssmmabw02.LACK_PER;   //短尺率


                ////计算一个LOT下的,铸坯总数,
                ////===================
                //c_sql_condition = " select nvl(count(1),0) from tpmommabw01 t "
                //    " where t.cast_lot_no = @cast_lot_no    ";
                //Log::Trace("", __FUNCTION__, "c_sql_condition1=[{0}]", c_sql_condition);
                //sqlstr = c_sql_condition;
                //cmd_sql.SetCommandText(c_sql_condition);// 设置执行的SQL语句
                //// 设置SQL中的变量
                //cmd_sql.Parameters.Set("cast_lot_no", tpmommabw01.CAST_LOT_NO);
                //Log::Trace("", __FUNCTION__, "参数cast_lot_no=[{0}]", tpmommabw01.CAST_LOT_NO);
                //tpssmmabw02.SLAB_NUM = cmd_sql.ExecuteScalar();
                //Log::Trace("", __FUNCTION__, "SLAB_NUM=[{0}]", tpssmmabw02.SLAB_NUM);
                //cmd_sql.Close(); //关闭游标 

                ////计算一个LOT下的, MAX(紧急合同标志) 
                ////select nvl(max(t.URGENCY_ORDER_MARK),'0') from tpmommabw01 t
                ////===================
                //c_sql_condition = " select nvl(max(t.urg_order_flag), '0') from tpmommabw01 t "
                //    " where t.cast_lot_no = @cast_lot_no    ";
                //Log::Trace("", __FUNCTION__, "c_sql_condition2=[{0}]", c_sql_condition);
                //sqlstr = c_sql_condition;
                //cmd_sql.SetCommandText(c_sql_condition);// 设置执行的SQL语句
                //// 设置SQL中的变量
                //cmd_sql.Parameters.Set("cast_lot_no", tpmommabw01.CAST_LOT_NO);
                //Log::Trace("", __FUNCTION__, "参数cast_lot_no=[{0}]", tpmommabw01.CAST_LOT_NO);
                //cmd_sql.ExecuteReader();
                //if (cmd_sql.Read())
                //{
                //    tpssmmabw02.URGENCY_ORDER_MARK = cmd_sql.GetString(1);
                //    Log::Trace("", __FUNCTION__, "URGENCY_ORDER_MARK=[{0}]", tpssmmabw02.URGENCY_ORDER_MARK);
                //}
                //cmd_sql.Close(); //关闭游标 

                //tpssmmabw02.TrimOrBlank();
                ////sqlstr = "insert tpssmmabw02.";
                //sqlstr = CString::Format("insert tpssmmabw02. CAST_LOT_NO[%s]", (const char*)tpssmmabw02.CAST_LOT_NO);
                //tpssmmabw02.Insert();
                //Log::Trace("", __FUNCTION__, "*******更新LOT表tpssmmabw02结束*******");

 

上一篇:SAP QM Inspection lot creation : sample size calculation


下一篇:2021-2022学年英语周报八年级第4期答案及试题