/// <summary> /// 修改 /// </summary> /// <param name="dal"></param> /// <param name="dept"></param> /// <param name="editUser"></param> /// <returns></returns> public static bool Update(IDal dal, CDept dept, string editUser) { int i; dal.Execute("UPDATE tDept SET DeptName=@DeptName ,EditDate=GETDATE(),EditUser=@EditUser WHERE Id=@Id", out i, dal.CreateParameter("@DeptName", dept.DeptName.Trim()), dal.CreateParameter("@EditUser", editUser), dal.CreateParameter("@Id", dept.Id)); return(i == 1); }
// POST api/deptapi public CDept Post(CDept value) { var user = (CSign)HttpContext.Current.Session[ConfigurationManager.AppSettings["AuthSaveKey"]]; if (user == null) { throw new HttpResponseException(new SiginFailureMessage()); } using (var dal = DalBuilder.CreateDal(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString, 0)) { bool ok; try { dal.Open(); ok = DeptBll.Create(dal, value, string.Format("{0}-{1}", user.UserCode, user.UserName)); } catch (Exception ex) { if (ex.Message.StartsWith("违反了 UNIQUE KEY 约束")) { throw new HttpResponseException(new PrimaryRepeatedMessge()); } LogBll.Write(dal, new CLog { LogUser = string.Format("{0}-{1}", user.UserCode, user.UserName), LogContent = string.Format("{0}#{1}", "Dept.Post", ex.Message), LogType = LogType.系统异常 }); throw new HttpResponseException(new SystemExceptionMessage()); } if (!ok) { LogBll.Write(dal, new CLog { LogContent = string.Format("新建部门{0}-{1}", value.DeptCode, value.DeptName), LogType = LogType.操作失败, LogUser = string.Format("{0}-{1}", user.UserCode, user.UserName) }); throw new HttpResponseException(new DealFailureMessage()); } LogBll.Write(dal, new CLog { LogContent = string.Format("新建部门{0}-{1}", value.DeptCode, value.DeptName), LogType = LogType.操作成功, LogUser = string.Format("{0}-{1}", user.UserCode, user.UserName) }); dal.Close(); return(value); } }
public static bool Delete(IDal dal, int id, out CDept hisDept) { int i; hisDept = Get(dal, id); if (hisDept == null) { return(false); } dal.BeginTran(); dal.Execute("UPDATE tUser SET DeptCode=null WHERE DeptCode=@DeptCode", out i, dal.CreateParameter("@DeptCode", hisDept.DeptCode)); dal.Execute("DELETE FROM tDept WHERE Id=@Id", out i, dal.CreateParameter("@Id", id)); dal.CommitTran(); return(true); }
/// <summary> /// 新建部门 /// </summary> /// <param name="dal"></param> /// <param name="dept"></param> /// <param name="editUser"></param> /// <returns></returns> public static bool Create(IDal dal, CDept dept, string editUser) { int i; dal.Execute("INSERT INTO tDept( DeptCode ,DeptName ,ParentCode ,BuildUser ,EditUser) VALUES ( @DeptCode ,@DeptName ,@ParentCode ,@BuildUser ,@EditUser )", out i, dal.CreateParameter("@DeptCode", dept.DeptCode.Trim()), dal.CreateParameter("@DeptName", dept.DeptName.Trim()), dal.CreateParameter("@ParentCode", dept.ParentCode.Trim()), dal.CreateParameter("@BuildUser", editUser), dal.CreateParameter("@EditUser", editUser)); if (i == 0) { return(false); } var dt = dal.Select("SELECT Id FROM dbo.tDept WHERE DeptCode=@DeptCode", out i, dal.CreateParameter("@DeptCode", dept.DeptCode)); if (i == 0) { return(false); } dept.Id = Convert.ToInt16(dt.Rows[0]["Id"]); return(true); }
private void SelectDept(TreeNodeCollection nodes, CDept targetDept) { if (LoggingService.IsDebugEnabled) { LoggingService.DebugFormatted("在列表中查找部门:{0}", new object[] { targetDept.Name }); } List<CDept> list = new List<CDept>(); list.Add(targetDept); while (!string.IsNullOrEmpty(list[0].ParentID)) { list.Insert(0, list[0].Parent); } foreach (CDept dept in list) { for (int i = 0; i < nodes.Count; i++) { TreeNode node = nodes[i]; if (node.Tag is CDept) { CDept tag = (CDept) node.Tag; if (tag.Id == dept.Id) { if ((node.Nodes.Count == 1) && (node.Nodes[0].Text == "Load...")) { this.LoadDeptChildren(node, dept); } if (targetDept.Id == tag.Id) { base.SelectedNode = node; return; } nodes = node.Nodes; break; } } } } }
private void LoadDeptChildren(TreeNode node, CDept dept) { if (LoggingService.IsDebugEnabled) { LoggingService.DebugFormatted("加载部门:{0}的子部门与人员", new object[] { dept.Name }); } node.Nodes.Clear(); foreach (CDept dept2 in dept.Children) { this.AddDeptNode(node, dept2); } foreach (CStaffDept dept3 in OGMService.LazyLoadStaffDepts(dept)) { this.AddDeptStaffNode(node, dept3); } }
private TreeNode AddDeptNode(TreeNode parentNode, CDept dept) { if (this.LoadAllDept() || dept.IsActive) { this.ForceCreateControl(); return (base.Invoke(new AddNode(this.AddNodeDelegate), new object[] { (parentNode == null) ? base.Nodes : parentNode.Nodes, dept.Name, this.mImageIndexOfDept, dept, true }) as TreeNode); } return null; }
private bool CheckAuthDept(CDept dept) { if (SecurityUtil.IsCanAccess("AdminData,Admin")) { return true; } ArrayList list = new ArrayList(); list.Add(dept.Id); for (CDept dept2 = dept.Parent; dept2 != null; dept2 = dept2.Parent) { list.Add(dept2.Id); } IList<string> currentPrincipalAuthResourcesByType = null; try { currentPrincipalAuthResourcesByType = SecurityUtil.GetCurrentPrincipalAuthResourcesByType<string>("YWCX_DEPT"); } catch (Exception exception) { LoggingService.ErrorFormatted("发生安全异常:{0}\r\n{1}", new object[] { exception.Message, exception.StackTrace }); return false; } foreach (string str in list) { if (currentPrincipalAuthResourcesByType.Contains(str)) { return true; } } return false; }