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