//private void Line1_Click(
#endregion Method
#region DB
private DataTable LOAD_DATA()
{
try
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
string process_name = "MES.PKG_MGL_VJ2.SEL_LEADTIME_TOTAL";
//ARGMODE
MyOraDB.ReDim_Parameter(2);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_WH_CD";
//MyOraDB.Parameter_Name[1] = "ARG_MLINE_CD";
MyOraDB.Parameter_Name[1] = "OUT_CURSOR";
MyOraDB.Parameter_Type[0] = (char)OracleType.VarChar;
//MyOraDB.Parameter_Type[1] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[1] = (char)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = _wh_cd == "TOTAL2" ? "VJ2" : _wh_cd;
//MyOraDB.Parameter_Values[1] = _mline_cd;
MyOraDB.Parameter_Values[1] = "";
MyOraDB.Add_Select_Parameter(true);
ds_ret = MyOraDB.Exe_Select_Procedure();
if (ds_ret == null)
{
return(null);
}
return(ds_ret.Tables[process_name]);
}
catch
{
return(null);
}
}
private DataTable select_chart_2()
{
System.Data.DataSet retDS;
COM.OraDB MyOraDB = new COM.OraDB();
MyOraDB.ReDim_Parameter(1);
MyOraDB.Process_Name = "pkg_deffect_status.select_chart_2";
//02.ARGURMENT ¢¬i
MyOraDB.Parameter_Name[0] = "OUT_CURSOR";
//03.DATA TYPE A¢´AC
MyOraDB.Parameter_Type[0] = (int)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = "";
MyOraDB.Add_Select_Parameter(true);
retDS = MyOraDB.Exe_Select_Procedure();
if (retDS == null) return null;
return retDS.Tables[MyOraDB.Process_Name];
}
//private void Line1_Click(
#endregion Method
#region DB
private DataTable LOAD_DATA()
{
try
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
string process_name = "MES.PKG_SMT_PROD_SHOW.SEL_LEAD_TIME";
//ARGMODE
MyOraDB.ReDim_Parameter(3);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_WH_CD";
MyOraDB.Parameter_Name[1] = "ARG_MLINE_CD";
MyOraDB.Parameter_Name[2] = "OUT_CURSOR";
MyOraDB.Parameter_Type[0] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[1] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[2] = (char)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = _Line;
MyOraDB.Parameter_Values[1] = _Mline;
MyOraDB.Parameter_Values[2] = "";
MyOraDB.Add_Select_Parameter(true);
ds_ret = MyOraDB.Exe_Select_Procedure();
if (ds_ret == null)
{
return(null);
}
return(ds_ret.Tables[process_name]);
}
catch
{
return(null);
}
}
public DataTable SEL_DMC_HEADER_INFOR(string ARG_LOCATE)
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
try
{
string process_name = "PKG_DMC_AGING_LOCATION.SEL_DMC_HEADER_INFOR";
MyOraDB.ReDim_Parameter(2);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_LOCATE";
MyOraDB.Parameter_Name[1] = "OUT_CURSOR";
MyOraDB.Parameter_Type[0] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[1] = (int)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = ARG_LOCATE;
MyOraDB.Parameter_Values[1] = "";
MyOraDB.Add_Select_Parameter(true);
ds_ret = MyOraDB.Exe_Select_Procedure();
if (ds_ret == null)
{
return(null);
}
return(ds_ret.Tables[process_name]);
}
catch
{
return(null);
}
}
public DataTable SEL_GET_FORM(string argGrp)
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
try
{
string process_name = "SEPHIROTH.PROC_STB_GET_FORM";
MyOraDB.ReDim_Parameter(2);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_GRP";
MyOraDB.Parameter_Name[1] = "OUT_CURSOR";
MyOraDB.Parameter_Type[0] = (int)OracleType.VarChar;
MyOraDB.Parameter_Type[1] = (int)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = argGrp;
MyOraDB.Parameter_Values[1] = "";
MyOraDB.Add_Select_Parameter(true);
ds_ret = MyOraDB.Exe_Select_Procedure();
if (ds_ret == null)
{
return(null);
}
return(ds_ret.Tables[process_name]);
}
catch (Exception ex)
{
ComVar.Var.writeToLog(this.Name + "/SEL_GET_FORM : " + ex.ToString());
return(null);
}
}
public static DataTable SEL_APS_PLAN_ACTUAL(string arg_wh)
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
try
{
string process_name = "PKG_DMC.SEL_MOLD_PRODUCTION_LAYOUT";
MyOraDB.ReDim_Parameter(2);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_WH_CD";
MyOraDB.Parameter_Name[1] = "OUT_CURSOR";
MyOraDB.Parameter_Type[0] = (int)OracleType.VarChar;
MyOraDB.Parameter_Type[1] = (int)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = arg_wh;
MyOraDB.Parameter_Values[1] = "";
MyOraDB.Add_Select_Parameter(true);
ds_ret = MyOraDB.Exe_Select_Procedure();
if (ds_ret == null)
{
return(null);
}
return(ds_ret.Tables[process_name]);
}
catch
{
return(null);
}
}
private DataTable select_deffect_monitor()
{
System.Data.DataSet retDS;
COM.OraDB MyOraDB = new COM.OraDB();
MyOraDB.ReDim_Parameter(1);
MyOraDB.Process_Name = "MES.PKG_SMT_B2_IP.SELECT_DEFFECT_MONITOR";
//02.ARGURMENT ¢¬i
MyOraDB.Parameter_Name[0] = "OUT_CURSOR";
//03.DATA TYPE A¢´AC
MyOraDB.Parameter_Type[0] = (int)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = "";
MyOraDB.Add_Select_Parameter(true);
retDS = MyOraDB.Exe_Select_Procedure();
if (retDS == null) return null;
return retDS.Tables[MyOraDB.Process_Name];
}
// SEL_DMC_SUMPROD_BY_CELL
public DataTable SEL_DMC_SUMPROD_BY_TOTAL()
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
try
{
string process_name = "PKG_DMC_AGING_LOCATION.SEL_DMC_SUMPROD_BY_TOTAL";
MyOraDB.ReDim_Parameter(1);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "OUT_CURSOR";
MyOraDB.Parameter_Type[0] = (int)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = "";
MyOraDB.Add_Select_Parameter(true);
ds_ret = MyOraDB.Exe_Select_Procedure();
if (ds_ret == null)
{
return(null);
}
return(ds_ret.Tables[process_name]);
}
catch
{
return(null);
}
}
private DataTable SP_MGL_TREELIST_CHART_DETAIL(string ARG_TYPE, string ARG_DATE, string ARG_PLANT)
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
try
{
string process_name = "MES.PKG_MGL_VJ3.SP_MGL_TREELIST_CHART_DETAIL";
MyOraDB.ReDim_Parameter(4);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_TYPE";
MyOraDB.Parameter_Name[1] = "ARG_DATE";
MyOraDB.Parameter_Name[2] = "ARG_PLANT";
MyOraDB.Parameter_Name[3] = "OUT_CURSOR";
MyOraDB.Parameter_Type[0] = (int)OracleType.VarChar;
MyOraDB.Parameter_Type[1] = (int)OracleType.VarChar;
MyOraDB.Parameter_Type[2] = (int)OracleType.VarChar;
MyOraDB.Parameter_Type[3] = (int)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = ARG_TYPE;
MyOraDB.Parameter_Values[1] = ARG_DATE;
MyOraDB.Parameter_Values[2] = ARG_PLANT;
MyOraDB.Parameter_Values[3] = "";
MyOraDB.Add_Select_Parameter(true);
ds_ret = MyOraDB.Exe_Select_Procedure();
if (ds_ret == null)
{
return(null);
}
return(ds_ret.Tables[process_name]);
}
catch
{
return(null);
}
}
// UC.UC_PH_MACHINE_GRID UC = new UC.UC_PH_MACHINE_GRID();
//UC.UC_PH_MACHINE_GRID UC23_44 = new UC.UC_PH_MACHINE_GRID();
#endregion
#region Oracle
private DataTable SELECT_DATA(string ARG_QTYPE)
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
try
{
string process_name = "MES.PKG_SMT_B1_PHUOC.PH_OEE_YEARLY_SELECT";
MyOraDB.ReDim_Parameter(2);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_QTYPE";
MyOraDB.Parameter_Name[1] = "OUT_CURSOR";
MyOraDB.Parameter_Type[0] = (int)OracleType.VarChar;
MyOraDB.Parameter_Type[1] = (int)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = ARG_QTYPE;
MyOraDB.Parameter_Values[1] = "";
MyOraDB.Add_Select_Parameter(true);
ds_ret = MyOraDB.Exe_Select_Procedure();
if (ds_ret == null)
{
return(null);
}
return(ds_ret.Tables[process_name]);
}
catch
{
return(null);
}
}
public DataSet LOAD_DATA_v2()
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
try
{
string process_name = "SEPHIROTH.PKG_DMC.SEL_PROD_SET_STATUS_V2";
MyOraDB.ReDim_Parameter(2);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "OUT_CURSOR1";
MyOraDB.Parameter_Name[1] = "OUT_CURSOR";
MyOraDB.Parameter_Type[0] = (int)OracleType.Cursor;
MyOraDB.Parameter_Type[1] = (int)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = "";
MyOraDB.Parameter_Values[1] = "";
MyOraDB.Add_Select_Parameter(true);
ds_ret = MyOraDB.Exe_Select_Procedure();
if (ds_ret == null)
{
return(null);
}
return(ds_ret);
}
catch
{
return(null);
}
}
public DataTable SEL_DATA_ANDON(string Qtype, string V_P_YMD_F, string V_P_YMD_T, string V_P_LINE, string V_P_MLINE, string V_P_STATION, string V_P_PROCESS, string V_P_DOWNTIME, string V_P_TOP5)
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
try
{
string process_name = "MES.PKG_SMT_PROD.SP_SMT_ANDON_GATHERING"; //SP_SMT_ANDON_DAILY
MyOraDB.ReDim_Parameter(10);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "V_P_TYPE";
MyOraDB.Parameter_Name[1] = "V_P_YMD_F";
MyOraDB.Parameter_Name[2] = "V_P_YMD_T";
MyOraDB.Parameter_Name[3] = "V_P_LINE";
MyOraDB.Parameter_Name[4] = "V_P_MLINE";
MyOraDB.Parameter_Name[5] = "V_P_STATION";
MyOraDB.Parameter_Name[6] = "V_P_PROCESS";
MyOraDB.Parameter_Name[7] = "V_P_DOWNTIME";
MyOraDB.Parameter_Name[8] = "V_P_TOP5";
MyOraDB.Parameter_Name[9] = "OUT_CURSOR";
MyOraDB.Parameter_Type[0] = (int)OracleType.VarChar;
MyOraDB.Parameter_Type[1] = (int)OracleType.VarChar;
MyOraDB.Parameter_Type[2] = (int)OracleType.VarChar;
MyOraDB.Parameter_Type[3] = (int)OracleType.VarChar;
MyOraDB.Parameter_Type[4] = (int)OracleType.VarChar;
MyOraDB.Parameter_Type[5] = (int)OracleType.VarChar;
MyOraDB.Parameter_Type[6] = (int)OracleType.VarChar;
MyOraDB.Parameter_Type[7] = (int)OracleType.VarChar;
MyOraDB.Parameter_Type[8] = (int)OracleType.VarChar;
MyOraDB.Parameter_Type[9] = (int)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = Qtype;
MyOraDB.Parameter_Values[1] = V_P_YMD_F;
MyOraDB.Parameter_Values[2] = V_P_YMD_T;
MyOraDB.Parameter_Values[3] = V_P_LINE;
MyOraDB.Parameter_Values[4] = V_P_MLINE;
MyOraDB.Parameter_Values[5] = V_P_STATION;
MyOraDB.Parameter_Values[6] = V_P_PROCESS;
MyOraDB.Parameter_Values[7] = V_P_DOWNTIME;
MyOraDB.Parameter_Values[8] = V_P_TOP5;
//MyOraDB.Parameter_Values[1] = date_F.DateTime.ToString("yyyyMMdd");
//MyOraDB.Parameter_Values[2] = date_T.DateTime.ToString("yyyyMMdd");
//MyOraDB.Parameter_Values[3] = "099";
//MyOraDB.Parameter_Values[4] = cboMline.EditValue.ToString();
//MyOraDB.Parameter_Values[5] = cboStation.EditValue.ToString();
//MyOraDB.Parameter_Values[6] = cboProcess.EditValue.ToString();
//MyOraDB.Parameter_Values[7] = V_P_DOWNTIME;
//MyOraDB.Parameter_Values[8] = V_P_TOP5;
MyOraDB.Parameter_Values[9] = "";
MyOraDB.Add_Select_Parameter(true);
ds_ret = MyOraDB.Exe_Select_Procedure();
if (ds_ret == null)
{
return(null);
}
return(ds_ret.Tables[process_name]);
}
catch
{
return(null);
}
}
private System.Data.DataSet GET_DATA(string argWH)
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
try
{
string process_name = "MES.PKG_SMT_B1_DIGITAL.SEL_DATA_FORM_MAIN";
MyOraDB.ReDim_Parameter(11);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_WH_CD";
MyOraDB.Parameter_Name[1] = "OUT_CURSOR";
MyOraDB.Parameter_Name[2] = "OUT_CURSOR1";
MyOraDB.Parameter_Name[3] = "OUT_CURSOR2";
MyOraDB.Parameter_Name[4] = "OUT_CURSOR3";
MyOraDB.Parameter_Name[5] = "OUT_CURSOR4";
MyOraDB.Parameter_Name[6] = "OUT_CURSOR5";
MyOraDB.Parameter_Name[7] = "OUT_CURSOR6";
MyOraDB.Parameter_Name[8] = "OUT_CURSOR7";
MyOraDB.Parameter_Name[9] = "OUT_CURSOR8";
MyOraDB.Parameter_Name[10] = "OUT_CURSOR9";
MyOraDB.Parameter_Type[0] = (int)OracleType.VarChar;
MyOraDB.Parameter_Type[1] = (int)OracleType.Cursor;
MyOraDB.Parameter_Type[2] = (int)OracleType.Cursor;
MyOraDB.Parameter_Type[3] = (int)OracleType.Cursor;
MyOraDB.Parameter_Type[4] = (int)OracleType.Cursor;
MyOraDB.Parameter_Type[5] = (int)OracleType.Cursor;
MyOraDB.Parameter_Type[6] = (int)OracleType.Cursor;
MyOraDB.Parameter_Type[7] = (int)OracleType.Cursor;
MyOraDB.Parameter_Type[8] = (int)OracleType.Cursor;
MyOraDB.Parameter_Type[9] = (int)OracleType.Cursor;
MyOraDB.Parameter_Type[10] = (int)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = argWH;
MyOraDB.Parameter_Values[1] = "";
MyOraDB.Parameter_Values[2] = "";
MyOraDB.Parameter_Values[3] = "";
MyOraDB.Parameter_Values[4] = "";
MyOraDB.Parameter_Values[5] = "";
MyOraDB.Parameter_Values[6] = "";
MyOraDB.Parameter_Values[7] = "";
MyOraDB.Parameter_Values[8] = "";
MyOraDB.Parameter_Values[9] = "";
MyOraDB.Parameter_Values[10] = "";
MyOraDB.Add_Select_Parameter(true);
ds_ret = MyOraDB.Exe_Select_Procedure();
if (ds_ret == null)
{
return(null);
}
return(ds_ret);
}
catch
{
return(null);
}
}
private DataSet SELECT_DATA(string WorkType, string DateF, string DateT, string Line, string Trip)
{
System.Data.DataSet retDS;
COM.OraDB MyOraDB = new COM.OraDB(1); //1.LMES , 2.SEPHIROTH
MyOraDB.ReDim_Parameter(14);
MyOraDB.Process_Name = "P_GMES0262_Q_PHUOCTEST";
MyOraDB.Parameter_Type[0] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[1] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[2] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[3] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[4] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[5] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[6] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[7] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[8] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[9] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[10] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[11] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[12] = (char)OracleType.Cursor;
MyOraDB.Parameter_Type[13] = (char)OracleType.Cursor;
MyOraDB.Parameter_Name[0] = "V_P_WORK_TYPE";
MyOraDB.Parameter_Name[1] = "V_P_DATEF";
MyOraDB.Parameter_Name[2] = "V_P_DATET";
MyOraDB.Parameter_Name[3] = "V_P_LINE_CD";
MyOraDB.Parameter_Name[4] = "V_P_TRIP";
MyOraDB.Parameter_Name[5] = "V_P_ERROR_CODE";
MyOraDB.Parameter_Name[6] = "V_P_ROW_COUNT";
MyOraDB.Parameter_Name[7] = "V_P_ERROR_NOTE";
MyOraDB.Parameter_Name[8] = "V_P_RETURN_STR";
MyOraDB.Parameter_Name[9] = "V_P_ERROR_STR";
MyOraDB.Parameter_Name[10] = "V_ERRORSTATE";
MyOraDB.Parameter_Name[11] = "V_ERRORPROCEDURE";
MyOraDB.Parameter_Name[12] = "OUT_CURSOR";
MyOraDB.Parameter_Name[13] = "OUT_CURSOR1";
MyOraDB.Parameter_Values[0] = WorkType;
MyOraDB.Parameter_Values[1] = DateF;
MyOraDB.Parameter_Values[2] = DateT;
MyOraDB.Parameter_Values[3] = Line;
MyOraDB.Parameter_Values[4] = Trip;
MyOraDB.Parameter_Values[5] = "";
MyOraDB.Parameter_Values[6] = "";
MyOraDB.Parameter_Values[7] = "";
MyOraDB.Parameter_Values[8] = "";
MyOraDB.Parameter_Values[9] = "";
MyOraDB.Parameter_Values[10] = "";
MyOraDB.Parameter_Values[11] = "";
MyOraDB.Parameter_Values[12] = "";
MyOraDB.Parameter_Values[13] = "";
MyOraDB.Add_Select_Parameter(true);
retDS = MyOraDB.Exe_Select_Procedure();
if (retDS == null)
{
return(null);
}
return(retDS);
}
private System.Data.DataSet GET_DATA()
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
try
{
string process_name = "MES.PKG_SMT_B_HR_STATUS.SEL_FTY_LT_HR_STATUS";
MyOraDB.ReDim_Parameter(6);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_QTYPE";
MyOraDB.Parameter_Name[1] = "ARG_LINE_CD";
MyOraDB.Parameter_Name[2] = "ARG_MLINE_CD";
MyOraDB.Parameter_Name[3] = "ARG_YM";
MyOraDB.Parameter_Name[4] = "OUT_CURSOR";
MyOraDB.Parameter_Name[5] = "OUT_CURSOR1";
MyOraDB.Parameter_Type[0] = (int)OracleType.VarChar;
MyOraDB.Parameter_Type[1] = (int)OracleType.VarChar;
MyOraDB.Parameter_Type[2] = (int)OracleType.VarChar;
MyOraDB.Parameter_Type[3] = (int)OracleType.VarChar;
MyOraDB.Parameter_Type[4] = (int)OracleType.Cursor;
MyOraDB.Parameter_Type[5] = (int)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = btnYM;
MyOraDB.Parameter_Values[1] = _line;
MyOraDB.Parameter_Values[2] = _mLine;
if (btnYM == "A")
{
MyOraDB.Parameter_Values[3] = uc_month.GetValue().ToString();
}
else
{
MyOraDB.Parameter_Values[3] = uc_year.GetValue().ToString();
}
MyOraDB.Parameter_Values[4] = "";
MyOraDB.Parameter_Values[5] = "";
MyOraDB.Add_Select_Parameter(true);
ds_ret = MyOraDB.Exe_Select_Procedure();
if (ds_ret == null)
{
return(null);
}
if (btnYM == "A")
{
ComVar.Func.WriteXML("FRM_SMT_HR_ABSENT_MONTH_" + uc_month.GetValue().ToString() + _line + _mLine, ds_ret);
}
else
{
ComVar.Func.WriteXML("FRM_SMT_HR_ABSENT_YEAR_" + uc_year.GetValue().ToString() + _line + _mLine, ds_ret);
}
return(ds_ret);
}
catch
{
return(null);
}
}
private DataTable Load_Data(string ArgDB, string ArgProc, string ArgType, string ArgLine = "", string ArgSdate = "", string ArgEdate = "",
string ArgVal1 = "", string ArgVal2 = "", string ArgVal3 = "", string ArgVal4 = "", string ArgVal5 = "")
{
try
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
if (ArgDB == "LMES")
{
MyOraDB.ConnectName = COM.OraDB.ConnectDB.LMES;
}
MyOraDB.TimeOut = 200000;
//MyOraDB.ShowError = true;
string process_name = ArgProc;
MyOraDB.ReDim_Parameter(10);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_TYPE";
MyOraDB.Parameter_Name[1] = "ARG_LINE";
MyOraDB.Parameter_Name[2] = "ARG_SDATE";
MyOraDB.Parameter_Name[3] = "ARG_EDATE";
MyOraDB.Parameter_Name[4] = "ARG_VAL1";
MyOraDB.Parameter_Name[5] = "ARG_VAL2";
MyOraDB.Parameter_Name[6] = "ARG_VAL3";
MyOraDB.Parameter_Name[7] = "ARG_VAL4";
MyOraDB.Parameter_Name[8] = "ARG_VAL5";
MyOraDB.Parameter_Name[9] = "OUT_CURSOR";
MyOraDB.Parameter_Type[0] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[1] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[2] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[3] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[4] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[5] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[6] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[7] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[8] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[9] = (char)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = ArgType;
MyOraDB.Parameter_Values[1] = ArgLine;
MyOraDB.Parameter_Values[2] = ArgSdate;
MyOraDB.Parameter_Values[3] = ArgEdate;
MyOraDB.Parameter_Values[4] = ArgVal1;
MyOraDB.Parameter_Values[5] = ArgVal2;
MyOraDB.Parameter_Values[6] = ArgVal3;
MyOraDB.Parameter_Values[7] = ArgVal4;
MyOraDB.Parameter_Values[8] = ArgVal5;
MyOraDB.Parameter_Values[9] = "";
MyOraDB.Add_Select_Parameter(true);
ds_ret = MyOraDB.Exe_Select_Procedure();
if (ds_ret == null)
{
return(null);
}
return(ds_ret.Tables[process_name]);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
return(null);
}
}
public DataTable SELECT_DATA(string ARG_TYPE, string ARG_FACTORY, string ARG_PLANT, string ARG_LINE, string ARG_MLINE, string ARG_YMD, string ARG_PROC, string ARG_STYLE, string ARG_RESOURCE, string ARG_HOUR, string ARG_PART)
{
try
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
string process_name = "SEPHIROTH.P_CUTTING_MANUAL_SELECT";
MyOraDB.ReDim_Parameter(12);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_TYPE";
MyOraDB.Parameter_Name[1] = "ARG_FACTORY";
MyOraDB.Parameter_Name[2] = "ARG_PLANT";
MyOraDB.Parameter_Name[3] = "ARG_LINE";
MyOraDB.Parameter_Name[4] = "ARG_MLINE";
MyOraDB.Parameter_Name[5] = "ARG_YMD";
MyOraDB.Parameter_Name[6] = "ARG_PROC";
MyOraDB.Parameter_Name[7] = "ARG_STYLE";
MyOraDB.Parameter_Name[8] = "ARG_RESOURCE";
MyOraDB.Parameter_Name[9] = "ARG_HOUR";
MyOraDB.Parameter_Name[10] = "ARG_PART";
MyOraDB.Parameter_Name[11] = "OUT_CURSOR";
MyOraDB.Parameter_Type[0] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[1] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[2] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[3] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[4] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[5] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[6] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[7] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[8] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[9] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[10] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[11] = (char)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = ARG_TYPE;
MyOraDB.Parameter_Values[1] = ARG_FACTORY;
MyOraDB.Parameter_Values[2] = ARG_PLANT;
MyOraDB.Parameter_Values[3] = ARG_LINE;
MyOraDB.Parameter_Values[4] = ARG_MLINE;
MyOraDB.Parameter_Values[5] = ARG_YMD;
MyOraDB.Parameter_Values[6] = ARG_PROC;
MyOraDB.Parameter_Values[7] = ARG_STYLE;
MyOraDB.Parameter_Values[8] = ARG_RESOURCE;
MyOraDB.Parameter_Values[9] = ARG_HOUR;
MyOraDB.Parameter_Values[10] = ARG_PART;
MyOraDB.Parameter_Values[11] = "";
MyOraDB.Add_Select_Parameter(true);
ds_ret = MyOraDB.Exe_Select_Procedure();
if (ds_ret == null)
{
return(null);
}
return(ds_ret.Tables[process_name]);
}
catch
{
return(null);
}
}
public bool EXE_INPUT_DELETE(string ARG_TYPE, string ARG_FACTORY, string ARG_PLANT, string ARG_LINE, string ARG_MLINE, string ARG_YMD, string ARG_PROC, string ARG_STYLE, string ARG_RESOURCE, string ARG_HOUR, string ARG_PART, string ARG_SIZE)
{
try
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
string process_name = "SEPHIROTH.P_CUTTING_MANUAL_INPUT";
MyOraDB.ReDim_Parameter(13);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_TYPE";
MyOraDB.Parameter_Name[1] = "ARG_FACTORY";
MyOraDB.Parameter_Name[2] = "ARG_PLANT";
MyOraDB.Parameter_Name[3] = "ARG_LINE";
MyOraDB.Parameter_Name[4] = "ARG_MLINE";
MyOraDB.Parameter_Name[5] = "ARG_YMD";
MyOraDB.Parameter_Name[6] = "ARG_PROC";
MyOraDB.Parameter_Name[7] = "ARG_STYLE";
MyOraDB.Parameter_Name[8] = "ARG_RESOURCE";
MyOraDB.Parameter_Name[9] = "ARG_HOUR";
MyOraDB.Parameter_Name[10] = "ARG_PART";
MyOraDB.Parameter_Name[11] = "ARG_SIZE";
MyOraDB.Parameter_Name[12] = "ARG_USER";
MyOraDB.Parameter_Type[0] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[1] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[2] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[3] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[4] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[5] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[6] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[7] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[8] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[9] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[10] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[11] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[12] = (char)OracleType.VarChar;
MyOraDB.Parameter_Values[0] = ARG_TYPE;
MyOraDB.Parameter_Values[1] = ARG_FACTORY;
MyOraDB.Parameter_Values[2] = ARG_PLANT;
MyOraDB.Parameter_Values[3] = ARG_LINE;
MyOraDB.Parameter_Values[4] = ARG_MLINE;
MyOraDB.Parameter_Values[5] = ARG_YMD;
MyOraDB.Parameter_Values[6] = ARG_PROC;
MyOraDB.Parameter_Values[7] = ARG_STYLE;
MyOraDB.Parameter_Values[8] = ARG_RESOURCE;
MyOraDB.Parameter_Values[9] = ARG_HOUR;
MyOraDB.Parameter_Values[10] = ARG_PART;
MyOraDB.Parameter_Values[11] = ARG_SIZE;
MyOraDB.Parameter_Values[12] = Environment.MachineName;
MyOraDB.Add_Modify_Parameter(true);
ds_ret = MyOraDB.Exe_Modify_Procedure();
if (ds_ret == null)
{
return(false);
}
return(true);
}
catch
{
return(false);
}
}