예제 #1
0
        /// <summary>
        /// 显示所有用列表
        /// </summary>
        /// <returns></returns>
        public DataTable ListAllUsers()
        {
            string sql = "select *from SYS_USer";

            return(SqlHelper_cory.ExceuteDataTable(sql, CommandType.Text));
        }
예제 #2
0
        public DataTable LoadNavMenu(string pid)
        {
            string sql = "select Menu_code,Menu_name,menu_unit,parent_menu_code from sys_menu where parent_menu_code=@pid";

            return(SqlHelper_cory.ExceuteDataTable(sql, CommandType.Text, new SqlParameter("@pid", pid)));
        }