Exemple #1
0
        public int DeleteDept(int id, string accessToken)
        {
            int        rows      = 0;
            GROUP_INFO groupInfo = _groupRepo.Get(id);

            if (groupInfo != null)
            {
                int childrenCount = _groupRepo.GetCountByParentID(id);
                if (childrenCount > 0)
                {
                    rows = -1;  //如果有子部门,不能删除
                }
                int empCount = _empRepo.GetCountByGroupID(id);
                if (empCount > 0)
                {
                    rows = -2;  //组织结构下有员工,不能删除
                }

                DeptResponse response = WXQYClientServiceApi.Create().DeleteDept(accessToken, groupInfo.WX_GROUP_ID);
                if (response != null && response.ErrorCode == 0)
                {
                    rows = _groupRepo.Delete(id);
                    if (groupInfo.TYPE == 3)
                    {
                        MDSearch storeInfo = _storeRepo.GetByGroupId(id);
                        if (storeInfo != null)
                        {
                            _storeRepo.Delete(storeInfo.ID);
                        }
                    }
                }
            }

            return(rows);
        }
Exemple #2
0
        public int ModifyEmpDept(string accessToken, int empId, int deptId, ref string errMsg)
        {
            EMPLOYEE_EX entity = _empRepo.Get(empId);

            if (entity != null)
            {
                GROUP_INFO_EX groupInfo = _groupRepo.Get(deptId);
                if (groupInfo != null)
                {
                    List <int> department = new List <int>()
                    {
                        groupInfo.WX_GROUP_ID
                    };
                    string gender   = entity.GENDER.HasValue ? entity.GENDER.Value.ToString() : null;
                    var    response = WXQYClientServiceApi.Create().UpdateUser(accessToken, entity.USERID, entity.NAME, department, entity.POSITION, entity.MOBILE, gender, entity.EMAIL, entity.WECHAT_ID);
                    if (response != null && response.ErrorCode == 0)
                    {
                        REL_EMP_GROUP rel = _empRepo.GetRelByEmpID(empId);
                        rel.GROUP_ID   = deptId;
                        rel.FullUpdate = false;

                        return(_empRepo.Update(rel));
                    }
                    else
                    {
                        errMsg = response.ErrorMessage;
                    }
                }
            }

            return(0);
        }
Exemple #3
0
        public string GetQYAccessToken()
        {
            // 读取XML文件中的数据
            string       filepath    = HttpContext.Current.Server.MapPath("~/Configs/AccessTokenData.config");
            StreamReader str         = new StreamReader(filepath, Encoding.UTF8);
            XmlDocument  xmlDocument = new XmlDocument();

            xmlDocument.Load(str);
            str.Close();
            str.Dispose();

            var      rootNode      = xmlDocument.SelectSingleNode("AccessTokenInfo");
            string   token         = rootNode.SelectSingleNode("Token").InnerText;
            DateTime AccessExpires = Convert.ToDateTime(rootNode.SelectSingleNode("Expires").InnerText);

            if (DateTime.Now >= AccessExpires)
            {
                AccessTokenResponse response = WXQYClientServiceApi.Create().GetAccessToken();
                if (response != null)
                {
                    rootNode.SelectSingleNode("Token").InnerText = response.AccessToken;
                    DateTime _accessExpires = DateTime.Now.AddSeconds(response.ExpiresIn);
                    rootNode.SelectSingleNode("Expires").InnerText = _accessExpires.ToString();
                    xmlDocument.Save(filepath);
                    token = response.AccessToken;
                }
                else
                {
                    token = "";
                    throw new Exception("获取AccessToken异常。");
                }
            }
            return(token);
        }
