public DataTable SEL_OS_LEAD_TIME(string arg_wh)
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
try
{
string process_name = "MES.PKG_SMT_B_LEADTIME.SEL_LEAD_TIME_BY_DAY";
MyOraDB.ReDim_Parameter(3);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_OP_CD";
MyOraDB.Parameter_Name[1] = "ARG_TYPE";
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] = arg_wh;
MyOraDB.Parameter_Values[1] = "Q";
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);
}
}
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_PH_HR_ABSENT";
MyOraDB.ReDim_Parameter(3);
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_Type[0] = (int)OracleType.VarChar;
MyOraDB.Parameter_Type[1] = (int)OracleType.Cursor;
MyOraDB.Parameter_Type[2] = (int)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = argWH;
MyOraDB.Parameter_Values[1] = "";
MyOraDB.Parameter_Values[2] = "";
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 SELECT_DATA(string ARG_QTYPE, string ARG_DATE)
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
try
{
string process_name = "MES.PKG_SMT_B1_PHUOC.OS_OEE_SELECT";
MyOraDB.ReDim_Parameter(3);
MyOraDB.Process_Name = process_name;
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] = ARG_QTYPE;
MyOraDB.Parameter_Values[1] = ARG_DATE;
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);
}
}
private DataTable Select_qty_Trip()
{
try
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
string process_name = "MES.SP_TMS_LT_TOTAL_TRIP";
//ARGMODE
MyOraDB.ReDim_Parameter(3);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "V_P_YMD";
MyOraDB.Parameter_Name[1] = "V_P_LOCATION";
MyOraDB.Parameter_Name[2] = "CV_1";
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] = DateTime.Now.ToString("yyyyMMdd");
MyOraDB.Parameter_Values[1] = "VJ3";
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 SP_MGL_HOME_DATA_SELECT(string V_P_TYPE)
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
try
{
string process_name = "";
if (_type.ToString() == "HR")
{
process_name = "MES.PKG_SMT_MGL_V2.MGL_HOME_HRVJ2_SELECT";
}
else
{
process_name = "MES.PKG_MGL_VJ2.MGL_HOME_DATA_SELECT";
}
MyOraDB.ReDim_Parameter(2);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_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);
}
}
public DataTable SEL_DATA_SLABTEST(string Qtype, string arg_op)
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
try
{
string process_name = "MES.PKG_SMT_ROLL.SP_ROLL_SLABTEST_MONTH"; //SP_SMT_ANDON_DAILY
MyOraDB.ReDim_Parameter(3);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "V_P_TYPE";
MyOraDB.Parameter_Name[1] = "V_P_OP";
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_op;
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);
}
}
private System.Data.DataSet Select_Ora_Grid_Set()
{
try
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
string process_name = "MES.PKG_TMS_VC_TO_LT_V1.SP_TMS_VC_TO_LT_SET";
//ARGMODE
MyOraDB.ReDim_Parameter(2);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "V_P_TYPE";
MyOraDB.Parameter_Name[1] = "CV_1";
MyOraDB.Parameter_Type[0] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[1] = (char)OracleType.Cursor;
// MyOraDB.Parameter_Type[3] = (char)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = "";
MyOraDB.Parameter_Values[1] = "";
// MyOraDB.Parameter_Values[3] = "";
// 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 DataTable SMT_B_PHP_INVENTORY(string V_P_MONTH, string V_P_PROC)
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
try
{
string process_name = "MES.PKG_SMT_B_PRODUCTION.SMT_B_PHP_INVENTORY";
MyOraDB.ReDim_Parameter(3);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "V_P_MONTH";
MyOraDB.Parameter_Name[1] = "V_P_PROC";
MyOraDB.Parameter_Name[2] = "CV_1";
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_MONTH;
MyOraDB.Parameter_Values[1] = V_P_PROC;
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_DATA_PROD_DAILY_2()
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
try
{
string process_name = "MES.PKG_SMT_B1.SEL_PH_PRODUCTION_DAS"; //SP_SMT_ANDON_DAILY
MyOraDB.ReDim_Parameter(3);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "arg_frm_line";
MyOraDB.Parameter_Name[1] = "arg_to_line";
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] = _frmLine;
MyOraDB.Parameter_Values[1] = _toLine;
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_APS_PLAN_ACTUAL()
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
try
{
string process_name = "PKG_SPB_MOLD_WMS.SEL_MOLD_PROD_LAYOUT_V3";
MyOraDB.ReDim_Parameter(3);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_DATE";
MyOraDB.Parameter_Name[1] = "ARG_SHIFT";
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] = dtpDate.DateTime.ToString("yyyyMMdd");
MyOraDB.Parameter_Values[1] = _shift;
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_INVENTORY_SHORTAGE(string ARG_LINE_CD)
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
try
{
string process_name = "MES.PKG_MGL_VJ3.MGL_INVENTORY_DATA_SELECT";
MyOraDB.ReDim_Parameter(3);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_TYPE";
MyOraDB.Parameter_Name[1] = "ARG_LINE_CD";
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] = "Q1";
MyOraDB.Parameter_Values[1] = ARG_LINE_CD;
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);
}
}
private DataTable MGL_I_QSD_DATA_SELECT(string ARG_TYPE, string ARG_FROM, string ARG_TO)
{
System.Data.DataSet retDS;
COM.OraDB MyOraDB = new COM.OraDB();
MyOraDB.ReDim_Parameter(6);
MyOraDB.Process_Name = "MES.PKG_MGL_VJ2.MGL_I_QSD_DATA_SUPPORT";
// for (int i = 0; i < intParm; i++)
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] = (int)OracleType.Cursor;
//V_P_TYPE,V_P_OPTION
MyOraDB.Parameter_Name[0] = "ARG_TYPE";
MyOraDB.Parameter_Name[1] = "ARG_FROM";
MyOraDB.Parameter_Name[2] = "ARG_TO";
MyOraDB.Parameter_Name[3] = "ARG_PLANT";
MyOraDB.Parameter_Name[4] = "ARG_PROCESS";
MyOraDB.Parameter_Name[5] = "OUT_CURSOR";
MyOraDB.Parameter_Values[0] = ARG_TYPE;
MyOraDB.Parameter_Values[1] = ARG_FROM;
MyOraDB.Parameter_Values[2] = ARG_TO;
MyOraDB.Parameter_Values[3] = ComVar.Var._strValue1;
MyOraDB.Parameter_Values[4] = "ALL";
MyOraDB.Parameter_Values[5] = "";
MyOraDB.Add_Select_Parameter(true);
retDS = MyOraDB.Exe_Select_Procedure();
if (retDS == null)
{
return(null);
}
return(retDS.Tables[MyOraDB.Process_Name]);
}
//public async Task<DataSet> sbGetRework(string ARG_QTYPE,string ARG_YMD, string ARG_PLANT, string ARG_LINE)
//{
// return await Task.Run(() => {
// COM.OraDB MyOraDB = new COM.OraDB();
// DataSet ds_ret;
// try
// {
// string process_name = "SEPHIROTH.PKG_SMT_QUALITY_COCKPIT_03.SP_GET_REWORK_POPUP";
// MyOraDB.ReDim_Parameter(6);
// 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_PLANT";
// MyOraDB.Parameter_Name[3] = "V_P_LINE";
// MyOraDB.Parameter_Name[4] = "OUT_CURSOR";
// MyOraDB.Parameter_Name[5] = "OUT_CURSOR2";
// 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] = ARG_QTYPE;
// MyOraDB.Parameter_Values[1] = ARG_YMD;
// MyOraDB.Parameter_Values[2] = ARG_PLANT;
// MyOraDB.Parameter_Values[3] = ARG_LINE;
// 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;
// return ds_ret;
// }
// catch
// {
// return null;
// }
// });
//}
#region DB
private DataSet Data_Select(string argType, string date, string plant, string line)
{
COM.OraDB MyOraDB = new COM.OraDB();
MyOraDB.ReDim_Parameter(5);
MyOraDB.Process_Name = "SEPHIROTH.PKG_SMT_QUALITY_COCKPIT_03.SP_GET_REWORK_POPUP";//
MyOraDB.Parameter_Name[0] = "V_P_TYPE";
MyOraDB.Parameter_Name[1] = "V_P_YMD";
MyOraDB.Parameter_Name[2] = "V_P_PLANT";
MyOraDB.Parameter_Name[3] = "V_P_LINE";
MyOraDB.Parameter_Name[4] = "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.Cursor;
MyOraDB.Parameter_Values[0] = argType;
MyOraDB.Parameter_Values[1] = date;
MyOraDB.Parameter_Values[2] = plant; //
MyOraDB.Parameter_Values[3] = line; //cbo_line.SelectedValue == null ? "" : cbo_line.SelectedValue.ToString();
MyOraDB.Parameter_Values[4] = "";
MyOraDB.Add_Select_Parameter(true);
DataSet retDS = MyOraDB.Exe_Select_Procedure();
if (retDS == null)
{
return(null);
}
return(retDS);
}
public DataTable GetDeliveryDetail(string ARG_FAC, string ARG_YMD, string ARG_LINE_CD)
{
try
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
string process_name = "MES.PKG_TMS_DASHBOARD.TMS_DELIVERY_DETAIL_SET";
MyOraDB.ReDim_Parameter(4);
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_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.Cursor;
MyOraDB.Parameter_Values[0] = ARG_FAC;
MyOraDB.Parameter_Values[1] = ARG_YMD;
MyOraDB.Parameter_Values[2] = ARG_LINE_CD;
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[0]);
}
catch
{
return(null);
}
}
public DataTable SEL_DATA_IMG(string Qtype, string arg_op)
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
try
{
string process_name = "MES.PKG_SMT_PU.GET_IMG";
MyOraDB.ReDim_Parameter(3);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_FORM_NAME";
MyOraDB.Parameter_Name[1] = "ARG_CNTR_NAME";
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] = arg_op;
MyOraDB.Parameter_Values[1] = "";
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 SP_SMT_PROD_DAILY_NEW(string ARG_DATE, string ARG_LINE_CD, string ARG_MLINE_CD)
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
try
{
string process_name = "MES.PKG_SMT_LONGTHANH.SMT_PRODUCTIVITY_DAILY_SELECT";
MyOraDB.ReDim_Parameter(4);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_DATE";
MyOraDB.Parameter_Name[1] = "ARG_LINE_CD";
MyOraDB.Parameter_Name[2] = "ARG_MLINE_CD";
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_DATE;
MyOraDB.Parameter_Values[1] = ARG_LINE_CD;
MyOraDB.Parameter_Values[2] = ARG_MLINE_CD;
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);
}
}
public DataTable SEL_OS_PROD_MONTH(string ARG_QTYPE, string ARG_OP)
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
try
{
string process_name = "MES.PKG_SMT_ROLL.SP_ROLL_PROD_MONTH";
MyOraDB.ReDim_Parameter(3);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "V_P_TYPE";
MyOraDB.Parameter_Name[1] = "V_P_OP";
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] = ARG_QTYPE;
MyOraDB.Parameter_Values[1] = ARG_OP;
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);
}
}
//=======================show hinh clik gauge===============
public DataTable SEL_MODEL_NAME(string ARG_QTYPE, string ARG_LINE_CD, string ARG_MLINE_CD)
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
try
{
string process_name = "MES.PKG_SMT_LT.SP_SMT_TEST";
MyOraDB.ReDim_Parameter(4);
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] = "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_QTYPE;
MyOraDB.Parameter_Values[1] = ARG_LINE_CD;
MyOraDB.Parameter_Values[2] = ARG_MLINE_CD;
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;
}
}
public static DataTable SEL_OS_APS_PLAN_ACTUAL(string arg_wh)
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
try
{
string process_name = "PKG_SPB_MOLD_WMS_V2.SEL_MOLD_APS_ACTUAL";
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);
}
}
public DataTable SEL_GET_FORM(string argGrp)
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
MyOraDB.ShowErr = false;
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 DataTable SEL_APS_PLAN_ACTUAL_PU(string TYPE)
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
try
{
string process_name = "PKG_SPB_MOLD_WMS_V2.SEL_MOLD_PRODUCTION_LAYOUT_PU";
MyOraDB.ReDim_Parameter(2);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_MACHINE_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] = 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);
}
}
public DataSet LOAD_DATA_v3()
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
try
{
string process_name = "SEPHIROTH.PKG_DMC.SEL_PROD_SET_STATUS_DMP_V3";
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);
}
}
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];
}
// 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);
}
}
public DataTable SEL_DMC_DETAIL_BY_CELL(string ARG_LOCATE)
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
try
{
string process_name = "PKG_DMC_AGING_LOCATION.SEL_DMC_DETAIL_BY_CELL";
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);
}
}
private DataTable SP_MGL_PRODUCTION_DATA_SELECT(string V_P_TYPE, string V_P_LINE, string V_P_MLINE)
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
try
{
string process_name = "MES.PKG_MGL_VJ2.MGL_PRODUCTION_DAILY";
MyOraDB.ReDim_Parameter(4);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_TYPE";
MyOraDB.Parameter_Name[1] = "ARG_LINE";
MyOraDB.Parameter_Name[2] = "ARG_MLINE";
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] = V_P_TYPE;
MyOraDB.Parameter_Values[1] = V_P_LINE;
MyOraDB.Parameter_Values[2] = V_P_MLINE;
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);
}
}
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];
}
//private void chartqty(DataTable dt_data, DevExpress.XtraCharts.ChartControl argChart)
//{
// try
// {
// if (dt_data == null || dt_data.Rows.Count <= 0) return;
// DataTable dt = dt_data.Clone();
// dt.Columns["VALUE_CHART"].DataType = typeof(double);
// dt = dt_data.Select("RN = '99' and ORD = '4'").CopyToDataTable();
// argChart.DataSource = dt;
// argChart.Series[0].ArgumentDataMember = "MODEL_NAME";
// argChart.Series[0].ValueDataMembers.AddRange(new string[] { "VALUE_CHART" });
// //argChart.Series[0].Points[0].Color = Color.Green;
// //argChart.Series[0].Points[1].Color = Color.Red;
// }
// catch
// {
// }
//}
#endregion
#region DB
public DataTable SEL_DATA()
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
try
{
string process_name = "PKG_SPB_MODEL_TEMP.SEL_OS_DEFECTIVE";
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] = "";
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 SEL_MODEL_DEF_LIST(string str)
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
try
{
string process_name = "PKG_SPB_MODEL_TEMP." + str;
MyOraDB.ReDim_Parameter(2);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "OUT_CURSOR1";
MyOraDB.Parameter_Name[1] = "OUT_CURSOR2";
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);
}
}
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_CMMS_DAILY";
//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] = (int)OracleType.VarChar;
MyOraDB.Parameter_Type[1] = (int)OracleType.VarChar;
MyOraDB.Parameter_Type[2] = (char)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = _wh_cd;
MyOraDB.Parameter_Values[1] = _mline_cd;
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);
}
}
