/// <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>
/// Update the reservations
/// </summary>
public void UpdateReservations(IEnumerable <string> ids, bool isSended)
{
using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringLocalTransaction)) {
conn.Open();
SqlTransaction trans = conn.BeginTransaction(IsolationLevel.ReadCommitted);
try {
SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.VarChar, 100),
new SqlParameter("@IsSended", SqlDbType.Bit) };
foreach (var id in ids)
{
parms[0].Value = ComUtility.DBNullString2Checker(id);
parms[1].Value = isSended;
SqlHelper.ExecuteNonQuery(trans, CommandType.Text, SqlText.SQL_SELECT_LSC_UPDATERESERVATION, parms);
}
trans.Commit();
} catch {
trans.Rollback();
throw;
} finally {
conn.Close();
}
}
}
/// <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 Trend Alarms
/// </summary>
/// <param name="lscId">lscId</param>
/// <param name="connectionString">connectionString</param>
/// <returns>Trend Alarms</returns>
public List <TrendAlarmInfo> SynTrendAlarms(int lscId, string connectionString)
{
SqlParameter[] parms = { new SqlParameter("@LscID", SqlDbType.Int) };
parms[0].Value = lscId;
var alarms = new List <TrendAlarmInfo>();
SqlHelper.TestConnection(connectionString);
using (var dt = SqlHelper.ExecuteTable(connectionString, CommandType.Text, SqlText.SQL_SELECT_ALARM_SYNTRENDALARMS, parms)) {
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
var alarm = new TrendAlarmInfo();
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 = EnmNodeType.Aic;
alarm.NodeName = ComUtility.DBNullStringHandler(dr["NodeName"]);
alarm.AlarmType = ComUtility.DBNullStringHandler(dr["AlarmType"]);
alarm.AlarmStatus = ComUtility.DBNullInt32Handler(dr["AlarmStatus"]);
alarm.AlarmLevel = ComUtility.DBNullInt32Handler(dr["AlarmLevel"]);
alarm.StartValue = ComUtility.DBNullFloatHandler(dr["StartValue"]);
alarm.AlarmValue = ComUtility.DBNullFloatHandler(dr["AlarmValue"]);
alarm.DiffValue = ComUtility.DBNullFloatHandler(dr["DiffValue"]);
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_TrendAlarm, dt);
}
}
return(alarms);
}
/// <summary>
/// Method to get lsc information
/// </summary>
/// <returns>lsc information</returns>
public LscInfo GetLsc(int lscId)
{
try {
SqlParameter[] parms = { new SqlParameter("@LscID", SqlDbType.Int) };
parms[0].Value = lscId;
LscInfo lsc = null;
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SqlText.SQL_SELECT_LSC_GETLSC, parms)) {
if (rdr.Read())
{
lsc = new LscInfo();
lsc.LscID = ComUtility.DBNullInt32Handler(rdr["LscID"]);
lsc.LscName = ComUtility.DBNullStringHandler(rdr["LscName"]);
lsc.LscIP = ComUtility.DBNullStringHandler(rdr["LscIP"]);
lsc.LscPort = ComUtility.DBNullInt32Handler(rdr["LscPort"]);
lsc.LscUID = ComUtility.DBNullStringHandler(rdr["LscUID"]);
lsc.LscPwd = ComUtility.DBNullStringHandler(rdr["LscPwd"]);
lsc.BeatInterval = ComUtility.DBNullInt32Handler(rdr["BeatInterval"]);
lsc.BeatDelay = ComUtility.DBNullInt32Handler(rdr["BeatDelay"]);
lsc.DBServer = ComUtility.DBNullStringHandler(rdr["DBServer"]);
lsc.DBPort = ComUtility.DBNullInt32Handler(rdr["DBPort"]);
lsc.DBName = ComUtility.DBNullStringHandler(rdr["DBName"]);
lsc.DBUID = ComUtility.DBNullStringHandler(rdr["DBUID"]);
lsc.DBPwd = ComUtility.DBNullStringHandler(rdr["DBPwd"]);
lsc.HisDBServer = ComUtility.DBNullStringHandler(rdr["HisDBServer"]);
lsc.HisDBPort = ComUtility.DBNullInt32Handler(rdr["HisDBPort"]);
lsc.HisDBName = ComUtility.DBNullStringHandler(rdr["HisDBName"]);
lsc.HisDBUID = ComUtility.DBNullStringHandler(rdr["HisDBUID"]);
lsc.HisDBPwd = ComUtility.DBNullStringHandler(rdr["HisDBPwd"]);
lsc.Connected = ComUtility.DBNullBooleanHandler(rdr["Connected"]);
lsc.ChangeTime = ComUtility.DBNullDateTimeHandler(rdr["ChangedTime"]);
lsc.MaxNodeModify = null;
lsc.MaxChangeLog = null;
lsc.Enabled = ComUtility.DBNullBooleanHandler(rdr["Enabled"]);
}
}
return(lsc);
} catch {
throw;
}
}
/// <summary>
/// Method to get all lscs information
/// </summary>
/// <returns>all lscs information</returns>
public List <LscInfo> GetLscs()
{
try {
List <LscInfo> lscList = new List <LscInfo>();
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SqlText.SQL_SELECT_LSC_GETLSCS, null)) {
while (rdr.Read())
{
LscInfo lsc = new LscInfo();
lsc.LscID = ComUtility.DBNullInt32Handler(rdr["LscID"]);
lsc.LscName = ComUtility.DBNullStringHandler(rdr["LscName"]);
lsc.LscIP = ComUtility.DBNullStringHandler(rdr["LscIP"]);
lsc.LscPort = ComUtility.DBNullInt32Handler(rdr["LscPort"]);
lsc.LscUID = ComUtility.DBNullStringHandler(rdr["LscUID"]);
lsc.LscPwd = ComUtility.DBNullStringHandler(rdr["LscPwd"]);
lsc.BeatInterval = ComUtility.DBNullInt32Handler(rdr["BeatInterval"]);
lsc.BeatDelay = ComUtility.DBNullInt32Handler(rdr["BeatDelay"]);
lsc.DBServer = ComUtility.DBNullStringHandler(rdr["DBServer"]);
lsc.DBPort = ComUtility.DBNullInt32Handler(rdr["DBPort"]);
lsc.DBName = ComUtility.DBNullStringHandler(rdr["DBName"]);
lsc.DBUID = ComUtility.DBNullStringHandler(rdr["DBUID"]);
lsc.DBPwd = ComUtility.DBNullStringHandler(rdr["DBPwd"]);
lsc.HisDBServer = ComUtility.DBNullStringHandler(rdr["HisDBServer"]);
lsc.HisDBPort = ComUtility.DBNullInt32Handler(rdr["HisDBPort"]);
lsc.HisDBName = ComUtility.DBNullStringHandler(rdr["HisDBName"]);
lsc.HisDBUID = ComUtility.DBNullStringHandler(rdr["HisDBUID"]);
lsc.HisDBPwd = ComUtility.DBNullStringHandler(rdr["HisDBPwd"]);
lsc.Connected = ComUtility.DBNullBooleanHandler(rdr["Connected"]);
lsc.ChangeTime = ComUtility.DBNullDateTimeHandler(rdr["ChangedTime"]);
lsc.MaxNodeModify = null;
lsc.MaxChangeLog = null;
lsc.Enabled = ComUtility.DBNullBooleanHandler(rdr["Enabled"]);
lscList.Add(lsc);
}
}
return(lscList);
} catch {
throw;
}
}
/// <summary>
/// Method to get all the reservation nodes information
/// </summary>
public List <NodeInReservationInfo> GetReservationNodes(string id)
{
SqlParameter[] parms = { new SqlParameter("@ReservationId", SqlDbType.VarChar, 100) };
parms[0].Value = id;
var entities = new List <NodeInReservationInfo>();
using (var rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SqlText.SQL_SELECT_LSC_GETRESERVATIONODES, parms)) {
while (rdr.Read())
{
var entity = new NodeInReservationInfo {
ReservationId = ComUtility.DBNullStringHandler(rdr["ReservationId"]),
NodeId = ComUtility.DBNullStringHandler(rdr["NodeId"]),
NodeType = ComUtility.DBNullResNodeHandler(rdr["NodeType"])
};
entities.Add(entity);
}
}
return(entities);
}
/// <summary>
/// Method to get all the reservations information
/// </summary>
public List <ReservationInfo> GetReservations()
{
var entities = new List <ReservationInfo>();
using (var rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SqlText.SQL_SELECT_LSC_GETRESERVATIONS, null)) {
while (rdr.Read())
{
var entity = new ReservationInfo {
LscId = ComUtility.DBNullInt32Handler(rdr["LscId"]),
Id = ComUtility.DBNullStringHandler(rdr["Id"]),
Name = ComUtility.DBNullStringHandler(rdr["Name"]),
StartTime = ComUtility.DBNullDateTimeHandler(rdr["StartTime"]),
EndTime = ComUtility.DBNullDateTimeHandler(rdr["EndTime"]),
Comment = ComUtility.DBNullStringHandler(rdr["Comment"]),
CreatedTime = ComUtility.DBNullDateTimeHandler(rdr["CreatedTime"]),
Project = new ProjectInfo {
Id = ComUtility.DBNullStringHandler(rdr["PId"]),
Name = ComUtility.DBNullStringHandler(rdr["PName"]),
StartTime = ComUtility.DBNullDateTimeHandler(rdr["PStartTime"]),
EndTime = ComUtility.DBNullDateTimeHandler(rdr["PEndTime"]),
Responsible = ComUtility.DBNullStringHandler(rdr["PResponsible"]),
ContactPhone = ComUtility.DBNullStringHandler(rdr["PContactPhone"]),
Company = ComUtility.DBNullStringHandler(rdr["PCompany"]),
Comment = ComUtility.DBNullStringHandler(rdr["PComment"]),
CreatedTime = ComUtility.DBNullDateTimeHandler(rdr["PCreatedTime"])
}
};
entities.Add(entity);
}
}
foreach (var entity in entities)
{
entity.Nodes = GetReservationNodes(entity.Id);
}
return(entities);
}
/// <summary>
/// Method to get system parameters
/// </summary>
/// <param name="paraCode">paraCode</param>
public List <SysParamInfo> GetSysParams(int paraCode)
{
try {
SqlParameter[] parms = { new SqlParameter("@ParaCode", SqlDbType.Int) };
parms[0].Value = paraCode;
var sysParms = new List <SysParamInfo>();
using (var rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SqlText.SQL_SELECT_ORDER_GETSYSPARAMS, parms)) {
while (rdr.Read())
{
var parm = new SysParamInfo();
parm.ID = ComUtility.DBNullInt32Handler(rdr["ID"]);
parm.ParaCode = ComUtility.DBNullInt32Handler(rdr["ParaCode"]);
parm.ParaData = ComUtility.DBNullInt32Handler(rdr["ParaData"]);
parm.ParaDisplay = ComUtility.DBNullStringHandler(rdr["ParaDisplay"]);
parm.Note = ComUtility.DBNullStringHandler(rdr["Note"]);
sysParms.Add(parm);
}
}
return(sysParms);
} catch { throw; }
}
/// <summary>
/// Get devices from database.
/// </summary>
/// <param name="lscId">lscId</param>
/// <param name="devId">devId</param>
/// <returns>devices list</returns>
public List <DevInfo> GetDevices(Int32 lscId, Int32 devId)
{
SqlParameter[] parms = { new SqlParameter("@LscID", SqlDbType.Int),
new SqlParameter("@DevID", SqlDbType.Int) };
parms[0].Value = lscId;
parms[1].Value = ComUtility.DBNullInt32Checker(devId);
var devices = new List <DevInfo>();
using (var rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SqlText.SQL_SELECT_COMMON_GETDEVICES, parms)) {
while (rdr.Read())
{
var dev = new DevInfo();
dev.LscID = ComUtility.DBNullInt32Handler(rdr["LscID"]);
dev.DevID = ComUtility.DBNullInt32Handler(rdr["DevID"]);
dev.DevName = ComUtility.DBNullStringHandler(rdr["DevName"]);
dev.DevDesc = ComUtility.DBNullStringHandler(rdr["DevDesc"]);
dev.StaID = ComUtility.DBNullInt32Handler(rdr["StaID"]);
devices.Add(dev);
}
}
return(devices);
}
/// <summary>
/// Method to add all the reservation information
/// </summary>
public void AddReservations(string connectionString, List <BookingInfo> bookings)
{
SqlParameter[] parms1 = { new SqlParameter("@LscID", SqlDbType.Int),
new SqlParameter("@ProjID", SqlDbType.VarChar, 50) };
SqlParameter[] parms2 = { new SqlParameter("@BookingUserID", SqlDbType.Int),
new SqlParameter("@ProjID", SqlDbType.VarChar, 50),
new SqlParameter("@ProjName", SqlDbType.VarChar, 100),
new SqlParameter("@ProjDesc", SqlDbType.VarChar, 200),
new SqlParameter("@LscIncluded", SqlDbType.Int),
new SqlParameter("@StaIncluded", SqlDbType.VarChar),
new SqlParameter("@DevIncluded", SqlDbType.VarChar),
new SqlParameter("@StartTime", SqlDbType.DateTime),
new SqlParameter("@EndTime", SqlDbType.DateTime),
new SqlParameter("@ProjStatus", SqlDbType.Int),
new SqlParameter("@IsComfirmed", SqlDbType.Bit),
new SqlParameter("@ComfirmedUserID", SqlDbType.Int),
new SqlParameter("@ComfirmedTime", SqlDbType.DateTime),
new SqlParameter("@IsChanged", SqlDbType.Bit),
new SqlParameter("@BookingTime", SqlDbType.DateTime) };
SqlHelper.TestConnection(connectionString);
using (var conn = new SqlConnection(connectionString)) {
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
var trans = conn.BeginTransaction(IsolationLevel.ReadCommitted);
try {
foreach (var booking in bookings)
{
parms1[0].Value = ComUtility.DBNullInt32Checker(booking.LscId);
parms1[1].Value = ComUtility.DBNullString2Checker(booking.Id);
SqlHelper.ExecuteNonQuery(trans, CommandType.Text, SqlText.SQL_SELECT_LSC_DELETERESERVATION, parms1);
foreach (var project in booking.Projects)
{
parms2[0].Value = ComUtility.DBNullInt32Checker(project.BookingUserID);
parms2[1].Value = ComUtility.DBNullString2Checker(project.ProjID);
parms2[2].Value = ComUtility.DBNullString2Checker(project.ProjName);
parms2[3].Value = ComUtility.DBNullString2Checker(project.ProjDesc);
parms2[4].Value = ComUtility.DBNullInt32Checker(project.LscIncluded);
parms2[5].Value = ComUtility.DBNullString2Checker(project.StaIncluded);
parms2[6].Value = ComUtility.DBNullString2Checker(project.DevIncluded);
parms2[7].Value = ComUtility.DBNullDateTimeChecker(project.StartTime);
parms2[8].Value = ComUtility.DBNullDateTimeChecker(project.EndTime);
parms2[9].Value = ComUtility.DBNullInt32Checker(project.ProjStatus);
parms2[10].Value = project.IsComfirmed;
parms2[11].Value = ComUtility.DBNullInt32Checker(project.ComfirmedUserID);
parms2[12].Value = ComUtility.DBNullDateTimeChecker(project.ComfirmedTime);
parms2[13].Value = project.IsChanged;
parms2[14].Value = ComUtility.DBNullDateTimeChecker(project.BookingTime);
SqlHelper.ExecuteNonQuery(trans, CommandType.Text, SqlText.SQL_SELECT_LSC_ADDRESERVATION, parms2);
}
}
trans.Commit();
} catch {
trans.Rollback();
throw;
}
}
}
/// <summary>
/// Method to save trend alarm information
/// </summary>
/// <param name="alarms">alarms</param>
public void SaveTrendAlarms(List <TrendAlarmInfo> alarms)
{
using (var conn = new SqlConnection(SqlHelper.ConnectionStringLocalTransaction)) {
conn.Open();
using (var trans = conn.BeginTransaction(IsolationLevel.ReadCommitted)) {
try {
SqlParameter[] parms = { new SqlParameter("@LscID", SqlDbType.Int),
new SqlParameter("@Area1Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Area2Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Area3Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Area4Name", SqlDbType.NVarChar, 50),
new SqlParameter("@StaName", SqlDbType.NVarChar, 100),
new SqlParameter("@DevName", SqlDbType.NVarChar, 100),
new SqlParameter("@NodeID", SqlDbType.Int),
new SqlParameter("@NodeType", SqlDbType.Int),
new SqlParameter("@NodeName", SqlDbType.NVarChar, 50),
new SqlParameter("@AlarmType", SqlDbType.NVarChar, 20),
new SqlParameter("@AlarmStatus", SqlDbType.Int),
new SqlParameter("@AlarmLevel", SqlDbType.Int),
new SqlParameter("@StartValue", SqlDbType.Real),
new SqlParameter("@AlarmValue", SqlDbType.Real),
new SqlParameter("@DiffValue", SqlDbType.Real),
new SqlParameter("@StartTime", SqlDbType.DateTime),
new SqlParameter("@AlarmTime", SqlDbType.DateTime),
new SqlParameter("@EventTime", SqlDbType.DateTime),
new SqlParameter("@ConfirmName", SqlDbType.NVarChar, 20),
new SqlParameter("@ConfirmTime", SqlDbType.DateTime),
new SqlParameter("@EndName", SqlDbType.NVarChar, 20),
new SqlParameter("@EndTime", SqlDbType.DateTime),
new SqlParameter("@StartIsAddAlarmList", SqlDbType.Bit),
new SqlParameter("@EndIsAddAlarmList", SqlDbType.Bit),
new SqlParameter("@ConfirmIsAddAlarmList", SqlDbType.Bit) };
foreach (var alarm in alarms)
{
parms[0].Value = alarm.LscID;
parms[1].Value = ComUtility.DBNullStringChecker(alarm.Area1Name);
parms[2].Value = ComUtility.DBNullStringChecker(alarm.Area2Name);
parms[3].Value = ComUtility.DBNullStringChecker(alarm.Area3Name);
parms[4].Value = ComUtility.DBNullStringChecker(alarm.Area4Name);
parms[5].Value = ComUtility.DBNullStringChecker(alarm.StaName);
parms[6].Value = ComUtility.DBNullStringChecker(alarm.DevName);
parms[7].Value = alarm.NodeID;
parms[8].Value = alarm.NodeType;
parms[9].Value = ComUtility.DBNullStringChecker(alarm.NodeName);
parms[10].Value = ComUtility.DBNullStringChecker(alarm.AlarmType);
parms[11].Value = ComUtility.DBNullInt32Checker(alarm.AlarmStatus);
parms[12].Value = ComUtility.DBNullInt32Checker(alarm.AlarmLevel);
parms[13].Value = ComUtility.DBNullFloatHandler(alarm.StartValue);
parms[14].Value = ComUtility.DBNullFloatHandler(alarm.AlarmValue);
parms[15].Value = ComUtility.DBNullFloatHandler(alarm.DiffValue);
parms[16].Value = ComUtility.DBNullDateTimeChecker(alarm.StartTime);
parms[17].Value = ComUtility.DBNullDateTimeChecker(alarm.AlarmTime);
parms[18].Value = ComUtility.DBNullDateTimeChecker(alarm.EventTime);
parms[19].Value = ComUtility.DBNullStringChecker(alarm.ConfirmName);
parms[20].Value = ComUtility.DBNullDateTimeChecker(alarm.ConfirmTime);
parms[21].Value = ComUtility.DBNullStringChecker(alarm.EndName);
parms[22].Value = ComUtility.DBNullDateTimeChecker(alarm.EndTime);
parms[23].Value = alarm.StartIsAddAlarmList;
parms[24].Value = alarm.EndIsAddAlarmList;
parms[25].Value = alarm.ConfirmIsAddAlarmList;
SqlHelper.ExecuteNonQuery(trans, CommandType.Text, SqlText.SQL_INSERT_ALARM_SAVETRENDALARMS, parms);
}
trans.Commit();
} catch {
trans.Rollback();
throw;
}
}
}
}