Exemple #4
0
        public void InitDepartments(string accessToken)
        {
            //select a.ID,a.NAME,a.PARENT_ID,a.WX_GROUP_ID,a.wx_parent_id,
            //b.ID,b.NAME, b.WX_GROUP_ID,b.wx_parent_id,
            //'update GROUP_INFO set PARENT_ID = ' + str(b.ID) + ' where ID =' + str(a.ID)
            //from GROUP_INFO a
            //left
            //join GROUP_INFO b on a.wx_parent_id = b.WX_GROUP_ID
            //where b.id is not null

            //select *,
            //'update MDSearch set group_id='+STR(g.ID) +' where id = '+str(m.ID),
            //'update group_info set code =''' + m.Code+''' where id= ' +STR(g.id)
            //from GROUP_INFO g
            //inner join MDSearch m on m.Name = g.NAME

            int rootId = AppConfig.QYDeptRootID;
            DeptListResponse response = WXQYClientServiceApi.Create().QueryDept(accessToken, rootId);

            if (response != null && response.Departments != null)
            {
                List <GROUP_INFO> groupList = new List <GROUP_INFO>();
                List <Department> children  = response.Departments.FindAll(m => m.ID != rootId);
                foreach (var item in children)
                {
                    GROUP_INFO g = new GROUP_INFO();
                    g.NAME      = item.Name;
                    g.CODE      = "";
                    g.PARENT_ID = 0;
                    if (item.ParentID == rootId)
                    {
                        g.TYPE = 1;
                    }
                    else
                    {
                        var cc = children.FindAll(m => m.ParentID == item.ID);
                        if (cc.Count > 0)
                        {
                            g.TYPE = 2;
                        }
                        else
                        {
                            g.TYPE = 3;
                        }
                    }
                    g.WX_GROUP_ID  = item.ID;
                    g.WX_PARENT_ID = item.ParentID;
                    g.WX_ORDER     = item.Order;
                    g.CREATE_TIME  = DateTime.Now;
                    g.CREATE_USER  = "******";
                    groupList.Add(g);
                }

                _storeRepo.BatchInsert(groupList);
            }
        }
Exemple #5
0
        public void SyncDeptToRemote(string accessToken)
        {
            List <GROUP_INFO> groups = this._groupRepo.GetAllByNames();

            foreach (var item in groups)
            {
                int          order    = item.WX_ORDER.HasValue ? item.WX_ORDER.Value : 1;
                DeptResponse response = WXQYClientServiceApi.Create().UpdateDept(accessToken, item.WX_GROUP_ID, item.NAME, item.WX_PARENT_ID.Value, order);
                if (response != null && response.ErrorCode == 0)
                {
                    LogService.Info(item.NAME + "-成功");
                }
                else
                {
                    LogService.Warn(item.NAME + "-失败");
                }
            }
        }
Exemple #6
0
        /// <summary>
        /// 修改组织架构
        /// </summary>
        /// <param name="accessToken"></param>
        /// <param name="deptId"></param>
        /// <param name="parentId"></param>
        /// <returns></returns>
        public int UpdateDeptOrg(string accessToken, int deptId, int parentId, ref string errMsg)
        {
            int        rows = 0, rootId = AppConfig.QYDeptRootID;
            GROUP_INFO existGroupInfo = _groupRepo.Get(deptId);

            if (existGroupInfo != null)
            {
                int wxParentId = 0;
                if (parentId == 0)
                {
                    wxParentId = rootId;
                }
                else
                {
                    GROUP_INFO parentInfo = _groupRepo.Get(parentId);
                    if (parentInfo != null)
                    {
                        wxParentId = parentInfo.WX_GROUP_ID;
                    }
                }
                DeptResponse response = WXQYClientServiceApi.Create().UpdateDept(accessToken, existGroupInfo.WX_GROUP_ID, existGroupInfo.NAME, wxParentId, existGroupInfo.WX_ORDER.Value);
                if (response != null && response.ErrorCode == 0)
                {
                    GROUP_INFO groupInfo = new GROUP_INFO();
                    groupInfo.ID               = deptId;
                    groupInfo.PARENT_ID        = parentId;
                    groupInfo.WX_PARENT_ID     = wxParentId;
                    groupInfo.LAST_MODIFY_TIME = DateTime.Now;
                    groupInfo.LAST_MODIFY_USER = "******";
                    groupInfo.FullUpdate       = false;

                    rows = (int)_groupRepo.Update(groupInfo);
                }
                else
                {
                    errMsg = response.ErrorMessage;
                }
            }


            return(rows);
        }
