Exemple #1
0
        public Department GetDepartment(int id)
        {
            string    sql = "select * from Depart where ID=" + id;
            DataTable dt  = sqlHelper.Query(sql);

            if (dt != null && dt.Rows.Count > 0)
            {
                Department dep = new Department();
                dep.ID      = id;
                dep.Name    = dt.Rows[0]["Name"].ToString();
                dep.Manager = dt.Rows[0]["Manager"].ToString();
                if (dt.Rows[0]["Parent"] != null && dt.Rows[0]["Parent"] != DBNull.Value)
                {
                    dep.ParentID = Convert.ToInt32(dt.Rows[0]["Parent"]);
                }
                if (dt.Rows[0]["Remark"] != null && dt.Rows[0]["Remark"] != DBNull.Value)
                {
                    dep.Remark = dt.Rows[0]["Remark"].ToString();
                }
                else
                {
                    dep.Remark = "";
                }
                return(dep);
            }
            return(null);
        }
Exemple #2
0
        public Permission GetPermission(int id)
        {
            string    sql = "select * from Permission where ID=" + id;
            DataTable dt  = sqlHelper.Query(sql);

            if (dt != null && dt.Rows.Count > 0)
            {
                Permission perm = new Permission();
                perm.ID        = id;
                perm.Name      = dt.Rows[0]["Name"].ToString();
                perm.IsExcept  = Convert.ToBoolean(dt.Rows[0]["IsExcept"]);
                perm.TheModule = ModuleLogic.GetInstance().GetModule(Convert.ToInt32(dt.Rows[0]["TheModule"]));
                perm.TheAction = ActionLogic.GetInstance().GetAction(Convert.ToInt32(dt.Rows[0]["TheAction"]));
                if (dt.Rows[0]["Remark"] != null && dt.Rows[0]["Remark"] != DBNull.Value)
                {
                    perm.Remark = dt.Rows[0]["Remark"].ToString();
                }
                else
                {
                    perm.Remark = "";
                }
                return(perm);
            }
            return(null);
        }
Exemple #3
0
        public UserGroup GetUserGroup(int id)
        {
            string    sql = "select * from UserGroup where ID=" + id;
            DataTable dt  = sqlHelper.Query(sql);

            if (dt != null && dt.Rows.Count > 0)
            {
                UserGroup ug = new UserGroup();
                ug.ID   = id;
                ug.Name = dt.Rows[0]["Name"].ToString();
                if (dt.Rows[0]["Remark"] != null && dt.Rows[0]["Remark"] != DBNull.Value)
                {
                    ug.Remark = dt.Rows[0]["Remark"].ToString();
                }
                else
                {
                    ug.Remark = "";
                }
                return(ug);
            }
            return(null);
        }
Exemple #4
0
        public Module GetModule(int id)
        {
            string    sql = "select * from Module where ID=" + id;
            DataTable dt  = sqlHelper.Query(sql);

            if (dt != null && dt.Rows.Count > 0)
            {
                Module module = new Module();
                module.ID   = id;
                module.Name = dt.Rows[0]["Name"].ToString();
                if (dt.Rows[0]["FormName"] != null && dt.Rows[0]["FormName"] != DBNull.Value)
                {
                    module.FormName = dt.Rows[0]["FormName"].ToString();
                }
                else
                {
                    module.FormName = "";
                }
                if (dt.Rows[0]["ControlName"] != null && dt.Rows[0]["ControlName"] != DBNull.Value)
                {
                    module.ControlName = dt.Rows[0]["ControlName"].ToString();
                }
                else
                {
                    module.ControlName = "";
                }
                if (dt.Rows[0]["Remark"] != null && dt.Rows[0]["Remark"] != DBNull.Value)
                {
                    module.Remark = dt.Rows[0]["Remark"].ToString();
                }
                else
                {
                    module.Remark = "";
                }
                return(module);
            }
            return(null);
        }
Exemple #5
0
        public Action GetAction(int id)
        {
            string    sql = "select * from [Action] where ID=" + id;
            DataTable dt  = sqlHelper.Query(sql);

            if (dt != null && dt.Rows.Count > 0)
            {
                Action action = new Action();
                action.ID   = id;
                action.Name = dt.Rows[0]["Name"].ToString();
                if (dt.Rows[0]["FormName"] != null && dt.Rows[0]["FormName"] != DBNull.Value)
                {
                    action.FormName = dt.Rows[0]["FormName"].ToString();
                }
                else
                {
                    action.FormName = "";
                }
                if (dt.Rows[0]["ControlName"] != null && dt.Rows[0]["ControlName"] != DBNull.Value)
                {
                    action.ControlName = dt.Rows[0]["ControlName"].ToString();
                }
                else
                {
                    action.ControlName = "";
                }
                if (dt.Rows[0]["Remark"] != null && dt.Rows[0]["Remark"] != DBNull.Value)
                {
                    action.Remark = dt.Rows[0]["Remark"].ToString();
                }
                else
                {
                    action.Remark = "";
                }
                return(action);
            }
            return(null);
        }
Exemple #6
0
        public Role GetRole(int id)
        {
            string    sql = "select * from [Role] where ID=" + id;
            DataTable dt  = sqlHelper.Query(sql);

            if (dt != null && dt.Rows.Count > 0)
            {
                Role role = new Role();
                role.ID          = id;
                role.Name        = dt.Rows[0]["Name"].ToString();
                role.Flag        = Convert.ToBoolean(dt.Rows[0]["Flag"]);
                role.Permissions = Common.GetPermissions(dt.Rows[0]["Permissions"].ToString());
                if (dt.Rows[0]["Remark"] != null && dt.Rows[0]["Remark"] != DBNull.Value)
                {
                    role.Remark = dt.Rows[0]["Remark"].ToString();
                }
                else
                {
                    role.Remark = "";
                }
                return(role);
            }
            return(null);
        }
Exemple #7
0
        public User GetUser(int id)
        {
            string    sql = "select * from [User] where ID=" + id;
            DataTable dt  = sqlHelper.Query(sql);

            if (dt != null && dt.Rows.Count > 0)
            {
                User user = new User();
                user.ID          = id;
                user.Username    = dt.Rows[0]["Username"].ToString();
                user.Departments = Common.GetDepartments(dt.Rows[0]["Depart"].ToString());
                user.Flag        = Convert.ToInt32(dt.Rows[0]["Flag"]);
                if (dt.Rows[0]["Password"] != null && dt.Rows[0]["Password"] != DBNull.Value)
                {
                    user.Password = dt.Rows[0]["Password"].ToString();
                }
                else
                {
                    user.Password = "";
                }
                if (dt.Rows[0]["Roles"] != null && dt.Rows[0]["Roles"] != DBNull.Value)
                {
                    user.Roles = Common.GetRoles(dt.Rows[0]["Roles"].ToString());
                }
                if (dt.Rows[0]["Usergroup"] != null && dt.Rows[0]["Usergroup"] != DBNull.Value)
                {
                    user.Usergroups = Common.GetUserGroups(dt.Rows[0]["Usergroup"].ToString());
                }
                if (dt.Rows[0]["Remark"] != null && dt.Rows[0]["Remark"] != DBNull.Value)
                {
                    user.Remark = dt.Rows[0]["Remark"].ToString();
                }
                return(user);
            }
            return(null);
        }