//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结束*******");