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