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); } }