コード例 #1
0
        /// <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");
            }
        }
コード例 #2
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);
        }
コード例 #3
0
        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");
                    }
                }
            }
        }
コード例 #4
0
ファイル: NoticeAdd.aspx.cs プロジェクト: cuongpv88/HSCompany
        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;
            }
        }
コード例 #5
0
        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());
        }
コード例 #6
0
        /// <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);
        }
コード例 #7
0
        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);
        }
コード例 #8
0
        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);
            }
        }
コード例 #9
0
ファイル: SystemPage.cs プロジェクト: Enochs/HHLWedding
        /// <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("");
        }
コード例 #10
0
        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"));
        }
コード例 #11
0
        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"));
        }
コード例 #12
0
        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");
            }
        }
コード例 #13
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);
        }
コード例 #14
0
        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");
                }
            }
        }
コード例 #15
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);
        }
コード例 #16
0
        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());
        }
コード例 #17
0
        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);
                }
            }
        }
コード例 #18
0
        /// <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");
            }
        }
コード例 #19
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);
        }
コード例 #20
0
        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\"}");
            }
        }
コード例 #21
0
        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);
        }
コード例 #22
0
        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));
            }
        }
コード例 #23
0
ファイル: PostInfo.aspx.cs プロジェクト: cuongpv88/HSCompany
        /// <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;
                    }
                }
            }
        }
コード例 #24
0
        /// <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);
            }
        }
コード例 #25
0
        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();
        }
コード例 #26
0
        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);
        }
コード例 #27
0
        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);
        }
コード例 #28
0
 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));
         }
     }
 }
コード例 #29
0
 /// <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);
     }
 }
コード例 #30
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;
                    }
                }
            }
        }