public static string GetNextCommand(int systemId)
{
SQLParameterList sqlParams = new SQLParameterList();
sqlParams.AddParameter("@systemId", systemId);
return((string)DatabaseManager.ExecuteScalar("spGetCommand", sqlParams).ToString());
}
public static DataSet GetCmdMap(int templateId)
{
SQLParameterList sqlParams = new SQLParameterList();
sqlParams.AddParameter("@templateId", templateId);
return(DatabaseManager.GetDataSet("spGetCmdMap", sqlParams));
}
public static SqlDataReader GetCommandDDLlist(int commandID)
{
SQLParameterList sqlParams = new SQLParameterList();
sqlParams.AddParameter("@commandId", commandID);
return(DatabaseManager.GetDataReader("spGetCmdDDLlist", sqlParams));
}
public static void SaveAuthKey(string ip, string mac, string authKey)
{
SQLParameterList sqlParams = new SQLParameterList();
sqlParams.AddParameter("@ip", ip);
sqlParams.AddParameter("@mac", mac);
sqlParams.AddParameter("@authKey", authKey);
int result = -1;
DatabaseManager.ExecuteScalar("spLogAuthKey", sqlParams);
}
internal static void SaveCommandQ(string cmd, string status,
DateTime executeTime, int systemId)
{
SQLParameterList sqlParams = new SQLParameterList();
sqlParams.AddParameter("@cmd", cmd.Trim());
sqlParams.AddParameter("@status", status);
sqlParams.AddParameter("@executeTime", executeTime);
sqlParams.AddParameter("@systemid", systemId);
int result = -1;
DatabaseManager.ExecuteNonQuery("spAddCommandQ", sqlParams);
}
public static bool CheckSystemExists(string ip, string mac)
{
SQLParameterList sqlParams = new SQLParameterList();
sqlParams.AddParameter("@ip", ip);
sqlParams.AddParameter("@mac", mac);
bool rtn = false;
int result = -1;
result = (int)DatabaseManager.ExecuteScalar("spCheckSystem", sqlParams);
if (result > 0)
{
rtn = true;
}
else
{
rtn = false;
}
return(rtn);
}
