public void Update(NodeGroupInfo nodeGroup)
{
var updateParms = new IDataParameter[]
{
GetParameter(ParmDescription, EDataType.NText, nodeGroup.Description),
GetParameter(ParmGroupName, EDataType.NVarChar, 255, nodeGroup.NodeGroupName),
GetParameter(ParmPublishmentsystemid, EDataType.Integer, nodeGroup.PublishmentSystemID)
};
ExecuteNonQuery(SqlUpdateNodegroup, updateParms);
}
private static AtomEntry ExportNodeGroupInfo(NodeGroupInfo nodeGroupInfo)
{
var entry = AtomUtility.GetEmptyEntry();
AtomUtility.AddDcElement(entry.AdditionalElements, "IsNodeGroup", true.ToString());
AtomUtility.AddDcElement(entry.AdditionalElements, "NodeGroupName", nodeGroupInfo.NodeGroupName);
AtomUtility.AddDcElement(entry.AdditionalElements, "Taxis", nodeGroupInfo.Taxis.ToString());
AtomUtility.AddDcElement(entry.AdditionalElements, "Description", nodeGroupInfo.Description);
return(entry);
}
public override void Submit_OnClick(object sender, EventArgs e)
{
var isChanged = false;
var nodeGroupInfo = new NodeGroupInfo
{
NodeGroupName = tbNodeGroupName.Text,
PublishmentSystemID = PublishmentSystemId,
Description = tbDescription.Text
};
if (Body.IsQueryExists("GroupName"))
{
try
{
DataProvider.NodeGroupDao.Update(nodeGroupInfo);
Body.AddSiteLog(PublishmentSystemId, "修改栏目组", $"栏目组:{nodeGroupInfo.NodeGroupName}");
isChanged = true;
}
catch (Exception ex)
{
FailMessage(ex, "栏目组修改失败！");
}
}
else
{
var nodeGroupNameList = DataProvider.NodeGroupDao.GetNodeGroupNameList(PublishmentSystemId);
if (nodeGroupNameList.IndexOf(tbNodeGroupName.Text) != -1)
{
FailMessage("栏目组添加失败，栏目组名称已存在！");
}
else
{
try
{
DataProvider.NodeGroupDao.Insert(nodeGroupInfo);
Body.AddSiteLog(PublishmentSystemId, "添加栏目组", $"栏目组:{nodeGroupInfo.NodeGroupName}");
isChanged = true;
}
catch (Exception ex)
{
FailMessage(ex, "栏目组添加失败！");
}
}
}
if (isChanged)
{
PageUtils.CloseModalPage(Page);
}
}
/// <summary>
/// 接続されているノード群を整列します。
/// </summary>
/// <param name="group"></param>
/// <param name="startX"></param>
/// <param name="startY"></param>
private void ArrangeGroup(NodeGroupInfo group, double startX, double startY)
{
for (var i = 0; i < group.Depth; ++i)
{
var current = group.GetByDepth(i);
var y = startY + (CalculateTempSize.Height / 2) * -current.Length;
foreach (var entry in current)
{
entry.Node.X = startX + i * CalculateTempSize.Width;
entry.Node.Y = y;
y += CalculateTempSize.Height;
}
}
}
public void Insert(NodeGroupInfo nodeGroup)
{
var maxTaxis = GetMaxTaxis(nodeGroup.PublishmentSystemID);
nodeGroup.Taxis = maxTaxis + 1;
var insertParms = new IDataParameter[]
{
GetParameter(ParmGroupName, EDataType.NVarChar, 255, nodeGroup.NodeGroupName),
GetParameter(ParmPublishmentsystemid, EDataType.Integer, nodeGroup.PublishmentSystemID),
GetParameter(ParmTaxis, EDataType.Integer, nodeGroup.Taxis),
GetParameter(ParmDescription, EDataType.NText, nodeGroup.Description)
};
ExecuteNonQuery(SqlInsertNodegroup, insertParms);
}
public NodeGroupInfo GetNodeGroupInfo(int publishmentSystemId, string groupName)
{
NodeGroupInfo nodeGroup = null;
const string sqlString = "SELECT NodeGroupName, PublishmentSystemID, Taxis, Description FROM siteserver_NodeGroup WHERE NodeGroupName = @NodeGroupName AND PublishmentSystemID = @PublishmentSystemID";
var parms = new IDataParameter[]
{
GetParameter(ParmGroupName, EDataType.NVarChar, 255, groupName),
GetParameter(ParmPublishmentsystemid, EDataType.Integer, publishmentSystemId)
};
using (var rdr = ExecuteReader(sqlString, parms))
{
if (rdr.Read())
{
var i = 0;
nodeGroup = new NodeGroupInfo(GetString(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i++), GetString(rdr, i));
}
rdr.Close();
}
return(nodeGroup);
}
