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