public string GET_LOGICALREF(string TABLENAME, string LOGICALREF, string WHEREFIELDNAME, string WHEREDATA) {
SqlDatabase sqlSERVICEDB;
sqlSERVICEDB = new SqlDatabase(M.CONSTR_BMS);
DataTable DATA = sqlSERVICEDB.ExecuteDataSet(new SqlCommand("SELECT TOP 1 " + LOGICALREF + " FROM " + TABLENAME + " WHERE " + WHEREFIELDNAME + "='" + WHEREDATA + "' ORDER BY LOGICALREF DESC")).Tables[0];
if (DATA.Rows.Count == 0) {
return "";
}
return DATA.Rows[0][0].ToString();
}