/// <summary>
/// 返回上期排产的RH炉连续生产数量
/// </summary>
/// <returns>连续生产数量</returns>
public int GetYPRH()
{
OracleParameter[] parameters =
{
new OracleParameter("P_MSG", OracleDbType.Varchar2, 100)
};
parameters[0].Value = "0";
return(Convert.ToInt32(DbHelperOra.RunProcedureOut("PKG_LG_JCJH.P_RETURN_RHLS", parameters)));
}
/// <summary>
/// 初始化缓冷实际
/// </summary>
/// <returns>执行结果1成功0失败</returns>
public string RstHLACT()
{
OracleParameter[] parameters =
{
new OracleParameter("P_MSG", OracleDbType.Varchar2, 500)
};
parameters[0].Value = "0";
return(DbHelperOra.RunProcedureOut("PKG_LG_JCJH.P_TB_HL_SJ", parameters));
}
/// <summary>
/// 初始化工序计划表
/// </summary>
/// <returns>执行结果1成功0失败</returns>
public string CleanGXPlan()
{
OracleParameter[] parameters =
{
new OracleParameter("P_MSG", OracleDbType.Varchar2, 500)
};
parameters[0].Value = "0";
return(DbHelperOra.RunProcedureOut("PKG_LG_JCJH.P_CLEAN_GX_PLAN", parameters));
}
/// <summary>
/// 重新刷新浇次顺序
/// </summary>
/// <param name="P_CCM_ID">连铸id</param>
/// <returns></returns>
public string ResetSort()
{
OracleParameter[] parameters =
{
new OracleParameter("P_MSG", OracleDbType.Varchar2, 100)
};
parameters[0].Value = "失败！";
return(DbHelperOra.RunProcedureOut("PKG_UPDATE_SORT.P_UPDATE_SORT", parameters));
}
/// <summary>
/// 系统对轧钢计划重新划分产线
/// </summary>
/// <returns></returns>
public string GetLine()
{
OracleParameter[] parameters =
{
new OracleParameter("P_MSG", OracleDbType.Varchar2, 500)
};
parameters[0].Value = "失败";
return(DbHelperOra.RunProcedureOut("PKG_UPDATE_SORT.P_ZG_PLAN_LINE", parameters));
}
/// <summary>
/// 将没有添加到联产品的物料信息添加到联产品表
/// </summary>
/// <returns></returns>
public string UPDATE_LCP_CODE()
{
OracleParameter[] parameters =
{
new OracleParameter("P_MSG", OracleDbType.Varchar2, 100)
};
parameters[0].Value = "失败";
return(DbHelperOra.RunProcedureOut("PKG_TB_MATRL_MAIN.P_UPDATE_LCP_CODE", parameters));
}
/// <summary>
/// 更新炼钢计划钢坯可使用量
/// </summary>
/// <returns></returns>
public string TB_LG_PLAN_WGT()
{
OracleParameter[] parameters =
{
new OracleParameter("P_MSG", OracleDbType.Varchar2, 100)
};
parameters[0].Value = "成功";
return(DbHelperOra.RunProcedureOut("pkg_p_plan.P_TB_LG_PLAN_WGT_TEST", parameters));
}
/// <summary>
/// 保存排产历史结果记录
/// </summary>
/// <returns></returns>
public string Save_Plan_Log()
{
OracleParameter[] parameters =
{
new OracleParameter("P_MSG", OracleDbType.Varchar2, 100)
};
parameters[0].Value = "失败";
return(DbHelperOra.RunProcedureOut("pkg_p_plan.P_PLAN_LOG", parameters));
}
/// <summary>
/// 同步钢坯信息到综合判定表(指定炉号)
/// </summary>
/// <param name="P_STOVE">炉号</param>
/// <returns></returns>
public string TB_SLAB_STOVE(string P_STOVE)
{
OracleParameter[] parameters =
{
new OracleParameter("P_STOVE", OracleDbType.Varchar2, 100),
new OracleParameter("P_MSG", OracleDbType.Varchar2, 100)
};
parameters[0].Value = P_STOVE;
parameters[1].Value = "失败";
return(DbHelperOra.RunProcedureOut("PKG_COMPRE_SLAB.P_TB_SLAB_STOVE", parameters));
}
/// <summary>
/// 同步线材信息到综合判定表(指定批号)
/// </summary>
/// <param name="P_BATCH">批号</param>
/// <returns></returns>
public string TB_ROLL_BATCH(string P_BATCH)
{
OracleParameter[] parameters =
{
new OracleParameter("P_BATCH", OracleDbType.Varchar2, 100),
new OracleParameter("P_MSG", OracleDbType.Varchar2, 100)
};
parameters[0].Value = P_BATCH;
parameters[1].Value = "失败";
return(DbHelperOra.RunProcedureOut("PKG_COMPRE_ROLL.P_TB_ROLL_BATCH", parameters));
}
/// <summary>
/// 生成质量设计号
/// </summary>
/// <param name="P_STD_ID">执行标准主键</param>
/// <returns></returns>
public string Creat_Design(string P_STD_ID)
{
OracleParameter[] parameters =
{
new OracleParameter("P_STD_ID", OracleDbType.Varchar2, 100),
new OracleParameter("P_MSG", OracleDbType.Varchar2, 100)
};
parameters[0].Value = P_STD_ID;
parameters[1].Value = "失败";
return(DbHelperOra.RunProcedureOut("PKG_Q_DESIGN.P_DESIGN_MAIN", parameters));
}
/// <summary>
/// 手动调整产线
/// </summary>
/// <param name="P_ID">计划主键</param>
/// <param name="LINE_ID">产线主键</param>
/// <returns>成功1失败0</returns>
public string GetLineByID(string P_ID, string LINE_ID)
{
OracleParameter[] parameters =
{
new OracleParameter("P_MSG", OracleDbType.Varchar2, 500),
new OracleParameter("P_ID", OracleDbType.Varchar2, 50),
new OracleParameter("P_LINE_NO", OracleDbType.Varchar2, 50)
};
parameters[0].Value = "0";
parameters[1].Value = P_ID;
parameters[2].Value = LINE_ID;
return(DbHelperOra.RunProcedureOut("PKG_UPDATE_SORT.P_ZG_PLAN_LINE_BYID", parameters));
}
/// <summary>
/// 维护计划轧钢机时产能
/// </summary>
/// <param name="P_LINT_ID">产线主键</param>
/// <param name="P_STL_GRD">钢种</param>
/// <param name="P_SPEC">规格</param>
/// <param name="P_MACH_WGT">机时产能</param>
/// <param name="P_SFGX">是否更新到机时产能基础表</param>
/// <returns>是否成功1，0失败</returns>
public string UpdatePlanJSCN(string P_LINT_ID, string P_STL_GRD, string P_SPEC, decimal P_MACH_WGT, string P_SFGX)
{
OracleParameter[] parameters =
{
new OracleParameter("P_MSG", OracleDbType.Varchar2, 500),
new OracleParameter("P_LINT_ID", OracleDbType.Varchar2, 50),
new OracleParameter("P_STL_GRD", OracleDbType.Varchar2, 50),
new OracleParameter("P_SPEC", OracleDbType.Varchar2, 50),
new OracleParameter("P_MACH_WGT", OracleDbType.Decimal),
new OracleParameter("P_SFGX", OracleDbType.Varchar2, 50)
};
parameters[0].Value = "0";
parameters[1].Value = P_LINT_ID;
parameters[2].Value = P_STL_GRD;
parameters[3].Value = P_SPEC;
parameters[4].Value = P_MACH_WGT;
parameters[5].Value = P_SFGX;
return(DbHelperOra.RunProcedureOut("PKG_UPDATE_SORT.P_ZG_JSCN", parameters));
}
/// <summary>
/// 根据合金名称获取数据
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public DataSet GetList(string name, DateTime dt1, DateTime dt2)
{
OracleParameter[] parameters =
{
new OracleParameter("P_MSG", OracleDbType.Varchar2, 500)
};
parameters[0].Value = "0";
String msg = DbHelperOra.RunProcedureOut("PKG_TB_ALLOY_STOCK.P_TB_ALLOY_STOCK", parameters);
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT mt.c_mat_name,c_alloy_code,round(nvl(n_alloy_wgt,0),1) n_alloy_wgt,round(nvl(N_NEED_WGT,0),1) N_NEED_WGT FROM (SELECT nvl(tb.c_alloy_code, tb.C_ALLOYN__CODE) c_alloy_code, tb.n_alloy_wgt, tb.N_NEED_WGT FROM (SELECT aa.c_alloy__name, aa.c_alloy_code, bb.C_ALLOYN__CODE,aa.n_alloy_wgt, bb.N_NEED_WGT FROM TB_ALLOY_STOCK aa FULL JOIN (SELECT A.C_ALLOYN__CODE, SUM(B.N_SLAB_WGT * A.N_ALLOY_WGT) / 1000 N_NEED_WGT FROM TQB_ALLOY_CONSUMPTION A INNER JOIN(SELECT SUM(T.N_SLAB_WGT) N_SLAB_WGT, T.C_STL_GRD, T.C_STD_CODE FROM TSP_PLAN_SMS T WHERE T.N_STATUS = 1AND T.N_CREAT_PLAN < 4 AND t.d_p_Start_Time > to_date('" + dt1 + "', 'yyyy-mm-dd HH24-mi-ss') AND t.d_p_End_Time < to_date('" + dt2 + "', 'yyyy-mm-dd HH24-mi-ss') GROUP BY T.C_STL_GRD, T.C_STD_CODE) B ON A.C_STL_GRD = B.C_STL_GRD AND(A.C_STD_CODE = B.C_STD_CODE OR A.C_STD_CODE = GET_STRARRAYSTROFINDEX(B.C_STD_CODE, '.', 0) OR A.C_STD_CODE = GET_STRARRAYSTROFINDEX(B.C_STD_CODE, '-', 0)) GROUP BY A.C_ALLOYN__CODE)bb ON aa.c_alloy_code = bb.C_ALLOYN__CODE) tb) tt LEFT JOIN tb_matrl_main mt ON tt.c_alloy_code = mt.c_mat_code");
if (name.Trim() != "")
{
strSql.Append(" where mt.c_mat_name LIKE '%" + name + "%'");
}
return(DbHelperOra.Query(strSql.ToString()));
}