Exemple #7
0
        public int DeleteEmployee(string accessToken, int empId)
        {
            EMPLOYEE emp = _empRepo.Get(empId);

            if (emp != null)
            {
                var response = WXQYClientServiceApi.Create().DeleteUser(accessToken, emp.USERID);
                if (response != null && response.ErrorCode == 0)
                {
                    using (TransScope scope = new TransScope())
                    {
                        int rows = _empRepo.Delete(empId);
                        _empRepo.DeleteRelByEmpID(empId);

                        scope.Commit();

                        return(rows);
                    }
                }
            }

            return(0);
        }
Exemple #8
0
        public int SaveEmployee(string accessToken, EMPLOYEE entity, DeptInfo dept, ref string errMsg)
        {
            using (TransScope scope = new TransScope())
            {
                int        wxGroupId = 0, deptId = dept.ID;
                GROUP_INFO groupInfo = null;
                if (entity.ID > 0)
                {
                    var rel = _empRepo.GetGroupIdByEmpID(entity.ID);
                    deptId = rel;
                }
                groupInfo = _groupRepo.Get(deptId);
                if (groupInfo == null)
                {
                    return(0);
                }
                wxGroupId = groupInfo.WX_GROUP_ID;
                List <int> department = new List <int>()
                {
                    wxGroupId
                };
                string gender = entity.GENDER.HasValue ? entity.GENDER.Value.ToString() : null;

                int rows = 0;
                if (entity.ID == 0)
                {
                    var response = WXQYClientServiceApi.Create().CreateUser(accessToken, entity.USERID, entity.NAME, department, entity.POSITION, entity.MOBILE, gender, entity.EMAIL, entity.WECHAT_ID);
                    if (response != null && response.ErrorCode == 0)
                    {
                        //同步头像
                        UserInfo user = WXQYClientServiceApi.Create().GetUser(accessToken, entity.USERID);
                        if (user != null)
                        {
                            entity.AVATAR_URL = user.Avatar;
                        }
                        entity.STATUS      = 4;
                        entity.CREATE_TIME = DateTime.Now;
                        rows      = (int)_empRepo.Insert(entity);
                        entity.ID = rows;
                        //修改关系表
                        if (rows > 0)
                        {
                            //删除所有员工关系
                            _empRepo.DeleteRelByEmpID(entity.ID);
                            //新增关系
                            REL_EMP_GROUP rel = new REL_EMP_GROUP();
                            rel.TYPE        = groupInfo.TYPE;
                            rel.EMP_ID      = entity.ID;
                            rel.GROUP_ID    = deptId;
                            rel.CREATE_TIME = DateTime.Now;
                            rel.CREATE_USER = "******";
                            _empRepo.Insert(rel);
                        }
                    }
                    else
                    {
                        errMsg = response.ErrorMessage;
                    }
                }
                else
                {
                    var response = WXQYClientServiceApi.Create().UpdateUser(accessToken, entity.USERID, entity.NAME, department, entity.POSITION, entity.MOBILE, gender, entity.EMAIL, entity.WECHAT_ID);
                    if (response != null && response.ErrorCode == 0)
                    {
                        //同步头像
                        UserInfo user = WXQYClientServiceApi.Create().GetUser(accessToken, entity.USERID);
                        if (user != null)
                        {
                            entity.AVATAR_URL = user.Avatar;
                        }
                        entity.FullUpdate = false;
                        rows = _empRepo.Update(entity);
                    }
                    else
                    {
                        errMsg = response.ErrorMessage;
                    }
                }

                scope.Commit();

                return(rows);
            }
        }
