/// <summary>
/// Method to gets lsc project
/// </summary>
/// <param name="projectId">projectId</param>
/// <param name="connectionString">connectionString</param>
/// <returns>project object</returns>
public List <ProjectInfo> GetProjectItem(int lscId, string lscName, string connectionString)
{
var projects = new List <ProjectInfo>();
SqlHelper.TestConnection(connectionString);
using (var rdr = SqlHelper.ExecuteReader(connectionString, CommandType.Text, SqlText.Sql_Appointment_Get_ProjectItem, null)) {
while (rdr.Read())
{
var project = new ProjectInfo();
project.LscID = lscId;
project.LscName = lscName;
project.ProjectId = ComUtility.DBNullStringHandler(rdr["ProjectId"]);
project.ProjectName = ComUtility.DBNullStringHandler(rdr["ProjectName"]);
project.BeginTime = ComUtility.DBNullDateTimeHandler(rdr["BeginTime"]);
project.EndTime = ComUtility.DBNullDateTimeHandler(rdr["EndTime"]);
project.Responsible = ComUtility.DBNullStringHandler(rdr["Responsible"]);
project.ContactPhone = ComUtility.DBNullStringHandler(rdr["ContactPhone"]);
project.Company = ComUtility.DBNullStringHandler(rdr["Company"]);
project.Comment = ComUtility.DBNullStringHandler(rdr["Comment"]);
project.Enabled = ComUtility.DBNullBooleanHandler(rdr["Enabled"]);
projects.Add(project);
}
}
return(projects);
}
/// <summary>
/// Method to get user defind groups
/// </summary>
/// <param name="lscId">lscId</param>
/// <param name="userId">userId</param>
public List <UDGroupInfo> GetUDGroups(int lscId, int userId)
{
try {
SqlParameter[] parms = { new SqlParameter("@LscID", SqlDbType.Int),
new SqlParameter("@UserID", SqlDbType.Int) };
parms[0].Value = lscId;
parms[1].Value = userId;
var groups = new List <UDGroupInfo>();
using (var rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SqlText.SQL_SELECT_GROUP_GETUDGROUPS, parms)) {
while (rdr.Read())
{
var group = new UDGroupInfo();
group.LscID = ComUtility.DBNullInt32Handler(rdr["LscID"]);
group.UserID = ComUtility.DBNullInt32Handler(rdr["UserID"]);
group.UDGroupID = ComUtility.DBNullInt32Handler(rdr["UDGroupID"]);
group.UDGroupName = ComUtility.DBNullStringHandler(rdr["UDGroupName"]);
group.UDGroupNodes = null;
group.Enabled = ComUtility.DBNullBooleanHandler(rdr["Enabled"]);
groups.Add(group);
}
}
return(groups);
} catch { throw; }
}
/// <summary>
/// Method to gets lsc project
/// </summary>
/// <param name="projectId">projectId</param>
/// <param name="connectionString">connectionString</param>
/// <returns>project object</returns>
public ProjectInfo GetProject(int lscId, string lscName, string projectId, string connectionString)
{
SqlParameter[] parms = { new SqlParameter("@ProjectId", SqlDbType.VarChar, 50) };
parms[0].Value = projectId;
ProjectInfo project = null;
SqlHelper.TestConnection(connectionString);
using (var rdr = SqlHelper.ExecuteReader(connectionString, CommandType.Text, SqlText.Sql_Appointment_Get_Project, parms)) {
if (rdr.Read())
{
project = new ProjectInfo();
project.LscID = lscId;
project.LscName = lscName;
project.ProjectId = ComUtility.DBNullStringHandler(rdr["ProjectId"]);
project.ProjectName = ComUtility.DBNullStringHandler(rdr["ProjectName"]);
project.BeginTime = ComUtility.DBNullDateTimeHandler(rdr["BeginTime"]);
project.EndTime = ComUtility.DBNullDateTimeHandler(rdr["EndTime"]);
project.Responsible = ComUtility.DBNullStringHandler(rdr["Responsible"]);
project.ContactPhone = ComUtility.DBNullStringHandler(rdr["ContactPhone"]);
project.Company = ComUtility.DBNullStringHandler(rdr["Company"]);
project.Comment = ComUtility.DBNullStringHandler(rdr["Comment"]);
project.Enabled = ComUtility.DBNullBooleanHandler(rdr["Enabled"]);
}
}
return(project);
}
/// <summary>
/// Method to get nodes combobox information
/// </summary>
/// <param name="lscId">lscId</param>
/// <param name="devId">devId</param>
/// <param name="AI">AI</param>
/// <param name="AO">AO</param>
/// <param name="DI">DI</param>
/// <param name="DO">DO</param>
public Dictionary <string, string> GetNodes(int lscId, int devId, bool AI, bool AO, bool DI, bool DO)
{
try {
SqlParameter[] parms = { new SqlParameter("@LscID", SqlDbType.Int),
new SqlParameter("@DevID", SqlDbType.Int),
new SqlParameter("@AI", SqlDbType.Bit),
new SqlParameter("@AO", SqlDbType.Bit),
new SqlParameter("@DI", SqlDbType.Bit),
new SqlParameter("@DO", SqlDbType.Bit) };
parms[0].Value = lscId;
parms[1].Value = devId;
parms[2].Value = AI;
parms[3].Value = AO;
parms[4].Value = DI;
parms[5].Value = DO;
var dict = new Dictionary <string, string>();
using (var rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SqlText.SQL_SELECT_COMBOBOX_GETNODES, parms)) {
while (rdr.Read())
{
var id = ComUtility.DBNullInt32Handler(rdr["NodeID"]);
var name = ComUtility.DBNullStringHandler(rdr["NodeName"]);
dict.Add(id.ToString(), name);
}
}
return(dict);
} catch { throw; }
}
/// <summary>
/// Gets an appointment
/// </summary>
/// <param name="lscId"></param>
/// <param name="lscName"></param>
/// <param name="id"></param>
/// <param name="connectionString"></param>
/// <returns></returns>
public AppointmentInfo GetAppointment(int lscId, string lscName, int id, string connectionString)
{
SqlParameter[] parms = { new SqlParameter("@Id", id) };
AppointmentInfo appointment = null;
SqlHelper.TestConnection(connectionString);
using (var rdr = SqlHelper.ExecuteReader(connectionString, CommandType.Text, SqlText.Sql_Appointment_Get, parms)) {
if (rdr.Read())
{
appointment = new AppointmentInfo();
appointment.LscID = lscId;
appointment.LscName = lscName;
appointment.Id = ComUtility.DBNullInt32Handler(rdr["Id"]);
appointment.StartTime = ComUtility.DBNullDateTimeHandler(rdr["StartTime"]);
appointment.EndTime = ComUtility.DBNullDateTimeHandler(rdr["EndTime"]);
appointment.LscIncluded = ComUtility.DBNullInt32Handler(rdr["LscIncluded"]);
appointment.StaIncluded = ComUtility.DBNullStringHandler(rdr["StaIncluded"]);
appointment.DevIncluded = ComUtility.DBNullStringHandler(rdr["DevIncluded"]);
appointment.ProjectId = ComUtility.DBNullStringHandler(rdr["ProjectId"]);
appointment.ProjectName = ComUtility.DBNullStringHandler(rdr["ProjectName"]);
appointment.Status = ComUtility.DBNullProjStatusHandler(rdr["Status"]);
appointment.CreaterId = ComUtility.DBNullInt32Handler(rdr["CreaterId"]);
appointment.Creater = ComUtility.DBNullStringHandler(rdr["Creater"]);
appointment.ContactPhone = ComUtility.DBNullStringHandler(rdr["ContactPhone"]);
appointment.CreatedTime = ComUtility.DBNullDateTimeHandler(rdr["CreatedTime"]);
}
}
return(appointment);
}
/// <summary>
/// Method to get alarm logics combobox information
/// </summary>
/// <param name="alarmDevId">alarmDevId</param>
public Dictionary <string, string> GetAlarmLogics(int alarmDevId)
{
try {
SqlParameter[] parms = { new SqlParameter("@AlarmDeviceTypeID", SqlDbType.Int) };
if (alarmDevId == ComUtility.DefaultInt32)
{
parms[0].Value = DBNull.Value;
}
else
{
parms[0].Value = alarmDevId;
}
var dict = new Dictionary <string, string>();
using (var rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SqlText.SQL_SELECT_COMBOBOX_GETALARMLOGICS, parms)) {
while (rdr.Read())
{
var id = ComUtility.DBNullInt32Handler(rdr["TypeID"]);
var name = ComUtility.DBNullStringHandler(rdr["TypeName"]);
dict.Add(id.ToString(), name);
}
}
return(dict);
} catch { throw; }
}
public List <StandardProtocolInfo> GetStandardProtocol()
{
var Protocols = new List <StandardProtocolInfo>();
using (var rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SqlText.SQL_SELECT_ALARM_GETALARMDETAILS, null)) {
while (rdr.Read())
{
var p = new StandardProtocolInfo();
p.AlarmID = ComUtility.DBNullInt32Handler(rdr["AlarmID"]);
p.AlarmName = ComUtility.DBNullStringHandler(rdr["AlarmName"]);
p.AlarmInterpret = ComUtility.DBNullStringHandler(rdr["AlarmInterpret"]);
p.AlarmVer = ComUtility.DBNullInt32Handler(rdr["AlarmVer"]);
p.AlarmLevel = ComUtility.DBNullAlarmLevelHandler(rdr["AlarmLevel"]);
p.DevEffect = ComUtility.DBNullStringHandler(rdr["DevEffect"]);
p.OperEffect = ComUtility.DBNullStringHandler(rdr["OperEffect"]);
p.SubAlarmLogTypeID = ComUtility.DBNullInt32Handler(rdr["SubAlarmLogTypeID"]);
p.SubAlarmLogType = ComUtility.DBNullStringHandler(rdr["SubAlarmLogType"]);
p.AlarmLogTypeID = ComUtility.DBNullInt32Handler(rdr["AlarmLogTypeID"]);
p.AlarmLogType = ComUtility.DBNullStringHandler(rdr["AlarmLogType"]);
p.AlarmDeviceTypeID = ComUtility.DBNullInt32Handler(rdr["AlarmDeviceTypeID"]);
p.AlarmDeviceType = ComUtility.DBNullStringHandler(rdr["AlarmDeviceType"]);
p.NMAlarmID = ComUtility.DBNullStringHandler(rdr["NMAlarmID"]);
p.AlarmClass = ComUtility.DBNullStringHandler(rdr["AlarmClass"]);
Protocols.Add(p);
}
}
return(Protocols);
}
/// <summary>
/// Method to get area2 combobox information
/// </summary>
/// <param name="lscId">lscId</param>
/// <param name="area1Id">area1Id</param>
/// <param name="groupId">groupId</param>
public Dictionary <string, string> GetArea2(int lscId, int area1Id, int groupId)
{
try {
SqlParameter[] parms = { new SqlParameter("@LscID", SqlDbType.Int),
new SqlParameter("@AreaID", SqlDbType.Int),
new SqlParameter("@GroupID", SqlDbType.Int),
new SqlParameter("@AreaType", SqlDbType.Int) };
parms[0].Value = lscId;
if (area1Id == ComUtility.DefaultInt32)
{
parms[1].Value = DBNull.Value;
}
else
{
parms[1].Value = area1Id;
}
parms[2].Value = groupId;
parms[3].Value = (int)EnmNodeType.Area;
var dict = new Dictionary <string, string>();
using (var rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SqlText.SQL_SELECT_COMBOBOX_GETAREA2, parms)) {
while (rdr.Read())
{
var id = ComUtility.DBNullInt32Handler(rdr["AreaID"]);
var name = ComUtility.DBNullStringHandler(rdr["AreaName"]);
dict.Add(id.ToString(), name);
}
}
return(dict);
} catch { throw; }
}
/// <summary>
/// Get Device Type
/// </summary>
public Dictionary <String, Int32> GetDevType(int lscId, int nodeId)
{
SqlParameter[] parms = { new SqlParameter("@LscID", SqlDbType.Int),
new SqlParameter("@DevID", SqlDbType.Int) };
parms[0].Value = lscId;
if (nodeId == ComUtility.DefaultInt32)
{
parms[1].Value = DBNull.Value;
}
else
{
parms[1].Value = ComUtility.GetDevID(nodeId);
}
var dict = new Dictionary <String, Int32>();
using (var rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SqlText.SQL_SELECT_PREALARM_GETDEVTYPE, parms)) {
while (rdr.Read())
{
var key = String.Format("{0}-{1}", ComUtility.DBNullInt32Handler(rdr["LscID"]), ComUtility.DBNullInt32Handler(rdr["DevID"]));
var value = ComUtility.DBNullInt32Handler(rdr["DevTypeID"]);
dict.Add(key, value);
}
}
return(dict);
}
/// <summary>
/// Gets users from the lsc database
/// </summary>
/// <param name="lscId">lscId</param>
/// <param name="lscName">lscName</param>
/// <param name="userId">userId</param>
/// <param name="connectionString">connectionString</param>
/// <returns></returns>
public List <LscUserInfo> GetUsers(int lscId, string lscName, int?userId, string connectionString)
{
SqlParameter[] parms = { new SqlParameter("@UserId", SqlDbType.Int) };
parms[0].Value = DBNull.Value;
if (userId.HasValue)
{
parms[0].Value = userId.Value;
}
var lscUsers = new List <LscUserInfo>();
SqlHelper.TestConnection(connectionString);
using (var rdr = SqlHelper.ExecuteReader(connectionString, CommandType.Text, SqlText.Sql_Lsc_Get_Users, parms)) {
while (rdr.Read())
{
var lscUser = new LscUserInfo();
lscUser.LscID = lscId;
lscUser.LscName = lscName;
lscUser.UserID = ComUtility.DBNullInt32Handler(rdr["UserID"]);
lscUser.UserName = ComUtility.DBNullStringHandler(rdr["UserName"]);
lscUser.UID = ComUtility.DBNullStringHandler(rdr["UID"]);
lscUser.OpLevel = ComUtility.DBNullUserLevelHandler(rdr["OpLevel"]);
lscUser.LimitTime = ComUtility.DBNullDateTimeHandler(rdr["LimitTime"]);
lscUser.TelePhone = ComUtility.DBNullStringHandler(rdr["TelePhone"]);
lscUser.MobilePhone = ComUtility.DBNullStringHandler(rdr["MobilePhone"]);
lscUser.Email = ComUtility.DBNullStringHandler(rdr["Email"]);
lscUser.Address = ComUtility.DBNullStringHandler(rdr["Address"]);
lscUser.PostalCode = ComUtility.DBNullStringHandler(rdr["PostalCode"]);
lscUser.Remark = ComUtility.DBNullStringHandler(rdr["Remark"]);
lscUser.Enabled = ComUtility.DBNullBooleanHandler(rdr["Enabled"]);
lscUsers.Add(lscUser);
}
}
return(lscUsers);
}
/// <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) };
if (paraCode == ComUtility.DefaultInt32)
{
parms[0].Value = DBNull.Value;
}
else
{
parms[0].Value = paraCode;
}
var sysParms = new List <SysParamInfo>();
using (var rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SqlText.SQL_SELECT_USER_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>
/// Method to get group tree nodes
/// </summary>
/// <param name="lscId">lscId</param>
/// <param name="groupId">groupId</param>
public List <GroupTreeInfo> GetGroupTreeNodes(int lscId, int groupId)
{
try {
SqlParameter[] parms = { new SqlParameter("@LscID", SqlDbType.Int),
new SqlParameter("@GroupID", SqlDbType.Int),
new SqlParameter("@AreaType", SqlDbType.Int),
new SqlParameter("@StaType", SqlDbType.Int),
new SqlParameter("@DevType", SqlDbType.Int) };
parms[0].Value = lscId;
parms[1].Value = groupId;
parms[2].Value = (int)EnmNodeType.Area;
parms[3].Value = (int)EnmNodeType.Sta;
parms[4].Value = (int)EnmNodeType.Dev;
var gNodes = new List <GroupTreeInfo>();
using (var rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SqlText.SQL_SELECT_GROUP_GETGROUPTREENODES, parms)) {
while (rdr.Read())
{
var gNode = new GroupTreeInfo();
gNode.LscID = ComUtility.DBNullInt32Handler(rdr["LscID"]);
gNode.NodeID = ComUtility.DBNullInt32Handler(rdr["NodeID"]);
gNode.NodeType = ComUtility.DBNullNodeTypeHandler(rdr["NodeType"]);
gNode.NodeName = ComUtility.DBNullStringHandler(rdr["NodeName"]);
gNode.GroupID = ComUtility.DBNullInt32Handler(rdr["GroupID"]);
gNode.LastNodeID = ComUtility.DBNullInt32Handler(rdr["LastNodeID"]);
gNode.TreeIndex = ComUtility.DBNullInt32Handler(rdr["TreeIndex"]);
gNode.Status = EnmAlarmLevel.NoAlarm;
gNode.Remark = ComUtility.DBNullStringHandler(rdr["Remark"]);
gNodes.Add(gNode);
}
}
return(gNodes);
} catch { throw; }
}
/// <summary>
/// Method to get calendar events
/// </summary>
/// <param name="uId">uId</param>
public List <CalendarEventInfo> GetCalendarEvents(string uId)
{
try {
SqlParameter[] parms = { new SqlParameter("@UID", SqlDbType.VarChar, 50) };
parms[0].Value = uId;
var calEvents = new List <CalendarEventInfo>();
using (var rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SqlText.SQL_SELECT_CALENDAR_GETCALENDAREVENTS, parms)) {
while (rdr.Read())
{
var calEvent = new CalendarEventInfo();
calEvent.EventID = ComUtility.DBNullInt32Handler(rdr["EventID"]);
calEvent.CalendarID = ComUtility.DBNullInt32Handler(rdr["CalendarID"]);
calEvent.Title = ComUtility.DBNullStringHandler(rdr["Title"]);
calEvent.StartDate = ComUtility.DBNullDateTimeHandler(rdr["StartDate"]);
calEvent.EndDate = ComUtility.DBNullDateTimeHandler(rdr["EndDate"]);
calEvent.IsAllDay = ComUtility.DBNullNullableBooleanHandler(rdr["IsAllDay"]);
calEvent.Notes = ComUtility.DBNullStringHandler(rdr["Notes"]);
calEvent.Location = ComUtility.DBNullStringHandler(rdr["Location"]);
calEvent.Reminder = ComUtility.DBNullStringHandler(rdr["Reminder"]);
calEvent.Url = ComUtility.DBNullStringHandler(rdr["Url"]);
calEvent.IsNew = ComUtility.DBNullNullableBooleanHandler(rdr["IsNew"]);
calEvent.UID = ComUtility.DBNullStringHandler(rdr["UID"]);
calEvent.UpdateTime = ComUtility.DBNullDateTimeHandler(rdr["UpdateTime"]);
calEvents.Add(calEvent);
}
}
return(calEvents);
} catch { throw; }
}
/// <summary>
/// Method to get frequency alarms
/// </summary>
public List <FrequencyAlarmInfo> GetFrequencyAlarms()
{
var alarms = new List <FrequencyAlarmInfo>();
var sqlText = String.Format(@"
;WITH Nodes AS
(
SELECT TA.[LscID],TA.[AicID] AS [NodeID],{0} AS [NodeType],TA.[DevID] FROM [dbo].[TM_AIC] TA
UNION ALL
SELECT TD.[LscID],TD.[DicID] AS [NodeID],{1} AS [NodeType],TD.[DevID] FROM [dbo].[TM_DIC] TD
),
Alarms AS
(
SELECT TF.*,N.[DevID],L.[LscName],DT.[TypeID] AS [DevTypeID],DT.[TypeName] AS [DevTypeName]
FROM [dbo].[TA_FrequencyAlarm] TF
INNER JOIN Nodes N ON TF.[LscID] = N.[LscID] AND TF.[NodeType] = N.[NodeType] AND TF.[NodeID] = N.[NodeID]
INNER JOIN [dbo].[TM_DEV] TD ON N.[LscID] = TD.[LscID] AND N.[DevID] = TD.[DevID]
INNER JOIN [dbo].[TM_LSC] L ON TD.[LscID] = L.[LscID]
LEFT OUTER JOIN [dbo].[TC_DeviceType] DT ON TD.[DevTypeID] = DT.[TypeID]
)
SELECT [LscID],[LscName],[Area1Name],[Area2Name],[Area3Name],[StaName],[DevID],[DevName],[NodeID],
[NodeType],[NodeName],[DevTypeID],[DevTypeName],[AlarmLevel],[FreAlarmValue],[FreRightValue],
[StartTime],[AlarmTime],[ConfirmName],[ConfirmTime],[EndName],[EndTime] FROM Alarms;", (Int32)EnmNodeType.Aic, (Int32)EnmNodeType.Dic);
using (var rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sqlText, null)) {
while (rdr.Read())
{
var alarm = new FrequencyAlarmInfo();
alarm.LscID = ComUtility.DBNullInt32Handler(rdr["LscID"]);
alarm.LscName = ComUtility.DBNullStringHandler(rdr["LscName"]);
alarm.Area1Name = ComUtility.DBNullStringHandler(rdr["Area1Name"]);
alarm.Area2Name = ComUtility.DBNullStringHandler(rdr["Area2Name"]);
alarm.Area3Name = ComUtility.DBNullStringHandler(rdr["Area3Name"]);
alarm.StaName = ComUtility.DBNullStringHandler(rdr["StaName"]);
alarm.DevID = ComUtility.DBNullInt32Handler(rdr["DevID"]);
alarm.DevName = ComUtility.DBNullStringHandler(rdr["DevName"]);
alarm.NodeID = ComUtility.DBNullInt32Handler(rdr["NodeID"]);
alarm.NodeType = ComUtility.DBNullNodeTypeHandler(rdr["NodeType"]);
alarm.NodeName = ComUtility.DBNullStringHandler(rdr["NodeName"]);
alarm.DevTypeID = ComUtility.DBNullInt32Handler(rdr["DevTypeID"]);
alarm.DevTypeName = ComUtility.DBNullStringHandler(rdr["DevTypeName"]);
alarm.AlarmLevel = ComUtility.DBNullAlarmLevelHandler(rdr["AlarmLevel"]);
alarm.FreAlarmValue = ComUtility.DBNullInt32Handler(rdr["FreAlarmValue"]);
alarm.FreRightValue = ComUtility.DBNullInt32Handler(rdr["FreRightValue"]);
alarm.StartTime = ComUtility.DBNullDateTimeHandler(rdr["StartTime"]);
alarm.AlarmTime = ComUtility.DBNullDateTimeHandler(rdr["AlarmTime"]);
alarm.ConfirmName = ComUtility.DBNullStringHandler(rdr["ConfirmName"]);
alarm.ConfirmTime = ComUtility.DBNullDateTimeHandler(rdr["ConfirmTime"]);
alarm.EndName = ComUtility.DBNullStringHandler(rdr["EndName"]);
alarm.EndTime = ComUtility.DBNullDateTimeHandler(rdr["EndTime"]);
alarms.Add(alarm);
}
}
return(alarms);
}
/// <summary>
/// Method to get CSC alarm filter columns information
/// </summary>
/// <param name="lscId">lscId</param>
/// <param name="uId">uId</param>
public List <ACSFilterInfo> GetCSCAlarmFilterCols(int lscId, string uId)
{
try {
SqlParameter[] parms = { new SqlParameter("@LscID", SqlDbType.Int),
new SqlParameter("@UID", SqlDbType.VarChar, 20) };
parms[0].Value = lscId;
parms[1].Value = uId;
using (var conn = new SqlConnection(SqlHelper.ConnectionStringLocalTransaction)) {
var items = SqlHelper.ExecuteScalar(conn, CommandType.Text, SqlText.SQL_SELECT_SETTING_GETCSCALARMFILTERCOLS, parms);
return(ComUtility.DBNullAlarmStaticFiterItemHandler(items));
}
} catch { throw; }
}
/// <summary>
/// Method to get alarm levels combobox information
/// </summary>
public Dictionary <string, string> GetAlarmLevels()
{
var dict = new Dictionary <string, string>();
foreach (EnmAlarmLevel level in Enum.GetValues(typeof(EnmAlarmLevel)))
{
if (level == EnmAlarmLevel.NoAlarm)
{
continue;
}
dict.Add(((int)level).ToString(), ComUtility.GetAlarmLevelName(level));
}
return(dict);
}
/// <summary>
/// Method to get trend alarms
/// </summary>
public List <TrendAlarmInfo> GetTrendAlarms()
{
var alarms = new List <TrendAlarmInfo>();
var sqlText = @"
;WITH Alarms AS
(
SELECT TT.*,TA.[DevID],L.[LscName],DT.[TypeID] AS DevTypeID,DT.[TypeName] AS DevTypeName
FROM [dbo].[TA_TrendAlarm] TT
INNER JOIN [dbo].[TM_AIC] TA ON TT.[LscID] = TA.[LscID] AND TT.[NodeID] = TA.[AicID]
INNER JOIN [dbo].[TM_DEV] TD ON TA.[LscID] = TD.[LscID] AND TA.[DevID] = TD.[DevID]
INNER JOIN [dbo].[TM_LSC] L ON TD.[LscID] = L.[LscID]
LEFT OUTER JOIN [dbo].[TC_DeviceType] DT ON TD.[DevTypeID] = DT.[TypeID]
)
SELECT [LscID],[LscName],[Area1Name],[Area2Name],[Area3Name],[StaName],[DevID],[DevName],[NodeID],
[NodeName],[DevTypeID],[DevTypeName],[AlarmType],[AlarmLevel],[StartValue],[AlarmValue],[DiffValue],
[StartTime],[AlarmTime],[ConfirmName],[ConfirmTime],[EndName],[EndTime] FROM Alarms;";
using (var rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sqlText, null)) {
while (rdr.Read())
{
var alarm = new TrendAlarmInfo();
alarm.LscID = ComUtility.DBNullInt32Handler(rdr["LscID"]);
alarm.LscName = ComUtility.DBNullStringHandler(rdr["LscName"]);
alarm.Area1Name = ComUtility.DBNullStringHandler(rdr["Area1Name"]);
alarm.Area2Name = ComUtility.DBNullStringHandler(rdr["Area2Name"]);
alarm.Area3Name = ComUtility.DBNullStringHandler(rdr["Area3Name"]);
alarm.StaName = ComUtility.DBNullStringHandler(rdr["StaName"]);
alarm.DevID = ComUtility.DBNullInt32Handler(rdr["DevID"]);
alarm.DevName = ComUtility.DBNullStringHandler(rdr["DevName"]);
alarm.NodeID = ComUtility.DBNullInt32Handler(rdr["NodeID"]);
alarm.NodeName = ComUtility.DBNullStringHandler(rdr["NodeName"]);
alarm.DevTypeID = ComUtility.DBNullInt32Handler(rdr["DevTypeID"]);
alarm.DevTypeName = ComUtility.DBNullStringHandler(rdr["DevTypeName"]);
alarm.AlarmType = ComUtility.DBNullStringHandler(rdr["AlarmType"]);
alarm.AlarmLevel = ComUtility.DBNullAlarmLevelHandler(rdr["AlarmLevel"]);
alarm.StartValue = ComUtility.DBNullFloatHandler(rdr["StartValue"]);
alarm.AlarmValue = ComUtility.DBNullFloatHandler(rdr["AlarmValue"]);
alarm.DiffValue = ComUtility.DBNullFloatHandler(rdr["DiffValue"]);
alarm.StartTime = ComUtility.DBNullDateTimeHandler(rdr["StartTime"]);
alarm.AlarmTime = ComUtility.DBNullDateTimeHandler(rdr["AlarmTime"]);
alarm.ConfirmName = ComUtility.DBNullStringHandler(rdr["ConfirmName"]);
alarm.ConfirmTime = ComUtility.DBNullDateTimeHandler(rdr["ConfirmTime"]);
alarm.EndName = ComUtility.DBNullStringHandler(rdr["EndName"]);
alarm.EndTime = ComUtility.DBNullDateTimeHandler(rdr["EndTime"]);
alarms.Add(alarm);
}
}
return(alarms);
}
/// <summary>
/// Method to get alarm log type
/// </summary>
public Dictionary <int, string> GetAlarmLogType()
{
try {
var dict = new Dictionary <int, string>();
using (var rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SqlText.SQL_SELECT_SETTING_GETALARMLOGTYPE, null)) {
while (rdr.Read())
{
var id = ComUtility.DBNullInt32Handler(rdr["TypeID"]);
var name = ComUtility.DBNullStringHandler(rdr["TypeName"]);
dict.Add(id, name);
}
}
return(dict);
} catch { throw; }
}
public Dictionary <int, string> GetAcMessageType(string connectionString)
{
var dict = new Dictionary <int, string>();
SqlHelper.TestConnection(connectionString);
using (var rdr = SqlHelper.ExecuteReader(connectionString, CommandType.Text, SqlText.SQL_SELECT_COMBOBOX_GetAcMessageType, null)) {
while (rdr.Read())
{
var id = ComUtility.DBNullInt32Handler(rdr["ID"]);
var name = ComUtility.DBNullStringHandler(rdr["Name"]);
dict.Add(id, name);
}
}
return(dict);
}
/// <summary>
/// Method to get alarm names combobox information
/// </summary>
public Dictionary <string, string> GetAlarmNames()
{
try {
var dict = new Dictionary <string, string>();
using (var rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SqlText.SQL_SELECT_COMBOBOX_GETALLALARMNAMES, null)) {
while (rdr.Read())
{
var id = ComUtility.DBNullInt32Handler(rdr["AlarmID"]);
var name = ComUtility.DBNullStringHandler(rdr["AlarmName"]);
dict.Add(id.ToString(), name);
}
}
return(dict);
} catch { throw; }
}
/// <summary>
/// Method to get load alarms
/// </summary>
public List <LoadAlarmInfo> GetLoadAlarms()
{
var alarms = new List <LoadAlarmInfo>();
var sqlText = @"
;WITH Alarms AS
(
SELECT LA.*,L.[LscName],DT.[TypeName] AS [DevTypeName]
FROM [dbo].[TA_LoadAlarm] LA
INNER JOIN [dbo].[TM_DEV] TD ON LA.[LscID] = TD.[LscID] AND LA.[DevID] = TD.[DevID]
INNER JOIN [dbo].[TM_LSC] L ON TD.[LscID] = L.[LscID]
LEFT OUTER JOIN [dbo].[TC_DeviceType] DT ON TD.[DevTypeID] = DT.[TypeID]
)
SELECT [LscID],[LscName],[Area1Name],[Area2Name],[Area3Name],[StaName],[DevID],[DevName],
[DevTypeID],[DevTypeName],[AlarmLevel],[RateValue],[LoadValue],[LoadPercent],[RightPercent],
[StartTime],[ConfirmName],[ConfirmTime],[EndName],[EndTime] FROM Alarms;";
using (var rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sqlText, null)) {
while (rdr.Read())
{
var alarm = new LoadAlarmInfo();
alarm.LscID = ComUtility.DBNullInt32Handler(rdr["LscID"]);
alarm.LscName = ComUtility.DBNullStringHandler(rdr["LscName"]);
alarm.Area1Name = ComUtility.DBNullStringHandler(rdr["Area1Name"]);
alarm.Area2Name = ComUtility.DBNullStringHandler(rdr["Area2Name"]);
alarm.Area3Name = ComUtility.DBNullStringHandler(rdr["Area3Name"]);
alarm.StaName = ComUtility.DBNullStringHandler(rdr["StaName"]);
alarm.DevID = ComUtility.DBNullInt32Handler(rdr["DevID"]);
alarm.DevName = ComUtility.DBNullStringHandler(rdr["DevName"]);
alarm.DevTypeID = ComUtility.DBNullInt32Handler(rdr["DevTypeID"]);
alarm.DevTypeName = ComUtility.DBNullStringHandler(rdr["DevTypeName"]);
alarm.AlarmLevel = ComUtility.DBNullAlarmLevelHandler(rdr["AlarmLevel"]);
alarm.RateValue = ComUtility.DBNullFloatHandler(rdr["RateValue"]);
alarm.LoadValue = ComUtility.DBNullFloatHandler(rdr["LoadValue"]);
alarm.LoadPercent = ComUtility.DBNullFloatHandler(rdr["LoadPercent"]);
alarm.RightPercent = ComUtility.DBNullFloatHandler(rdr["RightPercent"]);
alarm.StartTime = ComUtility.DBNullDateTimeHandler(rdr["StartTime"]);
alarm.ConfirmName = ComUtility.DBNullStringHandler(rdr["ConfirmName"]);
alarm.ConfirmTime = ComUtility.DBNullDateTimeHandler(rdr["ConfirmTime"]);
alarm.EndName = ComUtility.DBNullStringHandler(rdr["EndName"]);
alarm.EndTime = ComUtility.DBNullDateTimeHandler(rdr["EndTime"]);
alarms.Add(alarm);
}
}
return(alarms);
}
/// <summary>
/// Gets history appointment records.
/// </summary>
/// <param name="lscId">lscId</param>
/// <param name="lscName">lscName</param>
/// <param name="beginTime">beginTime</param>
/// <param name="endTime">endTime</param>
/// <param name="queryType">queryType</param>
/// <param name="queryText">queryText</param>
/// <returns></returns>
public List <AppointmentInfo> GetHisAppointments(int lscId, string lscName, DateTime beginTime, DateTime endTime, int queryType, string queryText)
{
SqlParameter[] parms = { new SqlParameter("@LscID", SqlDbType.Int),
new SqlParameter("@BeginTime", SqlDbType.DateTime),
new SqlParameter("@EndTime", SqlDbType.DateTime),
new SqlParameter("@QueryType", SqlDbType.Int),
new SqlParameter("@QueryText", SqlDbType.NVarChar, 100) };
parms[0].Value = lscId;
parms[1].Value = beginTime;
parms[2].Value = endTime;
parms[3].Value = queryType;
parms[4].Value = DBNull.Value;
if (queryText != null && queryText.Trim() != String.Empty)
{
parms[4].Value = queryText.Trim();
}
var appointments = new List <AppointmentInfo>();
using (var rdr = SqlHelper.ExecuteReader(SqlHelper.HisConnectionStringLocalTransaction, CommandType.Text, SqlText.Sql_Appointment_Get_His, parms)) {
while (rdr.Read())
{
var appointment = new AppointmentInfo();
appointment.LscID = lscId;
appointment.LscName = lscName;
appointment.Id = ComUtility.DBNullInt32Handler(rdr["Id"]);
appointment.StartTime = ComUtility.DBNullDateTimeHandler(rdr["StartTime"]);
appointment.EndTime = ComUtility.DBNullDateTimeHandler(rdr["EndTime"]);
appointment.LscIncluded = ComUtility.DBNullInt32Handler(rdr["LscIncluded"]);
appointment.StaIncluded = ComUtility.DBNullStringHandler(rdr["StaIncluded"]);
appointment.DevIncluded = ComUtility.DBNullStringHandler(rdr["DevIncluded"]);
appointment.ProjectId = ComUtility.DBNullStringHandler(rdr["ProjectId"]);
appointment.ProjectName = ComUtility.DBNullStringHandler(rdr["ProjectName"]);
appointment.Status = ComUtility.DBNullProjStatusHandler(rdr["Status"]);
appointment.CreaterId = ComUtility.DBNullInt32Handler(rdr["CreaterId"]);
appointment.Creater = ComUtility.DBNullStringHandler(rdr["Creater"]);
appointment.ContactPhone = ComUtility.DBNullStringHandler(rdr["ContactPhone"]);
appointment.CreatedTime = ComUtility.DBNullDateTimeHandler(rdr["CreatedTime"]);
appointment.RecordTime = ComUtility.DBNullDateTimeHandler(rdr["RecordTime"]);
appointments.Add(appointment);
}
}
return(appointments);
}
/// <summary>
/// Method to gets lsc project
/// </summary>
/// <param name="projectId">projectId</param>
/// <param name="connectionString">connectionString</param>
/// <returns>project object</returns>
public List <ProjectInfo> GetProjects(int lscId, string lscName, string projectId, string projectName, DateTime fromTime, DateTime endTime, string connectionString)
{
SqlParameter[] parms = { new SqlParameter("@ProjectId", SqlDbType.VarChar, 50),
new SqlParameter("@ProjectName", SqlDbType.VarChar, 100),
new SqlParameter("@BeginTime", SqlDbType.DateTime),
new SqlParameter("@EndTime", SqlDbType.DateTime) };
parms[0].Value = DBNull.Value;
if (projectId != null && projectId != String.Empty)
{
parms[0].Value = projectId;
}
parms[1].Value = DBNull.Value;
if (projectName != null && projectName != String.Empty)
{
parms[1].Value = projectName;
}
parms[2].Value = fromTime;
parms[3].Value = endTime;
var projects = new List <ProjectInfo>();
SqlHelper.TestConnection(connectionString);
using (var rdr = SqlHelper.ExecuteReader(connectionString, CommandType.Text, SqlText.Sql_Appointment_Get_Projects, parms)) {
while (rdr.Read())
{
var project = new ProjectInfo();
project.LscID = lscId;
project.LscName = lscName;
project.ProjectId = ComUtility.DBNullStringHandler(rdr["ProjectId"]);
project.ProjectName = ComUtility.DBNullStringHandler(rdr["ProjectName"]);
project.BeginTime = ComUtility.DBNullDateTimeHandler(rdr["BeginTime"]);
project.EndTime = ComUtility.DBNullDateTimeHandler(rdr["EndTime"]);
project.Responsible = ComUtility.DBNullStringHandler(rdr["Responsible"]);
project.ContactPhone = ComUtility.DBNullStringHandler(rdr["ContactPhone"]);
project.Company = ComUtility.DBNullStringHandler(rdr["Company"]);
project.Comment = ComUtility.DBNullStringHandler(rdr["Comment"]);
project.Enabled = ComUtility.DBNullBooleanHandler(rdr["Enabled"]);
projects.Add(project);
}
}
return(projects);
}
/// <summary>
/// Method to get lsc combobox information
/// </summary>
/// <param name="lscIds">lscIds</param>
public Dictionary <string, string> GetLscs(Dictionary <int, int> lscIds)
{
try {
var dict = new Dictionary <string, string>();
using (var rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SqlText.SQL_SELECT_COMBOBOX_GETLSCS, null)) {
while (rdr.Read())
{
var id = ComUtility.DBNullInt32Handler(rdr["LscID"]);
var name = ComUtility.DBNullStringHandler(rdr["LscName"]);
if (lscIds.ContainsKey(id))
{
dict.Add(String.Format("{0}&{1}", id, lscIds[id]), name);
}
}
}
return(dict);
} catch { throw; }
}
/// <summary>
/// Method to get LSC user
/// </summary>
/// <param name="uId">uId</param>
/// <param name="pwd">pwd</param>
public List <LscUserInfo> GetUser(string uId, string pwd)
{
SqlParameter[] parms = { new SqlParameter("@UID", SqlDbType.VarChar, 20),
new SqlParameter("@PWD", SqlDbType.VarChar, 20) };
parms[0].Value = uId;
if (pwd == null)
{
parms[1].Value = DBNull.Value;
}
else
{
parms[1].Value = pwd;
}
var lscUsers = new List <LscUserInfo>();
using (var rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SqlText.SQL_SELECT_USER_GETUSER, parms)) {
while (rdr.Read())
{
var lscUser = new LscUserInfo();
lscUser.LscID = ComUtility.DBNullInt32Handler(rdr["LscID"]);
lscUser.LscName = ComUtility.DBNullStringHandler(rdr["LscName"]);
lscUser.UserID = ComUtility.DBNullInt32Handler(rdr["UserID"]);
lscUser.UserName = ComUtility.DBNullStringHandler(rdr["UserName"]);
lscUser.UID = ComUtility.DBNullStringHandler(rdr["UID"]);
lscUser.OpLevel = ComUtility.DBNullUserLevelHandler(rdr["OpLevel"]);
lscUser.LimitTime = ComUtility.DBNullDateTimeHandler(rdr["LimitTime"]);
lscUser.TelePhone = ComUtility.DBNullStringHandler(rdr["TelePhone"]);
lscUser.MobilePhone = ComUtility.DBNullStringHandler(rdr["MobilePhone"]);
lscUser.Email = ComUtility.DBNullStringHandler(rdr["Email"]);
lscUser.Address = ComUtility.DBNullStringHandler(rdr["Address"]);
lscUser.PostalCode = ComUtility.DBNullStringHandler(rdr["PostalCode"]);
lscUser.Remark = ComUtility.DBNullStringHandler(rdr["Remark"]);
lscUser.AlarmSoundFiterItem = ComUtility.DBNullAlarmSoundFiterItemHandler(rdr["AlarmSoundFiterItem"]);
lscUser.AlarmStaticFiterItem = ComUtility.DBNullAlarmStaticFiterItemHandler(rdr["AlarmStaticFiterItem"]);
lscUser.ActiveValuesFiterItem = ComUtility.DBNullActiveValuesFiterItemHandler(rdr["ActiveValuesFiterItem"]);
lscUser.Group = null;
lscUser.UDGroups = null;
lscUser.Enabled = ComUtility.DBNullBooleanHandler(rdr["Enabled"]);
lscUsers.Add(lscUser);
}
}
return(lscUsers);
}
/// <summary>
/// Method to get trend count alarms
/// </summary>
public List <TrendAlarmInfo> GetTrendCountAlarms(int lscId, int nodeId, DateTime beginTime, DateTime endTime, float aiValue, int timeType, int valueType)
{
SqlParameter[] parms = { new SqlParameter("@LscID", SqlDbType.Int),
new SqlParameter("@AicID", SqlDbType.Int),
new SqlParameter("@BeginTime", SqlDbType.DateTime),
new SqlParameter("@EndTime", SqlDbType.DateTime),
new SqlParameter("@AIValue", SqlDbType.Real),
new SqlParameter("@TimeType", SqlDbType.Int),
new SqlParameter("@ValueType", SqlDbType.Int) };
parms[0].Value = lscId;
if (nodeId == ComUtility.DefaultInt32)
{
parms[1].Value = DBNull.Value;
}
else
{
parms[1].Value = nodeId;
}
parms[2].Value = beginTime;
parms[3].Value = endTime;
parms[4].Value = aiValue;
parms[5].Value = timeType;
parms[6].Value = valueType;
var alarms = new List <TrendAlarmInfo>();
using (var rdr = SqlHelper.ExecuteReader(SqlHelper.HisConnectionStringLocalTransaction, CommandType.Text, SqlText.SQL_SELECT_PREALARM_GETTRENDCOUNTALARMS, parms)) {
while (rdr.Read())
{
var alarm = new TrendAlarmInfo();
alarm.LscID = ComUtility.DBNullInt32Handler(rdr["LscID"]);
alarm.NodeID = ComUtility.DBNullInt32Handler(rdr["AicID"]);
alarm.StartValue = ComUtility.DBNullFloatHandler(rdr["StartValue"]);
alarm.AlarmValue = ComUtility.DBNullFloatHandler(rdr["AlarmValue"]);
alarm.DiffValue = ComUtility.DBNullFloatHandler(rdr["DiffValue"]);
alarm.StartTime = ComUtility.DBNullDateTimeHandler(rdr["StartTime"]);
alarm.EndTime = ComUtility.DBNullDateTimeHandler(rdr["EndTime"]);
alarms.Add(alarm);
}
}
return(alarms);
}
/// <summary>
/// Method to get history pictures information
/// </summary>
/// <param name="lscId">lscId</param>
/// <param name="fromTime">fromTime</param>
/// <param name="toTime">toTime</param>
/// <param name="picModels">picModels</param>
public List <PicInfo> GetHisPictures(int lscId, DateTime fromTime, DateTime toTime, string[] picModels)
{
try {
SqlParameter[] parms = { new SqlParameter("@LscID", SqlDbType.Int),
new SqlParameter("@FromTime", SqlDbType.DateTime),
new SqlParameter("@ToTime", SqlDbType.DateTime),
new SqlParameter("@PicModels", SqlDbType.NVarChar, 1024) };
parms[0].Value = lscId;
parms[1].Value = fromTime;
parms[2].Value = toTime;
if (picModels != null && picModels.Length > 0)
{
for (int i = 0; i < picModels.Length; i++)
{
picModels[i] = String.Format("\"{0}\"", picModels[i]);
}
parms[3].Value = String.Join(",", picModels);
}
else
{
parms[3].Value = DBNull.Value;
}
var pics = new List <PicInfo>();
using (var rdr = SqlHelper.ExecuteReader(SqlHelper.HisConnectionStringLocalTransaction, CommandType.Text, SqlText.SQL_SELECT_REPORT_GETHISPICTURES, parms)) {
var id = 0;
while (rdr.Read())
{
var pic = new PicInfo();
pic.LscID = ComUtility.DBNullInt32Handler(rdr["LscID"]);
pic.LscName = ComUtility.DefaultString;
pic.RtuID = ComUtility.DBNullInt32Handler(rdr["RtuID"]);
pic.PicID = ++id;
pic.PicName = ComUtility.DefaultString;
pic.PicModel = ComUtility.DBNullStringHandler(rdr["PicModel"]);
pic.PicBytes = ComUtility.DBNullBytesHandler(rdr["PicBytes"]);
pic.PicTime = ComUtility.DBNullDateTimeHandler(rdr["PicTime"]);
pics.Add(pic);
}
}
return(pics);
} catch { throw; }
}
/// <summary>
/// Method to get lscs information
/// </summary>
/// <param name="connectionString">connectionString</param>
public List <LscInfo> GetLscs(string connectionString)
{
try {
if (String.IsNullOrEmpty(connectionString))
{
connectionString = SqlHelper.ConnectionStringLocalTransaction;
}
var lscs = new List <LscInfo>();
using (var rdr = SqlHelper.ExecuteReader(connectionString, CommandType.Text, SqlText.SQL_SELECT_LSC_GETLSCS, null)) {
while (rdr.Read())
{
var 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.ChangedTime = ComUtility.DBNullDateTimeHandler(rdr["ChangedTime"]);
lsc.Enabled = ComUtility.DBNullBooleanHandler(rdr["Enabled"]);
lscs.Add(lsc);
}
}
return(lscs);
} catch { throw; }
}
/// <summary>
/// Method to get lsc information
/// </summary>
/// <param name="lscId">lscId</param>
public LscInfo GetLsc(int lscId)
{
try {
SqlParameter[] parms = { new SqlParameter("@LscID", SqlDbType.Int) };
parms[0].Value = lscId;
LscInfo lsc = null;
using (var 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.ChangedTime = ComUtility.DBNullDateTimeHandler(rdr["ChangedTime"]);
lsc.Enabled = ComUtility.DBNullBooleanHandler(rdr["Enabled"]);
}
}
return(lsc);
} catch { throw; }
}
/// <summary>
/// Method to get group
/// </summary>
/// <param name="lscId">lscId</param>
/// <param name="userId">userId</param>
public GroupInfo GetGroup(int lscId, int userId)
{
try {
SqlParameter[] parms = { new SqlParameter("@LscID", SqlDbType.Int),
new SqlParameter("@UserID", SqlDbType.Int) };
parms[0].Value = lscId;
parms[1].Value = userId;
GroupInfo group = null;
using (var rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SqlText.SQL_SELECT_GROUP_GETGROUP, parms)) {
if (rdr.Read())
{
group = new GroupInfo();
group.LscID = ComUtility.DBNullInt32Handler(rdr["LscID"]);
group.GroupID = ComUtility.DBNullInt32Handler(rdr["GroupID"]);
group.GroupName = ComUtility.DBNullStringHandler(rdr["GroupName"]);
group.GroupType = ComUtility.DBNullGroupTypeHandler(rdr["GroupType"]);
group.GroupNodes = null;
group.Enabled = ComUtility.DBNullBooleanHandler(rdr["Enabled"]);
}
}
return(group);
} catch { throw; }
}