public static DataTable QueryUser() { sql = "select ISNULL(MAX(ID), 0) AS MaxX from EDA.dbo.Daily_CriticalItem_OOC_Monitor_Main_BU_Rename;"; _msg = ""; dt = SQLCheck.GetDTable(connStr, sql, ref _msg); return(dt); }
public static DataTable Query_Data() { sql = " SELECT ID,Customer_ID,Category,Part,Part_Id,Yield_Impact_Item,Key_Module,Data_Source,Critical_Item,EDA_Item,MAIN_ID"; sql += " FROM EDA.dbo.Daily_CriticalItem_OOC_Monitor_Main_BU_Rename"; sql += " WHERE 1 = 1 ORDER BY ID;"; _msg = ""; dt = SQLCheck.GetDTable(connStr, sql, ref _msg); return(dt); }
public static DataTable Query_Data(string SYSTEM_ID, ref string _Msg) { sql = " SELECT SYSTEM_ID,USER_NOTES,MAIL_ADS,IS_SEND,IS_MODIFY,IS_CC,Name"; sql += " FROM EDA.dbo.Daily_Yield_OOC_MAIL_fortest"; sql += " WHERE SYSTEM_ID='" + SYSTEM_ID + "'"; sql += " AND 1 = 1"; _msg = "ORDER BY ID;"; dt = SQLCheck.GetDTable(connStr, sql, ref _msg); return(dt); }
public static string Signcount(string Category, string Part_Id, string EDA_Item, ref string _Msg) { sql = " SELECT count(*) counts FROM EDA.dbo.Daily_CriticalItem_OOC_Monitor_Main_BU_Rename "; sql += "WHERE Category = '" + Category + "'" + "or Part_Id = " + "'" + Part_Id + "'" + "or EDA_Item = " + "'" + EDA_Item + "'"; sql += " ;"; lisSQL.Clear(); lisSQL.Add(sql); sql_temp = sql; _Msg = ""; dt = SQLCheck.GetDTable(connStr, sql, ref _msg); return(dt.Rows[0][0].ToString()); }
//查詢筆數 public static string Count(string SYSTEM_ID, string USER_NOTES, string MAIL_ADS, ref string _Msg) { sql = " SELECT count(*) counts FROM EDA.dbo.Daily_Yield_OOC_MAIL_fortest "; sql += "WHERE SYSTEM_ID = '" + SYSTEM_ID + "'" + " AND ( USER_NOTES = " + "'" + USER_NOTES + "'" + "OR MAIL_ADS = " + "'" + MAIL_ADS + "')"; sql += " ;"; lisSQL.Clear(); lisSQL.Add(sql); sql_temp = sql; _Msg = ""; dt = SQLCheck.GetDTable(connStr, sql, ref _msg); return(dt.Rows[0][0].ToString()); }