/// <summary>
/// Method to retrieve orders information
/// </summary>
/// <returns>All orders</returns>
public List <OrderInfo> GetOrders()
{
List <OrderInfo> orders = new List <OrderInfo>();
try {
//Execute a query to read the orders
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SqlText.SQL_SELECT_ORDER_GETORDERS, null)) {
while (rdr.Read())
{
OrderInfo order = new OrderInfo();
order.LscID = ComUtility.DBNullInt32Handler(rdr["LscID"]);
order.TargetID = ComUtility.DBNullInt32Handler(rdr["TargetID"]);
order.TargetType = ComUtility.DBNullNodeTypeHandler(rdr["TargetType"]);
order.OrderType = ComUtility.DBNullActTypeHandler(rdr["OrderType"]);
order.RelValue1 = ComUtility.DBNullStringHandler(rdr["RelValue1"]);
order.RelValue2 = ComUtility.DBNullStringHandler(rdr["RelValue2"]);
order.RelValue3 = ComUtility.DBNullStringHandler(rdr["RelValue3"]);
order.RelValue4 = ComUtility.DBNullStringHandler(rdr["RelValue4"]);
order.RelValue5 = ComUtility.DBNullStringHandler(rdr["RelValue5"]);
order.UpdateTime = ComUtility.DBNullDateTimeHandler(rdr["UpdateTime"]);
orders.Add(order);
}
}
return(orders);
} catch {
throw;
}
}
/// <summary>
/// Method to get the specified node
/// </summary>
/// <param name="lscId">lscId</param>
/// <param name="nodeId">nodeId</param>
/// <param name="nodeType">nodeType</param>
/// <returns>node information</returns>
public NodeInfo GetNode(int lscId, int nodeId, EnmNodeType nodeType)
{
try {
SqlParameter[] parms = { new SqlParameter("@LscID", SqlDbType.Int),
new SqlParameter("@NodeID", SqlDbType.Int),
new SqlParameter("@NodeType", SqlDbType.Int) };
parms[0].Value = lscId;
parms[1].Value = nodeId;
parms[2].Value = (int)nodeType;
NodeInfo node = null;
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SqlText.SQL_SELECT_NODE_GETNODE, parms)) {
if (rdr.Read())
{
node = new NodeInfo();
node.LscID = ComUtility.DBNullInt32Handler(rdr["LscID"]);
node.NodeID = ComUtility.DBNullInt32Handler(rdr["NodeID"]);
node.NodeType = ComUtility.DBNullNodeTypeHandler(rdr["NodeType"]);
node.Value = ComUtility.DBNullFloatHandler(rdr["Value"]);
node.Status = ComUtility.DBNullStateHandler(rdr["Status"]);
node.DateTime = ComUtility.DBNullDateTimeHandler(rdr["DateTime"]);
node.UpdateTime = ComUtility.DBNullDateTimeHandler(rdr["UpdateTime"]);
}
}
return(node);
} catch {
throw;
}
}
/// <summary>
/// Syn Alarms
/// </summary>
/// <param name="lscId">lscId</param>
/// <param name="connectionString">connectionString</param>
/// <returns>Alarms</returns>
public List <AlarmInfo> SynAlarms(int lscId, string connectionString)
{
try {
SqlParameter[] parms = { new SqlParameter("@LscID", SqlDbType.Int),
new SqlParameter("@AIType", SqlDbType.Int),
new SqlParameter("@DIType", SqlDbType.Int) };
parms[0].Value = lscId;
parms[1].Value = (int)EnmNodeType.Aic;
parms[2].Value = (int)EnmNodeType.Dic;
List <AlarmInfo> alarms = new List <AlarmInfo>();
SqlHelper.TestConnection(connectionString);
using (DataTable dt = SqlHelper.ExecuteTable(connectionString, CommandType.Text, SqlText.SQL_SELECT_ALARM_SYNALARMS, parms)) {
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
AlarmInfo alarm = new AlarmInfo();
alarm.LscID = ComUtility.DBNullInt32Handler(dr["LscID"]);
alarm.SerialNO = ComUtility.DBNullInt32Handler(dr["SerialNO"]);
alarm.Area1Name = ComUtility.DBNullStringHandler(dr["Area1Name"]);
alarm.Area2Name = ComUtility.DBNullStringHandler(dr["Area2Name"]);
alarm.Area3Name = ComUtility.DBNullStringHandler(dr["Area3Name"]);
alarm.Area4Name = ComUtility.DBNullStringHandler(dr["Area4Name"]);
alarm.StaName = ComUtility.DBNullStringHandler(dr["StaName"]);
alarm.DevName = ComUtility.DBNullStringHandler(dr["DevName"]);
alarm.DevDesc = ComUtility.DBNullStringHandler(dr["DevDesc"]);
alarm.NodeID = ComUtility.DBNullInt32Handler(dr["NodeID"]);
alarm.NodeType = ComUtility.DBNullNodeTypeHandler(dr["NodeType"]);
alarm.NodeName = ComUtility.DBNullStringHandler(dr["NodeName"]);
alarm.AlarmID = ComUtility.DBNullInt32Handler(dr["AlarmID"]);
alarm.AlarmValue = ComUtility.DBNullFloatHandler(dr["AlarmValue"]);
alarm.AlarmLevel = ComUtility.DBNullAlarmLevelHandler(dr["AlarmLevel"]);
alarm.AlarmStatus = ComUtility.DBNullAlarmStatusHandler(dr["AlarmStatus"]);
alarm.AlarmDesc = ComUtility.DBNullStringHandler(dr["AlarmDesc"]);
alarm.AuxAlarmDesc = ComUtility.DBNullStringHandler(dr["AuxAlarmDesc"]);
alarm.StartTime = ComUtility.DBNullDateTimeHandler(dr["StartTime"]);
alarm.EndTime = ComUtility.DBNullDateTimeHandler(dr["EndTime"]);
alarm.ConfirmName = ComUtility.DBNullStringHandler(dr["ConfirmName"]);
alarm.ConfirmMarking = ComUtility.DBNullConfirmMarkingHandler(dr["ConfirmMarking"]);
alarm.ConfirmTime = ComUtility.DBNullDateTimeHandler(dr["ConfirmTime"]);
alarm.AuxSet = ComUtility.DBNullStringHandler(dr["AuxSet"]);
alarm.TaskID = ComUtility.DBNullStringHandler(dr["TaskID"]);
alarm.ProjName = ComUtility.DBNullStringHandler(dr["ProjName"]);
alarm.TurnCount = ComUtility.DBNullInt32Handler(dr["TurnCount"]);
alarm.UpdateTime = ComUtility.DBNullDateTimeHandler(dr["UpdateTime"]);
alarms.Add(alarm);
}
SqlHelper.ExecuteBulkCopy(SqlHelper.ConnectionStringLocalTransaction, SqlText.TN_Alarm, dt);
}
}
return(alarms);
} catch {
throw;
}
}
/// <summary>
/// Syn Frequency Alarms
/// </summary>
/// <param name="lscId">lscId</param>
/// <param name="connectionString">connectionString</param>
/// <returns>Frequency Alarms</returns>
public List <FrequencyAlarmInfo> SynFrequencyAlarms(int lscId, string connectionString)
{
SqlParameter[] parms = { new SqlParameter("@LscID", SqlDbType.Int) };
parms[0].Value = lscId;
var alarms = new List <FrequencyAlarmInfo>();
SqlHelper.TestConnection(connectionString);
using (var dt = SqlHelper.ExecuteTable(connectionString, CommandType.Text, SqlText.SQL_SELECT_ALARM_SYNFREQUENCYALARMS, parms)) {
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
var alarm = new FrequencyAlarmInfo();
alarm.LscID = ComUtility.DBNullInt32Handler(dr["LscID"]);
alarm.Area1Name = ComUtility.DBNullStringHandler(dr["Area1Name"]);
alarm.Area2Name = ComUtility.DBNullStringHandler(dr["Area2Name"]);
alarm.Area3Name = ComUtility.DBNullStringHandler(dr["Area3Name"]);
alarm.Area4Name = String.Empty;
alarm.StaName = ComUtility.DBNullStringHandler(dr["StaName"]);
alarm.DevName = ComUtility.DBNullStringHandler(dr["DevName"]);
alarm.NodeID = ComUtility.DBNullInt32Handler(dr["NodeID"]);
alarm.NodeType = ComUtility.DBNullNodeTypeHandler(dr["NodeType"]);
alarm.NodeName = ComUtility.DBNullStringHandler(dr["NodeName"]);
alarm.AlarmStatus = ComUtility.DBNullInt32Handler(dr["AlarmStatus"]);
alarm.AlarmLevel = ComUtility.DBNullInt32Handler(dr["AlarmLevel"]);
alarm.FreAlarmValue = ComUtility.DBNullInt32Handler(dr["FreAlarmValue"]);
alarm.FreRightValue = ComUtility.DBNullInt32Handler(dr["FreRightValue"]);
alarm.FreCompareValue = ComUtility.DBNullInt32Handler(dr["FreCompareValue"]);
alarm.StartTime = ComUtility.DBNullDateTimeHandler(dr["StartTime"]);
alarm.AlarmTime = ComUtility.DBNullDateTimeHandler(dr["AlarmTime"]);
alarm.EventTime = ComUtility.DBNullDateTimeHandler(dr["EventTime"]);
alarm.ConfirmName = ComUtility.DBNullStringHandler(dr["ConfirmName"]);
alarm.ConfirmTime = ComUtility.DBNullDateTimeHandler(dr["ConfirmTime"]);
alarm.EndName = ComUtility.DBNullStringHandler(dr["EndName"]);
alarm.EndTime = ComUtility.DBNullDateTimeHandler(dr["EndTime"]);
alarm.StartIsAddAlarmList = ComUtility.DBNullBooleanHandler(dr["StartIsAddAlarmList"]);
alarm.EndIsAddAlarmList = ComUtility.DBNullBooleanHandler(dr["EndIsAddAlarmList"]);
alarm.ConfirmIsAddAlarmList = ComUtility.DBNullBooleanHandler(dr["ConfirmIsAddAlarmList"]);
alarms.Add(alarm);
}
SqlHelper.ExecuteBulkCopy(SqlHelper.ConnectionStringLocalTransaction, SqlText.TN_FrequencyAlarm, dt);
}
}
return(alarms);
}
