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