public static string DelLog(string USER)
{
sql = "DELETE FROM EDA.DBO.RECORD_STEP_LOG ";
sql += "WHERE DateDiff(Day,Revise_Date,getdate()) >= 180";
_Msg = "";
lisSQL.Clear();
lisSQL.Add(sql);
SQLCheck.ExSql(lisSQL, ref _Msg);
if (_Msg != "")
{
return(_Msg);
}
// STEP LOG
sql = " INSERT INTO EDA.DBO.RECORD_STEP_LOG";
sql += " (TableName, Action, Details, Revisor, Revise_Date)";
sql += " VALUES('RECORD_STEP_LOG','DELETE','" + lisSQL[0].Replace("'", "''") + "','" + USER + "','" + Groceries.Get_Now() + "')";
lisSQL.Clear();
lisSQL.Add(sql);
_Msg = "";
SQLCheck.ExSql(lisSQL, ref _Msg);
return(_Msg);
}
//單筆資料更新
public static string Updata_Data(int ID, string Customer_ID, string Category, string Part, string Yield_Impact_Item, string Key_Module, string Data_Source, string Critical_Item, string MAIN_ID, string man, ref string _Msg)
{
sql = " UPDATE EDA.dbo.Daily_CriticalItem_OOC_Monitor_Main_BU_Rename ";
sql += "SET Customer_ID='" + Customer_ID + "'";
sql += ",Category='" + Category + "'";
sql += ",Part='" + Part + "'";
sql += ",Yield_Impact_Item='" + Yield_Impact_Item + "'";
sql += ",Key_Module='" + Key_Module + "'";
sql += ",Data_Source='" + Data_Source + "'";
sql += ",Critical_Item='" + Critical_Item + "'";
sql += ",MAIN_ID='" + MAIN_ID + "'";
sql += "WHERE ID='" + ID + "'";
sql += " ;";
lisSQL.Clear();
lisSQL.Add(sql);
sql_temp = sql;
_Msg = "";
SQLCheck.ExSql(lisSQL, ref _Msg);
if (_Msg != "")
{
return(_Msg);
}
//STEP LOG
sql = " INSERT INTO EDA.DBO.RECORD_STEP_LOG";
sql += " (TableName, Action, Details, Revisor, Revise_Date)";
sql += " VALUES('Daily_CriticalItem_OOC_Monitor_Main_BU_Rename','UPDATE_ONE','" + lisSQL[0].Replace("'", "''") + "','" + man + "','" + Groceries.Get_Now() + "')";
lisSQL.Clear();
lisSQL.Add(sql);
_Msg = "";
SQLCheck.ExSql(lisSQL, ref _Msg);
return(_Msg);
}
// LOGIN_LOG
public static string Login_log(string man, ref string _Msg)
{
sql = " insert into EDA.DBO.RECORD_STEP_LOG";
sql += " (tablename, action, details, revisor, revise_date)";
sql += " values('Daily_CriticalItem_OOC_Monitor_Main_BU_Rename','LOGIN','" + "','" + man + "','" + Groceries.Get_Now() + "')";
lisSQL.Clear();
lisSQL.Add(sql);
_msg = "";
SQLCheck.ExSql(lisSQL, ref _Msg);
return(_Msg);
}
//single data insert
public static string Insert_Data(int ID, string Customer_ID, string Category, string Part, string Part_Id, string Yield_Impact_Item, string Key_Module, string Data_Source, string Critical_Item, string eda_item, string MAIN_ID, string man, ref string _Msg)
{
sql = " INSERT INTO EDA.DBO.Daily_CriticalItem_OOC_Monitor_Main_BU_Rename ";
sql += "(CUSTOMER_ID,CATEGORY ,PART ,PART_ID ,YIELD_IMPACT_ITEM ,KEY_MODULE ,DATA_SOURCE ,CRITICAL_ITEM ,EDA_ITEM ,MAIN_ID) VALUES ";
sql += "('" + Customer_ID + "','" + Category + "','" + Part + "','" + Part_Id + "','" + Yield_Impact_Item + "'";
sql += ",'" + Key_Module + "','" + Data_Source + "','" + Critical_Item + "','" + eda_item + "','" + MAIN_ID + "')";
sql += " ;";
lisSQL.Clear();
lisSQL.Add(sql);
sql_temp = sql;
_Msg = "";
SQLCheck.ExSql(lisSQL, ref _Msg);
if (_Msg != "")
{
return(_Msg);
}
//STEP LOG
sql = " INSERT INTO EDA.DBO.RECORD_STEP_LOG";
sql += " (TableName, Action, Details, Revisor, Revise_Date)";
sql += " VALUES('Daily_CriticalItem_OOC_Monitor_Main_BU_Rename','INSERT','" + lisSQL[0].Replace("'", "''") + "','" + man + "','" + Groceries.Get_Now() + "')";
lisSQL.Clear();
lisSQL.Add(sql);
_Msg = "";
SQLCheck.ExSql(lisSQL, ref _Msg);
return(_Msg);
}
//單筆資料刪除
public static string Del_Data(int ID, string man, ref string _Msg)
{
sql = " DELETE FROM EDA.dbo.Daily_CriticalItem_OOC_Monitor_Main_BU_Rename ";
sql += "WHERE ID='" + ID + "'";
sql += " ;";
lisSQL.Clear();
lisSQL.Add(sql);
sql_temp = sql;
_Msg = "";
SQLCheck.ExSql(lisSQL, ref _Msg);
if (_Msg != "")
{
return(_Msg);
}
// STEP LOG
sql = " INSERT INTO EDA.DBO.RECORD_STEP_LOG";
sql += " (TableName, Action, Details, Revisor, Revise_Date)";
sql += " VALUES('Daily_CriticalItem_OOC_Monitor_Main_BU_Rename','DEL_ONE','" + lisSQL[0].Replace("'", "''") + "','" + man + "','" + Groceries.Get_Now() + "')";
lisSQL.Clear();
lisSQL.Add(sql);
_Msg = "";
SQLCheck.ExSql(lisSQL, ref _Msg);
return(_Msg);
}
