private DataTable TMS_HOME_OUTGOING_SHORTAGE_SELECT(string ARG_TYPE, string ARG_FACTORY, string ARG_PROC_CD, string ARG_IS_BOTTOM)
{
try
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
string process_name = "MES.PKG_TMS_PREFIT.TMS_HOME_OUTGOING_SHORTAGE";
MyOraDB.ReDim_Parameter(5);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_TYPE";
MyOraDB.Parameter_Name[1] = "ARG_FACTORY";
MyOraDB.Parameter_Name[2] = "ARG_PROC_CD";
MyOraDB.Parameter_Name[3] = "ARG_IS_BOTTOM";
MyOraDB.Parameter_Name[4] = "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.Cursor;
MyOraDB.Parameter_Values[0] = ARG_TYPE;
MyOraDB.Parameter_Values[1] = ARG_FACTORY;
MyOraDB.Parameter_Values[2] = ARG_PROC_CD;
MyOraDB.Parameter_Values[3] = ARG_IS_BOTTOM;
MyOraDB.Parameter_Values[4] = "";
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_OS_PROD_MONTH(string ARG_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_OS_PROD_MONTH_V2";
MyOraDB.ReDim_Parameter(4);
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_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_YMD;
MyOraDB.Parameter_Values[2] = ARG_OP;
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 SMT_EMD_BTS_MONTHLY_SELECT(string ARG_TYPE, 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_MGL_VJ2.MGL_BTS_MONTH_SUPPORT";
MyOraDB.ReDim_Parameter(5);
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] = "ARG_DATE";
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] = ARG_TYPE;
MyOraDB.Parameter_Values[1] = ARG_LINE_CD;
MyOraDB.Parameter_Values[2] = ARG_MLINE_CD;
MyOraDB.Parameter_Values[3] = ARG_DATE;
MyOraDB.Parameter_Values[4] = "";
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 TMS_HOME_RATIO_SELECT(string ARG_TYPE, string ARG_YMD, string ARG_PLANT)
{
try
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
string process_name = "MES.PKG_TMS_PREFIT.TMS_HOME_RATIO";
MyOraDB.ReDim_Parameter(5);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_TYPE";
MyOraDB.Parameter_Name[1] = "ARG_YMD";
MyOraDB.Parameter_Name[2] = "ARG_PLANT";
MyOraDB.Parameter_Name[3] = "OUT_CURSOR1";
MyOraDB.Parameter_Name[4] = "OUT_CURSOR2";
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_Values[0] = ARG_TYPE;
MyOraDB.Parameter_Values[1] = ARG_YMD;
MyOraDB.Parameter_Values[2] = ARG_PLANT;
MyOraDB.Parameter_Values[3] = "";
MyOraDB.Parameter_Values[4] = "";
MyOraDB.Add_Select_Parameter(true);
ds_ret = MyOraDB.Exe_Select_Procedure();
if (ds_ret == null)
{
return(null);
}
return(ds_ret);
}
catch (Exception ex)
{
return(null);
}
}
public DataTable LOAD_COMBO_V2(string type, string plant, string line)
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
try
{
string process_name = "SEPHIROTH.PKG_SMT_QUALITY_COCKPIT_04.SP_SET_COMBO";
MyOraDB.ReDim_Parameter(4);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "V_P_TYPE";
MyOraDB.Parameter_Name[1] = "V_P_PLANT";
MyOraDB.Parameter_Name[2] = "V_P_LINE";
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] = type;
MyOraDB.Parameter_Values[1] = plant;
MyOraDB.Parameter_Values[2] = line;
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 DataSet Data_Select(string argType)
{
COM.OraDB MyOraDB = new COM.OraDB();
MyOraDB.ReDim_Parameter(7);
MyOraDB.Process_Name = "SEPHIROTH.PKG_SMT_QUALITY_COCKPIT_04.SP_GET_INTERNAL_OSD";//
MyOraDB.Parameter_Name[0] = "V_P_TYPE";
MyOraDB.Parameter_Name[1] = "V_P_DATEF";
MyOraDB.Parameter_Name[2] = "V_P_DATET";
MyOraDB.Parameter_Name[3] = "V_P_PLANT";
MyOraDB.Parameter_Name[4] = "V_P_LINE";
MyOraDB.Parameter_Name[5] = "OUT_CURSOR";
MyOraDB.Parameter_Name[6] = "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.VarChar;
MyOraDB.Parameter_Type[5] = (int)OracleType.Cursor;
MyOraDB.Parameter_Type[6] = (int)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = argType;
MyOraDB.Parameter_Values[1] = _date;
MyOraDB.Parameter_Values[2] = "";
MyOraDB.Parameter_Values[3] = _plant_code; //
MyOraDB.Parameter_Values[4] = _line_code; //cbo_line.SelectedValue == null ? "" : cbo_line.SelectedValue.ToString();
MyOraDB.Parameter_Values[5] = "";
MyOraDB.Parameter_Values[6] = "";
MyOraDB.Add_Select_Parameter(true);
DataSet retDS = MyOraDB.Exe_Select_Procedure();
if (retDS == null)
{
return(null);
}
return(retDS);
}
/// <summary>
/// get dữ liệu Init của form như Title, gọi form
/// </summary>
/// <param name="dll_name">dll name của FORM</param>
/// <param name="class_name"> class Name của form</param>
/// <returns> trả về kiểu từ điển Dictinary</returns>
public static Dictionary <string, string> getInitForm(string dll_name, string class_name)
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
DataTable dt;
Dictionary <string, string> dtn = null;
string process_name = "SEPHIROTH.PROC_STB_GET_FORM_INIT";
MyOraDB.ReDim_Parameter(3);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_DLL_NM";
MyOraDB.Parameter_Name[1] = "ARG_CLASS_NM";
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] = dll_name;
MyOraDB.Parameter_Values[1] = class_name;
MyOraDB.Parameter_Values[2] = "";
MyOraDB.Add_Select_Parameter(true);
ds_ret = MyOraDB.Exe_Select_Procedure();
if (ds_ret != null)
{
dt = ds_ret.Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
dtn = new Dictionary <string, string>();
for (int i = 0; i < dt.Rows.Count; i++)
{
dtn.Add(dt.Rows[i]["COM_NM"].ToString(), dt.Rows[i]["COM_VL"].ToString());
}
}
}
return(dtn);
}
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_VC";
//ARGMODE
MyOraDB.ReDim_Parameter(3);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "V_P_LINE";
MyOraDB.Parameter_Name[1] = "V_P_YMD";
MyOraDB.Parameter_Name[2] = "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[2] = (char)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = "001";
MyOraDB.Parameter_Values[1] = cbdate.DateTime.ToString("yyyyMMdd");
MyOraDB.Parameter_Values[2] = "";
// 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);
}
}
private DataTable SEL_DATA_OSD(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_OSD_DATA";
// 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] = "P_TYPE";
MyOraDB.Parameter_Name[1] = "P_FROM";
MyOraDB.Parameter_Name[2] = "P_TO";
MyOraDB.Parameter_Name[3] = "P_PLANT";
MyOraDB.Parameter_Name[4] = "P_PROCESS";
MyOraDB.Parameter_Name[5] = "CV_1";
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 DataSet SEL_LAYOUT()
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
try
{
string process_name = "PKG_SPB_MOLD_WMS_V2.SEL_MOLD_LAYOUT_DETAIL";
MyOraDB.ReDim_Parameter(3);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_TYPE";
MyOraDB.Parameter_Name[1] = "OUT_CURSOR";
MyOraDB.Parameter_Name[2] = "OUT_CURSOR2";
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] = "";
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 SEL_DATA_TALLY_SHEET(string QTYPE, string OP_CD, string MOLD, string MC_F, string MC_T)
{
System.Data.DataSet retDS;
COM.OraDB MyOraDB = new COM.OraDB();
MyOraDB.ReDim_Parameter(6);
MyOraDB.Process_Name = "MES.PKG_SMT_B1.SP_PH_TALLY_SHEET";
// 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;
MyOraDB.Parameter_Name[0] = "V_P_TYPE";
MyOraDB.Parameter_Name[1] = "V_P_OP";
MyOraDB.Parameter_Name[2] = "V_P_MOLD";
MyOraDB.Parameter_Name[3] = "V_P_MC_F";
MyOraDB.Parameter_Name[4] = "V_P_MC_T";
MyOraDB.Parameter_Name[5] = "OUT_CURSOR";
MyOraDB.Parameter_Values[0] = QTYPE;
MyOraDB.Parameter_Values[1] = OP_CD;
MyOraDB.Parameter_Values[2] = MOLD;
MyOraDB.Parameter_Values[3] = MC_F;
MyOraDB.Parameter_Values[4] = MC_T;
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]);
}
private DataTable LOAD_DATA(string arg_cmd)
{
try
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
string process_name = "MES.PKG_MGL_VJ2.SEL_LEAD_TIME_DETAIL";
//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_Name[1] = "ARG_CMD";
MyOraDB.Parameter_Type[0] = (char)OracleType.VarChar;
//MyOraDB.Parameter_Type[1] = (char)OracleType.VarChar;
MyOraDB.Parameter_Type[2] = (char)OracleType.Cursor;
MyOraDB.Parameter_Type[1] = (char)OracleType.VarChar;
MyOraDB.Parameter_Values[0] = _wh_cd;
//MyOraDB.Parameter_Values[1] = _mline_cd;
MyOraDB.Parameter_Values[2] = "";
MyOraDB.Parameter_Values[1] = arg_cmd;
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_Gauge()
{
try
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
string process_name = "MES.PKG_TMS.TMS_SEQ_SUM_SEL";
//ARGMODE
MyOraDB.ReDim_Parameter(4);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_DATE";
MyOraDB.Parameter_Name[1] = "ARG_LINE";
MyOraDB.Parameter_Name[2] = "ARG_SEQ";
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] = DateTime.Now.ToString("yyyyMMdd");
MyOraDB.Parameter_Values[1] = "014";
MyOraDB.Parameter_Values[2] = "1";
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 SEL_SMT_ISB_PREDICTION_CHART(string ARG_LINE_CD, string ARG_MLINE_CD)
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
try
{
string process_name = "MES.PKG_MGL_VJ2.SP_SMT_ISB_PREDICTION"; //2020-09-18
MyOraDB.ReDim_Parameter(3);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_LINE_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] = (int)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = ARG_LINE_CD;
MyOraDB.Parameter_Values[1] = ARG_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);
}
}
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);
}
}
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);
}
}
private DataTable SELECT_DATA_IP(string ARG_QTYPE, string ARG_DATE)
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
try
{
string process_name = "MES.PKG_SMT_B1_PHUOC.IP_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 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);
}
}
private DataTable Select_VC_LT_Ora_Grid_Realtime()
{
try
{
COM.OraDB MyOraDB = new COM.OraDB();
System.Data.DataSet ds_ret;
string process_name = "MES.PKG_TMS_VC_TO_LT.SP_TMS_REAL_TIME";
//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.Tables[0]);
}
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);
}
}
/// <summary>
/// Load picture PIC of Line
/// </summary>
///
public DataTable SEL_IMG(string argType)
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
try
{
string process_name = "SEPHIROTH.PROC_STB_GET_IMG";
MyOraDB.ReDim_Parameter(4);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_CLASS_NM";
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] = this.GetType().Name;
MyOraDB.Parameter_Values[1] = argType;
MyOraDB.Parameter_Values[2] = "";
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 (Exception ex)
{
ComVar.Var.writeToLog(this.GetType().Name + "-->DB-->SEL_MODEL_NAME -->Err: " + ex.ToString());
return null;
}
}
// production / plant
private DataTable SEL_PROD_MDI(string ARG_LINE_CD, string ARG_MLINE_CD)
{
COM.OraDB MyOraDB = new COM.OraDB();
DataSet ds_ret;
try
{
string process_name = "MES.PKG_SMT_VJ3.SP_SMT_PROD_MDI";
MyOraDB.ReDim_Parameter(3);
MyOraDB.Process_Name = process_name;
MyOraDB.Parameter_Name[0] = "ARG_LINE_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] = (int)OracleType.Cursor;
MyOraDB.Parameter_Values[0] = ARG_LINE_CD;
MyOraDB.Parameter_Values[1] = ARG_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);
}
}
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 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_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);
}
}
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 Boolean INSERT_FRM_LOG(string ARG_PGM_CD, string ARG_PGM_NM, string ARG_FRM_CD, string ARG_FRM_NM, string ARG_REMARK, string ARG_UPD_USER)
{
System.Data.DataSet retDS;
COM.OraDB MyOraDB = new COM.OraDB();
MyOraDB.ReDim_Parameter(6);
MyOraDB.Process_Name = "MES.PKG_SMT_B1_PHUOC.SAVE_FRM_LOG";
MyOraDB.Parameter_Name[0] = "ARG_PGM_CD";
MyOraDB.Parameter_Name[1] = "ARG_PGM_NM";
MyOraDB.Parameter_Name[2] = "ARG_FRM_CD";
MyOraDB.Parameter_Name[3] = "ARG_FRM_NM";
MyOraDB.Parameter_Name[4] = "ARG_REMARK";
MyOraDB.Parameter_Name[5] = "ARG_UPD_USER";
for (int i = 0; i <= 5; i++)
{
MyOraDB.Parameter_Type[i] = (char)OracleType.VarChar;
}
MyOraDB.Parameter_Values[0] = ARG_PGM_CD;
MyOraDB.Parameter_Values[1] = ARG_PGM_NM;
MyOraDB.Parameter_Values[2] = ARG_FRM_CD;
MyOraDB.Parameter_Values[3] = ARG_FRM_NM;
MyOraDB.Parameter_Values[4] = ARG_REMARK;
MyOraDB.Parameter_Values[5] = ARG_UPD_USER;
MyOraDB.Add_Modify_Parameter(true);
retDS = MyOraDB.Exe_Modify_Procedure();
if (retDS == null)
{
return(false);
}
return(true);
}
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);
}
}
//=======================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;
}
}
private Boolean UPDATE_STAND_VALUE(string ARG_QTYPE, string ARG_MIN, string ARG_MAX, string ARG_LINE_CD, string ARG_GRP, string ARG_CON_CD)
{
System.Data.DataSet retDS;
COM.OraDB MyOraDB = new COM.OraDB();
MyOraDB.ReDim_Parameter(6);
MyOraDB.Process_Name = "MES.PKG_SMT_TRI.UPDATE_LEADTIME_STAND";
MyOraDB.Parameter_Name[0] = "ARG_QTYPE";
MyOraDB.Parameter_Name[1] = "ARG_MIN";
MyOraDB.Parameter_Name[2] = "ARG_MAX";
MyOraDB.Parameter_Name[3] = "ARG_LINE_CD";
MyOraDB.Parameter_Name[4] = "ARG_GRP";
MyOraDB.Parameter_Name[5] = "ARG_CON_CD";
for (int i = 0; i <= 5; i++)
{
MyOraDB.Parameter_Type[i] = (char)OracleType.VarChar;
}
MyOraDB.Parameter_Values[0] = ARG_QTYPE;
MyOraDB.Parameter_Values[1] = ARG_MIN;
MyOraDB.Parameter_Values[2] = ARG_MAX;
MyOraDB.Parameter_Values[3] = ARG_LINE_CD;
MyOraDB.Parameter_Values[4] = ARG_GRP;
MyOraDB.Parameter_Values[5] = ARG_CON_CD;
MyOraDB.Add_Modify_Parameter(true);
retDS = MyOraDB.Exe_Modify_Procedure();
if (retDS == null)
{
return(false);
}
return(true);
}
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);
}
}
