/// <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())); }