/// <summary> /// 显示所有用列表 /// </summary> /// <returns></returns> public DataTable ListAllUsers() { string sql = "select *from SYS_USer"; return(SqlHelper_cory.ExceuteDataTable(sql, CommandType.Text)); }
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))); }