//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 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 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);
}
// 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);
}
//INERT DATA
//single data insert
public static string Insert_Data(string SYSTEM_ID, string USER_NOTES, string MAIL_ADS, string IS_SEND, string IS_MODIFY, string IS_CC, string Name, ref string _Msg)
{
sql = " INSERT INTO EDA.DBO.Daily_Yield_OOC_MAIL_fortest ";
sql += "(SYSTEM_ID,USER_NOTES ,MAIL_ADS ,IS_SEND ,IS_MODIFY ,IS_CC ,Name) VALUES ";
sql += "('" + SYSTEM_ID + "','" + USER_NOTES + "','" + MAIL_ADS + "','" + IS_SEND + "'";
sql += ",'" + IS_MODIFY + "','" + IS_CC + "','" + Name + "')";
sql += " ;";
lisSQL.Clear();
lisSQL.Add(sql);
sql_temp = sql;
_Msg = "";
SQLCheck.ExSql(lisSQL, ref _Msg);
return(_Msg);
}
//單筆資料刪除
public static string Del_Data(string SYSTEM_ID, string MAIL_ADS, string USER_NOTES, ref string _Msg)
{
sql = " DELETE FROM EDA.dbo.Daily_Yield_OOC_MAIL_fortest";
sql += " WHERE SYSTEM_ID='" + SYSTEM_ID + "'";
sql += " AND (MAIL_ADS ='" + MAIL_ADS + "'";
sql += " OR USER_NOTES ='" + USER_NOTES + "')";
sql += " ;";
lisSQL.Clear();
lisSQL.Add(sql);
sql_temp = sql;
_Msg = "";
SQLCheck.ExSql(lisSQL, ref _Msg);
if (_Msg != "")
{
return(_Msg);
}
return(_Msg);
}
//上傳資料
public static string Upload_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 EDA.dbo.Daily_CriticalItem_OOC_Monitor_Main_BU_Rename VALUES (";
sql += " '" + Customer_ID + "'";
sql += " , '" + Category + "'";
sql += " , '" + Part + "'";
sql += " , '" + Part_Id + "'";
sql += " , '" + Yield_Impact_Item + "'";
sql += " , '" + Key_Module + "'";
sql += " , '" + Data_Source + "'";
sql += " , '" + Critical_Item + "'";
sql += " , '" + EDA_Item + "'";
sql += " , '" + 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','UPLOAD','" + lisSQL[0].Replace("'", "''") + "','" + man + "','" + Groceries.Get_Now() + "')";
lisSQL.Clear();
lisSQL.Add(sql);
_Msg = "";
SQLCheck.ExSql(lisSQL, ref _Msg);
return(_Msg);
}
