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