/// <summary>
/// 物理性能详细信息
/// </summary>
/// <param name="P_CODE">物理分组编码</param>
/// <returns></returns>
public DataSet Get_List(string P_CODE)
{
OracleParameter[] parameters =
{
new OracleParameter("P_CODE", OracleDbType.Varchar2, 100),
new OracleParameter("P_CUR", OracleDbType.RefCursor)
};
parameters[0].Value = P_CODE;
parameters[1].Value = null;
return(DbHelperOra.RunProcedure("PKG_XN.P_XN_ITEMS", parameters, "ds"));
}
/// <summary>
/// 更新浇次子计划
/// </summary>
/// <param name="P_INITIALIZE_ITEM_ID">订单方案号</param>
/// <param name="P_CCM_CODE">连铸机代码</param>
/// <returns></returns>
public int Update_LG_Plan(string P_INITIALIZE_ITEM_ID, string P_CCM_CODE)
{
OracleParameter[] parameters =
{
new OracleParameter("P_INITIALIZE_ITEM_ID", OracleDbType.Varchar2, 100),
new OracleParameter("P_CCM_CODE", OracleDbType.Varchar2, 100)
};
parameters[0].Value = P_INITIALIZE_ITEM_ID;
parameters[1].Value = P_CCM_CODE;
return(DbHelperOra.RunProcedure("pkg_p_plan.P_UPDATE_JCJH_SORT", parameters));
}
/// <summary>
/// 按时间和批号获取取样详细信息
/// </summary>
/// <param name="P_STD_CODE">标准</param>
/// <param name="P_STL_GRD">钢种</param>
/// <returns></returns>
public DataSet Get_Model_List_JSZX(string P_STD_CODE, string P_STL_GRD)
{
OracleParameter[] parameters =
{
new OracleParameter("P_STD_CODE", OracleDbType.Varchar2, 100),
new OracleParameter("P_STL_GRD", OracleDbType.Varchar2, 100),
new OracleParameter("P_CUR", OracleDbType.RefCursor)
};
parameters[0].Value = P_STD_CODE;
parameters[1].Value = P_STL_GRD;
parameters[2].Value = null;
return(DbHelperOra.RunProcedure("PKG_XN.P_ZY_ITEMS_MODEL_JSZX", parameters, "ds"));
}
/// <summary>
/// 查询成分原始信息
/// </summary>
/// <param name="P_STOVE">炉号</param>
/// <param name="P_START">时间（开始）</param>
/// <param name="P_END">时间（结束）</param>
/// <returns></returns>
public DataSet Get_CF_List(string P_STOVE, string P_START, string P_END)
{
OracleParameter[] parameters =
{
new OracleParameter("P_STOVE", OracleDbType.Varchar2, 100),
new OracleParameter("P_START", OracleDbType.Varchar2, 100),
new OracleParameter("P_END", OracleDbType.Varchar2, 100),
new OracleParameter("P_CUR", OracleDbType.RefCursor)
};
parameters[0].Value = P_STOVE;
parameters[1].Value = P_START;
parameters[2].Value = P_END;
parameters[3].Value = null;
return(DbHelperOra.RunProcedure("PKG_COMPRE_SLAB.P_QUERY_CF", parameters, "ds"));
}
/// <summary>
/// 按时间和批号获取取样详细信息
/// </summary>
/// <param name="P_BATCH">批号</param>
/// <param name="P_START">时间（开始）</param>
/// <param name="P_END">时间（结束）</param>
/// <param name="P_TYPE">类型,0未委托；1查询委托信息，2查询已接收送样信息，3查询已制样信息</param>
/// <returns></returns>
public DataSet Get_List_JSZX(string P_BATCH, string P_START, string P_END, string P_TYPE)
{
OracleParameter[] parameters =
{
new OracleParameter("P_BATCH", OracleDbType.Varchar2, 100),
new OracleParameter("P_START", OracleDbType.Varchar2, 100),
new OracleParameter("P_END", OracleDbType.Varchar2, 100),
new OracleParameter("P_TYPE", OracleDbType.Varchar2, 1),
new OracleParameter("P_CUR", OracleDbType.RefCursor)
};
parameters[0].Value = P_BATCH;
parameters[1].Value = P_START;
parameters[2].Value = P_END;
parameters[3].Value = P_TYPE;
parameters[4].Value = null;
return(DbHelperOra.RunProcedure("PKG_XN.P_ZY_ITEMS_JSZX", parameters, "ds"));
}
/// <summary>
/// 查询轧钢计划
/// </summary>
/// <param name="P_PC_NAME">排产名称</param>
/// <param name="P_STL_GRD">钢种</param>
/// <param name="P_STD_CODE">执行标准</param>
/// <returns></returns>
public DataSet Get_Plan_List(string P_PC_NAME, string P_STL_GRD, string P_STD_CODE, string P_STA_ID)
{
OracleParameter[] parameters =
{
new OracleParameter("P_PC_NAME", OracleDbType.Varchar2, 100),
new OracleParameter("P_STL_GRD", OracleDbType.Varchar2, 100),
new OracleParameter("P_STD_CODE", OracleDbType.Varchar2, 100),
new OracleParameter("P_STA_ID", OracleDbType.Varchar2, 100),
new OracleParameter("P_CUR", OracleDbType.RefCursor)
};
parameters[0].Value = P_PC_NAME;
parameters[1].Value = P_STL_GRD;
parameters[2].Value = P_STD_CODE;
parameters[3].Value = P_STA_ID;
parameters[4].Value = null;
return(DbHelperOra.RunProcedure("PKG_P_PLAN.P_ZG_PLAN_LOG", parameters, "ds"));
}
/// <summary>
/// 按标准，钢种，规格查询取样模板信息
/// </summary>
/// <param name="P_STD_CODE">标准</param>
/// <param name="P_STL_GRD">钢种</param>
/// <param name="P_SPEC_MIN">规格最小值</param>
/// <param name="P_SPEC_MAX">规格最大值</param>
/// <returns></returns>
public DataSet Get_Model_List(string P_STD_CODE, string P_STL_GRD, string P_SPEC_MIN, string P_SPEC_MAX)
{
OracleParameter[] parameters =
{
new OracleParameter("P_STD_CODE", OracleDbType.Varchar2, 100),
new OracleParameter("P_STL_GRD", OracleDbType.Varchar2, 100),
new OracleParameter("P_SPEC_MIN", OracleDbType.Varchar2, 100),
new OracleParameter("P_SPEC_MAX", OracleDbType.Varchar2, 100),
new OracleParameter("P_CUR", OracleDbType.RefCursor)
};
parameters[0].Value = P_STD_CODE;
parameters[1].Value = P_STL_GRD;
parameters[2].Value = P_SPEC_MIN;
parameters[3].Value = P_SPEC_MAX;
parameters[4].Value = null;
return(DbHelperOra.RunProcedure("PKG_XN.P_SAMP_MODLE_JSZX", parameters, "ds"));
}
/// <summary>
/// 按时间和批号获取物理性能修改信息
/// </summary>
/// <param name="P_CODE">物理分组编码</param>
/// <param name="P_BATCH">批号</param>
/// <param name="P_START">制样时间（最小）</param>
/// <param name="P_END">制样时间（最大）</param>
/// <param name="P_CHECK_STATE">检验状态；0-初检；1-复检；2-评审</param>
/// <returns></returns>
public DataSet Get_Log_List(string P_CODE, string P_BATCH, string P_START, string P_END, string P_CHECK_STATE)
{
OracleParameter[] parameters =
{
new OracleParameter("P_CODE", OracleDbType.Varchar2, 100),
new OracleParameter("P_BATCH", OracleDbType.Varchar2, 100),
new OracleParameter("P_START", OracleDbType.Varchar2, 100),
new OracleParameter("P_END", OracleDbType.Varchar2, 100),
new OracleParameter("P_CHECK_STATE", OracleDbType.Varchar2, 100),
new OracleParameter("P_CUR", OracleDbType.RefCursor)
};
parameters[0].Value = P_CODE;
parameters[1].Value = P_BATCH;
parameters[2].Value = P_START;
parameters[3].Value = P_END;
parameters[4].Value = P_CHECK_STATE;
parameters[5].Value = null;
return(DbHelperOra.RunProcedure("PKG_XN.P_XN_ITEMS_LOG", parameters, "ds"));
}
/// <summary>
/// 按时间和批号获取物理性能详细信息
/// </summary>
/// <param name="P_CODE">物理分组编码</param>
/// <param name="P_BATCH">批号</param>
/// <param name="P_START">制样时间（最小）</param>
/// <param name="P_END">制样时间（最大）</param>
/// <param name="P_TYPE">类型 0未同步综合判定的数据；1所有数据</param>
/// <returns></returns>
public DataSet Get_Result_List(string P_CODE, string P_BATCH, string P_START, string P_END, string P_TYPE, string P_STLGRD)
{
OracleParameter[] parameters =
{
new OracleParameter("P_CODE", OracleDbType.Varchar2, 100),
new OracleParameter("P_BATCH", OracleDbType.Varchar2, 100),
new OracleParameter("P_START", OracleDbType.Varchar2, 100),
new OracleParameter("P_END", OracleDbType.Varchar2, 100),
new OracleParameter("P_TYPE", OracleDbType.Varchar2, 1),
new OracleParameter("P_STLGRD", OracleDbType.Varchar2, 100),
new OracleParameter("P_CUR", OracleDbType.RefCursor)
};
parameters[0].Value = P_CODE;
parameters[1].Value = P_BATCH;
parameters[2].Value = P_START;
parameters[3].Value = P_END;
parameters[4].Value = P_TYPE;
parameters[5].Value = P_STLGRD;
parameters[6].Value = null;
return(DbHelperOra.RunProcedure("PKG_XN.P_XN_RESULT", parameters, "ds"));
}
/// <summary>
/// 同步钢坯综合判定数据
/// </summary>
/// <returns></returns>
public int TB_SLAB()
{
return(DbHelperOra.RunProcedure("PKG_COMPRE_SLAB.P_TB_SLAB_ZD"));
}
/// <summary>
/// 同步线材信息到综合判定表
/// </summary>
/// <returns></returns>
public int TB_ROLL()
{
return(DbHelperOra.RunProcedure("PKG_COMPRE_ROLL.P_TB_ROLL_ZD"));
}
