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