Esempio n. 1
0
        public List <roleSysform> getRightsByRoleId_1(int roleId)
        {
            List <roleSysform> role_sysForms = new List <roleSysform>();

            role_sysForms.Clear();
            string sql = string.Format("select role_Id,sys_form_Id,upperID from role_sys_form left join sys_form on sys_Form_Id=formid  where role_id={0} and upperID is not null", roleId);

            using (SqlConnection conn = DBHelp.getConn())
            {
                conn.Open();
                SqlCommand objCommand = new SqlCommand(sql, conn);
                using (SqlDataReader objReader = objCommand.ExecuteReader())
                {
                    while (objReader.Read())
                    {
                        roleSysform RR = new roleSysform();
                        RR.Sysform.FormID = Convert.ToInt32(objReader[1].ToString());
                        RR.Role.RID       = Convert.ToInt32(objReader[0].ToString());
                        if (objReader[2] != null)
                        {
                            RR.Sysform.UpperID = Convert.ToInt32(objReader[2].ToString());
                        }
                        role_sysForms.Add(RR);
                    }
                    objReader.Close();
                }
            }
            return(role_sysForms);
        }
Esempio n. 2
0
        public List <roleSysform> getRightsByRoleId(string roleId)
        {
            List <roleSysform> role_sysForms = new List <roleSysform>();
            // DataTable dt = DBHelp.getDataTaeble();
            Role           r     = null;
            sysFormService froms = new sysFormService();

            List <SysForm> allForms = froms.GetListArray(string.Format(" formID in (select sys_form_Id from role_sys_form where role_id in ({0}))", roleId));

            foreach (SysForm form in allForms)
            {
                roleSysform rsf = new roleSysform();
                //int sys_form_Id = Convert.ToInt32(dr["sys_form_Id"]);
                //SysForm form = new sysFormService().getFormsByFormId(sys_form_Id);
                if (form != null)
                {
                    rsf.Sysform = form;
                    rsf.Role    = r;
                    role_sysForms.Add(rsf);
                }
            }
            return(role_sysForms);
        }