private DataTable SELECT_TMS_VJ3_TRIP_TIME()
{
try
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
string process_name = "MES.SP_VJ3_TMS_TRIP_TIME";
MyOraDB.ReDim_Parameter(1);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "OUT_CURSOR";
MyOraDB.Parameter_Type[0] = (char)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[0]);
}
catch
{
return(null);
}
}
private DataTable Select_Train_Time(string Qtype, string Factory)
{
try
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
string process_name = "MES.PKG_TMS_HOME.TMS_GET_DEPART_TIME";
MyOraDB.ReDim_Parameter(3);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_QTYPE";
MyOraDB.Parameter_Name[1] = "ARG_FAC";
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] = Qtype;
MyOraDB.Parameter_Values[1] = Factory;
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[0]);
}
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_OS_DEFECTIVE.SEL_OS_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]);
}
private DataTable select_chart_3()
{
System.Data.DataSet retDS;
COM.OraDB MyOraDB = new COM.OraDB();
MyOraDB.ReDim_Parameter(1);
MyOraDB.Process_Name = "pkg_DMC.sel_chart_3";
//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]);
}
public DataTable SEL_TOTAL_PLAN_ACTUAL()
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
string process_name = "PKG_SPB_MOLD_WMS_V2.SEL_QTY_ACTUAL";
MyOraDB.ReDim_Parameter(2);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "OUT_CURSOR";
MyOraDB.Parameter_Name[1] = "ARG_WH_CD";
MyOraDB.Parameter_Type[0] = (int)OracleType.Cursor;
MyOraDB.Parameter_Type[1] = (int)OracleType.VarChar;
MyOraDB.Parameter_Values[0] = "";
MyOraDB.Parameter_Values[1] = "50";
MyOraDB.Add_Select_Parameter(true);
ds_ret = MyOraDB.Exe_Select_Procedure();
if (ds_ret == null)
{
return(null);
}
return(ds_ret.Tables[process_name]);
}
private DataTable select_chart_1(string arg_month)
{
System.Data.DataSet retDS;
COM.OraDB MyOraDB = new COM.OraDB();
MyOraDB.ReDim_Parameter(2);
MyOraDB.Process_Name = "MES.PKG_SMT_OS_DEFECTIVE.SEL_CHART_1_V2";
//02.ARGURMENT ¢¬i
MyOraDB.Parameter_Name[0] = "ARG_MONTH";
MyOraDB.Parameter_Name[1] = "OUT_CURSOR";
//03.DATA TYPE A¢´AC
MyOraDB.Parameter_Type[0] = (int)OracleType.NVarChar;
MyOraDB.Parameter_Type[1] = (int)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = arg_month;
MyOraDB.Parameter_Values[1] = "";
MyOraDB.Add_Select_Parameter(true);
retDS = MyOraDB.Exe_Select_Procedure();
if (retDS == null)
{
return(null);
}
return(retDS.Tables[MyOraDB.Process_Name]);
}
private DataTable Sel_Data(string Qtype, string ARG_DATE)
{
System.Data.DataSet retDS;
COM.OraDB MyOraDB = new COM.OraDB();
MyOraDB.ReDim_Parameter(3);
MyOraDB.Process_Name = "MES.PKG_SMT_B2_IP.SEL_FS_IP_DATA";
MyOraDB.Parameter_Name[0] = "ARG_QTYPE";
MyOraDB.Parameter_Name[1] = "ARG_DATE";
MyOraDB.Parameter_Name[2] = "OUT_CURSOR";
MyOraDB.Parameter_Type[0] = (int)OracleType.VarChar;
MyOraDB.Parameter_Type[1] = (int)OracleType.VarChar;
MyOraDB.Parameter_Type[2] = (int)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = Qtype;
MyOraDB.Parameter_Values[1] = ARG_DATE;
MyOraDB.Parameter_Values[2] = "";
MyOraDB.Add_Select_Parameter(true);
retDS = MyOraDB.Exe_Select_Procedure();
if (retDS == null)
{
return(null);
}
return(retDS.Tables[MyOraDB.Process_Name]);
}
private DataTable SP_MGL_HOME_CHART_DETAIL_SELECT(string V_P_TYPE, string V_P_FACTORY)
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
try
{
string process_name = "MES.PKG_MGL_VJ3.MGL_HOME_CHART_DETAIL_SELECT";
MyOraDB.ReDim_Parameter(3);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_TYPE";
MyOraDB.Parameter_Name[1] = "ARG_FACTORY";
MyOraDB.Parameter_Name[2] = "OUT_CURSOR";
MyOraDB.Parameter_Type[0] = (int)OracleType.VarChar;
MyOraDB.Parameter_Type[1] = (int)OracleType.VarChar;
MyOraDB.Parameter_Type[2] = (int)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = V_P_TYPE;
MyOraDB.Parameter_Values[1] = V_P_FACTORY;
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 PRINTING_OS_PRODUCTION_DATA(string ARG_QTYPE)
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
try
{
string process_name = "MES.PKG_SMT_PRINTING_VJ3.PRINTING_SELECT_MENU";
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);
}
}
private DataTable SELECT_ASSY_DATE()
{
System.Data.DataSet retDS;
COM.OraDB MyOraDB = new COM.OraDB();
MyOraDB.ReDim_Parameter(2);
MyOraDB.Process_Name = "MES.PKG_SFC_ROLL_SO.SELECT_ASSY_DATE";
//02.ARGURMENT ¢¬i
MyOraDB.Parameter_Name[0] = "ARG_OP_CD";
MyOraDB.Parameter_Name[1] = "OUT_CURSOR";
//03.DATA TYPE A¢´AC
MyOraDB.Parameter_Type[0] = (int)OracleType.NVarChar;
MyOraDB.Parameter_Type[1] = (int)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = "OS";
MyOraDB.Parameter_Values[1] = "";
MyOraDB.Add_Select_Parameter(true);
retDS = MyOraDB.Exe_Select_Procedure();
if (retDS == null)
{
return(null);
}
return(retDS.Tables[MyOraDB.Process_Name]);
}
Point origin = new Point(133, 310); // my origin
private DataTable Select_Train_Time()
{
try
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
string process_name = "MES.SP_TMS_TRAIN_TIME";
MyOraDB.ReDim_Parameter(2);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "V_P_YMD";
MyOraDB.Parameter_Name[1] = "CV_1";
MyOraDB.Parameter_Type[0] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[1] = (char)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = DateTime.Now.ToString("yyyyMMdd");
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[0]);
}
catch
{
return(null);
}
}
private DataTable SEL_DATA()
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
try
{
string process_name = "PROC_GET_INFOR_DOWNLOAD_V2";
MyOraDB.ReDim_Parameter(2);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_PROGAME";
MyOraDB.Parameter_Name[1] = "OUT_CURSOR";
MyOraDB.Parameter_Type[0] = (int)OracleType.VarChar;
MyOraDB.Parameter_Type[1] = (int)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = _dtXML.Rows[0]["grpFORM"].ToString();
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 LOAD_DATA_TEMP_RUB()
{
try
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
string process_name = "MES.PKG_OS_RUB_TEMP_TRACKING.SP_RUB_TEMP_TRACKING";
//ARGMODE
MyOraDB.ReDim_Parameter(1);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "CV_1";
MyOraDB.Parameter_Type[0] = (char)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);
}
}
public DataTable SELECT_DMP_SHELF_MASTER()
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
try
{
string process_name = "PKG_DMC_LOCATION.SEL_DMP_SHELF_MASTER_NEW";
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);
}
}
public DataTable SEL_PU_LEAD_TIME()
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
try
{
string process_name = "MES.PKG_SMT_PU.SELECT_PU_LEADTIME";
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 DataSet Sel_Mline(string Proc_Name, string ARG_PLANT)
{
try
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
string process_name = Proc_Name;
MyOraDB.ReDim_Parameter(2);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_PLANT";
MyOraDB.Parameter_Name[1] = "OUT_CURSOR";
MyOraDB.Parameter_Type[0] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[1] = (char)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = ARG_PLANT;
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);
}
}
private DataTable LOAD_DATA()
{
try
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
string process_name = "SEPHIROTH.PKG_DMC.SEL_PROD_SET_STATUS";
//ARGMODE
MyOraDB.ReDim_Parameter(1);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "OUT_CURSOR";
MyOraDB.Parameter_Type[0] = (char)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_SMT_EMD_MENU_SELECT(string V_P_TYPE)
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
try
{
string process_name = "MES.PKG_SMT_PROD_EMD.SP_SMT_EMD_MENU_SELECT";
MyOraDB.ReDim_Parameter(2);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "V_P_TYPE";
MyOraDB.Parameter_Name[1] = "OUT_CURSOR";
MyOraDB.Parameter_Type[0] = (int)OracleType.VarChar;
MyOraDB.Parameter_Type[1] = (int)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = V_P_TYPE;
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 TMS_HOME_SELECT(string ARG_TYPE, string ARG_YMD)
{
try
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
string process_name = "MES.PKG_TMS_PREFIT.TMS_HOME_SELECT";
MyOraDB.ReDim_Parameter(3);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_TYPE";
MyOraDB.Parameter_Name[1] = "ARG_YMD";
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] = ARG_TYPE;
MyOraDB.Parameter_Values[1] = ARG_YMD;
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[0]);
}
catch (Exception ex)
{
return(null);
}
}
private DataTable LOAD_BY_MODEL(string argMode)
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
try
{
string process_name = "MES.PKG_SMT_B1_DIGITAL.MOLD_REPAIR_BY_MODEL";
//ARGMODE
MyOraDB.ReDim_Parameter(2);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_WH_CD";
MyOraDB.Parameter_Type[0] = (char)OracleType.VarChar;
MyOraDB.Parameter_Values[0] = argMode;
MyOraDB.Parameter_Name[1] = "OUT_CURSOR";
MyOraDB.Parameter_Type[1] = (char)OracleType.Cursor;
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 System.Data.DataSet LOAD_DATA_v2(string sLine_cd, string sMline_cd, string smonth)
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
try
{
string process_name = "MES.PKG_SMT_PROD_SHOW.SEL_PRODUCTIVITY_MONTH_V2";
MyOraDB.ReDim_Parameter(10);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_LINE_CD";
MyOraDB.Parameter_Name[1] = "ARG_MLINE_CD";
MyOraDB.Parameter_Name[2] = "ARG_MONTH";
MyOraDB.Parameter_Name[3] = "OUT_CURSOR";
MyOraDB.Parameter_Name[4] = "OUT_CURSOR1";
MyOraDB.Parameter_Name[5] = "OUT_CURSOR2";
MyOraDB.Parameter_Name[6] = "OUT_CURSOR3";
MyOraDB.Parameter_Name[7] = "OUT_CURSOR4";
MyOraDB.Parameter_Name[8] = "OUT_CURSOR5";
MyOraDB.Parameter_Name[9] = "OUT_CURSOR6";
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_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_Values[0] = sLine_cd;
MyOraDB.Parameter_Values[1] = sMline_cd;
MyOraDB.Parameter_Values[2] = smonth;
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.Add_Select_Parameter(true);
ds_ret = MyOraDB.Exe_Select_Procedure();
if (ds_ret == null)
{
return(null);
}
return(ds_ret);
}
catch
{
return(null);
}
}
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_MGL_VJ2_HR_ABSENT";
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] = "A";
MyOraDB.Parameter_Values[1] = ComVar.Var._strValue1;
MyOraDB.Parameter_Values[2] = "";
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_" + _mLine, ds_ret);
//else
// ComVar.Func.WriteXML("FRM_SMT_HR_ABSENT_YEAR_" + _mLine, ds_ret);
return(ds_ret);
}
catch
{
return(null);
}
}
public System.Data.DataSet LOAD_DATA_v2()
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
try
{
string process_name = "MES.PKG_MGL_VJ2.MGL_PRODUCTIVITY_WEEKLY";
MyOraDB.ReDim_Parameter(9);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "OUT_CURSOR";
MyOraDB.Parameter_Name[1] = "OUT_CURSOR1";
MyOraDB.Parameter_Name[2] = "OUT_CURSOR2";
MyOraDB.Parameter_Name[3] = "OUT_CURSOR3";
MyOraDB.Parameter_Name[4] = "OUT_CURSOR4";
MyOraDB.Parameter_Name[5] = "ARG_WH_CD";
MyOraDB.Parameter_Name[6] = "ARG_MLINE_CD";
MyOraDB.Parameter_Name[7] = "OUT_CURSOR5";
MyOraDB.Parameter_Name[8] = "OUT_CURSOR6";
MyOraDB.Parameter_Type[0] = (int)OracleType.Cursor;
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.VarChar;
MyOraDB.Parameter_Type[6] = (int)OracleType.VarChar;
MyOraDB.Parameter_Type[7] = (int)OracleType.Cursor;
MyOraDB.Parameter_Type[8] = (int)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = "";
MyOraDB.Parameter_Values[1] = "";
MyOraDB.Parameter_Values[2] = "";
MyOraDB.Parameter_Values[3] = "";
MyOraDB.Parameter_Values[4] = "";
MyOraDB.Parameter_Values[5] = _wh_cd;
MyOraDB.Parameter_Values[6] = _mline_cd;
MyOraDB.Parameter_Values[7] = "";
MyOraDB.Parameter_Values[8] = "";
MyOraDB.Add_Select_Parameter(true);
ds_ret = MyOraDB.Exe_Select_Procedure();
if (ds_ret == null)
{
return(null);
}
return(ds_ret);
}
catch
{
return(null);
}
}
public DataSet TMS_DELIVERY_GETDATA(string PROC_NAME, string ARG_FAC, string ARG_YMD, string ARG_LINE)
{
try
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
string process_name = PROC_NAME;
MyOraDB.ReDim_Parameter(10);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_FAC";
MyOraDB.Parameter_Name[1] = "ARG_YMD";
MyOraDB.Parameter_Name[2] = "ARG_LINE_CD";
MyOraDB.Parameter_Name[3] = "OUT_CURSOR1";
MyOraDB.Parameter_Name[4] = "OUT_CURSOR2";
MyOraDB.Parameter_Name[5] = "OUT_CURSOR3";
MyOraDB.Parameter_Name[6] = "OUT_CURSOR4";
MyOraDB.Parameter_Name[7] = "OUT_CURSOR5";
MyOraDB.Parameter_Name[8] = "OUT_CURSOR6";
MyOraDB.Parameter_Name[9] = "OUT_CURSOR7";
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.Cursor;
MyOraDB.Parameter_Type[4] = (char)OracleType.Cursor;
MyOraDB.Parameter_Type[5] = (char)OracleType.Cursor;
MyOraDB.Parameter_Type[6] = (char)OracleType.Cursor;
MyOraDB.Parameter_Type[7] = (char)OracleType.Cursor;
MyOraDB.Parameter_Type[8] = (char)OracleType.Cursor;
MyOraDB.Parameter_Type[9] = (char)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = ARG_FAC;
MyOraDB.Parameter_Values[1] = ARG_YMD;
MyOraDB.Parameter_Values[2] = ARG_LINE;
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.Add_Select_Parameter(true);
ds_ret = MyOraDB.Exe_Select_Procedure();
if (ds_ret == null)
{
return(null);
}
return(ds_ret);
}
catch
{
return(null);
}
}
public DataSet SEL_DATA_ANALYSIS(string Qtype, string arg_ymd, string arg_op)
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
try
{
string process_name = "MES.PKG_SMT_B1.SP_PH_ANALYSIS_MONTH_V2"; //SP_SMT_ANDON_DAILY
MyOraDB.ReDim_Parameter(9);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "V_P_TYPE";
MyOraDB.Parameter_Name[1] = "V_P_YMD";
MyOraDB.Parameter_Name[2] = "V_P_OP";
MyOraDB.Parameter_Name[3] = "OUT_CURSOR1";
MyOraDB.Parameter_Name[4] = "OUT_CURSOR2";
MyOraDB.Parameter_Name[5] = "OUT_CURSOR3";
MyOraDB.Parameter_Name[6] = "OUT_CURSOR4";
MyOraDB.Parameter_Name[7] = "OUT_CURSOR5";
MyOraDB.Parameter_Name[8] = "OUT_CURSOR6";
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_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_Values[0] = Qtype;
MyOraDB.Parameter_Values[1] = arg_ymd;
MyOraDB.Parameter_Values[2] = arg_op;
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.Add_Select_Parameter(true);
ds_ret = MyOraDB.Exe_Select_Procedure();
if (ds_ret == null)
{
return(null);
}
return(ds_ret);
}
catch
{
return(null);
}
}
private DataSet SEL_DATA(string WorkType, string Date, string Comp, string SetYN)
{
System.Data.DataSet retDS;
COM.OraDB MyOraDB = new COM.OraDB(1);
MyOraDB.ReDim_Parameter(13);
MyOraDB.Process_Name = "LMES.P_MSIV90002A_Q_V05";
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_Type[12] = (char)OracleType.Cursor;
//V_P_TYPE,V_P_OPTION
MyOraDB.Parameter_Name[0] = "V_P_WORK_TYPE";
MyOraDB.Parameter_Name[1] = "V_P_DATE";
MyOraDB.Parameter_Name[2] = "V_P_COMP";
MyOraDB.Parameter_Name[3] = "V_P_SET_YN";
MyOraDB.Parameter_Name[4] = "V_P_ERROR_CODE";
MyOraDB.Parameter_Name[5] = "V_P_ROW_COUNT";
MyOraDB.Parameter_Name[6] = "V_P_ERROR_NOTE";
MyOraDB.Parameter_Name[7] = "V_P_RETURN_STR";
MyOraDB.Parameter_Name[8] = "V_P_ERROR_STR";
MyOraDB.Parameter_Name[9] = "V_ERRORSTATE";
MyOraDB.Parameter_Name[10] = "V_ERRORPROCEDURE";
MyOraDB.Parameter_Name[11] = "CV_1";
MyOraDB.Parameter_Name[12] = "CV_2";
MyOraDB.Parameter_Values[0] = WorkType;
MyOraDB.Parameter_Values[1] = Date;
MyOraDB.Parameter_Values[2] = Comp;
MyOraDB.Parameter_Values[3] = SetYN;
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.Parameter_Values[11] = "";
MyOraDB.Add_Select_Parameter(true);
retDS = MyOraDB.Exe_Select_Procedure();
if (retDS == null)
{
return(null);
}
return(retDS);
}
private DataSet SEL_DATA(string V_P_TYPE, string V_P_DATE)
{
COM.OraDB MyOraDB = new COM.OraDB();
MyOraDB.ConnectName = COM.OraDB.ConnectDB.LMES;
MyOraDB.ShowErr = true;
DataSet ds_ret;
try
{
string process_name = "P_SEND_EMAIL_BUDGET";
MyOraDB.ReDim_Parameter(7);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "V_P_TYPE";
MyOraDB.Parameter_Name[1] = "V_P_LOC";
MyOraDB.Parameter_Name[2] = "V_P_DATE";
MyOraDB.Parameter_Name[3] = "CV_DATA";
MyOraDB.Parameter_Name[4] = "CV_COL";
MyOraDB.Parameter_Name[5] = "CV_SUBJECT";
MyOraDB.Parameter_Name[6] = "CV_EMAIL";
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_Type[4] = (int)OracleType.Cursor;
MyOraDB.Parameter_Type[5] = (int)OracleType.Cursor;
MyOraDB.Parameter_Type[6] = (int)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = V_P_TYPE;
MyOraDB.Parameter_Values[1] = "";
MyOraDB.Parameter_Values[2] = V_P_DATE;
MyOraDB.Parameter_Values[3] = "";
MyOraDB.Parameter_Values[4] = "";
MyOraDB.Parameter_Values[5] = "";
MyOraDB.Parameter_Values[6] = "";
MyOraDB.Add_Select_Parameter(true);
ds_ret = MyOraDB.Exe_Select_Procedure();
if (ds_ret == null)
{
if (V_P_TYPE == "Q")
{
// WriteLog("P_SEND_EMAIL_NPI: null");
}
return(null);
}
return(ds_ret);
}
catch (Exception ex)
{
// WriteLog("SEL_CUTTING_DATA: " + ex.ToString());
return(null);
}
}
private DataTable SEL_DATA_OSD_POP1(string ARG_TYPE, string ARG_FROM)
{
System.Data.DataSet retDS;
COM.OraDB MyOraDB = new COM.OraDB();
MyOraDB.ReDim_Parameter(12);
MyOraDB.Process_Name = "MES.SP_GMES0280_POP";
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] = (int)OracleType.Cursor;
MyOraDB.Parameter_Name[0] = "V_P_TYPE";
MyOraDB.Parameter_Name[1] = "V_P_DATE";
MyOraDB.Parameter_Name[2] = "V_P_PLANT";
MyOraDB.Parameter_Name[3] = "V_P_PROCESS";
MyOraDB.Parameter_Name[4] = "V_P_ERROR_CODE";
MyOraDB.Parameter_Name[5] = "V_P_ROW_COUNT";
MyOraDB.Parameter_Name[6] = "V_P_ERROR_NOTE";
MyOraDB.Parameter_Name[7] = "V_P_RETURN_STR";
MyOraDB.Parameter_Name[8] = "V_P_ERROR_STR";
MyOraDB.Parameter_Name[9] = "V_ERRORSTATE";
MyOraDB.Parameter_Name[10] = "V_ERRORPROCEDURE";
MyOraDB.Parameter_Name[11] = "CV_1";
MyOraDB.Parameter_Values[0] = ARG_TYPE;
MyOraDB.Parameter_Values[1] = ARG_FROM.Replace(",", "").Replace("'", "");
MyOraDB.Parameter_Values[2] = ComVar.Var._strValue1;
MyOraDB.Parameter_Values[3] = "ALL";
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.Parameter_Values[11] = "";
MyOraDB.Add_Select_Parameter(true);
retDS = MyOraDB.Exe_Select_Procedure();
if (retDS == null)
{
return(null);
}
return(retDS.Tables[MyOraDB.Process_Name]);
}
private System.Data.DataSet Select_Ora_Grid()
{
try
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
string process_name = "MES.SP_TMS_LT_POP_SHORT";
//ARGMODE
MyOraDB.ReDim_Parameter(7);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "V_P_LINE";
MyOraDB.Parameter_Name[1] = "V_P_MLINE";
MyOraDB.Parameter_Name[2] = "V_P_YMD";
MyOraDB.Parameter_Name[3] = "V_P_TRIP";
MyOraDB.Parameter_Name[4] = "V_P_STYLE_CD";
MyOraDB.Parameter_Name[5] = "V_P_LOCATION";
// MyOraDB.Parameter_Name[4] = "V_P_CMP_CD";
MyOraDB.Parameter_Name[6] = "CV_1";
// MyOraDB.Parameter_Name[3] = "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[4] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[6] = (char)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = v_LINE_CD;
MyOraDB.Parameter_Values[1] = v_MLINE_CD;
MyOraDB.Parameter_Values[2] = v_date;
MyOraDB.Parameter_Values[3] = v_Trip;
MyOraDB.Parameter_Values[4] = v_STYLE_CD;
MyOraDB.Parameter_Values[5] = v_p_location;
// MyOraDB.Parameter_Values[4] = v_CMP_CD_IN;
MyOraDB.Parameter_Values[6] = "";
// MyOraDB.Parameter_Values[3] = "";
MyOraDB.Add_Select_Parameter(true);
ds_ret = MyOraDB.Exe_Select_Procedure();
if (ds_ret == null)
{
return(null);
}
return(ds_ret);
}
catch
{
return(null);
}
}
public async Task <DataTable> Fn_SelectDataGrid(string argType, string argPlan, string argLine, string argFromDate, string argToDate)
{
return(await Task.Run(() => {
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
MyOraDB.ShowErr = true;
try
{
string process_name = "SEPHIROTH.PKG_SMT_QUALITY_COCKPIT_02.NPI_DATA_SELECT";
MyOraDB.ReDim_Parameter(7);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "V_P_TYPE";
MyOraDB.Parameter_Name[1] = "V_P_FACTORY";
MyOraDB.Parameter_Name[2] = "V_P_PLANT";
MyOraDB.Parameter_Name[3] = "V_P_MLINE";
MyOraDB.Parameter_Name[4] = "V_P_FROM";
MyOraDB.Parameter_Name[5] = "V_P_TO";
MyOraDB.Parameter_Name[6] = "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.Cursor;
MyOraDB.Parameter_Values[0] = argType;
MyOraDB.Parameter_Values[1] = "2110";
MyOraDB.Parameter_Values[2] = argPlan;
MyOraDB.Parameter_Values[3] = argLine;
MyOraDB.Parameter_Values[4] = argFromDate;
MyOraDB.Parameter_Values[5] = argToDate;
MyOraDB.Parameter_Values[6] = "";
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)
{
Debug.WriteLine(ex);
return null;
}
}));
}