Exemple #9
0
        public void SyncUsersToLocal(string accessToken)
        {
            int rootId = AppConfig.QYDeptRootID;
            UserListResponse response = WXQYClientServiceApi.Create().QueryUser(accessToken, rootId);

            if (response != null &&
                response.Users != null &&
                response.Users.Count > 0)
            {
                _empRepo.DeleteAllRel();
                var empList   = _empRepo.QueryAll();
                var groupList = _groupRepo.GetAll();
                foreach (var item in response.Users)
                {
                    EMPLOYEE emp     = empList.FirstOrDefault(m => m.USERID == item.UserId);
                    bool     existed = emp != null;
                    if (!existed)
                    {
                        emp = new EMPLOYEE();
                    }
                    emp.USERID      = item.UserId;
                    emp.NAME        = item.Name;
                    emp.MOBILE      = item.Mobile;
                    emp.EMAIL       = item.Email;
                    emp.WECHAT_ID   = item.WeiXinId;
                    emp.EMP_NO      = item.UserId;
                    emp.GENDER      = item.Gender;
                    emp.POSITION    = item.Position;
                    emp.AVATAR_URL  = item.Avatar;
                    emp.STATUS      = item.Status;
                    emp.CREATE_TIME = DateTime.Now;

                    if (existed)
                    {
                        emp.FullUpdate = false;
                        _empRepo.Update(emp);
                    }
                    else
                    {
                        emp.ID = (int)_empRepo.Insert(emp);
                    }

                    if (item.Department != null && item.Department.Length > 0)
                    {
                        var groupId = item.Department[0];

                        var groupInfo = groupList.FirstOrDefault(m => m.WX_GROUP_ID == groupId);
                        if (groupInfo != null)
                        {
                            REL_EMP_GROUP rel = new REL_EMP_GROUP();
                            rel.TYPE        = groupInfo.TYPE;
                            rel.EMP_ID      = emp.ID;
                            rel.GROUP_ID    = groupInfo.ID;
                            rel.CREATE_TIME = DateTime.Now;
                            rel.CREATE_USER = "******";
                            _empRepo.Insert(rel);
                        }
                        else
                        {
                            LogService.Debug(groupId + ",");
                        }
                    }
                    else
                    {
                        LogService.Info(item.UserId + ",");
                    }
                }
            }
        }
Exemple #10
0
        public int ModifyDept(DeptInfo deptInfo, string accessToken, ref string errMsg)
        {
            int        rows = 0, rootId = AppConfig.QYDeptRootID;
            GROUP_INFO existGroupInfo = _groupRepo.Get(deptInfo.ID);

            if (existGroupInfo != null)
            {
                int wxParentId = 0;
                if (existGroupInfo.PARENT_ID == 0)
                {
                    wxParentId = rootId;
                }
                else
                {
                    GROUP_INFO parentInfo = _groupRepo.Get(existGroupInfo.PARENT_ID);
                    if (parentInfo != null)
                    {
                        wxParentId = parentInfo.WX_GROUP_ID;
                    }
                }
                DeptResponse response = WXQYClientServiceApi.Create().UpdateDept(accessToken, existGroupInfo.WX_GROUP_ID, deptInfo.DeptName, wxParentId, deptInfo.Order);
                if (response != null && response.ErrorCode == 0)
                {
                    GROUP_INFO groupInfo = new GROUP_INFO();
                    groupInfo.ID               = deptInfo.ID;
                    groupInfo.NAME             = deptInfo.DeptName;
                    groupInfo.CODE             = deptInfo.DeptCode;
                    groupInfo.MAGENTO_GROUP_ID = deptInfo.MagentoGroupID;
                    groupInfo.WX_ORDER         = deptInfo.Order;
                    groupInfo.LAST_MODIFY_TIME = DateTime.Now;
                    groupInfo.LAST_MODIFY_USER = "******";
                    groupInfo.FullUpdate       = false;

                    rows = (int)_groupRepo.Update(groupInfo);
                    if (rows > 0 && existGroupInfo.TYPE == 3)
                    {
                        MDSearch storeInfo = _storeRepo.GetByGroupId(deptInfo.ID);
                        if (storeInfo == null)
                        {
                            storeInfo = new MDSearch();
                        }
                        storeInfo.Name          = deptInfo.DeptName;
                        storeInfo.Code          = deptInfo.DeptCode;
                        storeInfo.StoreType     = deptInfo.StoreType;
                        storeInfo.IS_PICK_UP    = deptInfo.IsPickUp;
                        storeInfo.Address       = deptInfo.Address;
                        storeInfo.Phone         = deptInfo.Telephone;
                        storeInfo.X             = deptInfo.Latitude;
                        storeInfo.Y             = deptInfo.Longitude;
                        storeInfo.BelongsAreaNo = deptInfo.BelongsAreaNo;
                        storeInfo.Province      = deptInfo.Province;
                        storeInfo.City          = deptInfo.City;
                        storeInfo.Area          = deptInfo.Area;
                        storeInfo.PP            = deptInfo.Brand;

                        if (storeInfo.ID > 0)
                        {
                            storeInfo.FullUpdate = false;
                            _storeRepo.Update(storeInfo);
                        }
                        else
                        {
                            storeInfo.GROUP_ID = deptInfo.ID;

                            _groupRepo.Insert(storeInfo);
                        }
                    }
                }
                else
                {
                    errMsg = response.ErrorMessage;
                }
            }


            return(rows);
        }
