public System.Data.DataTable GetRealTimeNewData()
{
string sql1 = "create table nt as " +
"select ttt.STCD,ttt.ItemID, ttt.TM,YY_DATA_AUTO.DOWNDATE, YY_DATA_AUTO.NFOINDEX, YY_DATA_AUTO.CorrectionVALUE,YY_DATA_AUTO.DATAVALUE,YY_DATA_AUTO.DATATYPE " +
"from (SELECT STCD, ItemID, MAX(TM) AS TM FROM YY_DATA_AUTO GROUP BY STCD, ItemID) ttt LEFT OUTER JOIN YY_DATA_AUTO ON ttt.STCD = YY_DATA_AUTO.STCD AND ttt.ItemID = YY_DATA_AUTO.ItemID ";
string sql2 = "SELECT YY_RTU_Basic.STCD, nt.ItemID, nt.TM, nt.DOWNDATE, nt.NFOINDEX,nt.CorrectionVALUE, nt.DATATYPE,YY_RTU_Basic.NiceName, YY_RTU_ITEM.ItemName, YY_RTU_ITEM.ItemDecimal " +
"FROM nt " +
"LEFT OUTER JOIN YY_RTU_ITEM ON nt.ItemID = YY_RTU_ITEM.ItemID RIGHT OUTER JOIN YY_RTU_Basic ON nt.STCD = YY_RTU_Basic.STCD " +
"order by YY_RTU_Basic.STCD,nt.ItemID ";
string sql3 = "drop table nt";
dt.ExecSql(sql1);
System.Data.DataTable datatable = dt.Select(sql2);
dt.ExecSql(sql3);
return(datatable);
}
