public Dictionary <int, List <ChannelGroupInfo> > GetAllChannelGroups()
{
var allDict = new Dictionary <int, List <ChannelGroupInfo> >();
var sqlString =
$"SELECT GroupName, SiteId, Taxis, Description FROM {TableName} ORDER BY Taxis DESC, GroupName";
using (var rdr = ExecuteReader(sqlString))
{
while (rdr.Read())
{
var i = 0;
var group = new ChannelGroupInfo(GetString(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i++),
GetString(rdr, i));
List <ChannelGroupInfo> list;
allDict.TryGetValue(group.SiteId, out list);
if (list == null)
{
list = new List <ChannelGroupInfo>();
}
list.Add(group);
allDict[group.SiteId] = list;
}
rdr.Close();
}
return(allDict);
}
/// <summary>
/// Конструктор группы каналов.
/// </summary>
/// <param name="aGroupInfo">Ссылка на конфигурацию.</param>
public ChannelGroup(ChannelGroupInfo aGroupInfo)
{
if (aGroupInfo == null) {
throw new ArgumentNullException("aGroupInfo");
}
groupInfo = aGroupInfo;
}
/// <summary>
/// Конструктор по умолчанию.
/// </summary>
public OutChannelInfoImpl()
{
device = null;
channelNumber = 0;
group = null;
deviceId = 0;
groupId = 0;
}
public void Update(ChannelGroupInfo groupInfo)
{
var sqlString = $"UPDATE {TableName} SET Description = @Description WHERE GroupName = @GroupName AND SiteId = @SiteId";
var updateParms = new IDataParameter[]
{
GetParameter(ParmDescription, DataType.Text, groupInfo.Description),
GetParameter(ParmGroupName, DataType.VarChar, 255, groupInfo.GroupName),
GetParameter(ParmSiteId, DataType.Integer, groupInfo.SiteId)
};
ExecuteNonQuery(sqlString, updateParms);
}
public static AtomEntry Export(ChannelGroupInfo groupInfo)
{
var entry = AtomUtility.GetEmptyEntry();
AtomUtility.AddDcElement(entry.AdditionalElements, "IsNodeGroup", true.ToString());
AtomUtility.AddDcElement(entry.AdditionalElements, new List <string> {
nameof(ChannelGroupInfo.GroupName), "NodeGroupName"
}, groupInfo.GroupName);
AtomUtility.AddDcElement(entry.AdditionalElements, nameof(ChannelGroupInfo.Taxis), groupInfo.Taxis.ToString());
AtomUtility.AddDcElement(entry.AdditionalElements, nameof(ChannelGroupInfo.Description), groupInfo.Description);
return(entry);
}
public override void Submit_OnClick(object sender, EventArgs e)
{
var isChanged = false;
var nodeGroupInfo = new ChannelGroupInfo
{
GroupName = TbNodeGroupName.Text,
SiteId = SiteId,
Description = TbDescription.Text
};
if (AuthRequest.IsQueryExists("GroupName"))
{
try
{
DataProvider.ChannelGroupDao.Update(nodeGroupInfo);
AuthRequest.AddSiteLog(SiteId, "修改栏目组", $"栏目组:{nodeGroupInfo.GroupName}");
isChanged = true;
}
catch (Exception ex)
{
FailMessage(ex, "栏目组修改失败！");
}
}
else
{
var nodeGroupNameList = DataProvider.ChannelGroupDao.GetGroupNameList(SiteId);
if (nodeGroupNameList.IndexOf(TbNodeGroupName.Text) != -1)
{
FailMessage("栏目组添加失败，栏目组名称已存在！");
}
else
{
try
{
DataProvider.ChannelGroupDao.Insert(nodeGroupInfo);
AuthRequest.AddSiteLog(SiteId, "添加栏目组", $"栏目组:{nodeGroupInfo.GroupName}");
isChanged = true;
}
catch (Exception ex)
{
FailMessage(ex, "栏目组添加失败！");
}
}
}
if (isChanged)
{
LayerUtils.Close(Page);
}
}
public void Insert(ChannelGroupInfo groupInfo)
{
var maxTaxis = GetMaxTaxis(groupInfo.SiteId);
groupInfo.Taxis = maxTaxis + 1;
var sqlString = $"INSERT INTO {TableName} (GroupName, SiteId, Taxis, Description) VALUES (@GroupName, @SiteId, @Taxis, @Description)";
var insertParms = new IDataParameter[]
{
GetParameter(ParmGroupName, DataType.VarChar, 255, groupInfo.GroupName),
GetParameter(ParmSiteId, DataType.Integer, groupInfo.SiteId),
GetParameter(ParmTaxis, DataType.Integer, groupInfo.Taxis),
GetParameter(ParmDescription, DataType.Text, groupInfo.Description)
};
ExecuteNonQuery(sqlString, insertParms);
}
public ChannelGroupInfo GetGroupInfo(int siteId, string groupName)
{
ChannelGroupInfo group = null;
const string sqlString = "SELECT GroupName, SiteId, Taxis, Description FROM siteserver_ChannelGroup WHERE GroupName = @GroupName AND SiteId = @SiteId";
var parms = new IDataParameter[]
{
GetParameter(ParmGroupName, DataType.VarChar, 255, groupName),
GetParameter(ParmSiteId, DataType.Integer, siteId)
};
using (var rdr = ExecuteReader(sqlString, parms))
{
if (rdr.Read())
{
var i = 0;
group = new ChannelGroupInfo(GetString(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i++), GetString(rdr, i));
}
rdr.Close();
}
return(group);
}
/// <summary>
/// Изменяет группу каналов.
/// </summary>
/// <param name="aGroup">Группа каналов.</param>
public void SetGroup( ChannelGroupInfo aGroup )
{
group = aGroup;
}
