private void biAddSubArea_Click(object sender, EventArgs e)
{
Maticsoft.Model.SMT_CONTROLLER_ZONE area = GetSelectArea();
FrmControlAreaEditor areaEditor = new FrmControlAreaEditor();
areaEditor.IsAdd = true;
if (area != null)
{
areaEditor.ParentAreaID = area.ID;
}
else
{
areaEditor.ParentAreaID = 0;
}
if (areaEditor.ShowDialog(this) == DialogResult.OK)
{
Maticsoft.Model.SMT_CONTROLLER_ZONE areaAdded = areaEditor.Area;
DevComponents.AdvTree.Node node = AreaDataHelper.CreateNode(areaAdded);
if (advTreeArea.SelectedNode == null || advTreeArea.SelectedNode.Level == 0)
{
advTreeArea.Nodes[0].Nodes.Add(node);
}
else
{
advTreeArea.SelectedNode.Nodes.Add(node);
}
node.Parent.Expand();
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.SMT_CONTROLLER_ZONE model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SMT_CONTROLLER_ZONE set ");
strSql.Append("PAR_ID=@PAR_ID,");
strSql.Append("ZONE_NAME=@ZONE_NAME,");
strSql.Append("ZONE_DESC=@ZONE_DESC,");
strSql.Append("ORDER_VALUE=@ORDER_VALUE");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@PAR_ID", SqlDbType.Decimal, 9),
new SqlParameter("@ZONE_NAME", SqlDbType.NVarChar, 100),
new SqlParameter("@ZONE_DESC", SqlDbType.NVarChar, 200),
new SqlParameter("@ORDER_VALUE", SqlDbType.Int, 4),
new SqlParameter("@ID", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.PAR_ID;
parameters[1].Value = model.ZONE_NAME;
parameters[2].Value = model.ZONE_DESC;
parameters[3].Value = model.ORDER_VALUE;
parameters[4].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public decimal Add(Maticsoft.Model.SMT_CONTROLLER_ZONE model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SMT_CONTROLLER_ZONE(");
strSql.Append("PAR_ID,ZONE_NAME,ZONE_DESC,ORDER_VALUE)");
strSql.Append(" values (");
strSql.Append("@PAR_ID,@ZONE_NAME,@ZONE_DESC,@ORDER_VALUE)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@PAR_ID", SqlDbType.Decimal, 9),
new SqlParameter("@ZONE_NAME", SqlDbType.NVarChar, 100),
new SqlParameter("@ZONE_DESC", SqlDbType.NVarChar, 200),
new SqlParameter("@ORDER_VALUE", SqlDbType.Int, 4)
};
parameters[0].Value = model.PAR_ID;
parameters[1].Value = model.ZONE_NAME;
parameters[2].Value = model.ZONE_DESC;
parameters[3].Value = model.ORDER_VALUE;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToDecimal(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.SMT_CONTROLLER_ZONE DataRowToModel(DataRow row)
{
Maticsoft.Model.SMT_CONTROLLER_ZONE model = new Maticsoft.Model.SMT_CONTROLLER_ZONE();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = decimal.Parse(row["ID"].ToString());
}
if (row["PAR_ID"] != null && row["PAR_ID"].ToString() != "")
{
model.PAR_ID = decimal.Parse(row["PAR_ID"].ToString());
}
if (row["ZONE_NAME"] != null)
{
model.ZONE_NAME = row["ZONE_NAME"].ToString();
}
if (row["ZONE_DESC"] != null)
{
model.ZONE_DESC = row["ZONE_DESC"].ToString();
}
if (row["ORDER_VALUE"] != null && row["ORDER_VALUE"].ToString() != "")
{
model.ORDER_VALUE = int.Parse(row["ORDER_VALUE"].ToString());
}
}
return(model);
}
/// <summary>
/// 创建树形节点
/// </summary>
/// <param name="area">区域</param>
/// <returns>节点</returns>
public static DevComponents.AdvTree.Node CreateNode(Maticsoft.Model.SMT_CONTROLLER_ZONE area)
{
DevComponents.AdvTree.Node node = new DevComponents.AdvTree.Node(area.ZONE_NAME);
node.Tag = area;
node.Image = Properties.Resources.house1818;
node.Tooltip = area.ZONE_DESC;
return(node);
}
public static decimal AddArea(Maticsoft.Model.SMT_CONTROLLER_ZONE Area)
{
Maticsoft.BLL.SMT_CONTROLLER_ZONE bll = new Maticsoft.BLL.SMT_CONTROLLER_ZONE();
Area.ID = bll.Add(Area);
_areas.Add(Area);
return(Area.ID);
}
public static void UpdateNode(DevComponents.AdvTree.Node node, Maticsoft.Model.SMT_CONTROLLER_ZONE area)
{
if (node == null)
{
return;
}
node.Text = area.ZONE_NAME;
node.Tag = area;
node.Image = Properties.Resources.house1818;
node.Tooltip = area.ZONE_DESC;
}
private void btnOk_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(tbAreaName.Text))
{
MessageBox.Show("区域名称不能为空！");
tbAreaName.Focus();
return;
}
try
{
if (Area == null)
{
Area = new Maticsoft.Model.SMT_CONTROLLER_ZONE();
Area.ID = -1;
Area.PAR_ID = ParentAreaID == null ? 0 : (decimal)ParentAreaID;
Area.ORDER_VALUE = 100;
}
Area.ZONE_NAME = tbAreaName.Text.Trim();
Area.ZONE_DESC = tbAreaDesc.Text.Trim();
CtrlWaiting waiting = new CtrlWaiting(() =>
{
try
{
if (Area.ID == -1)
{
Area.ID = AreaDataHelper.AddArea(Area);
SmtLog.Info("区域", "添加区域：" + Area.ZONE_NAME);
}
else
{
AreaDataHelper.UpdateArea(Area);
SmtLog.Info("区域", "更新区域：" + Area.ZONE_NAME);
}
this.BeginInvoke(new Action(() =>
{
this.DialogResult = DialogResult.OK;
this.Close();
}));
}
catch (Exception ex)
{
WinInfoHelper.ShowInfoWindow(this, "保存区域异常：" + ex.Message);
log.Error("保存区域异常：", ex);
}
});
waiting.Show(this);
}
catch (Exception ex)
{
WinInfoHelper.ShowInfoWindow(this, "保存区域异常：" + ex.Message);
log.Error("保存区域异常：", ex);
}
}
/// <summary>
/// 递归创建下级节点
/// </summary>
/// <param name="root">当前节点</param>
/// <param name="areas">区域列表</param>
private static void GetSubTree(DevComponents.AdvTree.Node root, List <Maticsoft.Model.SMT_CONTROLLER_ZONE> areas)
{
Maticsoft.Model.SMT_CONTROLLER_ZONE rootarea = (Maticsoft.Model.SMT_CONTROLLER_ZONE)root.Tag;
List <Maticsoft.Model.SMT_CONTROLLER_ZONE> subAreas = areas.FindAll(m => m.PAR_ID == rootarea.ID);
subAreas.ForEach(m => areas.Remove(m));
foreach (var item in subAreas)
{
DevComponents.AdvTree.Node node = CreateNode(item);
GetSubTree(node, areas);
root.Nodes.Add(node);
}
}
public static bool UpdateArea(Maticsoft.Model.SMT_CONTROLLER_ZONE Area)
{
Maticsoft.BLL.SMT_CONTROLLER_ZONE bll = new Maticsoft.BLL.SMT_CONTROLLER_ZONE();
bool ret = bll.Update(Area);
var area = _areas.Find(m => m.ID == Area.ID);
if (area != null && area != Area)
{
_areas.Remove(area);
_areas.Add(Area);
}
else if (area == null)
{
_areas.Add(Area);
}
return(ret);
}
private void biModifyArea_Click(object sender, EventArgs e)
{
Maticsoft.Model.SMT_CONTROLLER_ZONE area = GetSelectArea();
FrmControlAreaEditor areaEditor = new FrmControlAreaEditor(area);
if (area != null)
{
areaEditor.ParentAreaID = area.PAR_ID;
}
else
{
areaEditor.ParentAreaID = 0;
}
if (areaEditor.ShowDialog(this) == DialogResult.OK)
{
Maticsoft.Model.SMT_CONTROLLER_ZONE update = areaEditor.Area;
AreaDataHelper.UpdateNode(advTreeArea.SelectedNode, update);
}
}
private void DoCreateAreaDevice(Node areaNode, List <Maticsoft.Model.SMT_FACERECG_DEVICE> devs)
{
Maticsoft.Model.SMT_CONTROLLER_ZONE zone = areaNode.Tag as Maticsoft.Model.SMT_CONTROLLER_ZONE;
if (zone != null)
{
var fdev = devs.FindAll(m => m.AREA_ID == zone.ID);
for (int i = fdev.Count - 1; i >= 0; i--)
{
var item = fdev[i];
Node doorNode = new Node("<font color='blue'>" + item.FACEDEV_NAME + "</font>");
doorNode.Tag = item;
doorNode.Image = Properties.Resources.door1818;
areaNode.Nodes.Insert(0, doorNode);
devs.Remove(item);
}
}
foreach (Node item in areaNode.Nodes)
{
DoCreateAreaDevice(item, devs);
}
}
private static void DoCreateNodes(Node node, List <Maticsoft.Model.SMT_DOOR_INFO> doors)
{
Maticsoft.Model.SMT_CONTROLLER_ZONE zone = node.Tag as Maticsoft.Model.SMT_CONTROLLER_ZONE;
if (zone != null)
{
var fdoors = doors.FindAll(m => m.AREA_ID == zone.ID);
for (int i = fdoors.Count - 1; i >= 0; i--)
{
var item = fdoors[i];
Node doorNode = new Node("<font color='blue'>" + item.DOOR_NAME + "</font>");
doorNode.Tag = item;
doorNode.Image = Properties.Resources.door1818;
node.Nodes.Insert(0, doorNode);
doors.Remove(item);
}
//node.Text += " (" + fdoors.Count + ")";
}
foreach (Node item in node.Nodes)
{
DoCreateNodes(item, doors);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.SMT_CONTROLLER_ZONE GetModel(decimal ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,PAR_ID,ZONE_NAME,ZONE_DESC,ORDER_VALUE from SMT_CONTROLLER_ZONE ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Decimal)
};
parameters[0].Value = ID;
Maticsoft.Model.SMT_CONTROLLER_ZONE model = new Maticsoft.Model.SMT_CONTROLLER_ZONE();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public FrmControlAreaEditor(Maticsoft.Model.SMT_CONTROLLER_ZONE area)
{
InitializeComponent();
Area = area;
IsAdd = false;
}
