private void tlOU_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e) { if (e.Node != null) { TreeListNode node = e.Node; object ID = e.Node.GetValue("Id"); object PID = e.Node.GetValue("ParentId"); model = dtAll.Find(s => s.Id.Equals(ID)); txtID.EditValue = model.Id; txtName.Text = model.DepartmentName; txtCreatTime.EditValue = model.CreateTime; txtHandNo.Text = model.SimpleCode; txtSortCode.Text = model.SortCode; tlPID.EditValue = model.ParentId; gcDataRole.DataSource = deptMg.GetRoleListByDepartmentId(clsPublic.GetObjGUID(ID)); gcDataUser.DataSource = deptMg.GetUserListByDepartmentId(clsPublic.GetObjGUID(ID)); if (node.GetValue("DepartmentName").ToString() != "株洲紫气东来商贸有限公司") { sbtnSave.Enabled = true; } else { sbtnSave.Enabled = false; } } }
/// <summary> /// 新增部门 /// </summary> /// <param name="model">实体</param> /// <returns></returns> public bool AddNew(Models.ACL_Department model) { SqlParameter[] Param = new SqlParameter[] { new SqlParameter("@Id", model.Id), new SqlParameter("@DepartmentName", model.DepartmentName), new SqlParameter("@SimpleCode", model.SimpleCode), new SqlParameter("@SortCode", model.SortCode), new SqlParameter("@ParentId", model.ParentId), new SqlParameter("@CreateTime", model.CreateTime), new SqlParameter("@IsRemoved", model.IsRemoved) }; return(Models.SqlHelper.ExecuteNoQuery(@"INSERT INTO [dbo].[ACL_Department] ([Id] ,[DepartmentName] ,[SimpleCode] ,[SortCode] ,[ParentId] ,[CreateTime] ,[IsRemoved]) VALUES (@Id ,@DepartmentName ,@SimpleCode ,@SortCode ,@ParentId ,@CreateTime ,@IsRemoved)", Param) > 0 ? true : false); }
/// <summary> /// 新增方法 /// </summary> public override void AddNew() { model = new Models.ACL_Department(); txtID.Text = "新ID"; txtName.Text = ""; txtCreatTime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); txtSortCode.Text = ""; tlPID.EditValue = null; txtHandNo.EditValue = ""; sbtnSave.Enabled = true; }
/// <summary> /// 删除方法 /// </summary> public override void Delete() { TreeListNode node = tlDepartment.FocusedNode; if (node != null) { if (node.Nodes.Count > 0) { clsPublic.ShowMessage("该机构下面有子机构,不能删除!"); } else { Guid DepartmentId = (Guid)node.GetValue("Id"); if (deptMg.ExistsUserById(DepartmentId)) { clsPublic.ShowMessage("该机构下面有用户,不能删除!"); return; } else { if (clsPublic.GetMessageBoxYesNoResult("是否删除该机构,删除将不能恢复?", "提示")) { if (deptMg.Delete(DepartmentId)) { Models.ACL_Department model = dtAll.Find(s => s.Id.Equals(clsPublic.GetObjGUID(DepartmentId))); dtAll.Remove(model); tlDepartment.RefreshDataSource(); tlPID.Properties.TreeList.RefreshDataSource(); clsPublic.ShowMessage("删除成功!"); } else { clsPublic.ShowMessage("删除失败!"); } } } } } }
/// <summary> /// 修改部门 /// </summary> /// <param name="model">实体</param> /// <returns></returns> public bool Modify(Models.ACL_Department model) { SqlParameter[] Param = new SqlParameter[] { new SqlParameter("@Id", model.Id), new SqlParameter("@DepartmentName", model.DepartmentName), new SqlParameter("@SimpleCode", model.SimpleCode), new SqlParameter("@SortCode", model.SortCode), new SqlParameter("@ParentId", model.ParentId), new SqlParameter("@CreateTime", model.CreateTime), new SqlParameter("@IsRemoved", model.IsRemoved) }; return(Models.SqlHelper.ExecuteNoQuery(@"UPDATE [dbo].[ACL_Department] SET [DepartmentName] = @DepartmentName ,[SimpleCode] = @SimpleCode ,[SortCode] = @SortCode ,[ParentId] = @ParentId ,[CreateTime] = @CreateTime ,[IsRemoved] = @IsRemoved WHERE [Id] = @Id", Param) > 0 ? true : false); }
/// <summary> /// 修改部门 /// </summary> /// <param name="model">实体</param> /// <returns></returns> public bool Modify(Models.ACL_Department model) { return(Sev.Modify(model)); }
/// <summary> /// 新增部门 /// </summary> /// <param name="model">实体</param> /// <returns></returns> public bool AddNew(Models.ACL_Department model) { return(Sev.AddNew(model)); }