Exemple #11
0
        public int CreateDept(DeptInfo deptInfo, string accessToken, ref string errMsg)
        {
            int        groupId = 0, wxParentId = 0, rootId = AppConfig.QYDeptRootID;
            GROUP_INFO groupInfo = null;

            if (deptInfo.ParentID == 0) //创建大区
            {
                groupInfo      = new GROUP_INFO();
                groupInfo.TYPE = 1;
                wxParentId     = rootId;//根目录ID
            }
            else
            {
                GROUP_INFO parentDept = _groupRepo.Get(deptInfo.ParentID);
                if (parentDept != null)
                {
                    groupInfo  = new GROUP_INFO();
                    wxParentId = parentDept.WX_GROUP_ID;

                    if (parentDept.TYPE == 1)   //如果父级是大区,则创建区域
                    {
                        groupInfo.TYPE = 2;
                    }
                    else if (parentDept.TYPE == 2)
                    {
                        groupInfo.TYPE = 3;
                    }
                }
            }
            if (groupInfo != null)
            {
                groupInfo.NAME             = deptInfo.DeptName;
                groupInfo.CODE             = deptInfo.DeptCode;
                groupInfo.PARENT_ID        = deptInfo.ParentID;
                groupInfo.MAGENTO_GROUP_ID = deptInfo.MagentoGroupID;
                groupInfo.WX_ORDER         = deptInfo.Order;
                groupInfo.CREATE_TIME      = DateTime.Now;
                groupInfo.CREATE_USER      = "******";

                DeptResponse response = WXQYClientServiceApi.Create().CreateDept(accessToken, groupInfo.NAME, wxParentId, groupInfo.WX_ORDER.Value);
                if (response != null && response.ErrorCode == 0)
                {
                    groupInfo.WX_GROUP_ID  = response.ID;
                    groupInfo.WX_PARENT_ID = wxParentId;
                    groupId = (int)_groupRepo.Insert(groupInfo);

                    if (groupId > 0 && groupInfo.TYPE == 3)    //创建MDSearch
                    {
                        MDSearch storeInfo = new MDSearch();
                        storeInfo.Name       = deptInfo.DeptName;
                        storeInfo.Code       = deptInfo.DeptCode;
                        storeInfo.StoreType  = deptInfo.StoreType;
                        storeInfo.IS_PICK_UP = deptInfo.IsPickUp;
                        storeInfo.Address    = deptInfo.Address;
                        storeInfo.Phone      = deptInfo.Telephone;
                        storeInfo.X          = deptInfo.Latitude;
                        storeInfo.Y          = deptInfo.Longitude;

                        storeInfo.BelongsAreaNo = deptInfo.BelongsAreaNo;
                        storeInfo.Province      = deptInfo.Province;
                        storeInfo.City          = deptInfo.City;
                        storeInfo.Area          = deptInfo.Area;
                        storeInfo.PP            = deptInfo.Brand;

                        storeInfo.GROUP_ID = groupId;

                        _groupRepo.Insert(storeInfo);
                    }
                    deptInfo.Type = groupInfo.TYPE;
                }
                else
                {
                    errMsg = response.ErrorMessage;
                }
            }

            return(groupId);
        }