Exemplo n.º 1
0
Arquivo: LoginDA.cs Projeto: SHKCB/RF
        /// <summary>
        /// 获取用户权限
        /// </summary>
        /// <param name="sysno"></param>
        /// <param name="appid"></param>
        /// <returns></returns>
        public static DataSet GetList(int sysno, string appid)
        {
            SQLHelper sqlLocal = new Utility.SQLHelper("");

            SqlParameter[] sqlParams = new SqlParameter[2]
            {
                new SqlParameter("@USERID", sysno),
                new SqlParameter("@ApplicationID", appid)
            };

            //A.Description,A.Name AS Category,C.Name AS [Page],C.[Key]
            DataSet ds = sqlLocal.QueryTransaction("P_RIGHT", sqlParams);

            return(ds);
        }