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; }