private bool Write_LogDB(DataRow dr, string ArgStatus, string ArgLog) { try { System.Data.DataSet retDS; COM.OraDB MyOraDB = new COM.OraDB(); MyOraDB.ReDim_Parameter(6); MyOraDB.Process_Name = "MES.PKG_SMT_POSTECH.SAVE_LOG"; MyOraDB.Parameter_Name[0] = "ARG_DB_NAME"; MyOraDB.Parameter_Name[1] = "ARG_PROC_NAME"; MyOraDB.Parameter_Name[2] = "ARG_SEQ"; MyOraDB.Parameter_Name[3] = "ARG_STATUS"; MyOraDB.Parameter_Name[4] = "ARG_LOG_RUN"; MyOraDB.Parameter_Name[5] = "UPD_USER"; for (int i = 0; i < MyOraDB.Parameter_Name.Length; i++) { MyOraDB.Parameter_Type[i] = (char)OracleType.VarChar; } MyOraDB.Parameter_Values[0] = dr["DB_NAME"].ToString(); MyOraDB.Parameter_Values[1] = dr["PROC_NAME"].ToString(); MyOraDB.Parameter_Values[2] = dr["SEQ"].ToString(); MyOraDB.Parameter_Values[3] = ArgStatus; MyOraDB.Parameter_Values[4] = ArgLog; MyOraDB.Parameter_Values[5] = _strIP + "|" + _strUser; MyOraDB.Add_Modify_Parameter(true); retDS = MyOraDB.Exe_Modify_Procedure(); if (retDS == null) { return(false); } return(true); } catch (Exception ex) { MessageBox.Show(ex.ToString()); return(false); } }
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); }
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 bool EXE_INPUT_DELETE(string ARG_TYPE, string ARG_FACTORY, string ARG_PLANT, string ARG_LINE, string ARG_MLINE, string ARG_YMD, string ARG_PROC, string ARG_STYLE, string ARG_RESOURCE, string ARG_HOUR, string ARG_PART, string ARG_SIZE) { try { COM.OraDB MyOraDB = new COM.OraDB(); System.Data.DataSet ds_ret; string process_name = "SEPHIROTH.P_CUTTING_MANUAL_INPUT"; MyOraDB.ReDim_Parameter(13); MyOraDB.Process_Name = process_name; MyOraDB.Parameter_Name[0] = "ARG_TYPE"; MyOraDB.Parameter_Name[1] = "ARG_FACTORY"; MyOraDB.Parameter_Name[2] = "ARG_PLANT"; MyOraDB.Parameter_Name[3] = "ARG_LINE"; MyOraDB.Parameter_Name[4] = "ARG_MLINE"; MyOraDB.Parameter_Name[5] = "ARG_YMD"; MyOraDB.Parameter_Name[6] = "ARG_PROC"; MyOraDB.Parameter_Name[7] = "ARG_STYLE"; MyOraDB.Parameter_Name[8] = "ARG_RESOURCE"; MyOraDB.Parameter_Name[9] = "ARG_HOUR"; MyOraDB.Parameter_Name[10] = "ARG_PART"; MyOraDB.Parameter_Name[11] = "ARG_SIZE"; MyOraDB.Parameter_Name[12] = "ARG_USER"; 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.VarChar; MyOraDB.Parameter_Type[12] = (char)OracleType.VarChar; MyOraDB.Parameter_Values[0] = ARG_TYPE; MyOraDB.Parameter_Values[1] = ARG_FACTORY; MyOraDB.Parameter_Values[2] = ARG_PLANT; MyOraDB.Parameter_Values[3] = ARG_LINE; MyOraDB.Parameter_Values[4] = ARG_MLINE; MyOraDB.Parameter_Values[5] = ARG_YMD; MyOraDB.Parameter_Values[6] = ARG_PROC; MyOraDB.Parameter_Values[7] = ARG_STYLE; MyOraDB.Parameter_Values[8] = ARG_RESOURCE; MyOraDB.Parameter_Values[9] = ARG_HOUR; MyOraDB.Parameter_Values[10] = ARG_PART; MyOraDB.Parameter_Values[11] = ARG_SIZE; MyOraDB.Parameter_Values[12] = Environment.MachineName; MyOraDB.Add_Modify_Parameter(true); ds_ret = MyOraDB.Exe_Modify_Procedure(); if (ds_ret == null) { return(false); } return(true); } catch { return(false); } }