/// <summary> /// 获得排序号 /// </summary> /// <param name="menucode"></param> /// <returns></returns> public string GetSortNum(HttpContext context) { string pcode = context.Request.QueryString["pcode"]; List <Sys_Department> lists = bll.FindWhere(" Department_Code ='" + pcode + "'"); if (lists.Count > 0) { List <Sys_Department> list = bll.FindWhere(" Department_ParentCode ='" + pcode + "'"); if (list.Count > 0) { Sys_Department model = list.OrderByDescending(p => p.Department_Sequence).First(); return((model.Department_Sequence + 1).ToString()); } else { return("1"); } } else { return("0"); } }
public AjaxMessage CreateDepartment(Sys_Department _department) { AjaxMessage ajax = new AjaxMessage(); ajax.IsSuccess = false; ajax.Message = ""; if (_department != null) { var parentDepartment = _departmentService.GetByID(_department.Parent); _department.EmployeeID = User.Identity.Name.ToInt32(); _department.CreateTime = DateTime.Now; if (_department.Parent == 0) { _department.ItemLevel = 1; } else { _department.ItemLevel = parentDepartment.ItemLevel + 1; } _department.SortOrder = _departmentService.GetMaxSort(_department.ItemLevel.ToString().ToInt32(), _department.Parent.ToString().ToInt32()); _department.Status = (byte)SysStatus.Enable; int result = _departmentService.Insert(_department); if (result > 0) { ajax.IsSuccess = true; ajax.Message = "添加成功"; } } return(ajax); }
public string Delete(HttpContext context) { string pcode = context.Request.QueryString["pcode"]; List <Sys_UserInfo> userList = bllUser.GetList(p => p.UserInfo_DepCode == pcode).ToList(); //FindWhere(" UserInfo_DepCode='" + pcode + "'"); List <Sys_Department> list = bll.GetList(p => p.Department_ParentCode == pcode && p.Department_IsDel == "0").ToList(); //FindWhere(" Department_ParentCode='" + pcode + "' AND Department_IsDel=0"); if (userList.Count > 0) { return("2"); } else { if (list.Count > 0) { return("0"); } else { Sys_Department Department = bll.Get(p => p.Department_Code == pcode); Department.Department_IsDel = "1"; //bool rtn = bll.DeleteWhere("Department_Code='" + pcode + "'"); bool rtn = bll.Update(Department); if (rtn) { return("1"); } else { return("0"); } } } }
public void ShowScope() { Sys_DepartmentBLL depbll = new Sys_DepartmentBLL(); Sys_Notice sn = snBll.Get(p => p.NoticeID == hid_Id.Value); string val = sn.Notice_Scope; if (val != null) { hid_DepId.Value = val; string str = ""; string[] spl = val.Split(','); foreach (string item in spl) { Sys_Department depmode = depbll.Get(p => p.Department_Code == item); if (depmode != null) { str += depmode.Department_Name + ","; } } if (!str.IsNullOrEmpty()) { str = str.Substring(0, str.Length - 1); } UCDepartmentTreeText1.Text = str; } }
public ActionResult DeptEdit(int id = 0, int parentId = 0) { string childs = ""; Sys_Department model = AllDepartments.Find(p => p.DepartmentId == id); if (model == null) { model = new Sys_Department { DepartmentId = id, ParentDeptId = parentId, DeptCode = "", DeptName = "", Remark = "" } } ; else { var list = new List <int>(); GetChildDeptIds(model.DepartmentId, list); childs = list.Aggregate("", (current, deptId) => current + (deptId + ",")); } if (model.ParentDeptId == 0) { model.parentDeptName = CommonLanguage.ParentDept; } else { model.parentDeptName = AllDepartments.Find(p => p.DepartmentId == model.ParentDeptId).DeptNameShow; } ViewBag.model = model; ViewBag.childs = childs; return(View()); }
/// <summary> /// </summary> /// <param name="deptId"></param> /// <param name="parentId"></param> public void ChangeDeptParentId(int deptId, int parentId) { Sys_Department model = _deptDB.Get(deptId); model.ParentDeptId = parentId; Update(model); }
public int GetTopManangerByEmployeeId(int employeeID) { Sys_Employee objResult = GetByID(employeeID); Department objDepartmentBLL = new Department(); Sys_Department depart = objDepartmentBLL.GetByID(objResult.DepartmentID); return(depart.DepartmentManager.Value); }
public int AddDepartment(Sys_Department saveDepart) { string sql = "insert into Sys_Department(DepartmentName,Email,DepartmentCode,PhoneNo,EnteredBy,EnteredDate,LastUpdatedBy,LastUpdatedDate," + "IsDeleted,DeletedBy,DeletedDate)" + " values(@DepartmentName,@Email,@DepartmentCode,@PhoneNo,@EnteredBy,@EnteredDate,0,null," + "0,0,null)"; using (var db = DbHelper.GetDBConnection()) { int id = db.Query <int>(sql, saveDepart).SingleOrDefault(); db.Close(); return(id); } }
/// <summary> /// @author;wp /// @datetime:2016-08-01 /// @desc: 获取部门 /// </summary> /// <param name="Source">部门Id</param> /// <returns></returns> public string GetDepartmentName(object Source) { if (Source != null) { int DepartmentID = Source.ToString().ToInt32(); Sys_Department _empDepart = _departService.GetByID(DepartmentID); if (_empDepart != null) { return(_empDepart.DepartmentName); } } return(""); }
public ActionResult Create(FormCollection frm) { Sys_Department saveDepart = new Sys_Department(); saveDepart.DepartmentName = frm["DepartmentName"]; saveDepart.DepartmentCode = frm["DepartmentCode"].ToUpper(); saveDepart.Email = frm["Email"]; saveDepart.PhoneNo = Convert.ToInt32(frm["PhoneNo"]); saveDepart.EnteredDate = DateTime.Now; saveDepart.EnteredBy = Convert.ToInt32(Session["UserId"]); db.AddDepartment(saveDepart); return(RedirectToAction("Index")); }
public ActionResult Edit(FormCollection frm, int?id) { Sys_Department updateDepart = new Sys_Department(); updateDepart.DepartmentName = frm["DepartmentName"]; updateDepart.DepartmentCode = frm["DepartmentCode"].ToUpper(); updateDepart.Email = frm["Email"]; updateDepart.PhoneNo = Convert.ToInt32(frm["PhoneNo"]); updateDepart.LastUpdatedDate = DateTime.Now; updateDepart.LastUpdatedBy = Convert.ToInt32(Session["UserId"]); db.UpdateDepartment(updateDepart, (int)id); return(RedirectToAction("Index")); }
public string ShowInfo(HttpContext context) { string code = context.Request.QueryString["code"]; Sys_Department model = bll.Get(p => p.Department_Code == code); if (model != null) { string json = model.ToJson <Sys_Department>(); return(json); } else { return("0"); } }
public string GetManagedDepartments(int EmployeeID) { Sys_Employee sys_Employee = ObjEntity.Sys_Employee.Where(C => C.EmployeeID == EmployeeID).FirstOrDefault(); if (sys_Employee != null) { Sys_Department sys_Department = ObjEntity.Sys_Department.Where(C => C.DepartmentID == sys_Employee.DepartmentID).FirstOrDefault(); if (sys_Department != null) { string sortOrder = sys_Department.SortOrder; List <int> departmentIDList = ObjEntity.Sys_Department.Where(C => C.SortOrder.StartsWith(sortOrder)).Select(C => C.DepartmentID).ToList(); return(string.Join(",", departmentIDList)); } } return(string.Empty); }
public string Modify(HttpContext context) { string name = context.Request.QueryString["name"]; string id = context.Request.QueryString["id"]; string sort = context.Request.QueryString["sort"]; string content = context.Request.QueryString["content"]; string type = context.Request.QueryString["type"]; string personCharge = context.Request.QueryString["personCharge"]; string teachers = context.Request.QueryString["teachers"]; string students = context.Request.QueryString["students"]; string depClass = context.Request.QueryString["depClass"]; Sys_Department depmodel = bll.Get(p => p.DepartmentID == id); if (depmodel == null) { return("0"); } else { depmodel.DepartmentID = id; depmodel.Department_Name = name; depmodel.Department_Sequence = int.Parse(sort); depmodel.Department_Type = type; //depmodel.Department_PersonCharge = personCharge; //depmodel.Department_Class = depClass; //if (!string.IsNullOrEmpty(teachers)) //{ // depmodel.Department_Teachers = int.Parse(teachers); //} //if (!string.IsNullOrEmpty(students)) //{ // depmodel.Department_Students = int.Parse(students); //} string msg = string.Empty; if (bll.Update(depmodel)) { return("1"); } else { return("0"); } } }
public void Add(AddDepartmentInput input) { input.Validate(); Sys_Department entity = this.CreateEntity <Sys_Department>(); entity.Name = input.Name; entity.EnCode = input.EnCode; entity.Manager = input.Manager; entity.Telephone = input.Telephone; entity.MobilePhone = input.MobilePhone; entity.WeChat = input.WeChat; entity.Fax = input.Fax; entity.Email = input.Email; entity.SortCode = input.SortCode; entity.Description = input.Description; this.DbContext.Insert(entity); }
public ActionResult Index() { var service = this.CreateService <IEntityAppService>(); Sys_User user = service.GetByKey <Sys_User>(this.CurrentSession.UserId); Sys_Department department = string.IsNullOrEmpty(user.DepartmentId) ? null : service.GetByKey <Sys_Department>(user.DepartmentId); Sys_Duty duty = string.IsNullOrEmpty(user.DutyId) ? null : service.GetByKey <Sys_Duty>(user.DutyId); Sys_Role role = string.IsNullOrEmpty(user.RoleId) ? null : service.GetByKey <Sys_Role>(user.RoleId); UserModel model = new UserModel(); model.User = user; model.DepartmentName = department == null ? null : department.Name; model.DutyName = duty == null ? null : duty.Name; model.RoleName = role == null ? null : role.Name; this.ViewBag.UserInfo = model; return(View()); }
public bool UpdateDepartment(Sys_Department updateDepart, int Id) { string sql = " Update Sys_Department set DepartmentName=@DepartmentName, Email=@Email, DepartmentCode=@DepartmentCode, PhoneNo=@PhoneNo," + "LastUpdatedDate=@LastUpdatedDate, LastUpdatedBy=@LastUpdatedBy where IsDeleted=0 and DepartmentId= " + Id; using (var db = DbHelper.GetDBConnection()) { var lst = db.Execute(sql, updateDepart); db.Close(); if (lst > 0) { return(true); } else { return(false); } } }
/// <summary> /// 新增 /// </summary> public string Add(HttpContext context) { string name = context.Request.QueryString["name"]; string pcode = context.Request.QueryString["pcode"]; string sort = context.Request.QueryString["sort"]; string content = context.Request.QueryString["content"]; string type = context.Request.QueryString["type"]; string depClass = context.Request.QueryString["depClass"]; string personCharge = context.Request.QueryString["personCharge"]; string teachers = context.Request.QueryString["teachers"]; string students = context.Request.QueryString["students"]; //组织单位对象 Sys_Department depmodel = new Sys_Department(); depmodel.DepartmentID = Guid.NewGuid().ToString(); depmodel.Department_ParentCode = pcode; depmodel.Department_Name = name; depmodel.Department_Level = (bll.Get(p => p.Department_Code == pcode).Department_Level + 1);; depmodel.Department_Respon = content; depmodel.Department_Sequence = int.Parse(sort); depmodel.Department_Code = bll.GetCode(pcode, "son"); depmodel.Department_AddTime = DateTime.Now; depmodel.Department_Type = type; //depmodel.Department_Class = depClass; //depmodel.Department_PersonCharge = personCharge; depmodel.Department_IsDel = "0"; //新增组织机构 bool abl = bll.Add(depmodel); if (abl) { return("1"); } else { return("0"); } }
public AjaxMessage DeleteDepartment(int DepartmentId) { AjaxMessage ajax = new AjaxMessage(); ajax.IsSuccess = false; ajax.Message = ""; if (DepartmentId != 0 && !string.IsNullOrEmpty(DepartmentId.ToString())) { Sys_Department department = _departmentService.GetByID(DepartmentId); int result = _departmentService.Delete(department); if (result > 0) { ajax.IsSuccess = true; ajax.Message = "删除成功"; } } return(ajax); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; context.Request.ContentEncoding = Encoding.GetEncoding("UTF-8"); StringBuilder sb = new StringBuilder(); string parentId = string.Empty; if (!string.IsNullOrEmpty(context.Request.QueryString["id"])) { parentId = context.Request.QueryString["id"]; } if (!string.IsNullOrEmpty(parentId)) { Sys_UserInfo entity = bll.Get(p => p.UserInfoID == parentId); if (entity != null) { string post = ""; string postN = ""; string name = entity.UserInfo_FullName; string ment = entity.UserInfo_DepCode; Sys_DepartmentBLL mentsbll = new Sys_DepartmentBLL(); Sys_Department ments = mentsbll.Get(p => p.Department_Code == ment); post = entity.UserInfo_Post; Sys_Post po = pobll.Get(p => p.PostID == post); if (po != null) { postN = po.Post_Name; } string mentss = ments.Department_Name; var Data = new { name = name, mentss = mentss, post = post, postN = postN }; string jsonPerson = JsonConvert.SerializeObject(Data); context.Response.Write(jsonPerson); } } else { context.Response.Write("{\"data\":\"error\"}"); } }
public AjaxMessage UpdateDepartment(Sys_Department _department) { AjaxMessage ajax = new AjaxMessage(); ajax.IsSuccess = false; ajax.Message = ""; if (_department != null) { Sys_Department department = _departmentService.GetByID(_department.DepartmentID); department.DepartmentName = _department.DepartmentName; int result = _departmentService.Update(department); if (result > 0) { ajax.IsSuccess = true; ajax.Message = "修改成功"; } } return(ajax); }
public JsonResult SaveDept(int deptId, string deptCode, string deptName, string deptDesc, int parentId) { try { if (deptBL.Exists(deptCode, deptName, deptId)) { return(Json(new { result = 0, content = "部门代码或部门名称重复!" }, JsonRequestBehavior.AllowGet)); } Sys_Department model = AllDepartments.Find(p => p.DepartmentId == deptId); if (model == null) { model = new Sys_Department(); } model.DepartmentId = deptId; model.DeptCode = deptCode; model.DeptName = deptName; model.Remark = deptDesc; model.ParentDeptId = parentId; if (model.DepartmentId == 0) { deptBL.Add(model); AllDepartments.Add(model); } else { deptBL.Update(model); } lock (lockobj) { RefreshDepartmentCache(); } return(Json(new { result = 1, content = "保存成功" }, JsonRequestBehavior.AllowGet)); } catch { return(Json(new { result = 0, content = "保存失败" }, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// / /// </summary> public void show() { Sys_DepartmentBLL depbll = new Sys_DepartmentBLL(); if (!string.IsNullOrEmpty(id)) { Sys_PostBLL bllPost = new Sys_PostBLL(); modelGwxx = bllPost.Get(p => p.PostID == id); if (modelGwxx != null) { this.txtGwName.Text = modelGwxx.Post_Name; this.txtpx.Text = modelGwxx.Post_Sort.ToString(); depmodel = depbll.Get(p => p.Department_Code == modelGwxx.Post_DepCode); if (depmodel != null) { this.txt_depName.Text = depmodel.Department_Name; } } } else { if (!string.IsNullOrEmpty(hid_DepCode)) { depmodel = depbll.Get(p => p.Department_Code == hid_DepCode); if (depmodel != null) { this.txt_depName.Text = depmodel.Department_Name; } } else { depmodel = depbll.Get(p => p.Department_Code == "001"); if (depmodel != null) { this.txt_depName.Text = depmodel.Department_Name; } } } }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model"></param> public void Add(Sys_Department model) { using (IDbConnection conn = OpenConnection()) { const string sqlwhere = @"insert into Sys_Department(DeptCode,DeptName,ParentDeptId,Remark,TypeNum,DeptGrade,OldDeptId) values(@DeptCode,@DeptName,@ParentDeptId,@Remark,@TypeNum,@DeptGrade,@OldDeptId) SELECT @@Identity AS ID "; var param = new { model.DeptCode, model.DeptName, model.ParentDeptId, model.Remark, model.TypeNum, model.DeptGrade, model.OldDeptId }; decimal id = conn.Query <decimal>(sqlwhere, param).FirstOrDefault(); model.DepartmentId = decimal.ToInt32(id); } }
protected void Page_Load(object sender, EventArgs e) { //this.UCEasyUIDataGrid.AddClick += new UserControls.UCGrid.AddClickEventHandler(btn_AddClick); //this.UCEasyUIDataGrid.ModifyClick += new UserControls.UCGrid.ModifyClickEventHandler(btn_ModifyClick); //this.UCEasyUIDataGrid.DeleteClick += new UserControls.UCGrid.DeleteClickEventHandler(DelInfo); //this.UCGrid.CheckAllDeleteClick += new UserControls.UCGrid.CheckAllDeleteClickEventHandler(DelCheckBoxInfo); hid_DepCode = base.RequstStr("depCode") == "" ? "0" : base.RequstStr("depCode"); Sys_Department deptModel = depdll.Get(p => p.Department_Code == (hid_DepCode == "0" ? "001" : hid_DepCode)); string str = hid_DepCode == "0" ? "001" : hid_DepCode; //List<Sys_Department> deptModel = depdll.FindWhere(p => p.Department_Code==str); //if (deptModel.Count>0) //{ // foreach (Sys_Department item in deptModel) //// { // txt_depName.Value = deptModel.Department_Name; // } // } InitGrid(); }
public AjaxMessage GetDepartmentById(int parentId, int Department) { AjaxMessage ajax = new AjaxMessage(); ajax.IsSuccess = false; ajax.Message = ""; if (Department == 0) { if (parentId != 0 && !string.IsNullOrEmpty(parentId.ToString())) { Sys_Department department = _departmentService.GetByID(parentId); if (department != null) { ajax.IsSuccess = true; ajax.Value = department.DepartmentName; ajax.Message = "加载成功"; } } } else if (Department != 0) { Sys_Department department = _departmentService.GetByID(Department); string parentName = "顶级部门"; if (parentId != 0) { Sys_Department parentDepartment = _departmentService.GetByID(parentId); parentName = parentDepartment.DepartmentName; } ajax.IsSuccess = true; string[] name = new string[2]; name[0] = department.DepartmentName; name[1] = parentName; ajax.Name = name; ajax.Message = "加载成功"; } return(ajax); }
public AjaxMessage SetDepartmentManager(int EmployeeId, int DepartmentId) { AjaxMessage ajax = new AjaxMessage(); ajax.IsSuccess = false; ajax.Message = ""; try { Sys_Department department = _departmentService.GetByID(DepartmentId); department.DepartmentManager = EmployeeId; int result = _departmentService.Update(department); if (result > 0) { ajax.IsSuccess = true; ajax.Message = "修改成功"; } } catch (Exception e) { ajax.Message = e.Message; } return(ajax); }
public JsonResult _Save(Sys_Department entity, AdminCredential User) { if (entity.ID == 0) { List <Sys_Department> rtlist = service.GetAll().Where(c => c.Name == entity.Name).ToList(); if (rtlist.Count > 0) { ItemResult <int> item = new ItemResult <int>(); item.Success = false; item.Message = "部门名称不能重复,请修改名称后,重新保存。"; return(Json(item, JsonRequestBehavior.DenyGet)); } else { ApplicationContext.Cache.Remove(EntityName + entity.ID); return(Json(service.Insert(entity), JsonRequestBehavior.DenyGet)); } } else { List <Sys_Department> Irtlist = service.GetAll().Where(c => c.Name == entity.Name && c.ID != entity.ID).ToList(); if (Irtlist.Count > 0) { ItemResult <int> item = new ItemResult <int>(); item.Success = false; item.Message = "部门名称不能重复,请修改名称后,重新保存。"; return(Json(item, JsonRequestBehavior.DenyGet)); } else { entity.UpdateTime = DateTime.Now; entity.UpdateUserID = User.ID; return(Json(service.Update(entity), JsonRequestBehavior.DenyGet)); } } }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">要更新的实体对象</param> /// <returns>成功返回True,失败返回False</returns> public bool Update(Sys_Department model) { using (IDbConnection conn = OpenConnection()) { const string sqlwhere = @"update Sys_Department set DeptCode=@DeptCode,DeptName=@DeptName,ParentDeptId=@ParentDeptId,Remark=@Remark,TypeNum=@TypeNum,DeptGrade=@DeptGrade,OldDeptId=@OldDeptId where DepartmentId=@DepartmentId UPDATE Sys_User SET DeptCode=@DeptCode,DeptName=@DeptName WHERE DeptId=@DepartmentId "; var param = new { model.DepartmentId, model.DeptCode, model.DeptName, model.ParentDeptId, model.Remark, model.TypeNum, model.DeptGrade, model.OldDeptId }; int result = conn.Execute(sqlwhere, param); return(result > 0); } }
private void InsertUserList(List <Sys_User> listUser, ref string userTempID, ref string chongfu) { List <Sys_User> listUserSql = userBL.GetList(" Sys_User.IsDelete = 0 "); foreach (Sys_User item in listUser) { try { Sys_User model = listUserSql.Find(p => p.JobNum == item.JobNum); if (model != null) { #region 系统已存在用户,做修改操作 但是被无知的人说,这个不需要;那这个就被邪恶的我干掉了。。。不要怪我哦 //model.Realname = item.Realname; //model.Sex = item.Sex; //model.Birthday = item.Birthday; //model.Email = item.Email; //model.Telephone = item.Telephone; //model.Fax = item.Fax; //model.JobTitle = item.JobTitle; //model.Ename = item.Ename; //Sys_Department dep = AllDepartments.Find(p => p.DeptCode == item.DeptCode); //if (dep != null) //{ // item.DeptCode = dep.DeptCode; // item.DeptName = dep.DeptName; // item.DeptId = dep.DepartmentId; //} //else //{ // item.DeptCode = ""; // item.DeptName = ""; // item.DeptId = -1; //} //Sys_Post post = AllPosts.Find(p => p.PostCode == item.PostCode); //if (post != null) //{ // item.PostCode = post.PostCode; // item.PostName = post.PostName; // item.PostLevel = post.PostLevel; // item.PostId = post.PostId; //} //else //{ // item.PostLevel = null; // item.PostName = ""; // item.PostCode = ""; // item.PostId = -1; //} //model.Status = item.Status; //model.FreezeTime = null; //userBL.Update(model); #endregion if (chongfu != "") { chongfu = chongfu + "," + item.Username; } else { chongfu = item.Username; } } else { if (item.Status < 2) { Sys_Department dep = AllDepartments.Find(p => p.DeptCode == item.DeptCode); if (dep != null) { item.DeptCode = dep.DeptCode; item.DeptName = dep.DeptName; item.DeptId = dep.DepartmentId; } else { item.DeptCode = ""; item.DeptName = ""; item.DeptId = -1; } Sys_Post post = AllPosts.Find(p => p.PostCode == item.PostCode); if (post != null) { item.PostCode = post.PostCode; item.PostName = post.PostName; //item.PostLevel = post.PostLevel; item.PostId = post.PostId; } else { item.PostLevel = null; item.PostName = ""; item.PostCode = ""; item.PostId = -1; } userBL.Add(item); } } } catch { if (userTempID != "") { userTempID = userTempID + "," + item.Username; } else { userTempID = item.Username; } } } }