Пример #1
0
        /// <summary>
        /// 登录系统
        /// </summary>
        /// <param name="loginName"></param>
        /// <param name="pwd"></param>
        /// <returns></returns>
        public Users GetLoginUser(string loginName, string pwd, string cCode)
        {
            Users  user   = new Users();
            string strSql = "select * from users a left join company b on a.cCode = b.cCode "
                            + " left join department c on  c.DeptCode = a.DeptCode "
                            + " where a.UserName = '******' and a.Password = '******' and substr(a.ccode,0,4) = '{2}'";

            strSql = string.Format(strSql, loginName, EncryptHelper.EncryptString(pwd), cCode.Substring(0, 4));
            DataTable dt = OracleHelper.ExecuteDataTable(strSql);

            if (dt.Rows.Count == 1)
            {
                user.UserId = dt.Rows[0]["UserId"].ToString();
                ////单位
                user.Company.CompanyCode = dt.Rows[0]["cCode"].ToString();
                user.Company.Name        = dt.Rows[0]["CName"].ToString();
                user.Company.CompanyType = dt.Rows[0]["cType"].ToString();
                ////部门
                user.DepartMent.DeptCode = dt.Rows[0]["DeptCode"].ToString();
                user.DepartMent.DeptName = dt.Rows[0]["DeptName"].ToString();
                BusiUserService userService = new BusiUserService();
                string[]        roleAry     = userService.GetUserRoles(dt.Rows[0]["UserId"].ToString());
                ////角色
                user.Role.RoleId   = roleAry[0];
                user.Role.RoleName = roleAry[1];
                user.Role.RoleKey  = roleAry[2];
                ////用户基本信息
                user.UserName  = dt.Rows[0]["UserName"].ToString();
                user.RealName  = dt.Rows[0]["RealName"].ToString();
                user.TelePhone = dt.Rows[0]["TelePhone"].ToString();
                user.Sex       = dt.Rows[0]["Sex"].ToString().Equals("0");
                user.State     = dt.Rows[0]["State"].ToString().Equals("0");
            }
            else
            {
                user = null;
            }
            return(user);
        }
Пример #2
0
        private void AddUserNode(TreeViewNode departmentNode, string departmentCode)
        {
            TreeViewOperation treeViewOperation = new TreeViewOperation();
            BusiUserService user = new BusiUserService();

            DataTable dtUser = user.GetUserByDeptCode(departmentCode);
            for (int j = 0; j < dtUser.Rows.Count; j++)
            {
                string provinceUserCompanyCode = dtUser.Rows[j]["CCODE"].ToString();
                string provinceUserId = dtUser.Rows[j]["USERID"].ToString();
                string provinceUserName = dtUser.Rows[j]["REALNAME"].ToString();
                TreeViewNode userNode = treeViewOperation.BuildNode(Guid.NewGuid().ToString(), provinceUserId, provinceUserName, false, false);
                userNode.ServerXzdm = CommonHelper.GetSHICode(provinceUserCompanyCode);
                treeViewOperation.AddNode(departmentNode, userNode);
            }
        }